PREVIEW / futures_30min / 2008-09-24
file: by_date/futures_30min/2008/2008-09-24.parquet size: 68 KB rows: 2,247
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 |
|---|---|---|---|---|---|---|---|
| 2008-09-24 00:00:00 | ES | Futures | 1138.28 | 1138.52 | 1136.86 | 1137.57 | 1958.0 |
| 2008-09-24 00:30:00 | ES | Futures | 1137.57 | 1137.81 | 1135.92 | 1136.63 | 1715.0 |
| 2008-09-24 01:00:00 | ES | Futures | 1136.63 | 1138.05 | 1136.39 | 1137.1 | 1457.0 |
| 2008-09-24 01:30:00 | ES | Futures | 1136.86 | 1137.81 | 1136.63 | 1137.57 | 1604.0 |
| 2008-09-24 02:00:00 | ES | Futures | 1137.81 | 1139.23 | 1136.15 | 1136.63 | 5314.0 |
| 2008-09-24 02:30:00 | ES | Futures | 1136.63 | 1139.7 | 1134.74 | 1139.23 | 6514.0 |
| 2008-09-24 03:00:00 | ES | Futures | 1139.47 | 1140.65 | 1136.63 | 1138.28 | 12464.0 |
| 2008-09-24 03:30:00 | ES | Futures | 1138.28 | 1138.76 | 1135.68 | 1137.81 | 8671.0 |
| 2008-09-24 04:00:00 | ES | Futures | 1137.57 | 1138.76 | 1136.63 | 1138.05 | 9250.0 |
| 2008-09-24 04:30:00 | ES | Futures | 1138.05 | 1139.7 | 1138.05 | 1138.76 | 6933.0 |
| 2008-09-24 05:00:00 | ES | Futures | 1138.76 | 1140.89 | 1137.81 | 1140.65 | 4659.0 |
| 2008-09-24 05:30:00 | ES | Futures | 1140.65 | 1141.36 | 1135.21 | 1135.44 | 13234.0 |
| 2008-09-24 06:00:00 | ES | Futures | 1135.44 | 1136.39 | 1133.32 | 1133.55 | 11445.0 |
| 2008-09-24 06:30:00 | ES | Futures | 1133.79 | 1134.5 | 1131.19 | 1133.32 | 11889.0 |
| 2008-09-24 07:00:00 | ES | Futures | 1133.32 | 1136.39 | 1132.61 | 1135.21 | 9782.0 |
| 2008-09-24 07:30:00 | ES | Futures | 1135.21 | 1135.44 | 1125.98 | 1132.61 | 35499.0 |
| 2008-09-24 08:00:00 | ES | Futures | 1132.61 | 1137.1 | 1129.77 | 1135.92 | 34475.0 |
| 2008-09-24 08:30:00 | ES | Futures | 1135.92 | 1137.57 | 1132.37 | 1133.79 | 27675.0 |
| 2008-09-24 09:00:00 | ES | Futures | 1133.79 | 1134.74 | 1128.35 | 1129.53 | 36112.0 |
| 2008-09-24 09:30:00 | ES | Futures | 1129.29 | 1130.48 | 1121.01 | 1126.22 | 266608.0 |
| 2008-09-24 10:00:00 | ES | Futures | 1126.22 | 1127.64 | 1119.12 | 1125.51 | 217192.0 |
| 2008-09-24 10:30:00 | ES | Futures | 1125.51 | 1131.19 | 1124.56 | 1130.95 | 174343.0 |
| 2008-09-24 11:00:00 | ES | Futures | 1130.71 | 1131.19 | 1121.01 | 1125.98 | 152579.0 |
| 2008-09-24 11:30:00 | ES | Futures | 1125.98 | 1128.82 | 1120.06 | 1125.98 | 134315.0 |
| 2008-09-24 12:00:00 | ES | Futures | 1125.74 | 1128.35 | 1121.01 | 1123.38 | 88347.0 |
| 2008-09-24 12:30:00 | ES | Futures | 1123.38 | 1125.98 | 1121.96 | 1124.09 | 73154.0 |
| 2008-09-24 13:00:00 | ES | Futures | 1124.32 | 1134.97 | 1123.14 | 1132.61 | 143285.0 |
| 2008-09-24 13:30:00 | ES | Futures | 1132.61 | 1134.26 | 1126.45 | 1128.35 | 107299.0 |
| 2008-09-24 14:00:00 | ES | Futures | 1128.11 | 1129.53 | 1123.85 | 1128.35 | 98021.0 |
| 2008-09-24 14:30:00 | ES | Futures | 1128.35 | 1134.03 | 1125.98 | 1126.69 | 133401.0 |
| 2008-09-24 15:00:00 | ES | Futures | 1126.69 | 1129.53 | 1120.54 | 1126.22 | 157400.0 |
| 2008-09-24 15:30:00 | ES | Futures | 1126.22 | 1128.82 | 1117.22 | 1127.4 | 235050.0 |
| 2008-09-24 16:00:00 | ES | Futures | 1127.4 | 1129.29 | 1126.45 | 1128.82 | 78392.0 |
| 2008-09-24 16:30:00 | ES | Futures | 1128.58 | 1129.77 | 1127.87 | 1129.53 | 5640.0 |
| 2008-09-24 17:00:00 | ES | Futures | 1129.29 | 1129.29 | 1124.8 | 1125.03 | 3947.0 |
| 2008-09-24 18:00:00 | ES | Futures | 1125.27 | 1128.11 | 1125.27 | 1126.69 | 3508.0 |
| 2008-09-24 18:30:00 | ES | Futures | 1126.93 | 1127.87 | 1125.74 | 1127.4 | 989.0 |
| 2008-09-24 19:00:00 | ES | Futures | 1127.4 | 1129.06 | 1127.16 | 1128.11 | 1992.0 |
| 2008-09-24 19:30:00 | ES | Futures | 1128.11 | 1128.58 | 1125.03 | 1125.03 | 1674.0 |
| 2008-09-24 20:00:00 | ES | Futures | 1125.03 | 1127.16 | 1124.56 | 1126.93 | 2182.0 |
| 2008-09-24 20:30:00 | ES | Futures | 1126.93 | 1129.06 | 1124.56 | 1127.4 | 2620.0 |
| 2008-09-24 21:00:00 | ES | Futures | 1127.4 | 1131.9 | 1122.67 | 1130.71 | 9387.0 |
| 2008-09-24 21:30:00 | ES | Futures | 1130.48 | 1134.97 | 1129.53 | 1132.13 | 9529.0 |
| 2008-09-24 22:00:00 | ES | Futures | 1132.13 | 1134.26 | 1131.42 | 1132.84 | 3297.0 |
| 2008-09-24 22:30:00 | ES | Futures | 1132.84 | 1134.26 | 1131.66 | 1132.13 | 2230.0 |
| 2008-09-24 23:00:00 | ES | Futures | 1132.13 | 1132.13 | 1128.82 | 1129.29 | 3098.0 |
| 2008-09-24 23:30:00 | ES | Futures | 1129.53 | 1130.0 | 1128.35 | 1129.77 | 1137.0 |
| 2008-09-24 00:00:00 | NQ | Futures | 1895.57 | 1896.14 | 1893.59 | 1894.44 | 555.0 |
| 2008-09-24 00:30:00 | NQ | Futures | 1893.59 | 1894.72 | 1892.18 | 1894.72 | 109.0 |
| 2008-09-24 01:00:00 | NQ | Futures | 1893.87 | 1894.44 | 1893.59 | 1894.44 | 17.0 |
> showing 50 of 2,247 rows — these rows as CSV