active_addresses AS (

SELECT DISTINCT

COALESCE(FROM_ADDRESS, TO_ADDRESS) AS address

FROM

ethereum.core.ez_token_transfers

WHERE

CONTRACT_ADDRESS = '0xdac17f958d2ee523a2206206994597c13d831ec7'

AND BLOCK_TIMESTAMP >= CURRENT_DATE() - INTERVAL '1 DAY'

),

address_ranges AS (

SELECT

CASE

WHEN USD_VALUE_NOW >= 1

AND USD_VALUE_NOW < 10 THEN '1 TO 10'

WHEN USD_VALUE_NOW >= 10

AND USD_VALUE_NOW < 100 THEN '10 TO 100'

WHEN USD_VALUE_NOW >= 100

AND USD_VALUE_NOW < 1000 THEN '100 TO 1000'

WHEN USD_VALUE_NOW >= 1000

AND USD_VALUE_NOW < 10000 THEN '1000 TO 10000'

WHEN USD_VALUE_NOW >= 10000

AND USD_VALUE_NOW < 100000 THEN '10000 TO 100000'

WHEN USD_VALUE_NOW >= 100000

AND USD_VALUE_NOW < 1000000 THEN '100000 TO 1000000'

ELSE '1000000+'

END AS holder_range,

USER_ADDRESS

FROM

ethereum.core.ez_current_balances

WHERE

USD_VALUE_NOW > 1

AND CONTRACT_ADDRESS = '0xdac17f958d2ee523a2206206994597c13d831ec7'

),

active_addresses_0_1 AS (

SELECT