PREVIEW / futures_30min / 2017-02-26
file: by_date/futures_30min/2017/2017-02-26.parquet size: 21 KB rows: 568
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-26 18:00:00 | ES | Futures | 2577.94 | 2584.21 | 2577.67 | 2582.58 | 9477.0 |
| 2017-02-26 18:30:00 | ES | Futures | 2582.3 | 2583.12 | 2581.76 | 2582.85 | 1996.0 |
| 2017-02-26 19:00:00 | ES | Futures | 2582.85 | 2583.39 | 2580.67 | 2582.03 | 4516.0 |
| 2017-02-26 19:30:00 | ES | Futures | 2581.76 | 2583.12 | 2579.58 | 2579.85 | 4616.0 |
| 2017-02-26 20:00:00 | ES | Futures | 2579.85 | 2580.12 | 2578.48 | 2579.85 | 5047.0 |
| 2017-02-26 20:30:00 | ES | Futures | 2580.12 | 2580.94 | 2579.3 | 2580.94 | 2151.0 |
| 2017-02-26 21:00:00 | ES | Futures | 2580.94 | 2582.03 | 2580.67 | 2581.49 | 2500.0 |
| 2017-02-26 21:30:00 | ES | Futures | 2581.49 | 2583.12 | 2580.94 | 2582.85 | 1799.0 |
| 2017-02-26 22:00:00 | ES | Futures | 2582.58 | 2583.39 | 2582.3 | 2582.85 | 2256.0 |
| 2017-02-26 22:30:00 | ES | Futures | 2582.85 | 2583.39 | 2582.3 | 2583.39 | 1278.0 |
| 2017-02-26 23:00:00 | ES | Futures | 2583.39 | 2585.85 | 2583.12 | 2583.94 | 6146.0 |
| 2017-02-26 23:30:00 | ES | Futures | 2583.94 | 2585.3 | 2583.94 | 2584.49 | 2088.0 |
| 2017-02-26 18:00:00 | NQ | Futures | 6372.11 | 6385.24 | 6368.83 | 6381.96 | 1425.0 |
| 2017-02-26 18:30:00 | NQ | Futures | 6382.25 | 6383.15 | 6380.46 | 6382.85 | 585.0 |
| 2017-02-26 19:00:00 | NQ | Futures | 6383.15 | 6383.45 | 6375.69 | 6378.08 | 1155.0 |
| 2017-02-26 19:30:00 | NQ | Futures | 6378.38 | 6381.06 | 6374.8 | 6375.99 | 1047.0 |
| 2017-02-26 20:00:00 | NQ | Futures | 6376.29 | 6376.88 | 6371.22 | 6373.9 | 1325.0 |
| 2017-02-26 20:30:00 | NQ | Futures | 6373.6 | 6374.5 | 6371.51 | 6373.9 | 848.0 |
| 2017-02-26 21:00:00 | NQ | Futures | 6374.2 | 6377.78 | 6373.3 | 6377.18 | 696.0 |
| 2017-02-26 21:30:00 | NQ | Futures | 6376.88 | 6381.96 | 6375.99 | 6381.36 | 500.0 |
| 2017-02-26 22:00:00 | NQ | Futures | 6381.36 | 6383.15 | 6380.17 | 6381.06 | 535.0 |
| 2017-02-26 22:30:00 | NQ | Futures | 6381.06 | 6382.55 | 6379.57 | 6381.96 | 251.0 |
| 2017-02-26 23:00:00 | NQ | Futures | 6381.96 | 6387.03 | 6381.96 | 6383.45 | 1300.0 |
| 2017-02-26 23:30:00 | NQ | Futures | 6383.45 | 6386.73 | 6382.85 | 6383.75 | 453.0 |
| 2017-02-26 18:00:00 | YM | Futures | 22538.2 | 22587.0 | 22506.7 | 22569.6 | 2151.0 |
| 2017-02-26 18:30:00 | YM | Futures | 22570.7 | 22570.7 | 22562.0 | 22567.5 | 458.0 |
| 2017-02-26 19:00:00 | YM | Futures | 22567.5 | 22575.1 | 22545.8 | 22558.8 | 1178.0 |
| 2017-02-26 19:30:00 | YM | Futures | 22558.8 | 22567.5 | 22541.4 | 22543.6 | 883.0 |
| 2017-02-26 20:00:00 | YM | Futures | 22543.6 | 22547.9 | 22532.8 | 22547.9 | 1004.0 |
| 2017-02-26 20:30:00 | YM | Futures | 22547.9 | 22552.3 | 22538.2 | 22551.2 | 687.0 |
| 2017-02-26 21:00:00 | YM | Futures | 22552.3 | 22563.1 | 22550.1 | 22558.8 | 643.0 |
| 2017-02-26 21:30:00 | YM | Futures | 22558.8 | 22570.7 | 22554.5 | 22569.6 | 383.0 |
| 2017-02-26 22:00:00 | YM | Futures | 22568.6 | 22577.2 | 22564.2 | 22567.5 | 657.0 |
| 2017-02-26 22:30:00 | YM | Futures | 22567.5 | 22574.0 | 22564.2 | 22571.8 | 289.0 |
| 2017-02-26 23:00:00 | YM | Futures | 22571.8 | 22590.3 | 22571.8 | 22577.2 | 1408.0 |
| 2017-02-26 23:30:00 | YM | Futures | 22576.1 | 22588.1 | 22575.1 | 22580.5 | 343.0 |
| 2017-02-26 18:00:00 | CL | Futures | 50.76 | 50.8 | 50.75 | 50.76 | 1285.0 |
| 2017-02-26 18:30:00 | CL | Futures | 50.76 | 50.77 | 50.73 | 50.73 | 479.0 |
| 2017-02-26 19:00:00 | CL | Futures | 50.73 | 50.75 | 50.71 | 50.72 | 496.0 |
| 2017-02-26 19:30:00 | CL | Futures | 50.72 | 50.76 | 50.72 | 50.73 | 596.0 |
| 2017-02-26 20:00:00 | CL | Futures | 50.73 | 50.74 | 50.68 | 50.72 | 741.0 |
| 2017-02-26 20:30:00 | CL | Futures | 50.72 | 50.74 | 50.7 | 50.72 | 566.0 |
| 2017-02-26 21:00:00 | CL | Futures | 50.73 | 50.79 | 50.72 | 50.78 | 850.0 |
| 2017-02-26 21:30:00 | CL | Futures | 50.77 | 50.86 | 50.77 | 50.84 | 1431.0 |
| 2017-02-26 22:00:00 | CL | Futures | 50.84 | 50.92 | 50.82 | 50.9 | 1973.0 |
| 2017-02-26 22:30:00 | CL | Futures | 50.9 | 50.93 | 50.87 | 50.88 | 859.0 |
| 2017-02-26 23:00:00 | CL | Futures | 50.87 | 50.94 | 50.87 | 50.92 | 1240.0 |
| 2017-02-26 23:30:00 | CL | Futures | 50.92 | 50.98 | 50.91 | 50.96 | 2045.0 |
| 2017-02-26 18:00:00 | GC | Futures | 1695.4 | 1695.4 | 1690.9 | 1693.1 | 2668.0 |
| 2017-02-26 18:30:00 | GC | Futures | 1693.1 | 1693.6 | 1692.4 | 1692.5 | 1071.0 |
> showing 50 of 568 rows — these rows as CSV