HOUR::date as day,

avg(price) as usd_price

from ethereum.core.fact_hourly_token_prices

where SYMBOL='WETH'

group by 1),

tb1 as (SELECT

* ,

event_inputs:_id as NFT_id,

event_inputs:_to as buyers,

event_inputs:_from as sellers,

event_inputs:_value as no_tokens

from polygon.core.fact_event_logs

where CONTRACT_ADDRESS in ('0xfec90bc707fc93aefeb0c18c2eb56bc79d32163e', '0x91ac106090fe2b0fa7d01efdf4487a5bfafad7fa',

'0x7e680862c572e4b945cf45912130c8d884109b59', '0xd5ae5a16fbaf964f96e242645a4a6f10b98fd0c4',

'0x37db2523d221d19838632eb62d1af911e52632c3', '0x5fd4d6fef3b87b91c7df8658727b5edd7210cf5a',

'0x45ee1caed83525673843321107bccadecb9065d7', '0xe1b5e23fdbc003aec16e6e79726a0b5f75ff93f5',

'0xbcea6c4029203b8753c856a2514a6ed211c69777', '0x334ad326a787dd332f26cbe8b4d7adfa8bd25f92',

'0xbc096988fa38c78d65c0637453fd3d3c38b1cfd4', '0x0985cb10c5d57dbf44aa473f33839ed38d80f111',

'0x3e4627665bf2e52c69be03788e664ab545f2be71', '0x04f7a676af597f847053b6c02ed42d02fa4046aa',

'0x79ef499463dae3cd413d78477fa848ecbbda774b', '0x81ba34b90876f42f34a4f232cfc0fe4b6ec949a3',

'0x621ce7e7e44d43a428a183d5390c4f4572c9ff9d', '0x04125a97a0f2583cd485be2c34b651cc13c38a27',

'0xdaa6e4ba2d4022ed820460bb501b9e061d9614fb', '0x3458161f2dc5d7eafa48e7c8d9acd7f415cf6da6',

'0x04f087e3191d7a050800a2e04cb20046d2633e35', '0x8264e2bad3d2f7afd72a00233b9f841fe4b388cd',

'0xddbdb65138131dbf2d01b4a5140e1979680c90bb', '0xc70a7496716b3e25546901fe88215531abbd5a10',

'0x2e90e8af4c319095942c84cfa446e1f206795517', '0x150afa2dfcaaada471472dfa6ad4b79e718a197c',

'0x83feea011baeb1c6d1df7d23903efad83d3c781f', '0x21d426e2b88fbf8b93adf0591a2d5b08d58f089f',

'0xe4989961ebfdac3e65fcf0059c916452c77d8503', '0x6acb8fb82880d39c2b8446f8778a14d34ee6cfb7',

'0xbfd670667053e517a97afe56c91e4f83f1160bd3', '0xb9c042c3275bc49799688eea1a29b1405d02946b',

'0x466a330887bdf62d53f968ea824793150f07762e', '0x5846728730366d686CdC95dae80a70b44Ec9eAb2',

'0xfbed9640e37666fe2ac78e1d263670976354cb69', '0xe0743141df04a6b9f3df890429cc994e46db03d9',

'0x97439ee4c93ff9f76417696ce648aa6f35ab3b25', '0xf43bc3f4f1edb7d4c373c8510a2888d69d83ceb7',

'0x425bf054ef7bad65b7bdd8e6587b1c3500e4f4ca', '0x2956409293da98603025cc0121c06a4244752039',

'0xa7bb50d90b43752199c45be04053641c3cb5f53f', '0x47749c5b970e63f3a0ed57cd6cef773e74fafe9d',

'0x838c1cd42929543daf9c3ef294fee8c1b3224b37', '0xc5aa1f91b0d52e26d2847f8e51f505d6e2ece795',