address,

date,

sum(balance_usd) AS BALANCE

FROM terra.daily_balances

WHERE date = CURRENT_DATE() AND BALANCE >= 50000

GROUP BY date, address),

ANCHOR_CONTRACTS AS (SELECT

*

FROM terra.labels

WHERE label::string = 'anchor'

ORDER BY label_type DESC)

SELECT

count(distinct msg_value:sender::string) as whale_count

FROM terra.msgs m

INNER JOIN WHALES w

ON m.msg_value:sender::string = w.address

INNER JOIN ANCHOR_CONTRACTS ac

ON ac.address = m.msg_value:contract;