HitmonleeCryptoDCA Summer
Updated 2024-06-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
⌄
SELECT sum(swap_from_amount_USD) as total_DCA
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 'DCA%'
/* 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 s
INNER JOIN solana.core.fact_transfers AS t
ON t.tx_id = s.tx_id
WHERE s.tx_id = '3G458kxx69ZvQAhrUHjPdagWKhA7NKdbRtmmekVP9yvawo84g1aDAoH7MCLt5SBxkFcBcKek5fqyYxzjqe3PwbF'
AND t.TX_TO = '3rVz2ZQr5vpSZK7cAyxq6uBg4JpyLLoshShRjgh3WDEe'
and swapper = 'DCAKuApAuZtVNYLk3KTAVW9GLWVvPbnb5CxxRRmVgcTr' */
QueryRunArchived: QueryRun has been archived