PREVIEW / futures_30min / 2008-04-24
file: by_date/futures_30min/2008/2008-04-24.parquet size: 69 KB rows: 2,250
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-24 00:00:00 | ES | Futures | 1279.71 | 1279.94 | 1279.48 | 1279.48 | 530.0 |
| 2008-04-24 00:30:00 | ES | Futures | 1279.48 | 1279.71 | 1279.24 | 1279.48 | 349.0 |
| 2008-04-24 01:00:00 | ES | Futures | 1279.48 | 1280.17 | 1279.24 | 1279.48 | 703.0 |
| 2008-04-24 01:30:00 | ES | Futures | 1279.71 | 1280.87 | 1279.48 | 1279.94 | 1016.0 |
| 2008-04-24 02:00:00 | ES | Futures | 1279.71 | 1282.5 | 1279.48 | 1282.27 | 1859.0 |
| 2008-04-24 02:30:00 | ES | Futures | 1282.04 | 1283.43 | 1282.04 | 1282.74 | 1982.0 |
| 2008-04-24 03:00:00 | ES | Futures | 1282.74 | 1284.37 | 1282.27 | 1284.37 | 5525.0 |
| 2008-04-24 03:30:00 | ES | Futures | 1284.37 | 1284.83 | 1280.87 | 1281.8 | 7009.0 |
| 2008-04-24 04:00:00 | ES | Futures | 1281.8 | 1281.8 | 1277.61 | 1278.54 | 11578.0 |
| 2008-04-24 04:30:00 | ES | Futures | 1278.78 | 1281.34 | 1277.85 | 1280.87 | 7227.0 |
| 2008-04-24 05:00:00 | ES | Futures | 1280.64 | 1282.04 | 1280.17 | 1281.11 | 4385.0 |
| 2008-04-24 05:30:00 | ES | Futures | 1281.34 | 1281.34 | 1279.01 | 1280.17 | 4022.0 |
| 2008-04-24 06:00:00 | ES | Futures | 1279.94 | 1280.17 | 1277.61 | 1279.24 | 11175.0 |
| 2008-04-24 06:30:00 | ES | Futures | 1279.24 | 1279.94 | 1274.12 | 1275.05 | 11993.0 |
| 2008-04-24 07:00:00 | ES | Futures | 1275.05 | 1278.54 | 1274.59 | 1278.31 | 10000.0 |
| 2008-04-24 07:30:00 | ES | Futures | 1278.31 | 1279.24 | 1276.45 | 1277.38 | 8033.0 |
| 2008-04-24 08:00:00 | ES | Futures | 1277.38 | 1279.01 | 1275.52 | 1276.68 | 19738.0 |
| 2008-04-24 08:30:00 | ES | Futures | 1276.91 | 1284.37 | 1276.91 | 1282.5 | 74665.0 |
| 2008-04-24 09:00:00 | ES | Futures | 1282.5 | 1290.65 | 1281.8 | 1287.63 | 62193.0 |
| 2008-04-24 09:30:00 | ES | Futures | 1287.86 | 1289.49 | 1282.5 | 1285.76 | 168888.0 |
| 2008-04-24 10:00:00 | ES | Futures | 1285.53 | 1285.53 | 1278.08 | 1280.64 | 209327.0 |
| 2008-04-24 10:30:00 | ES | Futures | 1280.41 | 1281.11 | 1277.85 | 1280.64 | 123979.0 |
| 2008-04-24 11:00:00 | ES | Futures | 1280.64 | 1286.23 | 1280.17 | 1286.23 | 129536.0 |
| 2008-04-24 11:30:00 | ES | Futures | 1286.23 | 1293.45 | 1285.76 | 1291.12 | 208303.0 |
| 2008-04-24 12:00:00 | ES | Futures | 1291.12 | 1297.87 | 1290.89 | 1295.54 | 168896.0 |
| 2008-04-24 12:30:00 | ES | Futures | 1295.31 | 1299.73 | 1294.84 | 1297.41 | 102977.0 |
| 2008-04-24 13:00:00 | ES | Futures | 1297.17 | 1300.2 | 1294.84 | 1296.01 | 78556.0 |
| 2008-04-24 13:30:00 | ES | Futures | 1296.01 | 1299.04 | 1293.91 | 1298.34 | 79623.0 |
| 2008-04-24 14:00:00 | ES | Futures | 1298.57 | 1302.99 | 1297.64 | 1302.06 | 108987.0 |
| 2008-04-24 14:30:00 | ES | Futures | 1302.06 | 1303.23 | 1299.5 | 1300.66 | 88249.0 |
| 2008-04-24 15:00:00 | ES | Futures | 1300.43 | 1303.23 | 1297.87 | 1299.73 | 103805.0 |
| 2008-04-24 15:30:00 | ES | Futures | 1299.97 | 1300.9 | 1293.45 | 1294.38 | 167213.0 |
| 2008-04-24 16:00:00 | ES | Futures | 1294.38 | 1294.84 | 1289.95 | 1290.42 | 110803.0 |
| 2008-04-24 16:30:00 | ES | Futures | 1291.35 | 1291.35 | 1288.09 | 1288.56 | 11735.0 |
| 2008-04-24 17:00:00 | ES | Futures | 1288.56 | 1290.42 | 1288.32 | 1289.02 | 2562.0 |
| 2008-04-24 18:00:00 | ES | Futures | 1289.26 | 1290.42 | 1289.26 | 1290.19 | 491.0 |
| 2008-04-24 18:30:00 | ES | Futures | 1290.19 | 1290.65 | 1289.49 | 1289.95 | 550.0 |
| 2008-04-24 19:00:00 | ES | Futures | 1289.72 | 1290.19 | 1289.02 | 1289.72 | 348.0 |
| 2008-04-24 19:30:00 | ES | Futures | 1289.49 | 1289.72 | 1288.56 | 1289.49 | 564.0 |
| 2008-04-24 20:00:00 | ES | Futures | 1289.49 | 1291.82 | 1288.56 | 1291.12 | 1424.0 |
| 2008-04-24 20:30:00 | ES | Futures | 1291.12 | 1291.58 | 1290.19 | 1290.65 | 359.0 |
| 2008-04-24 21:00:00 | ES | Futures | 1290.65 | 1291.12 | 1289.72 | 1290.19 | 395.0 |
| 2008-04-24 21:30:00 | ES | Futures | 1290.42 | 1291.12 | 1290.19 | 1290.89 | 399.0 |
| 2008-04-24 22:00:00 | ES | Futures | 1290.65 | 1291.12 | 1289.72 | 1289.72 | 289.0 |
| 2008-04-24 22:30:00 | ES | Futures | 1289.72 | 1290.65 | 1289.72 | 1290.19 | 137.0 |
| 2008-04-24 23:00:00 | ES | Futures | 1290.19 | 1290.42 | 1288.32 | 1289.02 | 910.0 |
| 2008-04-24 23:30:00 | ES | Futures | 1289.26 | 1292.75 | 1289.26 | 1292.52 | 1485.0 |
| 2008-04-24 00:00:00 | NQ | Futures | 2141.58 | 2142.14 | 2140.45 | 2141.86 | 90.0 |
| 2008-04-24 00:30:00 | NQ | Futures | 2141.86 | 2142.71 | 2141.86 | 2142.71 | 50.0 |
| 2008-04-24 01:00:00 | NQ | Futures | 2142.71 | 2143.56 | 2141.3 | 2143.56 | 53.0 |
> showing 50 of 2,250 rows — these rows as CSV