PREVIEW / futures_30min / 2010-11-22
file: by_date/futures_30min/2010/2010-11-22.parquet size: 73 KB rows: 2,568
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-11-22 00:00:00 | ES | Futures | 1187.54 | 1187.54 | 1186.55 | 1186.8 | 1815.0 |
| 2010-11-22 00:30:00 | ES | Futures | 1186.8 | 1187.29 | 1186.3 | 1186.55 | 1640.0 |
| 2010-11-22 01:00:00 | ES | Futures | 1186.3 | 1188.03 | 1186.3 | 1187.54 | 2566.0 |
| 2010-11-22 01:30:00 | ES | Futures | 1187.54 | 1188.27 | 1187.29 | 1187.54 | 1768.0 |
| 2010-11-22 02:00:00 | ES | Futures | 1187.54 | 1188.52 | 1186.55 | 1188.03 | 10216.0 |
| 2010-11-22 02:30:00 | ES | Futures | 1188.03 | 1188.52 | 1186.8 | 1187.54 | 9985.0 |
| 2010-11-22 03:00:00 | ES | Futures | 1187.78 | 1188.77 | 1186.3 | 1186.8 | 17879.0 |
| 2010-11-22 03:30:00 | ES | Futures | 1186.55 | 1187.78 | 1186.3 | 1186.8 | 10499.0 |
| 2010-11-22 04:00:00 | ES | Futures | 1186.8 | 1187.29 | 1186.06 | 1186.3 | 6611.0 |
| 2010-11-22 04:30:00 | ES | Futures | 1186.3 | 1186.55 | 1185.07 | 1185.32 | 9437.0 |
| 2010-11-22 05:00:00 | ES | Futures | 1185.07 | 1186.55 | 1185.07 | 1185.32 | 6956.0 |
| 2010-11-22 05:30:00 | ES | Futures | 1185.32 | 1185.81 | 1184.58 | 1185.07 | 8121.0 |
| 2010-11-22 06:00:00 | ES | Futures | 1185.32 | 1185.56 | 1183.59 | 1184.08 | 13795.0 |
| 2010-11-22 06:30:00 | ES | Futures | 1184.08 | 1184.08 | 1181.37 | 1182.11 | 18664.0 |
| 2010-11-22 07:00:00 | ES | Futures | 1182.11 | 1182.11 | 1178.91 | 1179.65 | 33980.0 |
| 2010-11-22 07:30:00 | ES | Futures | 1179.89 | 1181.13 | 1179.15 | 1180.39 | 19004.0 |
| 2010-11-22 08:00:00 | ES | Futures | 1180.63 | 1180.63 | 1176.44 | 1176.69 | 49830.0 |
| 2010-11-22 08:30:00 | ES | Futures | 1176.94 | 1178.66 | 1175.7 | 1177.18 | 37691.0 |
| 2010-11-22 09:00:00 | ES | Futures | 1177.43 | 1177.68 | 1174.72 | 1175.21 | 40456.0 |
| 2010-11-22 09:30:00 | ES | Futures | 1175.21 | 1180.63 | 1173.73 | 1179.89 | 188989.0 |
| 2010-11-22 10:00:00 | ES | Futures | 1179.89 | 1180.39 | 1175.21 | 1175.21 | 141909.0 |
| 2010-11-22 10:30:00 | ES | Futures | 1175.21 | 1175.7 | 1172.5 | 1173.49 | 218809.0 |
| 2010-11-22 11:00:00 | ES | Futures | 1173.24 | 1174.96 | 1171.51 | 1174.23 | 139830.0 |
| 2010-11-22 11:30:00 | ES | Futures | 1174.47 | 1175.21 | 1173.24 | 1174.23 | 57762.0 |
| 2010-11-22 12:00:00 | ES | Futures | 1174.23 | 1174.47 | 1168.56 | 1168.8 | 150270.0 |
| 2010-11-22 12:30:00 | ES | Futures | 1168.8 | 1169.05 | 1165.85 | 1168.56 | 190130.0 |
| 2010-11-22 13:00:00 | ES | Futures | 1168.8 | 1169.79 | 1167.57 | 1169.3 | 85951.0 |
| 2010-11-22 13:30:00 | ES | Futures | 1169.05 | 1172.5 | 1169.05 | 1172.01 | 92888.0 |
| 2010-11-22 14:00:00 | ES | Futures | 1172.01 | 1174.96 | 1171.51 | 1172.99 | 112834.0 |
| 2010-11-22 14:30:00 | ES | Futures | 1172.99 | 1177.43 | 1172.75 | 1176.94 | 108186.0 |
| 2010-11-22 15:00:00 | ES | Futures | 1177.18 | 1177.92 | 1174.72 | 1175.7 | 89845.0 |
| 2010-11-22 15:30:00 | ES | Futures | 1175.7 | 1180.39 | 1174.72 | 1179.65 | 180037.0 |
| 2010-11-22 16:00:00 | ES | Futures | 1179.65 | 1181.62 | 1179.15 | 1180.39 | 75711.0 |
| 2010-11-22 16:30:00 | ES | Futures | 1180.14 | 1180.39 | 1178.66 | 1179.89 | 7911.0 |
| 2010-11-22 17:00:00 | ES | Futures | 1179.89 | 1180.39 | 1179.15 | 1180.39 | 2522.0 |
| 2010-11-22 18:00:00 | ES | Futures | 1180.14 | 1180.88 | 1179.65 | 1179.89 | 4145.0 |
| 2010-11-22 18:30:00 | ES | Futures | 1179.89 | 1179.89 | 1178.42 | 1178.66 | 2848.0 |
| 2010-11-22 19:00:00 | ES | Futures | 1178.42 | 1179.15 | 1178.17 | 1178.66 | 3519.0 |
| 2010-11-22 19:30:00 | ES | Futures | 1178.66 | 1178.91 | 1177.92 | 1178.17 | 2489.0 |
| 2010-11-22 20:00:00 | ES | Futures | 1178.17 | 1178.66 | 1177.68 | 1178.42 | 2762.0 |
| 2010-11-22 20:30:00 | ES | Futures | 1178.42 | 1178.42 | 1177.18 | 1177.68 | 4327.0 |
| 2010-11-22 21:00:00 | ES | Futures | 1177.68 | 1178.42 | 1177.43 | 1177.92 | 1426.0 |
| 2010-11-22 21:30:00 | ES | Futures | 1177.92 | 1178.17 | 1176.44 | 1176.69 | 3776.0 |
| 2010-11-22 22:00:00 | ES | Futures | 1176.69 | 1176.94 | 1175.95 | 1175.95 | 4275.0 |
| 2010-11-22 22:30:00 | ES | Futures | 1175.95 | 1176.94 | 1175.7 | 1176.2 | 2556.0 |
| 2010-11-22 23:00:00 | ES | Futures | 1176.2 | 1176.69 | 1175.7 | 1175.95 | 2477.0 |
| 2010-11-22 23:30:00 | ES | Futures | 1176.2 | 1176.69 | 1175.7 | 1176.44 | 1977.0 |
| 2010-11-22 00:00:00 | NQ | Futures | 2461.34 | 2462.48 | 2461.05 | 2461.91 | 87.0 |
| 2010-11-22 00:30:00 | NQ | Futures | 2462.2 | 2463.06 | 2461.05 | 2461.62 | 82.0 |
| 2010-11-22 01:00:00 | NQ | Futures | 2461.62 | 2462.77 | 2461.62 | 2462.2 | 59.0 |
> showing 50 of 2,568 rows — these rows as CSV