prices AS (

SELECT

hour::date AS date,

AVG(decimals) AS decimals,

AVG(price) AS price

FROM

ethereum.core.fact_hourly_token_prices

WHERE

symbol = 'WETH'

GROUP BY

date

),

transfers AS (

SELECT

tx_hash,

origin_to_address AS marketplace,

event_inputs:_from AS seller,

event_inputs:_to AS buyer,

contract_address AS collection,

event_inputs:_id AS nft

FROM

polygon.core.fact_event_logs

WHERE

tx_status = 'SUCCESS'

AND event_name = 'TransferSingle'

AND contract_address IN (

'0xfec90bc707fc93aefeb0c18c2eb56bc79d32163e',

'0x91ac106090fe2b0fa7d01efdf4487a5bfafad7fa',

'0x7e680862c572e4b945cf45912130c8d884109b59',

'0xd5ae5a16fbaf964f96e242645a4a6f10b98fd0c4',

'0x37db2523d221d19838632eb62d1af911e52632c3',

'0x5fd4d6fef3b87b91c7df8658727b5edd7210cf5a',

'0x45ee1caed83525673843321107bccadecb9065d7',

'0xe1b5e23fdbc003aec16e6e79726a0b5f75ff93f5',