select block_timestamp::date as day,

count(DISTINCT TX_hash) as swaps,

count(DISTINCT ORIGIN_FROM_ADDRESS) as swappers,

count(DISTINCT pool_name) as pool_count,

count(DISTINCT token_in) as sold_tokens,

count(DISTINCT token_out) as purchase_tokens,

sum(AMOUNT_OUT_USD) as vol,

avg(AMOUNT_OUT_USD) as Avg_vol

from polygon.defi.ez_dex_swaps

where BLOCK_TIMESTAMP>=current_date-60 and platform='quickswap-v3'

group by 1