DATE | TOTAL_MEMO_TXS | SUCCESSFUL_MEMO_TXS | UNIQUE_ACCOUNTS | AVG_FEE_CHARGED_USD | SUCCESS_RATE | |
|---|---|---|---|---|---|---|
1 | 2025-03-13 00:00:00.000 | 1783954 | 975231 | 59108 | 54.67 | |
2 | 2025-03-12 00:00:00.000 | 3980753 | 2061046 | 75666 | 51.78 | |
3 | 2025-03-11 00:00:00.000 | 4392909 | 1927597 | 78400 | 43.88 | |
4 | 2025-03-10 00:00:00.000 | 4741574 | 2091135 | 84515 | 44.1 | |
5 | 2025-03-09 00:00:00.000 | 4059170 | 1921754 | 73552 | 47.34 | |
6 | 2025-03-08 00:00:00.000 | 3309265 | 1897896 | 83154 | 57.35 | |
7 | 2025-03-07 00:00:00.000 | 4328858 | 1976714 | 83226 | 45.66 | |
8 | 2025-03-06 00:00:00.000 | 3832742 | 1897078 | 82304 | 49.5 | |
9 | 2025-03-05 00:00:00.000 | 3951103 | 2009857 | 81040 | 50.87 | |
10 | 2025-03-04 00:00:00.000 | 4147430 | 1975817 | 83483 | 47.64 | |
11 | 2025-03-03 00:00:00.000 | 4381576 | 1878408 | 89038 | 42.87 | |
12 | 2025-03-02 00:00:00.000 | 4182208 | 1754285 | 87401 | 41.95 | |
13 | 2025-03-01 00:00:00.000 | 3359465 | 1681732 | 88488 | 50.06 | |
14 | 2025-02-28 00:00:00.000 | 4169270 | 1827380 | 81034 | 43.83 | |
15 | 2025-02-27 00:00:00.000 | 3243674 | 1760826 | 80148 | 54.28 | |
16 | 2025-02-26 00:00:00.000 | 3775670 | 1858148 | 78566 | 49.21 | |
17 | 2025-02-25 00:00:00.000 | 4999926 | 1991887 | 93151 | 39.84 | |
18 | 2025-02-24 00:00:00.000 | 4146543 | 1813162 | 81517 | 43.73 | |
19 | 2025-02-23 00:00:00.000 | 3526945 | 1548842 | 78228 | 43.91 | |
20 | 2025-02-22 00:00:00.000 | 3552202 | 1580929 | 73212 | 44.51 |
permarymemo transactions/ cex related transactions
Updated 5 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
›
⌄
with daily_memos as (
select
date(t.closed_at) as date,
count(*) as total_memo_txs,
count(case when successful = true then 1 end) as successful_memo_txs,
count(distinct account) as unique_accounts,
avg(t.fee_charged / 10000000.0 * p.price) as avg_fee_charged_usd -- converting from stroops to xlm and then to usd
from stellar.core.fact_transactions t
left join stellar.price.ez_prices_hourly p
on date_trunc('hour', t.closed_at) = p.hour
and p.symbol = 'xlm'
and p.blockchain = 'stellar'
where
t.closed_at >= dateadd(month, -12, current_date)
and t.memo is not null
group by date
)
select
date,
total_memo_txs,
successful_memo_txs,
unique_accounts,
round(avg_fee_charged_usd, 6) as avg_fee_charged_usd,
round(successful_memo_txs * 100.0 / total_memo_txs, 2) as success_rate
from daily_memos
order by date desc;
Last run: 5 days ago
...
366
22KB
64s