PROJECT_NAME | SALES_LAST_30_DAYS_USD | TRANSACTIONS_LAST_30_DAYS | ALL_TIME_SALES_USD | ALL_TIME_TRANSACTIONS | |
---|---|---|---|---|---|
1 | HatchyPocket | 281.0537 | 17 | 11601.533619031 | 1048 |
2 | HatchyPocket Gen2 | 1482.319844 | 186 | 50866.132060475 | 7207 |
3 | HatchyPocket Gen2 Eggs | 26.3143 | 4 | 2748.17497958 | 493 |
crypto_gostTotal sale
Updated 2024-12-17
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 recent_sales AS (
SELECT
project_name,
SUM(price_usd) AS total_sales_usd,
COUNT(*) AS total_transactions
FROM
AVALANCHE.nft.ez_nft_sales
WHERE
project_name ILIKE '%HatchyPocket%';
AND block_timestamp >= DATEADD(DAY, -30, CURRENT_TIMESTAMP)
AND event_type = 'sale'
GROUP BY
project_name
),
all_time_sales AS (
SELECT
project_name,
SUM(price_usd) AS total_sales_usd,
COUNT(*) AS total_transactions
FROM
AVALANCHE.nft.ez_nft_sales
WHERE
project_name ILIKE '%HatchyPocket%'
AND event_type = 'sale'
GROUP BY
project_name
)
SELECT
rs.project_name,
rs.total_sales_usd AS sales_last_30_days_usd,
rs.total_transactions AS transactions_last_30_days,
ats.total_sales_usd AS all_time_sales_usd,
ats.total_transactions AS all_time_transactions
FROM
recent_sales rs
JOIN
Last run: 2 months ago
3
165B
2s