shadil$MNGO price in over time
Updated 2022-10-16
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select sum(swap_to_amount) / sum(swap_from_amount) as price,
date_trunc('HOUR', block_timestamp) as date_time
from solana.fact_swaps
where block_timestamp >= '2022-09-01'
and succeeded = 1
and (swap_to_mint = '7kbnvuGBxxj8AG9qp8Scn56muWGaRaFqxg1FsRp3PaFT'
or swap_to_mint = 'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS'
or swap_to_mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'
or swap_to_mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'
or swap_to_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')
and swap_from_mint = 'MangoCzJ36AjZyKwVj3VnYU4GTonjfVEnJmvvWaxLac'
group by date_time
Run a query to Download Data