with lst_eth_price as (

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_deposit as (

with lst_wallet as (

select

tx_hash

,to_address as wallet

from ink.core.fact_traces

where input='0x'

and type='CALL'

)

select

block_timestamp::date as date_a

,tx_hash