weth_prices as (

select

date(block_timestamp) as date,

replace(feed_name, ' / USD') as symbol,

median(coalesce(latest_answer_adj, latest_answer_unadj / pow(10,8))) as price --using median cause there will be some nulls / zeroes

from ethereum.chainlink.ez_oracle_feeds

where feed_category = 'Cryptocurrency (USD pairs)'

and feed_name in ('ETH / USD')

group by 1,2

order by 1

),

eth_transfers as (

select *

from ethereum.core.fact_event_logs

where event_name = 'LogAnySwapOut' and tx_status = 'SUCCESS'

),

avalanche_transfers as (

select *

from avalanche.core.fact_event_logs

where event_name = 'LogAnySwapOut' and tx_status = 'SUCCESS'

),

polygon_transfers as (

select *

from polygon.core.fact_event_logs

where event_name = 'LogAnySwapOut' and tx_status = 'SUCCESS'

),

bsc_transfers as (

select *

from bsc.core.fact_event_logs

where event_name = 'LogAnySwapOut' and tx_status = 'SUCCESS'

),

decimals as (