Ink 1 | mamad-5XN3k3

Updated 2025-04-06

select

date_trunc('day', block_timestamp) as date,

count(DISTINCT tx_hash) as txs,

count(DISTINCT from_address) as users,

round(sum(TX_FEE_PRECISE),3) as fee,

round(count(case when TX_SUCCEEDED = 'TRUE' then TX_HASH end)/count(DISTINCT tx_hash),3) as success_rate,

count(case when TX_SUCCEEDED = 'TRUE' then TX_HASH end) as succeeded,

count(case when TX_SUCCEEDED != 'TRUE' then TX_HASH end) as failed

--min(BLOCK_TIMESTAMP) as min_time,

--max(BLOCK_TIMESTAMP) as max_time

from ink.core.fact_transactions

where block_timestamp >= '2024-12-17 11:00:00.000'

group by 1

order by 1 asc

Last run: 22 days ago

	DATE	TXS	USERS	FEE	SUCCESS_RATE	SUCCEEDED	FAILED
1	2024-12-17 00:00:00.000	61752	1440	0.259	0.989	61103	649
2	2024-12-18 00:00:00.000	120546	4212	0.317	0.991	119440	1106
3	2024-12-19 00:00:00.000	114781	6521	0.468	0.996	114274	507
4	2024-12-20 00:00:00.000	103046	2762	0.24	0.997	102750	296
5	2024-12-21 00:00:00.000	99087	2124	0.074	0.996	98718	369
6	2024-12-22 00:00:00.000	99128	2144	0.05	0.996	98694	434
7	2024-12-23 00:00:00.000	103033	3057	0.227	0.998	102789	244
8	2024-12-24 00:00:00.000	114504	4900	0.322	0.998	114242	262
9	2024-12-25 00:00:00.000	115239	4585	0.219	0.999	115142	97
10	2024-12-26 00:00:00.000	117234	5846	0.322	0.998	117051	183
11	2024-12-27 00:00:00.000	109386	4145	0.268	0.999	109257	129
12	2024-12-28 00:00:00.000	114429	4886	0.319	0.997	114140	289
13	2024-12-29 00:00:00.000	118475	5843	0.417	0.994	117732	743
14	2024-12-30 00:00:00.000	114897	5674	0.463	0.995	114326	571
15	2024-12-31 00:00:00.000	120003	7295	0.542	0.995	119414	589
16	2025-01-01 00:00:00.000	116511	4955	0.172	0.998	116235	276
17	2025-01-02 00:00:00.000	109194	4480	0.156	0.997	108854	340
18	2025-01-03 00:00:00.000	109965	5032	0.222	0.997	109596	369
19	2025-01-04 00:00:00.000	120151	5786	0.204	0.997	119807	344
20	2025-01-05 00:00:00.000	114891	5593	0.209	0.996	114411	480

...

111

7KB

flipside