Query editor
1Select2Project,3Sum (amount_usd) as total_volume4From dex.trades5Where block_time >= current_date - interval '30'day6And blockchain = 'sei'7Group by project8Order by total_volume desc
Select
Project,
Sum (amount_usd) as total_volume
From dex.trades
Where block_time >= current_date - interval '30'day
And blockchain = 'sei'
Group by project
Order by total_volume desc