PREVIEW / futures_30min / 2011-02-09
file: by_date/futures_30min/2011/2011-02-09.parquet size: 75 KB rows: 2,771
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-09 00:00:00 | ES | Futures | 1304.93 | 1305.67 | 1304.44 | 1305.67 | 2011.0 |
| 2011-02-09 00:30:00 | ES | Futures | 1305.67 | 1306.17 | 1304.44 | 1304.93 | 2227.0 |
| 2011-02-09 01:00:00 | ES | Futures | 1305.18 | 1305.18 | 1304.44 | 1304.93 | 1521.0 |
| 2011-02-09 01:30:00 | ES | Futures | 1304.68 | 1305.67 | 1304.68 | 1305.43 | 1303.0 |
| 2011-02-09 02:00:00 | ES | Futures | 1305.67 | 1305.67 | 1304.68 | 1304.93 | 2891.0 |
| 2011-02-09 02:30:00 | ES | Futures | 1304.68 | 1304.93 | 1303.94 | 1304.19 | 4886.0 |
| 2011-02-09 03:00:00 | ES | Futures | 1303.94 | 1305.92 | 1303.94 | 1305.43 | 12818.0 |
| 2011-02-09 03:30:00 | ES | Futures | 1305.43 | 1306.91 | 1304.93 | 1304.93 | 10308.0 |
| 2011-02-09 04:00:00 | ES | Futures | 1304.93 | 1305.43 | 1304.19 | 1304.19 | 6541.0 |
| 2011-02-09 04:30:00 | ES | Futures | 1304.19 | 1304.93 | 1303.45 | 1304.19 | 9937.0 |
| 2011-02-09 05:00:00 | ES | Futures | 1304.44 | 1305.67 | 1304.19 | 1304.44 | 7125.0 |
| 2011-02-09 05:30:00 | ES | Futures | 1304.44 | 1304.68 | 1302.7 | 1302.95 | 11322.0 |
| 2011-02-09 06:00:00 | ES | Futures | 1302.7 | 1303.69 | 1302.46 | 1302.46 | 10585.0 |
| 2011-02-09 06:30:00 | ES | Futures | 1302.7 | 1303.69 | 1302.46 | 1303.69 | 7941.0 |
| 2011-02-09 07:00:00 | ES | Futures | 1303.45 | 1304.93 | 1303.45 | 1304.19 | 9439.0 |
| 2011-02-09 07:30:00 | ES | Futures | 1304.44 | 1304.44 | 1302.95 | 1303.69 | 8558.0 |
| 2011-02-09 08:00:00 | ES | Futures | 1303.69 | 1303.94 | 1302.46 | 1302.7 | 13097.0 |
| 2011-02-09 08:30:00 | ES | Futures | 1302.95 | 1304.44 | 1302.7 | 1303.69 | 19610.0 |
| 2011-02-09 09:00:00 | ES | Futures | 1303.69 | 1304.44 | 1303.2 | 1304.19 | 15198.0 |
| 2011-02-09 09:30:00 | ES | Futures | 1304.19 | 1305.92 | 1303.69 | 1305.43 | 154319.0 |
| 2011-02-09 10:00:00 | ES | Futures | 1305.67 | 1307.4 | 1304.93 | 1306.17 | 138599.0 |
| 2011-02-09 10:30:00 | ES | Futures | 1306.17 | 1308.39 | 1305.67 | 1306.66 | 121912.0 |
| 2011-02-09 11:00:00 | ES | Futures | 1306.66 | 1307.16 | 1300.97 | 1301.71 | 206470.0 |
| 2011-02-09 11:30:00 | ES | Futures | 1301.71 | 1303.2 | 1301.22 | 1301.22 | 125265.0 |
| 2011-02-09 12:00:00 | ES | Futures | 1301.22 | 1302.46 | 1300.48 | 1302.46 | 101017.0 |
| 2011-02-09 12:30:00 | ES | Futures | 1302.21 | 1303.94 | 1301.96 | 1302.46 | 67743.0 |
| 2011-02-09 13:00:00 | ES | Futures | 1302.46 | 1305.18 | 1302.21 | 1304.93 | 78620.0 |
| 2011-02-09 13:30:00 | ES | Futures | 1305.18 | 1305.18 | 1302.95 | 1302.95 | 36914.0 |
| 2011-02-09 14:00:00 | ES | Futures | 1303.2 | 1303.2 | 1299.73 | 1301.47 | 139518.0 |
| 2011-02-09 14:30:00 | ES | Futures | 1301.22 | 1301.71 | 1298.25 | 1299.73 | 111691.0 |
| 2011-02-09 15:00:00 | ES | Futures | 1299.73 | 1302.7 | 1299.24 | 1302.7 | 81564.0 |
| 2011-02-09 15:30:00 | ES | Futures | 1302.7 | 1305.18 | 1301.71 | 1305.18 | 160238.0 |
| 2011-02-09 16:00:00 | ES | Futures | 1305.18 | 1307.16 | 1304.93 | 1305.43 | 101741.0 |
| 2011-02-09 16:30:00 | ES | Futures | 1304.93 | 1305.43 | 1304.19 | 1305.18 | 12625.0 |
| 2011-02-09 17:00:00 | ES | Futures | 1304.93 | 1305.18 | 1303.94 | 1303.94 | 4599.0 |
| 2011-02-09 18:00:00 | ES | Futures | 1303.94 | 1304.44 | 1303.69 | 1304.19 | 2778.0 |
| 2011-02-09 18:30:00 | ES | Futures | 1304.19 | 1304.44 | 1303.69 | 1303.94 | 1515.0 |
| 2011-02-09 19:00:00 | ES | Futures | 1303.94 | 1303.94 | 1302.95 | 1303.69 | 4207.0 |
| 2011-02-09 19:30:00 | ES | Futures | 1303.45 | 1303.94 | 1303.2 | 1303.2 | 1820.0 |
| 2011-02-09 20:00:00 | ES | Futures | 1303.45 | 1305.18 | 1303.2 | 1304.93 | 3304.0 |
| 2011-02-09 20:30:00 | ES | Futures | 1305.18 | 1305.67 | 1304.68 | 1305.67 | 3250.0 |
| 2011-02-09 21:00:00 | ES | Futures | 1305.67 | 1306.17 | 1304.93 | 1306.17 | 4552.0 |
| 2011-02-09 21:30:00 | ES | Futures | 1306.17 | 1306.41 | 1305.92 | 1306.41 | 1839.0 |
| 2011-02-09 22:00:00 | ES | Futures | 1306.17 | 1306.41 | 1305.92 | 1306.17 | 1218.0 |
| 2011-02-09 22:30:00 | ES | Futures | 1306.17 | 1306.41 | 1305.92 | 1306.17 | 1726.0 |
| 2011-02-09 23:00:00 | ES | Futures | 1306.41 | 1306.41 | 1306.17 | 1306.41 | 1256.0 |
| 2011-02-09 23:30:00 | ES | Futures | 1306.41 | 1306.66 | 1305.67 | 1305.67 | 1418.0 |
| 2011-02-09 00:00:00 | NQ | Futures | 2707.86 | 2709.3 | 2706.72 | 2709.01 | 175.0 |
| 2011-02-09 00:30:00 | NQ | Futures | 2709.01 | 2709.59 | 2707.0 | 2707.29 | 78.0 |
| 2011-02-09 01:00:00 | NQ | Futures | 2707.86 | 2707.86 | 2706.72 | 2707.0 | 61.0 |
> showing 50 of 2,771 rows — these rows as CSV