PREVIEW / futures_1hour / 2010-02-07
file: by_date/futures_1hour/2010/2010-02-07.parquet size: 13 KB rows: 241
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 | 1031.42 | 11412.0 |
| 2010-02-07 19:00:00 | ES | Futures | 1031.42 | 1032.63 | 1028.98 | 1032.63 | 9716.0 |
| 2010-02-07 20:00:00 | ES | Futures | 1032.63 | 1032.88 | 1030.2 | 1030.44 | 4453.0 |
| 2010-02-07 21:00:00 | ES | Futures | 1030.44 | 1031.42 | 1029.47 | 1030.93 | 2840.0 |
| 2010-02-07 22:00:00 | ES | Futures | 1030.93 | 1032.63 | 1030.44 | 1032.39 | 3856.0 |
| 2010-02-07 23:00:00 | ES | Futures | 1032.39 | 1032.63 | 1030.44 | 1031.66 | 3758.0 |
| 2010-02-07 18:00:00 | NQ | Futures | 1996.26 | 1999.12 | 1989.98 | 1992.83 | 736.0 |
| 2010-02-07 19:00:00 | NQ | Futures | 1992.55 | 1995.41 | 1990.26 | 1995.12 | 706.0 |
| 2010-02-07 20:00:00 | NQ | Futures | 1995.41 | 1996.55 | 1992.83 | 1993.12 | 606.0 |
| 2010-02-07 21:00:00 | NQ | Futures | 1993.41 | 1994.55 | 1991.41 | 1993.69 | 246.0 |
| 2010-02-07 22:00:00 | NQ | Futures | 1993.41 | 1995.98 | 1993.12 | 1995.12 | 337.0 |
| 2010-02-07 23:00:00 | NQ | Futures | 1995.69 | 1995.69 | 1992.26 | 1994.26 | 197.0 |
| 2010-02-07 18:00:00 | YM | Futures | 9315.1 | 9324.4 | 9288.9 | 9301.0 | 418.0 |
| 2010-02-07 19:00:00 | YM | Futures | 9302.0 | 9315.1 | 9284.2 | 9313.2 | 619.0 |
| 2010-02-07 20:00:00 | YM | Futures | 9313.2 | 9318.8 | 9301.0 | 9302.0 | 473.0 |
| 2010-02-07 21:00:00 | YM | Futures | 9302.0 | 9311.3 | 9296.4 | 9308.5 | 318.0 |
| 2010-02-07 22:00:00 | YM | Futures | 9306.6 | 9317.9 | 9306.6 | 9317.9 | 304.0 |
| 2010-02-07 23:00:00 | YM | Futures | 9317.9 | 9318.8 | 9304.8 | 9313.2 | 170.0 |
| 2010-02-07 18:00:00 | CL | Futures | 154.3 | 154.3 | 153.0 | 153.15 | 1641.0 |
| 2010-02-07 19:00:00 | CL | Futures | 153.21 | 153.81 | 152.85 | 153.79 | 938.0 |
| 2010-02-07 20:00:00 | CL | Futures | 153.75 | 153.88 | 153.43 | 153.47 | 719.0 |
| 2010-02-07 21:00:00 | CL | Futures | 153.49 | 153.53 | 153.02 | 153.02 | 616.0 |
| 2010-02-07 22:00:00 | CL | Futures | 153.08 | 153.34 | 152.91 | 153.28 | 480.0 |
| 2010-02-07 23:00:00 | CL | Futures | 153.28 | 153.43 | 153.23 | 153.41 | 394.0 |
| 2010-02-07 18:00:00 | GC | Futures | 1504.0 | 1510.6 | 1500.2 | 1501.5 | 2586.0 |
| 2010-02-07 19:00:00 | GC | Futures | 1501.3 | 1506.6 | 1499.9 | 1504.9 | 2744.0 |
| 2010-02-07 20:00:00 | GC | Futures | 1504.7 | 1506.0 | 1500.2 | 1501.6 | 2133.0 |
| 2010-02-07 21:00:00 | GC | Futures | 1501.9 | 1503.6 | 1500.1 | 1502.9 | 1112.0 |
| 2010-02-07 22:00:00 | GC | Futures | 1502.9 | 1503.5 | 1500.5 | 1502.0 | 1098.0 |
| 2010-02-07 23:00:00 | GC | Futures | 1502.2 | 1503.5 | 1501.2 | 1502.9 | 1119.0 |
| 2010-02-07 18:00:00 | ZN | Futures | 96.443742 | 96.469125 | 96.367592 | 96.367592 | 4212.0 |
| 2010-02-07 19:00:00 | ZN | Futures | 96.367592 | 96.405667 | 96.304134 | 96.304134 | 5129.0 |
| 2010-02-07 20:00:00 | ZN | Futures | 96.304134 | 96.367592 | 96.304134 | 96.342209 | 2994.0 |
| 2010-02-07 21:00:00 | ZN | Futures | 96.354901 | 96.405667 | 96.342209 | 96.367592 | 4341.0 |
| 2010-02-07 22:00:00 | ZN | Futures | 96.354901 | 96.367592 | 96.342209 | 96.342209 | 1184.0 |
| 2010-02-07 23:00:00 | ZN | Futures | 96.342209 | 96.354901 | 96.329517 | 96.342209 | 1386.0 |
> showing 36 of 241 rows — these rows as CSV