crypto_edgar2024-05-19 09:38 PM
Updated 2024-05-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
1WITH MINT_NFTS AS (
SELECT
DISTINCT TX_ID, SIGNERS[2]
FROM
solana.core.fact_events
WHERE
BLOCK_TIMESTAMP >= '2023-03-25'
AND SUCCEEDED
AND ARRAY_SIZE(SIGNERS) = 3
AND SIGNERS [0] = '7k5qzD2LLJCchakNG9wu9G3AvyFP7eWXBk4WbqgQypm6'
AND PROGRAM_ID = 'updg8JyjrmFE2h3d71p71zRXDR8q4C6Up8dDoeq3LTM'
),
FILTERED_SAGA_GENESIS_MINTS AS (
SELECT
TX_ID
FROM
solana.nft.fact_nft_mints
WHERE
BLOCK_TIMESTAMP >= '2023-03-25'
AND TX_ID IN (
SELECT
TX_ID
FROM
MINT_NFTS
)
AND SUCCEEDED
)
-- SELECT
-- DISTINCT TX_ID, SIGNERS[2]
-- FROM
-- solana.core.fact_events
-- WHERE
-- BLOCK_TIMESTAMP >= '2023-03-25'
-- AND PROGRAM_ID = 'updg8JyjrmFE2h3d71p71zRXDR8q4C6Up8dDoeq3LTM'
-- AND SUCCEEDED
-- AND TX_ID IN (
QueryRunArchived: QueryRun has been archived