AshlyCryptovoting power
Updated 2023-03-11
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
›
⌄
SELECT
CASE
when tx_to LIKE 'HgcYAkXFT1ENpUCjBZWc1TjAAFacUwdGZRNhTHx9cuo' then tx_from
else tx_to
end as wallet,
sum(
CASE
when tx_to LIKE 'HgcYAkXFT1ENpUCjBZWc1TjAAFacUwdGZRNhTHx9cuo' then amount
else -1 * amount
end
) AS deposit_ballance
FROM
solana.core.fact_transfers
WHERE
(
tx_to LIKE 'HgcYAkXFT1ENpUCjBZWc1TjAAFacUwdGZRNhTHx9cuo'
OR tx_from LIKE 'HgcYAkXFT1ENpUCjBZWc1TjAAFacUwdGZRNhTHx9cuo'
)
AND mint LIKE 'BWXrrYFhT7bMHmNBFoQFWdsSgA3yXoAnMhDK6Fn1eSEn'
GROUP BY
1
HAVING
DEPOSIT_BALLANCE > 0
ORDER BY
deposit_ballance DESC
Run a query to Download Data