tomilayoanonymous-copper
Updated 2024-10-29
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 june_summary AS (
SELECT
COUNT(DISTINCT tx_hash) AS june_total_transactions
FROM
blast.core.fact_transactions
WHERE
block_timestamp >= '2024-06-01' AND block_timestamp < '2024-07-01'
),
july_summary AS (
SELECT
COUNT(DISTINCT tx_hash) AS july_total_transactions,
COUNT(DISTINCT DATE(block_timestamp)) AS july_active_days
FROM
blast.core.fact_transactions
WHERE
block_timestamp >= '2024-07-01' AND block_timestamp < '2024-08-01'
),
july_daily_avg AS (
SELECT
july_total_transactions / july_active_days AS july_avg_daily_transactions
FROM
july_summary
)
SELECT
js.july_total_transactions AS total_transactions_in_july,
jda.july_avg_daily_transactions AS avg_daily_transactions_in_july,
COALESCE(
(js.july_total_transactions - jsu.june_total_transactions) * 100.0
/ NULLIF(jsu.june_total_transactions, 0), 0
) AS percentage_change_transactions
FROM
july_summary js
JOIN
june_summary jsu ON TRUE
JOIN
july_daily_avg jda ON TRUE;
QueryRunArchived: QueryRun has been archived