date_trunc('day',block_timestamp) as date,

count(distinct tx_hash) as Likes,

count(distinct signer_id) as users

from near.social.fact_decoded_actions

where node_data like '%like%'

group by 1

order by 1 asc