PREVIEW / futures_30min / 2008-08-31
file: by_date/futures_30min/2008/2008-08-31.parquet size: 16 KB rows: 341
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 |
|---|---|---|---|---|---|---|---|
| 2008-08-31 18:00:00 | ES | Futures | 1191.83 | 1191.83 | 1190.66 | 1191.13 | 2532.0 |
| 2008-08-31 18:30:00 | ES | Futures | 1191.36 | 1191.36 | 1190.66 | 1190.9 | 343.0 |
| 2008-08-31 19:00:00 | ES | Futures | 1190.9 | 1191.13 | 1190.9 | 1190.9 | 583.0 |
| 2008-08-31 19:30:00 | ES | Futures | 1190.9 | 1191.83 | 1190.9 | 1191.83 | 769.0 |
| 2008-08-31 20:00:00 | ES | Futures | 1191.83 | 1192.29 | 1191.59 | 1191.83 | 1253.0 |
| 2008-08-31 20:30:00 | ES | Futures | 1191.83 | 1191.83 | 1190.9 | 1191.59 | 1416.0 |
| 2008-08-31 21:00:00 | ES | Futures | 1191.59 | 1191.83 | 1190.43 | 1190.9 | 1128.0 |
| 2008-08-31 21:30:00 | ES | Futures | 1190.66 | 1191.13 | 1190.43 | 1190.66 | 361.0 |
| 2008-08-31 22:00:00 | ES | Futures | 1190.43 | 1190.9 | 1190.43 | 1190.9 | 246.0 |
| 2008-08-31 22:30:00 | ES | Futures | 1190.9 | 1190.9 | 1189.97 | 1190.2 | 640.0 |
| 2008-08-31 23:00:00 | ES | Futures | 1190.2 | 1190.43 | 1190.2 | 1190.2 | 275.0 |
| 2008-08-31 23:30:00 | ES | Futures | 1190.2 | 1190.2 | 1188.11 | 1188.34 | 1425.0 |
| 2008-08-31 18:00:00 | NQ | Futures | 2109.95 | 2109.95 | 2105.45 | 2105.45 | 132.0 |
| 2008-08-31 18:30:00 | NQ | Futures | 2105.73 | 2106.57 | 2105.45 | 2106.57 | 14.0 |
| 2008-08-31 19:00:00 | NQ | Futures | 2106.01 | 2107.13 | 2105.73 | 2107.13 | 23.0 |
| 2008-08-31 19:30:00 | NQ | Futures | 2106.01 | 2106.29 | 2105.73 | 2106.01 | 12.0 |
| 2008-08-31 20:00:00 | NQ | Futures | 2106.57 | 2107.13 | 2106.57 | 2107.13 | 11.0 |
| 2008-08-31 20:30:00 | NQ | Futures | 2107.42 | 2107.7 | 2106.29 | 2107.42 | 27.0 |
| 2008-08-31 21:00:00 | NQ | Futures | 2106.85 | 2107.42 | 2106.29 | 2106.29 | 10.0 |
| 2008-08-31 21:30:00 | NQ | Futures | 2106.57 | 2106.85 | 2105.73 | 2105.73 | 10.0 |
| 2008-08-31 22:00:00 | NQ | Futures | 2105.73 | 2107.13 | 2105.73 | 2105.73 | 35.0 |
| 2008-08-31 22:30:00 | NQ | Futures | 2106.01 | 2106.29 | 2104.88 | 2106.29 | 129.0 |
| 2008-08-31 23:00:00 | NQ | Futures | 2105.45 | 2105.45 | 2105.45 | 2105.45 | 4.0 |
| 2008-08-31 23:30:00 | NQ | Futures | 2105.45 | 2105.45 | 2103.48 | 2103.48 | 195.0 |
| 2008-08-31 18:00:00 | YM | Futures | 10494.8 | 10494.8 | 10483.0 | 10489.3 | 385.0 |
| 2008-08-31 18:30:00 | YM | Futures | 10486.6 | 10489.3 | 10481.1 | 10483.9 | 53.0 |
| 2008-08-31 19:00:00 | YM | Futures | 10484.8 | 10486.6 | 10482.0 | 10484.8 | 69.0 |
| 2008-08-31 19:30:00 | YM | Futures | 10484.8 | 10489.3 | 10483.9 | 10488.4 | 49.0 |
| 2008-08-31 20:00:00 | YM | Futures | 10491.1 | 10493.0 | 10487.5 | 10493.0 | 64.0 |
| 2008-08-31 20:30:00 | YM | Futures | 10490.2 | 10490.2 | 10482.0 | 10489.3 | 27.0 |
| 2008-08-31 21:00:00 | YM | Futures | 10489.3 | 10490.2 | 10480.2 | 10482.0 | 50.0 |
| 2008-08-31 21:30:00 | YM | Futures | 10482.0 | 10483.0 | 10480.2 | 10481.1 | 10.0 |
| 2008-08-31 22:00:00 | YM | Futures | 10483.9 | 10484.8 | 10482.0 | 10483.9 | 77.0 |
| 2008-08-31 22:30:00 | YM | Futures | 10483.0 | 10483.0 | 10473.0 | 10474.8 | 111.0 |
| 2008-08-31 23:00:00 | YM | Futures | 10476.6 | 10477.5 | 10474.8 | 10475.7 | 28.0 |
| 2008-08-31 23:30:00 | YM | Futures | 10475.7 | 10475.7 | 10461.1 | 10462.1 | 95.0 |
| 2008-08-31 14:30:00 | CL | Futures | 441.05 | 448.42 | 441.05 | 446.19 | 1931.0 |
| 2008-08-31 15:00:00 | CL | Futures | 446.23 | 447.1 | 444.64 | 445.4 | 1071.0 |
| 2008-08-31 15:30:00 | CL | Futures | 445.06 | 445.21 | 442.07 | 442.26 | 693.0 |
| 2008-08-31 16:00:00 | CL | Futures | 442.26 | 443.2 | 441.77 | 443.05 | 419.0 |
| 2008-08-31 16:30:00 | CL | Futures | 443.09 | 443.28 | 442.64 | 442.64 | 216.0 |
| 2008-08-31 17:00:00 | CL | Futures | 442.86 | 442.9 | 440.71 | 441.96 | 500.0 |
| 2008-08-31 17:30:00 | CL | Futures | 441.92 | 441.92 | 440.86 | 441.54 | 124.0 |
| 2008-08-31 18:00:00 | CL | Futures | 441.5 | 442.71 | 441.43 | 442.56 | 558.0 |
| 2008-08-31 18:30:00 | CL | Futures | 442.45 | 442.79 | 441.77 | 442.37 | 239.0 |
| 2008-08-31 19:00:00 | CL | Futures | 442.37 | 443.01 | 441.99 | 442.71 | 278.0 |
| 2008-08-31 19:30:00 | CL | Futures | 442.52 | 442.79 | 441.99 | 442.6 | 92.0 |
| 2008-08-31 20:00:00 | CL | Futures | 442.52 | 443.32 | 442.3 | 442.9 | 463.0 |
| 2008-08-31 20:30:00 | CL | Futures | 442.79 | 442.82 | 439.69 | 440.06 | 383.0 |
| 2008-08-31 21:00:00 | CL | Futures | 440.06 | 440.86 | 439.46 | 440.48 | 316.0 |
> showing 50 of 341 rows — these rows as CSV