select

--*

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

count (distinct signers[0]) as active_users_marketplace

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

WHERE program_id::string = 'traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg'

AND succeeded = 'true'

--AND log_messages::string LIKE '%ProcessExchange%'

--AND value:parsed:info:mint::string NOT IN ('ammoK8AkX2wnebQb35cDAZtTkvsXQbi82cGeTnUvvfK', 'foodQJAztMzX1DKpLaiounNe2BDMds5RNuPC6jsNrDG', 'fueL3hBZjLLLJHiFH9cqZoozTG3XQZ53diwFPwbzNim', 'tooLsNYLiVqzg8o4m3L2Uetbn62mvMWRqkog6PQeYKL')

--AND value:parsed:info:mint::string NOT IN ('ammoK8AkX2wnebQb35cDAZtTkvsXQbi82cGeTnUvvfK', 'foodQJAztMzX1DKpLaiounNe2BDMds5RNuPC6jsNrDG', 'fueL3hBZjLLLJHiFH9cqZoozTG3XQZ53diwFPwbzNim', 'tooLsNYLiVqzg8o4m3L2Uetbn62mvMWRqkog6PQeYKL')

AND block_timestamp > '2022-07-01' AND block_timestamp < '2023-09-01'

group by 1

order by 1 desc

),

atlas_locker AS (

select

--*

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

count (distinct signers) as active_users_atlas_locker

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

WHERE program_id::string = 'ATLocKpzDbTokxgvnLew3d7drZkEzLzDpzwgrgWKDbmc'

AND succeeded = 'true'

--AND log_messages::string LIKE '%StakeTokens%'

AND block_timestamp > '2022-07-01' AND block_timestamp < '2023-09-01'

group by 1

order by 1 desc

),