PREVIEW / futures_30min / 2012-05-13
file: by_date/futures_30min/2012/2012-05-13.parquet size: 20 KB rows: 501
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.55 | 18770.0 |
| 2012-05-13 18:30:00 | ES | Futures | 1360.3 | 1361.31 | 1360.04 | 1360.3 | 2532.0 |
| 2012-05-13 19:00:00 | ES | Futures | 1360.3 | 1361.06 | 1359.28 | 1361.06 | 2598.0 |
| 2012-05-13 19:30:00 | ES | Futures | 1361.06 | 1362.07 | 1360.04 | 1362.07 | 2352.0 |
| 2012-05-13 20:00:00 | ES | Futures | 1362.07 | 1365.36 | 1361.81 | 1364.85 | 9296.0 |
| 2012-05-13 20:30:00 | ES | Futures | 1365.1 | 1366.87 | 1363.84 | 1366.37 | 8803.0 |
| 2012-05-13 21:00:00 | ES | Futures | 1366.37 | 1367.13 | 1364.6 | 1364.85 | 3686.0 |
| 2012-05-13 21:30:00 | ES | Futures | 1364.85 | 1365.1 | 1361.56 | 1361.81 | 4903.0 |
| 2012-05-13 22:00:00 | ES | Futures | 1361.81 | 1363.08 | 1360.55 | 1361.56 | 4230.0 |
| 2012-05-13 22:30:00 | ES | Futures | 1361.56 | 1362.83 | 1361.31 | 1362.32 | 2303.0 |
| 2012-05-13 23:00:00 | ES | Futures | 1362.32 | 1363.59 | 1362.07 | 1363.59 | 1592.0 |
| 2012-05-13 23:30:00 | ES | Futures | 1363.59 | 1364.09 | 1363.08 | 1363.84 | 1087.0 |
| 2012-05-13 18:00:00 | NQ | Futures | 3010.0 | 3014.05 | 3001.61 | 3006.53 | 1854.0 |
| 2012-05-13 18:30:00 | NQ | Futures | 3006.53 | 3007.97 | 3005.95 | 3007.11 | 398.0 |
| 2012-05-13 19:00:00 | NQ | Futures | 3007.11 | 3008.55 | 3004.79 | 3007.97 | 237.0 |
| 2012-05-13 19:30:00 | NQ | Futures | 3007.97 | 3010.87 | 3006.24 | 3010.58 | 321.0 |
| 2012-05-13 20:00:00 | NQ | Futures | 3010.58 | 3018.68 | 3010.29 | 3018.1 | 920.0 |
| 2012-05-13 20:30:00 | NQ | Futures | 3018.1 | 3021.86 | 3014.92 | 3020.7 | 419.0 |
| 2012-05-13 21:00:00 | NQ | Futures | 3020.99 | 3022.72 | 3015.78 | 3016.94 | 323.0 |
| 2012-05-13 21:30:00 | NQ | Futures | 3016.65 | 3018.1 | 3011.16 | 3012.02 | 509.0 |
| 2012-05-13 22:00:00 | NQ | Futures | 3012.02 | 3014.92 | 3009.71 | 3012.6 | 449.0 |
| 2012-05-13 22:30:00 | NQ | Futures | 3012.31 | 3014.92 | 3011.16 | 3013.47 | 364.0 |
| 2012-05-13 23:00:00 | NQ | Futures | 3013.47 | 3015.78 | 3013.18 | 3014.63 | 319.0 |
| 2012-05-13 23:30:00 | NQ | Futures | 3014.63 | 3017.52 | 3014.63 | 3016.94 | 160.0 |
| 2012-05-13 18:00:00 | YM | Futures | 12704.8 | 12713.8 | 12673.9 | 12691.9 | 932.0 |
| 2012-05-13 18:30:00 | YM | Futures | 12694.8 | 12699.8 | 12688.9 | 12694.8 | 269.0 |
| 2012-05-13 19:00:00 | YM | Futures | 12694.8 | 12701.8 | 12685.9 | 12700.8 | 260.0 |
| 2012-05-13 19:30:00 | YM | Futures | 12698.8 | 12708.8 | 12694.8 | 12708.8 | 262.0 |
| 2012-05-13 20:00:00 | YM | Futures | 12710.8 | 12736.7 | 12710.8 | 12735.7 | 564.0 |
| 2012-05-13 20:30:00 | YM | Futures | 12735.7 | 12747.7 | 12727.7 | 12743.7 | 441.0 |
| 2012-05-13 21:00:00 | YM | Futures | 12745.7 | 12750.6 | 12729.7 | 12731.7 | 271.0 |
| 2012-05-13 21:30:00 | YM | Futures | 12733.7 | 12735.7 | 12705.8 | 12708.8 | 415.0 |
| 2012-05-13 22:00:00 | YM | Futures | 12708.8 | 12718.8 | 12697.8 | 12705.8 | 361.0 |
| 2012-05-13 22:30:00 | YM | Futures | 12706.8 | 12715.8 | 12704.8 | 12710.8 | 289.0 |
| 2012-05-13 23:00:00 | YM | Futures | 12710.8 | 12721.7 | 12709.8 | 12717.8 | 350.0 |
| 2012-05-13 23:30:00 | YM | Futures | 12718.8 | 12723.7 | 12714.8 | 12721.7 | 300.0 |
| 2012-05-13 18:00:00 | CL | Futures | 159.24 | 159.31 | 158.55 | 158.71 | 1479.0 |
| 2012-05-13 18:30:00 | CL | Futures | 158.7 | 158.9 | 158.55 | 158.6 | 377.0 |
| 2012-05-13 19:00:00 | CL | Futures | 158.58 | 158.93 | 158.51 | 158.93 | 492.0 |
| 2012-05-13 19:30:00 | CL | Futures | 158.93 | 158.93 | 158.53 | 158.76 | 393.0 |
| 2012-05-13 20:00:00 | CL | Futures | 158.78 | 159.0 | 158.7 | 158.98 | 570.0 |
| 2012-05-13 20:30:00 | CL | Futures | 158.96 | 159.23 | 158.86 | 159.18 | 549.0 |
| 2012-05-13 21:00:00 | CL | Futures | 159.18 | 159.18 | 158.66 | 158.75 | 973.0 |
| 2012-05-13 21:30:00 | CL | Futures | 158.76 | 158.83 | 158.21 | 158.35 | 1282.0 |
| 2012-05-13 22:00:00 | CL | Futures | 158.36 | 158.63 | 158.33 | 158.5 | 671.0 |
| 2012-05-13 22:30:00 | CL | Futures | 158.51 | 158.65 | 158.38 | 158.6 | 409.0 |
| 2012-05-13 23:00:00 | CL | Futures | 158.58 | 158.73 | 158.55 | 158.61 | 156.0 |
| 2012-05-13 23:30:00 | CL | Futures | 158.61 | 158.95 | 158.6 | 158.88 | 523.0 |
| 2012-05-13 18:00:00 | GC | Futures | 2197.3 | 2197.3 | 2187.2 | 2187.9 | 1726.0 |
| 2012-05-13 18:30:00 | GC | Futures | 2188.1 | 2191.2 | 2187.4 | 2189.8 | 581.0 |
> showing 50 of 501 rows — these rows as CSV