PREVIEW / futures_30min / 2008-06-29
file: by_date/futures_30min/2008/2008-06-29.parquet size: 17 KB rows: 387
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-06-29 18:00:00 | ES | Futures | 1191.59 | 1191.59 | 1189.97 | 1189.97 | 2956.0 |
| 2008-06-29 18:30:00 | ES | Futures | 1190.2 | 1191.13 | 1190.2 | 1190.2 | 711.0 |
| 2008-06-29 19:00:00 | ES | Futures | 1190.2 | 1191.59 | 1190.2 | 1191.59 | 941.0 |
| 2008-06-29 19:30:00 | ES | Futures | 1191.59 | 1192.06 | 1190.66 | 1191.83 | 1690.0 |
| 2008-06-29 20:00:00 | ES | Futures | 1191.83 | 1192.29 | 1190.9 | 1191.36 | 1062.0 |
| 2008-06-29 20:30:00 | ES | Futures | 1191.36 | 1192.76 | 1191.36 | 1192.29 | 1856.0 |
| 2008-06-29 21:00:00 | ES | Futures | 1192.29 | 1192.76 | 1191.83 | 1191.83 | 1377.0 |
| 2008-06-29 21:30:00 | ES | Futures | 1192.06 | 1194.15 | 1191.83 | 1194.15 | 2078.0 |
| 2008-06-29 22:00:00 | ES | Futures | 1194.15 | 1194.15 | 1192.76 | 1192.76 | 1089.0 |
| 2008-06-29 22:30:00 | ES | Futures | 1192.99 | 1192.99 | 1191.83 | 1192.06 | 962.0 |
| 2008-06-29 23:00:00 | ES | Futures | 1192.06 | 1192.29 | 1191.36 | 1191.59 | 1741.0 |
| 2008-06-29 23:30:00 | ES | Futures | 1191.59 | 1192.06 | 1191.36 | 1192.06 | 718.0 |
| 2008-06-29 18:00:00 | NQ | Futures | 2100.38 | 2104.32 | 2100.38 | 2101.79 | 339.0 |
| 2008-06-29 18:30:00 | NQ | Futures | 2101.79 | 2102.92 | 2100.95 | 2101.79 | 36.0 |
| 2008-06-29 19:00:00 | NQ | Futures | 2101.23 | 2101.51 | 2100.95 | 2101.51 | 112.0 |
| 2008-06-29 19:30:00 | NQ | Futures | 2102.92 | 2103.76 | 2099.54 | 2100.1 | 524.0 |
| 2008-06-29 20:00:00 | NQ | Futures | 2100.95 | 2102.63 | 2100.1 | 2102.63 | 135.0 |
| 2008-06-29 20:30:00 | NQ | Futures | 2102.35 | 2103.76 | 2102.07 | 2102.07 | 85.0 |
| 2008-06-29 21:00:00 | NQ | Futures | 2103.48 | 2104.04 | 2102.07 | 2102.07 | 88.0 |
| 2008-06-29 21:30:00 | NQ | Futures | 2102.35 | 2104.88 | 2102.35 | 2104.88 | 85.0 |
| 2008-06-29 22:00:00 | NQ | Futures | 2104.88 | 2104.88 | 2103.2 | 2103.2 | 51.0 |
| 2008-06-29 22:30:00 | NQ | Futures | 2102.92 | 2102.92 | 2100.38 | 2100.95 | 50.0 |
| 2008-06-29 23:00:00 | NQ | Futures | 2100.66 | 2100.66 | 2100.66 | 2100.66 | 4.0 |
| 2008-06-29 23:30:00 | NQ | Futures | 2100.66 | 2100.95 | 2100.66 | 2100.66 | 9.0 |
| 2008-06-29 18:00:00 | YM | Futures | 10329.4 | 10332.1 | 10319.4 | 10323.0 | 103.0 |
| 2008-06-29 18:30:00 | YM | Futures | 10323.0 | 10325.7 | 10319.4 | 10323.0 | 34.0 |
| 2008-06-29 19:00:00 | YM | Futures | 10323.0 | 10328.4 | 10321.2 | 10328.4 | 14.0 |
| 2008-06-29 19:30:00 | YM | Futures | 10328.4 | 10335.7 | 10324.8 | 10334.8 | 156.0 |
| 2008-06-29 20:00:00 | YM | Futures | 10335.7 | 10337.5 | 10326.6 | 10331.2 | 63.0 |
| 2008-06-29 20:30:00 | YM | Futures | 10330.3 | 10340.3 | 10330.3 | 10336.6 | 56.0 |
| 2008-06-29 21:00:00 | YM | Futures | 10338.4 | 10341.2 | 10330.3 | 10330.3 | 88.0 |
| 2008-06-29 21:30:00 | YM | Futures | 10332.1 | 10351.2 | 10332.1 | 10351.2 | 85.0 |
| 2008-06-29 22:00:00 | YM | Futures | 10350.3 | 10351.2 | 10340.3 | 10343.0 | 77.0 |
| 2008-06-29 22:30:00 | YM | Futures | 10341.2 | 10341.2 | 10331.2 | 10331.2 | 99.0 |
| 2008-06-29 23:00:00 | YM | Futures | 10330.3 | 10342.1 | 10330.3 | 10331.2 | 126.0 |
| 2008-06-29 23:30:00 | YM | Futures | 10330.3 | 10338.4 | 10329.4 | 10334.8 | 53.0 |
| 2008-06-29 18:00:00 | CL | Futures | 533.58 | 534.98 | 533.58 | 534.34 | 434.0 |
| 2008-06-29 18:30:00 | CL | Futures | 534.38 | 535.93 | 534.38 | 535.52 | 253.0 |
| 2008-06-29 19:00:00 | CL | Futures | 535.67 | 535.71 | 535.25 | 535.44 | 52.0 |
| 2008-06-29 19:30:00 | CL | Futures | 535.29 | 537.38 | 534.57 | 536.88 | 511.0 |
| 2008-06-29 20:00:00 | CL | Futures | 536.88 | 537.64 | 536.81 | 537.53 | 212.0 |
| 2008-06-29 20:30:00 | CL | Futures | 537.49 | 537.83 | 536.84 | 537.72 | 284.0 |
| 2008-06-29 21:00:00 | CL | Futures | 537.64 | 538.63 | 537.03 | 538.4 | 261.0 |
| 2008-06-29 21:30:00 | CL | Futures | 538.29 | 538.51 | 537.6 | 537.6 | 168.0 |
| 2008-06-29 22:00:00 | CL | Futures | 537.64 | 538.4 | 537.64 | 537.72 | 71.0 |
| 2008-06-29 22:30:00 | CL | Futures | 537.64 | 537.64 | 536.92 | 537.03 | 176.0 |
| 2008-06-29 23:00:00 | CL | Futures | 537.19 | 538.29 | 537.19 | 538.06 | 211.0 |
| 2008-06-29 23:30:00 | CL | Futures | 538.21 | 538.21 | 537.87 | 538.02 | 28.0 |
| 2008-06-29 18:00:00 | GC | Futures | 1341.9 | 1343.2 | 1339.3 | 1340.6 | 317.0 |
| 2008-06-29 18:30:00 | GC | Futures | 1340.5 | 1342.9 | 1340.2 | 1342.6 | 276.0 |
> showing 50 of 387 rows — these rows as CSV