chain_tx_stats

maybeyonaschain_tx_stats

Updated 4 hours ago

select

date_trunc('day', block_timestamp) as date,

count(tx_hash) as actual_txs,

count(

case

when tx_succeeded then tx_hash

else null end

) as actual_succeeded_txs,

count(

case

when not(tx_succeeded) then tx_hash

else null end

) as actual_failed_txs,

count(distinct from_address) as interacting_wallets,

sum(tx_fee_precise) as fees,

sum(l1_fee_precise) as l1_fees,

actual_txs/86400 as actual_tps,

sum(gas_used) as daily_gas_used,

sum(actual_txs) over(order by date) as cumu_actual_txs,

sum(actual_succeeded_txs) over(order by date) as cumu_actual_succeeded_txs,

sum(actual_failed_txs) over(order by date) as cumu_actual_failed_txs,

sum(fees) over(order by date) as cumu_fees,

sum(l1_fees) over(order by date) as cumu_l1_fees,

sum(daily_gas_used) over(order by date) as cumu_gas_used,

avg(actual_txs) over(order by date rows between 7 preceding and current row) as dma7_actual_txs,

avg(actual_succeeded_txs) over(order by date rows between 7 preceding and current row) as dma7_actual_succeeded_txs,

avg(actual_failed_txs) over(order by date rows between 7 preceding and current row) as dma7_actual_failed_txs,

avg(interacting_wallets) over(order by date rows between 7 preceding and current row) as dma7_interacting_wallets,

avg(fees) over(order by date rows between 7 preceding and current row) as dma7_fees,

avg(l1_fees) over(order by date rows between 7 preceding and current row) as dma7_l1_fees,

avg(daily_gas_used) over(order by date rows between 7 preceding and current row) as dma7_gas_used,

min(effective_gas_price/1e6) as min_gas_price,

max(effective_gas_price/1e6) as max_gas_price,

Last run: about 4 hours ago

	DATE	ACTUAL_TXS	ACTUAL_SUCCEEDED_TXS	ACTUAL_FAILED_TXS	INTERACTING_WALLETS	FEES	L1_FEES	ACTUAL_TPS	DAILY_GAS_USED	CUMU_ACTUAL_TXS	CUMU_ACTUAL_SUCCEEDED_TXS	CUMU_ACTUAL_FAILED_TXS	CUMU_FEES	CUMU_L1_FEES	CUMU_GAS_USED	DMA7_ACTUAL_TXS	DMA7_ACTUAL_SUCCEEDED_TXS	DMA7_ACTUAL_FAILED_TXS	DMA7_INTERACTING_WALLETS	DMA7_FEES	DMA7_L1_FEES	DMA7_GAS_USED	MIN_GAS_PRICE	MAX_GAS_PRICE	OPEN_GAS_PRICE	CLOSE_GAS_PRICE	MIN_L1_GAS_PRICE	MAX_L1_GAS_PRICE	OPEN_L1_GAS_PRICE	CLOSE_L1_GAS_PRICE
