NUM_SALES | NUM_PURCHASERS | NUM_SELLERS | TOTAL_FEES | TOTAL_CREATORS_FEE | TOTAL_WAPAL_FEE | AVG_SALES_PER_DAY | AVG_SALES_PER_BUYER | AVG_SALES_PER_SELLER | SALES_VOLUME | AVG_VOLUME_PER_TXN | AVG_VOLUME_PER_BUYER | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 630618 | 277452 | 206723 | 161400.375919318 | 120191.764891479 | 41208.61102784 | 0.816951 | 2.27289 | 3.050546 | 2747241.45973218 | 4.356427282 | 9.901681948 |
saeedmzn[Wapal NFT marketplace on Aptos] - total
Updated 2025-03-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
--Wapal
select
count (DISTINCT tx_hash) num_sales ,
count (DISTINCT BUYER_ADDRESS ) num_purchasers ,
count (DISTINCT SELLER_ADDRESS) num_sellers ,
sum (TOTAL_FEES_USD) total_fees ,
sum (CREATOR_FEE_USD) Total_creators_fee ,
sum (PLATFORM_FEE_USD) Total_Wapal_fee ,
num_sales/count (BLOCK_TIMESTAMP::date) avg_sales_per_day,
num_sales/num_purchasers avg_sales_per_buyer,
num_sales/num_sellers avg_sales_per_seller ,
sum (TOTAL_PRICE_USD) sales_volume ,
sales_volume/num_sales avg_volume_per_txn,
sales_volume/num_purchasers avg_volume_per_buyer
from aptos.nft.ez_nft_sales
where platform_name ='Wapal'
Last run: about 1 month ago
1
140B
2s