select

event_inputs:nounId as nounId,

event_inputs:amount/pow(10,18) as eth_price

from ethereum.core.fact_event_logs

where contract_address = '0x55e0f7a3bb39a28bd7bcc458e04b3cf00ad3219e' and

event_inputs:winner is not null

),secondary_sale as (

select tokenid as nounId,price as eth_price from

ethereum.core.ez_nft_sales

where nft_address = '0x4b10701bfd7bfedc47d50562b76b436fbb5bdb3b'

)

select mint.nounId, max(secondary_sale.eth_price -mint.eth_price) as eth_price_diff

from mint join secondary_sale on mint.nounId = secondary_sale.nounId

group by 1

order by 2 desc

limit 10