date_trunc('day', block_timestamp) as date,

count(distinct tx_hash) as tnx_count,

count(distinct signer_id) as unique_user,

count(post_image) as post_image,

count(post_text) as post_txt

near.social.fact_posts

group by

1

order by

1;