flipside

    Blast Users and TXs in last 24H
    ArioBlast Users and TXs in last 24H
    Updated 2024-08-06
    select
    COUNT(DISTINCT TX_HASH) AS tx_COUNT,
    COUNT(DISTINCT FROM_ADDRESS) AS User_count
    from
    blast.core.fact_transactions
    where
    1 = 1
    and STATUS = 'SUCCESS'
    and date_trunc(hour, block_timestamp) > (CURRENT_TIMESTAMP - interval '24 hours')
    QueryRunArchived: QueryRun has been archived