strawbettyunique buyers/sellers over time on Magic Eden for the Lightning OGs since February 5th
    Updated 2022-04-05
    -- Friktion Lightning OGs
    -- Payout 0.54 SOL
    -- Grand Prize 1.62 SOL
    -- Level Beginner


    -- Q45. Friktion has a community NFT created for its loyal supporters called the Lightning OGs.
    -- How do these OG NFTs work?
    -- Create a visualization showing unique buyers/sellers over time on Magic Eden for the Lightning OGs since February 5th.
    -- Who is accumulating the OGs?
    -- What percentage of OG holders have made a deposit into the SOL covered call Friktion volt since February 5th?
    -- What are best utilities for NFTs across DeFi (cite other examples if you know any)? What are the most interesting ways
    -- to integrate the OGs into the upcoming roadmap of Friktion? What utility would make the most sense?


    -- Note: The most innovative idea can win a Lightning OG!
    -- Hint: https://twitter.com/friktion_labs/status/1489835576945745922
    -- Hint: use fact_nft_sales , dim_nft_metadata, and fact_events
    -- Hint: https://magiceden.io/marketplace/lightning_ogs
    -- Hint: https://docs.friktion.fi/
    -- Sample SOL deposit: https://solscan.io/tx/4Fv3HzL5atPYHRcEVzuPCu2MwHb7qEBzwroBbXLiFDzrADp9CuypCCVMuUjRR33FamrNYzkJSqvCbGiF9rPzjfM2
    -- Hint: SOL Covered Call Volt token mint: 4Hnh1UCC6HLzx9NaGKnTVHR2bANcRrhydumdHCnrT3i2"

    with og_txns as (
    select
    m.contract_name,
    s.*
    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'
    and marketplace ilike '%magic eden%'
    )


    select
    block_timestamp::date as date,
    Run a query to Download Data