Query editor
1SELECT date_trunc('day', block_time) as day 2 ,sum(amount_usd) as usd 3 FROM opensea.trades a 4 WHERE blockchain = 'polygon' 5 GROUP BY 1 6 ORDER BY 1
SELECT date_trunc('day', block_time) as day
,sum(amount_usd) as usd
FROM opensea.trades a
WHERE blockchain = 'polygon'
GROUP BY 1
ORDER BY 1