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 tleft join query_3232731 d --asset_addresseson d.address = t.contract_addresswhere "to" = 0x0801896C67CF024606BcC92bd788d6Eb077CC74Fand (d.address is not null)-- or t.contract_address = 0x0d505c03d30e65f6e9b4ef88855a47a89e4b7676)union 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 tleft join query_3232731 d --asset_addresseson d.address = t.contract_addresswhere "from" = 0x0801896C67CF024606BcC92bd788d6Eb077CC74Fand (d.address is not null)-- or t.contract_address = 0x561877b6b3dd7651313794e5f2894b2f18be0766)),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,