shadil$MNGO price in over time
    Updated 2022-10-16
    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