commanderjoseph-761gwXJIto check 4
Updated 2024-10-22
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
›
⌄
⌄
/*SELECT
*
FROM
solana.core.fact_events
WHERE
tx_id = '5DEk5AfL62rT8yi5N6xiuGydREY9R38qssrhYTP6fU4jegXjCJrtV3tUYw6HwinJvnY6UKCaVQ8PwFfRUcPXUXfV'*/
SELECT
block_timestamp,
--date_trunc('hour', block_timestamp) as date,
tx_id,
address,
action,
amount / 1e9 as precise_amount,
token,
FROM solana.defi.fact_stake_pool_actions
where stake_pool = 'Jito4APyf642JPZPx3hGc6WWJ8zPKtRbRs4P815Awbb'
and
action = 'withdraw'
--(action = 'deposit' or action = 'withdraw')
and succeeded = 'true'
AND
block_timestamp > current_timestamp - interval '1 day'
LIMIT
150
QueryRunArchived: QueryRun has been archived