Query editor
WITH USDT_ETH AS (SELECT'ethereum' AS chain,evt_tx_hash,"from" AS sender_address,evt_block_time,CAST(value AS DOUBLE) / 1e18 AS volume_usd -- decimals=6FROM erc20_ethereum.evt_TransferWHERE contract_address = 0x6b175474e89094c44da98b954eedeac495271d0f), 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 = 0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3), USDT_POLYGON AS (SELECT'polygon' AS chain,evt_tx_hash,"from" AS sender_address,evt_block_time,CAST(value AS DOUBLE) / 1e18 AS volume_usd -- decimals=6FROM erc20_polygon.evt_TransferWHERE contract_address = 0x8f3cf7ad23cd3cadbd9735aff958023239c6a063), USDT_ARBITRUM AS (SELECT'arbitrum' AS chain,evt_tx_hash,"from" AS sender_address,evt_block_time,CAST(value AS DOUBLE) / 1e18 AS volume_usd -- decimals=6FROM erc20_arbitrum.evt_TransferWHERE contract_address = 0xda10009cbd5d07dd0cecc66161fc93d7c9000da1), USDT_AVALANCHE AS (SELECT'avalanche' AS chain,evt_tx_hash,"from" AS sender_address,evt_block_time,CAST(value AS DOUBLE) / 1e18 AS volume_usd -- decimals=6FROM erc20_avalanche_c.evt_TransferWHERE contract_address = 0xd586e7f844cea2f87f50152665bcbc2c279d8d70), USDT_GNOSIS AS (SELECT'gnosis' AS chain,evt_tx_hash,"from" AS sender_address,evt_block_time,CAST(value AS DOUBLE) / 1e18 AS volume_usd -- decimals=6FROM erc20_gnosis.evt_TransferWHERE contract_address = 0x44fa8e6f47987339850636f88629646662444217)