PREVIEW / futures_30min / 2008-04-17
file: by_date/futures_30min/2008/2008-04-17.parquet size: 68 KB rows: 2,279
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-04-17 00:00:00 | ES | Futures | 1276.45 | 1276.45 | 1274.82 | 1274.82 | 559.0 |
| 2008-04-17 00:30:00 | ES | Futures | 1274.82 | 1275.75 | 1274.82 | 1275.28 | 364.0 |
| 2008-04-17 01:00:00 | ES | Futures | 1275.28 | 1275.28 | 1274.12 | 1274.59 | 748.0 |
| 2008-04-17 01:30:00 | ES | Futures | 1274.59 | 1274.82 | 1273.66 | 1273.89 | 897.0 |
| 2008-04-17 02:00:00 | ES | Futures | 1274.12 | 1274.59 | 1272.96 | 1273.89 | 3042.0 |
| 2008-04-17 02:30:00 | ES | Futures | 1273.89 | 1274.12 | 1272.49 | 1272.96 | 2964.0 |
| 2008-04-17 03:00:00 | ES | Futures | 1272.96 | 1274.12 | 1271.56 | 1274.12 | 8557.0 |
| 2008-04-17 03:30:00 | ES | Futures | 1274.12 | 1274.35 | 1271.56 | 1271.79 | 5410.0 |
| 2008-04-17 04:00:00 | ES | Futures | 1271.79 | 1272.72 | 1270.86 | 1272.72 | 7056.0 |
| 2008-04-17 04:30:00 | ES | Futures | 1272.72 | 1273.19 | 1271.56 | 1272.72 | 2868.0 |
| 2008-04-17 05:00:00 | ES | Futures | 1272.72 | 1272.96 | 1271.09 | 1271.09 | 3937.0 |
| 2008-04-17 05:30:00 | ES | Futures | 1271.33 | 1274.59 | 1270.86 | 1273.89 | 7943.0 |
| 2008-04-17 06:00:00 | ES | Futures | 1273.89 | 1275.28 | 1269.7 | 1273.89 | 19355.0 |
| 2008-04-17 06:30:00 | ES | Futures | 1274.12 | 1275.98 | 1271.79 | 1273.66 | 15985.0 |
| 2008-04-17 07:00:00 | ES | Futures | 1273.66 | 1274.35 | 1270.16 | 1271.79 | 16285.0 |
| 2008-04-17 07:30:00 | ES | Futures | 1271.79 | 1272.49 | 1270.63 | 1270.86 | 8676.0 |
| 2008-04-17 08:00:00 | ES | Futures | 1270.86 | 1272.03 | 1267.14 | 1268.53 | 30379.0 |
| 2008-04-17 08:30:00 | ES | Futures | 1268.77 | 1270.63 | 1266.9 | 1268.3 | 47825.0 |
| 2008-04-17 09:00:00 | ES | Futures | 1268.3 | 1269.23 | 1267.14 | 1268.77 | 22881.0 |
| 2008-04-17 09:30:00 | ES | Futures | 1268.53 | 1270.86 | 1267.37 | 1269.46 | 158431.0 |
| 2008-04-17 10:00:00 | ES | Futures | 1269.46 | 1274.12 | 1265.97 | 1272.49 | 193183.0 |
| 2008-04-17 10:30:00 | ES | Futures | 1272.26 | 1274.59 | 1270.16 | 1271.33 | 140140.0 |
| 2008-04-17 11:00:00 | ES | Futures | 1271.09 | 1271.79 | 1266.67 | 1267.37 | 126323.0 |
| 2008-04-17 11:30:00 | ES | Futures | 1267.37 | 1268.3 | 1265.27 | 1266.67 | 115350.0 |
| 2008-04-17 12:00:00 | ES | Futures | 1266.67 | 1269.0 | 1265.97 | 1266.44 | 55631.0 |
| 2008-04-17 12:30:00 | ES | Futures | 1266.44 | 1269.93 | 1265.27 | 1269.46 | 67040.0 |
| 2008-04-17 13:00:00 | ES | Futures | 1269.7 | 1272.03 | 1269.0 | 1271.79 | 67837.0 |
| 2008-04-17 13:30:00 | ES | Futures | 1272.03 | 1273.42 | 1270.16 | 1270.4 | 97463.0 |
| 2008-04-17 14:00:00 | ES | Futures | 1270.4 | 1271.33 | 1268.53 | 1270.16 | 64871.0 |
| 2008-04-17 14:30:00 | ES | Futures | 1269.93 | 1272.96 | 1269.7 | 1270.4 | 77264.0 |
| 2008-04-17 15:00:00 | ES | Futures | 1270.4 | 1274.82 | 1269.46 | 1272.96 | 107157.0 |
| 2008-04-17 15:30:00 | ES | Futures | 1272.72 | 1276.45 | 1272.26 | 1272.96 | 134523.0 |
| 2008-04-17 16:00:00 | ES | Futures | 1272.96 | 1280.17 | 1271.33 | 1277.38 | 124099.0 |
| 2008-04-17 16:30:00 | ES | Futures | 1280.17 | 1281.8 | 1277.61 | 1279.94 | 14111.0 |
| 2008-04-17 17:00:00 | ES | Futures | 1279.94 | 1281.11 | 1279.71 | 1280.87 | 3540.0 |
| 2008-04-17 18:00:00 | ES | Futures | 1280.41 | 1280.64 | 1279.48 | 1279.71 | 1335.0 |
| 2008-04-17 18:30:00 | ES | Futures | 1279.94 | 1280.64 | 1279.94 | 1280.64 | 474.0 |
| 2008-04-17 19:00:00 | ES | Futures | 1280.41 | 1280.64 | 1279.48 | 1279.94 | 396.0 |
| 2008-04-17 19:30:00 | ES | Futures | 1279.71 | 1279.94 | 1279.24 | 1279.48 | 739.0 |
| 2008-04-17 20:00:00 | ES | Futures | 1279.71 | 1279.94 | 1279.01 | 1279.24 | 714.0 |
| 2008-04-17 20:30:00 | ES | Futures | 1279.24 | 1279.71 | 1278.78 | 1279.01 | 671.0 |
| 2008-04-17 21:00:00 | ES | Futures | 1279.24 | 1279.94 | 1279.01 | 1279.24 | 311.0 |
| 2008-04-17 21:30:00 | ES | Futures | 1279.24 | 1279.71 | 1278.08 | 1278.31 | 1179.0 |
| 2008-04-17 22:00:00 | ES | Futures | 1278.54 | 1278.78 | 1277.15 | 1277.38 | 1639.0 |
| 2008-04-17 22:30:00 | ES | Futures | 1277.85 | 1278.31 | 1276.91 | 1277.15 | 668.0 |
| 2008-04-17 23:00:00 | ES | Futures | 1277.15 | 1278.31 | 1276.91 | 1277.61 | 423.0 |
| 2008-04-17 23:30:00 | ES | Futures | 1277.38 | 1278.31 | 1277.15 | 1278.31 | 421.0 |
| 2008-04-17 00:00:00 | NQ | Futures | 2109.05 | 2109.05 | 2107.64 | 2107.64 | 71.0 |
| 2008-04-17 00:30:00 | NQ | Futures | 2107.07 | 2107.92 | 2105.38 | 2107.36 | 80.0 |
| 2008-04-17 01:00:00 | NQ | Futures | 2107.36 | 2107.36 | 2105.38 | 2106.51 | 23.0 |
> showing 50 of 2,279 rows — these rows as CSV