select

block_timestamp,

tx_hash,

contract_address,

EVENT_INDEX,

DECODED_LOG:collateralToken::string as collateralToken,

DECODED_LOG:conditionIds::string as conditionIds, -- [0]

DECODED_LOG:conditionalTokens::string as conditionalTokens,

DECODED_LOG:creator::string as creator,

DECODED_LOG:fee::int as fee,

DECODED_LOG:fixedProductMarketMaker::string as fixedProductMarketMaker

from polygon.core.ez_decoded_event_logs

where 1=1

and CONTRACT_ADDRESS = '0x8b9805a2f595b6705e74f7310829f2d299d21522'

and event_name = 'FixedProductMarketMakerCreation'

and collateralToken = '0x2791bca1f2de4661ed88a30c99a7a9449aa84174'

and TX_STATUS = 'SUCCESS'

),

CFTE_NRCFTE as (

select

BLOCK_TIMESTAMP

,TX_HASH

,CONTRACT_ADDRESS

,EVENT_NAME

,DECODED_LOG:fee::float as fee

,DECODED_LOG:maker::string as maker

,DECODED_LOG:makerAmountFilled::float as makerAmountFilled

,DECODED_LOG:makerAssetId::string as makerAssetId

,DECODED_LOG:orderHash::string as orderHash

,DECODED_LOG:taker::string as taker

,DECODED_LOG:takerAmountFilled::float as takerAmountFilled

,DECODED_LOG:takerAssetId::string as takerAssetId

from polygon.core.ez_decoded_event_logs

where

CONTRACT_ADDRESS in ('0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e', '0xc5d563a36ae78145c45a50134d48a1215220f80a')