par_rnMercato 04
Updated 2024-11-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT
DISTINCT BUYER_ADDRESS AS buyers,
COUNT (DISTINCT tx_hash) AS sales,
SUM (TOTAL_FEES_USD) AS fees_usd,
SUM (PLATFORM_FEE_USD) AS Mercato_fee_usd,
SUM (TOTAL_PRICE_USD) AS volume_usd
FROM
aptos.nft.ez_nft_sales
WHERE
platform_name = 'Mercato'
AND BLOCK_TIMESTAMP :: date >= current_date -30
GROUP BY
1
ORDER BY
volume_usd DESC
LIMIT
10
QueryRunArchived: QueryRun has been archived