with

sources as (

SELECT

trunc(block_timestamp,'day') as date,

--method_name as action,

project_name as source,

count(distinct tx_hash) as transactions,

sum(transactions) over (partition by source order by date) as cum_transactions,

sum(ATTACHED_GAS / power(10, 24)) as near_gas_spent,

sum(near_gas_spent) over (partition by source order by date) as total_near_gas_spent,

avg(ATTACHED_GAS / power(10, 24)) as avg_near_gas_spent

FROM near.core.fact_actions_events_function_call x

join near.core.dim_address_labels y on x.signer_id=y.address

WHERE (signer_id LIKE '%marbledao.near' or signer_id LIKE '%marbledex.near')

group by 1,2 order by 1 asc

select * from sources where source is not null order by 1 asc