select

--*

date_trunc('day', block_timestamp::date) as date,

zeroifnull(round(sum(case when inner_instruction:instructions[1]:programId = 'Lock7kBijGCQLEFAmXcengzXKA88iDNQPriQ7TbgeyG'

AND value:parsed:info:authority = signers[0]

then value:parsed:info:amount / POW(10,8)

when inner_instruction:instructions[0]:programId = 'Lock7kBijGCQLEFAmXcengzXKA88iDNQPriQ7TbgeyG'

AND value:parsed:info:authority != signers[0]

then value:parsed:info:amount*-1/2 / POW(10,8) end)::integer, 0, 'half_to_even')) AS POLIS_locked,

sum(polis_locked) over (order by date) as total_polis_locked

from solana.core.fact_events, lateral flatten(input => inner_instruction:instructions)

WHERE program_id = 'gateVwTnKyFrE8nxUUgfzoZTPKgJQZUbLsEidpG4Dp2'

AND date_trunc('day', block_timestamp) > '2022-07-01' --AND date_trunc('day', block_timestamp) < '2023-01-01'

group by 1

order by 2 desc

),

polis_locker_rewards AS (

select

--*

date_trunc('day', block_timestamp::date) as date,

zeroifnull(round(sum(case when value:programId = 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA'

AND value:parsed:info:authority = '2Jo8wqijXveVjra1DAknfoH1imS7XaJqLA1eQF5hzRUE'

then value:parsed:info:amount / POW(10,8) end)::decimal(20,2), 0, 'half_to_even')) AS rewards_plocker,

sum(rewards_plocker) over (order by date) as total_rewards_plocker

from solana.core.fact_events, lateral flatten(input => inner_instruction:instructions)

WHERE program_id = 'gateVwTnKyFrE8nxUUgfzoZTPKgJQZUbLsEidpG4Dp2'

AND date_trunc('day', block_timestamp) > '2022-07-01' --AND date_trunc('day', block_timestamp) < '2023-01-01'

group by 1

order by 2 desc

),