PREVIEW / futures_1hour / 2012-07-22
file: by_date/futures_1hour/2012/2012-07-22.parquet size: 15 KB rows: 293
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 |
|---|---|---|---|---|---|---|---|
| 2012-07-22 18:00:00 | ES | Futures | 1378.72 | 1380.0 | 1377.2 | 1378.47 | 11687.0 |
| 2012-07-22 19:00:00 | ES | Futures | 1378.47 | 1378.47 | 1375.42 | 1376.18 | 5354.0 |
| 2012-07-22 20:00:00 | ES | Futures | 1375.93 | 1377.45 | 1374.66 | 1376.44 | 10756.0 |
| 2012-07-22 21:00:00 | ES | Futures | 1376.44 | 1377.2 | 1375.16 | 1376.44 | 8626.0 |
| 2012-07-22 22:00:00 | ES | Futures | 1376.44 | 1376.44 | 1374.15 | 1375.16 | 9442.0 |
| 2012-07-22 23:00:00 | ES | Futures | 1375.16 | 1375.42 | 1373.64 | 1373.89 | 5294.0 |
| 2012-07-22 18:00:00 | NQ | Futures | 3025.24 | 3029.88 | 3022.63 | 3026.11 | 1139.0 |
| 2012-07-22 19:00:00 | NQ | Futures | 3026.11 | 3026.4 | 3021.18 | 3022.05 | 576.0 |
| 2012-07-22 20:00:00 | NQ | Futures | 3022.34 | 3024.37 | 3019.44 | 3021.47 | 1435.0 |
| 2012-07-22 21:00:00 | NQ | Futures | 3021.76 | 3022.92 | 3019.15 | 3021.18 | 900.0 |
| 2012-07-22 22:00:00 | NQ | Futures | 3021.18 | 3021.76 | 3014.8 | 3017.99 | 2272.0 |
| 2012-07-22 23:00:00 | NQ | Futures | 3017.99 | 3019.15 | 3015.67 | 3016.25 | 784.0 |
| 2012-07-22 18:00:00 | YM | Futures | 12684.6 | 12684.6 | 12658.7 | 12664.7 | 1041.0 |
| 2012-07-22 19:00:00 | YM | Futures | 12664.7 | 12664.7 | 12646.8 | 12649.8 | 681.0 |
| 2012-07-22 20:00:00 | YM | Futures | 12651.8 | 12660.7 | 12640.8 | 12651.8 | 599.0 |
| 2012-07-22 21:00:00 | YM | Futures | 12652.8 | 12656.8 | 12642.8 | 12652.8 | 592.0 |
| 2012-07-22 22:00:00 | YM | Futures | 12649.8 | 12650.8 | 12630.9 | 12640.8 | 861.0 |
| 2012-07-22 23:00:00 | YM | Futures | 12641.8 | 12643.8 | 12629.9 | 12632.9 | 429.0 |
| 2012-07-22 18:00:00 | CL | Futures | 150.42 | 150.47 | 149.72 | 149.91 | 1265.0 |
| 2012-07-22 19:00:00 | CL | Futures | 149.95 | 150.0 | 149.77 | 149.83 | 700.0 |
| 2012-07-22 20:00:00 | CL | Futures | 149.83 | 150.01 | 149.75 | 149.86 | 974.0 |
| 2012-07-22 21:00:00 | CL | Futures | 149.86 | 149.9 | 149.55 | 149.68 | 1132.0 |
| 2012-07-22 22:00:00 | CL | Futures | 149.67 | 149.68 | 148.55 | 148.7 | 3297.0 |
| 2012-07-22 23:00:00 | CL | Futures | 148.68 | 148.75 | 148.22 | 148.29 | 1445.0 |
| 2012-07-22 18:00:00 | GC | Futures | 2188.5 | 2189.6 | 2183.0 | 2188.5 | 825.0 |
| 2012-07-22 19:00:00 | GC | Futures | 2188.7 | 2189.2 | 2186.3 | 2187.6 | 338.0 |
| 2012-07-22 20:00:00 | GC | Futures | 2187.6 | 2189.0 | 2184.3 | 2185.9 | 1459.0 |
| 2012-07-22 21:00:00 | GC | Futures | 2186.1 | 2187.4 | 2184.4 | 2185.4 | 1464.0 |
| 2012-07-22 22:00:00 | GC | Futures | 2185.4 | 2186.1 | 2183.1 | 2184.3 | 2243.0 |
| 2012-07-22 23:00:00 | GC | Futures | 2184.4 | 2187.3 | 2183.8 | 2184.7 | 1884.0 |
| 2012-07-22 18:00:00 | ZN | Futures | 118.804827 | 118.832334 | 118.777319 | 118.804827 | 4688.0 |
| 2012-07-22 19:00:00 | ZN | Futures | 118.81858 | 118.887349 | 118.804827 | 118.859842 | 3762.0 |
| 2012-07-22 20:00:00 | ZN | Futures | 118.859842 | 118.92861 | 118.859842 | 118.914856 | 7414.0 |
| 2012-07-22 21:00:00 | ZN | Futures | 118.901103 | 118.942364 | 118.901103 | 118.914856 | 6004.0 |
| 2012-07-22 22:00:00 | ZN | Futures | 118.914856 | 118.956118 | 118.901103 | 118.914856 | 4954.0 |
| 2012-07-22 23:00:00 | ZN | Futures | 118.914856 | 118.92861 | 118.901103 | 118.92861 | 3368.0 |
> showing 36 of 293 rows — these rows as CSV