afonsoUntitled Query
    Updated 2023-01-14
    select
    date_trunc('week', block_timestamp) 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_out = '0xe95a203b1a91a908f9b9ce46459d101078c2c3cb' --aETHc
    group by 1
    order by 1 asc
    Run a query to Download Data