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'90 days'
group by blocktime