PREVIEW / futures_30min / 2012-08-12
file: by_date/futures_30min/2012/2012-08-12.parquet size: 19 KB rows: 490
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-08-12 18:00:00 | ES | Futures | 1424.5 | 1425.77 | 1424.24 | 1425.0 | 2927.0 |
| 2012-08-12 18:30:00 | ES | Futures | 1425.0 | 1426.28 | 1425.0 | 1426.02 | 854.0 |
| 2012-08-12 19:00:00 | ES | Futures | 1425.77 | 1425.77 | 1424.75 | 1425.0 | 746.0 |
| 2012-08-12 19:30:00 | ES | Futures | 1424.75 | 1425.51 | 1423.99 | 1424.24 | 1273.0 |
| 2012-08-12 20:00:00 | ES | Futures | 1424.24 | 1424.24 | 1422.72 | 1423.22 | 3272.0 |
| 2012-08-12 20:30:00 | ES | Futures | 1423.22 | 1423.22 | 1422.21 | 1422.97 | 3028.0 |
| 2012-08-12 21:00:00 | ES | Futures | 1422.97 | 1422.97 | 1421.7 | 1421.95 | 3189.0 |
| 2012-08-12 21:30:00 | ES | Futures | 1421.95 | 1423.48 | 1421.7 | 1422.97 | 3026.0 |
| 2012-08-12 22:00:00 | ES | Futures | 1423.22 | 1423.73 | 1422.72 | 1423.48 | 1265.0 |
| 2012-08-12 22:30:00 | ES | Futures | 1423.48 | 1423.99 | 1422.97 | 1422.97 | 1406.0 |
| 2012-08-12 23:00:00 | ES | Futures | 1423.22 | 1423.22 | 1422.21 | 1422.72 | 1326.0 |
| 2012-08-12 23:30:00 | ES | Futures | 1422.46 | 1422.97 | 1421.95 | 1421.95 | 774.0 |
| 2012-08-12 18:00:00 | NQ | Futures | 3153.95 | 3155.69 | 3153.08 | 3154.24 | 581.0 |
| 2012-08-12 18:30:00 | NQ | Futures | 3154.53 | 3156.27 | 3153.95 | 3155.69 | 64.0 |
| 2012-08-12 19:00:00 | NQ | Futures | 3155.98 | 3156.27 | 3153.66 | 3153.66 | 71.0 |
| 2012-08-12 19:30:00 | NQ | Futures | 3153.66 | 3154.82 | 3151.34 | 3151.34 | 100.0 |
| 2012-08-12 20:00:00 | NQ | Futures | 3151.63 | 3151.92 | 3148.15 | 3148.44 | 341.0 |
| 2012-08-12 20:30:00 | NQ | Futures | 3148.73 | 3148.73 | 3146.99 | 3147.57 | 351.0 |
| 2012-08-12 21:00:00 | NQ | Futures | 3147.86 | 3148.15 | 3144.96 | 3146.41 | 544.0 |
| 2012-08-12 21:30:00 | NQ | Futures | 3146.7 | 3150.18 | 3145.83 | 3149.02 | 294.0 |
| 2012-08-12 22:00:00 | NQ | Futures | 3149.02 | 3151.05 | 3148.15 | 3150.47 | 179.0 |
| 2012-08-12 22:30:00 | NQ | Futures | 3150.47 | 3151.05 | 3149.02 | 3149.02 | 213.0 |
| 2012-08-12 23:00:00 | NQ | Futures | 3149.02 | 3149.31 | 3147.28 | 3148.15 | 202.0 |
| 2012-08-12 23:30:00 | NQ | Futures | 3148.15 | 3149.02 | 3146.99 | 3147.28 | 90.0 |
| 2012-08-12 18:00:00 | YM | Futures | 13086.3 | 13093.3 | 13082.4 | 13087.3 | 516.0 |
| 2012-08-12 18:30:00 | YM | Futures | 13088.3 | 13094.3 | 13087.3 | 13093.3 | 75.0 |
| 2012-08-12 19:00:00 | YM | Futures | 13092.3 | 13092.3 | 13083.4 | 13085.3 | 99.0 |
| 2012-08-12 19:30:00 | YM | Futures | 13085.3 | 13091.3 | 13077.4 | 13078.4 | 145.0 |
| 2012-08-12 20:00:00 | YM | Futures | 13078.4 | 13078.4 | 13067.4 | 13071.4 | 287.0 |
| 2012-08-12 20:30:00 | YM | Futures | 13071.4 | 13071.4 | 13063.5 | 13068.4 | 374.0 |
| 2012-08-12 21:00:00 | YM | Futures | 13068.4 | 13069.4 | 13060.5 | 13062.5 | 277.0 |
| 2012-08-12 21:30:00 | YM | Futures | 13062.5 | 13075.4 | 13060.5 | 13070.4 | 430.0 |
| 2012-08-12 22:00:00 | YM | Futures | 13070.4 | 13077.4 | 13068.4 | 13073.4 | 213.0 |
| 2012-08-12 22:30:00 | YM | Futures | 13073.4 | 13077.4 | 13068.4 | 13068.4 | 340.0 |
| 2012-08-12 23:00:00 | YM | Futures | 13068.4 | 13071.4 | 13065.5 | 13069.4 | 273.0 |
| 2012-08-12 23:30:00 | YM | Futures | 13068.4 | 13070.4 | 13063.5 | 13064.5 | 149.0 |
| 2012-08-12 18:00:00 | CL | Futures | 153.12 | 153.23 | 152.89 | 153.1 | 471.0 |
| 2012-08-12 18:30:00 | CL | Futures | 153.12 | 153.35 | 153.1 | 153.16 | 256.0 |
| 2012-08-12 19:00:00 | CL | Futures | 153.18 | 153.21 | 153.1 | 153.1 | 87.0 |
| 2012-08-12 19:30:00 | CL | Futures | 153.1 | 153.15 | 153.08 | 153.1 | 182.0 |
| 2012-08-12 20:00:00 | CL | Futures | 153.1 | 153.3 | 153.08 | 153.2 | 430.0 |
| 2012-08-12 20:30:00 | CL | Futures | 153.18 | 153.25 | 153.07 | 153.21 | 413.0 |
| 2012-08-12 21:00:00 | CL | Futures | 153.21 | 153.21 | 152.98 | 153.12 | 299.0 |
| 2012-08-12 21:30:00 | CL | Futures | 153.1 | 153.35 | 152.95 | 153.26 | 509.0 |
| 2012-08-12 22:00:00 | CL | Futures | 153.23 | 153.62 | 153.18 | 153.51 | 668.0 |
| 2012-08-12 22:30:00 | CL | Futures | 153.51 | 153.92 | 153.51 | 153.67 | 982.0 |
| 2012-08-12 23:00:00 | CL | Futures | 153.69 | 153.76 | 153.53 | 153.66 | 295.0 |
| 2012-08-12 23:30:00 | CL | Futures | 153.66 | 153.82 | 153.49 | 153.49 | 270.0 |
| 2012-08-12 18:00:00 | GC | Futures | 2241.3 | 2241.3 | 2237.3 | 2239.9 | 429.0 |
| 2012-08-12 18:30:00 | GC | Futures | 2239.9 | 2240.6 | 2239.5 | 2239.9 | 136.0 |
> showing 50 of 490 rows — these rows as CSV