Query editor
WITH daily_volume AS (SELECTDATE_TRUNC('day', evt_block_time) AS date,COUNT(*) AS daily_tx_count,COUNT(DISTINCT "from") AS unique_senders,COUNT(DISTINCT "to") AS unique_receivers,SUM(TRY_CAST(value AS DECIMAL(38, 0))) / 1e18 AS volumeFROM erc20_ethereum.evt_TransferWHEREcontract_address = FROM_HEX('cf0c122c6b73ff809c693db761e7baebe62b6a2e')AND evt_block_time >= CURRENT_TIMESTAMP - INTERVAL '30' dayGROUP BYDATE_TRUNC('day', evt_block_time))SELECTdate,daily_tx_count,unique_senders,unique_receivers,ROUND(volume, 2) AS daily_volume,ROUND(AVG(volume) OVER (ORDER BY date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW), 2) AS seven_day_avg_volumeFROM daily_volumeORDER BYdate DESC