'Sushiswap' as dex,

count (distinct t1.tx_hash) as Swaps_Count,

count (distinct origin_from_address) as Swappers_Count,

count (distinct pool_name) as Pools_Count,

sum (amount_in_usd) as Total_USD_Volume,

avg (amount_in_usd) as Average_USD_Volume,

median (amount_in_usd) Median_USD_Volume,

min (amount_in_usd) as Minimum_USD_Volume,

max (amount_in_usd) as Maximum_USD_Volume,

sum (tx_fee) as Total_Fee,

avg (Tx_fee) as Average_Fee

from optimism.sushi.ez_swaps t1 join optimism.core.fact_transactions t2 on t1.tx_hash = t2.tx_hash

and t1.block_timestamp >= CURRENT_DATE - {{since_days_ago}}

union ALL

select 'Velodrome' as dex,

count (distinct t1.tx_hash) as Swaps_Count,

count (distinct origin_from_address) as Swappers_Count,

count (distinct pool_name) as Pools_Count,

sum (amount_in_usd) as Total_USD_Volume,

avg (amount_in_usd) as Average_USD_Volume,

median (amount_in_usd) Median_USD_Volume,

min (amount_in_usd) as Minimum_USD_Volume,

max (amount_in_usd) as Maximum_USD_Volume,

sum (tx_fee) as Total_Fee,

avg (Tx_fee) as Average_Fee

from optimism.velodrome.ez_swaps t1 join optimism.core.fact_transactions t2 on t1.tx_hash = t2.tx_hash

and t1.block_timestamp >= CURRENT_DATE - {{since_days_ago}}

union ALL

select 'Uniswap' as dex,

count (distinct t1.tx_hash) as Swaps_Count,

count (distinct origin_from_address) as Swappers_Count,