bank_accs as (

select

block_timestamp as bank_timestamp,

f.value :parsed :info :owner ::string as bank_address,

f.value :parsed :info :account ::string as token_account,

f.value :parsed :info :mint ::string as mint,

ifnull(address_name, mint) as label_mint

from solana.core.fact_events events

inner join lateral flatten (input => inner_instruction :instructions) f

left join solana.core.dim_labels labels

on f.value :parsed :info :mint = labels.address

where succeeded

and program_id = 'MFv2hWf31Z9kbCa1snEPYctwafyhdvnV7FZnsebVacA'

and block_timestamp > '2023-02-01'

and f.value :parsed :type = 'initializeAccount3'

and f.value :programId = 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA'

),

deposits as (

select

block_timestamp,

tx_id,

tx_from as user_address,

label_mint,

amount,

'deposit' as label_action

from solana.core.fact_transfers transfers

inner join bank_accs