PREVIEW / futures_30min / 2010-11-24
file: by_date/futures_30min/2010/2010-11-24.parquet size: 72 KB rows: 2,471
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-24 00:00:00 | ES | Futures | 1167.32 | 1167.82 | 1167.08 | 1167.32 | 1534.0 |
| 2010-11-24 00:30:00 | ES | Futures | 1167.32 | 1167.57 | 1166.58 | 1166.83 | 1409.0 |
| 2010-11-24 01:00:00 | ES | Futures | 1166.58 | 1167.32 | 1166.34 | 1166.58 | 1318.0 |
| 2010-11-24 01:30:00 | ES | Futures | 1166.58 | 1167.82 | 1165.35 | 1165.35 | 2084.0 |
| 2010-11-24 02:00:00 | ES | Futures | 1165.6 | 1166.34 | 1165.35 | 1165.85 | 6346.0 |
| 2010-11-24 02:30:00 | ES | Futures | 1165.85 | 1166.83 | 1165.6 | 1166.09 | 5974.0 |
| 2010-11-24 03:00:00 | ES | Futures | 1165.85 | 1166.58 | 1164.12 | 1164.61 | 22921.0 |
| 2010-11-24 03:30:00 | ES | Futures | 1164.61 | 1164.86 | 1159.44 | 1159.68 | 31096.0 |
| 2010-11-24 04:00:00 | ES | Futures | 1159.68 | 1162.64 | 1158.94 | 1161.9 | 25889.0 |
| 2010-11-24 04:30:00 | ES | Futures | 1161.9 | 1162.15 | 1159.19 | 1160.18 | 14603.0 |
| 2010-11-24 05:00:00 | ES | Futures | 1159.93 | 1163.38 | 1159.44 | 1163.13 | 14722.0 |
| 2010-11-24 05:30:00 | ES | Futures | 1163.13 | 1164.61 | 1161.9 | 1164.37 | 14163.0 |
| 2010-11-24 06:00:00 | ES | Futures | 1164.37 | 1166.34 | 1164.37 | 1165.85 | 19281.0 |
| 2010-11-24 06:30:00 | ES | Futures | 1166.09 | 1166.83 | 1163.63 | 1163.63 | 20363.0 |
| 2010-11-24 07:00:00 | ES | Futures | 1163.63 | 1166.34 | 1162.39 | 1165.11 | 24330.0 |
| 2010-11-24 07:30:00 | ES | Futures | 1164.86 | 1165.85 | 1163.87 | 1165.11 | 22814.0 |
| 2010-11-24 08:00:00 | ES | Futures | 1165.11 | 1168.06 | 1164.86 | 1167.08 | 23404.0 |
| 2010-11-24 08:30:00 | ES | Futures | 1167.08 | 1172.99 | 1165.35 | 1170.28 | 100628.0 |
| 2010-11-24 09:00:00 | ES | Futures | 1170.28 | 1170.77 | 1169.54 | 1170.04 | 20318.0 |
| 2010-11-24 09:30:00 | ES | Futures | 1170.04 | 1174.72 | 1169.79 | 1173.73 | 250253.0 |
| 2010-11-24 10:00:00 | ES | Futures | 1173.49 | 1177.43 | 1171.27 | 1176.2 | 216710.0 |
| 2010-11-24 10:30:00 | ES | Futures | 1176.2 | 1178.66 | 1175.7 | 1176.94 | 162735.0 |
| 2010-11-24 11:00:00 | ES | Futures | 1177.18 | 1178.42 | 1176.2 | 1176.94 | 93909.0 |
| 2010-11-24 11:30:00 | ES | Futures | 1176.69 | 1177.92 | 1175.7 | 1177.43 | 62863.0 |
| 2010-11-24 12:00:00 | ES | Futures | 1177.18 | 1178.42 | 1176.94 | 1178.17 | 51806.0 |
| 2010-11-24 12:30:00 | ES | Futures | 1178.17 | 1178.91 | 1177.18 | 1178.42 | 39089.0 |
| 2010-11-24 13:00:00 | ES | Futures | 1178.42 | 1179.89 | 1177.68 | 1179.65 | 46541.0 |
| 2010-11-24 13:30:00 | ES | Futures | 1179.65 | 1180.14 | 1178.91 | 1178.91 | 32674.0 |
| 2010-11-24 14:00:00 | ES | Futures | 1179.15 | 1179.4 | 1177.18 | 1178.42 | 35712.0 |
| 2010-11-24 14:30:00 | ES | Futures | 1178.42 | 1179.15 | 1178.17 | 1178.66 | 28733.0 |
| 2010-11-24 15:00:00 | ES | Futures | 1178.66 | 1180.63 | 1178.42 | 1179.65 | 48079.0 |
| 2010-11-24 15:30:00 | ES | Futures | 1179.4 | 1180.63 | 1177.43 | 1179.89 | 163387.0 |
| 2010-11-24 16:00:00 | ES | Futures | 1179.89 | 1180.14 | 1178.66 | 1179.4 | 97365.0 |
| 2010-11-24 16:30:00 | ES | Futures | 1178.91 | 1179.4 | 1178.17 | 1178.42 | 2956.0 |
| 2010-11-24 17:00:00 | ES | Futures | 1178.42 | 1178.91 | 1178.17 | 1178.42 | 552.0 |
| 2010-11-24 18:00:00 | ES | Futures | 1178.66 | 1179.89 | 1178.42 | 1179.15 | 1235.0 |
| 2010-11-24 18:30:00 | ES | Futures | 1179.15 | 1179.4 | 1178.17 | 1179.15 | 1773.0 |
| 2010-11-24 19:00:00 | ES | Futures | 1179.15 | 1179.65 | 1177.92 | 1178.42 | 1701.0 |
| 2010-11-24 19:30:00 | ES | Futures | 1178.17 | 1178.91 | 1177.43 | 1177.92 | 1620.0 |
| 2010-11-24 20:00:00 | ES | Futures | 1177.92 | 1178.17 | 1177.43 | 1177.92 | 1307.0 |
| 2010-11-24 20:30:00 | ES | Futures | 1177.92 | 1177.92 | 1177.43 | 1177.68 | 935.0 |
| 2010-11-24 21:00:00 | ES | Futures | 1177.43 | 1178.17 | 1177.18 | 1177.92 | 1029.0 |
| 2010-11-24 21:30:00 | ES | Futures | 1178.17 | 1178.17 | 1176.94 | 1177.43 | 933.0 |
| 2010-11-24 22:00:00 | ES | Futures | 1177.43 | 1177.68 | 1176.44 | 1176.94 | 833.0 |
| 2010-11-24 22:30:00 | ES | Futures | 1176.94 | 1178.42 | 1175.95 | 1177.92 | 3157.0 |
| 2010-11-24 23:00:00 | ES | Futures | 1177.92 | 1179.65 | 1177.68 | 1178.91 | 1348.0 |
| 2010-11-24 23:30:00 | ES | Futures | 1178.91 | 1179.89 | 1178.17 | 1178.42 | 1166.0 |
| 2010-11-24 00:00:00 | NQ | Futures | 2440.97 | 2441.54 | 2440.11 | 2440.39 | 47.0 |
| 2010-11-24 00:30:00 | NQ | Futures | 2440.39 | 2440.97 | 2440.11 | 2440.11 | 102.0 |
| 2010-11-24 01:00:00 | NQ | Futures | 2439.82 | 2440.97 | 2438.96 | 2439.53 | 83.0 |
> showing 50 of 2,471 rows — these rows as CSV