select

hour::date as price_date,

avg(price) as eth_price

from ethereum.price.ez_prices_hourly

where symbol ='ETH'

and hour::date >= '2024-12-01'

and blockchain = 'ethereum'

and token_address is null

group by 1

)

,lst_eth_price_one as (

select top 1

hour::date as price_date,

avg(price) as eth_price

from ethereum.price.ez_prices_hourly

where symbol ='ETH'

and hour::date >= '2024-12-01'

and blockchain = 'ethereum'

and token_address is null

group by 1

order by hour::date desc

)

,lst_Mint as (

select

block_timestamp::date as date

,tx_hash

,ORIGIN_FROM_ADDRESS as wallet

,amount

,amount*eth_price as amount_usd

from ink.core.ez_token_transfers

join lst_eth_price on block_timestamp::date = price_date

where block_timestamp::date>='2024-12-18'

and CONTRACT_ADDRESS='0x11476323d8dfcbafac942588e2f38823d2dd308e'

and ORIGIN_FUNCTION_SIGNATURE in ('0xea598cb0','0xe0e50bfb','0xcfc32570') --Mint

-- and tx_hash='0xe48e6533a29f252fe1890a9a8227a92966fc2213b4e3b52a769b827178f19320'