TOTAL_FEE | TOTAL_USERS | TOTAL_SALES_VOLUME | SALES_COUNT | TOTAL_NFT_SOLD | AVG_PRICE_PER_NFT | |
|---|---|---|---|---|---|---|
1 | 616370.599182498 | 80573 | 20102728.5360826 | 588563 | 59499 | 34.155610421 |
fidamAggregate
Updated 2025-01-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
With Ava AS(
SELECT
Sum (TOTAL_FEES) as Total_fee,
Count(DISTINCT Origin_From_Address) as Total_Users,
Sum(PRICE_USD) as Total_Sales_volume,
Count(EZ_NFT_SALES_ID) as Sales_Count,
Count(DISTINCT SELLER_ADDRESS) as Total_Nft_Sold
From avalanche.nft.ez_nft_sales
)
SELECT *,
Total_Sales_volume/Sales_Count as Avg_Price_per_NFt
From Ava
Last run: 3 months ago
1
69B
3s