yasmin Breakdown by TOKEN_ID
Updated 2024-09-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
SUBSTRING(TOKENID, CHARINDEX('#', TOKENID) + 1) AS TOKEN_ID,
SUM(TOTAL_PRICE) AS VOLUME_apt,
COUNT(DISTINCT tx_hash) AS TX,
COUNT(DISTINCT Seller_address) AS Sellers,
COUNT(DISTINCT buyer_address) AS Buyers
FROM aptos.nft.ez_nft_sales
WHERE project_name IN ('{{project_name}}')
AND block_timestamp::date >= '{{Start_Date}}'
AND block_timestamp::date <= '{{End_Date}}'
AND project_name IS NOT NULL
AND EVENT_TYPE = 'sale'
AND TOKEN_ID IS NOT NULL
GROUP BY 1
ORDER BY VOLUME_apt DESC;
QueryRunArchived: QueryRun has been archived