Query editor
WITH sunpump_data AS (SELECTDATE_TRUNC('day', block_time) AS period,COUNT(*) AS txsFROM tron.logsWHEREcontract_address = 0xc22dd1b7bc7574e94563c8282f64b065bc07b2faAND topic0 = 0x1ff0a01c8968e3551472812164f233abb579247de887db8cbb18281c149bee7aGROUP BY1ORDER BY1 DESC), pumpfun_data AS (SELECTDATE_TRUNC('day', block_time) AS period,COUNT(*) AS daily_txsFROM solana.account_activityWHEREaddress = 'TSLvdd1pWpHVjahSpsvCXUbgwsL3JAcvokwaKt1eokM' AND tx_successGROUP BY1ORDER BY1 DESC)SELECTCOALESCE(t.period, s.period) AS period,COALESCE(t.txs, 0) AS tron_txs,COALESCE(s.daily_txs, 0) AS solana_txsFROM sunpump_data AS tFULL OUTER JOIN pumpfun_data AS sON t.period = s.periodORDER BYperiod DESC;