(SELECT

MIN(t.block_timestamp) AS datex,

account_keys[0] as unique_users

-- signers[0] AS unique_users

solana.core.fact_transactions t

-- INNER JOIN solana.core.fact_events e ON e.tx_id = t.tx_id

-- program_id IN (

-- '9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin', -- Serum DEX V3

-- 'EUqojwWA2rd19FZrzeBncJsm38Jm1hEhE3zsmX3bRc2o', -- Serum DEX V2

-- 'BJ3jrUzddfuSrZHXSCxMUUQsjKEyLmuuyZebkcaFp2fg') -- Serum DEX V1

WHERE (array_contains('9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin'::VARIANT, account_keys) --Serum DEX V3

OR array_contains('EUqojwWA2rd19FZrzeBncJsm38Jm1hEhE3zsmX3bRc2o'::VARIANT, account_keys) --Serum DEX V2

OR array_contains('BJ3jrUzddfuSrZHXSCxMUUQsjKEyLmuuyZebkcaFp2fg'::VARIANT, account_keys) ----Serum DEX V1

)

AND t.succeeded = true

AND block_timestamp >= CURRENT_TIMESTAMP - INTERVAL'1 MONTHS'

GROUP BY 2),

u2 AS

(SELECT datex, COUNT(unique_users) AS users_new

FROM u1

GROUP BY 1),

u3 AS

(SELECT

t.block_timestamp AS datex,

COUNT(DISTINCT account_keys[0]) AS unique_users

FROM

solana.core.fact_transactions t

-- INNER JOIN solana.core.fact_events e ON e.tx_id = t.tx_id