ArioDaily Fees from Ordinals Vs Non-Ordinals
Updated 2024-11-11
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
total as (
select
date_trunc('day', block_timestamp) as date,
sum(fee) as total_fees
from
bitcoin.core.fact_transactions
where
Block_number > 767429
group by
1
),
price as (
select
date_trunc('day', hour) as date,
avg(price) as Btc_Price
from
bitcoin.price.ez_prices_hourly
where
1=1
and hour >= '2022-12-14'
group by
1
)
select
a.date,
ordinal_fees * Btc_Price as "Ordinal Fees",
sum("Ordinal Fees") over(order by a.date asc) as "Cum. Ordinal Fees ($)",
(total_fees - ordinal_fees) * Btc_Price as "Non Ordinal Fees",
ordinal_fees / total_fees as "Ordinal Fees Percent"
from
(
select
date_trunc('day', block_timestamp) as date,
sum(fee) as ordinal_fees
from
QueryRunArchived: QueryRun has been archived