mmdrezaAverage Like
Updated 2023-05-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with tab as (select
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)
select
avg(likes) as avg_likes,
avg(users) as avg_users
from tab
Run a query to Download Data