PREVIEW / futures_1hour / 2012-03-18
file: by_date/futures_1hour/2012/2012-03-18.parquet size: 13 KB rows: 261
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-03-18 18:00:00 | ES | Futures | 1413.93 | 1415.7 | 1413.68 | 1414.69 | 7102.0 |
| 2012-03-18 19:00:00 | ES | Futures | 1414.44 | 1416.21 | 1414.18 | 1415.95 | 3811.0 |
| 2012-03-18 20:00:00 | ES | Futures | 1416.21 | 1419.5 | 1415.95 | 1418.48 | 12336.0 |
| 2012-03-18 21:00:00 | ES | Futures | 1418.48 | 1418.99 | 1417.22 | 1417.98 | 5419.0 |
| 2012-03-18 22:00:00 | ES | Futures | 1417.98 | 1418.48 | 1416.97 | 1416.97 | 3931.0 |
| 2012-03-18 23:00:00 | ES | Futures | 1417.22 | 1419.24 | 1416.97 | 1418.74 | 3164.0 |
| 2012-03-18 18:00:00 | NQ | Futures | 3133.2 | 3139.85 | 3132.04 | 3136.38 | 1357.0 |
| 2012-03-18 19:00:00 | NQ | Futures | 3135.8 | 3139.56 | 3134.93 | 3139.27 | 670.0 |
| 2012-03-18 20:00:00 | NQ | Futures | 3139.56 | 3145.35 | 3139.56 | 3144.48 | 1602.0 |
| 2012-03-18 21:00:00 | NQ | Futures | 3144.19 | 3145.35 | 3141.87 | 3143.9 | 641.0 |
| 2012-03-18 22:00:00 | NQ | Futures | 3143.9 | 3145.06 | 3142.45 | 3143.03 | 649.0 |
| 2012-03-18 23:00:00 | NQ | Futures | 3142.74 | 3147.66 | 3142.45 | 3146.5 | 469.0 |
| 2012-03-18 18:00:00 | YM | Futures | 13114.3 | 13121.3 | 13104.3 | 13114.3 | 525.0 |
| 2012-03-18 19:00:00 | YM | Futures | 13113.3 | 13125.3 | 13109.3 | 13123.3 | 306.0 |
| 2012-03-18 20:00:00 | YM | Futures | 13124.3 | 13159.1 | 13124.3 | 13152.2 | 1249.0 |
| 2012-03-18 21:00:00 | YM | Futures | 13152.2 | 13153.1 | 13141.2 | 13147.2 | 468.0 |
| 2012-03-18 22:00:00 | YM | Futures | 13147.2 | 13150.2 | 13134.2 | 13137.2 | 475.0 |
| 2012-03-18 23:00:00 | YM | Futures | 13138.2 | 13155.1 | 13137.2 | 13149.2 | 569.0 |
| 2012-03-18 18:00:00 | CL | Futures | 179.99 | 180.24 | 179.79 | 180.16 | 687.0 |
| 2012-03-18 19:00:00 | CL | Futures | 180.11 | 180.29 | 180.09 | 180.11 | 369.0 |
| 2012-03-18 20:00:00 | CL | Futures | 180.13 | 180.28 | 180.11 | 180.14 | 391.0 |
| 2012-03-18 21:00:00 | CL | Futures | 180.13 | 180.34 | 179.94 | 180.03 | 846.0 |
| 2012-03-18 22:00:00 | CL | Futures | 180.03 | 180.16 | 179.96 | 180.04 | 260.0 |
| 2012-03-18 23:00:00 | CL | Futures | 180.03 | 180.09 | 179.96 | 180.04 | 239.0 |
| 2012-03-18 18:00:00 | GC | Futures | 2302.6 | 2304.0 | 2299.7 | 2302.0 | 831.0 |
| 2012-03-18 19:00:00 | GC | Futures | 2302.5 | 2305.2 | 2301.9 | 2304.7 | 664.0 |
| 2012-03-18 20:00:00 | GC | Futures | 2304.7 | 2306.5 | 2302.2 | 2304.0 | 1246.0 |
| 2012-03-18 21:00:00 | GC | Futures | 2304.1 | 2311.1 | 2302.2 | 2308.6 | 3854.0 |
| 2012-03-18 22:00:00 | GC | Futures | 2308.2 | 2309.7 | 2305.7 | 2307.7 | 1616.0 |
| 2012-03-18 23:00:00 | GC | Futures | 2308.0 | 2310.2 | 2307.2 | 2308.9 | 845.0 |
| 2012-03-18 18:00:00 | ZN | Futures | 112.495998 | 112.53701 | 112.468657 | 112.482327 | 3195.0 |
| 2012-03-18 19:00:00 | ZN | Futures | 112.468657 | 112.509669 | 112.468657 | 112.468657 | 3343.0 |
| 2012-03-18 20:00:00 | ZN | Futures | 112.468657 | 112.482327 | 112.386633 | 112.413974 | 9057.0 |
| 2012-03-18 21:00:00 | ZN | Futures | 112.427645 | 112.482327 | 112.400303 | 112.482327 | 3586.0 |
| 2012-03-18 22:00:00 | ZN | Futures | 112.482327 | 112.482327 | 112.454986 | 112.468657 | 1897.0 |
| 2012-03-18 23:00:00 | ZN | Futures | 112.468657 | 112.468657 | 112.413974 | 112.427645 | 3673.0 |
> showing 36 of 261 rows — these rows as CSV