PREVIEW / futures_1hour / 2015-08-02
file: by_date/futures_1hour/2015/2015-08-02.parquet size: 14 KB rows: 272
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 |
|---|---|---|---|---|---|---|---|
| 2015-08-02 18:00:00 | ES | Futures | 2235.15 | 2237.55 | 2234.89 | 2236.49 | 3665.0 |
| 2015-08-02 19:00:00 | ES | Futures | 2236.49 | 2237.28 | 2235.69 | 2236.75 | 2336.0 |
| 2015-08-02 20:00:00 | ES | Futures | 2236.49 | 2237.02 | 2233.56 | 2233.82 | 3760.0 |
| 2015-08-02 21:00:00 | ES | Futures | 2233.82 | 2233.82 | 2231.96 | 2233.29 | 5514.0 |
| 2015-08-02 22:00:00 | ES | Futures | 2233.29 | 2234.62 | 2232.49 | 2233.02 | 2701.0 |
| 2015-08-02 23:00:00 | ES | Futures | 2233.02 | 2233.56 | 2232.49 | 2233.02 | 1383.0 |
| 2015-08-02 18:00:00 | NQ | Futures | 5422.71 | 5427.44 | 5419.16 | 5424.48 | 739.0 |
| 2015-08-02 19:00:00 | NQ | Futures | 5424.78 | 5427.14 | 5422.41 | 5425.96 | 259.0 |
| 2015-08-02 20:00:00 | NQ | Futures | 5425.96 | 5426.26 | 5417.38 | 5418.27 | 391.0 |
| 2015-08-02 21:00:00 | NQ | Futures | 5418.27 | 5418.27 | 5412.35 | 5417.09 | 1043.0 |
| 2015-08-02 22:00:00 | NQ | Futures | 5416.79 | 5420.64 | 5414.72 | 5415.61 | 383.0 |
| 2015-08-02 23:00:00 | NQ | Futures | 5416.5 | 5417.68 | 5414.43 | 5416.2 | 282.0 |
| 2015-08-02 18:00:00 | YM | Futures | 18562.0 | 18587.3 | 18562.0 | 18578.8 | 362.0 |
| 2015-08-02 19:00:00 | YM | Futures | 18579.9 | 18585.1 | 18572.5 | 18577.8 | 368.0 |
| 2015-08-02 20:00:00 | YM | Futures | 18577.8 | 18580.9 | 18554.6 | 18556.7 | 511.0 |
| 2015-08-02 21:00:00 | YM | Futures | 18555.6 | 18556.7 | 18542.0 | 18551.4 | 915.0 |
| 2015-08-02 22:00:00 | YM | Futures | 18552.5 | 18563.0 | 18548.3 | 18551.4 | 333.0 |
| 2015-08-02 23:00:00 | YM | Futures | 18552.5 | 18556.7 | 18547.2 | 18552.5 | 171.0 |
| 2015-08-02 18:00:00 | CL | Futures | 69.14 | 69.18 | 68.39 | 68.98 | 3441.0 |
| 2015-08-02 19:00:00 | CL | Futures | 68.98 | 69.11 | 68.93 | 69.08 | 1005.0 |
| 2015-08-02 20:00:00 | CL | Futures | 69.07 | 69.17 | 69.01 | 69.12 | 1277.0 |
| 2015-08-02 21:00:00 | CL | Futures | 69.12 | 69.17 | 68.9 | 69.07 | 1614.0 |
| 2015-08-02 22:00:00 | CL | Futures | 69.04 | 69.11 | 68.9 | 69.04 | 812.0 |
| 2015-08-02 23:00:00 | CL | Futures | 69.04 | 69.26 | 69.04 | 69.14 | 868.0 |
| 2015-08-02 18:00:00 | GC | Futures | 1495.2 | 1496.3 | 1493.0 | 1493.8 | 1420.0 |
| 2015-08-02 19:00:00 | GC | Futures | 1493.8 | 1494.4 | 1491.2 | 1491.8 | 661.0 |
| 2015-08-02 20:00:00 | GC | Futures | 1491.9 | 1492.6 | 1490.0 | 1491.5 | 2199.0 |
| 2015-08-02 21:00:00 | GC | Futures | 1491.5 | 1493.9 | 1491.1 | 1491.6 | 3244.0 |
| 2015-08-02 22:00:00 | GC | Futures | 1491.5 | 1493.9 | 1491.2 | 1493.4 | 3378.0 |
| 2015-08-02 23:00:00 | GC | Futures | 1493.4 | 1499.1 | 1493.1 | 1495.7 | 3107.0 |
| 2015-08-02 18:00:00 | ZN | Futures | 122.723825 | 122.753886 | 122.648673 | 122.648673 | 6038.0 |
| 2015-08-02 19:00:00 | ZN | Futures | 122.648673 | 122.678734 | 122.603581 | 122.603581 | 5663.0 |
| 2015-08-02 20:00:00 | ZN | Futures | 122.603581 | 122.618612 | 122.57352 | 122.603581 | 11884.0 |
| 2015-08-02 21:00:00 | ZN | Futures | 122.603581 | 122.633642 | 122.543459 | 122.55849 | 12399.0 |
| 2015-08-02 22:00:00 | ZN | Futures | 122.543459 | 122.57352 | 122.543459 | 122.543459 | 3648.0 |
| 2015-08-02 23:00:00 | ZN | Futures | 122.543459 | 122.57352 | 122.543459 | 122.55849 | 2160.0 |
> showing 36 of 272 rows — these rows as CSV