Query editor
WITH daily_volume AS (SELECTDATE_TRUNC('day', evt_block_time) AS day,SUM(TRY_CAST(value AS DOUBLE))/1e18 AS transaction_volumeFROM erc20_ethereum.evt_TransferWHERE contract_address = 0xcf0c122c6b73ff809c693db761e7baebe62b6a2eAND evt_block_time >= CURRENT_DATE - INTERVAL '30' DAYGROUP BY 1ORDER BY day),monthly_volume AS (SELECTDATE_TRUNC('month', evt_block_time) AS month,SUM(TRY_CAST(value AS DOUBLE))/1e18 AS transaction_volume,COUNT(DISTINCT DATE_TRUNC('day', evt_block_time)) AS active_daysFROM erc20_ethereum.evt_TransferWHERE contract_address = 0xcf0c122c6b73ff809c693db761e7baebe62b6a2eAND evt_block_time >= CURRENT_DATE - INTERVAL '12' MONTHGROUP BY 1ORDER BY month),quarterly_volume AS (SELECTDATE_TRUNC('quarter', evt_block_time) AS quarter,SUM(TRY_CAST(value AS DOUBLE))/1e18 AS transaction_volume,COUNT(DISTINCT DATE_TRUNC('month', evt_block_time)) AS active_monthsFROM erc20_ethereum.evt_TransferWHERE contract_address = 0xcf0c122c6b73ff809c693db761e7baebe62b6a2eGROUP BY 1ORDER BY quarter),daily_ma AS (SELECTday,transaction_volume,AVG(transaction_volume) OVER (ORDER BY dayROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS seven_day_maFROM daily_volume)-- select time periodSELECT * FROM quarterly_volume-- SELECT * FROM monthly_volume-- SELECT * FROM daily_volume-- SELECT * FROM daily_ma