Query editor
SELECTdate_trunc('{{Select Date Granularity}}', CAST(block_time AS TIMESTAMP)) AS date_,blockchain,COUNT(DISTINCT tx_hash) AS sales,ROUND(SUM(amount_usd), 4) AS volume_usd,COUNT(DISTINCT seller) AS sellers,COUNT(DISTINCT buyer) AS buyersFROMnft.tradesWHERECAST(block_time AS TIMESTAMP) >= NOW() - interval '{{Select Timeframe}}' day-- AND CAST(block_time AS TIMESTAMP) < date_trunc('{{Select Date Granularity}}', NOW())AND project = 'opensea'and trade_type = 'secondary'GROUP BY1, 2