select
block_timestamp::date "Date",
count (distinct (tx_hash)) "Swaps Count",
count (distinct (recipient)) "Swappers Count",
sum(abs(amount0_usd)) "Volume (USD)",
avg(abs(amount0_usd)) "Average Volume (USD)",
median(abs(amount0_usd)) "Median Amount (USD)",
sum("Swaps Count") over (order by "Date" asc) as "Comulative Swaps Count",
sum("Swappers Count") over (order by "Date" asc) as "Comulative Swappers Count",
sum("Volume (USD)") over (order by "Date" asc) as "Comulative Volume (USD)"
from ethereum.uniswapv3.ez_swaps
where 1 = 1
and block_timestamp >= current_date - interval '2 weeks'
and token0_symbol in ('USDT', 'USDC', 'DAI', 'BUSD')
group by 1
order by 1