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[0]['instructions'][0]['parsed']['info']['account'] as account,

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']['destination'] as source,

TX_ID,LOG_MESSAGES,

case

when SOURCE='68yQyYj4YymoiQ644LVyRdvWLpw9xsjp67kmZhLMGnQp' or sub_act='HarvestLiquidationGains SOL' then 'sol'

when SOURCE='9FWk5tni1jv6muvuUeh2JJdcfGcuzShkh2Ashzr6QWch' or sub_act='HarvestLiquidationGains MSOL' then 'Msol'

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

when SOURCE='5EpCf866wXEgPFyTstgmJZJK1TPZJ3d1Jcvi2mT6EXFj' or sub_act='HarvestLiquidationGains FTT' then 'FTT'

when SOURCE='BcmAzZsn6uZL8Hsv4ZWidXFshPS5oSyBXetf2ZD2i5i7' or sub_act='HarvestLiquidationGains RAY' then 'RAY'

when SOURCE='5p8atdH8vX1mKgA38DPCC6tWGuGCiMRmZqFg1KrsECTW' or sub_act='HarvestLiquidationGains SRM' then 'SRAM'

when SOURCE='4EhioLhAgbX18VGmX5Qf7qBGB7HEDQELcBxEGTk6c38G' 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