select date_trunc('day', block_timestamp) as "Day", count(*) as "No. of stable" from optimism.velodrome.ez_staking_actions

where pool_type = 'stable'

and staking_action_type = 'deposit'

group by 1

),

b as (

select date_trunc('day', block_timestamp) as "Day", count(*) as "No. of volatile" from optimism.velodrome.ez_staking_actions

where pool_type = 'volatile'

and staking_action_type = 'deposit'

group by 1

select a."Day", a."No. of stable" , b."No. of volatile"

from a inner join b on a."Day" = b."Day"