trunc(block_timestamp,'week') as date,

'Near' as chain,

COUNT(*) AS n_swaps,

COUNT(distinct trader) AS unique_swapper,

COUNT(distinct TOKEN_IN_CONTRACT) AS unique_tokens,

SUM(COALESCE(amount_in_usd, amount_out_usd)) AS ttl_volume,

AVG(COALESCE(amount_in_usd, amount_out_usd)) AS Avg_volume,

ttl_volume/unique_swapper AS Avg_vol_per_trader,

sum(n_swaps) over (order by date) as total_n_swaps,

sum(ttl_volume) over (order by date) as total_ttl_volume

FROM near.defi.ez_dex_swaps

WHERE COALESCE(AMOUNT_IN_USD,AMOUNT_OUT_USD) < 1E6

AND date >= '2024-01-01'

GROUP by 1,2

UNION All

trunc(block_timestamp,'week') as date,

'Aptos' as chain,

COUNT(*) AS n_swaps,

COUNT(distinct SWAPPER) AS unique_swapper,

COUNT(distinct TOKEN_IN) AS unique_tokens,

SUM(COALESCE(AMOUNT_IN_USD,AMOUNT_OUT_USD)) AS ttl_volume,

AVG(COALESCE(AMOUNT_IN_USD,AMOUNT_OUT_USD)) AS Avg_volume,

ttl_volume/unique_swapper AS Avg_vol_per_trader,

sum(n_swaps) over (order by date) as total_n_swaps,

sum(ttl_volume) over (order by date) as total_ttl_volume

FROM aptos.defi.ez_dex_swaps

WHERE COALESCE(AMOUNT_IN_USD,AMOUNT_OUT_USD) < 1E6

AND date >= '2024-01-01'

GROUP by 1,2

ORDER by 1 DESC