cryptallTOP BLAST USERS BY TXN COUNT
    Updated 2024-06-27
    select
    from_address as "User",
    count(distinct tx_hash) as "txn_count"
    -- count(distinct value) as "volume"
    from blast.core.fact_transactions
    where status='SUCCESS'
    group by 1
    order by 2 desc
    limit 10


    QueryRunArchived: QueryRun has been archived