Afonso_DiazTotal data
Updated 2024-10-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
›
⌄
WITH daily_stats AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS day,
COUNT(tx_hash) AS daily_sales_transactions,
COUNT(DISTINCT seller_address) AS daily_unique_sellers,
COUNT(DISTINCT buyer_address) AS daily_unique_buyers
FROM
aptos.nft.ez_nft_sales
WHERE
project_name = 'Pixel Pirates'
GROUP BY
1
)
SELECT
COUNT(tx_hash) AS total_sales_transactions,
COUNT(DISTINCT seller_address) AS total_sellers,
COUNT(DISTINCT buyer_address) AS total_buyers,
SUM(total_price) AS total_sales_volume_apt,
SUM(total_price_usd) AS total_sales_volume_usd,
SUM(creator_fee_usd) AS total_creator_fee_usd,
AVG (total_price) as Average_sales_volume_apt,
AVG(ds.daily_sales_transactions) AS avg_sales_transactions_per_day,
AVG(ds.daily_unique_buyers) AS avg_buyers_per_day
FROM
aptos.nft.ez_nft_sales
LEFT JOIN
daily_stats ds
ON
DATE_TRUNC('day', aptos.nft.ez_nft_sales.block_timestamp) = ds.day
WHERE
project_name = 'Pixel Pirates'
QueryRunArchived: QueryRun has been archived