with data_token_transfer as (
select
substring(input_data, 202, 1), tx_hash
from
ethereum.core.fact_transactions
where
to_address = '0x3ee18b2214aff97000d974cf647e7c347e8fa585'
and
origin_function_signature = '0x0f5287b0' -- tokenTransfer
and
status = 'SUCCESS'
and
substring(input_data, 202, 1)::string = '1' -- solana
)
, data_token as (
select
block_timestamp::date as date,
sum(amount_usd) as total
from
ethereum.core.ez_token_transfers
where
tx_hash in (select tx_hash from data_token_transfer)
and
to_address = '0x3ee18b2214aff97000d974cf647e7c347e8fa585'
group by 1
)
, eth_price as (
select
hour,
price
from
ethereum.core.fact_hourly_token_prices
where
token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
)
, data_eth as (