PREVIEW / futures_30min / 2011-02-23
file: by_date/futures_30min/2011/2011-02-23.parquet size: 78 KB rows: 2,748
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 |
|---|---|---|---|---|---|---|---|
| 2011-02-23 00:00:00 | ES | Futures | 1304.93 | 1304.93 | 1304.19 | 1304.68 | 2576.0 |
| 2011-02-23 00:30:00 | ES | Futures | 1304.44 | 1305.67 | 1304.44 | 1305.43 | 3537.0 |
| 2011-02-23 01:00:00 | ES | Futures | 1305.18 | 1305.43 | 1304.44 | 1304.68 | 1981.0 |
| 2011-02-23 01:30:00 | ES | Futures | 1304.93 | 1304.93 | 1303.94 | 1304.19 | 5118.0 |
| 2011-02-23 02:00:00 | ES | Futures | 1304.44 | 1304.93 | 1303.94 | 1304.93 | 5232.0 |
| 2011-02-23 02:30:00 | ES | Futures | 1304.93 | 1305.43 | 1304.68 | 1304.93 | 5644.0 |
| 2011-02-23 03:00:00 | ES | Futures | 1304.93 | 1305.92 | 1304.44 | 1305.18 | 16354.0 |
| 2011-02-23 03:30:00 | ES | Futures | 1305.18 | 1305.43 | 1303.94 | 1305.18 | 12628.0 |
| 2011-02-23 04:00:00 | ES | Futures | 1304.93 | 1305.43 | 1303.45 | 1304.19 | 11147.0 |
| 2011-02-23 04:30:00 | ES | Futures | 1304.44 | 1305.18 | 1303.69 | 1304.93 | 9995.0 |
| 2011-02-23 05:00:00 | ES | Futures | 1304.68 | 1305.92 | 1304.68 | 1305.18 | 7393.0 |
| 2011-02-23 05:30:00 | ES | Futures | 1305.18 | 1305.67 | 1304.19 | 1304.93 | 6690.0 |
| 2011-02-23 06:00:00 | ES | Futures | 1304.93 | 1306.41 | 1304.44 | 1305.92 | 12388.0 |
| 2011-02-23 06:30:00 | ES | Futures | 1306.17 | 1306.91 | 1305.92 | 1306.66 | 13114.0 |
| 2011-02-23 07:00:00 | ES | Futures | 1306.41 | 1306.66 | 1305.67 | 1306.41 | 9783.0 |
| 2011-02-23 07:30:00 | ES | Futures | 1306.66 | 1306.91 | 1305.18 | 1305.18 | 15886.0 |
| 2011-02-23 08:00:00 | ES | Futures | 1305.18 | 1305.43 | 1302.95 | 1303.2 | 33961.0 |
| 2011-02-23 08:30:00 | ES | Futures | 1303.45 | 1303.45 | 1302.21 | 1302.46 | 26861.0 |
| 2011-02-23 09:00:00 | ES | Futures | 1302.7 | 1302.95 | 1298.99 | 1299.73 | 72688.0 |
| 2011-02-23 09:30:00 | ES | Futures | 1299.73 | 1302.95 | 1297.01 | 1297.76 | 318548.0 |
| 2011-02-23 10:00:00 | ES | Futures | 1297.76 | 1300.23 | 1294.29 | 1298.99 | 259225.0 |
| 2011-02-23 10:30:00 | ES | Futures | 1298.74 | 1300.72 | 1294.79 | 1298.99 | 172781.0 |
| 2011-02-23 11:00:00 | ES | Futures | 1298.74 | 1299.98 | 1296.27 | 1297.01 | 124130.0 |
| 2011-02-23 11:30:00 | ES | Futures | 1296.77 | 1297.01 | 1291.82 | 1292.31 | 259661.0 |
| 2011-02-23 12:00:00 | ES | Futures | 1292.31 | 1292.56 | 1286.87 | 1290.08 | 291289.0 |
| 2011-02-23 12:30:00 | ES | Futures | 1290.08 | 1291.57 | 1287.61 | 1289.59 | 141120.0 |
| 2011-02-23 13:00:00 | ES | Futures | 1289.59 | 1290.58 | 1284.15 | 1288.85 | 195451.0 |
| 2011-02-23 13:30:00 | ES | Futures | 1288.85 | 1292.31 | 1286.87 | 1290.83 | 139353.0 |
| 2011-02-23 14:00:00 | ES | Futures | 1290.83 | 1294.29 | 1290.33 | 1292.56 | 136624.0 |
| 2011-02-23 14:30:00 | ES | Futures | 1292.31 | 1295.53 | 1290.58 | 1295.53 | 150210.0 |
| 2011-02-23 15:00:00 | ES | Futures | 1295.53 | 1298.0 | 1293.8 | 1295.53 | 167495.0 |
| 2011-02-23 15:30:00 | ES | Futures | 1295.28 | 1295.78 | 1291.82 | 1292.81 | 261174.0 |
| 2011-02-23 16:00:00 | ES | Futures | 1292.81 | 1293.8 | 1291.07 | 1291.82 | 113914.0 |
| 2011-02-23 16:30:00 | ES | Futures | 1292.31 | 1293.8 | 1291.82 | 1293.05 | 5978.0 |
| 2011-02-23 17:00:00 | ES | Futures | 1293.05 | 1293.8 | 1292.81 | 1293.3 | 1909.0 |
| 2011-02-23 18:00:00 | ES | Futures | 1293.55 | 1295.28 | 1293.55 | 1295.03 | 6093.0 |
| 2011-02-23 18:30:00 | ES | Futures | 1295.03 | 1295.28 | 1294.29 | 1294.79 | 2555.0 |
| 2011-02-23 19:00:00 | ES | Futures | 1294.79 | 1295.03 | 1293.55 | 1294.54 | 13164.0 |
| 2011-02-23 19:30:00 | ES | Futures | 1294.29 | 1295.03 | 1293.8 | 1293.8 | 2310.0 |
| 2011-02-23 20:00:00 | ES | Futures | 1294.04 | 1295.28 | 1293.8 | 1294.79 | 5733.0 |
| 2011-02-23 20:30:00 | ES | Futures | 1294.79 | 1295.78 | 1294.54 | 1295.78 | 3451.0 |
| 2011-02-23 21:00:00 | ES | Futures | 1295.78 | 1296.02 | 1295.28 | 1295.53 | 5750.0 |
| 2011-02-23 21:30:00 | ES | Futures | 1295.53 | 1296.27 | 1295.28 | 1295.78 | 2140.0 |
| 2011-02-23 22:00:00 | ES | Futures | 1296.02 | 1296.52 | 1295.53 | 1296.27 | 3746.0 |
| 2011-02-23 22:30:00 | ES | Futures | 1296.27 | 1297.26 | 1295.78 | 1297.01 | 4349.0 |
| 2011-02-23 23:00:00 | ES | Futures | 1296.77 | 1297.01 | 1296.02 | 1296.52 | 5840.0 |
| 2011-02-23 23:30:00 | ES | Futures | 1296.27 | 1296.52 | 1295.78 | 1296.02 | 2043.0 |
| 2011-02-23 00:00:00 | NQ | Futures | 2671.41 | 2671.7 | 2670.55 | 2670.84 | 60.0 |
| 2011-02-23 00:30:00 | NQ | Futures | 2670.84 | 2671.99 | 2670.84 | 2671.99 | 157.0 |
| 2011-02-23 01:00:00 | NQ | Futures | 2671.7 | 2671.7 | 2669.98 | 2670.55 | 232.0 |
> showing 50 of 2,748 rows — these rows as CSV