hbd1994Top Tokens | Swap To
    Updated 2023-08-29
    select
    coalesce(SYMBOL_OUT,TOKEN_OUT) as "Token",
    TOKEN_OUT as "Token Address",
    count(distinct tx_hash) as "Swap Transactions",
    count(*) as "Swaps",
    count(distinct ORIGIN_FROM_ADDRESS) as "Swappers",
    sum(AMOUNT_OUT) as "Token Volume",
    sum(AMOUNT_OUT_USD) as "USD Volume"
    from base.defi.ez_dex_swaps
    where block_timestamp >= '{{Start_Date}}'
    and block_timestamp <= '{{End_Date}}'
    group by 1,2
    order by 3 desc
    Run a query to Download Data