SELECT

tx_id,

div0(mint_amount , power(10, 4)) as wl

FROM solana.defi.fact_token_mint_actions

WHERE mint LIKE 'FYUjeMAFjbTzdMG91RSW5P4HT2sT7qzJQgDPiPG9ez9o'

AND block_timestamp >= '2024-02-01'

), tab2 as (

a.tx_id,

block_timestamp,

wl,

amount,

ROUND(div0(wl , amount), 1) as ratio,

CASE

WHEN ratio = 1 THEN DATEADD(day, 30, block_timestamp)

WHEN ratio = 1.4 THEN DATEADD(day, 90, block_timestamp)

WHEN ratio = 2 THEN DATEADD(day, 180, block_timestamp)

END as unlock_date,

CASE

WHEN ratio = 1 THEN 30

WHEN ratio = 1.4 THEN 90

WHEN ratio = 2 THEN 180

END as lock_duration_days,

tx_from

FROM solana.core.fact_transfers as a

LEFT OUTER JOIN tab1

ON a.tx_id = tab1.tx_id

WHERE a.tx_id IN (SELECT tx_id FROM tab1)

AND mint LIKE 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

AND tx_to LIKE '9AdEE8AAm1XgJrPEs4zkTPozr3o4U5iGbgvPwkNdLDJ3'

AND block_timestamp > '2024-02-01'

), tab3 as (

SELECT

CAST(signers[0] as varchar) as wallet,

div0(DECODED_INSTRUCTION['args']['amount'] , power(10, 5)) as amt,