with price_tab as (

SELECT date_trunc('day',hour) as day1,

avg(price) as btc_price

FROM bitcoin.price.ez_hourly_token_prices

group by 1 ) ,

ordswap as (

select

transactions.block_timestamp,

transactions.block_number,

transactions.tx_id,

transactions.fee,

input1.pubkey_script_address AS buyer,

input2.pubkey_script_address AS seller,

outputs[1]:value AS amount

from

bitcoin.core.fact_transactions transactions

join bitcoin.core.fact_inputs input1 on transactions.tx_id = input1.tx_id

join bitcoin.core.fact_inputs input2 on transactions.tx_id = input2.tx_id

join bitcoin.core.fact_inputs input3 on transactions.tx_id = input3.tx_id

where

transactions.block_number > 767429

and transactions.block_timestamp > '2023-02-01'

and input1.index = 0

and input2.index = 1

and input3.index = 2

and input1.pubkey_script_address = input3.pubkey_script_address

and input2.pubkey_script_address = transactions.outputs[1]:scriptPubKey:address

and input3.pubkey_script_address = transactions.outputs[0]:scriptPubKey:address

and transactions.outputs[3]:scriptPubKey:address = 'bc1psypqqyvsc64dngq4mlc4grwf5776x9snhz4stfvzdrztlafl46pqneup8x'

),

sales as (

select