Query editor
SELECT CASE WHEN '{{Aggregation}}'='Hours' THEN date_trunc('day', block_time)WHEN '{{Aggregation}}'='Days' THEN date_trunc('day', block_time) END AS "Date",COUNT(distinct users) AS "Users"FROM (SELECT block_time,buyer AS usersFROM nft.tradesWHERE platform = 'OpenSea'AND block_number > 13975855UNION ALLSELECT block_time,seller AS usersFROM nft.tradesWHERE platform = 'OpenSea'AND block_number > 13975855) lr_txsGROUP BY 1