Arkangas 4
    Updated 2023-01-01
    with
    table1 as (
    select
    tx_receiver as Contract,
    sum (transaction_fee) / 1e24 as tx_feee,
    sum (gas_used) / 1e12 as TX_Gass
    from
    near.core.fact_transactions
    where block_timestamp >= '2022-01-01'
    group by 1
    order by 3 desc
    limit 10
    )
    select
    date_trunc(week,block_timestamp) as date,
    tx_receiver as Contract,
    sum (transaction_fee) / 1e24 as tx_feee,
    sum (gas_used) / 1e12 as TX_Gass,
    sum (TX_Gass) over (partition by Contract order by date) as Cumulative_TX_Gass
    from
    near.core.fact_transactions
    where tx_receiver in (select Contract from table1)
    and block_timestamp >= '2022-01-01'
    group by 1,2
    order by 1
    Run a query to Download Data