strawbettypercentage of OG holders have made a deposit into the SOL covered call Friktion volt
    Updated 2022-04-05

    with
    og_txns as (
    select purchaser
    from solana.fact_nft_sales s
    join solana.dim_nft_metadata m on s.mint = m.mint and m.contract_name = 'Lightning OG'
    where block_timestamp >= '2022-02-05'
    ),
    deposit_txns as (
    select inner_instruction:instructions[3]:parsed:info:owner as wallet
    from solana.events e
    where block_timestamp >='2022-02-05'
    and inner_instruction:instructions[3]:parsed:info:mint = '4Hnh1UCC6HLzx9NaGKnTVHR2bANcRrhydumdHCnrT3i2'
    and inner_instruction:instructions[3]:parsed:info:owner in (select distinct purchaser from og_txns)
    )

    select
    (select count(distinct purchaser) from og_txns) as n_og,
    (select count(distinct wallet) from deposit_txns) as n_volt,
    100* n_volt/n_og as volt_pct
    Run a query to Download Data