PREVIEW / futures_1hour / 2017-04-02
file: by_date/futures_1hour/2017/2017-04-02.parquet size: 14 KB rows: 296
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 |
|---|---|---|---|---|---|---|---|
| 2017-04-02 18:00:00 | ES | Futures | 2575.74 | 2579.56 | 2575.19 | 2578.74 | 5723.0 |
| 2017-04-02 19:00:00 | ES | Futures | 2579.02 | 2579.29 | 2577.65 | 2577.65 | 3097.0 |
| 2017-04-02 20:00:00 | ES | Futures | 2577.65 | 2579.02 | 2574.1 | 2578.47 | 11700.0 |
| 2017-04-02 21:00:00 | ES | Futures | 2578.2 | 2579.56 | 2576.56 | 2578.2 | 7385.0 |
| 2017-04-02 22:00:00 | ES | Futures | 2578.2 | 2579.02 | 2577.38 | 2577.92 | 4129.0 |
| 2017-04-02 23:00:00 | ES | Futures | 2577.92 | 2578.47 | 2577.1 | 2577.38 | 2863.0 |
| 2017-04-02 18:00:00 | NQ | Futures | 6483.65 | 6492.6 | 6482.16 | 6491.11 | 1485.0 |
| 2017-04-02 19:00:00 | NQ | Futures | 6490.51 | 6492.3 | 6487.23 | 6488.72 | 520.0 |
| 2017-04-02 20:00:00 | NQ | Futures | 6488.72 | 6492.0 | 6478.88 | 6489.32 | 2992.0 |
| 2017-04-02 21:00:00 | NQ | Futures | 6489.02 | 6492.0 | 6485.74 | 6490.51 | 1833.0 |
| 2017-04-02 22:00:00 | NQ | Futures | 6490.51 | 6492.0 | 6488.43 | 6489.62 | 1226.0 |
| 2017-04-02 23:00:00 | NQ | Futures | 6489.62 | 6491.11 | 6488.13 | 6488.72 | 588.0 |
| 2017-04-02 18:00:00 | YM | Futures | 22386.8 | 22411.8 | 22377.0 | 22404.2 | 1130.0 |
| 2017-04-02 19:00:00 | YM | Futures | 22404.2 | 22407.5 | 22395.5 | 22398.8 | 430.0 |
| 2017-04-02 20:00:00 | YM | Futures | 22398.8 | 22406.4 | 22371.6 | 22402.0 | 2105.0 |
| 2017-04-02 21:00:00 | YM | Futures | 22400.9 | 22410.7 | 22392.2 | 22404.2 | 1414.0 |
| 2017-04-02 22:00:00 | YM | Futures | 22404.2 | 22407.5 | 22398.8 | 22403.1 | 665.0 |
| 2017-04-02 23:00:00 | YM | Futures | 22403.1 | 22406.4 | 22394.4 | 22396.6 | 555.0 |
| 2017-04-02 18:00:00 | CL | Futures | 47.08 | 47.14 | 46.97 | 47.02 | 3361.0 |
| 2017-04-02 19:00:00 | CL | Futures | 47.01 | 47.04 | 46.98 | 47.0 | 1488.0 |
| 2017-04-02 20:00:00 | CL | Futures | 47.0 | 47.02 | 46.95 | 46.99 | 1768.0 |
| 2017-04-02 21:00:00 | CL | Futures | 47.0 | 47.06 | 46.97 | 46.98 | 1650.0 |
| 2017-04-02 22:00:00 | CL | Futures | 46.98 | 47.0 | 46.95 | 46.97 | 1306.0 |
| 2017-04-02 23:00:00 | CL | Futures | 46.96 | 46.99 | 46.91 | 46.92 | 1903.0 |
| 2017-04-02 18:00:00 | GC | Futures | 1680.7 | 1681.7 | 1677.7 | 1680.1 | 1904.0 |
| 2017-04-02 19:00:00 | GC | Futures | 1680.1 | 1680.7 | 1678.4 | 1678.5 | 1739.0 |
| 2017-04-02 20:00:00 | GC | Futures | 1678.5 | 1680.8 | 1678.0 | 1679.2 | 3872.0 |
| 2017-04-02 21:00:00 | GC | Futures | 1679.2 | 1680.0 | 1678.4 | 1678.5 | 1656.0 |
| 2017-04-02 22:00:00 | GC | Futures | 1678.5 | 1679.1 | 1677.6 | 1678.4 | 2295.0 |
| 2017-04-02 23:00:00 | GC | Futures | 1678.5 | 1679.5 | 1678.0 | 1679.2 | 1605.0 |
| 2017-04-02 18:00:00 | ZN | Futures | 123.593851 | 123.609351 | 123.500854 | 123.531853 | 10485.0 |
| 2017-04-02 19:00:00 | ZN | Futures | 123.547352 | 123.562852 | 123.516353 | 123.547352 | 6941.0 |
| 2017-04-02 20:00:00 | ZN | Futures | 123.562852 | 123.578352 | 123.516353 | 123.531853 | 16686.0 |
| 2017-04-02 21:00:00 | ZN | Futures | 123.547352 | 123.578352 | 123.531853 | 123.547352 | 12072.0 |
| 2017-04-02 22:00:00 | ZN | Futures | 123.547352 | 123.562852 | 123.547352 | 123.547352 | 3402.0 |
| 2017-04-02 23:00:00 | ZN | Futures | 123.547352 | 123.578352 | 123.547352 | 123.562852 | 6935.0 |
> showing 36 of 296 rows — these rows as CSV