check_skedDaily L2 TXs (Historical Type and Count)
Updated 2023-07-30
999
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
t1._day,
t1.Token_Txs_ARB,
t2.ETH_Txs_ARB,
t1.Token_Txs_ARB + t2.ETH_Txs_ARB AS total_txs_ARB,
t3.Token_Txs_OP,
t4.ETH_Txs_OP,
t3.Token_Txs_OP + t4.ETH_Txs_OP AS total_txs_OP,
t5.Token_Txs_MATIC,
t6.MATIC_Txs_MATIC,
t5.Token_Txs_MATIC + t6.MATIC_Txs_MATIC AS Total_TXs_MATIC
FROM
(
SELECT
_day,
COUNT(DISTINCT TX_HASH) AS Token_Txs_ARB
FROM
(
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS _day,
TX_HASH
FROM
arbitrum.core.fact_token_transfers
UNION ALL
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS _day,
TX_HASH
FROM
arbitrum.core.ez_eth_transfers
)
WHERE
_day >= CURRENT_DATE - INTERVAL '400 DAY'
GROUP BY
_day
ORDER BY
_day
Run a query to Download Data