1SELECT *
2FROM @kaggle.shreyaskeote23_interest_rate_dataset.federal_funds_rate_62_year_historical_data| unnamed_0 | year | average_closing_price | year_open | year_high | year_low | year_close | annual_change |
|---|---|---|---|---|---|---|---|
| 0 | 2024 | 5.33% | 5.33% | 5.33% | 5.33% | 5.33% | 0.00% |
| 1 | 2023 | 5.03% | 4.33% | 5.33% | 4.33% | 5.33% | 23.09% |
| 2 | 2022 | 1.68% | 0.08% | 4.33% | 0.08% | 4.33% | 6085.71% |
| 3 | 2021 | 0.08% | 0.09% | 0.10% | 0.05% | 0.07% | -22.22% |
| 4 | 2020 | 0.36% | 1.55% | 1.60% | 0.04% | 0.09% | -94.19% |
| 5 | 2019 | 2.16% | 2.40% | 2.45% | 1.55% | 1.55% | -35.42% |
| 6 | 2018 | 1.79% | 1.42% | 2.40% | 1.34% | 2.40% | 80.45% |
| 7 | 2017 | 1.00% | 0.55% | 1.42% | 0.55% | 1.33% | 141.82% |
| 8 | 2016 | 0.39% | 0.20% | 0.66% | 0.20% | 0.55% | 175.00% |
| 9 | 2015 | 0.13% | 0.06% | 0.37% | 0.06% | 0.20% | 233.33% |
| 10 | 2014 | 0.09% | 0.07% | 0.13% | 0.06% | 0.06% | -14.29% |
| 11 | 2013 | 0.11% | 0.09% | 0.17% | 0.06% | 0.07% | -22.22% |
| 12 | 2012 | 0.14% | 0.04% | 0.19% | 0.04% | 0.09% | 125.00% |
| 13 | 2011 | 0.10% | 0.13% | 0.19% | 0.04% | 0.04% | -69.23% |
| 14 | 2010 | 0.18% | 0.05% | 0.22% | 0.05% | 0.13% | 160.00% |
| 15 | 2009 | 0.16% | 0.14% | 0.25% | 0.05% | 0.05% | -64.29% |
| 16 | 2008 | 1.92% | 3.06% | 4.27% | 0.09% | 0.14% | -95.42% |
| 17 | 2007 | 5.02% | 5.17% | 5.41% | 3.06% | 3.06% | -40.81% |
| 18 | 2006 | 4.97% | 4.09% | 5.34% | 4.09% | 5.17% | 26.41% |
| 19 | 2005 | 3.22% | 1.97% | 4.30% | 1.97% | 4.09% | 107.61% |
| 20 | 2004 | 1.35% | 0.94% | 2.34% | 0.92% | 1.97% | 109.57% |
| 21 | 2003 | 1.13% | 1.16% | 1.45% | 0.86% | 0.94% | -18.97% |
| 22 | 2002 | 1.67% | 1.52% | 1.92% | 1.15% | 1.16% | -23.68% |
| 23 | 2001 | 3.88% | 5.41% | 6.67% | 1.19% | 1.52% | -71.90% |
| 24 | 2000 | 6.24% | 3.99% | 7.03% | 3.99% | 5.41% | 35.59% |
| 25 | 1999 | 4.97% | 4.07% | 5.76% | 3.99% | 3.99% | -1.97% |
| 26 | 1998 | 5.35% | 5.84% | 7.06% | 4.07% | 4.07% | -30.31% |
| 27 | 1997 | 5.46% | 6.26% | 7.07% | 4.63% | 5.84% | -6.71% |
| 28 | 1996 | 5.30% | 4.73% | 7.80% | 4.73% | 6.26% | 32.35% |
| 29 | 1995 | 5.83% | 4.94% | 7.41% | 4.73% | 4.73% | -4.25% |
| 30 | 1994 | 4.21% | 2.85% | 6.56% | 2.85% | 4.94% | 73.33% |
| 31 | 1993 | 3.02% | 2.66% | 3.99% | 2.66% | 2.85% | 7.14% |
| 32 | 1992 | 3.52% | 4.09% | 4.98% | 2.58% | 2.66% | -34.96% |
| 33 | 1991 | 5.69% | 5.53% | 10.39% | 4.09% | 4.09% | -26.04% |
| 34 | 1990 | 8.10% | 7.97% | 9.53% | 5.53% | 5.53% | -30.61% |
| 35 | 1989 | 9.21% | 9.04% | 10.71% | 7.97% | 7.97% | -11.84% |
| 36 | 1988 | 7.57% | 6.89% | 9.64% | 5.72% | 9.04% | 31.20% |
| 37 | 1987 | 6.66% | 14.35% | 14.35% | 5.52% | 6.89% | -51.99% |
| 38 | 1986 | 6.80% | 13.46% | 16.17% | 5.56% | 14.35% | 6.61% |
| 39 | 1985 | 8.10% | 8.74% | 13.46% | 6.73% | 13.46% | 54.00% |
| 40 | 1984 | 10.23% | 9.92% | 12.31% | 6.93% | 8.74% | -11.90% |
| 41 | 1983 | 9.09% | 11.20% | 11.20% | 8.22% | 9.92% | -11.43% |
| 42 | 1982 | 12.24% | 13.13% | 16.80% | 8.36% | 11.20% | -14.70% |
| 43 | 1981 | 16.39% | 22.00% | 22.36% | 11.83% | 13.13% | -40.32% |
| 44 | 1980 | 13.35% | 14.77% | 22.00% | 7.65% | 22.00% | 48.95% |
| 45 | 1979 | 11.20% | 10.84% | 17.60% | 8.34% | 14.77% | 36.25% |
| 46 | 1978 | 7.94% | 6.53% | 10.89% | 6.50% | 10.84% | 66.00% |
| 47 | 1977 | 5.54% | 4.17% | 7.10% | 4.07% | 6.53% | 56.59% |
| 48 | 1976 | 5.05% | 5.37% | 5.71% | 4.12% | 4.17% | -22.35% |
| 49 | 1975 | 5.82% | 3.87% | 8.55% | 2.99% | 5.37% | 38.76% |
| 50 | 1974 | 10.51% | 9.83% | 14.33% | 3.87% | 3.87% | -60.63% |
| 51 | 1973 | 8.74% | 5.50% | 13.00% | 5.25% | 9.83% | 78.73% |
| 52 | 1972 | 4.44% | 3.00% | 6.00% | 3.00% | 5.50% | 83.33% |
| 53 | 1971 | 4.67% | 3.00% | 5.75% | 2.25% | 3.00% | 0.00% |
| 54 | 1970 | 7.17% | 5.00% | 9.75% | 3.00% | 3.00% | -40.00% |
| 55 | 1969 | 8.21% | 4.00% | 10.50% | 4.00% | 5.00% | 25.00% |
| 56 | 1968 | 5.66% | 4.50% | 6.88% | 2.50% | 4.00% | -11.11% |
| 57 | 1967 | 4.22% | 5.00% | 5.75% | 2.00% | 4.50% | -10.00% |
| 58 | 1966 | 5.11% | 4.63% | 6.25% | 1.50% | 5.00% | 7.99% |
| 59 | 1965 | 4.08% | 4.00% | 4.63% | 1.00% | 4.63% | 15.75% |
| 60 | 1964 | 3.50% | 3.25% | 4.00% | 1.00% | 4.00% | 23.08% |
| 61 | 1963 | 3.18% | 3.00% | 3.50% | 0.75% | 3.25% | 8.33% |
| 62 | 1962 | 2.71% | 2.50% | 3.00% | 0.25% | 3.00% | 20.00% |
| 63 | 1961 | 1.95% | 3.00% | 3.00% | 0.13% | 2.50% | -16.67% |
| 64 | 1960 | 3.21% | 4.00% | 4.00% | 0.25% | 3.00% | -25.00% |
| 65 | 1959 | 3.31% | 2.38% | 4.00% | 1.50% | 4.00% | 68.07% |
| 66 | 1958 | 1.57% | 3.00% | 3.00% | 0.13% | 2.38% | -20.67% |
| 67 | 1957 | 3.11% | 3.00% | 3.50% | 1.00% | 3.00% | 0.00% |
| 68 | 1956 | 2.73% | 2.50% | 3.00% | 1.00% | 3.00% | 20.00% |
| 69 | 1955 | 1.79% | 1.44% | 2.50% | 0.50% | 2.50% | 73.61% |