Fleet Rentals - txs

AephiaFleet Rentals - txs

Updated 14 hours ago

WITH fleet_rentals AS (

select

--*

date_trunc('day',block_timestamp::date) as date

,count(case when ft.log_messages::string LIKE '%CreateContract%'

then tx_id end) as CreateContract

,count(case when ft.log_messages::string LIKE '%CloseContract%'

then tx_id end) as CloseContract

,count(case when ft.log_messages::string LIKE '%AcceptRental%'

then tx_id end) as AcceptRental

,count(case when ft.log_messages::string LIKE '%CloseRental%'

then tx_id end) as CloseRental

,count(case when ft.log_messages::string LIKE '%CancelRental%'

then tx_id end) as CancelRental

FROM solana.core.fact_events fe

inner join solana.core.fact_transactions ft USING(block_timestamp, tx_id, succeeded)

WHERE program_id = 'SRSLY1fq9TJqCk1gNSE7VZL2bztvTn9wm4VR8u8jMKT' --Fleet Rentals

AND (ft.log_messages::string LIKE '%CreateContract%'

OR ft.log_messages::string LIKE '%CloseContract%'

OR ft.log_messages::string LIKE '%AcceptRental%'

OR ft.log_messages::string LIKE '%CloseRental%'

OR ft.log_messages::string LIKE '%CancelRental%')

AND succeeded = 'true'

AND block_timestamp > current_date-30 AND block_timestamp < current_date

group by 1

)

,pay_rentals AS (

select

--fe.*

date_trunc('day',block_timestamp::date) as date

,sum(value:parsed:info:amount) / POW(10,8) as atlas_rental

Last run: about 14 hours ago

	DATE	CREATECONTRACT	CLOSECONTRACT	ACCEPTRENTAL	CLOSERENTAL	CANCELRENTAL	ATLAS_RENTAL	CREATECONTRACT_CUM	CLOSECONTRACT_CUM	ACCEPTRENTAL_CUM	CLOSERENTAL_CUM	CANCELRENTAL_CUM	ATLAS_RENTAL_CUM	RENTED_FLEETS	ACTIVE_OFFERS
1	2025-03-31 00:00:00.000	101	83	79	1	13	2333758	3354	2681	2265	20	319	50658626	1926	-934
2	2025-03-30 00:00:00.000	113	79	92	0	5	3269524	3253	2598	2186	19	306	48324868	1861	-900
3	2025-03-29 00:00:00.000	95	99	79	0	10	1557449	3140	2519	2094	19	301	45055344	1774	-852
4	2025-03-28 00:00:00.000	38	58	56	0	14	1170569	3045	2420	2015	19	291	43497895	1705	-789
5	2025-03-27 00:00:00.000	50	23	52	10	13	1217452	3007	2362	1959	19	277	42327326	1663	-741
6	2025-03-26 00:00:00.000	76	67	74	3	5	1760530	2957	2339	1907	9	264	41109874	1634	-752
7	2025-03-25 00:00:00.000	108	89	74	6	1	2032374	2881	2272	1833	6	259	39349344	1568	-700
8	2025-03-24 00:00:00.000	91	89	86	0	21	1270190	2773	2183	1759	0	258	37316970	1501	-653
9	2025-03-23 00:00:00.000	111	130	95	0	9	2078057	2682	2094	1673	0	237	36046780	1436	-611
10	2025-03-22 00:00:00.000	72	89	64	0	12	1750937	2571	1964	1578	0	228	33968723	1350	-515
11	2025-03-21 00:00:00.000	81	78	76	0	8	1506615	2499	1875	1514	0	216	32217786	1298	-458
12	2025-03-20 00:00:00.000	112	110	77	0	16	2319913	2418	1797	1438	0	208	30711171	1230	-401
13	2025-03-19 00:00:00.000	85	64	61	0	10	1222466	2306	1687	1361	0	192	28391258	1169	-358
14	2025-03-18 00:00:00.000	91	94	91	0	8	2365418	2221	1623	1300	0	182	27168792	1118	-338
15	2025-03-17 00:00:00.000	126	120	93	0	20	1774698	2130	1529	1209	0	174	24803374	1035	-260
16	2025-03-16 00:00:00.000	110	105	59	0	6	1274464	2004	1409	1116	0	154	23028676	962	-213
17	2025-03-15 00:00:00.000	140	136	91	0	8	1952479	1894	1304	1057	0	148	21754212	909	-171
18	2025-03-14 00:00:00.000	127	100	81	0	12	1619686	1754	1168	966	0	140	19801733	826	-100
19	2025-03-13 00:00:00.000	167	134	101	0	9	2638456	1627	1068	885	0	128	18182047	757	-70
20	2025-03-12 00:00:00.000	106	111	63	0	6	1189719	1460	934	784	0	119	15543591	665	-20

2KB

579s

flipside

flipside