PREVIEW / futures_1hour / 2011-01-09
file: by_date/futures_1hour/2011/2011-01-09.parquet size: 13 KB rows: 251
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 |
|---|---|---|---|---|---|---|---|
| 2011-01-09 18:00:00 | ES | Futures | 1253.22 | 1253.71 | 1251.49 | 1251.73 | 7500.0 |
| 2011-01-09 19:00:00 | ES | Futures | 1251.98 | 1253.47 | 1250.5 | 1253.22 | 5167.0 |
| 2011-01-09 20:00:00 | ES | Futures | 1253.47 | 1253.96 | 1251.49 | 1252.97 | 4027.0 |
| 2011-01-09 21:00:00 | ES | Futures | 1253.22 | 1254.7 | 1252.97 | 1253.71 | 5585.0 |
| 2011-01-09 22:00:00 | ES | Futures | 1253.47 | 1254.95 | 1252.97 | 1254.21 | 2926.0 |
| 2011-01-09 23:00:00 | ES | Futures | 1253.96 | 1254.7 | 1253.71 | 1254.7 | 1206.0 |
| 2011-01-09 18:00:00 | NQ | Futures | 2608.84 | 2609.12 | 2604.53 | 2605.68 | 699.0 |
| 2011-01-09 19:00:00 | NQ | Futures | 2605.97 | 2608.84 | 2603.1 | 2608.84 | 576.0 |
| 2011-01-09 20:00:00 | NQ | Futures | 2609.12 | 2611.42 | 2606.25 | 2610.27 | 573.0 |
| 2011-01-09 21:00:00 | NQ | Futures | 2610.27 | 2612.86 | 2609.41 | 2609.7 | 406.0 |
| 2011-01-09 22:00:00 | NQ | Futures | 2609.12 | 2611.71 | 2608.55 | 2609.7 | 194.0 |
| 2011-01-09 23:00:00 | NQ | Futures | 2609.99 | 2611.13 | 2609.7 | 2610.85 | 44.0 |
| 2011-01-09 18:00:00 | YM | Futures | 11123.7 | 11126.6 | 11106.4 | 11114.1 | 410.0 |
| 2011-01-09 19:00:00 | YM | Futures | 11112.2 | 11125.6 | 11101.7 | 11125.6 | 342.0 |
| 2011-01-09 20:00:00 | YM | Futures | 11126.6 | 11132.3 | 11114.1 | 11124.6 | 407.0 |
| 2011-01-09 21:00:00 | YM | Futures | 11123.7 | 11137.1 | 11123.7 | 11129.4 | 297.0 |
| 2011-01-09 22:00:00 | YM | Futures | 11128.5 | 11137.1 | 11124.6 | 11131.3 | 266.0 |
| 2011-01-09 23:00:00 | YM | Futures | 11131.3 | 11136.1 | 11130.4 | 11135.2 | 44.0 |
| 2011-01-09 18:00:00 | CL | Futures | 165.08 | 166.9 | 164.71 | 165.99 | 7184.0 |
| 2011-01-09 19:00:00 | CL | Futures | 166.01 | 166.4 | 165.6 | 166.12 | 1690.0 |
| 2011-01-09 20:00:00 | CL | Futures | 166.12 | 166.44 | 165.84 | 165.94 | 1218.0 |
| 2011-01-09 21:00:00 | CL | Futures | 165.97 | 166.12 | 165.57 | 165.64 | 1357.0 |
| 2011-01-09 22:00:00 | CL | Futures | 165.66 | 165.81 | 165.46 | 165.64 | 640.0 |
| 2011-01-09 23:00:00 | CL | Futures | 165.66 | 165.79 | 165.18 | 165.21 | 1178.0 |
| 2011-01-09 18:00:00 | GC | Futures | 1913.3 | 1918.4 | 1910.3 | 1914.4 | 1970.0 |
| 2011-01-09 19:00:00 | GC | Futures | 1914.4 | 1916.4 | 1912.2 | 1913.6 | 1254.0 |
| 2011-01-09 20:00:00 | GC | Futures | 1913.2 | 1919.9 | 1913.2 | 1918.4 | 1310.0 |
| 2011-01-09 21:00:00 | GC | Futures | 1918.5 | 1922.1 | 1917.0 | 1919.5 | 2070.0 |
| 2011-01-09 22:00:00 | GC | Futures | 1919.5 | 1921.9 | 1918.2 | 1919.2 | 791.0 |
| 2011-01-09 23:00:00 | GC | Futures | 1919.1 | 1920.2 | 1917.8 | 1918.4 | 816.0 |
| 2011-01-09 18:00:00 | ZN | Futures | 101.561516 | 101.574657 | 101.469534 | 101.469534 | 3038.0 |
| 2011-01-09 19:00:00 | ZN | Futures | 101.482674 | 101.522095 | 101.456394 | 101.495815 | 2455.0 |
| 2011-01-09 20:00:00 | ZN | Futures | 101.508955 | 101.522095 | 101.430113 | 101.443253 | 2145.0 |
| 2011-01-09 21:00:00 | ZN | Futures | 101.443253 | 101.469534 | 101.430113 | 101.456394 | 1352.0 |
| 2011-01-09 22:00:00 | ZN | Futures | 101.443253 | 101.456394 | 101.430113 | 101.443253 | 861.0 |
| 2011-01-09 23:00:00 | ZN | Futures | 101.443253 | 101.469534 | 101.430113 | 101.443253 | 1136.0 |
> showing 36 of 251 rows — these rows as CSV