DATE_TRUNC(hour,block_timestamp) as time,

tx_hash,

origin_function_signature,

case

when origin_function_signature = '0xee9eb0a5' then 'addLiquidityAndCreatePosition'

end as methodID,

from_address,

CASE

when tx_json:receipt:logs[0].address = '0x7ba861c07d40e3341b901fd6f418e96e0132e25b'

and tx_json:receipt:logs[0].decoded:eventName = 'Transfer'

then tx_json:receipt:logs[0]:decoded:inputs:value/POWER(10,6)

when tx_json:receipt:logs[0].address = '0x7ba861c07d40e3341b901fd6f418e96e0132e25b'

and tx_json:receipt:logs[1].decoded:eventName = 'Transfer'

then tx_json:receipt:logs[1]:decoded:inputs:value/POWER(10,6)

when tx_json:receipt:logs[0].address = '0x5979d7b546e38e414f7e9822514be443a4800529'

and tx_json:receipt:logs[0].decoded:eventName = 'Transfer'

then tx_json:receipt:logs[1]:decoded:inputs:value/POWER(10,6)

when tx_json:receipt:logs[0].address = '0x5979d7b546e38e414f7e9822514be443a4800529'

and tx_json:receipt:logs[0].decoded:eventName = 'Approval'

then tx_json:receipt:logs[3]:decoded:inputs:value/POWER(10,6)

when tx_json:receipt:logs[0].decoded:eventName = 'PairCreated'

then tx_json:receipt:logs[2]:decoded:inputs:value/POWER(10,6)

end as statom_amount,

CASE

when tx_json:receipt:logs[0].address = '0x5979d7b546e38e414f7e9822514be443a4800529'

and tx_json:receipt:logs[0].decoded:eventName = 'Transfer'

then tx_json:receipt:logs[0]:decoded:inputs:value/POWER(10,18)

when tx_json:receipt:logs[0].address = '0x5979d7b546e38e414f7e9822514be443a4800529'

and tx_json:receipt:logs[1].decoded:eventName = 'Transfer'

then tx_json:receipt:logs[1]:decoded:inputs:value/POWER(10,18)

when tx_json:receipt:logs[0].address = '0x7ba861c07d40e3341b901fd6f418e96e0132e25b'

and tx_json:receipt:logs[0].decoded:eventName = 'Transfer'

then tx_json:receipt:logs[1]:decoded:inputs:value/POWER(10,18)

when tx_json:receipt:logs[0].address = '0x7ba861c07d40e3341b901fd6f418e96e0132e25b'

and tx_json:receipt:logs[0].decoded:eventName = 'Approval'