BLOCK_TIMESTAMP,

SIGNERS[0] as user,

SUBSTR(LOG_MESSAGES[0],8,45) as program_id,

SUBSTR(LOG_MESSAGES[1],27,len(LOG_MESSAGES[1])-26) as actoin ,

SUBSTR(LOG_MESSAGES[2],17,len(LOG_MESSAGES[2])-16) as sub_act,

INNER_INSTRUCTIONS[0]['instructions'][0]['parsed']['info']['amount']/1e6 as amount1 ,

INNER_INSTRUCTIONS,INNER_INSTRUCTIONS[0]['instructions'][0]['parsed']['info']['mint'] as mint1,

INNER_INSTRUCTIONS,INNER_INSTRUCTIONS[0]['instructions'][0]['parsed']['type'] as type1,

INNER_INSTRUCTIONS,INNER_INSTRUCTIONS[0]['instructions'][1]['parsed']['info']['amount'] as amount2,

INNER_INSTRUCTIONS,INNER_INSTRUCTIONS[0]['instructions'][1]['parsed']['info']['mint'] as mint2,

INNER_INSTRUCTIONS,INNER_INSTRUCTIONS[0]['instructions'][1]['parsed']['type'] as type2,

INNER_INSTRUCTIONS[0]['instructions'][0]['parsed']['info']['source'] as source,

TX_ID,LOG_MESSAGES,

case

when SOURCE='gbbqSXucKBYcfvaPR2DevzExFpstvE6Ypu1Nfs3HGB1' or sub_act='HarvestLiquidationGains SOL' then 'sol'

when SOURCE='5xvgjTUyR5yBEW6oKYTeTd6BaQobGt7ECLPUearAxjBA' or sub_act='HarvestLiquidationGains MSOL' then 'Msol'

when SOURCE='CyfPwr1uV3pkhQtCdCpLvzzVvAngXYqq4KSAvkVxqhga' or sub_act='HarvestLiquidationGains ETH' then 'ETH'

when SOURCE='77PfF5Nqx8r3ZwLccxhyW9jmEYNLKrYTa4ruB8uAXQSA' or sub_act='HarvestLiquidationGains FTT' then 'FTT'

when SOURCE='3aqwFikJ1sLwebd3GDdPxFPnzTaPVEQp9J7R3stNfPHL' or sub_act='HarvestLiquidationGains RAY' then 'RAY'

when SOURCE='2hwuFn23CqZdsQ2hCbjRHLuNeHra1zfk6qAurTjEL133' or sub_act='HarvestLiquidationGains SRM' then 'SRAM'

when SOURCE='EQxPELJWp87ziPFm6cnWEqqbGuzwbfbE4ejXgoBKfdJg' or sub_act='HarvestLiquidationGains BTC' then 'BTC' else null end as liquidation_acoin

,

case

when liquidation_acoin='sol' or liquidation_acoin='Msol' then amount1/1E9

when liquidation_acoin='FTT' or liquidation_acoin='RAY' then amount1/1E6

when liquidation_acoin='ETH' then amount1/1E8

when liquidation_acoin='SRAM' or liquidation_acoin='BTC' then amount1/1E6

else null end as AMOUNT

from solana.core.fact_transactions

where