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 = 0xdac17f958d2ee523a2206206994597c13d831ec7), 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 = 0x55d398326f99059ff775485246999027b3197955), 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 = 0xc2132d05d31c914a87c6611c10748aeb04b58e8f), 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 = 0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9), 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 = 0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7), 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 = 0x4ecaba5870353805a9f068101a40e0f32ed605c6)