Query editor
SELECTdate_trunc('day', evt_block_time) AS day,count(DISTINCT "from") AS DAA,count(evt_tx_hash) AS transfer_count,AVG(count(evt_tx_hash)) OVER (ORDER BY date_trunc('day', evt_block_time)ROWS BETWEEN 30 PRECEDING AND CURRENT ROW) AS thirty_day_moving_averageFROM evms.erc20_transfersWHEREblockchain = 'ethereum'AND contract_address = 0x18084fbA666a33d37592fA2633fD49a74DD93a88GROUP BY 1ORDER BY 1;