Query editor
WITH v3_migrate AS (-- v3 migrated balance = v1_erc_out_to_JBXV3 + v1_ticket_out_to_JBXV3 + v2_ticket_out_to_JBXV3SELECT holder, SUM(amount) AS amountFROM (SELECT "from" as holder, CAST(value AS INT256)/1e18 AS amount, 'v1_erc_out' AS operation FROM juicebox_ethereum.Tickets_evt_TransferWHERE contract_address = 0x3abf2a4f8452ccc2cf7b4c1e4663147600646f66 AND to != 0x0000000000000000000000000000000000000000AND to = 0x4554CC10898f92D45378b98D6D6c2dD54c687Fb2UNION ALLSELECT holder, CAST(amount AS INT256)/1e18 AS amount, 'v1_ticket_out' AS operation FROM juicebox_ethereum.TicketBooth_evt_TransferWHERE projectId = CAST(1 AS UINT256) AND recipient = 0x4554CC10898f92D45378b98D6D6c2dD54c687Fb2UNION ALLSELECT holder, CAST(amount AS INT256)/1e18 AS amount, 'v2_ticket_out' AS operation FROM juicebox_v2_800_ethereum.JBTokenStore_evt_TransferWHERE projectId = CAST(1 AS UINT256) AND recipient = 0x4554CC10898f92D45378b98D6D6c2dD54c687Fb2) tGROUP BY holder), all_operations AS (SELECT holder, amount, operationFROM (SELECT holder, CAST(amount AS INT256)/1e18 AS amount, 'v3_mint' AS operation FROM juicebox_v3_ethereum.JBTokenStore_evt_Mint WHERE projectId = CAST(1 AS UINT256)UNION ALLSELECT recipient as holder, CAST(amount AS INT256)/1e18 AS amount, 'v3_ticket_in' AS operation FROM juicebox_v3_ethereum.JBTokenStore_evt_Transfer WHERE projectId = CAST(1 AS UINT256)UNION ALLSELECT substr(topic2, 13) as holder, CAST(bytearray_to_uint256(data) AS INT256)/1e18 as amount, 'v3_erc_in' AS operation FROM ethereum.logs WHERE contract_address = 0x4554CC10898f92D45378b98D6D6c2dD54c687Fb2 AND topic0 = 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef AND substr(topic1, 13) != 0x0000000000000000000000000000000000000000UNION ALLSELECT holder, amount, 'v3_migrate_in' AS operation FROM v3_migrateUNION ALLSELECT holder, CAST(amount AS INT256)/1e18 AS amount, 'v2_mint' AS operation FROM juicebox_v2_800_ethereum.JBTokenStore_evt_Mint WHERE projectId = CAST(1 AS UINT256)UNION ALLSELECT recipient as holder, CAST(amount AS INT256)/1e18 AS amount, 'v2_ticket_in' AS operation FROM juicebox_v2_800_ethereum.JBTokenStore_evt_Transfer WHERE projectId = CAST(1 AS UINT256)UNION ALLSELECT holder, CAST(amount AS INT256)/1e18 AS amount, 'v1_mint' AS operation FROM juicebox_ethereum.TicketBooth_evt_Print WHERE projectId = CAST(1 AS UINT256)UNION ALLSELECT recipient as holder, CAST(amount AS INT256)/1e18 AS amount, 'v1_ticket_in' AS operation FROM juicebox_ethereum.TicketBooth_evt_Transfer WHERE projectId = CAST(1 AS UINT256)UNION ALLSELECT to as holder, CAST(value AS INT256)/1e18 AS amount, 'v1_erc_in' AS operation FROM juicebox_ethereum.Tickets_evt_Transfer WHERE contract_address = 0x3abf2a4f8452ccc2cf7b4c1e4663147600646f66 AND "from" != 0x0000000000000000000000000000000000000000UNION ALLSELECT holder, -CAST(amount AS INT256)/1e18 AS amount, 'v3_burn' AS operation FROM juicebox_v3_ethereum.JBTokenStore_evt_Burn WHERE projectId = CAST(1 AS UINT256)UNION ALLSELECT holder, -CAST(amount AS INT256)/1e18 AS amount, 'v3_ticket_out' AS operation FROM juicebox_v3_ethereum.JBTokenStore_evt_Transfer WHERE projectId = CAST(1 AS UINT256)UNION ALLSELECT substr(topic1, 13) as holder, -CAST(bytearray_to_uint256(data) AS INT256)/1e18 as amount, 'v3_erc_out' AS operation FROM ethereum.logs WHERE contract_address = 0x4554CC10898f92D45378b98D6D6c2dD54c687Fb2 AND topic0 = 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef AND substr(topic2, 13) != 0x0000000000000000000000000000000000000000UNION ALLSELECT holder, -CAST(amount AS INT256)/1e18 AS amount, 'v2_burn' AS operation FROM juicebox_v2_800_ethereum.JBTokenStore_evt_Burn WHERE projectId = CAST(1 AS UINT256)UNION ALLSELECT holder, -CAST(amount AS INT256)/1e18 AS amount, 'v2_ticket_out' AS operation FROM juicebox_v2_800_ethereum.JBTokenStore_evt_Transfer WHERE projectId = CAST(1 AS UINT256)UNION ALLSELECT holder, -CAST(amount AS INT256)/1e18 AS amount, 'v1_burn' AS operation FROM juicebox_ethereum.TicketBooth_evt_Redeem WHERE projectId = CAST(1 AS UINT256)UNION ALLSELECT holder, -CAST(amount AS INT256)/1e18 AS amount, 'v1_ticket_out' AS operation FROM juicebox_ethereum.TicketBooth_evt_Transfer WHERE projectId = CAST(1 AS UINT256)UNION ALLSELECT "from" as holder, -CAST(value AS INT256)/1e18 AS amount, 'v1_erc_out' AS operation FROM juicebox_ethereum.Tickets_evt_Transfer WHERE contract_address = 0x3abf2a4f8452ccc2cf7b4c1e4663147600646f66 AND to != 0x0000000000000000000000000000000000000000) ops), operation_sums AS (SELECT holder, operation, SUM(amount) AS amountFROM all_operationsGROUP BY holder, operation), temp AS (