PREVIEW / futures_30min / 2010-10-12
file: by_date/futures_30min/2010/2010-10-12.parquet size: 76 KB rows: 2,662
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-10-12 00:00:00 | ES | Futures | 1137.5 | 1140.21 | 1137.01 | 1139.47 | 11376.0 |
| 2010-10-12 00:30:00 | ES | Futures | 1139.47 | 1139.72 | 1137.75 | 1137.99 | 3089.0 |
| 2010-10-12 01:00:00 | ES | Futures | 1137.99 | 1138.98 | 1137.5 | 1138.24 | 2818.0 |
| 2010-10-12 01:30:00 | ES | Futures | 1137.99 | 1138.49 | 1137.5 | 1137.75 | 5261.0 |
| 2010-10-12 02:00:00 | ES | Futures | 1137.99 | 1140.21 | 1137.5 | 1138.98 | 9690.0 |
| 2010-10-12 02:30:00 | ES | Futures | 1138.98 | 1139.47 | 1138.49 | 1139.23 | 4967.0 |
| 2010-10-12 03:00:00 | ES | Futures | 1139.47 | 1139.96 | 1137.5 | 1139.47 | 20125.0 |
| 2010-10-12 03:30:00 | ES | Futures | 1139.23 | 1140.21 | 1137.01 | 1137.5 | 17226.0 |
| 2010-10-12 04:00:00 | ES | Futures | 1137.5 | 1137.75 | 1135.53 | 1136.27 | 21810.0 |
| 2010-10-12 04:30:00 | ES | Futures | 1136.27 | 1137.01 | 1135.77 | 1137.01 | 13511.0 |
| 2010-10-12 05:00:00 | ES | Futures | 1136.76 | 1137.99 | 1136.27 | 1137.5 | 12430.0 |
| 2010-10-12 05:30:00 | ES | Futures | 1137.5 | 1139.72 | 1137.5 | 1138.98 | 12217.0 |
| 2010-10-12 06:00:00 | ES | Futures | 1138.98 | 1139.23 | 1137.25 | 1138.98 | 8845.0 |
| 2010-10-12 06:30:00 | ES | Futures | 1138.98 | 1139.47 | 1138.49 | 1139.23 | 5882.0 |
| 2010-10-12 07:00:00 | ES | Futures | 1138.98 | 1139.72 | 1138.73 | 1139.47 | 7222.0 |
| 2010-10-12 07:30:00 | ES | Futures | 1139.47 | 1142.18 | 1138.98 | 1141.44 | 22670.0 |
| 2010-10-12 08:00:00 | ES | Futures | 1141.44 | 1142.18 | 1139.23 | 1139.96 | 30169.0 |
| 2010-10-12 08:30:00 | ES | Futures | 1139.96 | 1143.17 | 1139.72 | 1142.68 | 26912.0 |
| 2010-10-12 09:00:00 | ES | Futures | 1142.92 | 1143.17 | 1141.44 | 1141.94 | 20627.0 |
| 2010-10-12 09:30:00 | ES | Futures | 1141.94 | 1142.43 | 1135.53 | 1137.75 | 219799.0 |
| 2010-10-12 10:00:00 | ES | Futures | 1137.99 | 1141.44 | 1137.01 | 1139.96 | 167884.0 |
| 2010-10-12 10:30:00 | ES | Futures | 1139.96 | 1144.4 | 1139.47 | 1142.92 | 157115.0 |
| 2010-10-12 11:00:00 | ES | Futures | 1143.17 | 1144.65 | 1142.68 | 1143.91 | 84983.0 |
| 2010-10-12 11:30:00 | ES | Futures | 1143.91 | 1145.14 | 1142.43 | 1143.66 | 84853.0 |
| 2010-10-12 12:00:00 | ES | Futures | 1143.66 | 1145.14 | 1142.68 | 1142.68 | 63458.0 |
| 2010-10-12 12:30:00 | ES | Futures | 1142.92 | 1143.17 | 1142.18 | 1142.68 | 29292.0 |
| 2010-10-12 13:00:00 | ES | Futures | 1142.43 | 1143.66 | 1141.94 | 1143.17 | 28574.0 |
| 2010-10-12 13:30:00 | ES | Futures | 1143.17 | 1143.66 | 1142.92 | 1143.42 | 22457.0 |
| 2010-10-12 14:00:00 | ES | Futures | 1143.42 | 1149.33 | 1141.94 | 1146.87 | 228279.0 |
| 2010-10-12 14:30:00 | ES | Futures | 1146.62 | 1147.85 | 1143.91 | 1147.36 | 107477.0 |
| 2010-10-12 15:00:00 | ES | Futures | 1147.61 | 1152.54 | 1145.39 | 1152.29 | 156202.0 |
| 2010-10-12 15:30:00 | ES | Futures | 1152.54 | 1152.54 | 1149.08 | 1149.33 | 159242.0 |
| 2010-10-12 16:00:00 | ES | Futures | 1149.33 | 1149.58 | 1147.61 | 1148.1 | 87710.0 |
| 2010-10-12 16:30:00 | ES | Futures | 1148.84 | 1150.56 | 1148.35 | 1149.58 | 8155.0 |
| 2010-10-12 17:00:00 | ES | Futures | 1149.58 | 1150.07 | 1149.08 | 1150.07 | 2827.0 |
| 2010-10-12 18:00:00 | ES | Futures | 1150.07 | 1150.07 | 1148.59 | 1148.84 | 2740.0 |
| 2010-10-12 18:30:00 | ES | Futures | 1149.08 | 1149.58 | 1148.84 | 1149.33 | 637.0 |
| 2010-10-12 19:00:00 | ES | Futures | 1149.58 | 1150.32 | 1149.33 | 1150.07 | 1132.0 |
| 2010-10-12 19:30:00 | ES | Futures | 1150.32 | 1150.32 | 1148.84 | 1149.58 | 3257.0 |
| 2010-10-12 20:00:00 | ES | Futures | 1149.58 | 1149.82 | 1147.85 | 1148.35 | 5364.0 |
| 2010-10-12 20:30:00 | ES | Futures | 1148.59 | 1149.58 | 1148.35 | 1149.58 | 3872.0 |
| 2010-10-12 21:00:00 | ES | Futures | 1149.33 | 1151.8 | 1149.33 | 1151.3 | 5363.0 |
| 2010-10-12 21:30:00 | ES | Futures | 1151.3 | 1152.78 | 1151.06 | 1151.06 | 4904.0 |
| 2010-10-12 22:00:00 | ES | Futures | 1151.06 | 1151.8 | 1150.81 | 1151.55 | 2131.0 |
| 2010-10-12 22:30:00 | ES | Futures | 1151.3 | 1151.55 | 1150.56 | 1151.3 | 1947.0 |
| 2010-10-12 23:00:00 | ES | Futures | 1151.3 | 1151.55 | 1150.81 | 1151.3 | 1200.0 |
| 2010-10-12 23:30:00 | ES | Futures | 1151.06 | 1151.3 | 1148.84 | 1149.33 | 4506.0 |
| 2010-10-12 00:00:00 | NQ | Futures | 2308.7 | 2312.15 | 2307.56 | 2310.43 | 749.0 |
| 2010-10-12 00:30:00 | NQ | Futures | 2310.71 | 2311.0 | 2307.84 | 2309.28 | 188.0 |
| 2010-10-12 01:00:00 | NQ | Futures | 2309.28 | 2310.14 | 2308.99 | 2308.99 | 148.0 |
> showing 50 of 2,662 rows — these rows as CSV