0-MIDtotal stats
    Updated 2024-07-02

    select 'Blast' as chain
    ,sum(AMOUNT_USD) as volume
    ,avg(AMOUNT_USD) as avg
    ,count(distinct ORIGIN_FROM_ADDRESS) as swappers
    ,count(distinct TX_HASH) as swaps
    from blast.core.ez_token_transfers
    where ORIGIN_FUNCTION_SIGNATURE='0x4630a0d8'
    and ORIGIN_TO_ADDRESS='0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'
    and ORIGIN_FROM_ADDRESS=TO_ADDRESS
    group by 1


    QueryRunArchived: QueryRun has been archived