Query editor
-- SELECT DATE_TRUNC ('day', block_time) 'day',-- COUNT (DISTINCT hash)-- FROM ethereum.transactions-- WHERE DATE_TRUNC ('day', block_time) > TRY_CAST('2023-12-31' AS TIMESTAMP)-- AND DATE_TRUNC ('day', block_time) < CURRENT_DATESELECTDATE_TRUNC ('week', block_time) "week",SUM (amount_usd) AS volume_usd,COUNT (DISTINCT tx_hash) weekly_transactionsFROM dex.tradesWHERE blockchain = 'ethereum'AND DATE_TRUNC ('week', block_time) > TRY_CAST('2023-12-31' AS TIMESTAMP)AND DATE_TRUNC ('week', block_time) < CURRENT_DATEGROUP BY 1ORDER BY DATE_TRUNC ('week', block_time) DESC