PREVIEW / futures_1hour / 2016-09-11
file: by_date/futures_1hour/2016/2016-09-11.parquet size: 14 KB rows: 273
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-09-11 18:00:00 | ES | Futures | 2301.56 | 2303.46 | 2294.78 | 2299.12 | 10404.0 |
| 2016-09-11 19:00:00 | ES | Futures | 2299.12 | 2301.83 | 2298.3 | 2299.39 | 5377.0 |
| 2016-09-11 20:00:00 | ES | Futures | 2299.66 | 2300.47 | 2298.3 | 2298.58 | 5628.0 |
| 2016-09-11 21:00:00 | ES | Futures | 2298.85 | 2299.39 | 2292.07 | 2292.07 | 7039.0 |
| 2016-09-11 22:00:00 | ES | Futures | 2292.07 | 2292.34 | 2285.56 | 2290.44 | 12840.0 |
| 2016-09-11 23:00:00 | ES | Futures | 2290.44 | 2290.44 | 2288.0 | 2288.54 | 3453.0 |
| 2016-09-11 18:00:00 | NQ | Futures | 5568.8 | 5569.99 | 5547.93 | 5560.45 | 1772.0 |
| 2016-09-11 19:00:00 | NQ | Futures | 5561.34 | 5565.81 | 5559.26 | 5560.15 | 474.0 |
| 2016-09-11 20:00:00 | NQ | Futures | 5559.26 | 5562.24 | 5556.58 | 5556.58 | 351.0 |
| 2016-09-11 21:00:00 | NQ | Futures | 5556.87 | 5559.26 | 5540.48 | 5540.48 | 844.0 |
| 2016-09-11 22:00:00 | NQ | Futures | 5540.18 | 5542.86 | 5524.68 | 5537.2 | 1264.0 |
| 2016-09-11 23:00:00 | NQ | Futures | 5537.8 | 5537.8 | 5532.43 | 5532.73 | 385.0 |
| 2016-09-11 18:00:00 | YM | Futures | 19395.4 | 19418.1 | 19348.9 | 19383.5 | 4483.0 |
| 2016-09-11 19:00:00 | YM | Futures | 19384.6 | 19406.2 | 19375.9 | 19390.0 | 1753.0 |
| 2016-09-11 20:00:00 | YM | Futures | 19390.0 | 19395.4 | 19374.8 | 19375.9 | 1331.0 |
| 2016-09-11 21:00:00 | YM | Futures | 19375.9 | 19383.5 | 19321.9 | 19323.0 | 1972.0 |
| 2016-09-11 22:00:00 | YM | Futures | 19320.8 | 19324.0 | 19265.7 | 19311.1 | 4544.0 |
| 2016-09-11 23:00:00 | YM | Futures | 19312.1 | 19312.1 | 19289.5 | 19293.8 | 819.0 |
| 2016-09-11 18:00:00 | CL | Futures | 46.29 | 46.38 | 45.79 | 46.05 | 8421.0 |
| 2016-09-11 19:00:00 | CL | Futures | 46.04 | 46.2 | 46.01 | 46.14 | 3314.0 |
| 2016-09-11 20:00:00 | CL | Futures | 46.13 | 46.16 | 46.02 | 46.03 | 2970.0 |
| 2016-09-11 21:00:00 | CL | Futures | 46.04 | 46.06 | 45.74 | 45.79 | 8830.0 |
| 2016-09-11 22:00:00 | CL | Futures | 45.79 | 45.83 | 45.74 | 45.79 | 3888.0 |
| 2016-09-11 23:00:00 | CL | Futures | 45.79 | 45.85 | 45.77 | 45.82 | 1822.0 |
| 2016-09-11 18:00:00 | GC | Futures | 1802.1 | 1802.9 | 1800.8 | 1801.6 | 2174.0 |
| 2016-09-11 19:00:00 | GC | Futures | 1801.6 | 1804.3 | 1801.5 | 1803.6 | 1634.0 |
| 2016-09-11 20:00:00 | GC | Futures | 1803.6 | 1803.8 | 1800.8 | 1801.7 | 3738.0 |
| 2016-09-11 21:00:00 | GC | Futures | 1801.7 | 1802.7 | 1797.3 | 1799.8 | 9270.0 |
| 2016-09-11 22:00:00 | GC | Futures | 1800.0 | 1802.1 | 1798.3 | 1801.1 | 5422.0 |
| 2016-09-11 23:00:00 | GC | Futures | 1801.1 | 1801.7 | 1800.8 | 1801.2 | 1239.0 |
| 2016-09-11 18:00:00 | ZN | Futures | 127.800109 | 127.861411 | 127.769457 | 127.846085 | 10799.0 |
| 2016-09-11 19:00:00 | ZN | Futures | 127.861411 | 127.922713 | 127.846085 | 127.907388 | 10231.0 |
| 2016-09-11 20:00:00 | ZN | Futures | 127.907388 | 127.984016 | 127.907388 | 127.953364 | 20502.0 |
| 2016-09-11 21:00:00 | ZN | Futures | 127.96869 | 127.96869 | 127.892062 | 127.938039 | 17374.0 |
| 2016-09-11 22:00:00 | ZN | Futures | 127.938039 | 127.953364 | 127.892062 | 127.892062 | 10945.0 |
| 2016-09-11 23:00:00 | ZN | Futures | 127.907388 | 127.922713 | 127.892062 | 127.922713 | 3766.0 |
> showing 36 of 273 rows — these rows as CSV