PREVIEW / futures_1hour / 2014-06-29
file: by_date/futures_1hour/2014/2014-06-29.parquet size: 13 KB rows: 258
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-06-29 18:00:00 | ES | Futures | 2034.61 | 2036.7 | 2033.83 | 2035.4 | 3630.0 |
| 2014-06-29 19:00:00 | ES | Futures | 2035.66 | 2036.18 | 2035.13 | 2036.18 | 1082.0 |
| 2014-06-29 20:00:00 | ES | Futures | 2036.44 | 2036.44 | 2034.09 | 2034.35 | 4464.0 |
| 2014-06-29 21:00:00 | ES | Futures | 2034.61 | 2034.87 | 2033.57 | 2034.09 | 5927.0 |
| 2014-06-29 22:00:00 | ES | Futures | 2034.09 | 2035.66 | 2034.09 | 2034.87 | 1895.0 |
| 2014-06-29 23:00:00 | ES | Futures | 2035.13 | 2035.92 | 2034.61 | 2035.92 | 2083.0 |
| 2014-06-29 18:00:00 | NQ | Futures | 4475.42 | 4480.67 | 4474.83 | 4478.34 | 658.0 |
| 2014-06-29 19:00:00 | NQ | Futures | 4478.05 | 4479.21 | 4477.75 | 4478.92 | 280.0 |
| 2014-06-29 20:00:00 | NQ | Futures | 4479.21 | 4479.51 | 4475.42 | 4477.17 | 453.0 |
| 2014-06-29 21:00:00 | NQ | Futures | 4476.59 | 4477.46 | 4474.83 | 4476.29 | 483.0 |
| 2014-06-29 22:00:00 | NQ | Futures | 4476.0 | 4479.21 | 4476.0 | 4477.75 | 297.0 |
| 2014-06-29 23:00:00 | NQ | Futures | 4477.75 | 4479.51 | 4477.17 | 4479.21 | 243.0 |
| 2014-06-29 18:00:00 | YM | Futures | 17331.1 | 17348.7 | 17326.9 | 17344.5 | 396.0 |
| 2014-06-29 19:00:00 | YM | Futures | 17341.4 | 17345.6 | 17339.4 | 17345.6 | 88.0 |
| 2014-06-29 20:00:00 | YM | Futures | 17346.6 | 17347.6 | 17332.1 | 17336.3 | 340.0 |
| 2014-06-29 21:00:00 | YM | Futures | 17336.3 | 17338.3 | 17328.0 | 17333.1 | 541.0 |
| 2014-06-29 22:00:00 | YM | Futures | 17332.1 | 17342.5 | 17332.1 | 17339.4 | 210.0 |
| 2014-06-29 23:00:00 | YM | Futures | 17339.4 | 17345.6 | 17338.3 | 17344.5 | 264.0 |
| 2014-06-29 18:00:00 | CL | Futures | 171.91 | 172.02 | 171.44 | 171.57 | 1210.0 |
| 2014-06-29 19:00:00 | CL | Futures | 171.57 | 171.6 | 171.46 | 171.6 | 402.0 |
| 2014-06-29 20:00:00 | CL | Futures | 171.6 | 171.6 | 171.47 | 171.52 | 497.0 |
| 2014-06-29 21:00:00 | CL | Futures | 171.5 | 171.63 | 171.47 | 171.57 | 405.0 |
| 2014-06-29 22:00:00 | CL | Futures | 171.57 | 171.62 | 171.49 | 171.54 | 423.0 |
| 2014-06-29 23:00:00 | CL | Futures | 171.54 | 171.59 | 171.46 | 171.59 | 284.0 |
| 2014-06-29 18:00:00 | GC | Futures | 1803.6 | 1804.7 | 1802.0 | 1802.9 | 807.0 |
| 2014-06-29 19:00:00 | GC | Futures | 1802.9 | 1803.7 | 1801.8 | 1802.0 | 658.0 |
| 2014-06-29 20:00:00 | GC | Futures | 1802.1 | 1804.3 | 1801.4 | 1804.0 | 1002.0 |
| 2014-06-29 21:00:00 | GC | Futures | 1803.9 | 1804.6 | 1800.7 | 1802.1 | 2708.0 |
| 2014-06-29 22:00:00 | GC | Futures | 1802.2 | 1804.0 | 1802.1 | 1802.9 | 1089.0 |
| 2014-06-29 23:00:00 | GC | Futures | 1802.9 | 1803.9 | 1802.1 | 1803.6 | 1208.0 |
| 2014-06-29 18:00:00 | ZN | Futures | 117.967039 | 118.011244 | 117.967039 | 117.981774 | 2017.0 |
| 2014-06-29 19:00:00 | ZN | Futures | 117.996509 | 117.996509 | 117.981774 | 117.996509 | 1018.0 |
| 2014-06-29 20:00:00 | ZN | Futures | 117.996509 | 118.025979 | 117.981774 | 118.011244 | 2199.0 |
| 2014-06-29 21:00:00 | ZN | Futures | 117.996509 | 118.011244 | 117.981774 | 118.011244 | 1272.0 |
| 2014-06-29 22:00:00 | ZN | Futures | 118.011244 | 118.025979 | 117.996509 | 118.025979 | 1743.0 |
| 2014-06-29 23:00:00 | ZN | Futures | 118.025979 | 118.025979 | 117.981774 | 117.981774 | 1631.0 |
> showing 36 of 258 rows — these rows as CSV