Query editor
withpools as (selectname,quote_symbol,pool_addressfromajna.erc20_pools),interest_rate as (selectcontract_address,evt_block_time,cast(newRate as decimal (38, 0))/1e18 as ratefromajna_arbitrum.ERC20Pool_evt_UpdateInterestRateunion allselectcontract_address,evt_block_time,cast(newRate as decimal (38, 0))/1e18 as ratefromajna_ethereum.ERC20Pool_evt_UpdateInterestRateunion allselectcontract_address,evt_block_time,cast(newRate as decimal (38, 0))/1e18 as ratefromajna_optimism.ERC20Pool_evt_UpdateInterestRateunion allselectcontract_address,evt_block_time,cast(newRate as decimal (38, 0))/1e18 as ratefromajna_polygon.ERC20Pool_evt_UpdateInterestRateunion allselectcontract_address,evt_block_time,cast(newRate as decimal (38, 0))/1e18 as ratefromajna_base.ERC20Pool_evt_UpdateInterestRate)selectevt_block_time,rate,name,quote_symbol,pool_addressfrominterest_ratejoinpools on contract_address = pool_addresswhereevt_block_time > timestamp '2024-01-01'order by evt_block_time desc