PREVIEW / futures_30min / 2008-01-29
file: by_date/futures_30min/2008/2008-01-29.parquet size: 43 KB rows: 1,503
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-01-29 00:00:00 | ES | Futures | 1263.24 | 1265.57 | 1262.54 | 1264.64 | 1354.0 |
| 2008-01-29 00:30:00 | ES | Futures | 1264.41 | 1265.11 | 1263.01 | 1263.94 | 704.0 |
| 2008-01-29 01:00:00 | ES | Futures | 1263.94 | 1264.17 | 1261.37 | 1262.07 | 731.0 |
| 2008-01-29 01:30:00 | ES | Futures | 1261.84 | 1264.64 | 1261.84 | 1263.01 | 918.0 |
| 2008-01-29 02:00:00 | ES | Futures | 1263.01 | 1264.41 | 1261.14 | 1263.24 | 3982.0 |
| 2008-01-29 02:30:00 | ES | Futures | 1262.77 | 1263.47 | 1261.84 | 1262.54 | 3754.0 |
| 2008-01-29 03:00:00 | ES | Futures | 1262.54 | 1263.47 | 1259.28 | 1262.54 | 8890.0 |
| 2008-01-29 03:30:00 | ES | Futures | 1262.54 | 1263.47 | 1260.44 | 1263.47 | 5233.0 |
| 2008-01-29 04:00:00 | ES | Futures | 1263.47 | 1266.04 | 1263.01 | 1264.17 | 9470.0 |
| 2008-01-29 04:30:00 | ES | Futures | 1264.17 | 1265.34 | 1263.71 | 1264.64 | 4828.0 |
| 2008-01-29 05:00:00 | ES | Futures | 1264.64 | 1265.8 | 1264.17 | 1265.57 | 4963.0 |
| 2008-01-29 05:30:00 | ES | Futures | 1265.57 | 1269.77 | 1265.11 | 1269.3 | 11377.0 |
| 2008-01-29 06:00:00 | ES | Futures | 1269.3 | 1269.77 | 1267.9 | 1268.14 | 4277.0 |
| 2008-01-29 06:30:00 | ES | Futures | 1267.9 | 1268.84 | 1265.34 | 1266.74 | 8244.0 |
| 2008-01-29 07:00:00 | ES | Futures | 1266.74 | 1267.44 | 1265.11 | 1266.74 | 12225.0 |
| 2008-01-29 07:30:00 | ES | Futures | 1266.74 | 1268.6 | 1265.34 | 1266.5 | 8508.0 |
| 2008-01-29 08:00:00 | ES | Futures | 1266.5 | 1270.0 | 1266.04 | 1268.6 | 19345.0 |
| 2008-01-29 08:30:00 | ES | Futures | 1268.6 | 1273.73 | 1268.37 | 1271.63 | 57044.0 |
| 2008-01-29 09:00:00 | ES | Futures | 1271.63 | 1273.97 | 1270.7 | 1271.87 | 26759.0 |
| 2008-01-29 09:30:00 | ES | Futures | 1271.63 | 1273.27 | 1263.24 | 1263.71 | 188612.0 |
| 2008-01-29 10:00:00 | ES | Futures | 1263.71 | 1270.47 | 1259.98 | 1269.3 | 211195.0 |
| 2008-01-29 10:30:00 | ES | Futures | 1269.54 | 1270.23 | 1265.8 | 1268.14 | 97139.0 |
| 2008-01-29 11:00:00 | ES | Futures | 1268.14 | 1272.57 | 1267.67 | 1270.0 | 94696.0 |
| 2008-01-29 11:30:00 | ES | Futures | 1270.0 | 1273.03 | 1269.07 | 1270.7 | 62177.0 |
| 2008-01-29 12:00:00 | ES | Futures | 1270.7 | 1271.17 | 1264.17 | 1266.04 | 77701.0 |
| 2008-01-29 12:30:00 | ES | Futures | 1265.8 | 1268.14 | 1264.41 | 1266.27 | 51381.0 |
| 2008-01-29 13:00:00 | ES | Futures | 1266.27 | 1268.37 | 1264.41 | 1267.67 | 50001.0 |
| 2008-01-29 13:30:00 | ES | Futures | 1267.67 | 1270.23 | 1265.8 | 1266.27 | 58825.0 |
| 2008-01-29 14:00:00 | ES | Futures | 1266.27 | 1268.84 | 1264.41 | 1268.14 | 70639.0 |
| 2008-01-29 14:30:00 | ES | Futures | 1268.37 | 1270.23 | 1266.27 | 1269.07 | 68476.0 |
| 2008-01-29 15:00:00 | ES | Futures | 1269.3 | 1274.9 | 1268.84 | 1272.57 | 116127.0 |
| 2008-01-29 15:30:00 | ES | Futures | 1272.57 | 1273.73 | 1269.77 | 1271.17 | 143685.0 |
| 2008-01-29 16:00:00 | ES | Futures | 1270.93 | 1271.4 | 1269.77 | 1270.23 | 54710.0 |
| 2008-01-29 16:30:00 | ES | Futures | 1269.77 | 1270.7 | 1268.84 | 1269.54 | 4974.0 |
| 2008-01-29 17:00:00 | ES | Futures | 1269.54 | 1270.0 | 1269.3 | 1269.77 | 1167.0 |
| 2008-01-29 18:00:00 | ES | Futures | 1270.0 | 1270.23 | 1269.07 | 1269.3 | 915.0 |
| 2008-01-29 18:30:00 | ES | Futures | 1269.3 | 1270.0 | 1268.37 | 1269.07 | 1024.0 |
| 2008-01-29 19:00:00 | ES | Futures | 1269.3 | 1269.3 | 1267.9 | 1268.37 | 1255.0 |
| 2008-01-29 19:30:00 | ES | Futures | 1268.37 | 1268.6 | 1267.67 | 1267.67 | 808.0 |
| 2008-01-29 20:00:00 | ES | Futures | 1267.67 | 1268.6 | 1267.44 | 1268.37 | 1213.0 |
| 2008-01-29 20:30:00 | ES | Futures | 1268.37 | 1268.84 | 1267.9 | 1268.84 | 380.0 |
| 2008-01-29 21:00:00 | ES | Futures | 1268.84 | 1270.0 | 1268.84 | 1269.3 | 758.0 |
| 2008-01-29 21:30:00 | ES | Futures | 1269.07 | 1270.23 | 1268.84 | 1268.84 | 532.0 |
| 2008-01-29 22:00:00 | ES | Futures | 1268.84 | 1269.3 | 1266.97 | 1266.97 | 1698.0 |
| 2008-01-29 22:30:00 | ES | Futures | 1266.97 | 1268.14 | 1266.04 | 1266.97 | 1840.0 |
| 2008-01-29 23:00:00 | ES | Futures | 1266.97 | 1267.2 | 1265.8 | 1266.5 | 972.0 |
| 2008-01-29 23:30:00 | ES | Futures | 1266.27 | 1266.5 | 1265.57 | 1265.8 | 1195.0 |
| 2008-01-29 00:00:00 | NQ | Futures | 2045.09 | 2049.35 | 2044.53 | 2047.65 | 48.0 |
| 2008-01-29 00:30:00 | NQ | Futures | 2047.65 | 2047.65 | 2046.8 | 2047.65 | 10.0 |
| 2008-01-29 01:00:00 | NQ | Futures | 2048.5 | 2048.5 | 2044.81 | 2045.09 | 139.0 |
> showing 50 of 1,503 rows — these rows as CSV