PROJECT | TRANSACTIONS_NUMBER | |
|---|---|---|
1 | kgen | 3826706 |
2 | thala | 1285465 |
3 | eragon | 1067827 |
4 | cellana finance | 550851 |
5 | lync | 307532 |
6 | palette | 289496 |
7 | switchboard | 243862 |
8 | econia | 167681 |
9 | slime revolution | 166469 |
10 | echo lending | 126331 |
11 | aries | 98611 |
12 | merkle | 83727 |
13 | pyth | 83379 |
14 | apt-casino | 82758 |
15 | lucid protocol | 80254 |
16 | chingari | 64419 |
17 | jtpoint | 59389 |
18 | aptin finance | 34880 |
19 | xgamble | 27261 |
20 | panora swap | 26647 |
AzinHot projects (transactions)
Updated 3 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH T1 AS
(select
COUNT(*)
, COUNT(DISTINCT SENDER) AS USER
,SPLIT(PAYLOAD_FUNCTION,'::')[0] AS CONTRACT
FROM
aptos.core.fact_transactions
WHERE
BLOCK_TIMESTAMP > CURRENT_DATE - 7
AND
SUCCESS = 'TRUE'
GROUP BY 3
ORDER BY 1 DESC),
T2 AS
(SELECT
CASE
WHEN CONTRACT = '0x66398cf97d29fd3825f65b37cb2773268e5438d37e20777e6a98261da0cf1f1e' THEN 'econia'
WHEN CONTRACT = '0x7de3fea83cd5ca0e1def27c3f3803af619882db51f34abf30dd04ad12ee6af31' THEN 'topas game'
WHEN CONTRACT = '0x7e783b349d3e89cf5931af376ebeadbfab855b3fa239b7ada8f5a92fbea6b387' THEN 'pyth'
WHEN CONTRACT = '0xde28606d08f78e31e5aefad98a9bccf5430abb557f22a5b3e4245fb26b40550b' THEN 'ddos coin'
WHEN CONTRACT = '0x5a96fab415f43721a44c5a761ecfcccc3dae9c21f34313f0e594b49d8d4564f4' THEN 'kkash'
WHEN CONTRACT = '0x6cb593226b22c801624059318c2d882b205893ae4307143ac32a8cb95f3f3ad3' THEN 'milestone'
WHEN CONTRACT IN ('0x6d138096fb880d1c16b48f10686b98a96000c0ac18501425378f784c6b81c34d','0xf9552a68230e0f4c0aa4ff3521b622ccabd8a8f07d17e453fe6fa3c091c8d495') THEN 'eragon'
WHEN CONTRACT = '0x6547d9f1d481fdc21cd38c730c07974f2f61adb7063e76f9d9522ab91f090dac' THEN 'Candy machine'
ELSE LABEL END AS LABEL
,A.*
FROM
T1 A LEFT JOIN aptos.core.dim_labels B ON A.CONTRACT=B.ADDRESS)
SELECT
LABEL AS Project
, SUM("COUNT(*)") AS Transactions_number
FROM
T2
Last run: 3 days ago
64
1KB
80s