ludicrousFact_transfers copy
Updated 2024-11-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
SELECT
TX_FROM AS source_address,
TX_TO AS destination_address,
BLOCK_TIMESTAMP,
TX_ID,
MINT,
CASE
WHEN TX_TO IS NOT NULL THEN 'INCOMING'
WHEN TX_FROM IS NOT NULL THEN 'OUTGOING'
ELSE 'UNKNOWN'
END AS transaction_type,
AMOUNT
FROM
solana.core.fact_transfers
WHERE
MINT IN (
'8sNn3aeKaWmqQjwKkusVuHHjQDhRLQGWKAzAHBaF9tan',
'6FuAe2ii6bQ4R6D68FLe6kXnvnHEdzsxKDmPY9fx3Qy2'
)
AND BLOCK_TIMESTAMP >= '2024-10-26'
ORDER BY
BLOCK_TIMESTAMP;
QueryRunArchived: QueryRun has been archived