2844users who accumulating the OGs
    Updated 2022-03-30
    SELECT block_timestamp, instruction:parsed:info:source AS Holders
    FROM solana.fact_events
    WHERE block_timestamp >= '2022-02-05'
    AND instruction:parsed:info:mint = '4Hnh1UCC6HLzx9NaGKnTVHR2bANcRrhydumdHCnrT3i2'
    AND instruction:parsed:info:source in (SELECT fact_nft_sales.purchaser
    from solana.fact_nft_sales INNER JOIN solana.dim_nft_metadata

    WHERE fact_nft_sales.mint = dim_nft_metadata.mint
    AND fact_nft_sales.marketplace LIKE '%magic%'
    AND fact_nft_sales.succeeded = 'true'
    AND dim_nft_metadata.contract_name like '%Lightning%'
    AND fact_nft_sales.block_timestamp >= '2022-02-05'

    GROUP BY purchaser
    )

    Run a query to Download Data