PREVIEW / futures_30min / 2010-09-13
file: by_date/futures_30min/2010/2010-09-13.parquet size: 68 KB rows: 2,467
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 |
|---|---|---|---|---|---|---|---|
| 2010-09-13 00:00:00 | ES | Futures | 1098.07 | 1099.05 | 1098.07 | 1098.81 | 351.0 |
| 2010-09-13 00:30:00 | ES | Futures | 1098.56 | 1098.81 | 1098.32 | 1098.32 | 318.0 |
| 2010-09-13 01:00:00 | ES | Futures | 1098.07 | 1098.56 | 1097.58 | 1097.58 | 440.0 |
| 2010-09-13 01:30:00 | ES | Futures | 1097.58 | 1098.07 | 1097.09 | 1097.34 | 736.0 |
| 2010-09-13 02:00:00 | ES | Futures | 1097.34 | 1098.81 | 1097.09 | 1098.56 | 2386.0 |
| 2010-09-13 02:30:00 | ES | Futures | 1098.32 | 1099.55 | 1098.32 | 1098.56 | 4011.0 |
| 2010-09-13 03:00:00 | ES | Futures | 1098.56 | 1099.55 | 1097.34 | 1098.81 | 5136.0 |
| 2010-09-13 03:30:00 | ES | Futures | 1099.05 | 1099.79 | 1096.36 | 1096.85 | 6450.0 |
| 2010-09-13 04:00:00 | ES | Futures | 1097.09 | 1099.79 | 1096.85 | 1099.79 | 3030.0 |
| 2010-09-13 04:30:00 | ES | Futures | 1099.55 | 1099.79 | 1098.81 | 1099.3 | 2597.0 |
| 2010-09-13 05:00:00 | ES | Futures | 1099.05 | 1101.26 | 1099.05 | 1099.55 | 4275.0 |
| 2010-09-13 05:30:00 | ES | Futures | 1099.79 | 1100.04 | 1099.05 | 1099.3 | 3014.0 |
| 2010-09-13 06:00:00 | ES | Futures | 1099.05 | 1099.3 | 1098.56 | 1099.05 | 2707.0 |
| 2010-09-13 06:30:00 | ES | Futures | 1098.81 | 1099.55 | 1098.32 | 1098.81 | 2091.0 |
| 2010-09-13 07:00:00 | ES | Futures | 1098.56 | 1099.05 | 1098.07 | 1098.32 | 1868.0 |
| 2010-09-13 07:30:00 | ES | Futures | 1098.32 | 1099.55 | 1097.83 | 1098.07 | 2771.0 |
| 2010-09-13 08:00:00 | ES | Futures | 1098.32 | 1099.05 | 1097.58 | 1098.07 | 6343.0 |
| 2010-09-13 08:30:00 | ES | Futures | 1098.07 | 1098.32 | 1096.85 | 1097.34 | 7437.0 |
| 2010-09-13 09:00:00 | ES | Futures | 1097.34 | 1099.79 | 1097.09 | 1099.55 | 11631.0 |
| 2010-09-13 09:30:00 | ES | Futures | 1099.3 | 1101.51 | 1098.07 | 1098.81 | 55670.0 |
| 2010-09-13 10:00:00 | ES | Futures | 1098.81 | 1102.0 | 1098.56 | 1101.51 | 39710.0 |
| 2010-09-13 10:30:00 | ES | Futures | 1101.75 | 1103.23 | 1101.51 | 1101.75 | 29548.0 |
| 2010-09-13 11:00:00 | ES | Futures | 1101.51 | 1102.0 | 1100.53 | 1101.75 | 16387.0 |
| 2010-09-13 11:30:00 | ES | Futures | 1101.75 | 1101.75 | 1098.81 | 1100.04 | 17851.0 |
| 2010-09-13 12:00:00 | ES | Futures | 1100.28 | 1100.28 | 1095.13 | 1096.85 | 23131.0 |
| 2010-09-13 12:30:00 | ES | Futures | 1096.6 | 1097.83 | 1095.86 | 1097.09 | 9626.0 |
| 2010-09-13 13:00:00 | ES | Futures | 1097.09 | 1098.81 | 1096.36 | 1098.32 | 7286.0 |
| 2010-09-13 13:30:00 | ES | Futures | 1098.32 | 1099.05 | 1097.34 | 1097.34 | 6021.0 |
| 2010-09-13 14:00:00 | ES | Futures | 1097.34 | 1098.81 | 1095.86 | 1098.56 | 11765.0 |
| 2010-09-13 14:30:00 | ES | Futures | 1098.32 | 1099.55 | 1097.83 | 1099.3 | 8500.0 |
| 2010-09-13 15:00:00 | ES | Futures | 1099.3 | 1100.04 | 1097.83 | 1099.79 | 12742.0 |
| 2010-09-13 15:30:00 | ES | Futures | 1099.79 | 1102.24 | 1099.3 | 1101.02 | 30969.0 |
| 2010-09-13 16:00:00 | ES | Futures | 1101.02 | 1101.75 | 1100.04 | 1100.04 | 15721.0 |
| 2010-09-13 16:30:00 | ES | Futures | 1100.04 | 1102.0 | 1100.04 | 1101.75 | 1137.0 |
| 2010-09-13 17:00:00 | ES | Futures | 1101.51 | 1103.72 | 1101.51 | 1102.98 | 908.0 |
| 2010-09-13 18:00:00 | ES | Futures | 1102.74 | 1103.47 | 1102.24 | 1102.49 | 478.0 |
| 2010-09-13 18:30:00 | ES | Futures | 1102.49 | 1102.49 | 1101.75 | 1102.24 | 82.0 |
| 2010-09-13 19:00:00 | ES | Futures | 1102.24 | 1102.49 | 1101.75 | 1102.0 | 363.0 |
| 2010-09-13 19:30:00 | ES | Futures | 1102.0 | 1102.49 | 1101.26 | 1101.26 | 127.0 |
| 2010-09-13 20:00:00 | ES | Futures | 1101.26 | 1101.26 | 1100.53 | 1100.53 | 741.0 |
| 2010-09-13 20:30:00 | ES | Futures | 1100.53 | 1101.02 | 1099.55 | 1100.04 | 828.0 |
| 2010-09-13 21:00:00 | ES | Futures | 1100.28 | 1101.02 | 1100.04 | 1101.02 | 409.0 |
| 2010-09-13 21:30:00 | ES | Futures | 1101.02 | 1101.51 | 1099.79 | 1100.28 | 382.0 |
| 2010-09-13 22:00:00 | ES | Futures | 1100.28 | 1100.28 | 1099.79 | 1100.04 | 176.0 |
| 2010-09-13 22:30:00 | ES | Futures | 1100.04 | 1100.53 | 1099.79 | 1100.53 | 149.0 |
| 2010-09-13 23:00:00 | ES | Futures | 1100.53 | 1101.02 | 1100.28 | 1100.77 | 277.0 |
| 2010-09-13 23:30:00 | ES | Futures | 1100.77 | 1100.77 | 1099.79 | 1100.28 | 302.0 |
| 2010-09-13 00:00:00 | NQ | Futures | 2187.65 | 2187.93 | 2187.36 | 2187.65 | 13.0 |
| 2010-09-13 00:30:00 | NQ | Futures | 2187.65 | 2188.22 | 2187.07 | 2187.65 | 35.0 |
| 2010-09-13 01:00:00 | NQ | Futures | 2187.65 | 2188.22 | 2186.5 | 2186.79 | 56.0 |
> showing 50 of 2,467 rows — these rows as CSV