crosschain.chain_stats Table: ez_optimism_protocol_metrics Type: View
What
Daily aggregated protocol-level metrics for Optimism blockchain including user activity, transaction counts, and token flow data. Combines protocol interaction data with Flipside scoring to distinguish between total activity and quality user activity (Flipside score >= 4). Metrics track inflows, outflows, and user engagement at the protocol level.Columns
| Column Name | Data Type | Description |
|---|---|---|
| DAY_ | DATE | DAY_ column |
| PROTOCOL | TEXT | PROTOCOL column |
| N_USERS | NUMBER | N_USERS column |
| N_QUALITY_USERS | NUMBER | N_QUALITY_USERS column |
| N_TRANSACTIONS | NUMBER | N_TRANSACTIONS column |
| N_QUALITY_TRANSACTIONS | NUMBER | N_QUALITY_TRANSACTIONS column |
| USD_INFLOWS | FLOAT | USD_INFLOWS column |
| USD_OUTFLOWS | FLOAT | USD_OUTFLOWS column |
| NET_USD_INFLOW | FLOAT | NET_USD_INFLOW column |
| GROSS_USD_VOLUME | FLOAT | GROSS_USD_VOLUME column |
| QUALITY_USD_INFLOWS | FLOAT | QUALITY_USD_INFLOWS column |
| QUALITY_USD_OUTFLOWS | FLOAT | QUALITY_USD_OUTFLOWS column |
| QUALITY_NET_USD | FLOAT | QUALITY_NET_USD column |
| QUALITY_GROSS_USD | FLOAT | QUALITY_GROSS_USD column |