PREVIEW / futures_1hour / 2017-05-28
file: by_date/futures_1hour/2017/2017-05-28.parquet size: 14 KB rows: 257
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-05-28 18:00:00 | ES | Futures | 2637.47 | 2640.75 | 2637.2 | 2640.47 | 4819.0 |
| 2017-05-28 19:00:00 | ES | Futures | 2640.2 | 2640.75 | 2639.11 | 2639.38 | 1335.0 |
| 2017-05-28 20:00:00 | ES | Futures | 2639.11 | 2640.2 | 2637.2 | 2639.93 | 4553.0 |
| 2017-05-28 21:00:00 | ES | Futures | 2639.65 | 2640.2 | 2638.83 | 2639.65 | 2345.0 |
| 2017-05-28 22:00:00 | ES | Futures | 2639.93 | 2640.2 | 2639.38 | 2639.65 | 1784.0 |
| 2017-05-28 23:00:00 | ES | Futures | 2639.65 | 2640.47 | 2639.38 | 2639.93 | 1273.0 |
| 2017-05-28 18:00:00 | NQ | Futures | 6908.5 | 6921.03 | 6907.91 | 6919.54 | 1685.0 |
| 2017-05-28 19:00:00 | NQ | Futures | 6919.83 | 6919.83 | 6914.17 | 6915.36 | 450.0 |
| 2017-05-28 20:00:00 | NQ | Futures | 6915.06 | 6919.24 | 6910.89 | 6916.55 | 1482.0 |
| 2017-05-28 21:00:00 | NQ | Futures | 6916.55 | 6918.34 | 6914.77 | 6917.15 | 953.0 |
| 2017-05-28 22:00:00 | NQ | Futures | 6917.15 | 6918.94 | 6913.87 | 6915.96 | 1435.0 |
| 2017-05-28 23:00:00 | NQ | Futures | 6915.96 | 6918.05 | 6915.96 | 6916.55 | 336.0 |
| 2017-05-28 18:00:00 | YM | Futures | 22898.7 | 22917.2 | 22894.3 | 22912.8 | 881.0 |
| 2017-05-28 19:00:00 | YM | Futures | 22913.9 | 22915.0 | 22904.1 | 22905.2 | 383.0 |
| 2017-05-28 20:00:00 | YM | Futures | 22905.2 | 22912.8 | 22893.3 | 22908.5 | 1130.0 |
| 2017-05-28 21:00:00 | YM | Futures | 22908.5 | 22910.6 | 22901.9 | 22909.6 | 604.0 |
| 2017-05-28 22:00:00 | YM | Futures | 22909.6 | 22911.7 | 22903.0 | 22906.3 | 529.0 |
| 2017-05-28 23:00:00 | YM | Futures | 22907.4 | 22913.9 | 22906.3 | 22909.6 | 417.0 |
| 2017-05-28 18:00:00 | CL | Futures | 45.68 | 45.78 | 45.59 | 45.65 | 3503.0 |
| 2017-05-28 19:00:00 | CL | Futures | 45.65 | 45.72 | 45.64 | 45.68 | 1325.0 |
| 2017-05-28 20:00:00 | CL | Futures | 45.69 | 45.7 | 45.59 | 45.64 | 2584.0 |
| 2017-05-28 21:00:00 | CL | Futures | 45.63 | 45.65 | 45.48 | 45.5 | 4484.0 |
| 2017-05-28 22:00:00 | CL | Futures | 45.49 | 45.56 | 45.39 | 45.44 | 3504.0 |
| 2017-05-28 23:00:00 | CL | Futures | 45.43 | 45.49 | 45.38 | 45.38 | 2080.0 |
| 2017-05-28 18:00:00 | GC | Futures | 1701.8 | 1703.2 | 1699.6 | 1701.3 | 1815.0 |
| 2017-05-28 19:00:00 | GC | Futures | 1701.2 | 1702.4 | 1700.5 | 1702.0 | 1140.0 |
| 2017-05-28 20:00:00 | GC | Futures | 1702.0 | 1702.5 | 1699.4 | 1700.0 | 2908.0 |
| 2017-05-28 21:00:00 | GC | Futures | 1699.8 | 1700.9 | 1699.4 | 1700.4 | 1636.0 |
| 2017-05-28 22:00:00 | GC | Futures | 1700.4 | 1700.8 | 1699.4 | 1699.6 | 1683.0 |
| 2017-05-28 23:00:00 | GC | Futures | 1699.6 | 1700.0 | 1698.6 | 1698.9 | 1527.0 |
| 2017-05-28 18:00:00 | ZN | Futures | 125.159311 | 125.190311 | 125.143812 | 125.143812 | 6547.0 |
| 2017-05-28 19:00:00 | ZN | Futures | 125.159311 | 125.174811 | 125.128312 | 125.159311 | 3188.0 |
| 2017-05-28 20:00:00 | ZN | Futures | 125.159311 | 125.174811 | 125.112813 | 125.128312 | 7229.0 |
| 2017-05-28 21:00:00 | ZN | Futures | 125.128312 | 125.143812 | 125.081813 | 125.081813 | 7860.0 |
| 2017-05-28 22:00:00 | ZN | Futures | 125.081813 | 125.097313 | 125.050814 | 125.050814 | 5772.0 |
| 2017-05-28 23:00:00 | ZN | Futures | 125.050814 | 125.081813 | 125.035315 | 125.066314 | 6610.0 |
> showing 36 of 257 rows — these rows as CSV