flyingfishSOL Transfers OUT RAW
Updated 2023-01-07Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT *
-- block_timestamp
-- , tx_id
-- , signers
-- , instructions[0]:parsed:info:destination as receiver
-- , instructions[0]:parsed:info:lamports / pow(10,9) as lamports
-- , instructions[0]:parsed:type as tx_type
-- , instructions[0]:parsed:program as tx_program
FROM solana.core.fact_transactions
WHERE block_timestamp > '2022-06-01'
and signers[0] = 'FiSMbrZLnWkZ6RnnJtdkJiZeGgovCVeCwPRudJ6TdTJT'
AND instructions[0]:parsed:type = 'transfer'
AND instructions[0]:programId = '11111111111111111111111111111111'
ORDER BY block_timestamp
limit 3
Run a query to Download Data