WITH

prices as (

select

hour,

decimals,

from polygon.price.ez_hourly_token_prices

where token_address=lower('0x0d500B1d8E8eF31E21C99d1Db9A6444d3ADf1270')

),

mints AS (

select

block_timestamp,

tx_hash,

decoded_log:amount as mint_price

from polygon.core.ez_decoded_event_logs --join prices p on trunc(n.block_timestamp,'hour')=p.hour --and n.mint_currency=p.token_address

WHERE date(block_timestamp) between '2023-09-01' and '2023-09-30'

and tx_status='SUCCESS'

and tx_hash in (select tx_hash from polygon.nft.ez_nft_mints where nft_address in (

lower('0xB32D51869D97218eB75e55F378205fDF658C37E1'),

lower('0xF214E792F8A5C199eE69288B6832b14B325D94eD'),

lower('0xa12c6af626218ae1b3341771ab1a657b44050e7a'),

lower('0xAe1CAc0B65DdEC9Ec4efD9E5852440BCAad55e82'),

lower('0x6EafD03b5e7aE17C61C4f8275221FA0Eb0d4bE19'),

lower('0x8D558Bffd9619D2df19133b333C15De3A53ecE7e'),

lower('0x3d029766cD5cB69ff0545A2B925DEf078b7b91fB'),

lower('0xBb8Bb9712A63B0Df0C6Ba16Ed14E97AE5b85e03d'),

lower('0x78b0565a878E5e397ab80E0d8B1684ab5CA00Ae6'),

lower('0xe13CDbe1B619837773De29f316428D7f65E7df9a'),

lower('0xd51b6113995a1d30125F60a542b2aE0bCE678715'),

lower('0x09235Ef4fD54d6a9Dd5110B14fde7EdBe5Db11cd'),

lower('0x366a28041b6128904e237Aa9DCE7Fa8fA0056Fe9'),

lower('0x20Ae1Db1184F4274E0eEb8017cAd225691Fd06Fe'),

lower('0xEe79a3e8Aef1109a6EE82bf399cE9e1BD43Cf5c4'),

lower('0xAA0489f3F92474B993Ef11176f7Cbe10510D3E70'),