Query editor
WITH USDT_ETH AS (SELECT'ethereum' AS chain,evt_tx_hash,"from" AS sender_address,evt_block_time,CAST(value AS DOUBLE) / 1e6 AS volume_usd -- decimals=6FROM erc20_ethereum.evt_TransferWHERE contract_address = 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48), USDT_BSC AS (SELECT'bsc' AS chain,evt_tx_hash,"from" AS sender_address,evt_block_time,CAST(value AS DOUBLE) / 1e18 AS volume_usdFROM erc20_bnb.evt_TransferWHERE contract_address = 0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d), USDT_POLYGON AS (SELECT'polygon' AS chain,evt_tx_hash,"from" AS sender_address,evt_block_time,CAST(value AS DOUBLE) / 1e6 AS volume_usd -- decimals=6FROM erc20_polygon.evt_TransferWHERE contract_address = 0x2791bca1f2de4661ed88a30c99a7a9449aa84174), USDT_ARBITRUM AS (SELECT'arbitrum' AS chain,evt_tx_hash,"from" AS sender_address,evt_block_time,CAST(value AS DOUBLE) / 1e6 AS volume_usd -- decimals=6FROM erc20_arbitrum.evt_TransferWHERE contract_address = 0xaf88d065e77c8cc2239327c5edb3a432268e5831), USDT_AVALANCHE AS (SELECT'avalanche' AS chain,evt_tx_hash,"from" AS sender_address,evt_block_time,CAST(value AS DOUBLE) / 1e6 AS volume_usd -- decimals=6FROM erc20_avalanche_c.evt_TransferWHERE contract_address = 0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e), USDT_GNOSIS AS (SELECT'gnosis' AS chain,evt_tx_hash,"from" AS sender_address,evt_block_time,CAST(value AS DOUBLE) / 1e6 AS volume_usd -- decimals=6FROM erc20_gnosis.evt_TransferWHERE contract_address = 0xddafbb505ad214d7b80b1f830fccc89b60fb7a83)