crypto_edgarPublic Sale Total Amount
Updated 2024-05-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
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'