Query editor
-- how to find daily volume of Carbon_defi the last 30 dayselectdate (block_time) as trade_date,SUM (amount_usd) as daily_volume_usdfrom dex.tradeswhere project= 'carbon_defi'and blockchain ='sei'and block_time >= current_date - interval '30' daygroup by date (block_time)order by trade_date asc