SELECT

SPLIT(SPLIT(TO_ADDRESS, ':')[9], '\n')[0] AS USER_ADDRESS,

max(BLOCK_TIMESTAMP) AS MAX_BLOCK_TIMESTAMP

FROM flipside_prod_db.thorchain.bond_events

WHERE memo is not NULL

GROUP BY USER_ADDRESS

SELECT

USER_ADDRESS,

CAST(SPLIT(SPLIT(TO_ADDRESS, ':')[7], '\n')[0] AS INT) / POW(10, 8) AS USER_BALANCE

FROM flipside_prod_db.thorchain.bond_events

JOIN WALLETS

ON MAX_BLOCK_TIMESTAMP = BLOCK_TIMESTAMP

WHERE USER_ADDRESS = SPLIT(SPLIT(TO_ADDRESS, ':')[9], '\n')[0]

HAVING USER_BALANCE > 100

LIMIT 20