with matic_price as

(

select date_trunc('{{granularity}}',hour) as time, price

from ethereum.core.fact_hourly_token_prices

where symbol='MATIC'

),

poly_nft AS (

SELECT

'polygon' as chain,

date_trunc('{{granularity}}',events.block_timestamp) as time,

events.tx_hash,

CASE

WHEN events.origin_to_address = '0x7bc8b1b5aba4df3be9f9a32dae501214dc0e4f3f' THEN 'tofuNFT'

WHEN events.origin_to_address = '0x5268ba85beada5891203aa7f836269741127e31d' THEN 'PlayDapp'

WHEN events.origin_to_address = '0xeaf5453b329eb38be159a872a6ce91c9a8fb0260' THEN 'Element'

WHEN events.origin_to_address IN ('0xeaf5453b329eb38be159a872a6ce91c9a8fb0260', '0x535a8a4a0d1eb5e9541227ebfb13d98c67c0fbf1') THEN 'BitKeep'

WHEN events.origin_to_address = '0x72b2c16baa31413dfac4c10fe8d939cefe41e76a' THEN 'Blockparty'

WHEN events.origin_to_address = '0x74a1faa4db3f8b98d7b134eedd87814a34bb5eb2' THEN 'NFTKEY'

WHEN events.origin_to_address = '0xa8ec74448e3dd4f074719333ae24fa52cec8e2fb' THEN 'Dropys'

WHEN events.origin_to_address = '0xd9bd0a41aa6fadc0e9ea5eabc4d816c2ac277ce7' THEN 'In Writing'

WHEN events.origin_to_address = '0xa8ec74448e3dd4f074719333ae24fa52cec8e2fb' THEN 'Dropys'

WHEN events.origin_to_address = '0xa8ec74448e3dd4f074719333ae24fa52cec8e2fb' THEN 'Dropys'

WHEN events.origin_to_address = '0xd816595544e6f557644c357ca134d0c4b7f4bcbd' THEN 'Guise'

WHEN events.origin_to_address = '0x00000000006c3852cbef3e08e8df289169ede581' THEN 'opensea'

WHEN events.origin_to_address = '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d' THEN 'zeroexfee'

WHEN events.origin_to_address = '0xd05f4fa592dd57b63823b29812209fb38517baa6' THEN 'decrease auction'

WHEN events.origin_to_address = '0xcbbecf690e030d096794f7685a1bf4a58378a575' THEN 'opensea'

ELSE null

END AS marketplace,

events.event_inputs:from AS seller,

events.event_inputs:to AS buyer,

events.contract_address AS collection,

events.event_inputs:tokenId AS token,

-- transactions.matic_value as matic,