weary-blue | FatemeTheLady

Updated 2025-02-25

select

date_trunc('day',l.block_timestamp) as "Time",

count(*) as "Transactions",

sum(l.tx_fee) as "Total Transaction Fee (RON)",

Avg(l.tx_fee) as "Avg Transaction Fee (RON)",

median(l.tx_fee) as "Median Transaction Fee (RON)",

max(l.tx_fee) as "Max Transaction Fee (RON)",

min(l.tx_fee) as "Min Transaction Fee (RON)",

sum(l.value) as " Transaction Amount",

count(distinct l.from_address) as "Active Addresses",

count(*)/ count(distinct l.from_address) as "Transactions Per Address"

from

ronin.core.fact_transactions l

where

date(l.block_timestamp) > current_date - interval '{{SeriesDate}} days'

and l.tx_succeeded=TRUE

group by 1

order by 1 desc

Last run: 24 days agoAuto-refreshes every 12 hours

	Time	Transactions	Total Transaction Fee (RON)	Avg Transaction Fee (RON)	Median Transaction Fee (RON)	Max Transaction Fee (RON)	Transaction Amount	Active Addresses	Transactions Per Address
1	2025-02-25 00:00:00.000	687824	1496.797882436	0.002176135003	0.00132265	5.594039359	4866399.43483044	509851	1.349069
2	2025-02-24 00:00:00.000	912842	2539.919122867	0.002782430172	0.00132265	7.978521087	14316168.0051932	591710	1.542719
3	2025-02-23 00:00:00.000	972149	2289.627215348	0.002355222518	0.001305128	5.213089019	5002719.67706298	575897	1.688061
4	2025-02-22 00:00:00.000	1011330	2215.361964244	0.002190543111	0.001305128	4.269612586	3474254.73648031	576571	1.754042
5	2025-02-21 00:00:00.000	940697	2441.210582674	0.00259510829	0.00132265	6.905514202	6154350.45910523	593984	1.583708
6	2025-02-20 00:00:00.000	1079970	3155.426338771	0.002921772215	0.00132265	26.796700855	5642080.73801725	636251	1.697396
7	2025-02-19 00:00:00.000	1022899	2869.918465202	0.002805671396	0.00132295	12.144922416	5031387.27442473	577700	1.77064

867B

flipside