1	2025-04-02 00:00:00.000	2386	2352	34	413	0.002120832138	0.000006336695601	0.027616	262476593	520927	510002	10925	1.462882463	0.6708339919	51457746472	4254.125	4113.125	141	401.625	0.006911982252	0.0006651749556	517660460.25	0.000251	1500.000251	1.000251	1.000251	0.317534926	0.947655767	0.531965022	0.795663643
2	2025-04-01 00:00:00.000	4903	4818	85	551	0.005639570929	0.003280982473	0.056748	471919327	518541	507650	10891	1.460761631	0.6708276552	51195269879	4474.125	4319.25	154.875	386	0.007376125295	0.0006659521426	552298567.75	0.000252	1500.000251	1.000251	1.000251	0.297203825	3.953159674	0.549929459	0.549902338
3	2025-03-31 00:00:00.000	4796	4730	66	448	0.005801267046	0.001045632135	0.055509	542153620	513638	502832	10806	1.45512206	0.6675466728	50723350552	4418.875	4261	157.875	358.125	0.007061901646	0.0002576938247	558212292.75	0.000251	1500.000251	1.000502	1.000251	0.297040995	2.470603369	0.353728428	0.51407522
4	2025-03-30 00:00:00.000	3880	3837	43	346	0.004410933658	0.000007336708853	0.044907	430770088	508842	498102	10740	1.449320793	0.6665010406	50181196932	4195.25	4031.25	164	332.875	0.006664484823	0.0001275982161	523217382.5	0.000252	1500.000251	1.000251	1.000251	0.297275824	0.884594488	0.343620512	0.375253244
5	2025-03-29 00:00:00.000	3836	3745	91	307	0.006706571207	0.00008394523678	0.044398	415589329	504962	494265	10697	1.44490986	0.6664937039	49750426844	4096.375	3925.625	170.75	316.25	0.006284681876	0.0001354863297	508358033.75	0.000251	1500.2	1.000251	1.000251	0.299046621	1.279505929	0.585153017	0.36685274
6	2025-03-28 00:00:00.000	4393	4213	180	293	0.002424853632	0.0008192789785	0.050845	500428191	501126	490520	10606	1.438203288	0.6664097587	49334837515	4040.25	3867.375	172.875	306.875	0.005787665882	0.0001264200072	499550316.625	0.000251	1500.000251	1.000251	1.000251	0.302511333	1.772349469	0.396493505	0.610591178
7	2025-03-27 00:00:00.000	4110	3906	204	383	0.008669001801	0.00003835296479	0.047569	675241332	496733	486307	10426	1.435778435	0.6655904797	48834409324	3982.125	3812.875	169.25	304.25	0.006367233728	0.0000255089465	490968845.875	0.000251	3000	1.000502	1.000251	0.286174445	2.125437687	0.346565108	0.371333643
8	2025-03-26 00:00:00.000	5729	5304	425	472	0.01952282761	0.00003953445234	0.066308	842705202	492623	482401	10222	1.427109433	0.6655521267	48159167992	3996.125	3834.25	161.875	289.875	0.006030326699	0.00002398528922	462914862.125	0.000251	1500.2	1.000251	1.000251	0.302712627	2.583543024	0.33969071	0.353722434
9	2025-03-25 00:00:00.000	4146	4001	145	288	0.005833976483	0.00001255419203	0.047986	539581453	486894	477097	9797	1.407586605	0.6655125923	47316462790	3732.75	3607.75	125	262.5	0.003904638165	0.00003644004724	403924914.75	0.000251	2000.000251	1.000251	1.100251	0.311650079	2.028733143	0.662213773	0.311650079
10	2025-03-24 00:00:00.000	4461	4352	109	328	0.003125781738	0.00001491592903	0.051632	519229127	482748	473096	9652	1.401752629	0.6655000381	46776881337	3630	3509.5	120.5	259.625	0.003777924935	0.0003150010651	377140961.75	0.000252	3000	1.000251	1.000502	0.306267957	3.269577933	0.422482601	0.52544433
11	2025-03-23 00:00:00.000	3007	2892	115	246	0.002621932457	0.000004867266614	0.034803	262194338	478287	468744	9543	1.398626847	0.6654851222	46257652210	3501.875	3379.75	122.125	246.375	0.00355408987	0.0003225068037	351694409.625	0.000252	1500.000251	1.000251	1.375	0.290028785	0.576603462	0.384836984	0.387188538
12	2025-03-22 00:00:00.000	3089	2992	97	213	0.001372510085	0.00007044161733	0.035752	311895298	475280	465852	9428	1.396004915	0.6654802549	45995457872	3478.25	3360.125	118.125	244.75	0.003566518338	0.0003421466535	350875492.25	0.000252	1500.000251	1.000251	1.000251	0.331975392	0.575141339	0.378837611	0.357410846
13	2025-03-21 00:00:00.000	3387	3279	108	232	0.002730443252	0.00001141465683	0.039201	345127592	472191	462860	9331	1.394632405	0.6654098133	45683562574	3515.875	3396.5	119.375	250.875	0.004078389126	0.0004850958047	356981396	0.000252	1500.000251	1.000251	1.000251	0.335448552	0.673472157	0.399597712	0.439226329
14	2025-03-20 00:00:00.000	3928	3777	151	272	0.007061396397	0.00001199049303	0.045463	431776425	468804	459581	9223	1.391901961	0.6653983986	45338434982	3545.75	3427.375	118.375	253.625	0.004641513823	0.0007723145145	359487122.75	0.000251	1500.000251	1.000251	1.000251	0.362527915	2.428371449	0.451799508	0.469688436
15	2025-03-19 00:00:00.000	4222	4077	145	268	0.005973745575	0.00002616370652	0.048866	450809462	464876	455804	9072	1.384840565	0.6653864081	44906658557	3914.125	3792.375	121.75	251.875	0.005272441487	0.001310846852	436047293	0.000251	1500.000251	0.066918	1.200301	0.338284616	3.59821015	0.432533054	0.421268796
16	2025-03-18 00:00:00.000	3622	3492	130	253	0.002517319333	0.0001391725165	0.041921	370785623	460654	451727	8927	1.378866819	0.6653602444	44455849095	4133.75	4013	120.75	253.625	0.006109311633	0.001970050626	473018284.5	0.000251	1500.000251	1.000251	1.000251	0.347861912	1.054431301	0.383130529	0.427103695
17	2025-03-17 00:00:00.000	3324	3215	109	265	0.004820270646	0.002241042335	0.038472	325309829	457032	448235	8797	1.3763495	0.6652210719	44085063472	4446.75	4317.875	128.875	250.5	0.009154578909	0.004819182187	507768592.125	0.000251	1500.000251	1.2	1.000251	0.350199876	2.02496223	0.498036967	0.406806168
18	2025-03-16 00:00:00.000	3436	3314	122	222	0.001335101215	0.00007496183735	0.039769	315656710	453708	445020	8688	1.371529229	0.6629800296	43759753643	4568.625	4434.75	133.875	246.875	0.009237253654	0.004768265503	523054837.625	0.000251	1500.000251	1.000251	1.000251	0.365342017	0.957868675	0.466356552	0.478972577
19	2025-03-15 00:00:00.000	2818	2735	83	233	0.002721360199	0.0001619860652	0.032616	255642999	450272	441706	8566	1.370194128	0.6629050677	43444096933	4634.75	4504.25	130.5	249.875	0.00930946416	0.004768617543	537364817.875	0.000251	1500.000251	1.000251	1.000251	0.374153274	0.767984483	0.547574281	0.44633306
20	2025-03-14 00:00:00.000	3390	3283	107	262	0.005467476394	0.001214034827	0.039236	360742528	447454	438971	8483	1.367472768	0.6627430817	43188453934	5070.375	4925.125	145.25	254.625	0.009782759119	0.005088056392	590587524	0.000251	1500.000251	1.000251	1.000251	0.36891552	1.99698618	0.510995121	0.521921098

...

125

37KB

flipside

flipside