PREVIEW / futures_30min / 2012-06-24
file: by_date/futures_30min/2012/2012-06-24.parquet size: 19 KB rows: 510
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-06-24 18:00:00 | ES | Futures | 1348.21 | 1349.23 | 1345.41 | 1345.67 | 7377.0 |
| 2012-06-24 18:30:00 | ES | Futures | 1345.67 | 1346.69 | 1345.41 | 1346.69 | 2023.0 |
| 2012-06-24 19:00:00 | ES | Futures | 1346.69 | 1347.19 | 1346.18 | 1346.69 | 1998.0 |
| 2012-06-24 19:30:00 | ES | Futures | 1346.43 | 1346.43 | 1345.41 | 1345.67 | 2478.0 |
| 2012-06-24 20:00:00 | ES | Futures | 1345.92 | 1346.18 | 1342.87 | 1342.87 | 8026.0 |
| 2012-06-24 20:30:00 | ES | Futures | 1342.87 | 1343.63 | 1342.11 | 1342.11 | 5461.0 |
| 2012-06-24 21:00:00 | ES | Futures | 1342.36 | 1343.38 | 1341.85 | 1343.13 | 8134.0 |
| 2012-06-24 21:30:00 | ES | Futures | 1342.87 | 1343.38 | 1342.11 | 1343.38 | 4756.0 |
| 2012-06-24 22:00:00 | ES | Futures | 1343.38 | 1343.63 | 1342.36 | 1343.13 | 1928.0 |
| 2012-06-24 22:30:00 | ES | Futures | 1343.13 | 1343.63 | 1342.11 | 1342.62 | 2661.0 |
| 2012-06-24 23:00:00 | ES | Futures | 1342.62 | 1343.63 | 1342.36 | 1343.13 | 1759.0 |
| 2012-06-24 23:30:00 | ES | Futures | 1343.13 | 1344.65 | 1343.13 | 1344.4 | 2388.0 |
| 2012-06-24 18:00:00 | NQ | Futures | 2984.37 | 2988.42 | 2976.83 | 2978.86 | 513.0 |
| 2012-06-24 18:30:00 | NQ | Futures | 2978.57 | 2981.47 | 2978.57 | 2981.47 | 187.0 |
| 2012-06-24 19:00:00 | NQ | Futures | 2980.89 | 2982.63 | 2979.73 | 2980.89 | 142.0 |
| 2012-06-24 19:30:00 | NQ | Futures | 2980.89 | 2980.89 | 2978.86 | 2979.44 | 97.0 |
| 2012-06-24 20:00:00 | NQ | Futures | 2979.73 | 2980.31 | 2974.51 | 2975.09 | 429.0 |
| 2012-06-24 20:30:00 | NQ | Futures | 2974.8 | 2975.67 | 2972.48 | 2973.06 | 255.0 |
| 2012-06-24 21:00:00 | NQ | Futures | 2973.35 | 2974.8 | 2971.9 | 2974.51 | 227.0 |
| 2012-06-24 21:30:00 | NQ | Futures | 2974.51 | 2975.09 | 2972.48 | 2974.8 | 253.0 |
| 2012-06-24 22:00:00 | NQ | Futures | 2974.8 | 2975.38 | 2973.64 | 2974.51 | 161.0 |
| 2012-06-24 22:30:00 | NQ | Futures | 2974.51 | 2975.38 | 2972.19 | 2972.77 | 194.0 |
| 2012-06-24 23:00:00 | NQ | Futures | 2972.48 | 2975.67 | 2972.48 | 2974.8 | 142.0 |
| 2012-06-24 23:30:00 | NQ | Futures | 2975.09 | 2977.41 | 2974.8 | 2976.83 | 285.0 |
| 2012-06-24 18:00:00 | YM | Futures | 12495.7 | 12495.7 | 12463.8 | 12467.8 | 690.0 |
| 2012-06-24 18:30:00 | YM | Futures | 12463.8 | 12476.8 | 12463.8 | 12473.8 | 249.0 |
| 2012-06-24 19:00:00 | YM | Futures | 12472.8 | 12477.8 | 12470.8 | 12472.8 | 161.0 |
| 2012-06-24 19:30:00 | YM | Futures | 12472.8 | 12472.8 | 12465.8 | 12467.8 | 135.0 |
| 2012-06-24 20:00:00 | YM | Futures | 12466.8 | 12469.8 | 12445.9 | 12447.9 | 473.0 |
| 2012-06-24 20:30:00 | YM | Futures | 12446.9 | 12450.9 | 12440.0 | 12442.0 | 219.0 |
| 2012-06-24 21:00:00 | YM | Futures | 12442.0 | 12448.9 | 12436.0 | 12446.9 | 300.0 |
| 2012-06-24 21:30:00 | YM | Futures | 12447.9 | 12448.9 | 12439.0 | 12448.9 | 297.0 |
| 2012-06-24 22:00:00 | YM | Futures | 12448.9 | 12449.9 | 12442.0 | 12445.9 | 176.0 |
| 2012-06-24 22:30:00 | YM | Futures | 12445.9 | 12449.9 | 12439.0 | 12441.0 | 188.0 |
| 2012-06-24 23:00:00 | YM | Futures | 12441.0 | 12450.9 | 12439.0 | 12444.0 | 188.0 |
| 2012-06-24 23:30:00 | YM | Futures | 12444.9 | 12455.9 | 12444.9 | 12455.9 | 138.0 |
| 2012-06-24 18:00:00 | CL | Futures | 132.37 | 133.16 | 132.09 | 132.67 | 1339.0 |
| 2012-06-24 18:30:00 | CL | Futures | 132.67 | 132.67 | 132.17 | 132.17 | 668.0 |
| 2012-06-24 19:00:00 | CL | Futures | 132.15 | 132.19 | 132.01 | 132.14 | 404.0 |
| 2012-06-24 19:30:00 | CL | Futures | 132.12 | 132.12 | 131.92 | 132.12 | 216.0 |
| 2012-06-24 20:00:00 | CL | Futures | 132.12 | 132.15 | 131.72 | 131.79 | 744.0 |
| 2012-06-24 20:30:00 | CL | Futures | 131.76 | 131.82 | 131.66 | 131.68 | 388.0 |
| 2012-06-24 21:00:00 | CL | Futures | 131.69 | 132.02 | 131.69 | 131.92 | 474.0 |
| 2012-06-24 21:30:00 | CL | Futures | 131.92 | 132.32 | 131.84 | 132.17 | 546.0 |
| 2012-06-24 22:00:00 | CL | Futures | 132.17 | 132.22 | 131.97 | 132.07 | 161.0 |
| 2012-06-24 22:30:00 | CL | Futures | 132.09 | 132.14 | 131.86 | 131.96 | 229.0 |
| 2012-06-24 23:00:00 | CL | Futures | 131.99 | 132.15 | 131.86 | 132.12 | 156.0 |
| 2012-06-24 23:30:00 | CL | Futures | 132.14 | 132.52 | 132.1 | 132.43 | 477.0 |
| 2012-06-24 18:00:00 | GC | Futures | 2176.1 | 2178.0 | 2172.4 | 2173.9 | 597.0 |
| 2012-06-24 18:30:00 | GC | Futures | 2174.0 | 2174.0 | 2169.7 | 2169.9 | 431.0 |
> showing 50 of 510 rows — these rows as CSV