PREVIEW / futures_30min / 2017-02-05
file: by_date/futures_30min/2017/2017-02-05.parquet size: 21 KB rows: 567
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-02-05 18:00:00 | ES | Futures | 2501.84 | 2502.11 | 2498.02 | 2498.56 | 5694.0 |
| 2017-02-05 18:30:00 | ES | Futures | 2498.29 | 2498.84 | 2498.02 | 2498.29 | 1607.0 |
| 2017-02-05 19:00:00 | ES | Futures | 2498.29 | 2498.56 | 2496.65 | 2497.2 | 3621.0 |
| 2017-02-05 19:30:00 | ES | Futures | 2497.2 | 2497.75 | 2496.38 | 2496.38 | 1383.0 |
| 2017-02-05 20:00:00 | ES | Futures | 2496.65 | 2497.2 | 2495.84 | 2497.2 | 3476.0 |
| 2017-02-05 20:30:00 | ES | Futures | 2496.93 | 2497.47 | 2496.65 | 2497.47 | 1500.0 |
| 2017-02-05 21:00:00 | ES | Futures | 2497.2 | 2499.65 | 2496.93 | 2498.84 | 3460.0 |
| 2017-02-05 21:30:00 | ES | Futures | 2498.84 | 2499.93 | 2498.84 | 2499.38 | 2203.0 |
| 2017-02-05 22:00:00 | ES | Futures | 2499.65 | 2499.65 | 2498.84 | 2499.11 | 533.0 |
| 2017-02-05 22:30:00 | ES | Futures | 2499.11 | 2499.38 | 2498.56 | 2498.84 | 1262.0 |
| 2017-02-05 23:00:00 | ES | Futures | 2499.11 | 2499.65 | 2498.56 | 2499.11 | 1241.0 |
| 2017-02-05 23:30:00 | ES | Futures | 2499.11 | 2499.65 | 2498.56 | 2499.65 | 1922.0 |
| 2017-02-05 18:00:00 | NQ | Futures | 6154.04 | 6157.32 | 6145.09 | 6145.39 | 1138.0 |
| 2017-02-05 18:30:00 | NQ | Futures | 6145.39 | 6145.39 | 6144.2 | 6145.39 | 517.0 |
| 2017-02-05 19:00:00 | NQ | Futures | 6145.09 | 6145.39 | 6142.41 | 6143.3 | 566.0 |
| 2017-02-05 19:30:00 | NQ | Futures | 6143.6 | 6144.79 | 6140.91 | 6141.21 | 486.0 |
| 2017-02-05 20:00:00 | NQ | Futures | 6141.51 | 6144.2 | 6140.32 | 6143.6 | 553.0 |
| 2017-02-05 20:30:00 | NQ | Futures | 6143.9 | 6144.2 | 6141.51 | 6142.7 | 257.0 |
| 2017-02-05 21:00:00 | NQ | Futures | 6143.0 | 6150.16 | 6142.41 | 6147.77 | 839.0 |
| 2017-02-05 21:30:00 | NQ | Futures | 6148.07 | 6149.56 | 6147.18 | 6148.67 | 334.0 |
| 2017-02-05 22:00:00 | NQ | Futures | 6148.37 | 6148.37 | 6146.58 | 6147.77 | 145.0 |
| 2017-02-05 22:30:00 | NQ | Futures | 6147.48 | 6149.27 | 6145.39 | 6148.97 | 421.0 |
| 2017-02-05 23:00:00 | NQ | Futures | 6148.67 | 6149.56 | 6147.77 | 6148.07 | 246.0 |
| 2017-02-05 23:30:00 | NQ | Futures | 6147.77 | 6148.67 | 6146.28 | 6148.67 | 269.0 |
| 2017-02-05 18:00:00 | YM | Futures | 21686.6 | 21706.2 | 21670.4 | 21671.5 | 1659.0 |
| 2017-02-05 18:30:00 | YM | Futures | 21670.4 | 21678.0 | 21670.4 | 21675.8 | 445.0 |
| 2017-02-05 19:00:00 | YM | Futures | 21675.8 | 21675.8 | 21662.8 | 21667.1 | 803.0 |
| 2017-02-05 19:30:00 | YM | Futures | 21667.1 | 21670.4 | 21657.4 | 21659.5 | 536.0 |
| 2017-02-05 20:00:00 | YM | Futures | 21660.6 | 21669.3 | 21655.2 | 21667.1 | 884.0 |
| 2017-02-05 20:30:00 | YM | Futures | 21667.1 | 21670.4 | 21664.9 | 21668.2 | 345.0 |
| 2017-02-05 21:00:00 | YM | Futures | 21668.2 | 21685.6 | 21667.1 | 21683.4 | 828.0 |
| 2017-02-05 21:30:00 | YM | Futures | 21683.4 | 21688.8 | 21682.3 | 21685.6 | 417.0 |
| 2017-02-05 22:00:00 | YM | Futures | 21686.6 | 21686.6 | 21681.2 | 21683.4 | 174.0 |
| 2017-02-05 22:30:00 | YM | Futures | 21684.5 | 21684.5 | 21676.9 | 21682.3 | 282.0 |
| 2017-02-05 23:00:00 | YM | Futures | 21681.2 | 21686.6 | 21679.0 | 21683.4 | 333.0 |
| 2017-02-05 23:30:00 | YM | Futures | 21683.4 | 21685.6 | 21676.9 | 21685.6 | 382.0 |
| 2017-02-05 18:00:00 | CL | Futures | 51.0 | 51.09 | 50.98 | 51.07 | 1559.0 |
| 2017-02-05 18:30:00 | CL | Futures | 51.07 | 51.11 | 51.02 | 51.11 | 609.0 |
| 2017-02-05 19:00:00 | CL | Futures | 51.1 | 51.13 | 51.06 | 51.09 | 1077.0 |
| 2017-02-05 19:30:00 | CL | Futures | 51.09 | 51.11 | 51.06 | 51.09 | 569.0 |
| 2017-02-05 20:00:00 | CL | Futures | 51.09 | 51.13 | 51.08 | 51.11 | 778.0 |
| 2017-02-05 20:30:00 | CL | Futures | 51.11 | 51.11 | 51.08 | 51.1 | 489.0 |
| 2017-02-05 21:00:00 | CL | Futures | 51.1 | 51.11 | 51.07 | 51.08 | 511.0 |
| 2017-02-05 21:30:00 | CL | Futures | 51.09 | 51.11 | 51.08 | 51.11 | 344.0 |
| 2017-02-05 22:00:00 | CL | Futures | 51.11 | 51.12 | 51.09 | 51.11 | 427.0 |
| 2017-02-05 22:30:00 | CL | Futures | 51.11 | 51.23 | 51.11 | 51.21 | 1977.0 |
| 2017-02-05 23:00:00 | CL | Futures | 51.2 | 51.21 | 51.17 | 51.19 | 863.0 |
| 2017-02-05 23:30:00 | CL | Futures | 51.19 | 51.2 | 51.16 | 51.19 | 414.0 |
| 2017-02-05 18:00:00 | GC | Futures | 1645.5 | 1651.9 | 1644.9 | 1645.7 | 3227.0 |
| 2017-02-05 18:30:00 | GC | Futures | 1645.7 | 1647.4 | 1644.1 | 1646.5 | 2117.0 |
> showing 50 of 567 rows — these rows as CSV