0xHaM-dParallel - Daily New Users Count Per chain copy
Updated 2024-07-11
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
›
⌄
-- forked from Parallel - Daily New Users Count Per chain @ https://flipsidecrypto.xyz/edit/queries/459e3bd5-ca5d-448b-9fc7-c5fdba80d7a1
-- forked from Parallel - Daily Users Count Per chain @ https://flipsidecrypto.xyz/edit/queries/5de208cd-6a9d-4af1-aca9-eaf97b5cdb65
-- forked from Parallel - Average Daily TPS Per chain @ https://flipsidecrypto.xyz/edit/queries/84b836ff-ce1a-4b1f-8c64-a63997ccc04a
-- forked from EVM - Average Daily TPS Per chain @ https://flipsidecrypto.xyz/edit/queries/b4a0088e-50c3-4b8c-a1a7-d35e6ed251a2
-- forked from https://flipsidecrypto.xyz/hess/q/zhRwUPgM_nD1/average-daily-tps-per-chain
with
final as (
select
min(block_timestamp) as min_timestamp,
'Aptos' as chain,
sender as user
from aptos.core.fact_transactions
where block_timestamp::date >= '2023-01-01'
group by 2,3
UNION ALL
select
min(block_timestamp) as min_timestamp,
'Sei' as chain,
TX_FROM as user
from sei.core.fact_transactions
where block_timestamp::date >= '2023-01-01'
-- and TX_SUCCEEDED = 'true'
group by 2,3
UNION ALL
select
min(block_timestamp) as min_timestamp,
'Solana' as chain,
QueryRunArchived: QueryRun has been archived