(select CONCAT('0x', SUBSTR(EVENT_INPUTS:makerAssetData :: STRING, 35, 40)) as nft_address, TX_HASH

from polygon.core.fact_event_logs

where ORIGIN_FUNCTION_SIGNATURE='0xbbbfa60c' and ORIGIN_TO_ADDRESS='0xf715beb51ec8f63317d66f491e37e7bb048fcc2d'

AND EVENT_NAME='Fill' and EVENT_INPUTS:makerFeeAssetData!='null'

),

opensea_fees as (

select BLOCK_TIMESTAMP, CONTRACT_ADDRESS,

case

when CONTRACT_ADDRESS='0x8f3cf7ad23cd3cadbd9735aff958023239c6a063' then 'DAI'

when CONTRACT_ADDRESS='0x7ceb23fd6bc0add59e62ac25578270cff1b9f619' then 'WETH'

when CONTRACT_ADDRESS='0x70c006878a5a50ed185ac4c87d837633923de296' then 'REVV'

when CONTRACT_ADDRESS='0x2791bca1f2de4661ed88a30c99a7a9449aa84174' then 'USDC'

end as token_name,

case

when CONTRACT_ADDRESS='0x2791bca1f2de4661ed88a30c99a7a9449aa84174' then EVENT_INPUTS:value/1e6

else EVENT_INPUTS:value/1e18

end as fee, TX_HASH

from polygon.core.fact_event_logs

where

ORIGIN_FUNCTION_SIGNATURE='0xbbbfa60c' and ORIGIN_TO_ADDRESS='0xf715beb51ec8f63317d66f491e37e7bb048fcc2d'

and EVENT_INPUTS:from='0xf715beb51ec8f63317d66f491e37e7bb048fcc2d'

and EVENT_INPUTS:to in ('0x5b3256965e7c3cf26e11fcaf296dfc8807c01073','0x8de9c5a032463c561423387a9648c5c7bcc5bc90')),

prices as (

select HOUR,

case

when SYMBOL is null then 'WETH'

else SYMBOL

end as token_name, PRICE

from flipside_prod_db.ethereum.token_prices_hourly

where TOKEN_ADDRESS is null or TOKEN_ADDRESS='0x557b933a7c2c45672b610f8954a3deb39a51a8ca'

),

opensea_fees_usd as (