select

date_trunc('day',block_timestamp) as date,

count(distinct tx_hash) as follow

from near.social.fact_decoded_actions

where node_data:graph ilike '%follow%'

group by 1

),

unfollow as (

select

date_trunc('day',block_timestamp) as day,

count(distinct tx_hash) as Unfollow

from near.social.fact_decoded_actions

where node_data:graph ilike '%unfollow%'

group by 1

select

avg(follow),

avg(unfollow)

from follow,unfollow