PREVIEW / futures_30min / 2008-09-30
file: by_date/futures_30min/2008/2008-09-30.parquet size: 75 KB rows: 2,356
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-09-30 00:00:00 | ES | Futures | 1069.18 | 1072.73 | 1067.53 | 1068.0 | 5699.0 |
| 2008-09-30 00:30:00 | ES | Futures | 1068.0 | 1071.08 | 1068.0 | 1071.08 | 1341.0 |
| 2008-09-30 01:00:00 | ES | Futures | 1071.08 | 1072.5 | 1069.66 | 1072.26 | 2104.0 |
| 2008-09-30 01:30:00 | ES | Futures | 1072.5 | 1074.15 | 1072.02 | 1072.5 | 5685.0 |
| 2008-09-30 02:00:00 | ES | Futures | 1072.73 | 1078.41 | 1070.37 | 1076.99 | 15362.0 |
| 2008-09-30 02:30:00 | ES | Futures | 1076.76 | 1078.65 | 1074.39 | 1077.94 | 9687.0 |
| 2008-09-30 03:00:00 | ES | Futures | 1078.18 | 1082.91 | 1074.63 | 1082.91 | 30206.0 |
| 2008-09-30 03:30:00 | ES | Futures | 1082.91 | 1088.35 | 1082.67 | 1087.41 | 35737.0 |
| 2008-09-30 04:00:00 | ES | Futures | 1087.41 | 1092.85 | 1086.22 | 1086.46 | 34857.0 |
| 2008-09-30 04:30:00 | ES | Futures | 1086.46 | 1088.35 | 1085.04 | 1087.88 | 12157.0 |
| 2008-09-30 05:00:00 | ES | Futures | 1087.88 | 1092.14 | 1085.28 | 1087.88 | 15943.0 |
| 2008-09-30 05:30:00 | ES | Futures | 1087.64 | 1092.85 | 1087.17 | 1089.77 | 13198.0 |
| 2008-09-30 06:00:00 | ES | Futures | 1090.01 | 1092.37 | 1085.04 | 1085.51 | 17182.0 |
| 2008-09-30 06:30:00 | ES | Futures | 1085.75 | 1088.59 | 1084.09 | 1084.33 | 17846.0 |
| 2008-09-30 07:00:00 | ES | Futures | 1084.09 | 1084.8 | 1080.54 | 1083.86 | 20339.0 |
| 2008-09-30 07:30:00 | ES | Futures | 1083.86 | 1088.35 | 1083.15 | 1084.09 | 22144.0 |
| 2008-09-30 08:00:00 | ES | Futures | 1084.09 | 1084.57 | 1081.02 | 1082.2 | 25205.0 |
| 2008-09-30 08:30:00 | ES | Futures | 1082.44 | 1084.33 | 1078.18 | 1079.6 | 46651.0 |
| 2008-09-30 09:00:00 | ES | Futures | 1079.83 | 1081.73 | 1077.23 | 1078.65 | 28781.0 |
| 2008-09-30 09:30:00 | ES | Futures | 1078.89 | 1081.02 | 1071.55 | 1076.28 | 261175.0 |
| 2008-09-30 10:00:00 | ES | Futures | 1076.28 | 1087.88 | 1072.73 | 1083.62 | 268831.0 |
| 2008-09-30 10:30:00 | ES | Futures | 1083.38 | 1090.72 | 1082.91 | 1083.15 | 193528.0 |
| 2008-09-30 11:00:00 | ES | Futures | 1083.15 | 1085.04 | 1080.54 | 1083.62 | 138259.0 |
| 2008-09-30 11:30:00 | ES | Futures | 1083.62 | 1092.14 | 1082.91 | 1090.24 | 147138.0 |
| 2008-09-30 12:00:00 | ES | Futures | 1090.48 | 1091.66 | 1082.44 | 1083.62 | 82302.0 |
| 2008-09-30 12:30:00 | ES | Futures | 1083.38 | 1090.48 | 1082.44 | 1090.24 | 75464.0 |
| 2008-09-30 13:00:00 | ES | Futures | 1090.24 | 1095.69 | 1084.57 | 1095.21 | 154945.0 |
| 2008-09-30 13:30:00 | ES | Futures | 1095.21 | 1099.71 | 1094.74 | 1096.4 | 162140.0 |
| 2008-09-30 14:00:00 | ES | Futures | 1096.4 | 1102.55 | 1094.27 | 1102.31 | 125289.0 |
| 2008-09-30 14:30:00 | ES | Futures | 1102.31 | 1104.21 | 1098.76 | 1100.66 | 128099.0 |
| 2008-09-30 15:00:00 | ES | Futures | 1100.66 | 1107.28 | 1096.87 | 1105.63 | 191857.0 |
| 2008-09-30 15:30:00 | ES | Futures | 1105.39 | 1112.96 | 1101.6 | 1111.31 | 377418.0 |
| 2008-09-30 16:00:00 | ES | Futures | 1111.07 | 1112.73 | 1102.31 | 1105.63 | 168672.0 |
| 2008-09-30 16:30:00 | ES | Futures | 1105.15 | 1105.86 | 1101.84 | 1102.79 | 10808.0 |
| 2008-09-30 17:00:00 | ES | Futures | 1102.79 | 1104.68 | 1102.08 | 1103.73 | 5673.0 |
| 2008-09-30 18:00:00 | ES | Futures | 1103.26 | 1103.73 | 1101.6 | 1103.26 | 3505.0 |
| 2008-09-30 18:30:00 | ES | Futures | 1103.5 | 1106.57 | 1100.42 | 1100.42 | 3946.0 |
| 2008-09-30 19:00:00 | ES | Futures | 1100.42 | 1107.52 | 1100.42 | 1105.63 | 4150.0 |
| 2008-09-30 19:30:00 | ES | Futures | 1105.63 | 1108.94 | 1104.21 | 1105.63 | 4563.0 |
| 2008-09-30 20:00:00 | ES | Futures | 1105.63 | 1107.99 | 1100.66 | 1100.89 | 3959.0 |
| 2008-09-30 20:30:00 | ES | Futures | 1100.89 | 1102.55 | 1100.42 | 1101.6 | 2033.0 |
| 2008-09-30 21:00:00 | ES | Futures | 1101.6 | 1101.6 | 1100.42 | 1101.13 | 1696.0 |
| 2008-09-30 21:30:00 | ES | Futures | 1101.13 | 1101.13 | 1098.76 | 1099.0 | 2697.0 |
| 2008-09-30 22:00:00 | ES | Futures | 1098.76 | 1100.89 | 1098.76 | 1100.89 | 1481.0 |
| 2008-09-30 22:30:00 | ES | Futures | 1100.89 | 1101.6 | 1100.18 | 1100.18 | 1137.0 |
| 2008-09-30 23:00:00 | ES | Futures | 1100.18 | 1100.42 | 1099.0 | 1099.0 | 1141.0 |
| 2008-09-30 23:30:00 | ES | Futures | 1099.0 | 1099.24 | 1098.53 | 1099.24 | 846.0 |
| 2008-09-30 00:00:00 | NQ | Futures | 1729.47 | 1731.17 | 1722.4 | 1722.96 | 461.0 |
| 2008-09-30 00:30:00 | NQ | Futures | 1723.25 | 1726.64 | 1723.25 | 1726.64 | 179.0 |
| 2008-09-30 01:00:00 | NQ | Futures | 1726.64 | 1728.06 | 1724.38 | 1727.49 | 139.0 |
> showing 50 of 2,356 rows — these rows as CSV