barbodUntitled Query
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
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