par_rnMercato 03
Updated 2024-11-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
PROJECT_NAME AS "Collection",
SUM (TOTAL_PRICE_USD) AS volume
FROM
aptos.nft.ez_nft_sales
WHERE
PLATFORM_NAME = 'Mercato'
AND
BLOCK_TIMESTAMP :: date >= current_date -30
AND
PROJECT_NAME is not NULL
GROUP BY
1
ORDER BY
volume DESC
LIMIT
5
QueryRunArchived: QueryRun has been archived