par_rnTradeport 02
Updated 2024-12-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT
DISTINCT BUYER_ADDRESS AS buyers,
COUNT (DISTINCT tx_hash) AS sales,
SUM (PRICE_USD) AS volume_usd
FROM
near.nft.ez_nft_sales
WHERE
platform_name = 'TradePort'
AND BLOCK_TIMESTAMP :: date >= current_date -30
GROUP BY
1
ORDER BY
volume_usd DESC
LIMIT
20
QueryRunArchived: QueryRun has been archived