datavortexcheck mint
Updated 2024-12-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
⌄
/*
SELECT DISTINCT
SPLIT_PART(tx.payload_function, '::', 2) AS module_name,
SPLIT_PART(tx.payload_function, '::', 3) AS function_name
FROM aptos.core.fact_transactions tx
INNER JOIN aptos.nft.ez_nft_mints nm
ON tx.tx_hash = nm.tx_hash
WHERE tx.block_timestamp >= CURRENT_DATE - INTERVAL '1 DAY'
AND tx.block_timestamp < CURRENT_DATE;
*/
SELECT
SPLIT_PART(tx.payload_function, '::', 2) AS module_name,
SPLIT_PART(tx.payload_function, '::', 3) AS function_name,
COUNT(DISTINCT tx.sender) AS distinct_users
FROM aptos.core.fact_transactions tx
WHERE tx.block_timestamp >= CURRENT_DATE - INTERVAL '1 DAY'
AND tx.block_timestamp < CURRENT_DATE
AND tx.payload_function IS NOT NULL -- Ensure payload_function is not null
GROUP BY
SPLIT_PART(tx.payload_function, '::', 2),
SPLIT_PART(tx.payload_function, '::', 3)
ORDER BY distinct_users DESC;
QueryRunArchived: QueryRun has been archived