t2 as (

select block_timestamp as day,

try_parse_json(args) as args,

args:proposal:kind:Transfer:receiver_id as receiver_id,

args:proposal:kind:Transfer:amount/1e24 as amount

from near.core.fact_actions_events_function_call

join near.core.fact_transactions

where method_name = 'add_proposal'

and tx_receiver = 'marketing.sputnik-dao.near'

date_trunc('week', day) as week,

receiver_id as receiver,

sum(amount) as transfer_volume,

avg(amount) as average_transfer_volume,

median(amount) as median_transfer_volume,

count(*) as proposals_count,

sum(transfer_volume) over (partition by receiver order by week) as cumulative_transfer_volume,

sum(proposals_count) over (partition by receiver order by week) as cumulative_proposals_count

from t2

group by 1, 2

having transfer_volume > 0

order by 1, 2