select hour::date as price_date,

token_address,

symbol,

decimals,

avg(price) as price

from Ethereum.price.ez_prices_hourly

group by 1,2,3,4

, ETH_price as (

select hour::date as price_date,

token_address,

symbol,

decimals,

avg(price) as ETH_price

from ethereum.price.ez_prices_hourly

where symbol = 'WETH'

group by 1,2,3,4

, base_from_Ethereum as (

select distinct tx_hash

from Ethereum.core.fact_token_transfers t

where 1 = 1

and block_timestamp >= '2023-04-01' and block_timestamp < CURRENT_DATE

and to_address = '0xef4fb24ad0916217251f553c0596f8edc630eb66'

, cancelled_tx as (

select tx_hash

FROM ethereum.core.fact_event_logs

where 1 = 1

and block_timestamp > '2023-01-01'

and topics[0] = '0x7d7d1c5b3eadbe275ceb358e65cd57410b35997187258dbaaae42ab6e1405fd8'

, from_Ethereum as (

select block_timestamp::date as date,

'From' as route_type,