with t0 as (

select

block_timestamp,

signers[0]::string as address,

sum(decoded_instruction:args:amount::int) * pow(10, -6) as lock_amount

from solana.core.fact_decoded_instructions i

where block_timestamp >= '2024-02-01'

and i.program_id ='voTpe3tHQ7AjQHMapgSue2HJFAh2cGsdokqN3XqmVSj'

and event_type = 'increaseLockedAmount'

group by 1,2

select

date_trunc (hour, block_timestamp) as "Date",

sum (lock_amount) as "Total locked amount",

sum("Total locked amount") over (order by"Date") as "cumulative lock",

count (DISTINCT address) as "Total lockers",

sum ("Total lockers") over (order by "Date") as "cumulative lockers"

from t0

GROUP by 1

order by 2 desc