flipside

    Daily Numbers
    hessDaily Numbers
    Updated 3 days ago
    select block_timestamp::date as date,
    case when block_timestamp::date < '2024-07-01' then 'Q2-2024 (EVM Launch)'
    when block_timestamp::date < '2024-10-01' then 'Q3-2024'
    when block_timestamp::date < '2025-01-01' then 'Q4-2024' else '2025' end as quarter,
    count(DISTINCT block_number) as produced_blocks,
    count(DISTINCT tx_hash) as transactions,
    count(DISTINCT from_address) as addresses,
    transactions/addresses as avg_tx_per_user,
    sum(tx_fee) as total_fees,
    avg(tx_fee) as avg_fee,
    max(tx_fee) as max_fee,
    median(tx_fee) as median_fee,
    min(tx_fee) as min_fee,
    ROUND(AVG(transactions) OVER (ORDER BY date ROWS BETWEEN 7 PRECEDING AND CURRENT ROW)) AS avg_7_day_moving_txn_count,
    ROUND(AVG(addresses) OVER (ORDER BY date ROWS BETWEEN 7 PRECEDING AND CURRENT ROW)) AS avg_7_day_moving_address_count
    from sei.core_evm.fact_transactions
    where status = 'SUCCESS'
    and date >= '2024-04-27'
    group by 1,2

    Last run: 3 days ago
    DATE
    QUARTER
    PRODUCED_BLOCKS
    TRANSACTIONS
    ADDRESSES
    AVG_TX_PER_USER
    TOTAL_FEES
    AVG_FEE
    MAX_FEE
    MEDIAN_FEE
    MIN_FEE
    AVG_7_DAY_MOVING_TXN_COUNT
    AVG_7_DAY_MOVING_ADDRESS_COUNT
    1
    		2024-05-27 00:00:00.000Q2-2024 (EVM Launch)1414152012112.56198351.2665977770.033728024853.7980330.000064958301520121
    2
    		2024-05-28 00:00:00.000Q2-2024 (EVM Launch)6943728265711.0837143.6899795310.00050672610981.1589180.00006144104401389
    3
    		2024-05-29 00:00:00.000Q2-2024 (EVM Launch)154081622516279.9723424.0660537750.00025060423881.1590140.00006144108342802
    4
    		2024-05-30 00:00:00.000Q2-2024 (EVM Launch)4662852058161732.19418711.1300253980.00021380048022.4903890.0000890930192711006
    5
    		2024-05-31 00:00:00.000Q2-2024 (EVM Launch)130406176194232475.81497430.9565412590.00017569577433.7980330.0000890930506561269
    6
    		2024-06-01 00:00:00.000Q2-2024 (EVM Launch)163981236177269587.6352539.108025290.00016558778071.29420.0000890934.19137635e-7815761507
    7
    		2024-06-02 00:00:00.000Q2-2024 (EVM Launch)2071294127963231127.76106548.0074592040.00011629826650.0068575810.0000890930.0000211288931753
    8
    		2024-06-03 00:00:00.000Q2-2024 (EVM Launch)1894892939322110139.30426568.1205539040.00023175616783.7980330.00008301701495231798
    9
    		2024-06-04 00:00:00.000Q2-2024 (EVM Launch)1715902493682439102.24190251.9901093560.00020848749383.7980330.00008304701805042088
    10
    		2024-06-05 00:00:00.000Q2-2024 (EVM Launch)1469572004591369146.42731938.785210320.00019348201040.0089446760.0002767202046512177
    11
    		2024-06-06 00:00:00.000Q2-2024 (EVM Launch)1805932696511271212.1565745.8704513740.00017011044410.021933565590.00008315202363292132
    12
    		2024-06-07 00:00:00.000Q2-2024 (EVM Launch)1096021191551083110.02308433.9656317390.00028505418770.025940168860.00028792302447172065
    13
    		2024-06-08 00:00:00.000Q2-2024 (EVM Launch)1049861124531007111.67130132.0622492620.00028511688670.0073412880.00028792302367491901
    14
    		2024-06-09 00:00:00.000Q2-2024 (EVM Launch)276982899069441.7723347.5921179780.00026188747770.0055486470.00028792302108511651
    15
    		2024-06-10 00:00:00.000Q2-2024 (EVM Launch)131911366355124.7967333.0921535610.00022631585750.024227621850.0002422201609591316
    16
    		2024-06-11 00:00:00.000Q2-2024 (EVM Launch)2046823770152815.55628312.3228150620.00051841880783.1545570.00022417401271891243
    17
    		2024-06-12 00:00:00.000Q2-2024 (EVM Launch)2742438283350310.92863310.5751111520.00027623517362.4156720.00017128501008031376
    18
    		2024-06-13 00:00:00.000Q2-2024 (EVM Launch)239053314233209.9825310.8490373190.00032735010922.7154770.0001712850798881620
    19
    		2024-06-14 00:00:00.000Q2-2024 (EVM Launch)1349814343129111.1099922.9363383490.00020472274620.023951950.0002422140479751622
    20
    		2024-06-15 00:00:00.000Q2-2024 (EVM Launch)125981300552524.7714292.9115703540.00022388084230.012620401930.0002422320.000021347061552
    ...
    313
    42KB
    17s