PREVIEW / futures_1hour / 2013-02-10
file: by_date/futures_1hour/2013/2013-02-10.parquet size: 14 KB rows: 268
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 |
|---|---|---|---|---|---|---|---|
| 2013-02-10 18:00:00 | ES | Futures | 1553.4 | 1554.69 | 1552.38 | 1554.17 | 5820.0 |
| 2013-02-10 19:00:00 | ES | Futures | 1554.17 | 1554.43 | 1553.15 | 1553.4 | 2350.0 |
| 2013-02-10 20:00:00 | ES | Futures | 1553.4 | 1553.92 | 1553.15 | 1553.66 | 1299.0 |
| 2013-02-10 21:00:00 | ES | Futures | 1553.66 | 1553.92 | 1553.15 | 1553.4 | 1004.0 |
| 2013-02-10 22:00:00 | ES | Futures | 1553.4 | 1553.66 | 1553.15 | 1553.4 | 975.0 |
| 2013-02-10 23:00:00 | ES | Futures | 1553.4 | 1553.4 | 1552.89 | 1552.89 | 1153.0 |
| 2013-02-10 18:00:00 | NQ | Futures | 3226.5 | 3232.9 | 3226.21 | 3232.03 | 575.0 |
| 2013-02-10 19:00:00 | NQ | Futures | 3232.03 | 3232.61 | 3230.28 | 3230.87 | 240.0 |
| 2013-02-10 20:00:00 | NQ | Futures | 3230.87 | 3231.16 | 3229.7 | 3230.28 | 116.0 |
| 2013-02-10 21:00:00 | NQ | Futures | 3230.58 | 3230.87 | 3229.41 | 3230.87 | 96.0 |
| 2013-02-10 22:00:00 | NQ | Futures | 3230.87 | 3231.45 | 3229.99 | 3230.58 | 105.0 |
| 2013-02-10 23:00:00 | NQ | Futures | 3230.28 | 3230.28 | 3229.41 | 3229.99 | 58.0 |
| 2013-02-10 18:00:00 | YM | Futures | 14022.0 | 14030.0 | 14008.9 | 14027.0 | 590.0 |
| 2013-02-10 19:00:00 | YM | Futures | 14028.0 | 14028.0 | 14020.0 | 14021.0 | 174.0 |
| 2013-02-10 20:00:00 | YM | Futures | 14021.0 | 14025.0 | 14018.0 | 14022.0 | 162.0 |
| 2013-02-10 21:00:00 | YM | Futures | 14022.0 | 14022.0 | 14019.0 | 14021.0 | 80.0 |
| 2013-02-10 22:00:00 | YM | Futures | 14020.0 | 14022.0 | 14016.9 | 14018.0 | 137.0 |
| 2013-02-10 23:00:00 | YM | Futures | 14018.0 | 14020.0 | 14018.0 | 14019.0 | 176.0 |
| 2013-02-10 18:00:00 | CL | Futures | 153.09 | 153.2 | 152.99 | 153.04 | 536.0 |
| 2013-02-10 19:00:00 | CL | Futures | 153.05 | 153.28 | 153.02 | 153.1 | 383.0 |
| 2013-02-10 20:00:00 | CL | Futures | 153.13 | 153.2 | 153.02 | 153.04 | 474.0 |
| 2013-02-10 21:00:00 | CL | Futures | 153.04 | 153.07 | 152.91 | 152.93 | 329.0 |
| 2013-02-10 22:00:00 | CL | Futures | 152.91 | 153.09 | 152.83 | 152.99 | 318.0 |
| 2013-02-10 23:00:00 | CL | Futures | 152.99 | 152.99 | 152.85 | 152.86 | 319.0 |
| 2013-02-10 18:00:00 | GC | Futures | 2293.7 | 2295.2 | 2292.2 | 2292.8 | 750.0 |
| 2013-02-10 19:00:00 | GC | Futures | 2292.7 | 2296.6 | 2292.6 | 2294.9 | 979.0 |
| 2013-02-10 20:00:00 | GC | Futures | 2295.2 | 2295.5 | 2292.4 | 2293.5 | 1185.0 |
| 2013-02-10 21:00:00 | GC | Futures | 2293.5 | 2294.4 | 2293.1 | 2294.1 | 377.0 |
| 2013-02-10 22:00:00 | GC | Futures | 2293.9 | 2294.8 | 2292.8 | 2294.2 | 311.0 |
| 2013-02-10 23:00:00 | GC | Futures | 2294.1 | 2295.2 | 2293.4 | 2295.2 | 429.0 |
| 2013-02-10 18:00:00 | ZN | Futures | 117.23912 | 117.253029 | 117.183484 | 117.183484 | 2982.0 |
| 2013-02-10 19:00:00 | ZN | Futures | 117.183484 | 117.211302 | 117.169575 | 117.197393 | 1503.0 |
| 2013-02-10 20:00:00 | ZN | Futures | 117.211302 | 117.266938 | 117.197393 | 117.266938 | 3810.0 |
| 2013-02-10 21:00:00 | ZN | Futures | 117.266938 | 117.280847 | 117.23912 | 117.280847 | 1671.0 |
| 2013-02-10 22:00:00 | ZN | Futures | 117.280847 | 117.280847 | 117.23912 | 117.266938 | 1278.0 |
| 2013-02-10 23:00:00 | ZN | Futures | 117.280847 | 117.280847 | 117.253029 | 117.266938 | 926.0 |
> showing 36 of 268 rows — these rows as CSV