SELECT

DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS event_day,

value:pubkey::STRING AS user_id

FROM solana.core.ez_events_decoded,

LATERAL FLATTEN(input => DECODED_ACCOUNTS)

WHERE

PROGRAM_ID = 'LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo'

AND BLOCK_ID >= 228499898

AND SUCCEEDED

AND EVENT_TYPE IN (

'claimFee',

'addLiquidityByStrategy',

'initializePosition',

'removeLiquidityByRange',

'closePosition',

'addLiquidityByWeight',

'removeLiquidity',

'addLiquidityByStrategyOneSide',

'addLiquidityOneSide',

'removeAllLiquidity',

'addLiquidity'

)

AND (value:name = 'sender' OR value:name = 'payer')

GROUP BY event_day, user_id

),

cumulative_users AS (

SELECT

a.event_day,

a.user_id,

MIN(b.event_day) AS first_seen_day

FROM

unique_users_per_day a

LEFT JOIN

unique_users_per_day b

ON