PREVIEW / futures_1hour / 2017-07-09
file: by_date/futures_1hour/2017/2017-07-09.parquet size: 14 KB rows: 292
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-07-09 18:00:00 | ES | Futures | 2649.2 | 2650.57 | 2649.2 | 2649.48 | 3565.0 |
| 2017-07-09 19:00:00 | ES | Futures | 2649.48 | 2652.48 | 2648.93 | 2651.94 | 4825.0 |
| 2017-07-09 20:00:00 | ES | Futures | 2651.66 | 2653.03 | 2651.66 | 2652.76 | 4217.0 |
| 2017-07-09 21:00:00 | ES | Futures | 2652.76 | 2653.58 | 2651.94 | 2653.58 | 4390.0 |
| 2017-07-09 22:00:00 | ES | Futures | 2653.58 | 2655.76 | 2653.03 | 2654.4 | 7373.0 |
| 2017-07-09 23:00:00 | ES | Futures | 2654.4 | 2656.04 | 2654.4 | 2655.49 | 3309.0 |
| 2017-07-09 18:00:00 | NQ | Futures | 6744.66 | 6744.66 | 6739.3 | 6739.3 | 878.0 |
| 2017-07-09 19:00:00 | NQ | Futures | 6739.3 | 6746.75 | 6736.32 | 6744.96 | 818.0 |
| 2017-07-09 20:00:00 | NQ | Futures | 6744.96 | 6748.23 | 6741.98 | 6747.64 | 945.0 |
| 2017-07-09 21:00:00 | NQ | Futures | 6747.64 | 6757.76 | 6744.36 | 6755.98 | 1673.0 |
| 2017-07-09 22:00:00 | NQ | Futures | 6755.98 | 6771.76 | 6754.19 | 6764.91 | 3088.0 |
| 2017-07-09 23:00:00 | NQ | Futures | 6765.21 | 6768.78 | 6763.12 | 6765.5 | 795.0 |
| 2017-07-09 18:00:00 | YM | Futures | 23248.9 | 23263.0 | 23248.9 | 23256.5 | 503.0 |
| 2017-07-09 19:00:00 | YM | Futures | 23255.4 | 23269.6 | 23252.1 | 23265.2 | 579.0 |
| 2017-07-09 20:00:00 | YM | Futures | 23265.2 | 23269.6 | 23261.9 | 23268.5 | 683.0 |
| 2017-07-09 21:00:00 | YM | Futures | 23268.5 | 23277.2 | 23264.1 | 23275.0 | 851.0 |
| 2017-07-09 22:00:00 | YM | Futures | 23275.0 | 23294.6 | 23272.8 | 23285.9 | 1398.0 |
| 2017-07-09 23:00:00 | YM | Futures | 23285.9 | 23293.5 | 23282.6 | 23289.2 | 668.0 |
| 2017-07-09 18:00:00 | CL | Futures | 40.38 | 40.72 | 40.36 | 40.44 | 5262.0 |
| 2017-07-09 19:00:00 | CL | Futures | 40.44 | 40.54 | 40.44 | 40.53 | 1604.0 |
| 2017-07-09 20:00:00 | CL | Futures | 40.54 | 40.65 | 40.47 | 40.58 | 5590.0 |
| 2017-07-09 21:00:00 | CL | Futures | 40.58 | 40.65 | 40.57 | 40.63 | 3551.0 |
| 2017-07-09 22:00:00 | CL | Futures | 40.63 | 40.67 | 40.54 | 40.64 | 5603.0 |
| 2017-07-09 23:00:00 | CL | Futures | 40.64 | 40.65 | 40.57 | 40.59 | 2793.0 |
| 2017-07-09 18:00:00 | GC | Futures | 1622.7 | 1624.5 | 1620.8 | 1623.1 | 3590.0 |
| 2017-07-09 19:00:00 | GC | Futures | 1623.1 | 1624.2 | 1621.5 | 1623.7 | 3302.0 |
| 2017-07-09 20:00:00 | GC | Futures | 1623.7 | 1623.9 | 1622.5 | 1623.7 | 4101.0 |
| 2017-07-09 21:00:00 | GC | Futures | 1623.7 | 1623.7 | 1619.4 | 1619.9 | 6860.0 |
| 2017-07-09 22:00:00 | GC | Futures | 1619.8 | 1622.2 | 1619.8 | 1621.1 | 3853.0 |
| 2017-07-09 23:00:00 | GC | Futures | 1621.3 | 1621.3 | 1619.5 | 1620.0 | 3206.0 |
| 2017-07-09 18:00:00 | ZN | Futures | 124.148714 | 124.179775 | 124.117654 | 124.164244 | 5471.0 |
| 2017-07-09 19:00:00 | ZN | Futures | 124.164244 | 124.179775 | 124.133184 | 124.164244 | 5538.0 |
| 2017-07-09 20:00:00 | ZN | Futures | 124.148714 | 124.164244 | 124.117654 | 124.133184 | 6548.0 |
| 2017-07-09 21:00:00 | ZN | Futures | 124.117654 | 124.133184 | 124.102124 | 124.102124 | 6461.0 |
| 2017-07-09 22:00:00 | ZN | Futures | 124.102124 | 124.133184 | 124.102124 | 124.133184 | 3638.0 |
| 2017-07-09 23:00:00 | ZN | Futures | 124.133184 | 124.133184 | 124.102124 | 124.117654 | 3947.0 |
> showing 36 of 292 rows — these rows as CSV