PREVIEW / futures_30min / 2010-10-07
file: by_date/futures_30min/2010/2010-10-07.parquet size: 73 KB rows: 2,651
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-07 00:00:00 | ES | Futures | 1138.49 | 1138.98 | 1138.24 | 1138.49 | 906.0 |
| 2010-10-07 00:30:00 | ES | Futures | 1138.24 | 1138.73 | 1137.99 | 1138.73 | 1384.0 |
| 2010-10-07 01:00:00 | ES | Futures | 1138.24 | 1138.98 | 1138.24 | 1138.98 | 1421.0 |
| 2010-10-07 01:30:00 | ES | Futures | 1138.73 | 1138.98 | 1138.49 | 1138.73 | 559.0 |
| 2010-10-07 02:00:00 | ES | Futures | 1138.49 | 1139.72 | 1138.49 | 1139.47 | 2281.0 |
| 2010-10-07 02:30:00 | ES | Futures | 1139.47 | 1141.2 | 1139.23 | 1140.95 | 5411.0 |
| 2010-10-07 03:00:00 | ES | Futures | 1140.7 | 1140.95 | 1137.01 | 1137.25 | 18450.0 |
| 2010-10-07 03:30:00 | ES | Futures | 1137.25 | 1139.23 | 1136.27 | 1138.98 | 13772.0 |
| 2010-10-07 04:00:00 | ES | Futures | 1139.23 | 1140.95 | 1138.49 | 1139.23 | 13892.0 |
| 2010-10-07 04:30:00 | ES | Futures | 1139.23 | 1140.46 | 1138.73 | 1138.98 | 6422.0 |
| 2010-10-07 05:00:00 | ES | Futures | 1138.98 | 1140.21 | 1138.73 | 1139.96 | 6783.0 |
| 2010-10-07 05:30:00 | ES | Futures | 1139.72 | 1139.96 | 1137.25 | 1139.47 | 7635.0 |
| 2010-10-07 06:00:00 | ES | Futures | 1139.47 | 1141.2 | 1139.47 | 1140.7 | 8203.0 |
| 2010-10-07 06:30:00 | ES | Futures | 1140.7 | 1141.2 | 1139.96 | 1140.7 | 4639.0 |
| 2010-10-07 07:00:00 | ES | Futures | 1140.7 | 1141.44 | 1140.46 | 1140.95 | 6279.0 |
| 2010-10-07 07:30:00 | ES | Futures | 1140.7 | 1141.44 | 1138.98 | 1139.23 | 15588.0 |
| 2010-10-07 08:00:00 | ES | Futures | 1139.23 | 1140.46 | 1138.49 | 1140.46 | 28072.0 |
| 2010-10-07 08:30:00 | ES | Futures | 1140.46 | 1147.36 | 1139.96 | 1146.13 | 107958.0 |
| 2010-10-07 09:00:00 | ES | Futures | 1145.88 | 1147.11 | 1143.91 | 1143.91 | 47329.0 |
| 2010-10-07 09:30:00 | ES | Futures | 1143.91 | 1144.4 | 1136.27 | 1136.76 | 270624.0 |
| 2010-10-07 10:00:00 | ES | Futures | 1136.76 | 1141.2 | 1135.77 | 1140.95 | 248342.0 |
| 2010-10-07 10:30:00 | ES | Futures | 1141.2 | 1141.69 | 1138.24 | 1138.98 | 152992.0 |
| 2010-10-07 11:00:00 | ES | Futures | 1138.73 | 1138.98 | 1136.51 | 1137.25 | 129020.0 |
| 2010-10-07 11:30:00 | ES | Futures | 1137.25 | 1138.98 | 1136.02 | 1137.25 | 69890.0 |
| 2010-10-07 12:00:00 | ES | Futures | 1137.25 | 1137.75 | 1133.56 | 1134.3 | 106951.0 |
| 2010-10-07 12:30:00 | ES | Futures | 1134.3 | 1134.3 | 1131.09 | 1133.06 | 131487.0 |
| 2010-10-07 13:00:00 | ES | Futures | 1133.06 | 1135.04 | 1132.32 | 1134.3 | 75820.0 |
| 2010-10-07 13:30:00 | ES | Futures | 1134.3 | 1137.25 | 1132.82 | 1136.51 | 76293.0 |
| 2010-10-07 14:00:00 | ES | Futures | 1136.51 | 1138.73 | 1135.53 | 1137.01 | 85480.0 |
| 2010-10-07 14:30:00 | ES | Futures | 1137.25 | 1137.99 | 1136.02 | 1137.75 | 58877.0 |
| 2010-10-07 15:00:00 | ES | Futures | 1137.99 | 1138.49 | 1136.76 | 1137.01 | 53511.0 |
| 2010-10-07 15:30:00 | ES | Futures | 1137.01 | 1139.23 | 1136.02 | 1137.75 | 113805.0 |
| 2010-10-07 16:00:00 | ES | Futures | 1137.75 | 1140.95 | 1137.75 | 1140.46 | 91678.0 |
| 2010-10-07 16:30:00 | ES | Futures | 1140.21 | 1140.46 | 1139.47 | 1139.72 | 3477.0 |
| 2010-10-07 17:00:00 | ES | Futures | 1139.72 | 1140.46 | 1139.23 | 1140.21 | 2609.0 |
| 2010-10-07 18:00:00 | ES | Futures | 1139.96 | 1140.7 | 1139.96 | 1140.46 | 1215.0 |
| 2010-10-07 18:30:00 | ES | Futures | 1140.7 | 1140.7 | 1140.21 | 1140.46 | 399.0 |
| 2010-10-07 19:00:00 | ES | Futures | 1140.46 | 1140.95 | 1139.96 | 1140.7 | 1210.0 |
| 2010-10-07 19:30:00 | ES | Futures | 1140.46 | 1140.95 | 1140.21 | 1140.7 | 1040.0 |
| 2010-10-07 20:00:00 | ES | Futures | 1140.95 | 1141.44 | 1140.46 | 1140.7 | 1776.0 |
| 2010-10-07 20:30:00 | ES | Futures | 1140.95 | 1141.69 | 1140.46 | 1140.95 | 3600.0 |
| 2010-10-07 21:00:00 | ES | Futures | 1140.95 | 1141.69 | 1140.7 | 1140.95 | 2653.0 |
| 2010-10-07 21:30:00 | ES | Futures | 1140.95 | 1141.2 | 1140.21 | 1140.7 | 1963.0 |
| 2010-10-07 22:00:00 | ES | Futures | 1140.46 | 1141.69 | 1140.46 | 1141.69 | 2613.0 |
| 2010-10-07 22:30:00 | ES | Futures | 1141.44 | 1142.92 | 1141.2 | 1142.68 | 3715.0 |
| 2010-10-07 23:00:00 | ES | Futures | 1142.43 | 1143.17 | 1142.18 | 1142.92 | 1781.0 |
| 2010-10-07 23:30:00 | ES | Futures | 1142.92 | 1143.17 | 1141.44 | 1142.18 | 2000.0 |
| 2010-10-07 00:00:00 | NQ | Futures | 2299.24 | 2300.67 | 2299.24 | 2299.81 | 28.0 |
| 2010-10-07 00:30:00 | NQ | Futures | 2299.24 | 2299.81 | 2298.66 | 2298.95 | 34.0 |
| 2010-10-07 01:00:00 | NQ | Futures | 2298.95 | 2299.52 | 2298.66 | 2299.24 | 22.0 |
> showing 50 of 2,651 rows — these rows as CSV