*

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

--sum(value:uiTokenAmount:uiAmount) AS tokens_pre_locker

from solana.core.fact_transactions, lateral flatten(input => pre_token_balances)

WHERE instructions[0]:programId = 'ATLocKpzDbTokxgvnLew3d7drZkEzLzDpzwgrgWKDbmc'

AND succeeded = 'true'

AND value:owner = signers[0]::string

AND log_messages::string LIKE '%Tokens%'

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

AND value:mint = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx'

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

limit 100