Frequency is the amount of times the particle moves back and forth per second, more or less. The more energy, the higher the frequency. At the same time, the more energy means you'll have a shorter wavelength (aka period). Color only applies to the visible spectrum.
You can keep it for as long as you want; you're the boss of your fridge. But anyway, an open beer bottle can stay good in the fridge for up to 96 hours, probably more.