block_timestamp::Date as date,

avg(swap_to_amount/swap_from_amount) as price

from solana.fact_swaps

where swap_from_mint = 'So11111111111111111111111111111111111111112'

and swap_to_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

and date >= '2022-01-01'

and succeeded = TRUE

and swap_from_amount > 1

and swap_to_amount > 1

GROUP by 1

order by 1