crypto_edgar2023-12-12 09:49 PM
    Updated 2023-12-12
    WITH WOLF_CAPITAL_NFTS AS (
    SELECT
    MINT
    FROM
    solana.nft.dim_nft_metadata
    WHERE
    COLLECTION_ID = '5ucdKHbPfmsWowXSNfHoiYEJ55kfFmvEdHii5RtjHpiH'
    ),
    FROZEN_WOLVES AS (
    SELECT
    BLOCK_TIMESTAMP,
    TX_ID,
    SIGNERS [0] as WALLET
    FROM
    solana.core.fact_events
    WHERE
    SUCCEEDED
    AND BLOCK_TIMESTAMP >= '2023-07-01'
    AND PROGRAM_ID = 'metaqbxxUerdq28cj1RbAWkYQm3ybzjb6a8bt518x1s'
    AND INSTRUCTION:data = 'T'
    AND INSTRUCTION:accounts [3] IN (
    SELECT
    MINT
    FROM
    WOLF_CAPITAL_NFTS
    )
    )

    SELECT COUNT(TX_ID), WALLET
    from FROZEN_WOLVES
    GROUP BY WALLET
    Run a query to Download Data