Query editor
withmigrations AS (SELECTevt_block_time AS block_time,evt_tx_hash AS tx,evt_tx_from AS claimed_by,ogvAmountIn / 1e18 AS ogv,ognAmountOut / 1e18 AS ognFROM origin_protocol_ethereum.Migrator_evt_TokenExchanged),aggregate AS (SELECTblock_time,tx,claimed_by,ogv,ogn,SUM(ogv) OVER (ORDER BY block_time) AS ogv_migratedFROM migrations),query AS (SELECTblock_time,tx,claimed_by,ogv,ogv_migrated,(ogv_migrated / 4515745462) AS pct_migratedFROM aggregate)SELECT *FROM queryORDER BY block_time DESC