PREVIEW / futures_30min / 2015-08-02
file: by_date/futures_30min/2015/2015-08-02.parquet size: 20 KB rows: 512
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 |
|---|---|---|---|---|---|---|---|
| 2015-08-02 18:00:00 | ES | Futures | 2235.15 | 2237.55 | 2234.89 | 2237.02 | 2489.0 |
| 2015-08-02 18:30:00 | ES | Futures | 2237.02 | 2237.28 | 2235.69 | 2236.49 | 1176.0 |
| 2015-08-02 19:00:00 | ES | Futures | 2236.49 | 2236.49 | 2235.69 | 2235.95 | 1198.0 |
| 2015-08-02 19:30:00 | ES | Futures | 2235.95 | 2237.28 | 2235.95 | 2236.75 | 1138.0 |
| 2015-08-02 20:00:00 | ES | Futures | 2236.49 | 2237.02 | 2235.42 | 2235.69 | 1806.0 |
| 2015-08-02 20:30:00 | ES | Futures | 2235.69 | 2235.95 | 2233.56 | 2233.82 | 1954.0 |
| 2015-08-02 21:00:00 | ES | Futures | 2233.82 | 2233.82 | 2231.96 | 2232.49 | 3019.0 |
| 2015-08-02 21:30:00 | ES | Futures | 2232.76 | 2233.56 | 2231.96 | 2233.29 | 2495.0 |
| 2015-08-02 22:00:00 | ES | Futures | 2233.29 | 2234.62 | 2233.29 | 2233.29 | 1797.0 |
| 2015-08-02 22:30:00 | ES | Futures | 2233.56 | 2233.82 | 2232.49 | 2233.02 | 904.0 |
| 2015-08-02 23:00:00 | ES | Futures | 2233.02 | 2233.29 | 2232.49 | 2232.49 | 517.0 |
| 2015-08-02 23:30:00 | ES | Futures | 2232.76 | 2233.56 | 2232.49 | 2233.02 | 866.0 |
| 2015-08-02 18:00:00 | NQ | Futures | 5422.71 | 5427.44 | 5419.16 | 5425.96 | 490.0 |
| 2015-08-02 18:30:00 | NQ | Futures | 5426.26 | 5426.26 | 5423.0 | 5424.48 | 249.0 |
| 2015-08-02 19:00:00 | NQ | Futures | 5424.78 | 5425.07 | 5422.41 | 5423.59 | 89.0 |
| 2015-08-02 19:30:00 | NQ | Futures | 5424.19 | 5427.14 | 5424.19 | 5425.96 | 170.0 |
| 2015-08-02 20:00:00 | NQ | Futures | 5425.96 | 5426.26 | 5422.41 | 5423.89 | 133.0 |
| 2015-08-02 20:30:00 | NQ | Futures | 5423.3 | 5423.59 | 5417.38 | 5418.27 | 258.0 |
| 2015-08-02 21:00:00 | NQ | Futures | 5418.27 | 5418.27 | 5412.35 | 5414.72 | 607.0 |
| 2015-08-02 21:30:00 | NQ | Futures | 5414.13 | 5417.38 | 5412.95 | 5417.09 | 436.0 |
| 2015-08-02 22:00:00 | NQ | Futures | 5416.79 | 5420.64 | 5416.2 | 5417.09 | 264.0 |
| 2015-08-02 22:30:00 | NQ | Futures | 5416.79 | 5417.68 | 5414.72 | 5415.61 | 119.0 |
| 2015-08-02 23:00:00 | NQ | Futures | 5416.5 | 5416.79 | 5414.72 | 5414.72 | 114.0 |
| 2015-08-02 23:30:00 | NQ | Futures | 5414.72 | 5417.68 | 5414.43 | 5416.2 | 168.0 |
| 2015-08-02 18:00:00 | YM | Futures | 18562.0 | 18587.3 | 18562.0 | 18585.1 | 198.0 |
| 2015-08-02 18:30:00 | YM | Futures | 18584.1 | 18585.1 | 18574.6 | 18578.8 | 164.0 |
| 2015-08-02 19:00:00 | YM | Futures | 18579.9 | 18579.9 | 18572.5 | 18572.5 | 193.0 |
| 2015-08-02 19:30:00 | YM | Futures | 18573.6 | 18585.1 | 18573.6 | 18577.8 | 175.0 |
| 2015-08-02 20:00:00 | YM | Futures | 18577.8 | 18580.9 | 18570.4 | 18572.5 | 230.0 |
| 2015-08-02 20:30:00 | YM | Futures | 18572.5 | 18573.6 | 18554.6 | 18556.7 | 281.0 |
| 2015-08-02 21:00:00 | YM | Futures | 18555.6 | 18556.7 | 18542.0 | 18547.2 | 450.0 |
| 2015-08-02 21:30:00 | YM | Futures | 18547.2 | 18554.6 | 18543.0 | 18551.4 | 465.0 |
| 2015-08-02 22:00:00 | YM | Futures | 18552.5 | 18563.0 | 18552.5 | 18555.6 | 222.0 |
| 2015-08-02 22:30:00 | YM | Futures | 18555.6 | 18556.7 | 18548.3 | 18551.4 | 111.0 |
| 2015-08-02 23:00:00 | YM | Futures | 18552.5 | 18553.5 | 18547.2 | 18548.3 | 85.0 |
| 2015-08-02 23:30:00 | YM | Futures | 18549.3 | 18556.7 | 18548.3 | 18552.5 | 86.0 |
| 2015-08-02 18:00:00 | CL | Futures | 69.14 | 69.18 | 68.39 | 68.9 | 2920.0 |
| 2015-08-02 18:30:00 | CL | Futures | 68.92 | 68.99 | 68.81 | 68.98 | 521.0 |
| 2015-08-02 19:00:00 | CL | Futures | 68.98 | 69.05 | 68.93 | 69.04 | 491.0 |
| 2015-08-02 19:30:00 | CL | Futures | 69.04 | 69.11 | 68.98 | 69.08 | 514.0 |
| 2015-08-02 20:00:00 | CL | Futures | 69.07 | 69.17 | 69.04 | 69.05 | 816.0 |
| 2015-08-02 20:30:00 | CL | Futures | 69.04 | 69.14 | 69.01 | 69.12 | 461.0 |
| 2015-08-02 21:00:00 | CL | Futures | 69.12 | 69.17 | 69.04 | 69.08 | 937.0 |
| 2015-08-02 21:30:00 | CL | Futures | 69.07 | 69.07 | 68.9 | 69.07 | 677.0 |
| 2015-08-02 22:00:00 | CL | Futures | 69.04 | 69.07 | 68.9 | 69.07 | 506.0 |
| 2015-08-02 22:30:00 | CL | Futures | 69.05 | 69.11 | 68.99 | 69.04 | 306.0 |
| 2015-08-02 23:00:00 | CL | Futures | 69.04 | 69.18 | 69.04 | 69.14 | 342.0 |
| 2015-08-02 23:30:00 | CL | Futures | 69.14 | 69.26 | 69.11 | 69.14 | 526.0 |
| 2015-08-02 18:00:00 | GC | Futures | 1495.2 | 1496.3 | 1493.9 | 1494.4 | 1040.0 |
| 2015-08-02 18:30:00 | GC | Futures | 1494.4 | 1494.4 | 1493.0 | 1493.8 | 380.0 |
> showing 50 of 512 rows — these rows as CSV