Query editor
WITHv1_breaker_events as (SELECTCASE trip.rateFeedID-- USDT RatesWHEN 0x564dD5fec58E7103C2A6041B7dD1BB3074a4616b THEN 'USDT/USD'-- USDC RatesWHEN 0xa1a8003936862e7a15092a91898d69fa8bce290c THEN 'USDC/USD'WHEN 0x206B25Ea01E188Ee243131aFdE526bA6E131a016 THEN 'USDC/EUR'WHEN 0x25F21A1f97607Edf6852339fad709728cffb9a9d THEN 'USDC/BRL'-- EUR RatesWHEN 0x40dC8528167557353fdcD98548AB2139A670Dd0b THEN 'EUR/XOF'WHEN 0xeD35e46b095197dA30DdFFA5B91d386886d5ce0d THEN 'EUROC/XOF'WHEN 0x26076B9702885d475ac8c3dB3Bd9F250Dc5A318B THEN 'EUROC/EUR'-- CELO RatesWHEN 0x765de816845861e75a25fca122bb6898b8b1282a THEN 'CELO/USD'WHEN 0xd8763cba276a3738e6de85b4b3bf5fded6d6ca73 THEN 'CELO/EUR'WHEN 0xe8537a3d056da446677b9e9d6c5db704eaab4787 THEN 'CELO/REAL'WHEN 0x73f93dcc49cb8a239e2032663e9475dd5ef29a08 THEN 'CELO/XOF'WHEN 0x62B8B11039FcfE5aB0C56E502b1C372A3d2a9c7A THEN 'CELO/G$'ELSE CAST(trip.rateFeedID AS VARCHAR)END as rateFeed,'<a href=https://celoscan.io/address/' || cast(c.address as varchar) || '#code target=_blank>' || replace(c.name, 'Breaker') || '</a>' as breaker,trip.evt_block_time AS trippedAt,trip.evt_block_number AS tripBlock,MIN(br.evt_block_number) as resetBlock,human_readable_seconds(date_diff('second',trip.evt_block_time,min(br.evt_block_time))) as tripDuration,MIN(br.evt_block_time) as resetAt,'<a href=https://celoscan.io/tx/' || cast(trip.evt_tx_hash as varchar) || ' target=_blank>' || concat(substr(cast(trip.evt_tx_hash as varchar), 1, 6),'..',substr(cast(trip.evt_tx_hash as varchar),length(cast(trip.evt_tx_hash as varchar)) - 6,6)) || '</a>' as trippedTx-- TODO: Figure out how to get the right Reset TX ID in here (can't use MIN() in that case)FROMmento_celo.BreakerBox_evt_BreakerTripped tripINNER JOIN celo.contracts c ON trip.breaker = c.addressINNER JOIN mento_celo.BreakerBox_evt_ResetSuccessful br ON trip.rateFeedID = br.rateFeedIDAND br.evt_block_number > trip.evt_block_numberGROUP BYtrip.rateFeedID,trip.evt_block_time,trip.evt_block_number,trip.evt_tx_hash,c.address,c.nameORDER BYtrip.evt_block_time DESC),v2_breaker_events as (