barbodusage
Updated 2022-04-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with t1 as(select
purchaser,
sum(sales_amount) as volume_sale
from solana.fact_nft_sales
where marketplace='magic eden v1'
and block_timestamp between '2022-03-01' and '2022-04-01' and succeeded='TRUE'
group by 1
order by 2 desc limit 20)
select
date_trunc('day',block_timestamp) as dt,
purchaser,
s.mint,
b.label as nft,
count(b.label) as usage
from solana.fact_nft_sales s LEFT OUTER JOIN Solana.dim_labels b ON s.mint = b.address
where marketplace='magic eden v1'
and purchaser in (select purchaser from t1)
and block_timestamp between '2022-03-01' and '2022-04-01' and succeeded='TRUE'
group by 1,2,3,4 having nft is not null
--order by 4 desc
Run a query to Download Data