Top Projects By AUs

0xHaM-dTop Projects By AUs

Updated 2025-03-05

-- forked from Top Projects By AUs @ https://flipsidecrypto.xyz/studio/queries/052affc8-b315-4de2-85c6-4ab776873352

select

"Project",

"Transactions",

case

when "TXs Change %">0 then '🟩 '||"TXs Change %"::string||'%'

when "TXs Change %"<0 then '🟥 '||"TXs Change %"::string||'%'

else ''||"TXs Change %"::string||'%' end as "TXs Change %",

"AUs",

case

when "AUs Change %">0 then '🟩 '||"AUs Change %"::string||'%'

when "AUs Change %"<0 then '🟥 '||"AUs Change %"::string||'%'

else "AUs Change %"::string||'%' end as "AUs Change %",

"Fees",

case

when "Fees Change %">0 then '🟩 '||"Fees Change %"::string||'%'

when "Fees Change %"<0 then '🟥 '||"Fees Change %"::string||'%'

else "Fees Change %"::string||'%' end as "Fees Change %"

from

(select

date_trunc({{period_type}}, BLOCK_TIMESTAMP) as "Date",

iff( INITCAP(LABEL)='Move Dollar','Thala',INITCAP(LABEL)) as "Project",

count(*) as "Transactions",

lag("Transactions") over (partition by "Project" order by "Date") as lag_txs,

round(100*("Transactions"-lag_txs)/lag_txs,2) as "TXs Change %",

count(distinct sender) as "AUs",

lag("AUs") over (partition by "Project" order by "Date") as lag_AUs,

round(100*("AUs"-lag_AUs)/lag_AUs,2) as "AUs Change %",

sum(((gas_used * gas_unit_price)/1e8)) as "Fees",

lag("Fees") over (partition by "Project" order by "Date") as lag_fees,

round(100*("Fees"-lag_fees)/lag_fees,2) as "Fees Change %"

from (

select *,

from aptos.core.fact_events

where SUCCESS=true

and BLOCK_TIMESTAMP::date>='{{start_day}}'

Last run: about 2 months ago

	Project	Transactions	TXs Change %	AUs	AUs Change %	Fees	Fees Change %
1	Kgen	18065857	🟥 -2.16%	3504309	🟩 11.41%	373019.388845	🟩 64.02%
2	Kgen	4319007	🟥 -76.09%	733566	🟥 -79.07%	179381.900706	🟥 -51.91%
3	Jtpoint	293285	🟩 21.89%	188713	🟥 -21.10%	4.10599	🟩 18.39%
4	Slime Revolution	5092897	🟥 -68.79%	169593	🟥 -6.17%	21.566908	🟥 -77.10%
5	Tapos	5389177	🟥 -11.74%	158272	🟩 0.04%	225.796484	🟥 -14.27%
6	Tapos	366988	🟥 -93.19%	151435	🟥 -4.32%	12.775912	🟥 -94.34%
7	Slime Revolution	475488	🟥 -90.66%	138920	🟥 -18.09%	1.979925	🟥 -90.82%
8	Xgamble	972058	🟥 -17.15%	58911	🟩 5.74%	4.168994	🟥 -18.17%
9	Apt-Casino	695656	🟥 -12.26%	58853	🟩 10.00%	4.623897	🟥 -26.38%
10	Liquidswap	2998970	🟥 -21.01%	52669	🟥 -31.33%	1494.64691	🟩 14.63%

821B

1030s