select

hour::date as date,

avg(price) as token_price_usd

from

avalanche.price.ez_prices_hourly

where

token_address = '0x152b9d0fdc40c096757f570a51e494bd4b943e50'

group by 1

),

avax_to_bitcoin as (

select

tx_hash,

block_timestamp,

origin_from_address as user,

decoded_log:value / 1e8 as amount,

amount * token_price_usd as amount_usd

from

avalanche.core.ez_decoded_event_logs

left join

pricet on block_timestamp::date = date

where

tx_succeeded

and event_name = 'Transfer'

and decoded_log:to = '0x0000000000000000000000000000000000000000'

and origin_to_address = contract_address

and origin_to_address = '0x152b9d0fdc40c096757f570a51e494bd4b943e50'

),

bitcoin_to_avax as (

select

tx_hash,

block_timestamp,

decoded_log:to as user,

decoded_log:amount / 1e8 as amount,