Query editor
WITH price AS (SELECTDATE_TRUNC('week', minute) AS time,AVG(price) AS priceFROM prices.usdWHEREsymbol = 'ETH'AND contract_address IS NULLAND blockchain IS NULLGROUP BY 1ORDER BY time DESC),volume AS (SELECTDATE_TRUNC('week', block_time) AS time,COUNT(*) AS weekly_transaction_counts,SUM(value / 1e18) AS weekly_volumeFROM ethereum.transactionsGROUP BY 1)SELECTv.time,p.price,v.weekly_transaction_counts,weekly_volume * p.price AS weekly_volume_usdFROM volume vLEFT JOIN price AS pON v.time = p.timeGROUP BY 1,2,3,4ORDER BY time DESC