PREVIEW / futures_30min / 2010-10-08
file: by_date/futures_30min/2010/2010-10-08.parquet size: 61 KB rows: 2,073
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-08 00:00:00 | ES | Futures | 1141.94 | 1142.43 | 1141.69 | 1142.18 | 928.0 |
| 2010-10-08 00:30:00 | ES | Futures | 1142.18 | 1142.18 | 1140.95 | 1141.94 | 1480.0 |
| 2010-10-08 01:00:00 | ES | Futures | 1141.94 | 1141.94 | 1141.2 | 1141.2 | 822.0 |
| 2010-10-08 01:30:00 | ES | Futures | 1141.44 | 1141.44 | 1140.21 | 1140.46 | 2398.0 |
| 2010-10-08 02:00:00 | ES | Futures | 1140.7 | 1140.95 | 1139.23 | 1139.72 | 4194.0 |
| 2010-10-08 02:30:00 | ES | Futures | 1139.47 | 1140.46 | 1138.24 | 1138.24 | 6263.0 |
| 2010-10-08 03:00:00 | ES | Futures | 1138.49 | 1139.23 | 1137.25 | 1137.99 | 14585.0 |
| 2010-10-08 03:30:00 | ES | Futures | 1137.99 | 1139.72 | 1137.25 | 1138.49 | 10579.0 |
| 2010-10-08 04:00:00 | ES | Futures | 1138.24 | 1139.47 | 1137.25 | 1138.73 | 9120.0 |
| 2010-10-08 04:30:00 | ES | Futures | 1138.49 | 1138.98 | 1136.02 | 1136.51 | 11388.0 |
| 2010-10-08 05:00:00 | ES | Futures | 1136.51 | 1137.99 | 1136.02 | 1137.25 | 7340.0 |
| 2010-10-08 05:30:00 | ES | Futures | 1137.5 | 1137.75 | 1136.51 | 1137.25 | 3135.0 |
| 2010-10-08 06:00:00 | ES | Futures | 1137.25 | 1137.75 | 1134.79 | 1135.77 | 16350.0 |
| 2010-10-08 06:30:00 | ES | Futures | 1135.53 | 1136.27 | 1135.04 | 1135.53 | 11500.0 |
| 2010-10-08 07:00:00 | ES | Futures | 1135.28 | 1136.27 | 1134.3 | 1136.27 | 13443.0 |
| 2010-10-08 07:30:00 | ES | Futures | 1136.27 | 1136.27 | 1134.3 | 1135.53 | 18878.0 |
| 2010-10-08 08:00:00 | ES | Futures | 1135.28 | 1137.75 | 1134.79 | 1136.76 | 36089.0 |
| 2010-10-08 08:30:00 | ES | Futures | 1136.51 | 1142.43 | 1129.37 | 1136.02 | 216667.0 |
| 2010-10-08 09:00:00 | ES | Futures | 1136.27 | 1140.21 | 1134.3 | 1139.72 | 69969.0 |
| 2010-10-08 09:30:00 | ES | Futures | 1139.72 | 1141.2 | 1136.27 | 1139.72 | 191821.0 |
| 2010-10-08 10:00:00 | ES | Futures | 1139.72 | 1140.95 | 1135.28 | 1136.02 | 170564.0 |
| 2010-10-08 10:30:00 | ES | Futures | 1135.77 | 1140.46 | 1135.28 | 1139.96 | 115504.0 |
| 2010-10-08 11:00:00 | ES | Futures | 1140.21 | 1143.91 | 1139.96 | 1143.17 | 146092.0 |
| 2010-10-08 11:30:00 | ES | Futures | 1143.42 | 1145.14 | 1142.68 | 1143.91 | 111697.0 |
| 2010-10-08 12:00:00 | ES | Futures | 1143.91 | 1144.4 | 1142.43 | 1142.92 | 47037.0 |
| 2010-10-08 12:30:00 | ES | Futures | 1142.92 | 1146.13 | 1142.68 | 1145.39 | 73686.0 |
| 2010-10-08 13:00:00 | ES | Futures | 1145.39 | 1145.63 | 1143.66 | 1144.4 | 49614.0 |
| 2010-10-08 13:30:00 | ES | Futures | 1144.65 | 1144.65 | 1141.94 | 1142.92 | 68297.0 |
| 2010-10-08 14:00:00 | ES | Futures | 1142.92 | 1144.65 | 1141.2 | 1144.15 | 64045.0 |
| 2010-10-08 14:30:00 | ES | Futures | 1143.91 | 1145.39 | 1143.42 | 1143.66 | 68110.0 |
| 2010-10-08 15:00:00 | ES | Futures | 1143.66 | 1146.37 | 1143.42 | 1144.65 | 63126.0 |
| 2010-10-08 15:30:00 | ES | Futures | 1144.89 | 1147.61 | 1144.15 | 1144.4 | 195047.0 |
| 2010-10-08 16:00:00 | ES | Futures | 1144.4 | 1145.39 | 1143.66 | 1144.15 | 113658.0 |
| 2010-10-08 00:00:00 | NQ | Futures | 2316.16 | 2316.45 | 2315.3 | 2316.16 | 143.0 |
| 2010-10-08 00:30:00 | NQ | Futures | 2316.16 | 2316.16 | 2314.44 | 2315.3 | 46.0 |
| 2010-10-08 01:00:00 | NQ | Futures | 2315.02 | 2315.02 | 2314.16 | 2314.73 | 15.0 |
| 2010-10-08 01:30:00 | NQ | Futures | 2314.16 | 2314.16 | 2311.0 | 2311.29 | 197.0 |
| 2010-10-08 02:00:00 | NQ | Futures | 2311.0 | 2311.57 | 2307.27 | 2308.42 | 380.0 |
| 2010-10-08 02:30:00 | NQ | Futures | 2308.7 | 2310.43 | 2305.84 | 2306.41 | 229.0 |
| 2010-10-08 03:00:00 | NQ | Futures | 2306.12 | 2308.7 | 2304.4 | 2305.55 | 755.0 |
| 2010-10-08 03:30:00 | NQ | Futures | 2305.84 | 2309.85 | 2304.97 | 2307.56 | 770.0 |
| 2010-10-08 04:00:00 | NQ | Futures | 2307.56 | 2308.99 | 2304.97 | 2306.41 | 549.0 |
| 2010-10-08 04:30:00 | NQ | Futures | 2306.7 | 2307.27 | 2300.67 | 2301.53 | 1377.0 |
| 2010-10-08 05:00:00 | NQ | Futures | 2301.82 | 2304.97 | 2301.53 | 2304.4 | 477.0 |
| 2010-10-08 05:30:00 | NQ | Futures | 2304.4 | 2304.4 | 2302.11 | 2303.83 | 130.0 |
| 2010-10-08 06:00:00 | NQ | Futures | 2303.83 | 2304.69 | 2301.24 | 2302.97 | 1088.0 |
| 2010-10-08 06:30:00 | NQ | Futures | 2302.97 | 2304.69 | 2302.39 | 2302.68 | 810.0 |
| 2010-10-08 07:00:00 | NQ | Futures | 2302.68 | 2304.11 | 2300.1 | 2303.54 | 974.0 |
| 2010-10-08 07:30:00 | NQ | Futures | 2303.83 | 2304.11 | 2300.67 | 2302.11 | 727.0 |
| 2010-10-08 08:00:00 | NQ | Futures | 2302.39 | 2305.55 | 2301.24 | 2305.26 | 2808.0 |
> showing 50 of 2,073 rows — these rows as CSV