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'

SUM(

CASE

WHEN CAST(makerAssetId AS VARCHAR) = '0' THEN CAST(makerAmountFilled AS DOUBLE)

WHEN CAST(takerAssetId AS VARCHAR) = '0' THEN CAST(takerAmountFilled AS DOUBLE)

END

) / pow(10, 6) AS volume

CFTE_NRCFTE

where BLOCK_TIMESTAMP::date >= current_date - interval '24 hours'