PREVIEW / futures_1hour / 2011-06-12
file: by_date/futures_1hour/2011/2011-06-12.parquet size: 13 KB rows: 256
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-06-12 18:00:00 | ES | Futures | 1262.03 | 1263.27 | 1260.54 | 1261.78 | 3894.0 |
| 2011-06-12 19:00:00 | ES | Futures | 1261.78 | 1262.03 | 1260.29 | 1261.03 | 2413.0 |
| 2011-06-12 20:00:00 | ES | Futures | 1260.78 | 1264.51 | 1260.78 | 1264.01 | 3356.0 |
| 2011-06-12 21:00:00 | ES | Futures | 1264.01 | 1265.01 | 1262.77 | 1264.76 | 1961.0 |
| 2011-06-12 22:00:00 | ES | Futures | 1264.76 | 1265.26 | 1263.52 | 1263.77 | 1135.0 |
| 2011-06-12 23:00:00 | ES | Futures | 1263.52 | 1263.77 | 1261.78 | 1262.52 | 1056.0 |
| 2011-06-12 18:00:00 | NQ | Futures | 2547.91 | 2555.95 | 2547.91 | 2552.5 | 271.0 |
| 2011-06-12 19:00:00 | NQ | Futures | 2553.08 | 2553.37 | 2551.36 | 2551.93 | 92.0 |
| 2011-06-12 20:00:00 | NQ | Futures | 2551.93 | 2558.25 | 2551.36 | 2557.96 | 184.0 |
| 2011-06-12 21:00:00 | NQ | Futures | 2557.39 | 2558.83 | 2555.67 | 2558.83 | 43.0 |
| 2011-06-12 22:00:00 | NQ | Futures | 2558.83 | 2559.4 | 2555.95 | 2556.53 | 26.0 |
| 2011-06-12 23:00:00 | NQ | Futures | 2557.1 | 2557.1 | 2554.23 | 2555.95 | 223.0 |
| 2011-06-12 18:00:00 | YM | Futures | 11507.5 | 11512.3 | 11491.0 | 11497.8 | 643.0 |
| 2011-06-12 19:00:00 | YM | Futures | 11499.7 | 11500.7 | 11489.1 | 11492.0 | 91.0 |
| 2011-06-12 20:00:00 | YM | Futures | 11495.9 | 11520.1 | 11495.9 | 11519.1 | 437.0 |
| 2011-06-12 21:00:00 | YM | Futures | 11519.1 | 11524.0 | 11508.5 | 11522.0 | 243.0 |
| 2011-06-12 22:00:00 | YM | Futures | 11523.0 | 11528.8 | 11516.2 | 11519.1 | 242.0 |
| 2011-06-12 23:00:00 | YM | Futures | 11518.1 | 11518.1 | 11501.7 | 11510.4 | 216.0 |
| 2011-06-12 18:00:00 | CL | Futures | 170.1 | 170.5 | 169.98 | 170.25 | 941.0 |
| 2011-06-12 19:00:00 | CL | Futures | 170.27 | 170.43 | 170.12 | 170.34 | 391.0 |
| 2011-06-12 20:00:00 | CL | Futures | 170.34 | 171.03 | 170.32 | 171.0 | 1036.0 |
| 2011-06-12 21:00:00 | CL | Futures | 170.98 | 171.05 | 170.72 | 171.01 | 724.0 |
| 2011-06-12 22:00:00 | CL | Futures | 171.0 | 171.0 | 170.39 | 170.5 | 572.0 |
| 2011-06-12 23:00:00 | CL | Futures | 170.5 | 170.58 | 170.07 | 170.36 | 497.0 |
| 2011-06-12 18:00:00 | GC | Futures | 2134.9 | 2137.6 | 2131.3 | 2134.1 | 1206.0 |
| 2011-06-12 19:00:00 | GC | Futures | 2134.0 | 2136.8 | 2134.0 | 2135.8 | 666.0 |
| 2011-06-12 20:00:00 | GC | Futures | 2135.8 | 2137.9 | 2133.1 | 2137.0 | 1494.0 |
| 2011-06-12 21:00:00 | GC | Futures | 2137.0 | 2139.3 | 2135.4 | 2138.9 | 1107.0 |
| 2011-06-12 22:00:00 | GC | Futures | 2139.1 | 2139.4 | 2137.5 | 2138.4 | 673.0 |
| 2011-06-12 23:00:00 | GC | Futures | 2138.3 | 2139.0 | 2135.6 | 2135.9 | 832.0 |
| 2011-06-12 18:00:00 | ZN | Futures | 106.374141 | 106.401047 | 106.360688 | 106.387594 | 1329.0 |
| 2011-06-12 19:00:00 | ZN | Futures | 106.387594 | 106.401047 | 106.347235 | 106.374141 | 2446.0 |
| 2011-06-12 20:00:00 | ZN | Futures | 106.374141 | 106.374141 | 106.266516 | 106.279969 | 5752.0 |
| 2011-06-12 21:00:00 | ZN | Futures | 106.279969 | 106.320328 | 106.279969 | 106.293422 | 3421.0 |
| 2011-06-12 22:00:00 | ZN | Futures | 106.293422 | 106.306875 | 106.279969 | 106.293422 | 1849.0 |
| 2011-06-12 23:00:00 | ZN | Futures | 106.306875 | 106.320328 | 106.279969 | 106.306875 | 1904.0 |
> showing 36 of 256 rows — these rows as CSV