0xHaM-dAll - New Users
Updated 2024-05-10
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
›
⌄
-- forked from All - New Users @ https://flipsidecrypto.xyz/edit/queries/2a0399a8-4253-4c39-8496-10a5ea4c4a12
-- forked from All - New Users copy @ https://flipsidecrypto.xyz/edit/queries/b87b895a-a62a-426d-87a9-f2d700d44e62
-- forked from h4wk / All - New Users @ https://flipsidecrypto.xyz/h4wk/q/9-SEpbstq0jB/all---new-users
-- 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
parallel 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
QueryRunArchived: QueryRun has been archived