Query editor
with transaction_opensea as(selectDATE_TRUNC('day', block_time) as "date",sum(amount_usd) as "usd"from opensea.tradesgroup by DATE_TRUNC('day', block_time))select*from transaction_openseawhere "date" >= date '2023-07-01'and "date" < date '2023-08-01'order by "date" asclimit 100