primo_dataall_users
Updated 2022-07-12
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
31
32
›
⌄
-- Users
select dt, project, count(distinct usr) user_ct
from
(
select
date(t.block_timestamp) dt
, case when m.purchaser = 'GenoS3ck8xbDvYEZ8RxMG3Ln2qcyoAN8CTeZuaWgAoEA' then 'Genopets' when m.purchaser = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' then 'StepN' else 'Other' end project
, t.tx_to usr
from solana.core.fact_nft_mints m -- Ties Project to NFT
inner join solana.core.fact_transfers t -- Gets Transfers
on m.mint = t.mint
where m.succeeded = TRUE
and m.purchaser in ('GenoS3ck8xbDvYEZ8RxMG3Ln2qcyoAN8CTeZuaWgAoEA', 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK')
union ALL
select
date(t.block_timestamp) dt
, case when m.purchaser = 'GenoS3ck8xbDvYEZ8RxMG3Ln2qcyoAN8CTeZuaWgAoEA' then 'Genopets' when m.purchaser = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' then 'StepN' else 'Other' end project
, t.tx_from usr
from solana.core.fact_nft_mints m -- Ties Project to NFT
inner join solana.core.fact_transfers t -- Gets Transfers
on m.mint = t.mint
where m.succeeded = TRUE
and m.purchaser in ('GenoS3ck8xbDvYEZ8RxMG3Ln2qcyoAN8CTeZuaWgAoEA', 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK')
)
group by 1,2
Run a query to Download Data