select

CONVERT_TIMEZONE( 'America/New_York' , BLOCK_TIMESTAMP ) as 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')

and

EVENT_NAME = 'OrderFilled'

and

TX_STATUS = 'SUCCESS'

, users as (

SELECT

BLOCK_TIMESTAMP

,taker AS user_address

,TX_HASH

FROM

CFTE_NRCFTE

WHERE 1=1

AND taker != contract_address

AND maker NOT IN (

'0x4D97DCd97eC945f40cF65F87097ACe5EA0476045',

'0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e',

'0x78769D50Be1763ed1CA0D5E878D93f05aabff29e'

)