PREVIEW / futures_30min / 2014-09-14
file: by_date/futures_30min/2014/2014-09-14.parquet size: 19 KB rows: 502
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 |
|---|---|---|---|---|---|---|---|
| 2014-09-14 18:00:00 | ES | Futures | 2068.23 | 2069.8 | 2062.21 | 2064.56 | 14678.0 |
| 2014-09-14 18:30:00 | ES | Futures | 2064.83 | 2065.09 | 2063.78 | 2064.04 | 3171.0 |
| 2014-09-14 19:00:00 | ES | Futures | 2064.3 | 2064.3 | 2063.26 | 2064.04 | 2364.0 |
| 2014-09-14 19:30:00 | ES | Futures | 2064.04 | 2064.56 | 2063.26 | 2063.52 | 1986.0 |
| 2014-09-14 20:00:00 | ES | Futures | 2063.78 | 2064.83 | 2063.26 | 2064.56 | 3182.0 |
| 2014-09-14 20:30:00 | ES | Futures | 2064.56 | 2064.56 | 2063.26 | 2063.78 | 2635.0 |
| 2014-09-14 21:00:00 | ES | Futures | 2063.78 | 2064.83 | 2063.52 | 2064.56 | 2026.0 |
| 2014-09-14 21:30:00 | ES | Futures | 2064.3 | 2064.83 | 2063.52 | 2063.52 | 1872.0 |
| 2014-09-14 22:00:00 | ES | Futures | 2063.52 | 2064.83 | 2063.26 | 2064.3 | 2784.0 |
| 2014-09-14 22:30:00 | ES | Futures | 2064.56 | 2065.09 | 2064.3 | 2064.56 | 2213.0 |
| 2014-09-14 23:00:00 | ES | Futures | 2064.56 | 2064.56 | 2063.52 | 2063.78 | 1556.0 |
| 2014-09-14 23:30:00 | ES | Futures | 2063.78 | 2064.04 | 2063.52 | 2063.78 | 2253.0 |
| 2014-09-14 18:00:00 | NQ | Futures | 4748.45 | 4752.26 | 4729.11 | 4744.35 | 3499.0 |
| 2014-09-14 18:30:00 | NQ | Futures | 4744.06 | 4745.23 | 4742.88 | 4742.88 | 344.0 |
| 2014-09-14 19:00:00 | NQ | Futures | 4743.18 | 4743.18 | 4741.42 | 4743.18 | 383.0 |
| 2014-09-14 19:30:00 | NQ | Futures | 4743.47 | 4744.64 | 4741.71 | 4742.0 | 284.0 |
| 2014-09-14 20:00:00 | NQ | Futures | 4742.3 | 4745.23 | 4741.71 | 4744.64 | 463.0 |
| 2014-09-14 20:30:00 | NQ | Futures | 4744.35 | 4744.35 | 4741.71 | 4742.59 | 373.0 |
| 2014-09-14 21:00:00 | NQ | Futures | 4742.88 | 4746.11 | 4742.88 | 4745.23 | 513.0 |
| 2014-09-14 21:30:00 | NQ | Futures | 4744.64 | 4746.11 | 4742.88 | 4743.18 | 545.0 |
| 2014-09-14 22:00:00 | NQ | Futures | 4743.47 | 4744.35 | 4742.59 | 4744.06 | 328.0 |
| 2014-09-14 22:30:00 | NQ | Futures | 4744.35 | 4746.11 | 4744.35 | 4745.23 | 384.0 |
| 2014-09-14 23:00:00 | NQ | Futures | 4745.23 | 4745.52 | 4742.88 | 4743.76 | 113.0 |
| 2014-09-14 23:30:00 | NQ | Futures | 4743.47 | 4743.76 | 4742.59 | 4742.59 | 304.0 |
| 2014-09-14 18:00:00 | YM | Futures | 17547.0 | 17567.8 | 17508.6 | 17523.1 | 2134.0 |
| 2014-09-14 18:30:00 | YM | Futures | 17522.1 | 17526.2 | 17517.9 | 17520.0 | 329.0 |
| 2014-09-14 19:00:00 | YM | Futures | 17520.0 | 17520.0 | 17513.8 | 17516.9 | 485.0 |
| 2014-09-14 19:30:00 | YM | Futures | 17516.9 | 17523.1 | 17514.8 | 17516.9 | 224.0 |
| 2014-09-14 20:00:00 | YM | Futures | 17517.9 | 17525.2 | 17515.9 | 17524.2 | 562.0 |
| 2014-09-14 20:30:00 | YM | Futures | 17524.2 | 17524.2 | 17514.8 | 17517.9 | 401.0 |
| 2014-09-14 21:00:00 | YM | Futures | 17516.9 | 17529.4 | 17516.9 | 17524.2 | 399.0 |
| 2014-09-14 21:30:00 | YM | Futures | 17523.1 | 17526.2 | 17516.9 | 17517.9 | 258.0 |
| 2014-09-14 22:00:00 | YM | Futures | 17516.9 | 17522.1 | 17515.9 | 17522.1 | 388.0 |
| 2014-09-14 22:30:00 | YM | Futures | 17523.1 | 17529.4 | 17522.1 | 17525.2 | 443.0 |
| 2014-09-14 23:00:00 | YM | Futures | 17525.2 | 17525.2 | 17520.0 | 17521.0 | 192.0 |
| 2014-09-14 23:30:00 | YM | Futures | 17521.0 | 17523.1 | 17517.9 | 17520.0 | 620.0 |
| 2014-09-14 18:00:00 | CL | Futures | 151.99 | 152.33 | 151.49 | 151.53 | 306.0 |
| 2014-09-14 18:30:00 | CL | Futures | 151.44 | 151.68 | 151.38 | 151.56 | 63.0 |
| 2014-09-14 19:00:00 | CL | Futures | 151.56 | 151.56 | 150.11 | 150.4 | 826.0 |
| 2014-09-14 19:30:00 | CL | Futures | 150.51 | 150.55 | 149.53 | 150.0 | 689.0 |
| 2014-09-14 20:00:00 | CL | Futures | 150.0 | 150.48 | 149.95 | 150.45 | 453.0 |
| 2014-09-14 20:30:00 | CL | Futures | 150.43 | 150.51 | 150.26 | 150.48 | 198.0 |
| 2014-09-14 21:00:00 | CL | Futures | 150.48 | 150.63 | 150.4 | 150.45 | 191.0 |
| 2014-09-14 21:30:00 | CL | Futures | 150.48 | 150.56 | 150.36 | 150.53 | 90.0 |
| 2014-09-14 22:00:00 | CL | Futures | 150.53 | 150.55 | 150.26 | 150.26 | 114.0 |
| 2014-09-14 22:30:00 | CL | Futures | 150.28 | 150.48 | 150.28 | 150.48 | 55.0 |
| 2014-09-14 23:00:00 | CL | Futures | 150.48 | 150.6 | 150.45 | 150.46 | 131.0 |
| 2014-09-14 23:30:00 | CL | Futures | 150.45 | 150.81 | 150.45 | 150.65 | 390.0 |
| 2014-09-14 18:00:00 | GC | Futures | 1681.5 | 1684.4 | 1679.0 | 1681.3 | 2200.0 |
| 2014-09-14 18:30:00 | GC | Futures | 1681.5 | 1681.8 | 1678.7 | 1680.8 | 891.0 |
> showing 50 of 502 rows — these rows as CSV