select distinct origin_from_address as unique_address

from optimism.core.fact_event_logs

)

select count(distinct origin_from_address) as total_address,

case when lower(event_name) like ('%swap%') then 'Swapping'

-- when lower(event_name) like ('%sign%') then 'Signing'

when lower(event_name) like ('%deposit%') then 'Deposit'

when lower(event_name) like ('%withdraw%') then 'Withdrawal'

when lower(event_name) like ('%liquidity%') then 'Staking/Unstaking' -- Most likely to be add_liquidity

when lower(event_name) like ('%stake%') then 'Staking/Unstaking'

when lower(event_name) like ('%mint%') then 'Minting'

when lower(event_name) like ('%transfer%') then 'Transferring'

else 'Other Activity' end as type

from optimism.core.fact_event_logs

join meta_addr on origin_from_address = unique_address

-- join ethereum.core.dim_function_signatures on origin_function_signature = bytes_signature

-- where block_timestamp::date >= '2022-01-01'

group by type