date_trunc('week', block_timestamp) as date,

count(distinct t.tx_hash) as transactions,

sum(transactions) over (

order by

date

) as cummulative_transactions,

count(distinct signer_id) as Users,

sum(Users) over (

order by

date

) as cummulative_users,

sum(transaction_fee / power(10, 24)) as transaction_fees,

sum(transaction_fees) over (

order by

date

) as cummulative_transaction_fees

near.social.fact_decoded_actions

left outer join near.core.dim_address_labels on signer_id = address

left outer join near.core.fact_transactions t using (tx_hash)

tx_status = 'Success'

GROUP BY

1

ORDER BY

1;