PREVIEW / futures_30min / 2008-01-30
file: by_date/futures_30min/2008/2008-01-30.parquet size: 48 KB rows: 1,516
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-30 00:00:00 | ES | Futures | 1265.8 | 1266.27 | 1264.87 | 1264.87 | 1402.0 |
| 2008-01-30 00:30:00 | ES | Futures | 1265.11 | 1265.8 | 1264.64 | 1265.34 | 828.0 |
| 2008-01-30 01:00:00 | ES | Futures | 1265.34 | 1266.97 | 1264.64 | 1265.34 | 1941.0 |
| 2008-01-30 01:30:00 | ES | Futures | 1265.34 | 1265.8 | 1263.94 | 1264.17 | 1496.0 |
| 2008-01-30 02:00:00 | ES | Futures | 1264.17 | 1264.87 | 1263.71 | 1264.17 | 3677.0 |
| 2008-01-30 02:30:00 | ES | Futures | 1264.17 | 1264.64 | 1262.07 | 1263.47 | 5708.0 |
| 2008-01-30 03:00:00 | ES | Futures | 1263.71 | 1264.41 | 1262.31 | 1264.41 | 7908.0 |
| 2008-01-30 03:30:00 | ES | Futures | 1264.41 | 1266.27 | 1263.47 | 1264.17 | 7257.0 |
| 2008-01-30 04:00:00 | ES | Futures | 1264.17 | 1265.8 | 1261.84 | 1263.01 | 6993.0 |
| 2008-01-30 04:30:00 | ES | Futures | 1263.01 | 1266.04 | 1261.84 | 1265.8 | 7406.0 |
| 2008-01-30 05:00:00 | ES | Futures | 1265.8 | 1267.67 | 1265.11 | 1265.8 | 7627.0 |
| 2008-01-30 05:30:00 | ES | Futures | 1265.8 | 1268.84 | 1265.57 | 1267.9 | 5363.0 |
| 2008-01-30 06:00:00 | ES | Futures | 1267.9 | 1269.77 | 1267.67 | 1269.07 | 5945.0 |
| 2008-01-30 06:30:00 | ES | Futures | 1269.07 | 1270.23 | 1267.44 | 1267.44 | 5939.0 |
| 2008-01-30 07:00:00 | ES | Futures | 1267.44 | 1267.9 | 1264.87 | 1264.87 | 10984.0 |
| 2008-01-30 07:30:00 | ES | Futures | 1264.87 | 1266.97 | 1263.71 | 1265.11 | 11815.0 |
| 2008-01-30 08:00:00 | ES | Futures | 1265.11 | 1271.4 | 1264.87 | 1270.93 | 39267.0 |
| 2008-01-30 08:30:00 | ES | Futures | 1270.93 | 1272.33 | 1266.04 | 1266.27 | 32427.0 |
| 2008-01-30 09:00:00 | ES | Futures | 1266.27 | 1268.14 | 1266.04 | 1266.04 | 16570.0 |
| 2008-01-30 09:30:00 | ES | Futures | 1266.04 | 1268.37 | 1262.77 | 1267.67 | 149039.0 |
| 2008-01-30 10:00:00 | ES | Futures | 1267.67 | 1271.4 | 1267.2 | 1269.77 | 130595.0 |
| 2008-01-30 10:30:00 | ES | Futures | 1269.77 | 1271.87 | 1268.14 | 1270.7 | 71300.0 |
| 2008-01-30 11:00:00 | ES | Futures | 1270.47 | 1271.17 | 1266.04 | 1266.27 | 74270.0 |
| 2008-01-30 11:30:00 | ES | Futures | 1266.27 | 1268.37 | 1264.64 | 1266.97 | 80191.0 |
| 2008-01-30 12:00:00 | ES | Futures | 1266.74 | 1269.07 | 1266.04 | 1266.97 | 57763.0 |
| 2008-01-30 12:30:00 | ES | Futures | 1266.97 | 1267.67 | 1265.8 | 1267.44 | 23133.0 |
| 2008-01-30 13:00:00 | ES | Futures | 1267.67 | 1270.23 | 1267.2 | 1268.6 | 40892.0 |
| 2008-01-30 13:30:00 | ES | Futures | 1268.6 | 1269.3 | 1266.04 | 1266.74 | 36164.0 |
| 2008-01-30 14:00:00 | ES | Futures | 1266.74 | 1286.79 | 1265.8 | 1283.29 | 399203.0 |
| 2008-01-30 14:30:00 | ES | Futures | 1283.52 | 1289.82 | 1273.97 | 1289.59 | 407289.0 |
| 2008-01-30 15:00:00 | ES | Futures | 1289.59 | 1294.02 | 1279.79 | 1281.89 | 315578.0 |
| 2008-01-30 15:30:00 | ES | Futures | 1281.66 | 1283.52 | 1261.84 | 1263.94 | 483696.0 |
| 2008-01-30 16:00:00 | ES | Futures | 1263.71 | 1263.94 | 1256.48 | 1259.28 | 127995.0 |
| 2008-01-30 16:30:00 | ES | Futures | 1258.81 | 1259.04 | 1253.68 | 1255.55 | 14405.0 |
| 2008-01-30 17:00:00 | ES | Futures | 1255.31 | 1255.55 | 1247.39 | 1247.85 | 21301.0 |
| 2008-01-30 18:00:00 | ES | Futures | 1248.78 | 1248.78 | 1243.19 | 1246.69 | 15694.0 |
| 2008-01-30 18:30:00 | ES | Futures | 1246.69 | 1247.62 | 1245.52 | 1246.45 | 4605.0 |
| 2008-01-30 19:00:00 | ES | Futures | 1246.69 | 1248.32 | 1245.52 | 1247.62 | 3834.0 |
| 2008-01-30 19:30:00 | ES | Futures | 1247.62 | 1249.48 | 1245.75 | 1249.25 | 4614.0 |
| 2008-01-30 20:00:00 | ES | Futures | 1249.48 | 1252.05 | 1249.25 | 1252.05 | 8078.0 |
| 2008-01-30 20:30:00 | ES | Futures | 1252.05 | 1252.05 | 1248.55 | 1252.05 | 2792.0 |
| 2008-01-30 21:00:00 | ES | Futures | 1251.82 | 1252.51 | 1249.72 | 1250.18 | 1941.0 |
| 2008-01-30 21:30:00 | ES | Futures | 1250.18 | 1251.12 | 1246.45 | 1246.69 | 2881.0 |
| 2008-01-30 22:00:00 | ES | Futures | 1246.92 | 1247.85 | 1245.99 | 1247.62 | 1530.0 |
| 2008-01-30 22:30:00 | ES | Futures | 1247.39 | 1251.35 | 1247.39 | 1251.12 | 1586.0 |
| 2008-01-30 23:00:00 | ES | Futures | 1251.12 | 1255.31 | 1250.65 | 1255.08 | 4475.0 |
| 2008-01-30 23:30:00 | ES | Futures | 1254.85 | 1256.01 | 1252.98 | 1252.98 | 2859.0 |
| 2008-01-30 00:00:00 | NQ | Futures | 2047.08 | 2048.78 | 2046.23 | 2046.51 | 147.0 |
| 2008-01-30 00:30:00 | NQ | Futures | 2046.51 | 2049.64 | 2046.23 | 2046.8 | 126.0 |
| 2008-01-30 01:00:00 | NQ | Futures | 2047.65 | 2047.65 | 2045.95 | 2047.08 | 64.0 |
> showing 50 of 1,516 rows — these rows as CSV