Using FIRST_VALUE to find the first occurrence of a wind speed in a dataset
Using FIRST_VALUE to find the first occurrence of a rainfall measurement in a dataset
Using FIRST_VALUE to find the first occurrence of a temperature in a dataset
Using FIRST_VALUE to find the first occurrence of a currency exchange rate in a dataset
Using FIRST_VALUE to find the first occurrence of a market index in a dataset