Updated 2024-05-07
    select
    status,
    --trunc(block_timestamp,'hour') as hour,
    count(distinct tx_hash) as transactions,
    count(distinct from_address) as active_users,
    sum(tx_fee) as fees,
    avg(tx_fee) as avg_tx_fee
    from blast.core.fact_transactions
    --origin_function_signature
    group by 1



    QueryRunArchived: QueryRun has been archived