amirozausers_deposited
    Updated 2022-05-03
    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