select

tx_hash,

block_timestamp,

signer_id,

node,

parse_json(node_data:comment) as jsona_comment,

parse_json(node_data:comment):item:path as jsona_item_path

from near.social.fact_decoded_actions

join near.core.fact_transactions using(tx_hash)

where tx_status = 'Success'

and node = 'post'

and jsona_comment is not null

and jsona_item_path is not null

select

date_trunc('day', block_timestamp) as "Date",

count(distinct tx_hash) as "Total Number of Comments",

sum("Total Number of Comments") over (order by "Date") as "Cumulative Number of Comments"

from add_comment_list

group by "Date"