PREVIEW / futures_30min / 2008-10-01
file: by_date/futures_30min/2008/2008-10-01.parquet size: 71 KB rows: 2,328
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-10-01 00:00:00 | ES | Futures | 1099.0 | 1099.95 | 1098.53 | 1099.47 | 745.0 |
| 2008-10-01 00:30:00 | ES | Futures | 1099.47 | 1100.89 | 1099.24 | 1099.71 | 1281.0 |
| 2008-10-01 01:00:00 | ES | Futures | 1099.47 | 1100.66 | 1099.47 | 1100.18 | 542.0 |
| 2008-10-01 01:30:00 | ES | Futures | 1099.95 | 1100.89 | 1099.24 | 1100.66 | 884.0 |
| 2008-10-01 02:00:00 | ES | Futures | 1100.89 | 1101.84 | 1098.53 | 1099.71 | 4555.0 |
| 2008-10-01 02:30:00 | ES | Futures | 1099.95 | 1101.84 | 1097.82 | 1100.42 | 7054.0 |
| 2008-10-01 03:00:00 | ES | Futures | 1100.18 | 1100.42 | 1096.63 | 1099.47 | 11899.0 |
| 2008-10-01 03:30:00 | ES | Futures | 1099.47 | 1099.47 | 1095.69 | 1097.34 | 11364.0 |
| 2008-10-01 04:00:00 | ES | Futures | 1097.34 | 1097.34 | 1094.74 | 1095.21 | 8965.0 |
| 2008-10-01 04:30:00 | ES | Futures | 1094.98 | 1099.24 | 1094.74 | 1099.24 | 6958.0 |
| 2008-10-01 05:00:00 | ES | Futures | 1099.47 | 1099.71 | 1094.98 | 1095.45 | 8589.0 |
| 2008-10-01 05:30:00 | ES | Futures | 1095.69 | 1095.69 | 1091.9 | 1092.61 | 13049.0 |
| 2008-10-01 06:00:00 | ES | Futures | 1092.37 | 1094.27 | 1091.19 | 1093.32 | 10162.0 |
| 2008-10-01 06:30:00 | ES | Futures | 1093.56 | 1097.82 | 1093.56 | 1097.34 | 6366.0 |
| 2008-10-01 07:00:00 | ES | Futures | 1097.11 | 1099.24 | 1096.4 | 1097.34 | 9210.0 |
| 2008-10-01 07:30:00 | ES | Futures | 1097.34 | 1098.29 | 1094.74 | 1094.74 | 8751.0 |
| 2008-10-01 08:00:00 | ES | Futures | 1094.98 | 1097.11 | 1093.56 | 1095.92 | 24022.0 |
| 2008-10-01 08:30:00 | ES | Futures | 1096.16 | 1099.71 | 1094.27 | 1096.4 | 19539.0 |
| 2008-10-01 09:00:00 | ES | Futures | 1096.4 | 1097.82 | 1094.5 | 1094.74 | 20053.0 |
| 2008-10-01 09:30:00 | ES | Futures | 1094.98 | 1096.63 | 1088.35 | 1095.21 | 239234.0 |
| 2008-10-01 10:00:00 | ES | Futures | 1095.21 | 1095.45 | 1083.15 | 1089.53 | 226655.0 |
| 2008-10-01 10:30:00 | ES | Futures | 1089.3 | 1089.77 | 1082.91 | 1086.22 | 151295.0 |
| 2008-10-01 11:00:00 | ES | Futures | 1086.46 | 1092.14 | 1082.67 | 1091.19 | 135844.0 |
| 2008-10-01 11:30:00 | ES | Futures | 1091.19 | 1094.74 | 1089.3 | 1092.85 | 105590.0 |
| 2008-10-01 12:00:00 | ES | Futures | 1093.08 | 1099.95 | 1090.95 | 1098.53 | 127338.0 |
| 2008-10-01 12:30:00 | ES | Futures | 1098.53 | 1110.12 | 1098.05 | 1105.86 | 211707.0 |
| 2008-10-01 13:00:00 | ES | Futures | 1105.86 | 1106.34 | 1099.0 | 1100.42 | 141344.0 |
| 2008-10-01 13:30:00 | ES | Futures | 1100.42 | 1106.81 | 1091.43 | 1099.47 | 289148.0 |
| 2008-10-01 14:00:00 | ES | Futures | 1099.71 | 1106.57 | 1095.69 | 1106.1 | 161212.0 |
| 2008-10-01 14:30:00 | ES | Futures | 1106.1 | 1110.36 | 1100.89 | 1103.5 | 167640.0 |
| 2008-10-01 15:00:00 | ES | Futures | 1103.5 | 1107.28 | 1099.47 | 1102.55 | 108660.0 |
| 2008-10-01 15:30:00 | ES | Futures | 1102.79 | 1106.1 | 1100.89 | 1103.02 | 133028.0 |
| 2008-10-01 16:00:00 | ES | Futures | 1103.73 | 1109.18 | 1101.84 | 1105.15 | 80090.0 |
| 2008-10-01 16:30:00 | ES | Futures | 1105.86 | 1107.28 | 1105.39 | 1105.39 | 4375.0 |
| 2008-10-01 17:00:00 | ES | Futures | 1105.15 | 1107.76 | 1105.15 | 1107.28 | 1972.0 |
| 2008-10-01 18:00:00 | ES | Futures | 1107.52 | 1110.6 | 1106.81 | 1109.18 | 3440.0 |
| 2008-10-01 18:30:00 | ES | Futures | 1109.41 | 1110.12 | 1108.47 | 1108.47 | 859.0 |
| 2008-10-01 19:00:00 | ES | Futures | 1108.7 | 1111.31 | 1108.47 | 1110.6 | 1999.0 |
| 2008-10-01 19:30:00 | ES | Futures | 1110.83 | 1111.07 | 1107.28 | 1107.52 | 2750.0 |
| 2008-10-01 20:00:00 | ES | Futures | 1107.52 | 1110.12 | 1106.81 | 1109.65 | 3525.0 |
| 2008-10-01 20:30:00 | ES | Futures | 1109.41 | 1109.65 | 1101.84 | 1105.15 | 5155.0 |
| 2008-10-01 21:00:00 | ES | Futures | 1105.15 | 1111.31 | 1100.89 | 1103.02 | 14495.0 |
| 2008-10-01 21:30:00 | ES | Futures | 1103.02 | 1104.21 | 1093.56 | 1097.58 | 17699.0 |
| 2008-10-01 22:00:00 | ES | Futures | 1097.34 | 1099.47 | 1094.74 | 1097.11 | 4706.0 |
| 2008-10-01 22:30:00 | ES | Futures | 1097.11 | 1097.34 | 1093.32 | 1094.03 | 4458.0 |
| 2008-10-01 23:00:00 | ES | Futures | 1094.27 | 1096.16 | 1094.03 | 1094.74 | 1730.0 |
| 2008-10-01 23:30:00 | ES | Futures | 1094.74 | 1096.16 | 1094.5 | 1094.98 | 1365.0 |
| 2008-10-01 00:00:00 | NQ | Futures | 1800.78 | 1801.91 | 1800.78 | 1801.91 | 47.0 |
| 2008-10-01 00:30:00 | NQ | Futures | 1802.48 | 1807.0 | 1802.48 | 1803.04 | 106.0 |
| 2008-10-01 01:00:00 | NQ | Futures | 1804.17 | 1804.17 | 1803.04 | 1803.61 | 5.0 |
> showing 50 of 2,328 rows — these rows as CSV