select

floor(c.balance/100.00)*100 as min_balance,

count(c.wallet) as count

from

(

SELECT b.address as wallet, b.balance as balance

FROM

(

SELECT DISTINCT event_from

FROM terra.transfers

WHERE date_trunc ('day', block_timestamp) = CURRENT_DATE -90

AND tx_status = 'SUCCEEDED'

) a

LEFT JOIN

(

SELECT address,

COALESCE(address_label_subtype,'no_labeled') as address_label_subtype,

sum(balance) as balance

FROM terra.daily_balances

WHERE currency = 'LUNA'

AND date = '2022-02-01'

GROUP BY address, address_label_subtype

) b

on a.event_from = b.address

WHERE b.address_label_subtype NOT LIKE '%contract%'

AND b.address_label_subtype != 'staking'

AND b.address_label_subtype != 'mints_burns'

AND b.address_label_subtype != 'mint_burn'

AND b.address_label_subtype != 'validator'

AND b.address_label_subtype != 'memo_hot_wallet'

AND b.address_label_subtype != 'hot_wallet'

AND b.address_label_subtype != 'bridge'

AND b.address_label_subtype != 'pool'

AND balance >= 100