count(distinct tx_hash)/count(distinct trader) AS "Swap per Trader",

avg(coalesce(amount_in_usd,amount_out_usd)) as "Avg",

median(coalesce(amount_in_usd,amount_out_usd)) as "Median",

max(coalesce(amount_in_usd,amount_out_usd)) as "Max",

count(distinct trader) as "Trader Count",

sum(coalesce(amount_in_usd,amount_out_usd)) as "Swap Volume"

FROM near.defi.ez_dex_swaps

WHERE (symbol_in in ('DAI', 'FRAX', 'FUSD', 'USDC', 'USDC.e', 'USDT.e', 'USDt', 'USN', 'cUSD', 'sFRAX')

or symbol_out in ('DAI', 'FRAX', 'FUSD', 'USDC', 'USDC.e', 'USDT.e', 'USDt', 'USN', 'cUSD', 'sFRAX'))

and block_timestamp::date between '{{Start_Date}}' and '{{End_Date}}'