PREVIEW / futures_30min / 2016-07-03
file: by_date/futures_30min/2016/2016-07-03.parquet size: 20 KB rows: 475
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 |
|---|---|---|---|---|---|---|---|
| 2016-07-03 18:00:00 | ES | Futures | 2277.69 | 2277.69 | 2274.17 | 2274.17 | 3279.0 |
| 2016-07-03 18:30:00 | ES | Futures | 2274.44 | 2275.53 | 2273.9 | 2274.98 | 876.0 |
| 2016-07-03 19:00:00 | ES | Futures | 2274.98 | 2275.25 | 2273.63 | 2274.44 | 880.0 |
| 2016-07-03 19:30:00 | ES | Futures | 2274.44 | 2274.44 | 2271.46 | 2271.46 | 1471.0 |
| 2016-07-03 20:00:00 | ES | Futures | 2271.73 | 2273.36 | 2271.46 | 2273.36 | 2179.0 |
| 2016-07-03 20:30:00 | ES | Futures | 2273.36 | 2275.8 | 2273.36 | 2273.63 | 1859.0 |
| 2016-07-03 21:00:00 | ES | Futures | 2273.9 | 2276.34 | 2273.63 | 2276.07 | 3399.0 |
| 2016-07-03 21:30:00 | ES | Futures | 2276.07 | 2278.78 | 2275.53 | 2277.97 | 3828.0 |
| 2016-07-03 22:00:00 | ES | Futures | 2277.97 | 2278.78 | 2276.61 | 2276.88 | 2984.0 |
| 2016-07-03 22:30:00 | ES | Futures | 2277.15 | 2277.15 | 2276.61 | 2277.15 | 1111.0 |
| 2016-07-03 23:00:00 | ES | Futures | 2277.15 | 2277.15 | 2276.34 | 2276.61 | 1454.0 |
| 2016-07-03 23:30:00 | ES | Futures | 2276.88 | 2277.97 | 2275.8 | 2276.61 | 1583.0 |
| 2016-07-03 18:00:00 | NQ | Futures | 5291.91 | 5298.16 | 5286.54 | 5287.43 | 300.0 |
| 2016-07-03 18:30:00 | NQ | Futures | 5287.43 | 5290.71 | 5286.54 | 5288.63 | 139.0 |
| 2016-07-03 19:00:00 | NQ | Futures | 5287.73 | 5288.63 | 5286.54 | 5287.14 | 108.0 |
| 2016-07-03 19:30:00 | NQ | Futures | 5286.54 | 5287.14 | 5277.0 | 5277.6 | 289.0 |
| 2016-07-03 20:00:00 | NQ | Futures | 5277.9 | 5281.77 | 5277.0 | 5280.88 | 285.0 |
| 2016-07-03 20:30:00 | NQ | Futures | 5281.18 | 5287.43 | 5281.18 | 5282.96 | 201.0 |
| 2016-07-03 21:00:00 | NQ | Futures | 5282.96 | 5287.43 | 5280.58 | 5286.54 | 322.0 |
| 2016-07-03 21:30:00 | NQ | Futures | 5286.84 | 5295.78 | 5285.94 | 5294.29 | 491.0 |
| 2016-07-03 22:00:00 | NQ | Futures | 5294.59 | 5295.48 | 5290.42 | 5292.2 | 298.0 |
| 2016-07-03 22:30:00 | NQ | Futures | 5291.91 | 5292.8 | 5291.61 | 5292.8 | 76.0 |
| 2016-07-03 23:00:00 | NQ | Futures | 5292.8 | 5293.69 | 5291.01 | 5292.2 | 167.0 |
| 2016-07-03 23:30:00 | NQ | Futures | 5292.2 | 5295.18 | 5289.52 | 5291.01 | 188.0 |
| 2016-07-03 18:00:00 | YM | Futures | 19242.5 | 19261.9 | 19219.9 | 19222.1 | 382.0 |
| 2016-07-03 18:30:00 | YM | Futures | 19221.0 | 19229.6 | 19217.8 | 19226.4 | 163.0 |
| 2016-07-03 19:00:00 | YM | Futures | 19224.2 | 19228.6 | 19218.9 | 19224.2 | 154.0 |
| 2016-07-03 19:30:00 | YM | Futures | 19223.2 | 19224.2 | 19200.6 | 19200.6 | 238.0 |
| 2016-07-03 20:00:00 | YM | Futures | 19202.7 | 19214.6 | 19200.6 | 19213.5 | 427.0 |
| 2016-07-03 20:30:00 | YM | Futures | 19213.5 | 19233.9 | 19212.4 | 19216.7 | 465.0 |
| 2016-07-03 21:00:00 | YM | Futures | 19217.8 | 19233.9 | 19213.5 | 19230.7 | 538.0 |
| 2016-07-03 21:30:00 | YM | Futures | 19230.7 | 19257.6 | 19229.6 | 19250.1 | 749.0 |
| 2016-07-03 22:00:00 | YM | Futures | 19251.2 | 19258.7 | 19243.6 | 19246.9 | 562.0 |
| 2016-07-03 22:30:00 | YM | Futures | 19245.8 | 19252.2 | 19244.7 | 19251.2 | 225.0 |
| 2016-07-03 23:00:00 | YM | Futures | 19251.2 | 19254.4 | 19245.8 | 19250.1 | 237.0 |
| 2016-07-03 23:30:00 | YM | Futures | 19249.0 | 19255.5 | 19238.2 | 19240.4 | 322.0 |
| 2016-07-03 18:00:00 | CL | Futures | 51.41 | 51.54 | 51.23 | 51.27 | 2017.0 |
| 2016-07-03 18:30:00 | CL | Futures | 51.26 | 51.47 | 51.24 | 51.39 | 1259.0 |
| 2016-07-03 19:00:00 | CL | Futures | 51.39 | 51.39 | 51.3 | 51.38 | 697.0 |
| 2016-07-03 19:30:00 | CL | Futures | 51.38 | 51.38 | 51.29 | 51.3 | 336.0 |
| 2016-07-03 20:00:00 | CL | Futures | 51.3 | 51.37 | 51.26 | 51.28 | 963.0 |
| 2016-07-03 20:30:00 | CL | Futures | 51.29 | 51.35 | 51.22 | 51.24 | 1233.0 |
| 2016-07-03 21:00:00 | CL | Futures | 51.24 | 51.32 | 51.14 | 51.22 | 2677.0 |
| 2016-07-03 21:30:00 | CL | Futures | 51.23 | 51.39 | 51.21 | 51.35 | 1962.0 |
| 2016-07-03 22:00:00 | CL | Futures | 51.35 | 51.36 | 51.21 | 51.26 | 1544.0 |
| 2016-07-03 22:30:00 | CL | Futures | 51.27 | 51.3 | 51.19 | 51.25 | 895.0 |
| 2016-07-03 23:00:00 | CL | Futures | 51.24 | 51.34 | 51.23 | 51.29 | 1044.0 |
| 2016-07-03 23:30:00 | CL | Futures | 51.3 | 51.32 | 51.24 | 51.26 | 412.0 |
| 2016-07-03 18:00:00 | GC | Futures | 1830.4 | 1830.6 | 1821.5 | 1827.2 | 1784.0 |
| 2016-07-03 18:30:00 | GC | Futures | 1827.4 | 1830.0 | 1827.2 | 1829.7 | 446.0 |
> showing 50 of 475 rows — these rows as CSV