PREVIEW / futures_1hour / 2011-02-13
file: by_date/futures_1hour/2011/2011-02-13.parquet size: 14 KB rows: 265
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 |
|---|---|---|---|---|---|---|---|
| 2011-02-13 18:00:00 | ES | Futures | 1312.35 | 1315.07 | 1312.35 | 1314.33 | 9106.0 |
| 2011-02-13 19:00:00 | ES | Futures | 1314.33 | 1315.07 | 1313.34 | 1313.59 | 5829.0 |
| 2011-02-13 20:00:00 | ES | Futures | 1313.59 | 1313.84 | 1312.35 | 1312.35 | 4265.0 |
| 2011-02-13 21:00:00 | ES | Futures | 1312.35 | 1314.33 | 1311.86 | 1314.33 | 6683.0 |
| 2011-02-13 22:00:00 | ES | Futures | 1314.09 | 1315.07 | 1313.84 | 1314.83 | 4441.0 |
| 2011-02-13 23:00:00 | ES | Futures | 1314.83 | 1314.83 | 1313.84 | 1314.83 | 2010.0 |
| 2011-02-13 18:00:00 | NQ | Futures | 2728.24 | 2732.26 | 2727.38 | 2730.54 | 369.0 |
| 2011-02-13 19:00:00 | NQ | Futures | 2730.54 | 2732.26 | 2729.1 | 2729.39 | 106.0 |
| 2011-02-13 20:00:00 | NQ | Futures | 2729.68 | 2729.68 | 2727.67 | 2727.67 | 169.0 |
| 2011-02-13 21:00:00 | NQ | Futures | 2727.67 | 2731.97 | 2727.38 | 2731.69 | 540.0 |
| 2011-02-13 22:00:00 | NQ | Futures | 2731.69 | 2732.84 | 2730.83 | 2731.11 | 300.0 |
| 2011-02-13 23:00:00 | NQ | Futures | 2731.11 | 2731.4 | 2729.39 | 2731.4 | 125.0 |
| 2011-02-13 18:00:00 | YM | Futures | 11724.2 | 11733.8 | 11715.6 | 11730.9 | 433.0 |
| 2011-02-13 19:00:00 | YM | Futures | 11730.0 | 11737.6 | 11725.2 | 11728.0 | 223.0 |
| 2011-02-13 20:00:00 | YM | Futures | 11728.0 | 11728.0 | 11720.4 | 11720.4 | 149.0 |
| 2011-02-13 21:00:00 | YM | Futures | 11718.5 | 11730.9 | 11716.6 | 11730.0 | 232.0 |
| 2011-02-13 22:00:00 | YM | Futures | 11730.9 | 11735.7 | 11730.0 | 11733.8 | 140.0 |
| 2011-02-13 23:00:00 | YM | Futures | 11732.8 | 11737.6 | 11727.1 | 11737.6 | 274.0 |
| 2011-02-13 18:00:00 | CL | Futures | 157.39 | 158.11 | 157.39 | 157.97 | 411.0 |
| 2011-02-13 19:00:00 | CL | Futures | 157.95 | 157.95 | 157.21 | 157.88 | 189.0 |
| 2011-02-13 20:00:00 | CL | Futures | 157.83 | 157.84 | 157.53 | 157.61 | 261.0 |
| 2011-02-13 21:00:00 | CL | Futures | 157.67 | 157.84 | 157.49 | 157.72 | 297.0 |
| 2011-02-13 22:00:00 | CL | Futures | 157.77 | 158.07 | 157.77 | 158.02 | 168.0 |
| 2011-02-13 23:00:00 | CL | Futures | 157.95 | 157.95 | 157.56 | 157.61 | 155.0 |
| 2011-02-13 18:00:00 | GC | Futures | 1895.8 | 1896.3 | 1892.2 | 1893.5 | 2194.0 |
| 2011-02-13 19:00:00 | GC | Futures | 1893.2 | 1894.5 | 1890.5 | 1893.9 | 1860.0 |
| 2011-02-13 20:00:00 | GC | Futures | 1893.9 | 1895.8 | 1892.9 | 1893.3 | 1394.0 |
| 2011-02-13 21:00:00 | GC | Futures | 1893.3 | 1895.8 | 1892.8 | 1895.3 | 857.0 |
| 2011-02-13 22:00:00 | GC | Futures | 1895.6 | 1897.0 | 1894.5 | 1895.3 | 1022.0 |
| 2011-02-13 23:00:00 | GC | Futures | 1895.6 | 1896.1 | 1895.0 | 1895.4 | 727.0 |
| 2011-02-13 18:00:00 | ZN | Futures | 99.62989 | 99.682451 | 99.616749 | 99.66931 | 2202.0 |
| 2011-02-13 19:00:00 | ZN | Futures | 99.66931 | 99.721872 | 99.64303 | 99.708731 | 4047.0 |
| 2011-02-13 20:00:00 | ZN | Futures | 99.721872 | 99.774433 | 99.721872 | 99.748152 | 5210.0 |
| 2011-02-13 21:00:00 | ZN | Futures | 99.748152 | 99.761293 | 99.682451 | 99.682451 | 5594.0 |
| 2011-02-13 22:00:00 | ZN | Futures | 99.682451 | 99.695591 | 99.65617 | 99.65617 | 3480.0 |
| 2011-02-13 23:00:00 | ZN | Futures | 99.65617 | 99.682451 | 99.64303 | 99.65617 | 2624.0 |
> showing 36 of 265 rows — these rows as CSV