fantacollectionsovertime
Updated 2022-04-09
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
›
⌄
with top20wallets as (select top 20 sum(sales_amount) as sales_amount , purchaser as wallet from solana.fact_nft_sales
where block_timestamp::date >='2022-03-01' and
(MARKETPLACE='magic eden v1' or MARKETPLACE ='magic eden v2')
group by wallet
order by sales_amount desc
)
, selling as (select count(1) as number , nft.purchaser as wallet from solana.fact_nft_sales as nft inner join top20wallets
on nft.purchaser=top20wallets.wallet
where nft.block_timestamp::date >='2022-03-01'
and (MARKETPLACE='magic eden v1' or MARKETPLACE ='magic eden v2')
group by nft.purchaser
order by number desc)
, collections as (
select count(1) as number , token_name from solana.fact_nft_sales as nft inner join top20wallets
on nft.purchaser=top20wallets.wallet
inner join solana.dim_nft_metadata as dnft on nft.mint=dnft.mint
where nft.block_timestamp::date >='2022-03-01'
and (MARKETPLACE='magic eden v1' or MARKETPLACE ='magic eden v2')
group by token_name
order by number desc
)
,collectionsovertime as(
select count(1) as number , nft.block_timestamp::date as nftdate,token_name from solana.fact_nft_sales as nft inner join top20wallets
on nft.purchaser=top20wallets.wallet
inner join solana.dim_nft_metadata as dnft on nft.mint=dnft.mint
where nft.block_timestamp::date>='2022-03-01'
and (MARKETPLACE='magic eden v1' or MARKETPLACE ='magic eden v2')
and token_name in ( select token_name from collections)
group by nftdate,token_name)
select * from collectionsovertime
Run a query to Download Data