Query editor
WITH prices2 AS (SELECTprice,contract_address AS token_address,timestamp AS block_timeFROM prices.day),token_data as (select contract_address, decimalsfrom tokens.erc20),names as(select distinct _market, symbol, chain from(select _market, symbol,'arb' as chain from penpie_arbitrum.PendleStakingSideChain_call_registerPoolunion allselect _market, symbol,'bnb' as chain from penpie_bnb.PendleStakingSideChain_call_registerPoolunion allselect _market, symbol,'opt' as chain from penpie_optimism.PendleStakingSideChain_call_registerPoolunion allselect _market, symbol,'eth' as chain from penpie_ethereum.PendleStaking_call_registerPool)),bribes AS (WITH all_chains AS (SELECT a.evt_block_time, a.evt_tx_hash, a._pid, _amount AS amount, _epoch,CASEWHEN _bribeToken = 0x0000000000000000000000000000000000000001 THEN 0x82af49447d8a07e3bd95bd0d56f35241523fbab1WHEN _bribeToken = 0x3caae25ee616f2c8e13c74da0813402eae3f496b THEN 0x3d9907F9a368ad0a51Be60f7Da3b97cf940982D8ELSE _bribeTokenEND AS token, marketFROM penpie_arbitrum.PenpieBribeManager_evt_NewBribe AS aLEFT JOIN penpie_arbitrum.PendleVoteManagerSideChain_evt_AddPool AS b ON a._pid = b._pidUNION ALLSELECT a.evt_block_time, a.evt_tx_hash, a._pid, _amount AS amount, _epoch, _bribeToken AS token, marketFROM penpie_bnb.PenpieBribeManager_evt_NewBribe AS aLEFT JOIN penpie_bnb.PendleVoteManagerSideChain_evt_AddPool AS b ON a._pid = b._pidUNION ALLSELECT a.evt_block_time, a.evt_tx_hash, a._pid, _amount AS amount, _epoch,CASEWHEN _bribeToken = 0x0000000000000000000000000000000000000001 THEN 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2WHEN _bribeToken = 0x643C4E15d7d62Ad0aBeC4a9BD4b001aA3Ef52d66 THEN 0x80ac24aa929eaf5013f6436cda2a7ba190f5cc0bELSE _bribeTokenEND AS token, marketFROM penpie_ethereum.PenpieBribeManager_evt_NewBribe AS aLEFT JOIN penpie_ethereum.pendlevotemanagermainchain_evt_addpool AS b ON a._pid = b._pidUNION ALLSELECT a.evt_block_time, a.evt_tx_hash, a._pid, _amount AS amount, _epoch,CASEWHEN _bribeToken = 0x0000000000000000000000000000000000000001 THEN 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2ELSE _bribeTokenEND AS token, marketFROM penpie_optimism.PenpieBribeManager_evt_NewBribe AS a