SELECT

hour::DATE AS op_date

, AVG(price) AS OP_price

FROM optimism.core.fact_hourly_token_prices

WHERE symbol = 'OP'

and hour>= '2022-10-01' and hour < CURRENT_DATE

GROUP BY 1

),

airdrop as (

select date_trunc('day', block_timestamp) as date,

sum(raw_amount)/1e18 as claimed_vol,

COUNT(DISTINCT to_address) as claimers

from optimism.core.fact_token_transfers

where contract_address = '0x4200000000000000000000000000000000000042'

and from_address = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'

GROUP by 1

select a.OP_price, b.*

from op_price a join airdrop b on a.op_date=b.date