PREVIEW / futures_30min / 2008-06-17
file: by_date/futures_30min/2008/2008-06-17.parquet size: 65 KB rows: 2,276
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-17 00:00:00 | ES | Futures | 1263.64 | 1264.57 | 1263.18 | 1264.57 | 372.0 |
| 2008-06-17 00:30:00 | ES | Futures | 1264.11 | 1265.27 | 1263.87 | 1264.11 | 508.0 |
| 2008-06-17 01:00:00 | ES | Futures | 1264.11 | 1264.34 | 1263.41 | 1263.64 | 511.0 |
| 2008-06-17 01:30:00 | ES | Futures | 1263.41 | 1265.04 | 1263.18 | 1264.57 | 726.0 |
| 2008-06-17 02:00:00 | ES | Futures | 1264.57 | 1266.9 | 1264.34 | 1266.2 | 2773.0 |
| 2008-06-17 02:30:00 | ES | Futures | 1266.2 | 1266.9 | 1265.73 | 1266.66 | 1236.0 |
| 2008-06-17 03:00:00 | ES | Futures | 1266.66 | 1268.76 | 1266.66 | 1268.06 | 6523.0 |
| 2008-06-17 03:30:00 | ES | Futures | 1268.06 | 1268.52 | 1267.36 | 1267.36 | 3967.0 |
| 2008-06-17 04:00:00 | ES | Futures | 1267.36 | 1268.76 | 1267.36 | 1268.52 | 3480.0 |
| 2008-06-17 04:30:00 | ES | Futures | 1268.29 | 1270.85 | 1267.59 | 1269.92 | 8052.0 |
| 2008-06-17 05:00:00 | ES | Futures | 1269.69 | 1269.92 | 1268.29 | 1269.69 | 5347.0 |
| 2008-06-17 05:30:00 | ES | Futures | 1269.45 | 1270.85 | 1268.99 | 1270.38 | 6556.0 |
| 2008-06-17 06:00:00 | ES | Futures | 1270.38 | 1270.61 | 1269.69 | 1270.38 | 2124.0 |
| 2008-06-17 06:30:00 | ES | Futures | 1270.15 | 1271.31 | 1269.92 | 1270.85 | 4100.0 |
| 2008-06-17 07:00:00 | ES | Futures | 1270.85 | 1271.78 | 1270.61 | 1271.08 | 13518.0 |
| 2008-06-17 07:30:00 | ES | Futures | 1271.08 | 1272.01 | 1270.85 | 1271.78 | 8735.0 |
| 2008-06-17 08:00:00 | ES | Futures | 1271.78 | 1275.5 | 1271.54 | 1273.64 | 42185.0 |
| 2008-06-17 08:30:00 | ES | Futures | 1273.4 | 1274.57 | 1271.31 | 1274.57 | 47200.0 |
| 2008-06-17 09:00:00 | ES | Futures | 1274.57 | 1275.03 | 1272.01 | 1272.47 | 37280.0 |
| 2008-06-17 09:30:00 | ES | Futures | 1272.24 | 1272.71 | 1266.66 | 1268.76 | 223003.0 |
| 2008-06-17 10:00:00 | ES | Futures | 1268.76 | 1270.85 | 1265.04 | 1265.73 | 164131.0 |
| 2008-06-17 10:30:00 | ES | Futures | 1265.5 | 1268.99 | 1264.8 | 1267.83 | 133229.0 |
| 2008-06-17 11:00:00 | ES | Futures | 1267.59 | 1269.69 | 1262.95 | 1263.87 | 120739.0 |
| 2008-06-17 11:30:00 | ES | Futures | 1263.87 | 1264.8 | 1261.55 | 1262.48 | 131096.0 |
| 2008-06-17 12:00:00 | ES | Futures | 1262.48 | 1264.57 | 1262.02 | 1262.71 | 65276.0 |
| 2008-06-17 12:30:00 | ES | Futures | 1262.48 | 1263.41 | 1259.46 | 1261.55 | 77340.0 |
| 2008-06-17 13:00:00 | ES | Futures | 1261.32 | 1265.04 | 1260.16 | 1264.11 | 70772.0 |
| 2008-06-17 13:30:00 | ES | Futures | 1264.34 | 1265.73 | 1263.18 | 1264.11 | 50787.0 |
| 2008-06-17 14:00:00 | ES | Futures | 1264.11 | 1264.8 | 1260.85 | 1261.09 | 70442.0 |
| 2008-06-17 14:30:00 | ES | Futures | 1261.09 | 1264.11 | 1260.62 | 1262.48 | 55900.0 |
| 2008-06-17 15:00:00 | ES | Futures | 1262.48 | 1263.41 | 1258.3 | 1259.69 | 91689.0 |
| 2008-06-17 15:30:00 | ES | Futures | 1259.69 | 1260.62 | 1257.13 | 1257.6 | 145461.0 |
| 2008-06-17 16:00:00 | ES | Futures | 1257.6 | 1258.53 | 1256.21 | 1258.3 | 67537.0 |
| 2008-06-17 16:30:00 | ES | Futures | 1257.6 | 1258.53 | 1257.13 | 1258.3 | 3302.0 |
| 2008-06-17 17:00:00 | ES | Futures | 1258.06 | 1258.3 | 1257.13 | 1257.37 | 747.0 |
| 2008-06-17 18:00:00 | ES | Futures | 1257.13 | 1257.6 | 1256.67 | 1257.6 | 1719.0 |
| 2008-06-17 18:30:00 | ES | Futures | 1257.6 | 1258.06 | 1255.97 | 1256.21 | 692.0 |
| 2008-06-17 19:00:00 | ES | Futures | 1256.21 | 1256.44 | 1255.97 | 1256.21 | 551.0 |
| 2008-06-17 19:30:00 | ES | Futures | 1256.44 | 1257.37 | 1255.97 | 1257.37 | 404.0 |
| 2008-06-17 20:00:00 | ES | Futures | 1257.37 | 1257.83 | 1256.44 | 1257.6 | 832.0 |
| 2008-06-17 20:30:00 | ES | Futures | 1257.6 | 1257.83 | 1257.13 | 1257.6 | 401.0 |
| 2008-06-17 21:00:00 | ES | Futures | 1257.83 | 1258.06 | 1257.37 | 1257.83 | 363.0 |
| 2008-06-17 21:30:00 | ES | Futures | 1257.83 | 1258.3 | 1257.37 | 1257.6 | 326.0 |
| 2008-06-17 22:00:00 | ES | Futures | 1257.83 | 1258.3 | 1257.13 | 1258.3 | 567.0 |
| 2008-06-17 22:30:00 | ES | Futures | 1258.3 | 1258.3 | 1257.13 | 1257.37 | 282.0 |
| 2008-06-17 23:00:00 | ES | Futures | 1257.13 | 1258.3 | 1257.13 | 1258.06 | 378.0 |
| 2008-06-17 23:30:00 | ES | Futures | 1258.3 | 1258.76 | 1258.06 | 1258.3 | 754.0 |
| 2008-06-17 00:00:00 | NQ | Futures | 2236.53 | 2238.21 | 2236.25 | 2237.93 | 17.0 |
| 2008-06-17 00:30:00 | NQ | Futures | 2238.5 | 2239.06 | 2238.21 | 2238.21 | 49.0 |
| 2008-06-17 01:00:00 | NQ | Futures | 2237.37 | 2237.37 | 2236.81 | 2236.81 | 32.0 |
> showing 50 of 2,276 rows — these rows as CSV