Query editor
with mint_actions_polygon as (selectcontract_address,sender as reserve_address,sum(amount) as amountfrom query_4049788 --ptoken_mint_burn_polygonwhere sender = 0xb265985061e60e348ce237ae2aad0c9c4785114b --Reserve addressand action = 'Mint'group by 1,2),price_polygon as (selectcontract_address,pricefrom prices.usd_latestwhere blockchain = 'polygon'),reserve_amount_polygon as (selectm.contract_address,reserve_address,amount / POW(10, decimals) as amount,(amount / POW(10, decimals)) * price as amount_usd,t.underline_asset_addressfrom mint_actions_polygon mleft join query_4049840 t --pTokens - Ethereum and Polygonon t.contract_address = m.contract_address and t.network = 'polygon'left join price_polygon pon p.contract_address = t.underline_asset_address),mint_actions_ethereum as (selectcontract_address,sender as reserve_address,sum(amount) as amountfrom query_4049790 --ptoken_mint_burn_ethereumwhere sender = 0x05ee7b3701d8c19ecfbcbdcd0a2bda8eb25790ba --Reserve addressand action = 'Mint'group by 1,2),price_ethereum as (selectcontract_address,pricefrom prices.usd_latestwhere blockchain = 'ethereum'),reserve_amount_ethereum as (selectm.contract_address,reserve_address,amount / POW(10, decimals) as amount,(amount / POW(10, decimals)) * price as amount_usd,t.underline_asset_addressfrom mint_actions_ethereum m