PREVIEW / futures_1hour / 2013-11-24
file: by_date/futures_1hour/2013/2013-11-24.parquet size: 14 KB rows: 263
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 |
|---|---|---|---|---|---|---|---|
| 2013-11-24 18:00:00 | ES | Futures | 1859.38 | 1866.6 | 1858.35 | 1864.02 | 25626.0 |
| 2013-11-24 19:00:00 | ES | Futures | 1864.28 | 1866.86 | 1863.51 | 1866.34 | 11238.0 |
| 2013-11-24 20:00:00 | ES | Futures | 1866.09 | 1866.6 | 1864.28 | 1864.54 | 8189.0 |
| 2013-11-24 21:00:00 | ES | Futures | 1864.54 | 1864.8 | 1863.76 | 1864.02 | 2954.0 |
| 2013-11-24 22:00:00 | ES | Futures | 1864.02 | 1864.28 | 1863.25 | 1863.51 | 2647.0 |
| 2013-11-24 23:00:00 | ES | Futures | 1863.25 | 1863.76 | 1862.73 | 1863.25 | 2625.0 |
| 2013-11-24 18:00:00 | NQ | Futures | 3976.02 | 3990.54 | 3973.41 | 3985.61 | 2992.0 |
| 2013-11-24 19:00:00 | NQ | Futures | 3986.19 | 3991.12 | 3984.44 | 3989.96 | 1259.0 |
| 2013-11-24 20:00:00 | NQ | Futures | 3989.96 | 3990.83 | 3985.02 | 3985.61 | 1022.0 |
| 2013-11-24 21:00:00 | NQ | Futures | 3985.61 | 3985.9 | 3983.86 | 3985.31 | 498.0 |
| 2013-11-24 22:00:00 | NQ | Futures | 3985.31 | 3986.19 | 3983.57 | 3984.73 | 430.0 |
| 2013-11-24 23:00:00 | NQ | Futures | 3984.73 | 3985.02 | 3983.28 | 3984.44 | 246.0 |
| 2013-11-24 18:00:00 | YM | Futures | 16378.8 | 16442.1 | 16368.5 | 16421.7 | 3516.0 |
| 2013-11-24 19:00:00 | YM | Futures | 16422.7 | 16441.1 | 16418.6 | 16437.0 | 1502.0 |
| 2013-11-24 20:00:00 | YM | Futures | 16437.0 | 16440.0 | 16419.6 | 16420.6 | 1382.0 |
| 2013-11-24 21:00:00 | YM | Futures | 16421.7 | 16423.7 | 16419.6 | 16419.6 | 421.0 |
| 2013-11-24 22:00:00 | YM | Futures | 16419.6 | 16421.7 | 16411.4 | 16413.5 | 436.0 |
| 2013-11-24 23:00:00 | YM | Futures | 16413.5 | 16417.6 | 16409.4 | 16415.5 | 347.0 |
| 2013-11-24 18:00:00 | CL | Futures | 148.78 | 148.84 | 147.98 | 148.69 | 5790.0 |
| 2013-11-24 19:00:00 | CL | Futures | 148.67 | 148.8 | 148.4 | 148.42 | 1154.0 |
| 2013-11-24 20:00:00 | CL | Futures | 148.45 | 148.65 | 148.42 | 148.47 | 1092.0 |
| 2013-11-24 21:00:00 | CL | Futures | 148.47 | 148.65 | 148.34 | 148.59 | 1091.0 |
| 2013-11-24 22:00:00 | CL | Futures | 148.61 | 148.69 | 148.51 | 148.58 | 591.0 |
| 2013-11-24 23:00:00 | CL | Futures | 148.56 | 148.69 | 148.42 | 148.43 | 574.0 |
| 2013-11-24 18:00:00 | GC | Futures | 1701.9 | 1704.0 | 1695.2 | 1699.8 | 4613.0 |
| 2013-11-24 19:00:00 | GC | Futures | 1699.8 | 1705.1 | 1696.5 | 1704.3 | 5124.0 |
| 2013-11-24 20:00:00 | GC | Futures | 1704.3 | 1705.0 | 1700.2 | 1701.0 | 2508.0 |
| 2013-11-24 21:00:00 | GC | Futures | 1701.0 | 1702.4 | 1700.6 | 1701.0 | 1254.0 |
| 2013-11-24 22:00:00 | GC | Futures | 1701.0 | 1702.8 | 1699.9 | 1700.0 | 1690.0 |
| 2013-11-24 23:00:00 | GC | Futures | 1700.0 | 1700.4 | 1695.0 | 1696.3 | 2683.0 |
| 2013-11-24 18:00:00 | ZN | Futures | 115.728933 | 115.728933 | 115.657522 | 115.686087 | 5358.0 |
| 2013-11-24 19:00:00 | ZN | Futures | 115.671804 | 115.686087 | 115.586111 | 115.628958 | 9965.0 |
| 2013-11-24 20:00:00 | ZN | Futures | 115.628958 | 115.628958 | 115.571829 | 115.600393 | 9474.0 |
| 2013-11-24 21:00:00 | ZN | Futures | 115.600393 | 115.628958 | 115.600393 | 115.614675 | 3599.0 |
| 2013-11-24 22:00:00 | ZN | Futures | 115.628958 | 115.64324 | 115.600393 | 115.628958 | 3229.0 |
| 2013-11-24 23:00:00 | ZN | Futures | 115.64324 | 115.64324 | 115.614675 | 115.628958 | 2263.0 |
> showing 36 of 263 rows — these rows as CSV