SELECT SUM(newBalance) AS totalVotableSuplly , MAX(BLOCK_TIMESTAMP) AS snapShotTime , 'After' AS boa FROM ( SELECT (to_number(SUBSTRING(DATA, 99, 32), 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'))/POW(10, 18) AS newBalance , ROW_NUMBER() OVER (PARTITION BY TOPICS[1] ORDER BY BLOCK_NUMBER DESC) AS rowNumber , BLOCK_TIMESTAMP FROM optimism.core.fact_event_logs WHERE TOPICS[0] = '0xdec2bacdd2f05b59de34da9b523dff8be42e5e38e818c82fdb0bae774387a724' --DelegateVotesChanged AND CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042' AND BLOCK_TIMESTAMP < '2023-02-23 14:11'::TIMESTAMP + INTERVAL '13 day' ) WHERE rowNumber = 1 UNION SELECT SUM(newBalance) AS totalVotableSuplly , MAX(BLOCK_TIMESTAMP) AS snapShotTime , 'After' AS boa FROM ( SELECT (to_number(SUBSTRING(DATA, 99, 32), 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'))/POW(10, 18) AS newBalance , ROW_NUMBER() OVER (PARTITION BY TOPICS[1] ORDER BY BLOCK_NUMBER DESC) AS rowNumber , BLOCK_TIMESTAMP FROM optimism.core.fact_event_logs WHERE TOPICS[0] = '0xdec2bacdd2f05b59de34da9b523dff8be42e5e38e818c82fdb0bae774387a724' --DelegateVotesChanged AND CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042' AND BLOCK_TIMESTAMP < '2023-02-23 14:11'::TIMESTAMP + INTERVAL '12 day' ) WHERE rowNumber = 1 UNION SELECT SUM(newBalance) AS totalVotableSuplly , MAX(BLOCK_TIMESTAMP) AS snapShotTime , 'After' AS boa FROM ( SELECT (to_number(SUBSTRING(DATA, 99, 32), 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'))/POW(10, 18) AS newBalance , ROW_NUMBER() OVER (PARTITION BY TOPICS[1] ORDER BY BLOCK_NUMBER DESC) AS rowNumber , BLOCK_TIMESTAMP FROM optimism.core.fact_event_logs WHERE TOPICS[0] = '0xdec2bacdd2f05b59de34da9b523dff8be42e5e38e818c82fdb0bae774387a724' --DelegateVotesChanged AND CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042' AND BLOCK_TIMESTAMP < '2023-02-23 14:11'::TIMESTAMP + INTERVAL '11 day' ) WHERE rowNumber = 1 UNION SELECT SUM(newBalance) AS totalVotableSuplly , MAX(BLOCK_TIMESTAMP) AS snapShotTime , 'After' AS boa FROM ( SELECT (to_number(SUBSTRING(DATA, 99, 32), 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'))/POW(10, 18) AS newBalance , ROW_NUMBER() OVER (PARTITION BY TOPICS[1] ORDER BY BLOCK_NUMBER DESC) AS rowNumber , BLOCK_TIMESTAMP FROM optimism.core.fact_event_logs WHERE TOPICS[0] = '0xdec2bacdd2f05b59de34da9b523dff8be42e5e38e818c82fdb0bae774387a724' --DelegateVotesChanged AND CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042' AND BLOCK_TIMESTAMP < '2023-02-23 14:11'::TIMESTAMP + INTERVAL '10 day' ) WHERE rowNumber = 1 UNION SELECT SUM(newBalance) AS totalVotableSuplly , MAX(BLOCK_TIMESTAMP) AS snapShotTime , 'After' AS boa FROM ( SELECT (to_number(SUBSTRING(DATA, 99, 32), 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'))/POW(10, 18) AS newBalance , ROW_NUMBER() OVER (PARTITION BY TOPICS[1] ORDER BY BLOCK_NUMBER DESC) AS rowNumber , BLOCK_TIMESTAMP FROM optimism.core.fact_event_logs WHERE TOPICS[0] = '0xdec2bacdd2f05b59de34da9b523dff8be42e5e38e818c82fdb0bae774387a724' --DelegateVotesChanged AND CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042' AND BLOCK_TIMESTAMP < '2023-02-23 14:11'::TIMESTAMP + INTERVAL '9 day' ) WHERE rowNumber = 1 UNION SELECT SUM(newBalance) AS totalVotableSuplly , MAX(BLOCK_TIMESTAMP) AS snapShotTime , 'After' AS boa FROM ( SELECT (to_number(SUBSTRING(DATA, 99, 32), 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'))/POW(10, 18) AS newBalance , ROW_NUMBER() OVER (PARTITION BY TOPICS[1] ORDER BY BLOCK_NUMBER DESC) AS rowNumber , BLOCK_TIMESTAMP FROM optimism.core.fact_event_logs WHERE TOPICS[0] = '0xdec2bacdd2f05b59de34da9b523dff8be42e5e38e818c82fdb0bae774387a724' --DelegateVotesChanged AND CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042' AND BLOCK_TIMESTAMP < '2023-02-23 14:11'::TIMESTAMP + INTERVAL '8 day' ) WHERE rowNumber = 1 UNION SELECT SUM(newBalance) AS totalVotableSuplly , MAX(BLOCK_TIMESTAMP) AS snapShotTime , 'After' AS boa FROM ( SELECT (to_number(SUBSTRING(DATA, 99, 32), 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'))/POW(10, 18) AS newBalance , ROW_NUMBER() OVER (PARTITION BY TOPICS[1] ORDER BY BLOCK_NUMBER DESC) AS rowNumber , BLOCK_TIMESTAMP FROM optimism.core.fact_event_logs WHERE TOPICS[0] = '0xdec2bacdd2f05b59de34da9b523dff8be42e5e38e818c82fdb0bae774387a724' --DelegateVotesChanged AND CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042' AND BLOCK_TIMESTAMP < '2023-02-23 14:11'::TIMESTAMP + INTERVAL '7 day' ) WHERE rowNumber = 1 UNION SELECT SUM(newBalance) AS totalVotableSuplly , MAX(BLOCK_TIMESTAMP) AS snapShotTime , 'After' AS boa FROM ( SELECT (to_number(SUBSTRING(DATA, 99, 32), 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'))/POW(10, 18) AS newBalance , ROW_NUMBER() OVER (PARTITION BY TOPICS[1] ORDER BY BLOCK_NUMBER DESC) AS rowNumber , BLOCK_TIMESTAMP FROM optimism.core.fact_event_logs WHERE TOPICS[0] = '0xdec2bacdd2f05b59de34da9b523dff8be42e5e38e818c82fdb0bae774387a724' --DelegateVotesChanged AND CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042' AND BLOCK_TIMESTAMP < '2023-02-23 14:11'::TIMESTAMP + INTERVAL '6 day' ) WHERE rowNumber = 1 UNION SELECT SUM(newBalance) AS totalVotableSuplly , MAX(BLOCK_TIMESTAMP) AS snapShotTime , 'After' AS boa FROM ( SELECT (to_number(SUBSTRING(DATA, 99, 32), 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'))/POW(10, 18) AS newBalance , ROW_NUMBER() OVER (PARTITION BY TOPICS[1] ORDER BY BLOCK_NUMBER DESC) AS rowNumber , BLOCK_TIMESTAMP FROM optimism.core.fact_event_logs WHERE TOPICS[0] = '0xdec2bacdd2f05b59de34da9b523dff8be42e5e38e818c82fdb0bae774387a724' --DelegateVotesChanged AND CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042' AND BLOCK_TIMESTAMP < '2023-02-23 14:11'::TIMESTAMP + INTERVAL '5 day' ) WHERE rowNumber = 1 UNION SELECT SUM(newBalance) AS totalVotableSuplly , MAX(BLOCK_TIMESTAMP) AS snapShotTime , 'After' AS boa FROM ( SELECT (to_number(SUBSTRING(DATA, 99, 32), 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'))/POW(10, 18) AS newBalance , ROW_NUMBER() OVER (PARTITION BY TOPICS[1] ORDER BY BLOCK_NUMBER DESC) AS rowNumber , BLOCK_TIMESTAMP FROM optimism.core.fact_event_logs WHERE TOPICS[0] = '0xdec2bacdd2f05b59de34da9b523dff8be42e5e38e818c82fdb0bae774387a724' --DelegateVotesChanged AND CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042' AND BLOCK_TIMESTAMP < '2023-02-23 14:11'::TIMESTAMP + INTERVAL '4 day' ) WHERE rowNumber = 1 UNION SELECT SUM(newBalance) AS totalVotableSuplly , MAX(BLOCK_TIMESTAMP) AS snapShotTime , 'After' AS boa FROM ( SELECT (to_number(SUBSTRING(DATA, 99, 32), 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'))/POW(10, 18) AS newBalance , ROW_NUMBER() OVER (PARTITION BY TOPICS[1] ORDER BY BLOCK_NUMBER DESC) AS rowNumber , BLOCK_TIMESTAMP FROM optimism.core.fact_event_logs WHERE TOPICS[0] = '0xdec2bacdd2f05b59de34da9b523dff8be42e5e38e818c82fdb0bae774387a724' --DelegateVotesChanged AND CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042' AND BLOCK_TIMESTAMP < '2023-02-23 14:11'::TIMESTAMP + INTERVAL '3 day' ) WHERE rowNumber = 1 UNION SELECT SUM(newBalance) AS totalVotableSuplly , MAX(BLOCK_TIMESTAMP) AS snapShotTime , 'After' AS boa FROM ( SELECT (to_number(SUBSTRING(DATA, 99, 32), 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'))/POW(10, 18) AS newBalance , ROW_NUMBER() OVER (PARTITION BY TOPICS[1] ORDER BY BLOCK_NUMBER DESC) AS rowNumber , BLOCK_TIMESTAMP FROM optimism.core.fact_event_logs WHERE TOPICS[0] = '0xdec2bacdd2f05b59de34da9b523dff8be42e5e38e818c82fdb0bae774387a724' --DelegateVotesChanged AND CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042' AND BLOCK_TIMESTAMP < '2023-02-23 14:11'::TIMESTAMP + INTERVAL '2 day' ) WHERE rowNumber = 1 UNION SELECT SUM(newBalance) AS totalVotableSuplly , MAX(BLOCK_TIMESTAMP) AS snapShotTime , 'After' AS boa FROM ( SELECT (to_number(SUBSTRING(DATA, 99, 32), 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'))/POW(10, 18) AS newBalance , ROW_NUMBER() OVER (PARTITION BY TOPICS[1] ORDER BY BLOCK_NUMBER DESC) AS rowNumber , BLOCK_TIMESTAMP FROM optimism.core.fact_event_logs WHERE TOPICS[0] = '0xdec2bacdd2f05b59de34da9b523dff8be42e5e38e818c82fdb0bae774387a724' --DelegateVotesChanged AND CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042' AND BLOCK_TIMESTAMP < '2023-02-23 14:11'::TIMESTAMP + INTERVAL '1 day' ) WHERE rowNumber = 1 UNION SELECT SUM(newBalance) AS totalVotableSuplly , MAX(BLOCK_TIMESTAMP) AS snapShotTime , 'Before' AS boa FROM ( SELECT (to_number(SUBSTRING(DATA, 99, 32), 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'))/POW(10, 18) AS newBalance , ROW_NUMBER() OVER (PARTITION BY TOPICS[1] ORDER BY BLOCK_NUMBER DESC) AS rowNumber , BLOCK_TIMESTAMP FROM optimism.core.fact_event_logs WHERE TOPICS[0] = '0xdec2bacdd2f05b59de34da9b523dff8be42e5e38e818c82fdb0bae774387a724' --DelegateVotesChanged AND CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042' AND BLOCK_TIMESTAMP < '2023-02-23 14:11'::TIMESTAMP ) WHERE rowNumber = 1 UNION SELECT SUM(newBalance) AS totalVotableSuplly , MAX(BLOCK_TIMESTAMP) AS snapShotTime , 'Before' AS boa FROM ( SELECT (to_number(SUBSTRING(DATA, 99, 32), 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'))/POW(10, 18) AS newBalance , ROW_NUMBER() OVER (PARTITION BY TOPICS[1] ORDER BY BLOCK_NUMBER DESC) AS rowNumber , BLOCK_TIMESTAMP FROM optimism.core.fact_event_logs WHERE TOPICS[0] = '0xdec2bacdd2f05b59de34da9b523dff8be42e5e38e818c82fdb0bae774387a724' --DelegateVotesChanged AND CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042' AND BLOCK_TIMESTAMP < '2023-02-23 14:11'::TIMESTAMP - INTERVAL '1 day' ) WHERE rowNumber = 1 UNION SELECT SUM(newBalance) AS totalVotableSuplly , MAX(BLOCK_TIMESTAMP) AS snapShotTime , 'Before' AS boa FROM ( SELECT (to_number(SUBSTRING(DATA, 99, 32), 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'))/POW(10, 18) AS newBalance , ROW_NUMBER() OVER (PARTITION BY TOPICS[1] ORDER BY BLOCK_NUMBER DESC) AS rowNumber , BLOCK_TIMESTAMP FROM optimism.core.fact_event_logs WHERE TOPICS[0] = '0xdec2bacdd2f05b59de34da9b523dff8be42e5e38e818c82fdb0bae774387a724' --DelegateVotesChanged AND CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042' AND BLOCK_TIMESTAMP < '2023-02-23 14:11'::TIMESTAMP - INTERVAL '2 day' ) WHERE rowNumber = 1 UNION SELECT SUM(newBalance) AS totalVotableSuplly , MAX(BLOCK_TIMESTAMP) AS snapShotTime , 'Before' AS boa FROM ( SELECT (to_number(SUBSTRING(DATA, 99, 32), 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'))/POW(10, 18) AS newBalance , ROW_NUMBER() OVER (PARTITION BY TOPICS[1] ORDER BY BLOCK_NUMBER DESC) AS rowNumber , BLOCK_TIMESTAMP FROM optimism.core.fact_event_logs WHERE TOPICS[0] = '0xdec2bacdd2f05b59de34da9b523dff8be42e5e38e818c82fdb0bae774387a724' --DelegateVotesChanged AND CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042' AND BLOCK_TIMESTAMP < '2023-02-23 14:11'::TIMESTAMP - INTERVAL '3 day' ) WHERE rowNumber = 1 UNION SELECT SUM(newBalance) AS totalVotableSuplly , MAX(BLOCK_TIMESTAMP) AS snapShotTime , 'Before' AS boa FROM ( SELECT (to_number(SUBSTRING(DATA, 99, 32), 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'))/POW(10, 18) AS newBalance , ROW_NUMBER() OVER (PARTITION BY TOPICS[1] ORDER BY BLOCK_NUMBER DESC) AS rowNumber , BLOCK_TIMESTAMP FROM optimism.core.fact_event_logs WHERE TOPICS[0] = '0xdec2bacdd2f05b59de34da9b523dff8be42e5e38e818c82fdb0bae774387a724' --DelegateVotesChanged AND CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042' AND BLOCK_TIMESTAMP < '2023-02-23 14:11'::TIMESTAMP - INTERVAL '4 day' ) WHERE rowNumber = 1 UNION SELECT SUM(newBalance) AS totalVotableSuplly , MAX(BLOCK_TIMESTAMP) AS snapShotTime , 'Before' AS boa FROM ( SELECT (to_number(SUBSTRING(DATA, 99, 32), 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'))/POW(10, 18) AS newBalance , ROW_NUMBER() OVER (PARTITION BY TOPICS[1] ORDER BY BLOCK_NUMBER DESC) AS rowNumber , BLOCK_TIMESTAMP FROM optimism.core.fact_event_logs WHERE TOPICS[0] = '0xdec2bacdd2f05b59de34da9b523dff8be42e5e38e818c82fdb0bae774387a724' --DelegateVotesChanged AND CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042' AND BLOCK_TIMESTAMP < '2023-02-23 14:11'::TIMESTAMP - INTERVAL '5 day' ) WHERE rowNumber = 1 UNION SELECT SUM(newBalance) AS totalVotableSuplly , MAX(BLOCK_TIMESTAMP) AS snapShotTime , 'Before' AS boa FROM ( SELECT (to_number(SUBSTRING(DATA, 99, 32), 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'))/POW(10, 18) AS newBalance , ROW_NUMBER() OVER (PARTITION BY TOPICS[1] ORDER BY BLOCK_NUMBER DESC) AS rowNumber , BLOCK_TIMESTAMP FROM optimism.core.fact_event_logs WHERE TOPICS[0] = '0xdec2bacdd2f05b59de34da9b523dff8be42e5e38e818c82fdb0bae774387a724' --DelegateVotesChanged AND CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042' AND BLOCK_TIMESTAMP < '2023-02-23 14:11'::TIMESTAMP - INTERVAL '6 day' ) WHERE rowNumber = 1 UNION SELECT SUM(newBalance) AS totalVotableSuplly , MAX(BLOCK_TIMESTAMP) AS snapShotTime , 'Before' AS boa FROM ( SELECT (to_number(SUBSTRING(DATA, 99, 32), 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'))/POW(10, 18) AS newBalance , ROW_NUMBER() OVER (PARTITION BY TOPICS[1] ORDER BY BLOCK_NUMBER DESC) AS rowNumber , BLOCK_TIMESTAMP FROM optimism.core.fact_event_logs WHERE TOPICS[0] = '0xdec2bacdd2f05b59de34da9b523dff8be42e5e38e818c82fdb0bae774387a724' --DelegateVotesChanged AND CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042' AND BLOCK_TIMESTAMP < '2023-02-23 14:11'::TIMESTAMP - INTERVAL '7 day' ) WHERE rowNumber = 1 UNION SELECT SUM(newBalance) AS totalVotableSuplly , MAX(BLOCK_TIMESTAMP) AS snapShotTime , 'Before' AS boa FROM ( SELECT (to_number(SUBSTRING(DATA, 99, 32), 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'))/POW(10, 18) AS newBalance , ROW_NUMBER() OVER (PARTITION BY TOPICS[1] ORDER BY BLOCK_NUMBER DESC) AS rowNumber , BLOCK_TIMESTAMP FROM optimism.core.fact_event_logs WHERE TOPICS[0] = '0xdec2bacdd2f05b59de34da9b523dff8be42e5e38e818c82fdb0bae774387a724' --DelegateVotesChanged AND CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042' AND BLOCK_TIMESTAMP < '2023-02-23 14:11'::TIMESTAMP - INTERVAL '8 day' ) WHERE rowNumber = 1 UNION SELECT SUM(newBalance) AS totalVotableSuplly , MAX(BLOCK_TIMESTAMP) AS snapShotTime , 'Before' AS boa FROM ( SELECT (to_number(SUBSTRING(DATA, 99, 32), 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'))/POW(10, 18) AS newBalance , ROW_NUMBER() OVER (PARTITION BY TOPICS[1] ORDER BY BLOCK_NUMBER DESC) AS rowNumber , BLOCK_TIMESTAMP FROM optimism.core.fact_event_logs WHERE TOPICS[0] = '0xdec2bacdd2f05b59de34da9b523dff8be42e5e38e818c82fdb0bae774387a724' --DelegateVotesChanged AND CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042' AND BLOCK_TIMESTAMP < '2023-02-23 14:11'::TIMESTAMP - INTERVAL '9 day' ) WHERE rowNumber = 1 UNION SELECT SUM(newBalance) AS totalVotableSuplly , MAX(BLOCK_TIMESTAMP) AS snapShotTime , 'Before' AS boa FROM ( SELECT (to_number(SUBSTRING(DATA, 99, 32), 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'))/POW(10, 18) AS newBalance , ROW_NUMBER() OVER (PARTITION BY TOPICS[1] ORDER BY BLOCK_NUMBER DESC) AS rowNumber , BLOCK_TIMESTAMP FROM optimism.core.fact_event_logs WHERE TOPICS[0] = '0xdec2bacdd2f05b59de34da9b523dff8be42e5e38e818c82fdb0bae774387a724' --DelegateVotesChanged AND CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042' AND BLOCK_TIMESTAMP < '2023-02-23 14:11'::TIMESTAMP - INTERVAL '10 day' ) WHERE rowNumber = 1 UNION SELECT SUM(newBalance) AS totalVotableSuplly , MAX(BLOCK_TIMESTAMP) AS snapShotTime , 'Before' AS boa FROM ( SELECT (to_number(SUBSTRING(DATA, 99, 32), 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'))/POW(10, 18) AS newBalance , ROW_NUMBER() OVER (PARTITION BY TOPICS[1] ORDER BY BLOCK_NUMBER DESC) AS rowNumber , BLOCK_TIMESTAMP FROM optimism.core.fact_event_logs WHERE TOPICS[0] = '0xdec2bacdd2f05b59de34da9b523dff8be42e5e38e818c82fdb0bae774387a724' --DelegateVotesChanged AND CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042' AND BLOCK_TIMESTAMP < '2023-02-23 14:11'::TIMESTAMP - INTERVAL '11 day' ) WHERE rowNumber = 1 UNION SELECT SUM(newBalance) AS totalVotableSuplly , MAX(BLOCK_TIMESTAMP) AS snapShotTime , 'Before' AS boa FROM ( SELECT (to_number(SUBSTRING(DATA, 99, 32), 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'))/POW(10, 18) AS newBalance , ROW_NUMBER() OVER (PARTITION BY TOPICS[1] ORDER BY BLOCK_NUMBER DESC) AS rowNumber , BLOCK_TIMESTAMP FROM optimism.core.fact_event_logs WHERE TOPICS[0] = '0xdec2bacdd2f05b59de34da9b523dff8be42e5e38e818c82fdb0bae774387a724' --DelegateVotesChanged AND CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042' AND BLOCK_TIMESTAMP < '2023-02-23 14:11'::TIMESTAMP - INTERVAL '12 day' ) WHERE rowNumber = 1 UNION SELECT SUM(newBalance) AS totalVotableSuplly , MAX(BLOCK_TIMESTAMP) AS snapShotTime , 'Before' AS boa FROM ( SELECT (to_number(SUBSTRING(DATA, 99, 32), 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'))/POW(10, 18) AS newBalance , ROW_NUMBER() OVER (PARTITION BY TOPICS[1] ORDER BY BLOCK_NUMBER DESC) AS rowNumber , BLOCK_TIMESTAMP FROM optimism.core.fact_event_logs WHERE TOPICS[0] = '0xdec2bacdd2f05b59de34da9b523dff8be42e5e38e818c82fdb0bae774387a724' --DelegateVotesChanged AND CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042' AND BLOCK_TIMESTAMP < '2023-02-23 14:11'::TIMESTAMP - INTERVAL '13 day' ) WHERE rowNumber = 1

Flow Direction: Optimism <->Base