WITH active_addresses AS ( SELECT CASE WHEN USD_VALUE_LAST_ACTIVITY >= 1 AND USD_VALUE_LAST_ACTIVITY < 10 THEN '$1 TO $10' WHEN USD_VALUE_LAST_ACTIVITY >= 10 AND USD_VALUE_LAST_ACTIVITY < 100 THEN '$10 TO $100' WHEN USD_VALUE_LAST_ACTIVITY >= 100 AND USD_VALUE_LAST_ACTIVITY < 1000 THEN '$100 TO $1,000' WHEN USD_VALUE_LAST_ACTIVITY >= 1000 AND USD_VALUE_LAST_ACTIVITY < 10000 THEN '$1,000 TO $10,000' WHEN USD_VALUE_LAST_ACTIVITY >= 10000 AND USD_VALUE_LAST_ACTIVITY < 100000 THEN '$10,000 TO $100,000' WHEN USD_VALUE_LAST_ACTIVITY >= 100000 AND USD_VALUE_LAST_ACTIVITY < 1000000 THEN '$100,000 TO $1,000,000' WHEN USD_VALUE_LAST_ACTIVITY >= 1000000 THEN '$1,000,000 +' END AS holder_range, COUNT(DISTINCT USER_ADDRESS) AS transacting_address_count FROM ethereum.core.ez_current_balances WHERE CONTRACT_ADDRESS = '0xdac17f958d2ee523a2206206994597c13d831ec7' AND LAST_ACTIVITY_BLOCK_TIMESTAMP > CURRENT_TIMESTAMP - INTERVAL '24 HOURS' GROUP BY holder_range ), total_addresses AS ( SELECT holder_range, COUNT(*) AS total_address_count FROM ( SELECT USER_ADDRESS, 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 $1,000' WHEN USD_VALUE_NOW >= 1000 AND USD_VALUE_NOW < 10000 THEN '$1,000 TO $10,000' WHEN USD_VALUE_NOW >= 10000 AND USD_VALUE_NOW < 100000 THEN '$10,000 TO $100,000' WHEN USD_VALUE_NOW >= 100000 AND USD_VALUE_NOW < 1000000 THEN '$100,000 TO $1,000,000' WHEN USD_VALUE_NOW >= 1000000 THEN '$1,000,000 +' END AS holder_range FROM ethereum.core.ez_current_balances WHERE CONTRACT_ADDRESS = '0xdac17f958d2ee523a2206206994597c13d831ec7' ) sub GROUP BY holder_range ) SELECT total_addresses.holder_range, active_addresses.transacting_address_count, total_addresses.total_address_count, ( active_addresses.transacting_address_count * 100.0 / total_addresses.total_address_count ) AS transacting_address_share FROM total_addresses JOIN active_addresses ON total_addresses.holder_range = active_addresses.holder_range;

USDT on Ethereum