Query editor
WITH daily AS (SELECTdate_trunc('day', t.block_time) AS day,SUM(t.amount) AS token_volume,SUM(t.amount * p.price) AS usd_volume,COUNT(*) AS txn_countFROM tokens.transfers tLEFT JOIN prices.day pON p.contract_address = t.contract_addressAND p.blockchain = t.blockchainAND p.timestamp = date_trunc('day', t.block_time)WHERE t.contract_address IN (0x14862c03a0caccc1ab328b062e64e31b2a1afcd7,0x306acd0c07c430abbbb2e74ef7bde94f32a898c0)AND t.blockchain IN ('ethereum', 'base')GROUP BY 1)SELECTday,token_volume,usd_volume,txn_count,AVG(usd_volume) OVER (ORDER BY day ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS usd_volume_cumulative_ma,AVG(token_volume) OVER (ORDER BY day ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS token_volume_cumulative_maFROM dailyORDER BY day DESC