PREVIEW / futures_30min / 2010-02-07
file: by_date/futures_30min/2010/2010-02-07.parquet size: 18 KB rows: 449
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-07 18:00:00 | ES | Futures | 1033.36 | 1033.61 | 1029.71 | 1029.71 | 9098.0 |
| 2010-02-07 18:30:00 | ES | Futures | 1029.96 | 1031.66 | 1029.71 | 1031.42 | 2314.0 |
| 2010-02-07 19:00:00 | ES | Futures | 1031.42 | 1032.15 | 1028.98 | 1030.44 | 6977.0 |
| 2010-02-07 19:30:00 | ES | Futures | 1030.44 | 1032.63 | 1030.2 | 1032.63 | 2739.0 |
| 2010-02-07 20:00:00 | ES | Futures | 1032.63 | 1032.88 | 1031.42 | 1031.9 | 2901.0 |
| 2010-02-07 20:30:00 | ES | Futures | 1031.66 | 1032.15 | 1030.2 | 1030.44 | 1552.0 |
| 2010-02-07 21:00:00 | ES | Futures | 1030.44 | 1031.42 | 1029.47 | 1030.2 | 1409.0 |
| 2010-02-07 21:30:00 | ES | Futures | 1029.96 | 1030.93 | 1029.47 | 1030.93 | 1431.0 |
| 2010-02-07 22:00:00 | ES | Futures | 1030.93 | 1032.39 | 1030.44 | 1032.15 | 2105.0 |
| 2010-02-07 22:30:00 | ES | Futures | 1032.39 | 1032.63 | 1031.66 | 1032.39 | 1751.0 |
| 2010-02-07 23:00:00 | ES | Futures | 1032.39 | 1032.63 | 1031.9 | 1032.63 | 1717.0 |
| 2010-02-07 23:30:00 | ES | Futures | 1032.63 | 1032.63 | 1030.44 | 1031.66 | 2041.0 |
| 2010-02-07 18:00:00 | NQ | Futures | 1996.26 | 1999.12 | 1989.98 | 1990.55 | 666.0 |
| 2010-02-07 18:30:00 | NQ | Futures | 1990.84 | 1992.83 | 1990.55 | 1992.83 | 70.0 |
| 2010-02-07 19:00:00 | NQ | Futures | 1992.55 | 1995.12 | 1990.26 | 1992.26 | 472.0 |
| 2010-02-07 19:30:00 | NQ | Futures | 1992.55 | 1995.41 | 1991.12 | 1995.12 | 234.0 |
| 2010-02-07 20:00:00 | NQ | Futures | 1995.41 | 1996.26 | 1994.55 | 1995.98 | 208.0 |
| 2010-02-07 20:30:00 | NQ | Futures | 1995.69 | 1996.55 | 1992.83 | 1993.12 | 398.0 |
| 2010-02-07 21:00:00 | NQ | Futures | 1993.41 | 1994.55 | 1991.41 | 1992.83 | 162.0 |
| 2010-02-07 21:30:00 | NQ | Futures | 1992.55 | 1993.98 | 1991.98 | 1993.69 | 84.0 |
| 2010-02-07 22:00:00 | NQ | Futures | 1993.41 | 1995.98 | 1993.12 | 1995.12 | 221.0 |
| 2010-02-07 22:30:00 | NQ | Futures | 1995.12 | 1995.69 | 1994.26 | 1995.12 | 116.0 |
| 2010-02-07 23:00:00 | NQ | Futures | 1995.69 | 1995.69 | 1994.55 | 1995.41 | 59.0 |
| 2010-02-07 23:30:00 | NQ | Futures | 1995.41 | 1995.41 | 1992.26 | 1994.26 | 138.0 |
| 2010-02-07 18:00:00 | YM | Futures | 9315.1 | 9324.4 | 9290.7 | 9290.7 | 198.0 |
| 2010-02-07 18:30:00 | YM | Futures | 9290.7 | 9302.0 | 9288.9 | 9301.0 | 220.0 |
| 2010-02-07 19:00:00 | YM | Futures | 9302.0 | 9311.3 | 9284.2 | 9299.2 | 459.0 |
| 2010-02-07 19:30:00 | YM | Futures | 9300.1 | 9315.1 | 9295.4 | 9313.2 | 160.0 |
| 2010-02-07 20:00:00 | YM | Futures | 9313.2 | 9318.8 | 9309.5 | 9311.3 | 293.0 |
| 2010-02-07 20:30:00 | YM | Futures | 9313.2 | 9316.0 | 9301.0 | 9302.0 | 180.0 |
| 2010-02-07 21:00:00 | YM | Futures | 9302.0 | 9308.5 | 9296.4 | 9302.9 | 150.0 |
| 2010-02-07 21:30:00 | YM | Futures | 9301.0 | 9311.3 | 9297.3 | 9308.5 | 168.0 |
| 2010-02-07 22:00:00 | YM | Futures | 9306.6 | 9317.9 | 9306.6 | 9315.1 | 175.0 |
| 2010-02-07 22:30:00 | YM | Futures | 9316.0 | 9317.9 | 9313.2 | 9317.9 | 129.0 |
| 2010-02-07 23:00:00 | YM | Futures | 9317.9 | 9318.8 | 9313.2 | 9318.8 | 75.0 |
| 2010-02-07 23:30:00 | YM | Futures | 9317.9 | 9317.9 | 9304.8 | 9313.2 | 95.0 |
| 2010-02-07 18:00:00 | CL | Futures | 154.3 | 154.3 | 153.0 | 153.19 | 1283.0 |
| 2010-02-07 18:30:00 | CL | Futures | 153.17 | 153.3 | 153.06 | 153.15 | 358.0 |
| 2010-02-07 19:00:00 | CL | Futures | 153.21 | 153.66 | 152.85 | 153.45 | 532.0 |
| 2010-02-07 19:30:00 | CL | Futures | 153.43 | 153.81 | 153.43 | 153.79 | 406.0 |
| 2010-02-07 20:00:00 | CL | Futures | 153.75 | 153.88 | 153.51 | 153.56 | 413.0 |
| 2010-02-07 20:30:00 | CL | Futures | 153.56 | 153.68 | 153.43 | 153.47 | 306.0 |
| 2010-02-07 21:00:00 | CL | Futures | 153.49 | 153.53 | 153.15 | 153.19 | 348.0 |
| 2010-02-07 21:30:00 | CL | Futures | 153.19 | 153.36 | 153.02 | 153.02 | 268.0 |
| 2010-02-07 22:00:00 | CL | Futures | 153.08 | 153.34 | 152.91 | 153.17 | 321.0 |
| 2010-02-07 22:30:00 | CL | Futures | 153.26 | 153.34 | 153.17 | 153.28 | 159.0 |
| 2010-02-07 23:00:00 | CL | Futures | 153.28 | 153.32 | 153.23 | 153.3 | 70.0 |
| 2010-02-07 23:30:00 | CL | Futures | 153.32 | 153.43 | 153.23 | 153.41 | 324.0 |
| 2010-02-07 18:00:00 | GC | Futures | 1504.0 | 1510.6 | 1500.2 | 1501.2 | 1939.0 |
| 2010-02-07 18:30:00 | GC | Futures | 1501.2 | 1503.2 | 1500.4 | 1501.5 | 647.0 |
> showing 50 of 449 rows — these rows as CSV