from ethereum.chainlink.fact_oracle_feeds

where feed_address = lower('0x5f4ec3df9cbd43714fe2740f5e3616155c5b8419')

),

block_no as (

select block_number,block_timestamp

from ethereum.core.fact_blocks

where date(block_timestamp) between '2022-11-05' AND '2022-11-11'),

ether_price as(

select date(block_timestamp) as date_block ,AVG(latest_answer) as avg_price

from a

inner join block_no

on block_no.block_number = a.block_number

group by date(block_timestamp)),

pool_info as (

SELECT *

FROM arbitrum.sushi.dim_dex_pools

WHERE pool_name LIKE ('%RDNT%') AND token0_address = lower('0x0C4681e6C0235179ec3D4F4fc4DF3d14FDD96017')

),

trades as (

SELECT *

FROM arbitrum.core.fact_event_logs as logs

INNER JOIN pool_info

ON logs.contract_address = pool_info.pool_address

WHERE event_name = 'Swap'

and (origin_from_address = lower('0x0A5C08eb32CA68b803607C8607420ec9aD3ECD79')

OR origin_to_address = lower('0x0A5C08eb32CA68b803607C8607420ec9aD3ECD79'))),

final_data as (

SELECT *,

(event_inputs :amount0Out :: INTEGER)/pow(10,token0_decimals) AS amount0Out,

(event_inputs :amount1In :: INTEGER)/pow(10,token0_decimals) AS amount1In,

avg_price/pow(10,8) as reel_avg_price

from trades