PREVIEW / futures_1hour / 2012-01-22
file: by_date/futures_1hour/2012/2012-01-22.parquet size: 14 KB rows: 276
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-01-22 18:00:00 | ES | Futures | 1317.9 | 1318.4 | 1315.88 | 1316.39 | 13139.0 |
| 2012-01-22 19:00:00 | ES | Futures | 1316.39 | 1317.39 | 1315.38 | 1317.14 | 6225.0 |
| 2012-01-22 20:00:00 | ES | Futures | 1317.14 | 1317.9 | 1315.38 | 1315.88 | 5234.0 |
| 2012-01-22 21:00:00 | ES | Futures | 1315.88 | 1316.39 | 1315.63 | 1316.39 | 1919.0 |
| 2012-01-22 22:00:00 | ES | Futures | 1316.13 | 1317.65 | 1316.13 | 1317.65 | 2700.0 |
| 2012-01-22 23:00:00 | ES | Futures | 1317.65 | 1317.9 | 1317.14 | 1317.39 | 1582.0 |
| 2012-01-22 18:00:00 | NQ | Futures | 2807.12 | 2809.43 | 2803.08 | 2804.23 | 599.0 |
| 2012-01-22 19:00:00 | NQ | Futures | 2804.81 | 2805.39 | 2801.92 | 2805.39 | 323.0 |
| 2012-01-22 20:00:00 | NQ | Futures | 2805.1 | 2806.25 | 2802.79 | 2803.08 | 280.0 |
| 2012-01-22 21:00:00 | NQ | Futures | 2803.65 | 2804.81 | 2803.37 | 2804.81 | 327.0 |
| 2012-01-22 22:00:00 | NQ | Futures | 2804.52 | 2807.41 | 2804.23 | 2807.41 | 221.0 |
| 2012-01-22 23:00:00 | NQ | Futures | 2807.12 | 2807.7 | 2806.83 | 2806.83 | 163.0 |
| 2012-01-22 18:00:00 | YM | Futures | 12521.0 | 12527.0 | 12508.1 | 12514.1 | 1245.0 |
| 2012-01-22 19:00:00 | YM | Futures | 12514.1 | 12522.0 | 12507.1 | 12521.0 | 481.0 |
| 2012-01-22 20:00:00 | YM | Futures | 12520.0 | 12528.0 | 12507.1 | 12511.1 | 541.0 |
| 2012-01-22 21:00:00 | YM | Futures | 12511.1 | 12516.1 | 12509.1 | 12515.1 | 236.0 |
| 2012-01-22 22:00:00 | YM | Futures | 12515.1 | 12526.0 | 12514.1 | 12524.0 | 211.0 |
| 2012-01-22 23:00:00 | YM | Futures | 12523.0 | 12525.0 | 12521.0 | 12521.0 | 67.0 |
| 2012-01-22 18:00:00 | CL | Futures | 165.81 | 165.9 | 164.4 | 164.57 | 1702.0 |
| 2012-01-22 19:00:00 | CL | Futures | 164.58 | 164.72 | 164.23 | 164.68 | 878.0 |
| 2012-01-22 20:00:00 | CL | Futures | 164.7 | 165.22 | 164.6 | 165.16 | 773.0 |
| 2012-01-22 21:00:00 | CL | Futures | 165.16 | 165.48 | 164.99 | 165.38 | 869.0 |
| 2012-01-22 22:00:00 | CL | Futures | 165.31 | 165.54 | 165.21 | 165.38 | 673.0 |
| 2012-01-22 23:00:00 | CL | Futures | 165.36 | 165.54 | 165.05 | 165.27 | 752.0 |
| 2012-01-22 18:00:00 | GC | Futures | 2315.4 | 2318.3 | 2312.3 | 2314.3 | 1126.0 |
| 2012-01-22 19:00:00 | GC | Futures | 2314.4 | 2315.8 | 2312.8 | 2314.8 | 623.0 |
| 2012-01-22 20:00:00 | GC | Futures | 2314.7 | 2320.4 | 2314.4 | 2320.4 | 1360.0 |
| 2012-01-22 21:00:00 | GC | Futures | 2320.0 | 2321.8 | 2316.6 | 2319.3 | 1454.0 |
| 2012-01-22 22:00:00 | GC | Futures | 2319.4 | 2320.8 | 2318.5 | 2320.8 | 464.0 |
| 2012-01-22 23:00:00 | GC | Futures | 2320.8 | 2325.0 | 2320.3 | 2324.3 | 1827.0 |
| 2012-01-22 18:00:00 | ZN | Futures | 113.783198 | 113.865037 | 113.769558 | 113.837757 | 8170.0 |
| 2012-01-22 19:00:00 | ZN | Futures | 113.851397 | 113.892316 | 113.851397 | 113.878677 | 5253.0 |
| 2012-01-22 20:00:00 | ZN | Futures | 113.878677 | 113.905956 | 113.865037 | 113.892316 | 4724.0 |
| 2012-01-22 21:00:00 | ZN | Futures | 113.878677 | 113.905956 | 113.865037 | 113.892316 | 3698.0 |
| 2012-01-22 22:00:00 | ZN | Futures | 113.892316 | 113.892316 | 113.810478 | 113.837757 | 4629.0 |
| 2012-01-22 23:00:00 | ZN | Futures | 113.824117 | 113.851397 | 113.824117 | 113.851397 | 1313.0 |
> showing 36 of 276 rows — these rows as CSV