PREVIEW / futures_30min / 2012-07-08
file: by_date/futures_30min/2012/2012-07-08.parquet size: 19 KB rows: 507
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-07-08 18:00:00 | ES | Futures | 1372.37 | 1372.88 | 1371.1 | 1371.1 | 11329.0 |
| 2012-07-08 18:30:00 | ES | Futures | 1371.1 | 1372.11 | 1371.1 | 1371.6 | 1342.0 |
| 2012-07-08 19:00:00 | ES | Futures | 1371.6 | 1371.6 | 1371.1 | 1371.35 | 831.0 |
| 2012-07-08 19:30:00 | ES | Futures | 1371.1 | 1371.86 | 1370.84 | 1371.1 | 2859.0 |
| 2012-07-08 20:00:00 | ES | Futures | 1371.1 | 1371.86 | 1370.84 | 1371.35 | 2692.0 |
| 2012-07-08 20:30:00 | ES | Futures | 1371.6 | 1372.11 | 1370.59 | 1371.6 | 3105.0 |
| 2012-07-08 21:00:00 | ES | Futures | 1371.35 | 1371.6 | 1370.59 | 1370.84 | 2060.0 |
| 2012-07-08 21:30:00 | ES | Futures | 1370.84 | 1373.13 | 1370.33 | 1372.62 | 3825.0 |
| 2012-07-08 22:00:00 | ES | Futures | 1372.88 | 1373.38 | 1371.86 | 1371.86 | 2395.0 |
| 2012-07-08 22:30:00 | ES | Futures | 1372.11 | 1372.88 | 1371.86 | 1372.62 | 1390.0 |
| 2012-07-08 23:00:00 | ES | Futures | 1372.37 | 1372.37 | 1370.08 | 1370.59 | 2956.0 |
| 2012-07-08 23:30:00 | ES | Futures | 1370.59 | 1371.35 | 1369.82 | 1371.35 | 1929.0 |
| 2012-07-08 18:00:00 | NQ | Futures | 3017.7 | 3021.47 | 3017.7 | 3018.28 | 490.0 |
| 2012-07-08 18:30:00 | NQ | Futures | 3018.28 | 3020.31 | 3018.28 | 3018.86 | 88.0 |
| 2012-07-08 19:00:00 | NQ | Futures | 3019.15 | 3020.02 | 3017.7 | 3017.7 | 77.0 |
| 2012-07-08 19:30:00 | NQ | Futures | 3017.99 | 3018.86 | 3017.7 | 3017.99 | 137.0 |
| 2012-07-08 20:00:00 | NQ | Futures | 3017.99 | 3020.02 | 3017.99 | 3018.86 | 114.0 |
| 2012-07-08 20:30:00 | NQ | Futures | 3019.15 | 3020.89 | 3017.12 | 3018.86 | 234.0 |
| 2012-07-08 21:00:00 | NQ | Futures | 3018.86 | 3019.73 | 3017.99 | 3018.86 | 178.0 |
| 2012-07-08 21:30:00 | NQ | Futures | 3018.86 | 3022.63 | 3016.54 | 3022.63 | 408.0 |
| 2012-07-08 22:00:00 | NQ | Futures | 3022.05 | 3023.21 | 3020.31 | 3020.89 | 380.0 |
| 2012-07-08 22:30:00 | NQ | Futures | 3020.89 | 3022.63 | 3020.02 | 3021.47 | 193.0 |
| 2012-07-08 23:00:00 | NQ | Futures | 3021.47 | 3021.47 | 3016.25 | 3017.12 | 276.0 |
| 2012-07-08 23:30:00 | NQ | Futures | 3017.12 | 3018.86 | 3015.67 | 3018.86 | 244.0 |
| 2012-07-08 18:00:00 | YM | Futures | 12636.9 | 12638.9 | 12622.0 | 12624.9 | 271.0 |
| 2012-07-08 18:30:00 | YM | Futures | 12623.9 | 12632.9 | 12623.9 | 12627.9 | 82.0 |
| 2012-07-08 19:00:00 | YM | Futures | 12627.9 | 12628.9 | 12623.9 | 12626.9 | 52.0 |
| 2012-07-08 19:30:00 | YM | Futures | 12624.9 | 12632.9 | 12622.9 | 12626.9 | 131.0 |
| 2012-07-08 20:00:00 | YM | Futures | 12625.9 | 12633.9 | 12625.9 | 12627.9 | 153.0 |
| 2012-07-08 20:30:00 | YM | Futures | 12628.9 | 12632.9 | 12622.9 | 12628.9 | 239.0 |
| 2012-07-08 21:00:00 | YM | Futures | 12627.9 | 12631.9 | 12626.9 | 12626.9 | 175.0 |
| 2012-07-08 21:30:00 | YM | Futures | 12627.9 | 12645.8 | 12622.0 | 12641.8 | 396.0 |
| 2012-07-08 22:00:00 | YM | Futures | 12642.8 | 12648.8 | 12636.9 | 12636.9 | 303.0 |
| 2012-07-08 22:30:00 | YM | Futures | 12639.9 | 12646.8 | 12637.9 | 12643.8 | 206.0 |
| 2012-07-08 23:00:00 | YM | Futures | 12642.8 | 12642.8 | 12622.9 | 12625.9 | 353.0 |
| 2012-07-08 23:30:00 | YM | Futures | 12627.9 | 12633.9 | 12622.9 | 12633.9 | 222.0 |
| 2012-07-08 18:00:00 | CL | Futures | 138.97 | 139.2 | 138.64 | 139.02 | 1102.0 |
| 2012-07-08 18:30:00 | CL | Futures | 139.04 | 139.33 | 138.99 | 139.3 | 455.0 |
| 2012-07-08 19:00:00 | CL | Futures | 139.3 | 139.4 | 139.14 | 139.2 | 485.0 |
| 2012-07-08 19:30:00 | CL | Futures | 139.2 | 139.37 | 139.18 | 139.25 | 316.0 |
| 2012-07-08 20:00:00 | CL | Futures | 139.25 | 139.51 | 139.2 | 139.45 | 745.0 |
| 2012-07-08 20:30:00 | CL | Futures | 139.45 | 139.51 | 139.33 | 139.48 | 422.0 |
| 2012-07-08 21:00:00 | CL | Futures | 139.5 | 139.71 | 139.42 | 139.65 | 351.0 |
| 2012-07-08 21:30:00 | CL | Futures | 139.6 | 140.16 | 139.55 | 139.98 | 838.0 |
| 2012-07-08 22:00:00 | CL | Futures | 140.01 | 140.34 | 140.01 | 140.11 | 853.0 |
| 2012-07-08 22:30:00 | CL | Futures | 140.11 | 140.27 | 140.08 | 140.21 | 410.0 |
| 2012-07-08 23:00:00 | CL | Futures | 140.22 | 140.26 | 139.89 | 139.99 | 537.0 |
| 2012-07-08 23:30:00 | CL | Futures | 140.01 | 140.18 | 139.94 | 140.16 | 319.0 |
| 2012-07-08 18:00:00 | GC | Futures | 2189.6 | 2190.5 | 2184.9 | 2186.7 | 656.0 |
| 2012-07-08 18:30:00 | GC | Futures | 2187.2 | 2187.7 | 2185.6 | 2186.6 | 104.0 |
> showing 50 of 507 rows — these rows as CSV