PREVIEW / futures_30min / 2008-04-30
file: by_date/futures_30min/2008/2008-04-30.parquet size: 67 KB rows: 2,267
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-04-30 00:00:00 | ES | Futures | 1299.04 | 1299.04 | 1297.87 | 1297.87 | 715.0 |
| 2008-04-30 00:30:00 | ES | Futures | 1297.87 | 1298.8 | 1297.41 | 1298.1 | 584.0 |
| 2008-04-30 01:00:00 | ES | Futures | 1298.34 | 1298.57 | 1297.64 | 1297.64 | 382.0 |
| 2008-04-30 01:30:00 | ES | Futures | 1297.64 | 1298.1 | 1296.94 | 1297.17 | 495.0 |
| 2008-04-30 02:00:00 | ES | Futures | 1297.41 | 1297.41 | 1295.54 | 1296.24 | 1323.0 |
| 2008-04-30 02:30:00 | ES | Futures | 1296.01 | 1297.41 | 1295.78 | 1297.41 | 926.0 |
| 2008-04-30 03:00:00 | ES | Futures | 1297.41 | 1298.1 | 1296.01 | 1297.87 | 2767.0 |
| 2008-04-30 03:30:00 | ES | Futures | 1297.41 | 1298.34 | 1296.47 | 1297.17 | 2282.0 |
| 2008-04-30 04:00:00 | ES | Futures | 1296.94 | 1297.17 | 1295.78 | 1296.94 | 1544.0 |
| 2008-04-30 04:30:00 | ES | Futures | 1296.94 | 1296.94 | 1295.08 | 1295.54 | 1845.0 |
| 2008-04-30 05:00:00 | ES | Futures | 1295.31 | 1296.01 | 1294.61 | 1295.54 | 1861.0 |
| 2008-04-30 05:30:00 | ES | Futures | 1295.78 | 1296.01 | 1293.91 | 1294.61 | 3386.0 |
| 2008-04-30 06:00:00 | ES | Futures | 1294.38 | 1294.61 | 1290.65 | 1291.35 | 14928.0 |
| 2008-04-30 06:30:00 | ES | Futures | 1291.35 | 1293.68 | 1291.12 | 1293.68 | 5321.0 |
| 2008-04-30 07:00:00 | ES | Futures | 1293.45 | 1295.78 | 1292.28 | 1294.15 | 11263.0 |
| 2008-04-30 07:30:00 | ES | Futures | 1294.15 | 1295.08 | 1292.75 | 1293.21 | 13984.0 |
| 2008-04-30 08:00:00 | ES | Futures | 1293.21 | 1297.87 | 1292.98 | 1296.94 | 35573.0 |
| 2008-04-30 08:30:00 | ES | Futures | 1296.94 | 1301.6 | 1296.94 | 1299.5 | 69898.0 |
| 2008-04-30 09:00:00 | ES | Futures | 1299.73 | 1299.97 | 1297.41 | 1297.87 | 21671.0 |
| 2008-04-30 09:30:00 | ES | Futures | 1297.87 | 1301.83 | 1297.41 | 1299.27 | 111656.0 |
| 2008-04-30 10:00:00 | ES | Futures | 1299.27 | 1300.9 | 1297.64 | 1298.8 | 85595.0 |
| 2008-04-30 10:30:00 | ES | Futures | 1298.8 | 1301.6 | 1298.8 | 1300.2 | 73336.0 |
| 2008-04-30 11:00:00 | ES | Futures | 1300.2 | 1304.16 | 1300.2 | 1302.99 | 90836.0 |
| 2008-04-30 11:30:00 | ES | Futures | 1302.99 | 1303.46 | 1300.66 | 1302.76 | 44473.0 |
| 2008-04-30 12:00:00 | ES | Futures | 1302.76 | 1303.46 | 1299.5 | 1299.97 | 52691.0 |
| 2008-04-30 12:30:00 | ES | Futures | 1299.97 | 1300.9 | 1299.5 | 1300.2 | 25191.0 |
| 2008-04-30 13:00:00 | ES | Futures | 1300.43 | 1302.53 | 1299.97 | 1301.6 | 35978.0 |
| 2008-04-30 13:30:00 | ES | Futures | 1301.6 | 1302.76 | 1300.2 | 1300.66 | 44027.0 |
| 2008-04-30 14:00:00 | ES | Futures | 1300.66 | 1310.44 | 1298.8 | 1305.32 | 263781.0 |
| 2008-04-30 14:30:00 | ES | Futures | 1305.55 | 1307.65 | 1296.94 | 1296.94 | 212738.0 |
| 2008-04-30 15:00:00 | ES | Futures | 1296.94 | 1297.87 | 1289.26 | 1290.65 | 283572.0 |
| 2008-04-30 15:30:00 | ES | Futures | 1290.65 | 1295.08 | 1289.02 | 1289.72 | 263147.0 |
| 2008-04-30 16:00:00 | ES | Futures | 1289.72 | 1291.82 | 1288.56 | 1289.49 | 118810.0 |
| 2008-04-30 16:30:00 | ES | Futures | 1288.09 | 1290.42 | 1287.39 | 1289.26 | 8430.0 |
| 2008-04-30 17:00:00 | ES | Futures | 1289.02 | 1289.95 | 1289.02 | 1289.95 | 1251.0 |
| 2008-04-30 17:30:00 | ES | Futures | 1289.95 | 1289.95 | 1289.95 | 1289.95 | 12.0 |
| 2008-04-30 18:00:00 | ES | Futures | 1289.95 | 1291.12 | 1289.72 | 1290.65 | 1395.0 |
| 2008-04-30 18:30:00 | ES | Futures | 1290.89 | 1291.58 | 1290.42 | 1290.65 | 701.0 |
| 2008-04-30 19:00:00 | ES | Futures | 1290.65 | 1291.35 | 1290.42 | 1291.12 | 629.0 |
| 2008-04-30 19:30:00 | ES | Futures | 1291.12 | 1291.12 | 1290.19 | 1290.65 | 484.0 |
| 2008-04-30 20:00:00 | ES | Futures | 1290.89 | 1291.82 | 1290.89 | 1291.58 | 702.0 |
| 2008-04-30 20:30:00 | ES | Futures | 1291.58 | 1291.58 | 1290.65 | 1291.35 | 334.0 |
| 2008-04-30 21:00:00 | ES | Futures | 1291.12 | 1291.35 | 1289.95 | 1290.19 | 572.0 |
| 2008-04-30 21:30:00 | ES | Futures | 1290.19 | 1290.65 | 1289.95 | 1290.42 | 359.0 |
| 2008-04-30 22:00:00 | ES | Futures | 1290.42 | 1291.35 | 1290.19 | 1291.12 | 258.0 |
| 2008-04-30 22:30:00 | ES | Futures | 1291.35 | 1291.35 | 1290.42 | 1290.65 | 143.0 |
| 2008-04-30 23:00:00 | ES | Futures | 1290.65 | 1290.89 | 1290.65 | 1290.89 | 128.0 |
| 2008-04-30 23:30:00 | ES | Futures | 1290.89 | 1291.35 | 1290.65 | 1290.89 | 575.0 |
| 2008-04-30 00:00:00 | NQ | Futures | 2200.41 | 2200.69 | 2197.01 | 2197.01 | 195.0 |
| 2008-04-30 00:30:00 | NQ | Futures | 2197.58 | 2199.56 | 2197.3 | 2198.71 | 44.0 |
> showing 50 of 2,267 rows — these rows as CSV