select to_address, raw_amount / pow(10,18) as amount FROM

optimism.core.fact_token_transfers

where block_timestamp > '2023-02-09'

and from_address = lower('0x2501c477D0A35545a387Aa4A3EEe4292A9a8B3F0')

and contract_address = lower('0x4200000000000000000000000000000000000042')

,bins as (

select

floor(amount/10.00)*10 as bin_floor,

count(to_address) as count

from alldrops

group by 1

order by 1

-- same query as above, just in a CTE

bin_floor,

bin_floor || ' - ' || (bin_floor + 10) as bin_range,

count

from bins

where bin_floor < 500

order by 1;