Query editor
WITH whale_daily AS (SELECTblock_date AS day,COUNT(*) AS large_transfer_countFROM tokens.transfersWHERE contract_address = 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2AND blockchain = 'ethereum'AND block_date >= CURRENT_DATE - INTERVAL '90' DAYAND amount > 100GROUP BY 1),dex_daily AS (SELECTblock_date AS day,ROUND(SUM(amount_usd), 0) AS dex_volume_usdFROM dex.tradesWHERE (token_bought_address = 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2OR token_sold_address = 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2)AND blockchain = 'ethereum'AND block_month >= DATE_TRUNC('month', CURRENT_DATE - INTERVAL '90' DAY)AND block_date >= CURRENT_DATE - INTERVAL '90' DAYGROUP BY 1)SELECTCOALESCE(w.day, d.day) AS day,COALESCE(w.large_transfer_count, 0) AS large_whale_transfers,COALESCE(d.dex_volume_usd, 0) AS dex_volume_usdFROM whale_daily wFULL OUTER JOIN dex_daily d ON w.day = d.dayORDER BY 1