Transactions related to Arbitrum Odyssey during the second week of Arbitrum Odyssey

articoloquintoTransactions related to Arbitrum Odyssey during the second week of Arbitrum Odyssey

Updated 2022-06-30

select count(*) as "transactions",

case when "TO_ADDRESS" = lower('0x9e6ef7f75ad88d4edb4c9925c94b769c5b0d6281') then 'Arbitrum Odyssey'

when "TO_ADDRESS" = lower('0xa906f338cb21815cbc4bc87ace9e68c87ef8d8f1') then 'Arbitrum Odyssey'

when "TO_ADDRESS" = lower('0x1a0ad27350cccd6f7f168e052100b4960efdb774') then 'Arbitrum Odyssey'

when "TO_ADDRESS" = lower('0xabbc5f99639c9b6bcb58544ddf04efa6802f4064') then 'Arbitrum Odyssey'

when "TO_ADDRESS" = lower('0x3d6ba331e3d9702c5e8a8d254e5d8a285f223aba') then 'Arbitrum Odyssey'

when "TO_ADDRESS" = lower('0x16e25cf364cecc305590128335b8f327975d0560') then 'Arbitrum Odyssey' else 'Others' end as "cause"

from arbitrum.core.fact_transactions

where BLOCK_TIMESTAMP between '2022-06-28 17:00:00' and '2022-06-29 15:00:00' and STATUS = 'SUCCESS'

group by 2

Run a query to Download Data

flipside