PREVIEW / futures_30min / 2009-11-27
file: by_date/futures_30min/2009/2009-11-27.parquet size: 57 KB rows: 1,769
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2009-11-27 00:00:00 | ES | Futures | 1044.94 | 1045.43 | 1041.55 | 1044.7 | 14477.0 |
| 2009-11-27 00:30:00 | ES | Futures | 1044.7 | 1045.19 | 1038.4 | 1042.28 | 7714.0 |
| 2009-11-27 01:00:00 | ES | Futures | 1042.04 | 1042.76 | 1040.34 | 1041.07 | 2910.0 |
| 2009-11-27 01:30:00 | ES | Futures | 1041.07 | 1043.01 | 1040.1 | 1041.07 | 4290.0 |
| 2009-11-27 02:00:00 | ES | Futures | 1041.31 | 1041.55 | 1035.26 | 1037.19 | 22766.0 |
| 2009-11-27 02:30:00 | ES | Futures | 1036.95 | 1037.68 | 1033.8 | 1035.26 | 17972.0 |
| 2009-11-27 03:00:00 | ES | Futures | 1035.26 | 1041.31 | 1034.53 | 1040.58 | 38274.0 |
| 2009-11-27 03:30:00 | ES | Futures | 1040.34 | 1044.7 | 1040.1 | 1043.01 | 28437.0 |
| 2009-11-27 04:00:00 | ES | Futures | 1043.01 | 1048.09 | 1041.55 | 1043.98 | 26930.0 |
| 2009-11-27 04:30:00 | ES | Futures | 1044.22 | 1047.61 | 1043.49 | 1045.91 | 17573.0 |
| 2009-11-27 05:00:00 | ES | Futures | 1045.91 | 1048.34 | 1045.91 | 1048.34 | 14819.0 |
| 2009-11-27 05:30:00 | ES | Futures | 1048.34 | 1048.58 | 1044.94 | 1045.19 | 15122.0 |
| 2009-11-27 06:00:00 | ES | Futures | 1044.94 | 1045.19 | 1041.8 | 1043.01 | 15676.0 |
| 2009-11-27 06:30:00 | ES | Futures | 1043.25 | 1046.4 | 1043.25 | 1045.91 | 12280.0 |
| 2009-11-27 07:00:00 | ES | Futures | 1045.91 | 1046.4 | 1043.25 | 1043.73 | 16057.0 |
| 2009-11-27 07:30:00 | ES | Futures | 1043.98 | 1047.37 | 1043.25 | 1047.12 | 24506.0 |
| 2009-11-27 08:00:00 | ES | Futures | 1046.88 | 1051.24 | 1046.88 | 1048.58 | 45091.0 |
| 2009-11-27 08:30:00 | ES | Futures | 1048.34 | 1049.55 | 1046.4 | 1046.64 | 29044.0 |
| 2009-11-27 09:00:00 | ES | Futures | 1046.4 | 1048.09 | 1045.19 | 1045.19 | 33876.0 |
| 2009-11-27 09:30:00 | ES | Futures | 1045.43 | 1053.91 | 1044.22 | 1053.42 | 241918.0 |
| 2009-11-27 10:00:00 | ES | Futures | 1053.42 | 1058.51 | 1052.94 | 1056.81 | 156447.0 |
| 2009-11-27 10:30:00 | ES | Futures | 1056.81 | 1062.87 | 1055.6 | 1060.93 | 136603.0 |
| 2009-11-27 11:00:00 | ES | Futures | 1060.93 | 1064.08 | 1059.48 | 1060.2 | 112488.0 |
| 2009-11-27 11:30:00 | ES | Futures | 1059.96 | 1061.42 | 1058.75 | 1060.45 | 61321.0 |
| 2009-11-27 12:00:00 | ES | Futures | 1060.45 | 1060.69 | 1057.06 | 1058.27 | 76875.0 |
| 2009-11-27 12:30:00 | ES | Futures | 1058.27 | 1063.11 | 1056.09 | 1056.57 | 127839.0 |
| 2009-11-27 13:00:00 | ES | Futures | 1056.81 | 1057.06 | 1054.39 | 1055.36 | 65646.0 |
| 2009-11-27 00:00:00 | NQ | Futures | 1986.66 | 1996.07 | 1984.38 | 1987.8 | 1933.0 |
| 2009-11-27 00:30:00 | NQ | Futures | 1988.09 | 1988.94 | 1979.82 | 1984.95 | 1455.0 |
| 2009-11-27 01:00:00 | NQ | Futures | 1984.95 | 1985.81 | 1980.67 | 1983.53 | 128.0 |
| 2009-11-27 01:30:00 | NQ | Futures | 1982.67 | 1985.81 | 1980.39 | 1982.1 | 607.0 |
| 2009-11-27 02:00:00 | NQ | Futures | 1982.1 | 1982.38 | 1970.12 | 1974.97 | 1810.0 |
| 2009-11-27 02:30:00 | NQ | Futures | 1974.68 | 1978.68 | 1964.7 | 1969.27 | 2143.0 |
| 2009-11-27 03:00:00 | NQ | Futures | 1969.27 | 1979.53 | 1967.84 | 1979.53 | 3043.0 |
| 2009-11-27 03:30:00 | NQ | Futures | 1979.53 | 1992.08 | 1979.25 | 1987.52 | 4504.0 |
| 2009-11-27 04:00:00 | NQ | Futures | 1987.8 | 1998.07 | 1984.1 | 1988.66 | 2412.0 |
| 2009-11-27 04:30:00 | NQ | Futures | 1988.94 | 1995.5 | 1988.37 | 1992.94 | 1415.0 |
| 2009-11-27 05:00:00 | NQ | Futures | 1992.65 | 1996.64 | 1992.65 | 1995.79 | 990.0 |
| 2009-11-27 05:30:00 | NQ | Futures | 1995.79 | 1996.93 | 1989.8 | 1989.8 | 630.0 |
| 2009-11-27 06:00:00 | NQ | Futures | 1989.8 | 1989.8 | 1984.38 | 1987.23 | 1288.0 |
| 2009-11-27 06:30:00 | NQ | Futures | 1987.8 | 1993.79 | 1987.8 | 1991.8 | 787.0 |
| 2009-11-27 07:00:00 | NQ | Futures | 1992.08 | 1994.36 | 1988.09 | 1988.66 | 1387.0 |
| 2009-11-27 07:30:00 | NQ | Futures | 1988.94 | 1994.65 | 1988.37 | 1994.36 | 1449.0 |
| 2009-11-27 08:00:00 | NQ | Futures | 1994.36 | 2004.63 | 1994.36 | 1999.21 | 4314.0 |
| 2009-11-27 08:30:00 | NQ | Futures | 1999.21 | 2002.35 | 1995.79 | 1996.64 | 2823.0 |
| 2009-11-27 09:00:00 | NQ | Futures | 1996.64 | 2000.35 | 1991.23 | 1991.23 | 4531.0 |
| 2009-11-27 09:30:00 | NQ | Futures | 1991.23 | 2008.62 | 1986.95 | 2005.77 | 56008.0 |
| 2009-11-27 10:00:00 | NQ | Futures | 2006.06 | 2018.32 | 2004.91 | 2015.18 | 28434.0 |
| 2009-11-27 10:30:00 | NQ | Futures | 2014.9 | 2028.3 | 2012.62 | 2023.74 | 26275.0 |
| 2009-11-27 11:00:00 | NQ | Futures | 2023.74 | 2030.3 | 2022.03 | 2024.59 | 21858.0 |
> showing 50 of 1,769 rows — these rows as CSV