select
date_trunc('day', block_timestamp) as blocktime,
count(token_0_amount_usd) as number_of_swaps,
count(distinct trader) as number_of_traders,
sum(token_0_amount_usd) as volume
from
terra.swaps
where
blocktime > getdate() - interval'150 days'
group by
blocktime