andre4trader joe nft stats by collection
Updated 2024-09-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
35
36
›
⌄
WITH top_projects AS (
SELECT
project_name
FROM
avalanche.nft.ez_nft_sales
WHERE
platform_name = 'joepegs' and block_timestamp>='2024-01-01'
GROUP BY
project_name
ORDER BY
SUM(price_usd) DESC
LIMIT 10
),
joe as (
SELECT
DATE_TRUNC('week', block_timestamp) AS time,
project_name,
buyer_address,
tx_hash,
price_usd AS volume
FROM
avalanche.nft.ez_nft_sales
WHERE
DATE_TRUNC('week', block_timestamp) < DATE_TRUNC('week', CURRENT_DATE)
AND platform_name = 'joepegs'
AND project_name IN (SELECT project_name FROM top_projects)
),
alls AS (
SELECT
time,
project_name,
COUNT(DISTINCT tx_hash) AS sales,
COUNT(DISTINCT buyer_address) AS active_users,
SUM(volume) AS volume,
AVG(volume) AS avg_price
FROM joe
QueryRunArchived: QueryRun has been archived