PREVIEW / futures_30min / 2008-09-16
file: by_date/futures_30min/2008/2008-09-16.parquet size: 75 KB rows: 2,373
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-16 00:00:00 | ES | Futures | 1114.38 | 1117.46 | 1114.15 | 1114.86 | 1705.0 |
| 2008-09-16 00:30:00 | ES | Futures | 1114.86 | 1117.46 | 1114.38 | 1116.28 | 1252.0 |
| 2008-09-16 01:00:00 | ES | Futures | 1116.28 | 1121.25 | 1115.33 | 1121.01 | 3526.0 |
| 2008-09-16 01:30:00 | ES | Futures | 1121.01 | 1124.09 | 1120.77 | 1122.9 | 6735.0 |
| 2008-09-16 02:00:00 | ES | Futures | 1122.9 | 1125.74 | 1122.67 | 1123.85 | 9536.0 |
| 2008-09-16 02:30:00 | ES | Futures | 1123.85 | 1128.35 | 1123.61 | 1127.16 | 10184.0 |
| 2008-09-16 03:00:00 | ES | Futures | 1127.16 | 1130.48 | 1126.22 | 1129.29 | 20223.0 |
| 2008-09-16 03:30:00 | ES | Futures | 1129.29 | 1129.29 | 1124.09 | 1124.56 | 10191.0 |
| 2008-09-16 04:00:00 | ES | Futures | 1124.8 | 1127.87 | 1124.56 | 1126.93 | 8185.0 |
| 2008-09-16 04:30:00 | ES | Futures | 1126.93 | 1128.82 | 1126.93 | 1127.64 | 6840.0 |
| 2008-09-16 05:00:00 | ES | Futures | 1127.4 | 1134.26 | 1127.16 | 1133.79 | 18410.0 |
| 2008-09-16 05:30:00 | ES | Futures | 1133.79 | 1136.39 | 1130.71 | 1134.97 | 17789.0 |
| 2008-09-16 06:00:00 | ES | Futures | 1134.97 | 1135.21 | 1124.8 | 1124.8 | 22567.0 |
| 2008-09-16 06:30:00 | ES | Futures | 1124.8 | 1125.51 | 1121.96 | 1122.67 | 19762.0 |
| 2008-09-16 07:00:00 | ES | Futures | 1122.67 | 1122.9 | 1116.75 | 1121.01 | 40494.0 |
| 2008-09-16 07:30:00 | ES | Futures | 1121.01 | 1123.61 | 1116.99 | 1121.72 | 43747.0 |
| 2008-09-16 08:00:00 | ES | Futures | 1121.72 | 1124.56 | 1114.15 | 1116.99 | 89422.0 |
| 2008-09-16 08:30:00 | ES | Futures | 1116.99 | 1118.64 | 1106.81 | 1109.41 | 121374.0 |
| 2008-09-16 09:00:00 | ES | Futures | 1109.41 | 1111.07 | 1100.89 | 1105.63 | 99514.0 |
| 2008-09-16 09:30:00 | ES | Futures | 1105.63 | 1122.19 | 1104.92 | 1111.54 | 495674.0 |
| 2008-09-16 10:00:00 | ES | Futures | 1111.78 | 1128.11 | 1111.54 | 1127.4 | 347546.0 |
| 2008-09-16 10:30:00 | ES | Futures | 1127.64 | 1138.05 | 1120.3 | 1133.08 | 450213.0 |
| 2008-09-16 11:00:00 | ES | Futures | 1133.08 | 1141.6 | 1120.06 | 1121.01 | 390102.0 |
| 2008-09-16 11:30:00 | ES | Futures | 1121.01 | 1132.61 | 1120.06 | 1130.71 | 154402.0 |
| 2008-09-16 12:00:00 | ES | Futures | 1130.95 | 1136.63 | 1126.45 | 1134.03 | 190190.0 |
| 2008-09-16 12:30:00 | ES | Futures | 1134.03 | 1134.74 | 1128.58 | 1134.26 | 74253.0 |
| 2008-09-16 13:00:00 | ES | Futures | 1134.5 | 1137.1 | 1131.19 | 1134.74 | 102004.0 |
| 2008-09-16 13:30:00 | ES | Futures | 1134.5 | 1135.21 | 1127.64 | 1129.77 | 105583.0 |
| 2008-09-16 14:00:00 | ES | Futures | 1129.77 | 1138.52 | 1113.2 | 1120.77 | 327640.0 |
| 2008-09-16 14:30:00 | ES | Futures | 1120.77 | 1147.04 | 1117.7 | 1144.2 | 496721.0 |
| 2008-09-16 15:00:00 | ES | Futures | 1143.96 | 1152.48 | 1139.7 | 1140.89 | 259249.0 |
| 2008-09-16 15:30:00 | ES | Futures | 1140.89 | 1151.54 | 1140.41 | 1150.83 | 282621.0 |
| 2008-09-16 16:00:00 | ES | Futures | 1151.06 | 1155.8 | 1147.28 | 1152.01 | 142724.0 |
| 2008-09-16 16:30:00 | ES | Futures | 1152.72 | 1153.9 | 1133.55 | 1135.44 | 66647.0 |
| 2008-09-16 17:00:00 | ES | Futures | 1135.44 | 1144.91 | 1135.44 | 1142.07 | 18339.0 |
| 2008-09-16 18:00:00 | ES | Futures | 1139.7 | 1140.41 | 1136.15 | 1137.1 | 9713.0 |
| 2008-09-16 18:30:00 | ES | Futures | 1137.34 | 1141.83 | 1136.63 | 1141.36 | 9073.0 |
| 2008-09-16 19:00:00 | ES | Futures | 1141.36 | 1163.13 | 1141.12 | 1160.06 | 33183.0 |
| 2008-09-16 19:30:00 | ES | Futures | 1160.06 | 1163.84 | 1155.56 | 1157.45 | 18590.0 |
| 2008-09-16 20:00:00 | ES | Futures | 1157.45 | 1162.66 | 1156.27 | 1157.22 | 9111.0 |
| 2008-09-16 20:30:00 | ES | Futures | 1156.98 | 1157.93 | 1156.27 | 1156.27 | 3034.0 |
| 2008-09-16 21:00:00 | ES | Futures | 1156.51 | 1160.06 | 1156.03 | 1160.06 | 6418.0 |
| 2008-09-16 21:30:00 | ES | Futures | 1160.06 | 1162.9 | 1159.82 | 1160.06 | 9252.0 |
| 2008-09-16 22:00:00 | ES | Futures | 1160.06 | 1161.48 | 1158.87 | 1160.29 | 3642.0 |
| 2008-09-16 22:30:00 | ES | Futures | 1160.29 | 1160.29 | 1156.51 | 1156.74 | 3394.0 |
| 2008-09-16 23:00:00 | ES | Futures | 1156.74 | 1156.98 | 1152.48 | 1154.38 | 5463.0 |
| 2008-09-16 23:30:00 | ES | Futures | 1154.61 | 1156.03 | 1154.14 | 1155.32 | 2102.0 |
| 2008-09-16 00:00:00 | NQ | Futures | 1927.26 | 1930.94 | 1926.7 | 1927.55 | 124.0 |
| 2008-09-16 00:30:00 | NQ | Futures | 1927.83 | 1931.22 | 1927.55 | 1929.81 | 69.0 |
| 2008-09-16 01:00:00 | NQ | Futures | 1930.66 | 1936.04 | 1930.38 | 1936.04 | 467.0 |
> showing 50 of 2,373 rows — these rows as CSV