PREVIEW / futures_30min / 2008-09-17
file: by_date/futures_30min/2008/2008-09-17.parquet size: 75 KB rows: 2,337
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-17 00:00:00 | ES | Futures | 1155.32 | 1155.32 | 1153.43 | 1153.67 | 1342.0 |
| 2008-09-17 00:30:00 | ES | Futures | 1153.9 | 1154.85 | 1152.01 | 1153.43 | 2036.0 |
| 2008-09-17 01:00:00 | ES | Futures | 1153.19 | 1154.85 | 1152.01 | 1152.96 | 1205.0 |
| 2008-09-17 01:30:00 | ES | Futures | 1152.96 | 1155.8 | 1152.96 | 1154.14 | 3514.0 |
| 2008-09-17 02:00:00 | ES | Futures | 1153.9 | 1155.8 | 1150.59 | 1150.83 | 7641.0 |
| 2008-09-17 02:30:00 | ES | Futures | 1150.83 | 1155.56 | 1150.35 | 1154.85 | 10893.0 |
| 2008-09-17 03:00:00 | ES | Futures | 1154.85 | 1155.32 | 1149.41 | 1149.64 | 14689.0 |
| 2008-09-17 03:30:00 | ES | Futures | 1149.64 | 1150.59 | 1132.61 | 1136.15 | 38486.0 |
| 2008-09-17 04:00:00 | ES | Futures | 1136.39 | 1143.73 | 1135.44 | 1142.78 | 25144.0 |
| 2008-09-17 04:30:00 | ES | Futures | 1142.78 | 1149.41 | 1142.78 | 1148.7 | 14274.0 |
| 2008-09-17 05:00:00 | ES | Futures | 1148.7 | 1149.41 | 1144.91 | 1147.28 | 12027.0 |
| 2008-09-17 05:30:00 | ES | Futures | 1147.04 | 1149.88 | 1145.38 | 1145.38 | 11444.0 |
| 2008-09-17 06:00:00 | ES | Futures | 1145.15 | 1147.28 | 1140.65 | 1144.2 | 12252.0 |
| 2008-09-17 06:30:00 | ES | Futures | 1143.96 | 1147.28 | 1143.73 | 1146.57 | 13163.0 |
| 2008-09-17 07:00:00 | ES | Futures | 1146.33 | 1149.64 | 1144.44 | 1144.91 | 25793.0 |
| 2008-09-17 07:30:00 | ES | Futures | 1144.91 | 1147.51 | 1143.96 | 1144.67 | 18127.0 |
| 2008-09-17 08:00:00 | ES | Futures | 1144.67 | 1146.09 | 1134.5 | 1134.74 | 56512.0 |
| 2008-09-17 08:30:00 | ES | Futures | 1134.5 | 1137.34 | 1128.58 | 1128.82 | 77292.0 |
| 2008-09-17 09:00:00 | ES | Futures | 1128.82 | 1132.13 | 1124.8 | 1129.06 | 73659.0 |
| 2008-09-17 09:30:00 | ES | Futures | 1128.82 | 1136.15 | 1122.43 | 1133.08 | 405212.0 |
| 2008-09-17 10:00:00 | ES | Futures | 1133.32 | 1136.39 | 1124.8 | 1125.98 | 240756.0 |
| 2008-09-17 10:30:00 | ES | Futures | 1125.98 | 1128.58 | 1117.46 | 1120.54 | 274577.0 |
| 2008-09-17 11:00:00 | ES | Futures | 1120.54 | 1121.96 | 1105.86 | 1107.76 | 307763.0 |
| 2008-09-17 11:30:00 | ES | Futures | 1107.99 | 1118.17 | 1106.81 | 1112.02 | 279617.0 |
| 2008-09-17 12:00:00 | ES | Futures | 1112.02 | 1112.25 | 1102.08 | 1104.92 | 262973.0 |
| 2008-09-17 12:30:00 | ES | Futures | 1105.15 | 1117.7 | 1104.21 | 1113.67 | 203014.0 |
| 2008-09-17 13:00:00 | ES | Futures | 1113.67 | 1118.88 | 1106.34 | 1106.81 | 172288.0 |
| 2008-09-17 13:30:00 | ES | Futures | 1106.81 | 1110.36 | 1101.84 | 1106.57 | 223874.0 |
| 2008-09-17 14:00:00 | ES | Futures | 1106.57 | 1120.77 | 1103.5 | 1120.54 | 268901.0 |
| 2008-09-17 14:30:00 | ES | Futures | 1120.54 | 1127.87 | 1114.62 | 1119.83 | 377896.0 |
| 2008-09-17 15:00:00 | ES | Futures | 1119.83 | 1130.24 | 1116.99 | 1121.25 | 338016.0 |
| 2008-09-17 15:30:00 | ES | Futures | 1121.01 | 1121.25 | 1095.21 | 1097.58 | 478452.0 |
| 2008-09-17 16:00:00 | ES | Futures | 1097.82 | 1102.55 | 1097.58 | 1101.37 | 174712.0 |
| 2008-09-17 16:30:00 | ES | Futures | 1104.68 | 1109.89 | 1102.31 | 1103.02 | 26301.0 |
| 2008-09-17 17:00:00 | ES | Futures | 1103.02 | 1105.15 | 1100.89 | 1101.37 | 8225.0 |
| 2008-09-17 18:00:00 | ES | Futures | 1101.37 | 1105.15 | 1101.37 | 1102.31 | 13144.0 |
| 2008-09-17 18:30:00 | ES | Futures | 1102.55 | 1102.79 | 1100.89 | 1102.08 | 3484.0 |
| 2008-09-17 19:00:00 | ES | Futures | 1102.31 | 1103.26 | 1101.13 | 1101.6 | 3008.0 |
| 2008-09-17 19:30:00 | ES | Futures | 1101.37 | 1103.73 | 1100.89 | 1102.79 | 5379.0 |
| 2008-09-17 20:00:00 | ES | Futures | 1103.02 | 1104.92 | 1102.55 | 1103.5 | 7381.0 |
| 2008-09-17 20:30:00 | ES | Futures | 1103.73 | 1106.1 | 1102.55 | 1105.63 | 7186.0 |
| 2008-09-17 21:00:00 | ES | Futures | 1105.86 | 1106.57 | 1105.15 | 1105.86 | 3974.0 |
| 2008-09-17 21:30:00 | ES | Futures | 1105.63 | 1106.57 | 1105.15 | 1106.1 | 2402.0 |
| 2008-09-17 22:00:00 | ES | Futures | 1106.1 | 1106.1 | 1102.79 | 1103.02 | 2839.0 |
| 2008-09-17 22:30:00 | ES | Futures | 1103.02 | 1103.26 | 1101.84 | 1103.02 | 3121.0 |
| 2008-09-17 23:00:00 | ES | Futures | 1103.02 | 1104.44 | 1102.79 | 1104.44 | 1753.0 |
| 2008-09-17 23:30:00 | ES | Futures | 1104.44 | 1104.68 | 1102.31 | 1102.79 | 2505.0 |
| 2008-09-17 00:00:00 | NQ | Futures | 1969.14 | 1970.27 | 1966.6 | 1968.58 | 30.0 |
| 2008-09-17 00:30:00 | NQ | Futures | 1966.6 | 1969.43 | 1964.33 | 1966.6 | 104.0 |
| 2008-09-17 01:00:00 | NQ | Futures | 1966.6 | 1967.16 | 1961.22 | 1962.92 | 376.0 |
> showing 50 of 2,337 rows — these rows as CSV