select

--*

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

sum(value:parsed:info:amount) / POW(10,8) AS atlas_rewards_claimed

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

WHERE program_id::string = 'FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW'

AND succeeded = 'true'

AND block_timestamp > '2021-12-16'

group by 1

order by 1 desc

),

atlas_locker AS (

select

--*

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

zeroifnull(round(sum(case when value:parsed:info:authority = signers[0]

AND value:parsed:info:mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx'

then value:parsed:info:tokenAmount:uiAmount

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

AND value:parsed:info:mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx'

then value:parsed:info:tokenAmount:uiAmount*-1 end)::integer, 0, 'half_to_even')) AS ATLAS_locked,

sum(atlas_locked) over (order by date) as total_atlas_locked

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

WHERE program_id = 'ATLocKpzDbTokxgvnLew3d7drZkEzLzDpzwgrgWKDbmc'

--AND value:parsed:info:mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx'

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

group by 1

order by 1 desc