with users as

(select

block_timestamp::date as date,

origin_from_address as users,

round(round(raw_amount/1e18)) as amount_claimed,

case when round(raw_amount/1e18) = 777 then 'Optimism Users'

when round(raw_amount/1e18) = 2469 then 'Repeat Optimism Users'

when round(raw_amount/1e18) = 272 then 'DAO Voters'

when round(raw_amount/1e18) = 1190 then 'Multisig Signers'

when round(raw_amount/1e18) = 556 then 'Gitcoin Donors'

when round(raw_amount/1e18) = 409 then 'Users Priced Out of Ethereum'

else 'Overlap Bonuses' end as cat,

'214748364'::number as total_amount_airdroped,

'248699'::number as total_users_eligible

from optimism.core.fact_token_transfers

where origin_to_address = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'

and contract_address = '0x4200000000000000000000000000000000000042'

and origin_function_signature = '0x2e7ba6ef' )

select

date,

cat,

count(users) as users_count,

sum(amount_claimed) as amount

from users

group by 1,2