Query editor
WITHairdrop_balance AS (SELECTDATE_TRUNC('day', evt_block_time) AS date,SUM("value" / CAST(1e18 AS DOUBLE)) AS airdrop_balanceFROMerc20_ethereum.evt_TransferWHERE"contract_address" = 0xcAfE001067cDEF266AfB7Eb5A286dCFD277f3dE5AND "to" = 0x090E53c44E8a9b6B1bcA800e881455b921AEC420AND "evt_block_time" >= CAST('2021-11-01' AS TIMESTAMP)GROUP BY1UNIONSELECTDATE_TRUNC('day', evt_block_time) AS date,- SUM("value" / CAST(1e18 AS DOUBLE)) AS airdrop_balanceFROMerc20_ethereum.evt_TransferWHERE"contract_address" = 0xcAfE001067cDEF266AfB7Eb5A286dCFD277f3dE5AND "from" = 0x090E53c44E8a9b6B1bcA800e881455b921AEC420AND "evt_block_time" >= CAST('2021-11-01' AS TIMESTAMP)GROUP BY1),dao_y1 AS (SELECTDATE_TRUNC('day', evt_block_time) AS date,SUM("value" / CAST(1e18 AS DOUBLE)) AS dao_y1FROMerc20_ethereum.evt_TransferWHERE"contract_address" = 0xcAfE001067cDEF266AfB7Eb5A286dCFD277f3dE5AND "to" = 0x6a3CCa09b1C2B83834124c8646a68b9Bad2a07b9AND "evt_block_time" >= CAST('2021-11-01' AS TIMESTAMP)GROUP BY1UNIONSELECTDATE_TRUNC('day', evt_block_time) AS date,- SUM("value" / CAST(1e18 AS DOUBLE)) AS dao_y1FROMerc20_ethereum.evt_TransferWHERE"contract_address" = 0xcAfE001067cDEF266AfB7Eb5A286dCFD277f3dE5AND "from" = 0x6a3CCa09b1C2B83834124c8646a68b9Bad2a07b9AND "evt_block_time" >= CAST('2021-11-01' AS TIMESTAMP)GROUP BY1),txs AS (SELECTDATE_TRUNC('day', evt_block_time) AS date,SUM("value" / CAST(1e18 AS DOUBLE)) AS txsFROMerc20_ethereum.evt_TransferWHERE"contract_address" = 0xcAfE001067cDEF266AfB7Eb5A286dCFD277f3dE5GROUP BY