Query editor
WITH token_price_mapping AS (SELECT0x9e20461bc2c4c980f62f1b279d71734207a6a356 as wrapped_token, -- OMNINULL as original_token,0.00005068 as fixed_price, -- Fixed OMNI price18 as decimals,'OMNI' as symbolUNION ALLSELECT0xb5b1b659da79a2507c27aad509f15b4874edc0cc, -- DUSTNULL,0.15,18,'DUST'UNION ALLSELECT0x70bef3bb2f001da2fddb207dae696cd9faff3f5d, -- NSTNULL,8.17,18,'NST'UNION ALLSELECT0xb8a914a00664e9361eae187468eff94905dfbc15, -- DRIPNULL,0.17,18,'DRIP'),ethereum_tab AS (-- Tx Type: TransferSELECTtx.block_time,tx.hash as tx_hash,tx."from",'ethereum' AS origin_chain,wc.chain as recipient_chain,'ethereum' || '->' || wc.chain AS pair_chain,wh.token AS token_address,COALESCE(prices.symbol, erc20.symbol, tpm.symbol, 'Unknown') AS token_symbol,COALESCE(wh.amount / POWER(10, prices.decimals),wh.amount / POWER(10, erc20.decimals),wh.amount / POWER(10, tpm.decimals)) AS token_amount,COALESCE(wh.amount / POWER(10, prices.decimals) * prices.price,wh.amount / POWER(10, erc20.decimals) * dex_prices.median_daily_price,wh.amount / POWER(10, tpm.decimals) * tpm.fixed_price) AS amount_usdFROM wormhole_ethereum.TokenBridge_call_transferTokens AS whINNER JOIN dune.hashed_official.result_wormhole_chain_id AS wcON wh.recipientChain = wc.chainIdLEFT JOIN ethereum.transactions txON tx.hash = call_tx_hashLEFT JOIN prices.usd AS pricesON wh.token = prices.contract_addressAND DATE_TRUNC('minute',tx.block_time) = DATE_TRUNC('minute',prices.minute)