par_rnTradeport 01
Updated 2024-12-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
DATE_TRUNC ('day',BLOCK_TIMESTAMP) AS date,
COUNT (DISTINCT TX_HASH) AS sales,
COUNT (DISTINCT BUYER_ADDRESS) AS buyers,
COUNT (DISTINCT SELLER_ADDRESS) AS sellers,
SUM (PRICE) AS volume,
SUM (PRICE_USD) AS volume_usd
FROM
near.nft.ez_nft_sales
WHERE
platform_name = 'TradePort'
AND
date >= current_date-30
GROUP BY 1
QueryRunArchived: QueryRun has been archived