adriaparcerisas2024-03-01 09:38 AM
    Updated 2024-05-04
    select
    --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
    where status='SUCCESS'
    --origin_function_signature
    --status
    QueryRunArchived: QueryRun has been archived