PREVIEW / futures_1hour / 2017-08-20
file: by_date/futures_1hour/2017/2017-08-20.parquet size: 14 KB rows: 281
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-08-20 18:00:00 | ES | Futures | 2655.49 | 2658.22 | 2653.85 | 2657.68 | 11972.0 |
| 2017-08-20 19:00:00 | ES | Futures | 2657.68 | 2658.5 | 2654.4 | 2655.76 | 5556.0 |
| 2017-08-20 20:00:00 | ES | Futures | 2655.76 | 2655.76 | 2650.84 | 2651.94 | 12548.0 |
| 2017-08-20 21:00:00 | ES | Futures | 2651.94 | 2653.03 | 2648.93 | 2651.66 | 12912.0 |
| 2017-08-20 22:00:00 | ES | Futures | 2651.66 | 2651.94 | 2649.75 | 2650.02 | 8692.0 |
| 2017-08-20 23:00:00 | ES | Futures | 2650.02 | 2651.39 | 2649.2 | 2650.84 | 4881.0 |
| 2017-08-20 18:00:00 | NQ | Futures | 6913.78 | 6927.78 | 6908.42 | 6920.33 | 2272.0 |
| 2017-08-20 19:00:00 | NQ | Futures | 6920.04 | 6921.53 | 6909.32 | 6917.06 | 1129.0 |
| 2017-08-20 20:00:00 | NQ | Futures | 6916.76 | 6917.36 | 6893.83 | 6899.49 | 3316.0 |
| 2017-08-20 21:00:00 | NQ | Futures | 6899.79 | 6902.77 | 6889.07 | 6898.9 | 3211.0 |
| 2017-08-20 22:00:00 | NQ | Futures | 6898.3 | 6901.87 | 6893.54 | 6893.83 | 1259.0 |
| 2017-08-20 23:00:00 | NQ | Futures | 6893.54 | 6901.87 | 6889.96 | 6899.79 | 1425.0 |
| 2017-08-20 18:00:00 | YM | Futures | 23608.1 | 23638.6 | 23607.0 | 23638.6 | 1225.0 |
| 2017-08-20 19:00:00 | YM | Futures | 23637.5 | 23641.8 | 23612.4 | 23622.2 | 900.0 |
| 2017-08-20 20:00:00 | YM | Futures | 23621.1 | 23622.2 | 23582.0 | 23592.8 | 2826.0 |
| 2017-08-20 21:00:00 | YM | Futures | 23592.8 | 23597.2 | 23572.2 | 23588.5 | 2034.0 |
| 2017-08-20 22:00:00 | YM | Futures | 23587.4 | 23593.9 | 23580.9 | 23580.9 | 808.0 |
| 2017-08-20 23:00:00 | YM | Futures | 23579.8 | 23593.9 | 23575.4 | 23589.6 | 924.0 |
| 2017-08-20 18:00:00 | CL | Futures | 44.21 | 44.23 | 44.09 | 44.1 | 2249.0 |
| 2017-08-20 19:00:00 | CL | Futures | 44.1 | 44.13 | 44.04 | 44.06 | 1594.0 |
| 2017-08-20 20:00:00 | CL | Futures | 44.06 | 44.08 | 43.94 | 44.04 | 5231.0 |
| 2017-08-20 21:00:00 | CL | Futures | 44.05 | 44.05 | 43.98 | 44.01 | 4677.0 |
| 2017-08-20 22:00:00 | CL | Futures | 44.01 | 44.09 | 44.01 | 44.01 | 4312.0 |
| 2017-08-20 23:00:00 | CL | Futures | 44.01 | 44.07 | 43.99 | 44.0 | 5039.0 |
| 2017-08-20 18:00:00 | GC | Futures | 1717.3 | 1718.9 | 1715.3 | 1716.7 | 4163.0 |
| 2017-08-20 19:00:00 | GC | Futures | 1716.6 | 1717.3 | 1713.4 | 1717.3 | 7384.0 |
| 2017-08-20 20:00:00 | GC | Futures | 1717.3 | 1719.9 | 1715.7 | 1716.7 | 7983.0 |
| 2017-08-20 21:00:00 | GC | Futures | 1716.7 | 1720.2 | 1714.5 | 1720.1 | 9727.0 |
| 2017-08-20 22:00:00 | GC | Futures | 1719.9 | 1720.6 | 1719.0 | 1720.3 | 5089.0 |
| 2017-08-20 23:00:00 | GC | Futures | 1720.3 | 1721.3 | 1720.1 | 1720.2 | 4084.0 |
| 2017-08-20 18:00:00 | ZN | Futures | 125.950222 | 125.965752 | 125.82598 | 125.84151 | 7115.0 |
| 2017-08-20 19:00:00 | ZN | Futures | 125.84151 | 125.872571 | 125.82598 | 125.84151 | 10357.0 |
| 2017-08-20 20:00:00 | ZN | Futures | 125.85704 | 125.919161 | 125.84151 | 125.85704 | 10231.0 |
| 2017-08-20 21:00:00 | ZN | Futures | 125.85704 | 125.919161 | 125.84151 | 125.903631 | 15796.0 |
| 2017-08-20 22:00:00 | ZN | Futures | 125.919161 | 125.934692 | 125.888101 | 125.903631 | 10349.0 |
| 2017-08-20 23:00:00 | ZN | Futures | 125.919161 | 125.919161 | 125.888101 | 125.919161 | 2553.0 |
> showing 36 of 281 rows — these rows as CSV