DATE | QUARTER_NAME | Users | Transactions | Fees (NEAR) | New Users | Developer | Deployed Contract | Average Daily Transactions | Average Daily Users | Average Daily Fees (NEAR) | Average Daily New Users | Average Daily Developer | Average Daily Deployed Contract | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2024-10-01 00:00:00.000 | Q4 - 2024 | 27501936 | 686471555 | 382739.05610596 | 6940872 | 735 | 1348 | 7627462 | 305577 | 4253 | 77121 | 8 | 15 |
SniperQuarterly Custom
Updated 2024-10-21
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
›
⌄
with main as (
select
date_trunc('quarter', block_timestamp) as date,
count(DISTINCT tx_signer) as "Users",
count(DISTINCT tx_hash) as "Transactions",
sum(TRANSACTION_FEE / pow(10, 24)) as "Fees (NEAR)"
FROM
near.core.fact_transactions
where
block_timestamp :: Date >= '2024-01-01'
group by
1
),
new_wallet as (
select
date_trunc('quarter', first_tx) as date,
count(DISTINCT tx_signer) as "New Users"
from
(
select
tx_signer,
min(block_timestamp) as first_tx
from
near.core.fact_transactions
where
block_timestamp :: Date >= '2024-01-01'
group by
1
)
group by
1
),
contract as (
select date_trunc('quarter', block_timestamp) as date,
count(DISTINCT creator) as "Developer",
count(contract) as "Deployed Contract"
Last run: about 1 month ago
1
124B
280s