DAY | DAILY_FEES_USD | MA_7D | MA_14D | MA_30D | |
|---|---|---|---|---|---|
1 | 2025-03-13 00:00:00.000 | 589.05 | 1097.86 | 907.97 | 804.77 |
2 | 2025-03-12 00:00:00.000 | 1060.26 | 1153.04 | 889.58 | 812.48 |
3 | 2025-03-11 00:00:00.000 | 1113.79 | 1099.29 | 854.81 | 803.3 |
4 | 2025-03-10 00:00:00.000 | 1824.42 | 1031.05 | 840.2 | 791.36 |
5 | 2025-03-09 00:00:00.000 | 1219.21 | 895.6 | 770.76 | 750.03 |
6 | 2025-03-08 00:00:00.000 | 917.18 | 842.03 | 723.97 | 730.48 |
7 | 2025-03-07 00:00:00.000 | 961.1 | 778.32 | 695.39 | 722.37 |
8 | 2025-03-06 00:00:00.000 | 975.34 | 718.08 | 673.12 | 711.52 |
9 | 2025-03-05 00:00:00.000 | 684 | 626.12 | 678.79 | 698.95 |
10 | 2025-03-04 00:00:00.000 | 636.08 | 610.33 | 669.46 | 699.7 |
11 | 2025-03-03 00:00:00.000 | 876.31 | 649.35 | 673.94 | 703.05 |
12 | 2025-03-02 00:00:00.000 | 844.2 | 645.91 | 638.9 | 693.42 |
13 | 2025-03-01 00:00:00.000 | 471.17 | 605.92 | 629.18 | 684.55 |
14 | 2025-02-28 00:00:00.000 | 539.42 | 612.46 | 639.86 | 697.89 |
15 | 2025-02-27 00:00:00.000 | 331.63 | 628.17 | 671.71 | 708.45 |
16 | 2025-02-26 00:00:00.000 | 573.47 | 731.46 | 735.37 | 735.37 |
17 | 2025-02-25 00:00:00.000 | 909.23 | 728.6 | 747.82 | 747.82 |
18 | 2025-02-24 00:00:00.000 | 852.26 | 698.52 | 734.37 | 734.37 |
19 | 2025-02-23 00:00:00.000 | 564.24 | 631.89 | 723.66 | 723.66 |
20 | 2025-02-22 00:00:00.000 | 516.96 | 652.44 | 739.6 | 739.6 |
permary Transaction fees
Updated 4 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 fees as (
select
date(closed_at) as day,
sum(fee_charged / 1e7) as daily_fees
from stellar.core.fact_transactions
where block_timestamp >= current_date - interval '1 month'
group by day
),
price as (
select
date_trunc('day', hour) as day,
avg(price) as avg_daily_price
from crosschain.price.ez_prices_hourly
where symbol = 'XLM'
and blockchain = 'stellar'
and is_native = TRUE
and hour >= current_date - interval '1 MONTH'
group by day
),
daily_fees_usd as (
select
f.day,
f.daily_fees,
p.avg_daily_price,
f.daily_fees * p.avg_daily_price as daily_fees_usd
from fees f
join price p on f.day = p.day
)
select
day,
round(daily_fees_usd, 2) as daily_fees_usd,
-- 7-day moving average
Last run: 4 days ago
29
2KB
8s