PREVIEW / futures_1hour / 2012-05-13
file: by_date/futures_1hour/2012/2012-05-13.parquet size: 14 KB rows: 267
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-05-13 18:00:00 | ES | Futures | 1362.07 | 1363.08 | 1358.02 | 1360.3 | 21302.0 |
| 2012-05-13 19:00:00 | ES | Futures | 1360.3 | 1362.07 | 1359.28 | 1362.07 | 4950.0 |
| 2012-05-13 20:00:00 | ES | Futures | 1362.07 | 1366.87 | 1361.81 | 1366.37 | 18099.0 |
| 2012-05-13 21:00:00 | ES | Futures | 1366.37 | 1367.13 | 1361.56 | 1361.81 | 8589.0 |
| 2012-05-13 22:00:00 | ES | Futures | 1361.81 | 1363.08 | 1360.55 | 1362.32 | 6533.0 |
| 2012-05-13 23:00:00 | ES | Futures | 1362.32 | 1364.09 | 1362.07 | 1363.84 | 2679.0 |
| 2012-05-13 18:00:00 | NQ | Futures | 3010.0 | 3014.05 | 3001.61 | 3007.11 | 2252.0 |
| 2012-05-13 19:00:00 | NQ | Futures | 3007.11 | 3010.87 | 3004.79 | 3010.58 | 558.0 |
| 2012-05-13 20:00:00 | NQ | Futures | 3010.58 | 3021.86 | 3010.29 | 3020.7 | 1339.0 |
| 2012-05-13 21:00:00 | NQ | Futures | 3020.99 | 3022.72 | 3011.16 | 3012.02 | 832.0 |
| 2012-05-13 22:00:00 | NQ | Futures | 3012.02 | 3014.92 | 3009.71 | 3013.47 | 813.0 |
| 2012-05-13 23:00:00 | NQ | Futures | 3013.47 | 3017.52 | 3013.18 | 3016.94 | 479.0 |
| 2012-05-13 18:00:00 | YM | Futures | 12704.8 | 12713.8 | 12673.9 | 12694.8 | 1201.0 |
| 2012-05-13 19:00:00 | YM | Futures | 12694.8 | 12708.8 | 12685.9 | 12708.8 | 522.0 |
| 2012-05-13 20:00:00 | YM | Futures | 12710.8 | 12747.7 | 12710.8 | 12743.7 | 1005.0 |
| 2012-05-13 21:00:00 | YM | Futures | 12745.7 | 12750.6 | 12705.8 | 12708.8 | 686.0 |
| 2012-05-13 22:00:00 | YM | Futures | 12708.8 | 12718.8 | 12697.8 | 12710.8 | 650.0 |
| 2012-05-13 23:00:00 | YM | Futures | 12710.8 | 12723.7 | 12709.8 | 12721.7 | 650.0 |
| 2012-05-13 18:00:00 | CL | Futures | 159.24 | 159.31 | 158.55 | 158.6 | 1856.0 |
| 2012-05-13 19:00:00 | CL | Futures | 158.58 | 158.93 | 158.51 | 158.76 | 885.0 |
| 2012-05-13 20:00:00 | CL | Futures | 158.78 | 159.23 | 158.7 | 159.18 | 1119.0 |
| 2012-05-13 21:00:00 | CL | Futures | 159.18 | 159.18 | 158.21 | 158.35 | 2255.0 |
| 2012-05-13 22:00:00 | CL | Futures | 158.36 | 158.65 | 158.33 | 158.6 | 1080.0 |
| 2012-05-13 23:00:00 | CL | Futures | 158.58 | 158.95 | 158.55 | 158.88 | 679.0 |
| 2012-05-13 18:00:00 | GC | Futures | 2197.3 | 2197.3 | 2187.2 | 2189.8 | 2307.0 |
| 2012-05-13 19:00:00 | GC | Futures | 2189.9 | 2192.2 | 2189.1 | 2190.6 | 810.0 |
| 2012-05-13 20:00:00 | GC | Futures | 2190.6 | 2196.5 | 2189.0 | 2195.9 | 2072.0 |
| 2012-05-13 21:00:00 | GC | Futures | 2196.2 | 2197.7 | 2190.2 | 2191.5 | 2717.0 |
| 2012-05-13 22:00:00 | GC | Futures | 2191.6 | 2193.8 | 2190.9 | 2192.9 | 1196.0 |
| 2012-05-13 23:00:00 | GC | Futures | 2192.7 | 2193.1 | 2191.2 | 2191.6 | 720.0 |
| 2012-05-13 18:00:00 | ZN | Futures | 116.474165 | 116.58353 | 116.474165 | 116.542518 | 10698.0 |
| 2012-05-13 19:00:00 | ZN | Futures | 116.556189 | 116.56986 | 116.515177 | 116.515177 | 2094.0 |
| 2012-05-13 20:00:00 | ZN | Futures | 116.515177 | 116.542518 | 116.446824 | 116.460494 | 8017.0 |
| 2012-05-13 21:00:00 | ZN | Futures | 116.460494 | 116.56986 | 116.446824 | 116.56986 | 6607.0 |
| 2012-05-13 22:00:00 | ZN | Futures | 116.556189 | 116.58353 | 116.528848 | 116.542518 | 5706.0 |
| 2012-05-13 23:00:00 | ZN | Futures | 116.542518 | 116.556189 | 116.528848 | 116.542518 | 1427.0 |
> showing 36 of 267 rows — these rows as CSV