Query editor
with polygon_deposits as (select a.*,value / POW(10,a.decimals) as deposited_volume,value / POW(10,a.decimals) * price as deposited_volume_usdfrom (selecta.block_time,tx_hash,a.contract_address as pool,tx_from as lender,varbinary_to_uint256(varbinary_ltrim(data)) as value,b.decimals,b.underline_asset_addressfrom polygon.logs a,query_4049840 AS b -- polygon and ethereum pTokenswhere topic0 = 0x5548c837ab068cf56a2c2479df0882a4922fd203edb7517321831d95078c5f62and a.contract_address = b.pool and b.network = 'polygon') aleft join prices.usd pon p.contract_address = a.underline_asset_addressand date_trunc('minute', p.minute) = date_trunc('minute', a.block_time)and p.blockchain = 'polygon'),ethereum_deposits as (select a.*,value / POW(10,a.decimals) as deposited_volume,value / POW(10,a.decimals) * price as deposited_volume_usdfrom (selecta.block_time,tx_hash,a.contract_address as pool,tx_from as lender,varbinary_to_uint256(varbinary_ltrim(data)) as value,b.decimals,b.underline_asset_addressfrom ethereum.logs a,query_4049840 AS b --polygon and ethereum pTokenswhere topic0 = 0x5548c837ab068cf56a2c2479df0882a4922fd203edb7517321831d95078c5f62and a.contract_address = b.pool and b.network = 'ethereum') aleft join prices.usd pon p.contract_address = a.underline_asset_addressand date_trunc('minute', p.minute) = date_trunc('minute', a.block_time)and p.blockchain = 'ethereum'),arbitrum_deposits as (select a.*,value / POW(10,a.decimals) as deposited_volume,value / POW(10,a.decimals) * price as deposited_volume_usdfrom (selecta.block_time,tx_hash,a.contract_address as pool,tx_from as lender,varbinary_to_uint256(varbinary_ltrim(data)) as value,