Query editor
WITH usde_inflow1 AS(SELECT DATE_TRUNC('day', evt_block_time) AS date,SUM(cast("value"/1e18 AS DOUBLE)) AS usde_inflow1FROM erc20_ethereum.evt_TransferWHERE "contract_address" = 0x4c9edd5852cd905f086c759e8383e09bff1e68b3AND "to" = 0x02950460e2b9529d0e00284a5fa2d7bdf3fa4d72AND "evt_block_time" >= CAST('2023-11-20' AS TIMESTAMP)GROUP BY 1),usde_outflow1 AS(SELECT DATE_TRUNC('day', evt_block_time) AS date,-SUM(cast("value"/1e18 AS DOUBLE)) AS usde_outflow1FROM erc20_ethereum.evt_TransferWHERE "contract_address" = 0x4c9edd5852cd905f086c759e8383e09bff1e68b3AND "from" = 0x02950460e2b9529d0e00284a5fa2d7bdf3fa4d72AND "evt_block_time" >= CAST('2023-11-20' AS TIMESTAMP)GROUP BY 1),usdc_inflow AS(SELECT DATE_TRUNC('day', evt_block_time) AS date,SUM(cast("value"/1e6 AS DOUBLE)) AS usdc_inflowFROM erc20_ethereum.evt_TransferWHERE "contract_address" = 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48AND "to" = 0x02950460e2b9529d0e00284a5fa2d7bdf3fa4d72AND "evt_block_time" >= CAST('2023-11-20' AS TIMESTAMP)GROUP BY 1),usdc_outflow AS (SELECT DATE_TRUNC('day', evt_block_time) AS date,-SUM(cast("value" /1e6 AS DOUBLE)) AS usdc_outflowFROM erc20_ethereum.evt_TransferWHERE "contract_address" = 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48AND "from" = 0x02950460e2b9529d0e00284a5fa2d7bdf3fa4d72AND "evt_block_time" >= CAST('2023-11-20' AS TIMESTAMP)GROUP BY 1),usde_inflow2 AS(SELECT DATE_TRUNC('day', evt_block_time) AS date,SUM(cast("value"/1e18 AS DOUBLE)) AS usde_inflow2FROM erc20_ethereum.evt_TransferWHERE "contract_address" = 0x4c9edd5852cd905f086c759e8383e09bff1e68b3AND "to" = 0xf55b0f6f2da5ffddb104b58a60f2862745960442AND "evt_block_time" >= CAST('2023-11-20' AS TIMESTAMP)GROUP BY 1),usde_outflow2 AS(SELECT DATE_TRUNC('day', evt_block_time) AS date,-SUM(cast("value"/1e18 AS DOUBLE)) AS usde_outflow2FROM erc20_ethereum.evt_TransferWHERE "contract_address" = 0x4c9edd5852cd905f086c759e8383e09bff1e68b3AND "from" = 0xf55b0f6f2da5ffddb104b58a60f2862745960442AND "evt_block_time" >= CAST('2023-11-20' AS TIMESTAMP)GROUP BY 1),crvusd_inflow AS(SELECT DATE_TRUNC('day', evt_block_time) AS date,SUM(cast("value"/1e18 AS DOUBLE)) AS crvusd_inflowFROM erc20_ethereum.evt_TransferWHERE "contract_address" = 0xf939e0a03fb07f59a73314e73794be0e57ac1b4eAND "to" = 0xf55b0f6f2da5ffddb104b58a60f2862745960442