PREVIEW / futures_1hour / 2009-11-27
file: by_date/futures_1hour/2009/2009-11-27.parquet size: 35 KB rows: 953
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 | 1038.4 | 1042.28 | 22191.0 |
| 2009-11-27 01:00:00 | ES | Futures | 1042.04 | 1043.01 | 1040.1 | 1041.07 | 7200.0 |
| 2009-11-27 02:00:00 | ES | Futures | 1041.31 | 1041.55 | 1033.8 | 1035.26 | 40738.0 |
| 2009-11-27 03:00:00 | ES | Futures | 1035.26 | 1044.7 | 1034.53 | 1043.01 | 66711.0 |
| 2009-11-27 04:00:00 | ES | Futures | 1043.01 | 1048.09 | 1041.55 | 1045.91 | 44503.0 |
| 2009-11-27 05:00:00 | ES | Futures | 1045.91 | 1048.58 | 1044.94 | 1045.19 | 29941.0 |
| 2009-11-27 06:00:00 | ES | Futures | 1044.94 | 1046.4 | 1041.8 | 1045.91 | 27956.0 |
| 2009-11-27 07:00:00 | ES | Futures | 1045.91 | 1047.37 | 1043.25 | 1047.12 | 40563.0 |
| 2009-11-27 08:00:00 | ES | Futures | 1046.88 | 1051.24 | 1046.4 | 1046.64 | 74135.0 |
| 2009-11-27 09:00:00 | ES | Futures | 1046.4 | 1053.91 | 1044.22 | 1053.42 | 275794.0 |
| 2009-11-27 10:00:00 | ES | Futures | 1053.42 | 1062.87 | 1052.94 | 1060.93 | 293050.0 |
| 2009-11-27 11:00:00 | ES | Futures | 1060.93 | 1064.08 | 1058.75 | 1060.45 | 173809.0 |
| 2009-11-27 12:00:00 | ES | Futures | 1060.45 | 1063.11 | 1056.09 | 1056.57 | 204714.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 | 1979.82 | 1984.95 | 3388.0 |
| 2009-11-27 01:00:00 | NQ | Futures | 1984.95 | 1985.81 | 1980.39 | 1982.1 | 735.0 |
| 2009-11-27 02:00:00 | NQ | Futures | 1982.1 | 1982.38 | 1964.7 | 1969.27 | 3953.0 |
| 2009-11-27 03:00:00 | NQ | Futures | 1969.27 | 1992.08 | 1967.84 | 1987.52 | 7547.0 |
| 2009-11-27 04:00:00 | NQ | Futures | 1987.8 | 1998.07 | 1984.1 | 1992.94 | 3827.0 |
| 2009-11-27 05:00:00 | NQ | Futures | 1992.65 | 1996.93 | 1989.8 | 1989.8 | 1620.0 |
| 2009-11-27 06:00:00 | NQ | Futures | 1989.8 | 1993.79 | 1984.38 | 1991.8 | 2075.0 |
| 2009-11-27 07:00:00 | NQ | Futures | 1992.08 | 1994.65 | 1988.09 | 1994.36 | 2836.0 |
| 2009-11-27 08:00:00 | NQ | Futures | 1994.36 | 2004.63 | 1994.36 | 1996.64 | 7137.0 |
| 2009-11-27 09:00:00 | NQ | Futures | 1996.64 | 2008.62 | 1986.95 | 2005.77 | 60539.0 |
| 2009-11-27 10:00:00 | NQ | Futures | 2006.06 | 2028.3 | 2004.91 | 2023.74 | 54709.0 |
| 2009-11-27 11:00:00 | NQ | Futures | 2023.74 | 2030.3 | 2021.17 | 2023.74 | 36488.0 |
| 2009-11-27 12:00:00 | NQ | Futures | 2023.74 | 2027.73 | 2014.61 | 2016.04 | 30366.0 |
| 2009-11-27 13:00:00 | NQ | Futures | 2016.04 | 2017.18 | 2005.77 | 2006.63 | 11584.0 |
| 2009-11-27 00:00:00 | YM | Futures | 9494.4 | 9500.9 | 9447.9 | 9473.9 | 1763.0 |
| 2009-11-27 01:00:00 | YM | Futures | 9474.9 | 9482.3 | 9457.2 | 9466.5 | 768.0 |
| 2009-11-27 02:00:00 | YM | Futures | 9464.6 | 9467.4 | 9409.7 | 9419.0 | 2727.0 |
| 2009-11-27 03:00:00 | YM | Futures | 9420.0 | 9497.2 | 9412.5 | 9486.0 | 4666.0 |
| 2009-11-27 04:00:00 | YM | Futures | 9486.0 | 9524.2 | 9474.9 | 9512.1 | 2857.0 |
| 2009-11-27 05:00:00 | YM | Futures | 9514.9 | 9530.7 | 9501.8 | 9501.8 | 1431.0 |
| 2009-11-27 06:00:00 | YM | Futures | 9501.8 | 9513.9 | 9476.7 | 9505.6 | 1896.0 |
| 2009-11-27 07:00:00 | YM | Futures | 9506.5 | 9520.4 | 9488.8 | 9517.6 | 2670.0 |
| 2009-11-27 08:00:00 | YM | Futures | 9516.7 | 9552.1 | 9513.9 | 9513.9 | 5721.0 |
| 2009-11-27 09:00:00 | YM | Futures | 9513.0 | 9561.4 | 9492.5 | 9554.9 | 24544.0 |
| 2009-11-27 10:00:00 | YM | Futures | 9554.9 | 9624.6 | 9551.1 | 9605.1 | 25684.0 |
| 2009-11-27 11:00:00 | YM | Futures | 9605.1 | 9643.2 | 9584.6 | 9606.0 | 23588.0 |
| 2009-11-27 12:00:00 | YM | Futures | 9606.0 | 9632.1 | 9577.2 | 9581.8 | 12675.0 |
| 2009-11-27 13:00:00 | YM | Futures | 9581.8 | 9582.8 | 9559.5 | 9570.7 | 3461.0 |
| 2009-11-27 00:00:00 | CL | Futures | 167.73 | 167.91 | 166.38 | 166.47 | 6960.0 |
| 2009-11-27 01:00:00 | CL | Futures | 166.49 | 166.8 | 164.81 | 164.97 | 12314.0 |
| 2009-11-27 02:00:00 | CL | Futures | 164.94 | 165.3 | 163.46 | 163.75 | 15978.0 |
| 2009-11-27 03:00:00 | CL | Futures | 163.73 | 164.1 | 160.34 | 163.84 | 38850.0 |
| 2009-11-27 04:00:00 | CL | Futures | 163.86 | 164.9 | 163.19 | 164.66 | 17478.0 |
| 2009-11-27 05:00:00 | CL | Futures | 164.66 | 164.86 | 163.86 | 164.39 | 10192.0 |
| 2009-11-27 06:00:00 | CL | Futures | 164.41 | 164.52 | 163.46 | 164.35 | 12060.0 |
| 2009-11-27 07:00:00 | CL | Futures | 164.35 | 164.88 | 163.55 | 164.7 | 14010.0 |
> showing 50 of 953 rows — these rows as CSV