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

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

Updated 2022-06-30

select count(*) as "transactions",

case when "FROM_ADDRESS" = lower('0x710bda329b2a6224e4b44833de30f38e7f81d564') then 'Arbitrum Odyssey'

when "FROM_ADDRESS" = lower('0x428ab2ba90eba0a4be7af34c9ac451ab061ac010') then 'Arbitrum Odyssey'

when "FROM_ADDRESS" = lower('0x98e9d288743839e96a8005a6b51c770bbf7788c0') then 'Arbitrum Odyssey'

when "FROM_ADDRESS" = lower('0xe93685f3bba03016f02bd1828badd6195988d950') then 'Arbitrum Odyssey'

when "FROM_ADDRESS" = lower('0x2a038e100f8b85df21e4d44121bdbfe0c288a869') then 'Arbitrum Odyssey'

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

from arbitrum.core.fact_transactions

where BLOCK_TIMESTAMP between '2022-06-21 17:00:00' and '2022-06-27 17:00:00' and STATUS = 'SUCCESS'

group by 2

Run a query to Download Data

flipside