PREVIEW / futures_30min / 2012-12-30
file: by_date/futures_30min/2012/2012-12-30.parquet size: 18 KB rows: 473
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-12-30 18:00:00 | ES | Futures | 1424.85 | 1428.96 | 1419.98 | 1426.13 | 27396.0 |
| 2012-12-30 18:30:00 | ES | Futures | 1426.13 | 1427.93 | 1425.36 | 1426.39 | 5256.0 |
| 2012-12-30 19:00:00 | ES | Futures | 1426.39 | 1426.39 | 1424.85 | 1425.11 | 3554.0 |
| 2012-12-30 19:30:00 | ES | Futures | 1425.11 | 1426.13 | 1424.34 | 1424.85 | 2937.0 |
| 2012-12-30 20:00:00 | ES | Futures | 1424.59 | 1425.88 | 1424.59 | 1425.11 | 1785.0 |
| 2012-12-30 20:30:00 | ES | Futures | 1425.11 | 1426.39 | 1424.34 | 1426.13 | 4075.0 |
| 2012-12-30 21:00:00 | ES | Futures | 1425.88 | 1425.88 | 1424.34 | 1424.59 | 1390.0 |
| 2012-12-30 21:30:00 | ES | Futures | 1424.59 | 1425.88 | 1423.05 | 1425.62 | 2703.0 |
| 2012-12-30 22:00:00 | ES | Futures | 1425.62 | 1427.16 | 1425.11 | 1426.65 | 3116.0 |
| 2012-12-30 22:30:00 | ES | Futures | 1426.9 | 1427.16 | 1425.88 | 1425.88 | 1243.0 |
| 2012-12-30 23:00:00 | ES | Futures | 1425.62 | 1426.9 | 1424.59 | 1424.59 | 1754.0 |
| 2012-12-30 23:30:00 | ES | Futures | 1424.59 | 1424.85 | 1423.82 | 1424.08 | 1097.0 |
| 2012-12-30 18:00:00 | NQ | Futures | 3015.77 | 3020.13 | 3003.83 | 3016.06 | 1499.0 |
| 2012-12-30 18:30:00 | NQ | Futures | 3016.06 | 3018.97 | 3010.53 | 3016.06 | 729.0 |
| 2012-12-30 19:00:00 | NQ | Futures | 3016.06 | 3016.64 | 3013.15 | 3013.73 | 274.0 |
| 2012-12-30 19:30:00 | NQ | Futures | 3014.02 | 3015.77 | 3011.69 | 3012.27 | 322.0 |
| 2012-12-30 20:00:00 | NQ | Futures | 3011.98 | 3014.02 | 3011.69 | 3012.56 | 111.0 |
| 2012-12-30 20:30:00 | NQ | Futures | 3012.56 | 3013.73 | 3010.53 | 3013.44 | 366.0 |
| 2012-12-30 21:00:00 | NQ | Futures | 3012.86 | 3012.86 | 3010.82 | 3011.98 | 58.0 |
| 2012-12-30 21:30:00 | NQ | Futures | 3011.11 | 3014.31 | 3009.36 | 3013.73 | 199.0 |
| 2012-12-30 22:00:00 | NQ | Futures | 3013.73 | 3016.35 | 3013.44 | 3014.89 | 178.0 |
| 2012-12-30 22:30:00 | NQ | Futures | 3014.31 | 3015.48 | 3013.44 | 3013.44 | 101.0 |
| 2012-12-30 23:00:00 | NQ | Futures | 3013.44 | 3016.35 | 3012.86 | 3012.86 | 182.0 |
| 2012-12-30 23:30:00 | NQ | Futures | 3012.27 | 3013.15 | 3010.53 | 3011.11 | 120.0 |
| 2012-12-30 18:00:00 | YM | Futures | 12878.1 | 12900.3 | 12818.8 | 12880.1 | 1771.0 |
| 2012-12-30 18:30:00 | YM | Futures | 12881.1 | 12893.2 | 12873.1 | 12881.1 | 297.0 |
| 2012-12-30 19:00:00 | YM | Futures | 12885.2 | 12885.2 | 12875.1 | 12876.1 | 241.0 |
| 2012-12-30 19:30:00 | YM | Futures | 12876.1 | 12882.1 | 12871.1 | 12871.1 | 278.0 |
| 2012-12-30 20:00:00 | YM | Futures | 12874.1 | 12882.1 | 12872.1 | 12882.1 | 394.0 |
| 2012-12-30 20:30:00 | YM | Futures | 12882.1 | 12885.2 | 12872.1 | 12884.2 | 561.0 |
| 2012-12-30 21:00:00 | YM | Futures | 12882.1 | 12885.2 | 12880.1 | 12881.1 | 278.0 |
| 2012-12-30 21:30:00 | YM | Futures | 12881.1 | 12890.2 | 12877.1 | 12890.2 | 316.0 |
| 2012-12-30 22:00:00 | YM | Futures | 12889.2 | 12903.3 | 12888.2 | 12899.3 | 198.0 |
| 2012-12-30 22:30:00 | YM | Futures | 12898.2 | 12898.2 | 12890.2 | 12890.2 | 228.0 |
| 2012-12-30 23:00:00 | YM | Futures | 12891.2 | 12898.2 | 12882.1 | 12882.1 | 258.0 |
| 2012-12-30 23:30:00 | YM | Futures | 12882.1 | 12882.1 | 12871.1 | 12877.1 | 231.0 |
| 2012-12-30 18:00:00 | CL | Futures | 145.15 | 145.45 | 145.08 | 145.32 | 682.0 |
| 2012-12-30 18:30:00 | CL | Futures | 145.32 | 145.63 | 145.31 | 145.5 | 289.0 |
| 2012-12-30 19:00:00 | CL | Futures | 145.48 | 145.53 | 145.45 | 145.47 | 144.0 |
| 2012-12-30 19:30:00 | CL | Futures | 145.47 | 145.58 | 145.34 | 145.5 | 438.0 |
| 2012-12-30 20:00:00 | CL | Futures | 145.52 | 145.61 | 145.47 | 145.52 | 238.0 |
| 2012-12-30 20:30:00 | CL | Futures | 145.5 | 145.55 | 145.4 | 145.45 | 281.0 |
| 2012-12-30 21:00:00 | CL | Futures | 145.44 | 145.48 | 145.36 | 145.42 | 214.0 |
| 2012-12-30 21:30:00 | CL | Futures | 145.4 | 145.66 | 145.4 | 145.58 | 305.0 |
| 2012-12-30 22:00:00 | CL | Futures | 145.58 | 145.61 | 145.52 | 145.6 | 147.0 |
| 2012-12-30 22:30:00 | CL | Futures | 145.6 | 145.69 | 145.57 | 145.63 | 143.0 |
| 2012-12-30 23:00:00 | CL | Futures | 145.63 | 145.65 | 145.58 | 145.61 | 92.0 |
| 2012-12-30 23:30:00 | CL | Futures | 145.63 | 145.89 | 145.61 | 145.81 | 544.0 |
| 2012-12-30 18:00:00 | GC | Futures | 2280.6 | 2283.8 | 2280.6 | 2281.6 | 512.0 |
| 2012-12-30 18:30:00 | GC | Futures | 2281.4 | 2283.6 | 2281.4 | 2282.9 | 201.0 |
> showing 50 of 473 rows — these rows as CSV