Hossein2023-07-10 09:33 AM
    Updated 2023-07-10
    select
    date_trunc('week', block_timestamp)::date as week,
    count(distinct tx_hash) as swaps,
    count(distinct sender) as swappers,
    sum(amount_in_usd) as volume_usd,
    avg(amount_in_usd) as average_volume_usd,
    sum(swaps) over (order by week) as cumulative_swaps,
    sum(volume_usd) over (order by week) as cumulative_volume_usd
    from avalanche.core.ez_dex_swaps
    where '0xa25eaf2906fa1a3a13edac9b9657108af7b703e3' in (token_in, token_out)
    and amount_in_usd > 0
    group by 1
    order by 1
    Run a query to Download Data