Average Daily Active Users | Average Daily Transactions | Total Deployed Contracts | Total Users Count | Total Transactions Count | Average Fee per Transactions | |
|---|---|---|---|---|---|---|
1 | 314.852941 | 47227.573529 | 7508 | 15577 | 6422950 | 2.736419496e-7 |
rezarwzkey metrics
Updated 2 days ago
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 deployed_contracts as (
SELECT
count(DISTINCT tx_hash) as "Total Deployed Contracts"
from
swell.core.fact_traces
WHERE
TYPE ILIKE 'create%'
AND to_address IS NOT NULL
AND input IS NOT NULL
AND input != '0x'
AND TX_SUCCEEDED = TRUE
AND TRACE_SUCCEEDED = TRUE
),
overall_data as (
SELECT
count(DISTINCT from_address) as "Total Users Count",
count(tx_hash) as "Total Transactions Count",
avg(TX_FEE) as "Average Fee per Transactions"
FROM
swell.core.fact_transactions
),
daily_avg as (
SELECT
Avg(daily_active_users) as "Average Daily Active Users",
Avg(daily_transactions) as "Average Daily Transactions"
FROM
(
SELECT
block_timestamp :: date AS date,
COUNT(DISTINCT from_address) AS daily_active_users,
COUNT(distinct tx_hash) AS daily_transactions
FROM
swell.core.fact_transactions
GROUP BY
1
)
Last run: 2 days ago
1
61B
6s