afonsoswap from aETHc
    Updated 2023-01-13
    select date_trunc('week', block_timestamp::date) as week,
    count (distinct tx_hash) as swaps_count,
    count (distinct origin_from_address) as swappers_count,
    sum (amount_in_usd) as volume_usd,
    sum(swaps_count) over (order by week asc) as cumulative_swaps_count,
    sum(swappers_count) over (order by week asc) as cumulative_swappers_count,
    sum(volume_usd) over (order by week asc) as cumulative_volume_usd
    from ethereum.core.ez_dex_swaps
    where token_in = '0xe95a203b1a91a908f9b9ce46459d101078c2c3cb' --aETHc
    group by week
    having volume_usd > 0
    order by 1 asc
    Run a query to Download Data