PREVIEW / futures_1hour / 2010-02-08
file: by_date/futures_1hour/2010/2010-02-08.parquet size: 46 KB rows: 1,381
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 |
|---|---|---|---|---|---|---|---|
| 2010-02-08 00:00:00 | ES | Futures | 1031.66 | 1032.39 | 1030.44 | 1030.93 | 4143.0 |
| 2010-02-08 01:00:00 | ES | Futures | 1030.69 | 1031.17 | 1028.98 | 1029.47 | 6659.0 |
| 2010-02-08 02:00:00 | ES | Futures | 1029.23 | 1034.58 | 1028.74 | 1032.63 | 17424.0 |
| 2010-02-08 03:00:00 | ES | Futures | 1032.88 | 1037.99 | 1031.9 | 1036.53 | 39277.0 |
| 2010-02-08 04:00:00 | ES | Futures | 1036.53 | 1037.26 | 1033.61 | 1035.07 | 25498.0 |
| 2010-02-08 05:00:00 | ES | Futures | 1035.07 | 1035.55 | 1030.69 | 1031.42 | 26631.0 |
| 2010-02-08 06:00:00 | ES | Futures | 1031.42 | 1032.88 | 1029.96 | 1030.44 | 22851.0 |
| 2010-02-08 07:00:00 | ES | Futures | 1030.2 | 1034.09 | 1027.53 | 1033.12 | 58073.0 |
| 2010-02-08 08:00:00 | ES | Futures | 1033.36 | 1034.58 | 1031.42 | 1033.61 | 52270.0 |
| 2010-02-08 09:00:00 | ES | Futures | 1033.61 | 1035.55 | 1027.53 | 1031.17 | 287936.0 |
| 2010-02-08 10:00:00 | ES | Futures | 1031.17 | 1036.53 | 1030.2 | 1036.53 | 307932.0 |
| 2010-02-08 11:00:00 | ES | Futures | 1036.53 | 1039.69 | 1036.28 | 1037.01 | 216193.0 |
| 2010-02-08 12:00:00 | ES | Futures | 1037.26 | 1038.23 | 1035.07 | 1036.77 | 116777.0 |
| 2010-02-08 13:00:00 | ES | Futures | 1036.77 | 1037.01 | 1030.93 | 1032.15 | 172590.0 |
| 2010-02-08 14:00:00 | ES | Futures | 1032.39 | 1035.07 | 1030.93 | 1031.66 | 149782.0 |
| 2010-02-08 15:00:00 | ES | Futures | 1031.9 | 1032.39 | 1024.61 | 1025.58 | 395104.0 |
| 2010-02-08 16:00:00 | ES | Futures | 1025.58 | 1027.77 | 1025.34 | 1026.55 | 117830.0 |
| 2010-02-08 17:00:00 | ES | Futures | 1026.55 | 1026.8 | 1025.58 | 1026.07 | 2522.0 |
| 2010-02-08 18:00:00 | ES | Futures | 1026.31 | 1028.01 | 1025.82 | 1027.04 | 5339.0 |
| 2010-02-08 19:00:00 | ES | Futures | 1027.04 | 1028.74 | 1026.07 | 1027.28 | 6927.0 |
| 2010-02-08 20:00:00 | ES | Futures | 1027.28 | 1028.74 | 1026.07 | 1028.5 | 4764.0 |
| 2010-02-08 21:00:00 | ES | Futures | 1028.5 | 1029.23 | 1027.77 | 1028.01 | 4544.0 |
| 2010-02-08 22:00:00 | ES | Futures | 1028.01 | 1028.25 | 1027.04 | 1028.01 | 2750.0 |
| 2010-02-08 23:00:00 | ES | Futures | 1028.25 | 1029.23 | 1027.77 | 1029.23 | 3223.0 |
| 2010-02-08 00:00:00 | NQ | Futures | 1994.26 | 1995.12 | 1992.26 | 1992.83 | 198.0 |
| 2010-02-08 01:00:00 | NQ | Futures | 1992.83 | 1993.41 | 1989.69 | 1989.98 | 333.0 |
| 2010-02-08 02:00:00 | NQ | Futures | 1989.98 | 1997.98 | 1988.84 | 1996.26 | 1413.0 |
| 2010-02-08 03:00:00 | NQ | Futures | 1996.26 | 2003.4 | 1994.26 | 2001.97 | 3491.0 |
| 2010-02-08 04:00:00 | NQ | Futures | 2002.26 | 2002.83 | 1996.26 | 1998.55 | 1305.0 |
| 2010-02-08 05:00:00 | NQ | Futures | 1998.83 | 1999.98 | 1992.26 | 1992.83 | 1891.0 |
| 2010-02-08 06:00:00 | NQ | Futures | 1992.55 | 1995.12 | 1989.98 | 1990.84 | 1088.0 |
| 2010-02-08 07:00:00 | NQ | Futures | 1990.55 | 1998.26 | 1985.69 | 1996.55 | 3600.0 |
| 2010-02-08 08:00:00 | NQ | Futures | 1996.26 | 1998.55 | 1992.55 | 1996.83 | 3649.0 |
| 2010-02-08 09:00:00 | NQ | Futures | 1997.12 | 1998.83 | 1978.55 | 1988.55 | 58479.0 |
| 2010-02-08 10:00:00 | NQ | Futures | 1988.84 | 1996.83 | 1987.12 | 1995.98 | 49751.0 |
| 2010-02-08 11:00:00 | NQ | Futures | 1996.26 | 2003.69 | 1996.26 | 2000.26 | 33681.0 |
| 2010-02-08 12:00:00 | NQ | Futures | 2000.26 | 2003.4 | 1996.55 | 2001.12 | 17779.0 |
| 2010-02-08 13:00:00 | NQ | Futures | 2001.12 | 2001.69 | 1988.55 | 1993.98 | 30562.0 |
| 2010-02-08 14:00:00 | NQ | Futures | 1994.26 | 1998.55 | 1990.55 | 1991.98 | 22696.0 |
| 2010-02-08 15:00:00 | NQ | Futures | 1991.98 | 1993.41 | 1978.84 | 1980.55 | 49454.0 |
| 2010-02-08 16:00:00 | NQ | Futures | 1980.55 | 1983.98 | 1977.12 | 1979.41 | 13293.0 |
| 2010-02-08 17:00:00 | NQ | Futures | 1979.41 | 1980.55 | 1978.84 | 1979.7 | 205.0 |
| 2010-02-08 18:00:00 | NQ | Futures | 1980.27 | 1982.55 | 1979.7 | 1981.12 | 344.0 |
| 2010-02-08 19:00:00 | NQ | Futures | 1981.41 | 1983.41 | 1980.84 | 1981.12 | 580.0 |
| 2010-02-08 20:00:00 | NQ | Futures | 1981.69 | 1983.69 | 1979.7 | 1983.69 | 408.0 |
| 2010-02-08 21:00:00 | NQ | Futures | 1983.69 | 1985.41 | 1983.41 | 1984.55 | 379.0 |
| 2010-02-08 22:00:00 | NQ | Futures | 1984.27 | 1984.55 | 1982.55 | 1984.55 | 332.0 |
| 2010-02-08 23:00:00 | NQ | Futures | 1984.55 | 1985.98 | 1983.69 | 1985.41 | 147.0 |
| 2010-02-08 00:00:00 | YM | Futures | 9312.3 | 9314.1 | 9300.1 | 9302.9 | 314.0 |
| 2010-02-08 01:00:00 | YM | Futures | 9302.0 | 9302.0 | 9286.1 | 9289.8 | 300.0 |
> showing 50 of 1,381 rows — these rows as CSV