PREVIEW / futures_30min / 2017-05-28
file: by_date/futures_30min/2017/2017-05-28.parquet size: 19 KB rows: 487
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.47 | 2637.2 | 2639.11 | 3658.0 |
| 2017-05-28 18:30:00 | ES | Futures | 2639.38 | 2640.75 | 2639.11 | 2640.47 | 1161.0 |
| 2017-05-28 19:00:00 | ES | Futures | 2640.2 | 2640.75 | 2640.2 | 2640.2 | 592.0 |
| 2017-05-28 19:30:00 | ES | Futures | 2640.2 | 2640.47 | 2639.11 | 2639.38 | 743.0 |
| 2017-05-28 20:00:00 | ES | Futures | 2639.11 | 2639.11 | 2637.2 | 2639.11 | 3246.0 |
| 2017-05-28 20:30:00 | ES | Futures | 2639.11 | 2640.2 | 2638.83 | 2639.93 | 1307.0 |
| 2017-05-28 21:00:00 | ES | Futures | 2639.65 | 2640.2 | 2639.38 | 2639.65 | 670.0 |
| 2017-05-28 21:30:00 | ES | Futures | 2639.65 | 2639.93 | 2638.83 | 2639.65 | 1675.0 |
| 2017-05-28 22:00:00 | ES | Futures | 2639.93 | 2640.2 | 2639.38 | 2639.93 | 1236.0 |
| 2017-05-28 22:30:00 | ES | Futures | 2639.65 | 2640.2 | 2639.38 | 2639.65 | 548.0 |
| 2017-05-28 23:00:00 | ES | Futures | 2639.65 | 2640.47 | 2639.38 | 2640.47 | 450.0 |
| 2017-05-28 23:30:00 | ES | Futures | 2640.2 | 2640.2 | 2639.38 | 2639.93 | 823.0 |
| 2017-05-28 18:00:00 | NQ | Futures | 6908.5 | 6915.96 | 6907.91 | 6913.27 | 921.0 |
| 2017-05-28 18:30:00 | NQ | Futures | 6913.57 | 6921.03 | 6913.57 | 6919.54 | 764.0 |
| 2017-05-28 19:00:00 | NQ | Futures | 6919.83 | 6919.83 | 6917.15 | 6918.05 | 213.0 |
| 2017-05-28 19:30:00 | NQ | Futures | 6917.45 | 6917.45 | 6914.17 | 6915.36 | 237.0 |
| 2017-05-28 20:00:00 | NQ | Futures | 6915.06 | 6917.75 | 6910.89 | 6917.15 | 969.0 |
| 2017-05-28 20:30:00 | NQ | Futures | 6916.85 | 6919.24 | 6915.66 | 6916.55 | 513.0 |
| 2017-05-28 21:00:00 | NQ | Futures | 6916.55 | 6918.34 | 6915.36 | 6916.85 | 221.0 |
| 2017-05-28 21:30:00 | NQ | Futures | 6916.85 | 6918.05 | 6914.77 | 6917.15 | 732.0 |
| 2017-05-28 22:00:00 | NQ | Futures | 6917.15 | 6918.94 | 6913.87 | 6915.96 | 1284.0 |
| 2017-05-28 22:30:00 | NQ | Futures | 6915.66 | 6917.15 | 6915.36 | 6915.96 | 151.0 |
| 2017-05-28 23:00:00 | NQ | Futures | 6915.96 | 6918.05 | 6915.96 | 6917.75 | 158.0 |
| 2017-05-28 23:30:00 | NQ | Futures | 6917.75 | 6917.75 | 6916.26 | 6916.55 | 178.0 |
| 2017-05-28 18:00:00 | YM | Futures | 22898.7 | 22913.9 | 22894.3 | 22906.3 | 621.0 |
| 2017-05-28 18:30:00 | YM | Futures | 22906.3 | 22917.2 | 22904.1 | 22912.8 | 260.0 |
| 2017-05-28 19:00:00 | YM | Futures | 22913.9 | 22915.0 | 22910.6 | 22911.7 | 101.0 |
| 2017-05-28 19:30:00 | YM | Futures | 22911.7 | 22912.8 | 22904.1 | 22905.2 | 282.0 |
| 2017-05-28 20:00:00 | YM | Futures | 22905.2 | 22909.6 | 22893.3 | 22908.5 | 759.0 |
| 2017-05-28 20:30:00 | YM | Futures | 22908.5 | 22912.8 | 22905.2 | 22908.5 | 371.0 |
| 2017-05-28 21:00:00 | YM | Futures | 22908.5 | 22910.6 | 22906.3 | 22906.3 | 172.0 |
| 2017-05-28 21:30:00 | YM | Futures | 22905.2 | 22910.6 | 22901.9 | 22909.6 | 432.0 |
| 2017-05-28 22:00:00 | YM | Futures | 22909.6 | 22911.7 | 22903.0 | 22909.6 | 398.0 |
| 2017-05-28 22:30:00 | YM | Futures | 22908.5 | 22911.7 | 22905.2 | 22906.3 | 131.0 |
| 2017-05-28 23:00:00 | YM | Futures | 22907.4 | 22913.9 | 22906.3 | 22912.8 | 193.0 |
| 2017-05-28 23:30:00 | YM | Futures | 22911.7 | 22911.7 | 22907.4 | 22909.6 | 224.0 |
| 2017-05-28 18:00:00 | CL | Futures | 45.68 | 45.78 | 45.59 | 45.67 | 2489.0 |
| 2017-05-28 18:30:00 | CL | Futures | 45.68 | 45.76 | 45.61 | 45.65 | 1014.0 |
| 2017-05-28 19:00:00 | CL | Futures | 45.65 | 45.72 | 45.64 | 45.66 | 631.0 |
| 2017-05-28 19:30:00 | CL | Futures | 45.66 | 45.71 | 45.64 | 45.68 | 694.0 |
| 2017-05-28 20:00:00 | CL | Futures | 45.69 | 45.7 | 45.59 | 45.64 | 1851.0 |
| 2017-05-28 20:30:00 | CL | Futures | 45.64 | 45.65 | 45.6 | 45.64 | 733.0 |
| 2017-05-28 21:00:00 | CL | Futures | 45.63 | 45.65 | 45.49 | 45.58 | 2711.0 |
| 2017-05-28 21:30:00 | CL | Futures | 45.57 | 45.58 | 45.48 | 45.5 | 1773.0 |
| 2017-05-28 22:00:00 | CL | Futures | 45.49 | 45.56 | 45.49 | 45.5 | 1211.0 |
| 2017-05-28 22:30:00 | CL | Futures | 45.5 | 45.5 | 45.39 | 45.44 | 2293.0 |
| 2017-05-28 23:00:00 | CL | Futures | 45.43 | 45.49 | 45.42 | 45.44 | 1238.0 |
| 2017-05-28 23:30:00 | CL | Futures | 45.44 | 45.45 | 45.38 | 45.38 | 842.0 |
| 2017-05-28 18:00:00 | GC | Futures | 1701.8 | 1703.2 | 1699.6 | 1702.2 | 1359.0 |
| 2017-05-28 18:30:00 | GC | Futures | 1702.0 | 1702.1 | 1700.4 | 1701.3 | 456.0 |
> showing 50 of 487 rows — these rows as CSV