Select Block_timestamp, Tx_hash,

Origin_From_Address, Amount_In_USD,symbol_In,Symbol_Out,POOL_NAME,

From optimism.defi.ez_dex_swaps

Where platform ='velodrome'

Select Date_trunc('day',Block_timestamp) as date,

Count(DISTINCT Tx_hash) as Swap,

Count(Distinct Origin_From_Address) as Swappers,

Sum(Amount_In_USD) as Volume,

Avg(Amount_In_USD) as Avg_volume,

Count(DISTINCT POOL_NAME) as pool_count

From Settle

WHERE Block_timestamp >=CURRENT_DATE -interval'7days'

Group by date

Order by date DESC

Limit 40