afonsoswap from aETHb
    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 = '0xd01ef7c0a5d8c432fc2d1a85c66cf2327362e5c6' --aETHb
    group by week
    having volume_usd > 0
    order by 1 asc
    Run a query to Download Data