flyingfishNFTx Daily Volume and Transaction Count
Updated 2022-06-10
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 total_sales as (
SELECT
project_name,
sum(price_usd) as total_volume,
COUNT(project_name) as total_txs
FROM ethereum.core.ez_nft_sales
WHERE platform_name = 'nftx'
AND block_timestamp >= CURRENT_DATE - 60
GROUP BY project_name
ORDER BY total_volume DESC
),
daily_sales as (
SELECT
project_name,
date_trunc('day', block_timestamp) as date,
sum(price_usd) as total_volume,
COUNT(project_name) as total_txs,
CASE
WHEN project_name IN (SELECT project_name FROM total_sales ORDER BY total_volume DESC LIMIT 5) THEN project_name
ELSE 'Not Top 5 Collections by Volume'
END AS volume_rank,
CASE
WHEN project_name IN (SELECT project_name FROM total_sales ORDER BY total_txs DESC LIMIT 5) THEN project_name
ELSE 'Not Top 5 Collections by Transaction Count'
END AS transaction_rank
FROM ethereum.core.ez_nft_sales
WHERE platform_name = 'nftx'
AND block_timestamp >= CURRENT_DATE - 60
GROUP BY project_name, date
ORDER BY total_volume DESC
)
SELECT
volume_rank,
date,
sum(total_volume) as volume
FROM daily_sales
Run a query to Download Data