select event_inputs:nounId as Token_ID, Block_timestamp as mint_time, event_inputs:amount/pow(10,18) * price as mint_price

from ethereum.core.fact_event_logs l

inner join ethereum.core.fact_hourly_token_prices p on to_char(block_timestamp, 'yyyy-mm-dd HH24:00:00.000') = hour

where origin_to_address = '0x55e0f7a3bb39a28bd7bcc458e04b3cf00ad3219e'

and symbol = 'WETH'

and event_name = 'AuctionSettled'),

sale as (

select TOKENID, price_usd as sale_price, mint_price, timestampdiff('hour', mint_time, block_timestamp) as difference, mint_time

from ethereum.core.ez_nft_sales s

inner join lilnoun ln on ln.Token_ID = s.TOKENID

where nft_address = '0x4b10701bfd7bfedc47d50562b76b436fbb5bdb3b')

select TOKENID, (sale_price - mint_price) as Interest

from sale

where difference < 24