mariyaDaily Sol price
Updated 2022-11-24
9
1
2
3
4
5
6
7
8
›
⌄
select block_timestamp::date as date,
(sum(SWAP_TO_AMOUNT)/sum(SWAP_FROM_AMOUNT)) as sol_price
from solana.core.fact_swaps
where SWAP_FROM_MINT = 'So11111111111111111111111111111111111111112'
and SWAP_TO_MINT = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
and block_timestamp::date >= '2022-10-01'
and succeeded = 'TRUE'
group by 1
Run a query to Download Data