PREVIEW / futures_1hour / 2015-05-17
file: by_date/futures_1hour/2015/2015-05-17.parquet size: 14 KB rows: 264
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-05-17 18:00:00 | ES | Futures | 2238.93 | 2240.51 | 2236.81 | 2237.87 | 4034.0 |
| 2015-05-17 19:00:00 | ES | Futures | 2237.87 | 2238.4 | 2237.08 | 2237.34 | 1003.0 |
| 2015-05-17 20:00:00 | ES | Futures | 2237.34 | 2238.4 | 2236.81 | 2237.34 | 4867.0 |
| 2015-05-17 21:00:00 | ES | Futures | 2237.08 | 2237.08 | 2234.96 | 2235.23 | 3882.0 |
| 2015-05-17 22:00:00 | ES | Futures | 2235.49 | 2236.81 | 2235.23 | 2236.81 | 1556.0 |
| 2015-05-17 23:00:00 | ES | Futures | 2236.81 | 2238.13 | 2236.55 | 2236.81 | 2337.0 |
| 2015-05-17 18:00:00 | NQ | Futures | 5282.85 | 5285.79 | 5276.97 | 5279.03 | 470.0 |
| 2015-05-17 19:00:00 | NQ | Futures | 5278.73 | 5279.91 | 5276.97 | 5277.26 | 114.0 |
| 2015-05-17 20:00:00 | NQ | Futures | 5277.56 | 5279.62 | 5276.09 | 5276.97 | 307.0 |
| 2015-05-17 21:00:00 | NQ | Futures | 5276.97 | 5276.97 | 5272.27 | 5272.27 | 471.0 |
| 2015-05-17 22:00:00 | NQ | Futures | 5272.27 | 5275.5 | 5272.27 | 5275.21 | 253.0 |
| 2015-05-17 23:00:00 | NQ | Futures | 5275.5 | 5277.56 | 5274.91 | 5276.38 | 254.0 |
| 2015-05-17 18:00:00 | YM | Futures | 19123.5 | 19125.6 | 19103.6 | 19113.0 | 647.0 |
| 2015-05-17 19:00:00 | YM | Futures | 19111.9 | 19115.1 | 19106.7 | 19107.8 | 128.0 |
| 2015-05-17 20:00:00 | YM | Futures | 19106.7 | 19115.1 | 19104.6 | 19108.8 | 427.0 |
| 2015-05-17 21:00:00 | YM | Futures | 19104.6 | 19108.8 | 19091.0 | 19093.1 | 769.0 |
| 2015-05-17 22:00:00 | YM | Futures | 19094.1 | 19105.7 | 19093.1 | 19105.7 | 175.0 |
| 2015-05-17 23:00:00 | YM | Futures | 19106.7 | 19115.1 | 19105.7 | 19108.8 | 288.0 |
| 2015-05-17 18:00:00 | CL | Futures | 90.9 | 91.14 | 90.82 | 90.91 | 671.0 |
| 2015-05-17 19:00:00 | CL | Futures | 90.91 | 90.93 | 90.84 | 90.88 | 188.0 |
| 2015-05-17 20:00:00 | CL | Futures | 90.87 | 91.08 | 90.85 | 91.06 | 1010.0 |
| 2015-05-17 21:00:00 | CL | Futures | 91.05 | 91.05 | 90.96 | 91.0 | 533.0 |
| 2015-05-17 22:00:00 | CL | Futures | 91.0 | 91.05 | 90.79 | 90.81 | 1400.0 |
| 2015-05-17 23:00:00 | CL | Futures | 90.81 | 90.99 | 90.81 | 90.97 | 387.0 |
| 2015-05-17 18:00:00 | GC | Futures | 1670.0 | 1673.2 | 1669.8 | 1672.8 | 1308.0 |
| 2015-05-17 19:00:00 | GC | Futures | 1672.6 | 1673.0 | 1670.4 | 1670.7 | 848.0 |
| 2015-05-17 20:00:00 | GC | Futures | 1671.0 | 1671.3 | 1668.0 | 1669.2 | 1752.0 |
| 2015-05-17 21:00:00 | GC | Futures | 1669.4 | 1670.0 | 1667.9 | 1668.1 | 1729.0 |
| 2015-05-17 22:00:00 | GC | Futures | 1668.3 | 1672.0 | 1668.3 | 1671.0 | 2053.0 |
| 2015-05-17 23:00:00 | GC | Futures | 1671.0 | 1671.8 | 1670.4 | 1671.5 | 997.0 |
| 2015-05-17 18:00:00 | ZN | Futures | 122.305102 | 122.42457 | 122.290169 | 122.349903 | 8002.0 |
| 2015-05-17 19:00:00 | ZN | Futures | 122.349903 | 122.349903 | 122.305102 | 122.305102 | 2576.0 |
| 2015-05-17 20:00:00 | ZN | Futures | 122.305102 | 122.320036 | 122.245368 | 122.260302 | 6427.0 |
| 2015-05-17 21:00:00 | ZN | Futures | 122.260302 | 122.275235 | 122.230435 | 122.230435 | 7087.0 |
| 2015-05-17 22:00:00 | ZN | Futures | 122.230435 | 122.320036 | 122.230435 | 122.320036 | 6212.0 |
| 2015-05-17 23:00:00 | ZN | Futures | 122.320036 | 122.320036 | 122.290169 | 122.320036 | 4845.0 |
> showing 36 of 264 rows — these rows as CSV