bins as (

SELECT

COUNT(distinct from_address) as count_size,

floor(ethereum.public.udf_hex_to_int(data)/POW(10,18)/{{bin_size}})*{{bin_size}} as bin_floor,

'OP' as token

FROM

optimism.core.fact_event_logs

INNER JOIN

optimism.core.fact_transactions

USING (TX_HASH)

WHERE

contract_address = '0x4200000000000000000000000000000000000042'

AND topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'

AND topics[1] = '0x000000000000000000000000fedfaf1a10335448b7fa0268f56d2b44dbd357de'

group by bin_floor, token

order by bin_floor

)

bin_floor,

bin_floor || ' - ' || (bin_floor + {{bin_size}}) as bin_range,

count_size,

count_size/(SELECT

COUNT(distinct from_address)

FROM

optimism.core.fact_event_logs

INNER JOIN

optimism.core.fact_transactions

USING (TX_HASH)

WHERE

contract_address = '0x4200000000000000000000000000000000000042'

AND topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'

AND topics[1] = '0x000000000000000000000000fedfaf1a10335448b7fa0268f56d2b44dbd357de') * 100 as pct_size,

token

from bins

order by bin_floor