crypto_edgarNr Wins Per Wallet
    Updated 2024-05-19
    WITH STEPN_SAGA_BADGE_MINTS AS (
    SELECT
    TX_ID,
    INSTRUCTION:accounts [0] AS WALLET_MINTED_TO,
    SIGNERS [1] AS MINT
    FROM
    solana.core.fact_events
    WHERE
    SUCCEEDED
    AND BLOCK_TIMESTAMP BETWEEN '2024-05-16 10:09:00'
    AND '2024-05-16 10:30:00'
    AND PROGRAM_ID = 'metaqbxxUerdq28cj1RbAWkYQm3ybzjb6a8bt518x1s'
    AND INSTRUCTION:accounts [1] = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
    ),
    STEPN_SAGA_BADGE_RECIPIENTS AS (
    SELECT
    BLOCK_TIMESTAMP,
    TX_ID,
    MINT,
    TX_TO
    FROM
    solana.core.fact_transfers
    WHERE
    BLOCK_TIMESTAMP BETWEEN '2024-05-16 10:12:00'
    AND '2024-05-16 10:45:00'
    AND MINT IN (
    SELECT
    MINT
    FROM
    STEPN_SAGA_BADGE_MINTS
    )
    AND TX_FROM = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
    ),
    STEPN_SAGA_BADGES_WON_PER_RECIPIENT AS (
    SELECT
    TX_TO,
    QueryRunArchived: QueryRun has been archived