khanhNodes by RUNE Bond Group
Updated 2022-09-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH WALLETS as (
SELECT
SPLIT(SPLIT(TO_ADDRESS, ':')[9], '\n')[0] ADDRESS,
MAX(BLOCK_TIMESTAMP) AS BLOCK_TIMESTAMP
FROM flipside_prod_db.thorchain.bond_events
WHERE memo != ''
GROUP BY ADDRESS
)
SELECT
CASE WHEN (CAST(SPLIT(SPLIT(TO_ADDRESS, ':')[7], '\n')[0] AS INT) / POW(10, 8)) < 100000 THEN '< 100000'
WHEN (CAST(SPLIT(SPLIT(TO_ADDRESS, ':')[7], '\n')[0] AS INT) / POW(10, 8)) BETWEEN 100000 AND 500000 THEN 'BETWEEN 100000 AND 500000'
WHEN (CAST(SPLIT(SPLIT(TO_ADDRESS, ':')[7], '\n')[0] AS INT) / POW(10, 8)) BETWEEN 500000 AND 800000 THEN 'BETWEEN 500000 AND 800000'
WHEN (CAST(SPLIT(SPLIT(TO_ADDRESS, ':')[7], '\n')[0] AS INT) / POW(10, 8)) BETWEEN 500000 AND 1000000 THEN 'BETWEEN 800000 AND 1000000'
ELSE '> 1000000' END AS TOTAL_BALANCE,COUNT(*) AS NUM
FROM flipside_prod_db.thorchain.bond_events A
LEFT JOIN WALLETS
ON WALLETS.BLOCK_TIMESTAMP = A.BLOCK_TIMESTAMP
AND ADDRESS = SPLIT(SPLIT(TO_ADDRESS, ':')[9], '\n')[0]
GROUP BY TOTAL_BALANCE
ORDER BY NUM
Run a query to Download Data