SELECT date_trunc('day', block_timestamp) as date, address, asset_name, asset_id, amount / POW(10,6) as amount

FROM algorand.account_asset a INNER JOIN algorand.block b on a.asset_added_at = b.block_id

WHERE (asset_id = 31566704 OR asset_id = 312769) and amount > 0

, tiers as (

SELECT address,

CASE

WHEN amount < 10 THEN '<10'

WHEN amount >= 10 and amount <= 100 THEN '10-100'

WHEN amount >= 100 and amount <= 1000 THEN '100-1000'

WHEN amount >= 1000 and amount <= 10000 THEN '1000-10000'

WHEN amount >= 10000 and amount <= 100000 THEN '10000-100000'

WHEN amount >= 100000 and amount <= 1000000 THEN '100000-1000000'

WHEN amount >= 1000000 THEN '> 1000000'

END as tier

FROM assets

WHERE asset_name = 'Tether USDt'

SELECT tier, COUNT(DISTINCT address) as num_address

FROM tiers

GROUP BY 1