PREVIEW / futures_30min / 2010-09-30
file: by_date/futures_30min/2010/2010-09-30.parquet size: 73 KB rows: 2,609
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-09-30 00:00:00 | ES | Futures | 1122.96 | 1122.96 | 1121.73 | 1121.97 | 1562.0 |
| 2010-09-30 00:30:00 | ES | Futures | 1122.22 | 1122.71 | 1121.48 | 1122.71 | 1066.0 |
| 2010-09-30 01:00:00 | ES | Futures | 1122.71 | 1122.71 | 1121.23 | 1121.23 | 2009.0 |
| 2010-09-30 01:30:00 | ES | Futures | 1121.48 | 1121.48 | 1120.25 | 1120.99 | 7316.0 |
| 2010-09-30 02:00:00 | ES | Futures | 1121.23 | 1121.23 | 1118.27 | 1119.75 | 15672.0 |
| 2010-09-30 02:30:00 | ES | Futures | 1120.0 | 1122.46 | 1119.26 | 1121.73 | 8606.0 |
| 2010-09-30 03:00:00 | ES | Futures | 1121.97 | 1123.45 | 1120.0 | 1121.73 | 22673.0 |
| 2010-09-30 03:30:00 | ES | Futures | 1121.73 | 1125.18 | 1121.23 | 1124.44 | 17528.0 |
| 2010-09-30 04:00:00 | ES | Futures | 1124.68 | 1124.93 | 1121.97 | 1122.71 | 10960.0 |
| 2010-09-30 04:30:00 | ES | Futures | 1122.71 | 1122.96 | 1120.74 | 1122.22 | 11608.0 |
| 2010-09-30 05:00:00 | ES | Futures | 1122.46 | 1124.44 | 1120.49 | 1124.44 | 9694.0 |
| 2010-09-30 05:30:00 | ES | Futures | 1124.44 | 1124.93 | 1122.46 | 1123.94 | 8580.0 |
| 2010-09-30 06:00:00 | ES | Futures | 1123.7 | 1124.44 | 1123.45 | 1123.7 | 4867.0 |
| 2010-09-30 06:30:00 | ES | Futures | 1123.7 | 1124.19 | 1121.73 | 1122.46 | 7272.0 |
| 2010-09-30 07:00:00 | ES | Futures | 1122.22 | 1122.96 | 1121.73 | 1122.71 | 3656.0 |
| 2010-09-30 07:30:00 | ES | Futures | 1122.46 | 1122.96 | 1121.97 | 1122.46 | 4424.0 |
| 2010-09-30 08:00:00 | ES | Futures | 1122.46 | 1123.7 | 1121.73 | 1121.73 | 21945.0 |
| 2010-09-30 08:30:00 | ES | Futures | 1121.97 | 1128.63 | 1121.97 | 1127.89 | 89104.0 |
| 2010-09-30 09:00:00 | ES | Futures | 1127.89 | 1131.83 | 1127.89 | 1129.61 | 73119.0 |
| 2010-09-30 09:30:00 | ES | Futures | 1129.61 | 1137.25 | 1129.61 | 1133.31 | 367028.0 |
| 2010-09-30 10:00:00 | ES | Futures | 1133.06 | 1133.56 | 1127.89 | 1129.86 | 234067.0 |
| 2010-09-30 10:30:00 | ES | Futures | 1130.11 | 1131.34 | 1126.16 | 1126.41 | 141783.0 |
| 2010-09-30 11:00:00 | ES | Futures | 1126.41 | 1127.15 | 1117.54 | 1119.01 | 359008.0 |
| 2010-09-30 11:30:00 | ES | Futures | 1119.01 | 1121.48 | 1117.29 | 1119.51 | 201460.0 |
| 2010-09-30 12:00:00 | ES | Futures | 1119.51 | 1119.75 | 1115.32 | 1117.54 | 160742.0 |
| 2010-09-30 12:30:00 | ES | Futures | 1117.78 | 1122.96 | 1117.29 | 1122.22 | 123924.0 |
| 2010-09-30 13:00:00 | ES | Futures | 1122.22 | 1123.7 | 1121.23 | 1123.45 | 67525.0 |
| 2010-09-30 13:30:00 | ES | Futures | 1123.7 | 1123.7 | 1120.99 | 1122.71 | 71679.0 |
| 2010-09-30 14:00:00 | ES | Futures | 1122.71 | 1123.2 | 1119.26 | 1121.97 | 74725.0 |
| 2010-09-30 14:30:00 | ES | Futures | 1121.97 | 1125.67 | 1121.73 | 1123.94 | 101931.0 |
| 2010-09-30 15:00:00 | ES | Futures | 1123.94 | 1124.44 | 1120.74 | 1124.19 | 126744.0 |
| 2010-09-30 15:30:00 | ES | Futures | 1124.44 | 1125.18 | 1120.0 | 1120.49 | 265350.0 |
| 2010-09-30 16:00:00 | ES | Futures | 1120.25 | 1121.97 | 1119.01 | 1119.26 | 174582.0 |
| 2010-09-30 16:30:00 | ES | Futures | 1119.75 | 1120.49 | 1119.26 | 1120.0 | 8969.0 |
| 2010-09-30 17:00:00 | ES | Futures | 1120.0 | 1120.25 | 1119.26 | 1120.0 | 2812.0 |
| 2010-09-30 18:00:00 | ES | Futures | 1120.0 | 1120.49 | 1119.75 | 1120.25 | 1986.0 |
| 2010-09-30 18:30:00 | ES | Futures | 1120.25 | 1120.49 | 1119.51 | 1119.75 | 880.0 |
| 2010-09-30 19:00:00 | ES | Futures | 1120.0 | 1120.49 | 1119.75 | 1120.49 | 609.0 |
| 2010-09-30 19:30:00 | ES | Futures | 1120.49 | 1121.73 | 1120.0 | 1121.48 | 2473.0 |
| 2010-09-30 20:00:00 | ES | Futures | 1121.73 | 1123.45 | 1121.23 | 1122.71 | 4903.0 |
| 2010-09-30 20:30:00 | ES | Futures | 1122.96 | 1123.94 | 1122.46 | 1123.94 | 3728.0 |
| 2010-09-30 21:00:00 | ES | Futures | 1123.94 | 1124.93 | 1123.45 | 1124.19 | 8983.0 |
| 2010-09-30 21:30:00 | ES | Futures | 1124.19 | 1124.44 | 1123.2 | 1124.19 | 1841.0 |
| 2010-09-30 22:00:00 | ES | Futures | 1124.44 | 1124.93 | 1124.19 | 1124.93 | 752.0 |
| 2010-09-30 22:30:00 | ES | Futures | 1124.93 | 1125.18 | 1123.94 | 1124.44 | 1460.0 |
| 2010-09-30 23:00:00 | ES | Futures | 1124.44 | 1124.44 | 1123.45 | 1123.94 | 515.0 |
| 2010-09-30 23:30:00 | ES | Futures | 1123.94 | 1124.19 | 1121.73 | 1121.97 | 2208.0 |
| 2010-09-30 00:00:00 | NQ | Futures | 2301.24 | 2301.82 | 2299.81 | 2300.38 | 136.0 |
| 2010-09-30 00:30:00 | NQ | Futures | 2300.1 | 2301.24 | 2299.81 | 2300.96 | 49.0 |
| 2010-09-30 01:00:00 | NQ | Futures | 2300.67 | 2301.24 | 2298.95 | 2299.52 | 132.0 |
> showing 50 of 2,609 rows — these rows as CSV