ZSaed3. commen buyer and seller
Updated 2022-06-13
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
›
⌄
⌄
/*
Q8. Create a visualization showing NFT sales volume on Flow since May 9th.
Which NFT projects are trending on Flow right now
and what is the general trend of NFT sales over the last month?
Do the projects that are trending seem to have common wallets or is there not much crossover between buyers/sellers?
*/
with sales as (
select
TX_ID,
BUYER,
SELLER,
NFT_ID,
CURRENCY,
MARKETPLACE,
NFT_COLLECTION,
BLOCK_TIMESTAMP
from flow.core.fact_nft_sales
where BLOCK_TIMESTAMP::date BETWEEN '2022-05-09' and CURRENT_DATE-1
and TX_SUCCEEDED = TRUE
)
, top_ten as (
select
count(DISTINCT buyer) as num_buyer,
count(DISTINCT seller) as num_seller,
count(DISTINCT nft_id) as num_nft_id,
count(DISTINCT tx_id) as num_tx_id,
nft_collection
-- BLOCK_TIMESTAMP::date as date
from sales
group by nft_collection
order by num_tx_id DESC
Run a query to Download Data