amirozausers_deposited
Updated 2022-05-03
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
›
⌄
with sol_covered_call as
(select distinct INSTRUCTION:parsed:info:source wallets
from solana.events
where INSTRUCTION:parsed:info:mint ='Hnh1UCC6HLzx9NaGKnTVHR2bANcRrhydumdHCnrT3i2'
and INSTRUCTION:parsed:info:mint is not null
and EVENT_TYPE='create'
and date_trunc('day',block_timestamp) >= '2022-02-05')
,cte2 as (
select count(distinct s.purchaser) users_deposited
from solana.fact_nft_sales s
inner join solana.dim_nft_metadata m on s.mint = m.mint
where date_trunc('day',s.block_timestamp) >= '2022-02-05'
and s.SUCCEEDED='TRUE'
and s.MARKETPLACE like '%magic%'
and m.contract_name ='Lightning OG'
and s.purchaser in (select wallets from sol_covered_call)
),cte3 as (
select count(distinct s.purchaser) total_users
from solana.fact_nft_sales s
inner join solana.dim_nft_metadata m on s.mint = m.mint
where date_trunc('day',s.block_timestamp) >= '2022-02-05'
and s.SUCCEEDED='TRUE'
and s.MARKETPLACE like '%magic%'
and m.contract_name ='Lightning OG'
)
select cte2.users_deposited/cte3.total_users users_deposited
from cte2,cte3
Run a query to Download Data