bergStablecoins Swap numbers on Uniswap at 2 weeks ago
    Updated 2022-12-08
    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
    Run a query to Download Data