Query editor
with eth_price as (select pricefrom(selectprice,ROW_NUMBER() OVER (PARTITION BY contract_address ORDER BY minute DESC) AS indexfrom prices.usdwhere symbol = 'ETH') tmpwhere index = 1), BTC_PRICE as (select pricefrom(selectprice,ROW_NUMBER() OVER (PARTITION BY contract_address ORDER BY minute DESC) AS indexfrom prices.usd--where symbol = 'ETH'where symbol = 'BTC') tmpwhere index = 1), ETH AS (SELECT'ETH' AS token,evt_block_time AS time,to AS address,amount,amount * (select avg(price) from eth_price) / 1000000000000000000.0 AS value_in_usdFROMmanta_bridge_ethereum.L1StandardBridge_evt_ETHDepositInitiatedWHEREevt_block_number > 10095729),ETH_SUM AS (SELECT SUM(amount) / 1000000000000000000.0 AS AMOUNT_SUM FROM ETH),ETH_SUM_USD AS (SELECT SUM(value_in_usd) AS AMOUNT_SUM FROM ETH),ERC20 AS (SELECT * FROM manta_bridge_ethereum.L1StandardBridge_evt_ERC20DepositInitiated WHERE evt_block_number > 10095729),USDT AS (SELECT'USDT' AS token,evt_block_time AS time,to AS address,amount,amount / 1000000.0 AS value_in_usdFROM ERC20WHEREl1Token = 0xdAC17F958D2ee523a2206206994597C13D831ec7),USDT_SUM_USD AS (SELECT SUM(value_in_usd) AS AMOUNT_SUM FROM USDT),USDC AS (SELECT'USDC' AS token,evt_block_time AS time,to AS address,amount,amount / 1000000.0 AS value_in_usdFROM ERC20WHEREl1Token = 0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48),USDC_SUM_USD AS (SELECT SUM(value_in_usd) AS AMOUNT_SUM FROM USDC),