MLDZMNxdai14
    Updated 2023-03-06
    select
    concat(SYMBOL_in,'->',SYMBOL_out) as swap_pair,
    count(distinct tx_hash) as swaps,
    count(distinct ORIGIN_FROM_ADDRESS) as swappers,
    sum( AMOUNT_OUT_USD ) swap_usd
    from
    ethereum.core.ez_dex_swaps
    where
    (TOKEN_IN ilike '0x6B175474E89094C44Da98b954EedeAC495271d0F'
    or
    TOKEN_OUT ilike '0x6B175474E89094C44Da98b954EedeAC495271d0F')
    and BLOCK_TIMESTAMP>=CURRENT_DATE- {{Time_period_days}}
    group by 1 having swap_usd is not null
    order by 4 desc limit 10
    Run a query to Download Data