PREVIEW / futures_1hour / 2015-11-22
file: by_date/futures_1hour/2015/2015-11-22.parquet size: 14 KB rows: 275
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-11-22 18:00:00 | ES | Futures | 2236.67 | 2239.62 | 2235.6 | 2238.01 | 7089.0 |
| 2015-11-22 19:00:00 | ES | Futures | 2238.01 | 2239.08 | 2237.74 | 2238.81 | 2274.0 |
| 2015-11-22 20:00:00 | ES | Futures | 2238.81 | 2238.81 | 2235.07 | 2235.07 | 4088.0 |
| 2015-11-22 21:00:00 | ES | Futures | 2235.07 | 2236.41 | 2234.0 | 2235.87 | 4034.0 |
| 2015-11-22 22:00:00 | ES | Futures | 2236.14 | 2236.67 | 2235.34 | 2236.67 | 1541.0 |
| 2015-11-22 23:00:00 | ES | Futures | 2236.67 | 2237.21 | 2236.14 | 2236.94 | 977.0 |
| 2015-11-22 18:00:00 | NQ | Futures | 5561.58 | 5571.07 | 5559.8 | 5568.1 | 922.0 |
| 2015-11-22 19:00:00 | NQ | Futures | 5567.21 | 5569.88 | 5566.03 | 5568.99 | 327.0 |
| 2015-11-22 20:00:00 | NQ | Futures | 5569.29 | 5569.29 | 5561.58 | 5561.88 | 840.0 |
| 2015-11-22 21:00:00 | NQ | Futures | 5561.88 | 5565.73 | 5559.5 | 5565.43 | 884.0 |
| 2015-11-22 22:00:00 | NQ | Futures | 5565.43 | 5566.62 | 5563.36 | 5566.32 | 516.0 |
| 2015-11-22 23:00:00 | NQ | Futures | 5566.32 | 5567.21 | 5565.14 | 5566.92 | 259.0 |
| 2015-11-22 18:00:00 | YM | Futures | 18855.8 | 18893.9 | 18855.8 | 18882.3 | 1137.0 |
| 2015-11-22 19:00:00 | YM | Futures | 18883.3 | 18899.2 | 18879.1 | 18890.7 | 840.0 |
| 2015-11-22 20:00:00 | YM | Futures | 18890.7 | 18891.8 | 18857.9 | 18858.9 | 840.0 |
| 2015-11-22 21:00:00 | YM | Futures | 18857.9 | 18868.5 | 18851.5 | 18864.2 | 736.0 |
| 2015-11-22 22:00:00 | YM | Futures | 18867.4 | 18873.8 | 18861.1 | 18870.6 | 360.0 |
| 2015-11-22 23:00:00 | YM | Futures | 18871.7 | 18875.9 | 18865.3 | 18874.8 | 242.0 |
| 2015-11-22 18:00:00 | CL | Futures | 56.89 | 57.11 | 56.81 | 56.92 | 1895.0 |
| 2015-11-22 19:00:00 | CL | Futures | 56.94 | 57.13 | 56.92 | 57.04 | 1351.0 |
| 2015-11-22 20:00:00 | CL | Futures | 57.04 | 57.06 | 56.25 | 56.26 | 5303.0 |
| 2015-11-22 21:00:00 | CL | Futures | 56.25 | 56.39 | 56.17 | 56.35 | 3366.0 |
| 2015-11-22 22:00:00 | CL | Futures | 56.35 | 56.41 | 56.32 | 56.4 | 1295.0 |
| 2015-11-22 23:00:00 | CL | Futures | 56.4 | 56.43 | 56.29 | 56.41 | 1065.0 |
| 2015-11-22 18:00:00 | GC | Futures | 1469.6 | 1469.8 | 1464.3 | 1467.7 | 2081.0 |
| 2015-11-22 19:00:00 | GC | Futures | 1467.9 | 1469.0 | 1465.8 | 1467.2 | 2465.0 |
| 2015-11-22 20:00:00 | GC | Futures | 1467.2 | 1467.5 | 1461.0 | 1461.6 | 6749.0 |
| 2015-11-22 21:00:00 | GC | Futures | 1461.4 | 1462.0 | 1456.1 | 1459.5 | 7137.0 |
| 2015-11-22 22:00:00 | GC | Futures | 1459.5 | 1462.0 | 1459.3 | 1462.0 | 1895.0 |
| 2015-11-22 23:00:00 | GC | Futures | 1461.9 | 1462.0 | 1459.5 | 1461.0 | 1593.0 |
| 2015-11-22 18:00:00 | ZN | Futures | 122.28401 | 122.28401 | 122.193485 | 122.208573 | 7676.0 |
| 2015-11-22 19:00:00 | ZN | Futures | 122.22366 | 122.238748 | 122.193485 | 122.208573 | 3978.0 |
| 2015-11-22 20:00:00 | ZN | Futures | 122.22366 | 122.238748 | 122.208573 | 122.22366 | 2627.0 |
| 2015-11-22 21:00:00 | ZN | Futures | 122.238748 | 122.238748 | 122.208573 | 122.22366 | 2125.0 |
| 2015-11-22 22:00:00 | ZN | Futures | 122.208573 | 122.238748 | 122.208573 | 122.22366 | 848.0 |
| 2015-11-22 23:00:00 | ZN | Futures | 122.22366 | 122.22366 | 122.133135 | 122.148223 | 4911.0 |
> showing 36 of 275 rows — these rows as CSV