crypto_edgarTest
Updated 2023-10-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
BLOCK_TIMESTAMP,
TX_ID,
INSTRUCTION:accounts [10] AS NFT_ADDRESS,
ARRAY_SIZE(INNER_INSTRUCTION:instructions) AS NR_INSTRUCTIONS
FROM
solana.core.fact_events
WHERE
BLOCK_TIMESTAMP BETWEEN '2023-09-12'
AND CURRENT_TIMESTAMP
AND PROGRAM_ID = 'LUCK57mxzZiRGF2PdHAY79P6tZ8Apsi381tKvBrTdqk'
AND INSTRUCTION:data LIKE 'mRczHuvKRb%'
AND NR_INSTRUCTIONS > 1
ORDER BY NR_INSTRUCTIONS ASC
Run a query to Download Data