Query editor
WITH market_capitalisation AS (SELECTDate AS day,Total_Value_Locked,AVG(Total_Value_Locked) OVER (ORDER BY DATEROWS BETWEEN 30 PRECEDING AND CURRENT ROW) AS d90_MA_mcapFROM query_3090233),volume AS (SELECT day, volume_transfers_usdFROM query_3113249)SELECTm.day,m.Total_Value_Locked AS Market_Capitalisation,v.volume_transfers_usd AS Volume,m.d90_MA_mcap AS d90_MA_mcap,v.volume_transfers_usd/m.Total_Value_Locked AS Volume_to_Market_Capitalisation,v.volume_transfers_usd/ m.d90_MA_mcap AS token_velocityFROM market_capitalisation mLEFT JOIN volume v ON m.day = v.day;