with rraw as (

SELECT

block_Timestamp,

tx_hash,

decoded_log:amount0::int / 1e18 as first_token_amount,

decoded_log:amount1::int / 1e6 as second_token_amount,

decoded_log:tokenId::string as nft_id

from kaia.core.ez_decoded_event_logs

where contract_address = '0x68f762d28cebad501c090949e4680697e56848fc'

and event_name = 'IncreaseLiquidity'

and block_timestamp > timestamp '2024-09-25'

),

ralmost as (

select

tx_hash,

block_timestamp,

first_token_amount,

second_token_amount,

nft_id

from rraw

qualify row_number() over(partition by nft_id order by block_timestamp asc) = 1

),

rbase as (

block_timestamp,

tx_hash,

from_address,

to_address,

value_precise,

left(input, 10) as function_signature,

input,