forgashArbitrum
Updated 2022-12-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
-- select
-- block_timestamp::date as days,
-- count(distinct FROM_ADDRESS) as dau,
-- count(*) as txns,
-- count(distinct tx_hash)
-- from arbitrum.core.fact_transactions
-- group by days
-- order by days
--from txs:
-- select
-- status,
-- count(distinct tx_hash) as txs
-- from arbitrum.core.fact_transactions
-- where block_timestamp::Date = '2022-12-01'
-- group by 1
-- 639,587 total
-- 629,309 success
-- 10,197 fail
--from blocks
-- block count matches arbiscan
-- tx count on arbiscan = 372,484
-- vs 639,587 here
-- select
-- sum(tx_count) as txs,
-- count(distinct block_number)
-- from arbitrum.core.fact_blocks
-- where block_timestamp::date = '2022-12-01'
-- looking at some sample blocks
-- top 10 match
-- select *
-- from arbitrum.core.fact_blocks
-- where block_timestamp::date = '2022-12-01'
Run a query to Download Data