faralpaTop marketplaces Solana
Updated 2023-04-13Copy Reference Fork
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
›
⌄
with nfts_market as (
SELECT
distinct marketplace,
count(distinct tx_id) as tx_count,
count(distinct purchaser) as buyers
from
solana.core.fact_nft_sales
where
date(block_timestamp) between current_date()-61 and current_date()-1
group by marketplace
order by buyers DESC
limit 11
)
SELECT
date(block_timestamp) as date,
count(distinct tx_id) as tx_count,
count(distinct purchaser) as buyers,
marketplace
from
solana.core.fact_nft_sales
where
date(block_timestamp) between current_date()-61 and current_date()-1
and marketplace in (select distinct marketplace from nfts_market)
group by date,marketplace
Run a query to Download Data