js699weekly flow summary metrics
Updated 2025-01-09
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
›
⌄
with
prices as (
select
DATE_TRUNC('week', hour) AS data,
avg(price) as flow_price
from flow.price.ez_prices_hourly where symbol ='FLOW'
group by 1
)
SELECT
DATE_TRUNC('week', BLOCK_TIMESTAMP_HOUR) AS date,
case when date>'2024-09-04' then 'Post Upgrade' else 'Pre Upgrade' end as phase,
flow_price,
SUM(BLOCK_COUNT) AS weekly_block_count,
SUM(TRANSACTION_COUNT) AS weekly_transaction_count,
MAX(UNIQUE_FROM_COUNT) AS weekly_unique_addresses,
SUM(TOTAL_FEES_NATIVE) AS weekly_total_fees_native,
SUM(TOTAL_FEES_USD) AS weekly_total_fees_usd,
AVG(TOTAL_FEES_NATIVE / TRANSACTION_COUNT) AS avg_fee_per_transaction_native,
AVG(TOTAL_FEES_USD / TRANSACTION_COUNT) AS avg_fee_per_transaction_usd
FROM flow.stats.ez_core_metrics_hourly x
join prices y on DATE_TRUNC('week', x.BLOCK_TIMESTAMP_HOUR)=data
GROUP BY date, phase, flow_price
ORDER BY date DESC
QueryRunArchived: QueryRun has been archived