HitmonleeCryptoJUP All 3 Vol Sum
Updated 2024-06-27
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
›
⌄
SELECT sum(swap_from_amount_USD) as total_limit
FROM solana.defi.ez_dex_swaps AS s
INNER JOIN solana.core.fact_transfers AS t
ON t.tx_id = s.tx_id
WHERE
t.TX_TO = '3rVz2ZQr5vpSZK7cAyxq6uBg4JpyLLoshShRjgh3WDEe'
and swapper ILIKE 'j1%'
SELECT t.block_timestamp, t.tx_id, t.tx_from, t.tx_to, s.swapper, s.swap_from_amount_usd, s.swap_to_amount_usd
FROM solana.defi.ez_dex_swaps AS {{Address}}
ON t.tx_id = s.tx_id
WHERE s.tx_id = '3G458kxx69ZvQAhrUHjPdagWKhA7NKdbRtmmekVP9yvawo84g1aDAoH7MCLt5SBxkFcBcKek5fqyYxzjqe3PwbF'
AND t.TX_TO = '3rVz2ZQr5vpSZK7cAyxq6uBg4JpyLLoshShRjgh3WDEe'
and swapper = 'DCAKuApAuZtVNYLk3KTAVW9GLWVvPbnb5CxxRRmVgcTr' '
AND t.tx_to LIKE '{{Address}}'
AND swap_program ILIKE '%jupiter%'
)
SELECT
'{{Address}}' as swapper,
COALESCE(first_total.total, 0) +
COALESCE(second_total.total_DCA, 0) +
COALESCE(third_total.total_limit, 0) as Total_Volume
FROM
(SELECT '{{Address}}' as swapper) as addr
LEFT JOIN first_total ON true
LEFT JOIN second_total ON true
LEFT JOIN third_total ON true;
QueryRunArchived: QueryRun has been archived