crypto_edgar2023-10-22 08:04 PM
Updated 2023-11-02
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
›
⌄
-- SELECT *
-- FROM solana.core.fact_transfers
-- WHERE DATE_TRUNC('Day', BLOCK_TIMESTAMP) = '2023-10-12'
-- AND TX_ID = '5iaXL93kMno9enXwXP9U2qS3JAzhKtit5zTZtXnrJGQRRhP9GZzLgQz6JvpaF5ZGHyNbNU8NxT2VPaQX1TjLfVF8'
-- -- GROUP BY TX_ID, MINT
-- -- HAVING INDEX = MAX(INDEX)
-- WITH MaxIndexCTE AS (
-- SELECT
-- TX_ID,
-- -- Replace with your actual unique identifier column
-- INDEX,
-- ROW_NUMBER() OVER (
-- PARTITION BY TX_ID
-- ORDER BY
-- INDEX DESC
-- ) AS RowNum
-- FROM
-- solana.core.fact_transfers -- Replace with the actual table name
-- WHERE
-- BLOCK_TIMESTAMP >= '2023-10-20'
-- AND MINT = '63D7r8VRZkSa8U3BEn6EF5wozHFXd9DCMQjCWm3qGhdc'
-- )
-- SELECT
-- t.*,
-- m.RowNum
-- FROM
-- solana.core.fact_transfers t
-- JOIN MaxIndexCTE m ON t.TX_ID = m.TX_ID
-- WHERE
-- m.RowNum = 1
-- AND BLOCK_TIMESTAMP >= '2023-10-20'
-- AND MINT = '63D7r8VRZkSa8U3BEn6EF5wozHFXd9DCMQjCWm3qGhdc' -- SELECT *
-- -- FROM MaxIndexCTE
SELECT
DISTINCT TX_ID,
MINT,
Run a query to Download Data