Query editor
WITH volume AS (SELECTday,blockchain,SUM(COALESCE(volume, 0)) AS volumeFROM query_4337415 AS volumeGROUP BY 1, 2)SELECTsupply.day,supply.chain,volume.volume / supply.circulating_supply AS turnover,AVG(volume.volume / supply.circulating_supply) OVER (PARTITION BY chain ORDER BY supply.day ROWS BETWEEN 29 PRECEDING AND CURRENT ROW) AS turnover_30FROM query_4257883 AS supplyLEFT JOIN volumeON supply.day = volume.dayAND supply.chain = volume.blockchain