PREVIEW / futures_30min / 2008-05-29
file: by_date/futures_30min/2008/2008-05-29.parquet size: 66 KB rows: 2,221
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-29 00:00:00 | ES | Futures | 1294.84 | 1295.08 | 1293.68 | 1293.91 | 423.0 |
| 2008-05-29 00:30:00 | ES | Futures | 1293.91 | 1294.84 | 1293.91 | 1294.61 | 289.0 |
| 2008-05-29 01:00:00 | ES | Futures | 1294.38 | 1296.94 | 1294.15 | 1296.94 | 864.0 |
| 2008-05-29 01:30:00 | ES | Futures | 1296.71 | 1296.71 | 1296.01 | 1296.24 | 613.0 |
| 2008-05-29 02:00:00 | ES | Futures | 1296.24 | 1297.41 | 1296.01 | 1297.41 | 2098.0 |
| 2008-05-29 02:30:00 | ES | Futures | 1297.41 | 1297.41 | 1295.54 | 1296.47 | 3531.0 |
| 2008-05-29 03:00:00 | ES | Futures | 1296.47 | 1296.71 | 1293.91 | 1296.47 | 5906.0 |
| 2008-05-29 03:30:00 | ES | Futures | 1296.47 | 1296.94 | 1295.78 | 1296.24 | 4664.0 |
| 2008-05-29 04:00:00 | ES | Futures | 1296.47 | 1300.2 | 1296.47 | 1298.34 | 11224.0 |
| 2008-05-29 04:30:00 | ES | Futures | 1298.57 | 1298.8 | 1297.41 | 1297.64 | 3812.0 |
| 2008-05-29 05:00:00 | ES | Futures | 1297.64 | 1297.87 | 1296.01 | 1296.94 | 4480.0 |
| 2008-05-29 05:30:00 | ES | Futures | 1296.94 | 1297.64 | 1295.78 | 1296.94 | 3722.0 |
| 2008-05-29 06:00:00 | ES | Futures | 1296.94 | 1297.17 | 1294.38 | 1295.08 | 8284.0 |
| 2008-05-29 06:30:00 | ES | Futures | 1295.31 | 1295.78 | 1293.91 | 1294.84 | 4317.0 |
| 2008-05-29 07:00:00 | ES | Futures | 1294.84 | 1295.78 | 1294.61 | 1295.54 | 2757.0 |
| 2008-05-29 07:30:00 | ES | Futures | 1295.54 | 1297.17 | 1295.31 | 1296.71 | 8725.0 |
| 2008-05-29 08:00:00 | ES | Futures | 1296.71 | 1297.64 | 1296.01 | 1297.64 | 16095.0 |
| 2008-05-29 08:30:00 | ES | Futures | 1297.41 | 1298.1 | 1292.28 | 1292.52 | 40688.0 |
| 2008-05-29 09:00:00 | ES | Futures | 1292.52 | 1293.45 | 1291.58 | 1293.45 | 27873.0 |
| 2008-05-29 09:30:00 | ES | Futures | 1293.21 | 1298.1 | 1292.98 | 1297.17 | 135810.0 |
| 2008-05-29 10:00:00 | ES | Futures | 1297.17 | 1299.27 | 1293.21 | 1297.87 | 156209.0 |
| 2008-05-29 10:30:00 | ES | Futures | 1297.87 | 1302.76 | 1292.98 | 1301.13 | 245227.0 |
| 2008-05-29 11:00:00 | ES | Futures | 1301.13 | 1303.23 | 1300.2 | 1301.83 | 131853.0 |
| 2008-05-29 11:30:00 | ES | Futures | 1301.6 | 1305.09 | 1300.9 | 1304.16 | 107741.0 |
| 2008-05-29 12:00:00 | ES | Futures | 1304.39 | 1304.86 | 1303.23 | 1304.16 | 50979.0 |
| 2008-05-29 12:30:00 | ES | Futures | 1304.39 | 1309.05 | 1303.92 | 1308.12 | 112634.0 |
| 2008-05-29 13:00:00 | ES | Futures | 1308.12 | 1309.05 | 1306.02 | 1306.49 | 65129.0 |
| 2008-05-29 13:30:00 | ES | Futures | 1306.49 | 1308.35 | 1305.79 | 1306.95 | 58044.0 |
| 2008-05-29 14:00:00 | ES | Futures | 1307.18 | 1310.44 | 1306.25 | 1307.65 | 90691.0 |
| 2008-05-29 14:30:00 | ES | Futures | 1307.65 | 1308.35 | 1304.16 | 1305.32 | 88854.0 |
| 2008-05-29 15:00:00 | ES | Futures | 1305.32 | 1305.55 | 1301.36 | 1302.06 | 112542.0 |
| 2008-05-29 15:30:00 | ES | Futures | 1302.06 | 1304.62 | 1301.36 | 1302.06 | 114168.0 |
| 2008-05-29 16:00:00 | ES | Futures | 1302.29 | 1303.69 | 1301.13 | 1301.6 | 71994.0 |
| 2008-05-29 16:30:00 | ES | Futures | 1301.83 | 1302.99 | 1301.6 | 1302.76 | 3174.0 |
| 2008-05-29 17:00:00 | ES | Futures | 1302.76 | 1303.46 | 1301.83 | 1302.76 | 3105.0 |
| 2008-05-29 18:00:00 | ES | Futures | 1302.53 | 1302.76 | 1301.83 | 1301.83 | 957.0 |
| 2008-05-29 18:30:00 | ES | Futures | 1301.83 | 1302.06 | 1299.27 | 1299.97 | 5301.0 |
| 2008-05-29 19:00:00 | ES | Futures | 1299.97 | 1301.13 | 1299.73 | 1301.13 | 447.0 |
| 2008-05-29 19:30:00 | ES | Futures | 1301.13 | 1301.36 | 1300.43 | 1300.66 | 349.0 |
| 2008-05-29 20:00:00 | ES | Futures | 1300.43 | 1301.36 | 1300.2 | 1301.13 | 360.0 |
| 2008-05-29 20:30:00 | ES | Futures | 1301.13 | 1302.53 | 1301.13 | 1301.83 | 557.0 |
| 2008-05-29 21:00:00 | ES | Futures | 1301.83 | 1301.83 | 1301.13 | 1301.6 | 490.0 |
| 2008-05-29 21:30:00 | ES | Futures | 1301.36 | 1302.06 | 1300.9 | 1300.9 | 307.0 |
| 2008-05-29 22:00:00 | ES | Futures | 1300.9 | 1301.13 | 1300.2 | 1300.66 | 505.0 |
| 2008-05-29 22:30:00 | ES | Futures | 1300.9 | 1301.13 | 1300.66 | 1300.66 | 387.0 |
| 2008-05-29 23:00:00 | ES | Futures | 1300.66 | 1301.36 | 1300.43 | 1300.9 | 194.0 |
| 2008-05-29 23:30:00 | ES | Futures | 1300.9 | 1302.53 | 1300.66 | 1302.06 | 600.0 |
| 2008-05-29 00:00:00 | NQ | Futures | 2267.15 | 2268.0 | 2265.46 | 2265.46 | 37.0 |
| 2008-05-29 00:30:00 | NQ | Futures | 2265.46 | 2267.15 | 2265.46 | 2266.02 | 13.0 |
| 2008-05-29 01:00:00 | NQ | Futures | 2265.74 | 2269.13 | 2265.74 | 2269.13 | 41.0 |
> showing 50 of 2,221 rows — these rows as CSV