Query editor
with transactions_polygon as (selectto as address,evt_tx_hash,evt_block_time,t.value / POW(10, d.decimals) as value,t.contract_addressfrom erc20_polygon.evt_transfer tinner join query_3232731 d --asset_addresseson d.address = t.contract_addresswhere "to" = 0x02bcaA4633E466d151b34112608f60A82a4F6035union allselect"from" as address,evt_tx_hash,evt_block_time,0 - t.value / POW(10, d.decimals) as value,t.contract_addressfrom erc20_polygon.evt_transfer tinner join query_3232731 d --asset_addresseson d.address = t.contract_addresswhere "from" = 0x02bcaA4633E466d151b34112608f60A82a4F6035),balance_polygon as (selectaddress,evt_tx_hash,evt_block_time,sum(value) over (partition by address, contract_address order by evt_block_time) as value,contract_address,row_number() over (partition by address, contract_address order by evt_block_time desc) as rnfrom transactions_polygon --where contract_address = 0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270order by evt_block_time),polygon_tvl as (selectaddress,b.contract_address,evt_block_time,value,value * coalesce(p.price, d.median_price) as value_usdfrom balance_polygon bleft join prices.usd_latest pon p.contract_address = b.contract_address and p.blockchain = 'polygon'left join (select * from (select *, row_number() over (partition by blockchain, contract_address order by hour desc) as rn from dex.prices) where rn = 1) don d.contract_address = b.contract_address and d.blockchain = 'polygon'where b.rn = 1),------------transactions_ethereum as (selectto as address,evt_tx_hash,evt_block_time,