when amount BETWEEN 10 and 100 then '$10 - $100'

when amount BETWEEN 100 and 500 then '$100 - $500'

when amount BETWEEN 500 and 1000 then '$500 - $1K'

when amount BETWEEN 1000 and 5000 then '$1K - $5K'

when amount BETWEEN 5000 and 10000 then '$5K - $10K'

when amount BETWEEN 10000 and 20000 then '$10K - $20K'

when amount BETWEEN 20000 and 100000 then '$20K - $100K'

else 'more than $100K'

end as range ,

count (DISTINCT tx_hash) num_bridges_ ,

count (DISTINCT origin_FROM_ADDRESS ) num_wallets_

from ethereum.core.ez_token_transfers

where SYMBOL = 'DAI'

AND ORIGIN_TO_ADDRESS = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1' -- Optimistm to Ethereum

group by 1