Query editor
WITHusdt_inflow AS (SELECTDATE_TRUNC('day', evt_block_time) AS date,SUM(cast("value"/1e6 AS DOUBLE)) AS usdt_inflowFROMerc20_ethereum.evt_TransferWHERE"contract_address" = 0xdAC17F958D2ee523a2206206994597C13D831ec7AND "to" = 0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7AND "evt_block_time" >= CAST('2020-09-06' AS TIMESTAMP)GROUP BY1),usdt_outflow AS (SELECTDATE_TRUNC('day', evt_block_time) AS date,- SUM(cast("value"/1e6 AS DOUBLE)) AS usdt_outflowFROMerc20_ethereum.evt_TransferWHERE"contract_address" = 0xdAC17F958D2ee523a2206206994597C13D831ec7AND "from" = 0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7AND "evt_block_time" >= CAST('2020-09-06' AS TIMESTAMP)GROUP BY1),dai_inflow AS (SELECTDATE_TRUNC('day', evt_block_time) AS date,SUM(cast("value"/1e18 AS DOUBLE)) AS dai_inflowFROMerc20_ethereum.evt_TransferWHERE"contract_address" = 0x6B175474E89094C44Da98b954EedeAC495271d0FAND "to" = 0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7AND "evt_block_time" >= CAST('2020-09-06' AS TIMESTAMP)GROUP BY1),dai_outflow AS (SELECTDATE_TRUNC('day', evt_block_time) AS date,- SUM(cast("value" /1e18 AS DOUBLE)) AS dai_outflowFROMerc20_ethereum.evt_TransferWHERE"contract_address" = 0x6B175474E89094C44Da98b954EedeAC495271d0FAND "from" = 0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7AND "evt_block_time" >= CAST('2020-09-06' AS TIMESTAMP)GROUP BY1),usdc_inflow AS (SELECTDATE_TRUNC('day', evt_block_time) AS date,SUM(cast("value"/1e6 AS DOUBLE)) AS usdc_inflowFROMerc20_ethereum.evt_TransferWHERE