crypto_edgarPublic Sale Total Amount
    Updated 2024-05-05
    SELECT
    COUNT(*) AS NR_PUBLIC_SALE_TICKETS_SOLD,
    COUNT(DISTINCT SIGNERS [0]) AS UNIQUE_WALLETS,
    NR_PUBLIC_SALE_TICKETS_SOLD * 0.1 AS AMOUNT_SOL
    FROM
    solana.core.fact_events
    WHERE
    BLOCK_TIMESTAMP >= '2024-04-06'
    AND BLOCK_TIMESTAMP <= '2024-04-21'
    AND SUCCEEDED
    AND PROGRAM_ID = 'TFCGs5oBAZmVNTsGWPMquE8uqXUtZt6zRY1LBxQs35G'
    AND SIGNERS [2] = 'AqaY1ZEFrZ5cPoEEHS48fPG4ctkrBweUKxWztqL2Y9Vj'
    AND INNER_INSTRUCTION:instructions[0]:parsed:type = 'transfer'
    AND INNER_INSTRUCTION:instructions[0]:parsed:info:lamports = 100000000
    -- AND INNER_INSTRUCTION:instructions[0]:parsed:info:destination = '5d9VwBbhwuqWbRiP5ujpUuieFmK6sfZtoqxeMUfZVnBF'