staking as (

SELECT tx_hash

FROM near.core.fact_actions_events_function_call

WHERE method_name in ('deposit_and_stake','stake','stake_all')

),

stakes as (

SELECT

block_timestamp,

tx_hash as tx,

tx_receiver as validator,

tx_signer as delegator,

tx:actions[0]:FunctionCall:deposit/pow(10,24) near_staked

FROM near.core.fact_transactions

WHERE tx_hash in (select * from staking)

),

weekly as (

SELECT

trunc(block_timestamp,'week') as weeks,

tx,

validator,

near_staked

--amount_staked/pow(10,24) as near_staked

FROM stakes WHERE near_staked is not null

),

totals as (

SELECT

weeks,

sum(near_staked) as week_near_staked,

sum(week_near_staked) over (order by weeks)as total_near_staked

from weekly

group by 1 order by 1

),

ranking as (

SELECT

weeks,