headitmanagerunique wallet purchases chart
Updated 2022-03-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with degods_mint as
(
select distinct mint from solana.dim_nft_metadata where token_name='DeGods'
)
, degods_purchaser as
(
select sum(sales_amount) as amount,purchaser
from
solana.fact_nft_sales
inner join degods_mint
on solana.fact_nft_sales.mint=degods_mint.mint
where
block_timestamp::date >= '2022-01-01'
and program_id in ('MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8','M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K')
group by purchaser
)
select * from degods_purchaser
Run a query to Download Data