MAINTAB as

(select

BLOCK_TIMESTAMP ,

tx_id from

sei.core.fact_msg_attributes

where

MSG_TYPE = 'wasm'

and

ATTRIBUTE_KEY = 'action'

and

ATTRIBUTE_VALUE = 'provide_liquidity' )

, tb2 as (

select

tx_id ,

ATTRIBUTE_VALUE as LPer

from

sei.core.fact_msg_attributes

where

MSG_TYPE = 'wasm'

and

ATTRIBUTE_KEY = 'receiver'

) ,

tb3 as

(

select

tx_id ,

split((split(ATTRIBUTE_VALUE,',')[0]),'/')[1] as asset_1 ,

split((split(ATTRIBUTE_VALUE,',')[0]),'/')[1] as asset_2