PREVIEW / futures_30min / 2008-06-09
file: by_date/futures_30min/2008/2008-06-09.parquet size: 69 KB rows: 2,240
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-06-09 00:00:00 | ES | Futures | 1268.77 | 1269.7 | 1268.53 | 1269.46 | 639.0 |
| 2008-06-09 00:30:00 | ES | Futures | 1269.46 | 1269.93 | 1268.77 | 1269.23 | 582.0 |
| 2008-06-09 01:00:00 | ES | Futures | 1269.23 | 1269.46 | 1268.53 | 1269.0 | 217.0 |
| 2008-06-09 01:30:00 | ES | Futures | 1269.0 | 1269.46 | 1267.83 | 1268.07 | 1567.0 |
| 2008-06-09 02:00:00 | ES | Futures | 1268.07 | 1270.4 | 1268.07 | 1270.16 | 4372.0 |
| 2008-06-09 02:30:00 | ES | Futures | 1270.16 | 1270.86 | 1269.46 | 1270.63 | 2738.0 |
| 2008-06-09 03:00:00 | ES | Futures | 1270.63 | 1272.26 | 1268.53 | 1269.0 | 17608.0 |
| 2008-06-09 03:30:00 | ES | Futures | 1268.77 | 1273.19 | 1268.77 | 1272.96 | 10826.0 |
| 2008-06-09 04:00:00 | ES | Futures | 1272.96 | 1273.66 | 1271.33 | 1272.96 | 8239.0 |
| 2008-06-09 04:30:00 | ES | Futures | 1272.72 | 1273.19 | 1271.56 | 1272.96 | 6993.0 |
| 2008-06-09 05:00:00 | ES | Futures | 1272.96 | 1273.19 | 1270.63 | 1270.86 | 6441.0 |
| 2008-06-09 05:30:00 | ES | Futures | 1270.63 | 1272.96 | 1270.4 | 1272.26 | 4752.0 |
| 2008-06-09 06:00:00 | ES | Futures | 1272.49 | 1272.72 | 1269.0 | 1270.16 | 5239.0 |
| 2008-06-09 06:30:00 | ES | Futures | 1270.16 | 1272.96 | 1268.3 | 1271.33 | 18304.0 |
| 2008-06-09 07:00:00 | ES | Futures | 1271.56 | 1272.49 | 1265.74 | 1269.93 | 25669.0 |
| 2008-06-09 07:30:00 | ES | Futures | 1269.93 | 1271.56 | 1268.77 | 1268.77 | 10849.0 |
| 2008-06-09 08:00:00 | ES | Futures | 1268.77 | 1272.72 | 1268.53 | 1270.16 | 15017.0 |
| 2008-06-09 08:30:00 | ES | Futures | 1269.93 | 1272.96 | 1269.23 | 1271.79 | 19220.0 |
| 2008-06-09 09:00:00 | ES | Futures | 1271.79 | 1273.66 | 1270.86 | 1271.09 | 27513.0 |
| 2008-06-09 09:30:00 | ES | Futures | 1270.86 | 1272.72 | 1266.9 | 1272.72 | 215501.0 |
| 2008-06-09 10:00:00 | ES | Futures | 1272.96 | 1277.38 | 1270.63 | 1273.89 | 235426.0 |
| 2008-06-09 10:30:00 | ES | Futures | 1273.89 | 1275.05 | 1270.86 | 1271.33 | 137317.0 |
| 2008-06-09 11:00:00 | ES | Futures | 1271.33 | 1274.82 | 1270.86 | 1274.35 | 169719.0 |
| 2008-06-09 11:30:00 | ES | Futures | 1274.35 | 1275.75 | 1272.03 | 1272.72 | 84589.0 |
| 2008-06-09 12:00:00 | ES | Futures | 1272.96 | 1273.66 | 1270.63 | 1272.49 | 63265.0 |
| 2008-06-09 12:30:00 | ES | Futures | 1272.49 | 1274.59 | 1272.26 | 1274.12 | 37461.0 |
| 2008-06-09 13:00:00 | ES | Futures | 1274.12 | 1274.12 | 1264.11 | 1266.9 | 154969.0 |
| 2008-06-09 13:30:00 | ES | Futures | 1266.9 | 1268.07 | 1261.55 | 1263.18 | 135180.0 |
| 2008-06-09 14:00:00 | ES | Futures | 1263.41 | 1264.57 | 1257.82 | 1262.94 | 196260.0 |
| 2008-06-09 14:30:00 | ES | Futures | 1262.94 | 1266.9 | 1261.55 | 1262.01 | 161548.0 |
| 2008-06-09 15:00:00 | ES | Futures | 1262.25 | 1264.81 | 1258.99 | 1262.01 | 143072.0 |
| 2008-06-09 15:30:00 | ES | Futures | 1261.78 | 1270.4 | 1261.78 | 1269.0 | 198903.0 |
| 2008-06-09 16:00:00 | ES | Futures | 1269.23 | 1270.16 | 1267.6 | 1269.7 | 58918.0 |
| 2008-06-09 16:30:00 | ES | Futures | 1268.53 | 1270.4 | 1268.3 | 1269.23 | 4844.0 |
| 2008-06-09 17:00:00 | ES | Futures | 1269.23 | 1269.7 | 1269.23 | 1269.46 | 1120.0 |
| 2008-06-09 18:00:00 | ES | Futures | 1269.46 | 1269.7 | 1267.83 | 1268.3 | 1890.0 |
| 2008-06-09 18:30:00 | ES | Futures | 1268.07 | 1268.3 | 1267.83 | 1268.07 | 382.0 |
| 2008-06-09 19:00:00 | ES | Futures | 1268.07 | 1268.77 | 1267.83 | 1268.53 | 480.0 |
| 2008-06-09 19:30:00 | ES | Futures | 1268.77 | 1269.0 | 1268.53 | 1269.0 | 718.0 |
| 2008-06-09 20:00:00 | ES | Futures | 1268.77 | 1269.23 | 1266.67 | 1267.37 | 2914.0 |
| 2008-06-09 20:30:00 | ES | Futures | 1267.6 | 1267.83 | 1264.11 | 1265.04 | 3711.0 |
| 2008-06-09 21:00:00 | ES | Futures | 1265.04 | 1265.51 | 1263.88 | 1265.27 | 1377.0 |
| 2008-06-09 21:30:00 | ES | Futures | 1265.27 | 1265.74 | 1263.18 | 1263.88 | 1914.0 |
| 2008-06-09 22:00:00 | ES | Futures | 1264.11 | 1264.81 | 1263.18 | 1263.41 | 1523.0 |
| 2008-06-09 22:30:00 | ES | Futures | 1263.41 | 1263.88 | 1262.94 | 1263.41 | 1065.0 |
| 2008-06-09 23:00:00 | ES | Futures | 1263.41 | 1263.88 | 1263.18 | 1263.64 | 406.0 |
| 2008-06-09 23:30:00 | ES | Futures | 1263.64 | 1263.64 | 1262.25 | 1263.64 | 975.0 |
| 2008-06-09 00:00:00 | NQ | Futures | 2256.12 | 2257.54 | 2255.28 | 2256.12 | 121.0 |
| 2008-06-09 00:30:00 | NQ | Futures | 2256.41 | 2257.26 | 2254.43 | 2256.41 | 105.0 |
| 2008-06-09 01:00:00 | NQ | Futures | 2256.41 | 2256.41 | 2255.28 | 2255.84 | 40.0 |
> showing 50 of 2,240 rows — these rows as CSV