HitmonleeCryptotry all
Updated 2024-07-01
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
›
⌄
SELECT
-- SUM(e.swap_from_amount_usd) AS total_limit_swap_from_amount_usd
t.block_timestamp, tr.tx_to, tr.tx_from, t.instruction, t.inner_instruction, e.swapper, e.swap_from_amount_usd, e.swap_to_amount_usd, t.tx_id
FROM
solana.core.fact_events t
JOIN
solana.defi.ez_dex_swaps e ON t.tx_id = e.tx_id
JOIN
solana.core.fact_transfers tr ON t.tx_id = tr.tx_id
WHERE
-- e.swapper = '{{Address}}'
-- instruction:programid[0] = 'jupoNjAxXgZ4rjzxzPMP4oxduvQsQtZzyknqvzYNrNu'
--or instruction:programid[1] = 'jupoNjAxXgZ4rjzxzPMP4oxduvQsQtZzyknqvzYNrNu'
-- or instruction:programid[2] = 'jupoNjAxXgZ4rjzxzPMP4oxduvQsQtZzyknqvzYNrNu'
-- or instruction:programid[3] = 'jupoNjAxXgZ4rjzxzPMP4oxduvQsQtZzyknqvzYNrNu'
-- instruction:accounts[2]
('{{Address}}' = instruction:accounts[2] OR '{{Address}}' = instruction:accounts[4])
and
tr.tx_to = '{{Address}}'
and t.instruction:programId IN ('jupoNjAxXgZ4rjzxzPMP4oxduvQsQtZzyknqvzYNrNu', 'j1o2qRpjcyUwEvwtcfhEQefh773ZgjxcVRry7LDqg5X')
-- and
-- tx_id = '3ikSf4Fp15ADXcp7X8fNgtXxUqW7Jku53cL99vgn6XRtZtKkffQtnkHof9NqiYA3DFpJUoNdcQd5LSjCbDsb4w3g'
-- AND block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '272 HOURS'
-- LIMIT 20;
QueryRunArchived: QueryRun has been archived