with sol_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 ('SOL / USD')

group by 1,2

order by 1

),

prices as (

select

date(recorded_hour) as date,

token_address,

symbol,

avg(close) as price

from solana.core.ez_token_prices_hourly p

group by 1, 2, 3

),

nfts as (

select distinct mint

from solana.core.fact_nft_mints

select

t.block_timestamp,

t.tx_id,

t.tx_from,

t.tx_to,

t.mint,

case

when s.sales_amount is not null and t.tx_to in ('{{address}}') then 'Bought'