flipside

    burning-azure
    nguyentra93burning-azure
    Updated 2025-05-29
    /* ─── Daily core-metrics, labelled by token symbol ─────────────── */
    WITH core_hourly AS (

    /* ---------- EVM chains ---------- */
    SELECT 'ETH' AS token, Block_timestamp_hour,
    total_fees_usd, total_fees_native,
    block_count, transaction_count, transaction_count_success
    FROM ethereum.stats.ez_core_metrics_hourly

    UNION ALL
    SELECT 'MATIC', Block_timestamp_hour,
    total_fees_usd, total_fees_native,
    block_count, transaction_count, transaction_count_success
    FROM polygon.stats.ez_core_metrics_hourly

    UNION ALL
    SELECT 'BNB', Block_timestamp_hour,
    total_fees_usd, total_fees_native,
    block_count, transaction_count, transaction_count_success
    FROM bsc.stats.ez_core_metrics_hourly

    UNION ALL
    /* Base uses ETH for gas; keep distinct to avoid collapsing with mainnet ETH */
    SELECT 'ETH_BASE', Block_timestamp_hour,
    total_fees_usd, total_fees_native,
    block_count, transaction_count, transaction_count_success
    FROM base.stats.ez_core_metrics_hourly

    UNION ALL
    SELECT 'AVAX', Block_timestamp_hour,
    total_fees_usd, total_fees_native,
    block_count, transaction_count, transaction_count_success
    FROM avalanche.stats.ez_core_metrics_hourly

    UNION ALL
    SELECT 'ARB', Block_timestamp_hour,
    Last run: about 2 months ago
    DATE
    CHAIN
    FEES_USD
    FEES_NATIVE
    BLOCK_COUNT
    TX_COUNT
    TX_SUCCESS
    1
    		1970-01-01 00:00:00.000APT0111
    2
    		2010-07-17 00:00:00.000BTC00.01132626
    3
    		2010-07-18 00:00:00.000BTC0.030.28259999
    4
    		2010-07-19 00:00:00.000BTC00.0446151151
    5
    		2010-07-20 00:00:00.000BTC0068166166
    6
    		2010-07-21 00:00:00.000BTC0052128128
    7
    		2010-07-22 00:00:00.000BTC0067151151
    8
    		2010-07-23 00:00:00.000BTC00.01116273273
    9
    		2010-07-24 00:00:00.000BTC0062125125
    10
    		2010-07-25 00:00:00.000BTC00.04326161
    11
    		2010-07-26 00:00:00.000BTC0.071.2758103103
    12
    		2010-07-27 00:00:00.000BTC0.010.12185454
    13
    		2010-07-28 00:00:00.000BTC00.0152528528
    14
    		2010-07-29 00:00:00.000BTC007110351035
    15
    		2010-07-30 00:00:00.000BTC00.0968132132
    16
    		2010-07-31 00:00:00.000BTC00.0877110110
    17
    		2010-08-01 00:00:00.000BTC00.0489132132
    18
    		2010-08-02 00:00:00.000BTC00.02539191
    19
    		2010-08-03 00:00:00.000BTC00123332332
    20
    		2010-08-04 00:00:00.000BTC00528181
    ...
    29963
    2MB
    25s