Query editor
withdata_chains as(select evt_tx_hash,evt_block_time,_reward as amount,_token as tokenfrom magpie_arbitrum.vlMGPBaseRewarder_evt_RewardPaidunion allselect evt_tx_hash,evt_block_time,_reward as amount,_token as tokenfrom magpie_bnb.vlMGPBaseRewarder_evt_RewardPaidunion allselect evt_tx_hash,evt_block_time,rewardAmount as amount,rewardToken as tokenfrom magpie_arbitrum.vlStreamRewarder_evt_RewardQueuedunion allselect evt_tx_hash,evt_block_time,rewardAmount as amount,rewardToken as tokenfrom magpie_bnb.vlStreamRewarder_evt_RewardQueuedunion ALLselect evt_tx_hash,evt_block_time,rewardAmount as amount,rewardToken as tokenfrom magpie_arbitrum.vlStreamRewarder2_evt_RewardQueuedunion allselect evt_tx_hash,evt_block_time,rewardAmount as amount,rewardToken as tokenfrom magpie_bnb.vlStreamRewarder2_evt_RewardQueued),all_chains as(select evt_tx_hash,casewhen evt_block_time>= TIMESTAMP '2025-03-01 00:00:00' and evt_block_time< TIMESTAMP '2025-03-06 00:00:00' then TIMESTAMP '2025-02-25 00:00:00'else date_trunc('day',evt_block_time) end as day, amount, token from data_chainswheretoken in(0x2ac2b254bc18cd4999f64773a966e4f4869c34ee,0x7DEdBce5a2E31E4c75f87FeA60bF796C17718715,0x5012c90F14d190607662CA8344120812Aaa2639D,0xC4a65A93dD6CD9717551ebE827E8baEe025d1d7E, --pnp0x346af1954e3d6be46b96da713a1f7fd2d1928f1d,0x2B5D9ADea07B590b638FFc165792b2C610EdA649, --ckp0xa61F74247455A40b01b0559ff6274441FAfa22A3,0xd06716e1ff2e492cc5034c2e81805562dd3b45fa, --mgp0x54BDBF3cE36f451Ec61493236b8E6213ac87c0f6,0x27c073e8427aa493a90b8dC8b73A89e670FD77bB, --rdp0x7e7a7c916c19a45769f6bdaf91087f93c6c12f78, --egp arb0x0cc7288a11c0c31d39d0e05eb59f24e506ad6ad5,--egp bnb0x56fA5F7BF457454Be33D8B978C86A5f5B9DD84C2, -- ltp bnb0xa73959804651eEd0D4bd04293A675cB832c20454 -- ltp arb)),pnp as (select date_trunc('day',hour) as day,min(median_price) as price_pnp from dex.priceswhere contract_address=0x2Ac2B254Bc18cD4999f64773a966E4f4869c34Eegroup by 1),egp as ( select date_trunc('day', timestamp) as day, min(price) as price_egp from prices.daywhere contract_address=0x7e7a7c916c19a45769f6bdaf91087f93c6c12f78group by 1),