PREVIEW / futures_30min / 2010-10-06
file: by_date/futures_30min/2010/2010-10-06.parquet size: 72 KB rows: 2,649
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-06 00:00:00 | ES | Futures | 1140.21 | 1140.7 | 1139.72 | 1140.21 | 1467.0 |
| 2010-10-06 00:30:00 | ES | Futures | 1140.21 | 1140.7 | 1139.96 | 1140.21 | 1118.0 |
| 2010-10-06 01:00:00 | ES | Futures | 1139.96 | 1140.7 | 1139.72 | 1140.21 | 1771.0 |
| 2010-10-06 01:30:00 | ES | Futures | 1140.46 | 1140.46 | 1139.72 | 1139.72 | 952.0 |
| 2010-10-06 02:00:00 | ES | Futures | 1139.72 | 1140.46 | 1139.23 | 1140.21 | 4421.0 |
| 2010-10-06 02:30:00 | ES | Futures | 1140.46 | 1140.95 | 1139.47 | 1140.46 | 5463.0 |
| 2010-10-06 03:00:00 | ES | Futures | 1140.46 | 1141.94 | 1139.96 | 1140.95 | 18086.0 |
| 2010-10-06 03:30:00 | ES | Futures | 1140.95 | 1141.94 | 1140.7 | 1141.2 | 14315.0 |
| 2010-10-06 04:00:00 | ES | Futures | 1141.2 | 1142.68 | 1140.46 | 1142.43 | 13023.0 |
| 2010-10-06 04:30:00 | ES | Futures | 1142.18 | 1142.68 | 1141.94 | 1142.43 | 11090.0 |
| 2010-10-06 05:00:00 | ES | Futures | 1142.43 | 1143.42 | 1142.18 | 1142.92 | 10572.0 |
| 2010-10-06 05:30:00 | ES | Futures | 1142.92 | 1143.66 | 1142.18 | 1143.17 | 10922.0 |
| 2010-10-06 06:00:00 | ES | Futures | 1143.17 | 1143.66 | 1141.94 | 1142.18 | 9554.0 |
| 2010-10-06 06:30:00 | ES | Futures | 1142.43 | 1142.68 | 1140.95 | 1141.44 | 7989.0 |
| 2010-10-06 07:00:00 | ES | Futures | 1141.69 | 1141.94 | 1139.23 | 1140.21 | 22377.0 |
| 2010-10-06 07:30:00 | ES | Futures | 1140.21 | 1143.17 | 1139.96 | 1143.17 | 17678.0 |
| 2010-10-06 08:00:00 | ES | Futures | 1142.92 | 1143.66 | 1138.49 | 1138.98 | 65373.0 |
| 2010-10-06 08:30:00 | ES | Futures | 1139.23 | 1139.47 | 1137.01 | 1138.24 | 39728.0 |
| 2010-10-06 09:00:00 | ES | Futures | 1138.24 | 1140.21 | 1138.24 | 1139.47 | 32184.0 |
| 2010-10-06 09:30:00 | ES | Futures | 1139.23 | 1141.94 | 1138.49 | 1140.46 | 207585.0 |
| 2010-10-06 10:00:00 | ES | Futures | 1140.46 | 1142.43 | 1138.49 | 1139.72 | 150636.0 |
| 2010-10-06 10:30:00 | ES | Futures | 1139.72 | 1140.7 | 1137.99 | 1139.23 | 142868.0 |
| 2010-10-06 11:00:00 | ES | Futures | 1139.47 | 1140.21 | 1137.75 | 1139.72 | 97905.0 |
| 2010-10-06 11:30:00 | ES | Futures | 1139.96 | 1141.69 | 1139.72 | 1140.21 | 76125.0 |
| 2010-10-06 12:00:00 | ES | Futures | 1140.46 | 1141.2 | 1137.99 | 1138.24 | 74570.0 |
| 2010-10-06 12:30:00 | ES | Futures | 1137.99 | 1139.23 | 1136.76 | 1137.25 | 77678.0 |
| 2010-10-06 13:00:00 | ES | Futures | 1137.25 | 1137.25 | 1134.79 | 1136.27 | 110706.0 |
| 2010-10-06 13:30:00 | ES | Futures | 1136.02 | 1137.5 | 1135.28 | 1137.5 | 48955.0 |
| 2010-10-06 14:00:00 | ES | Futures | 1137.5 | 1137.99 | 1135.28 | 1137.25 | 65969.0 |
| 2010-10-06 14:30:00 | ES | Futures | 1137.5 | 1138.49 | 1136.51 | 1137.75 | 75802.0 |
| 2010-10-06 15:00:00 | ES | Futures | 1137.75 | 1138.24 | 1136.02 | 1137.25 | 53772.0 |
| 2010-10-06 15:30:00 | ES | Futures | 1137.5 | 1139.72 | 1136.02 | 1139.23 | 127112.0 |
| 2010-10-06 16:00:00 | ES | Futures | 1139.23 | 1140.21 | 1139.23 | 1139.72 | 82679.0 |
| 2010-10-06 16:30:00 | ES | Futures | 1139.47 | 1140.7 | 1139.47 | 1139.96 | 6336.0 |
| 2010-10-06 17:00:00 | ES | Futures | 1140.21 | 1140.46 | 1137.99 | 1138.49 | 3533.0 |
| 2010-10-06 18:00:00 | ES | Futures | 1138.49 | 1139.23 | 1138.49 | 1138.98 | 751.0 |
| 2010-10-06 18:30:00 | ES | Futures | 1138.98 | 1138.98 | 1138.24 | 1138.49 | 556.0 |
| 2010-10-06 19:00:00 | ES | Futures | 1138.73 | 1139.47 | 1138.24 | 1138.24 | 1207.0 |
| 2010-10-06 19:30:00 | ES | Futures | 1138.49 | 1138.73 | 1138.24 | 1138.73 | 551.0 |
| 2010-10-06 20:00:00 | ES | Futures | 1138.49 | 1139.47 | 1138.49 | 1139.47 | 1065.0 |
| 2010-10-06 20:30:00 | ES | Futures | 1139.47 | 1140.7 | 1139.23 | 1139.96 | 4577.0 |
| 2010-10-06 21:00:00 | ES | Futures | 1139.96 | 1140.46 | 1139.23 | 1139.72 | 1580.0 |
| 2010-10-06 21:30:00 | ES | Futures | 1139.96 | 1140.21 | 1138.98 | 1139.23 | 1937.0 |
| 2010-10-06 22:00:00 | ES | Futures | 1138.98 | 1139.72 | 1138.73 | 1139.47 | 1370.0 |
| 2010-10-06 22:30:00 | ES | Futures | 1139.47 | 1139.96 | 1139.23 | 1139.47 | 1145.0 |
| 2010-10-06 23:00:00 | ES | Futures | 1139.47 | 1139.72 | 1138.98 | 1139.23 | 751.0 |
| 2010-10-06 23:30:00 | ES | Futures | 1138.98 | 1139.47 | 1138.49 | 1138.73 | 944.0 |
| 2010-10-06 00:00:00 | NQ | Futures | 2319.89 | 2320.75 | 2317.31 | 2319.32 | 336.0 |
| 2010-10-06 00:30:00 | NQ | Futures | 2319.32 | 2319.32 | 2318.17 | 2318.75 | 310.0 |
| 2010-10-06 01:00:00 | NQ | Futures | 2318.75 | 2320.47 | 2318.46 | 2319.03 | 195.0 |
> showing 50 of 2,649 rows — these rows as CSV