from near.core.fact_transactions

group by 1

order by 2 desc

limit 10)

select date(block_timestamp) as date , TX_RECEIVER ,count(DISTINCT(TX_HASH)) as total_tx, sum(TRANSACTION_FEE/pow(10,24)) as fee,

sum(fee) over (partition by TX_RECEIVER order by date asc) as cum_fee, sum(GAS_USED/1e12) as gas,

sum(gas) over (partition by TX_RECEIVER order by date asc) as cum_gas

from near.core.fact_transactions

where block_timestamp::date >= '2022-07-21' and TX_RECEIVER in ( select TX_RECEIVER from contract)

group by 1,2