TX_HASH,

ORIGIN_FROM_ADDRESS as wallet,

ORIGIN_TO_ADDRESS,

CONTRACT_ADDRESS as token_from,

EVENT_INPUTS:value as amount_from

from optimism.core.fact_event_logs

where EVENT_INPUTS:from = ORIGIN_FROM_ADDRESS

and EVENT_NAME = 'Transfer'

and date = '2022-07-29'

),

tto as (SELECT BLOCK_TIMESTAMP::date as date,

TX_HASH,

ORIGIN_FROM_ADDRESS as wallet,

ORIGIN_TO_ADDRESS,

CONTRACT_ADDRESS as token_to,

EVENT_INPUTS:value as amount_to

from optimism.core.fact_event_logs

where EVENT_INPUTS:to = ORIGIN_FROM_ADDRESS

and EVENT_NAME = 'Transfer'

and date = '2022-07-29'

),

a as (SELECT tfrom.*,

token_to,

amount_to

from tfrom

join tto on tfrom.TX_HASH = tto.TX_HASH

),

price as (SELECT hour::date as date,

TOKEN_ADDRESS,

SYMBOL,

DECIMALS,

avg(price) as daily_price

from optimism.core.fact_hourly_token_prices

where date = '2022-07-29'