PREVIEW / futures_30min / 2008-05-01
file: by_date/futures_30min/2008/2008-05-01.parquet size: 61 KB rows: 2,025
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-05-01 00:00:00 | ES | Futures | 1290.89 | 1290.89 | 1290.19 | 1290.19 | 123.0 |
| 2008-05-01 00:30:00 | ES | Futures | 1290.42 | 1290.65 | 1289.95 | 1289.95 | 260.0 |
| 2008-05-01 01:00:00 | ES | Futures | 1290.19 | 1291.82 | 1289.95 | 1290.65 | 340.0 |
| 2008-05-01 01:30:00 | ES | Futures | 1290.65 | 1292.05 | 1290.42 | 1292.05 | 465.0 |
| 2008-05-01 02:00:00 | ES | Futures | 1292.05 | 1292.98 | 1291.35 | 1291.82 | 780.0 |
| 2008-05-01 02:30:00 | ES | Futures | 1291.82 | 1292.05 | 1291.12 | 1291.35 | 872.0 |
| 2008-05-01 03:00:00 | ES | Futures | 1291.58 | 1293.68 | 1290.89 | 1292.52 | 3838.0 |
| 2008-05-01 03:30:00 | ES | Futures | 1292.52 | 1293.45 | 1291.82 | 1293.21 | 1128.0 |
| 2008-05-01 04:00:00 | ES | Futures | 1293.21 | 1293.68 | 1291.35 | 1292.28 | 1931.0 |
| 2008-05-01 04:30:00 | ES | Futures | 1292.28 | 1292.28 | 1291.58 | 1291.82 | 437.0 |
| 2008-05-01 05:00:00 | ES | Futures | 1291.82 | 1292.05 | 1291.35 | 1292.05 | 666.0 |
| 2008-05-01 05:30:00 | ES | Futures | 1292.28 | 1293.91 | 1292.05 | 1293.68 | 1594.0 |
| 2008-05-01 06:00:00 | ES | Futures | 1293.68 | 1293.68 | 1292.75 | 1292.75 | 1187.0 |
| 2008-05-01 06:30:00 | ES | Futures | 1292.75 | 1294.38 | 1292.52 | 1294.15 | 3083.0 |
| 2008-05-01 07:00:00 | ES | Futures | 1294.15 | 1294.38 | 1292.98 | 1293.68 | 4049.0 |
| 2008-05-01 07:30:00 | ES | Futures | 1293.91 | 1294.15 | 1292.98 | 1293.91 | 3334.0 |
| 2008-05-01 08:00:00 | ES | Futures | 1293.68 | 1294.38 | 1291.35 | 1292.28 | 17909.0 |
| 2008-05-01 08:30:00 | ES | Futures | 1292.28 | 1292.75 | 1289.49 | 1289.95 | 28742.0 |
| 2008-05-01 09:00:00 | ES | Futures | 1290.19 | 1290.42 | 1288.32 | 1289.49 | 19954.0 |
| 2008-05-01 09:30:00 | ES | Futures | 1289.26 | 1294.61 | 1288.09 | 1292.52 | 168749.0 |
| 2008-05-01 10:00:00 | ES | Futures | 1292.52 | 1296.94 | 1291.82 | 1296.47 | 226812.0 |
| 2008-05-01 10:30:00 | ES | Futures | 1296.24 | 1296.71 | 1293.21 | 1296.01 | 114345.0 |
| 2008-05-01 11:00:00 | ES | Futures | 1295.78 | 1299.04 | 1294.61 | 1297.64 | 114281.0 |
| 2008-05-01 11:30:00 | ES | Futures | 1297.41 | 1299.97 | 1296.71 | 1297.64 | 77440.0 |
| 2008-05-01 12:00:00 | ES | Futures | 1297.87 | 1301.83 | 1297.64 | 1301.13 | 77587.0 |
| 2008-05-01 12:30:00 | ES | Futures | 1301.13 | 1310.21 | 1300.9 | 1308.58 | 188008.0 |
| 2008-05-01 13:00:00 | ES | Futures | 1308.81 | 1313.94 | 1306.95 | 1310.91 | 162066.0 |
| 2008-05-01 13:30:00 | ES | Futures | 1310.91 | 1311.14 | 1307.42 | 1307.88 | 80432.0 |
| 2008-05-01 14:00:00 | ES | Futures | 1307.88 | 1311.61 | 1306.72 | 1309.05 | 114027.0 |
| 2008-05-01 14:30:00 | ES | Futures | 1309.28 | 1314.17 | 1308.81 | 1310.68 | 134849.0 |
| 2008-05-01 15:00:00 | ES | Futures | 1310.44 | 1312.31 | 1309.05 | 1311.38 | 92020.0 |
| 2008-05-01 15:30:00 | ES | Futures | 1311.14 | 1314.4 | 1307.88 | 1313.47 | 158449.0 |
| 2008-05-01 16:00:00 | ES | Futures | 1313.24 | 1315.33 | 1312.54 | 1315.1 | 86720.0 |
| 2008-05-01 16:30:00 | ES | Futures | 1314.4 | 1315.1 | 1313.94 | 1314.4 | 4328.0 |
| 2008-05-01 17:00:00 | ES | Futures | 1314.4 | 1314.87 | 1314.4 | 1314.87 | 798.0 |
| 2008-05-01 18:00:00 | ES | Futures | 1314.4 | 1314.64 | 1313.7 | 1314.17 | 879.0 |
| 2008-05-01 18:30:00 | ES | Futures | 1314.17 | 1315.1 | 1314.17 | 1314.87 | 502.0 |
| 2008-05-01 19:00:00 | ES | Futures | 1315.1 | 1315.33 | 1314.64 | 1314.87 | 1396.0 |
| 2008-05-01 19:30:00 | ES | Futures | 1314.87 | 1314.87 | 1314.17 | 1314.87 | 391.0 |
| 2008-05-01 20:00:00 | ES | Futures | 1314.87 | 1317.9 | 1314.64 | 1316.27 | 2959.0 |
| 2008-05-01 20:30:00 | ES | Futures | 1316.27 | 1316.73 | 1315.8 | 1316.27 | 613.0 |
| 2008-05-01 21:00:00 | ES | Futures | 1316.27 | 1316.73 | 1315.57 | 1316.27 | 594.0 |
| 2008-05-01 21:30:00 | ES | Futures | 1316.27 | 1316.96 | 1315.8 | 1316.73 | 546.0 |
| 2008-05-01 22:00:00 | ES | Futures | 1316.73 | 1316.73 | 1315.8 | 1316.5 | 740.0 |
| 2008-05-01 22:30:00 | ES | Futures | 1316.27 | 1316.5 | 1315.8 | 1316.27 | 490.0 |
| 2008-05-01 23:00:00 | ES | Futures | 1316.03 | 1316.27 | 1316.03 | 1316.03 | 323.0 |
| 2008-05-01 23:30:00 | ES | Futures | 1316.03 | 1316.96 | 1315.8 | 1316.73 | 787.0 |
| 2008-05-01 00:00:00 | NQ | Futures | 2178.91 | 2179.48 | 2178.35 | 2178.35 | 12.0 |
| 2008-05-01 00:30:00 | NQ | Futures | 2178.06 | 2179.48 | 2178.06 | 2178.63 | 15.0 |
| 2008-05-01 01:00:00 | NQ | Futures | 2178.63 | 2179.48 | 2178.35 | 2179.48 | 29.0 |
> showing 50 of 2,025 rows — these rows as CSV