with inflow AS (

SELECT

transfer.block_timestamp,

transfer.tx_hash,

transfer.from_address,

transfer.amount,

transfer.amount_usd,

tx_fee

FROM ethereum.core.ez_native_transfers transfer

INNER JOIN ethereum.core.fact_transactions transaction ON(transaction.tx_hash = transfer.tx_hash)

WHERE transfer.to_address = '0x63ca00232f471be2a3bf3c4e95bc1d2b3ea5db92'

AND transfer.block_timestamp:: date >= '2024-07-12'

AND transaction.block_timestamp:: date >= '2024-07-12'

AND amount_usd IS NOT NULL

SELECT

(CASE

WHEN amount_usd < 50 THEN 'Less Than $50'

WHEN amount_usd >= 50 AND amount_usd < 100 THEN 'Between $50 & $100'

WHEN amount_usd >= 100 AND amount_usd < 250 THEN 'Between $100 & $250'

WHEN amount_usd >= 250 AND amount_usd < 500 THEN 'Between $250 & $500'

WHEN amount_usd >= 500 AND amount_usd < 1000 THEN 'Between $500 & $1000'

WHEN amount_usd >= 1000 AND amount_usd < 2000 THEN 'Between $1000 & $2000'

WHEN amount_usd >= 2000 THEN 'More Than $2000'

END ) AS label,

count(DISTINCT from_address) AS user,

SUM(amount) AS eth_amount,

SUM(amount_usd) AS usd_amount

FROM inflow

GROUP BY 1