VOLUME | AVG_VOLUME | BUYERS | SELLERS | NFT_SOLD | UNIQUE_NFT_SOLD | TRANSACTION | TOTAL_FEES | PLATFORM_FEES | CREATOR_FEE | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | 453217983.521552 | 77.569040214 | 437593 | 394355 | 5842769 | 25676 | 2464216 | 5917124.459934 | 3306966.0142389 | 2610158.44569509 |
SpecterSummary
Updated 2025-04-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
SUM(price_usd) as volume,
avg(price_usd) as avg_volume,
COUNT(distinct buyer_address) as buyers,
COUNT(distinct seller_address) as sellers,
COUNT(tokenid) as nft_sold,
COUNT(DISTINCT nft_address) AS Unique_nft_sold,
COUNT(distinct tx_hash) as transaction,
SUM(total_fees_usd) AS Total_fees,
SUM(platform_fee_usd) AS Platform_fees,
SUM(creator_fee_usd) AS Creator_fee,
FROM base.nft.ez_nft_sales
WHERE PLATFORM_NAME = 'opensea'
Last run: 22 days ago
1
117B
3s