PREVIEW / futures_30min / 2010-11-04
file: by_date/futures_30min/2010/2010-11-04.parquet size: 76 KB rows: 2,689
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-04 00:00:00 | ES | Futures | 1179.89 | 1180.63 | 1179.15 | 1179.4 | 2841.0 |
| 2010-11-04 00:30:00 | ES | Futures | 1179.65 | 1180.39 | 1179.15 | 1179.4 | 2221.0 |
| 2010-11-04 01:00:00 | ES | Futures | 1179.4 | 1179.89 | 1178.42 | 1178.66 | 3868.0 |
| 2010-11-04 01:30:00 | ES | Futures | 1178.66 | 1179.4 | 1178.42 | 1179.4 | 1243.0 |
| 2010-11-04 02:00:00 | ES | Futures | 1179.15 | 1179.65 | 1178.91 | 1179.65 | 1133.0 |
| 2010-11-04 02:30:00 | ES | Futures | 1179.65 | 1180.14 | 1179.4 | 1180.14 | 1697.0 |
| 2010-11-04 03:00:00 | ES | Futures | 1180.14 | 1181.13 | 1179.4 | 1180.88 | 11209.0 |
| 2010-11-04 03:30:00 | ES | Futures | 1180.88 | 1181.62 | 1180.39 | 1181.37 | 6845.0 |
| 2010-11-04 04:00:00 | ES | Futures | 1181.37 | 1187.04 | 1181.37 | 1187.04 | 52480.0 |
| 2010-11-04 04:30:00 | ES | Futures | 1186.8 | 1187.29 | 1185.81 | 1186.8 | 23135.0 |
| 2010-11-04 05:00:00 | ES | Futures | 1187.04 | 1188.03 | 1186.3 | 1187.78 | 19628.0 |
| 2010-11-04 05:30:00 | ES | Futures | 1187.78 | 1188.27 | 1187.29 | 1187.29 | 12971.0 |
| 2010-11-04 06:00:00 | ES | Futures | 1187.29 | 1188.77 | 1187.04 | 1188.52 | 17346.0 |
| 2010-11-04 06:30:00 | ES | Futures | 1188.27 | 1188.77 | 1187.29 | 1187.78 | 8774.0 |
| 2010-11-04 07:00:00 | ES | Futures | 1187.78 | 1188.52 | 1187.04 | 1188.03 | 15977.0 |
| 2010-11-04 07:30:00 | ES | Futures | 1188.03 | 1188.52 | 1187.04 | 1188.27 | 23985.0 |
| 2010-11-04 08:00:00 | ES | Futures | 1188.52 | 1190.74 | 1187.78 | 1190.49 | 44876.0 |
| 2010-11-04 08:30:00 | ES | Futures | 1190.49 | 1192.22 | 1188.77 | 1191.23 | 68895.0 |
| 2010-11-04 09:00:00 | ES | Futures | 1191.23 | 1191.97 | 1190.0 | 1190.74 | 38550.0 |
| 2010-11-04 09:30:00 | ES | Futures | 1190.74 | 1193.45 | 1189.51 | 1192.22 | 227927.0 |
| 2010-11-04 10:00:00 | ES | Futures | 1192.22 | 1194.68 | 1189.75 | 1194.19 | 195722.0 |
| 2010-11-04 10:30:00 | ES | Futures | 1194.19 | 1196.65 | 1192.96 | 1195.92 | 166638.0 |
| 2010-11-04 11:00:00 | ES | Futures | 1196.16 | 1197.89 | 1194.68 | 1195.42 | 216658.0 |
| 2010-11-04 11:30:00 | ES | Futures | 1195.42 | 1196.41 | 1194.44 | 1194.93 | 78984.0 |
| 2010-11-04 12:00:00 | ES | Futures | 1194.93 | 1196.41 | 1193.94 | 1195.67 | 86104.0 |
| 2010-11-04 12:30:00 | ES | Futures | 1195.42 | 1196.9 | 1195.18 | 1196.41 | 78959.0 |
| 2010-11-04 13:00:00 | ES | Futures | 1196.41 | 1197.15 | 1195.92 | 1196.9 | 50984.0 |
| 2010-11-04 13:30:00 | ES | Futures | 1196.9 | 1197.39 | 1194.93 | 1195.18 | 77279.0 |
| 2010-11-04 14:00:00 | ES | Futures | 1195.42 | 1197.15 | 1194.44 | 1196.16 | 65902.0 |
| 2010-11-04 14:30:00 | ES | Futures | 1196.41 | 1198.38 | 1196.16 | 1196.65 | 88120.0 |
| 2010-11-04 15:00:00 | ES | Futures | 1196.65 | 1200.11 | 1196.41 | 1200.11 | 146779.0 |
| 2010-11-04 15:30:00 | ES | Futures | 1200.11 | 1201.58 | 1197.89 | 1200.6 | 304720.0 |
| 2010-11-04 16:00:00 | ES | Futures | 1200.6 | 1201.58 | 1200.35 | 1201.34 | 105886.0 |
| 2010-11-04 16:30:00 | ES | Futures | 1201.09 | 1201.34 | 1199.86 | 1200.35 | 9637.0 |
| 2010-11-04 17:00:00 | ES | Futures | 1200.35 | 1200.85 | 1199.86 | 1200.35 | 3201.0 |
| 2010-11-04 18:00:00 | ES | Futures | 1200.35 | 1200.85 | 1200.11 | 1200.6 | 1708.0 |
| 2010-11-04 18:30:00 | ES | Futures | 1200.6 | 1200.85 | 1200.11 | 1200.11 | 1287.0 |
| 2010-11-04 19:00:00 | ES | Futures | 1200.11 | 1200.85 | 1200.11 | 1200.6 | 1109.0 |
| 2010-11-04 19:30:00 | ES | Futures | 1200.6 | 1200.85 | 1200.11 | 1200.85 | 1825.0 |
| 2010-11-04 20:00:00 | ES | Futures | 1200.6 | 1200.85 | 1200.11 | 1200.35 | 2482.0 |
| 2010-11-04 20:30:00 | ES | Futures | 1200.35 | 1200.6 | 1199.37 | 1199.61 | 3792.0 |
| 2010-11-04 21:00:00 | ES | Futures | 1199.61 | 1200.35 | 1199.61 | 1200.11 | 1001.0 |
| 2010-11-04 21:30:00 | ES | Futures | 1200.35 | 1200.6 | 1199.37 | 1199.86 | 2988.0 |
| 2010-11-04 22:00:00 | ES | Futures | 1199.86 | 1200.35 | 1199.61 | 1200.11 | 1929.0 |
| 2010-11-04 22:30:00 | ES | Futures | 1200.11 | 1200.35 | 1199.37 | 1199.61 | 1537.0 |
| 2010-11-04 23:00:00 | ES | Futures | 1199.61 | 1200.11 | 1199.37 | 1199.61 | 1297.0 |
| 2010-11-04 23:30:00 | ES | Futures | 1199.61 | 1199.86 | 1199.12 | 1199.61 | 2616.0 |
| 2010-11-04 00:00:00 | NQ | Futures | 2484.29 | 2484.86 | 2483.71 | 2484.29 | 72.0 |
| 2010-11-04 00:30:00 | NQ | Futures | 2484.29 | 2485.44 | 2483.71 | 2483.71 | 119.0 |
| 2010-11-04 01:00:00 | NQ | Futures | 2483.71 | 2484.29 | 2481.99 | 2482.28 | 94.0 |
> showing 50 of 2,689 rows — these rows as CSV