PREVIEW / futures_30min / 2008-05-13
file: by_date/futures_30min/2008/2008-05-13.parquet size: 68 KB rows: 2,271
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-13 00:00:00 | ES | Futures | 1308.58 | 1309.05 | 1308.35 | 1308.81 | 491.0 |
| 2008-05-13 00:30:00 | ES | Futures | 1309.05 | 1309.28 | 1308.12 | 1308.35 | 649.0 |
| 2008-05-13 01:00:00 | ES | Futures | 1308.35 | 1309.98 | 1308.35 | 1309.05 | 1058.0 |
| 2008-05-13 01:30:00 | ES | Futures | 1309.05 | 1309.51 | 1308.81 | 1309.28 | 674.0 |
| 2008-05-13 02:00:00 | ES | Futures | 1309.28 | 1309.75 | 1308.81 | 1309.51 | 1776.0 |
| 2008-05-13 02:30:00 | ES | Futures | 1309.75 | 1310.44 | 1309.51 | 1310.21 | 1945.0 |
| 2008-05-13 03:00:00 | ES | Futures | 1310.21 | 1310.21 | 1307.42 | 1307.65 | 6450.0 |
| 2008-05-13 03:30:00 | ES | Futures | 1307.65 | 1307.88 | 1306.02 | 1306.72 | 6270.0 |
| 2008-05-13 04:00:00 | ES | Futures | 1306.72 | 1307.42 | 1306.49 | 1306.72 | 2433.0 |
| 2008-05-13 04:30:00 | ES | Futures | 1306.49 | 1306.72 | 1305.09 | 1305.79 | 7442.0 |
| 2008-05-13 05:00:00 | ES | Futures | 1305.79 | 1306.25 | 1304.39 | 1304.39 | 7113.0 |
| 2008-05-13 05:30:00 | ES | Futures | 1304.39 | 1304.62 | 1302.29 | 1303.69 | 11644.0 |
| 2008-05-13 06:00:00 | ES | Futures | 1303.92 | 1304.39 | 1301.36 | 1303.46 | 10344.0 |
| 2008-05-13 06:30:00 | ES | Futures | 1303.46 | 1305.09 | 1302.99 | 1304.39 | 5499.0 |
| 2008-05-13 07:00:00 | ES | Futures | 1304.16 | 1304.86 | 1302.99 | 1303.46 | 6166.0 |
| 2008-05-13 07:30:00 | ES | Futures | 1303.46 | 1304.39 | 1302.53 | 1303.92 | 10678.0 |
| 2008-05-13 08:00:00 | ES | Futures | 1304.16 | 1306.25 | 1303.69 | 1305.79 | 20166.0 |
| 2008-05-13 08:30:00 | ES | Futures | 1305.79 | 1313.94 | 1304.62 | 1312.07 | 102994.0 |
| 2008-05-13 09:00:00 | ES | Futures | 1312.31 | 1312.54 | 1310.68 | 1310.91 | 24584.0 |
| 2008-05-13 09:30:00 | ES | Futures | 1310.91 | 1311.61 | 1304.86 | 1305.32 | 187835.0 |
| 2008-05-13 10:00:00 | ES | Futures | 1305.55 | 1306.95 | 1303.46 | 1305.79 | 143576.0 |
| 2008-05-13 10:30:00 | ES | Futures | 1305.79 | 1307.18 | 1302.06 | 1302.29 | 108033.0 |
| 2008-05-13 11:00:00 | ES | Futures | 1302.53 | 1304.86 | 1300.66 | 1302.76 | 115486.0 |
| 2008-05-13 11:30:00 | ES | Futures | 1302.76 | 1305.09 | 1301.36 | 1304.62 | 87932.0 |
| 2008-05-13 12:00:00 | ES | Futures | 1304.39 | 1307.18 | 1303.92 | 1306.02 | 81842.0 |
| 2008-05-13 12:30:00 | ES | Futures | 1306.02 | 1307.42 | 1303.92 | 1304.86 | 67660.0 |
| 2008-05-13 13:00:00 | ES | Futures | 1304.62 | 1305.79 | 1303.23 | 1305.32 | 59167.0 |
| 2008-05-13 13:30:00 | ES | Futures | 1305.32 | 1307.65 | 1304.86 | 1306.25 | 59468.0 |
| 2008-05-13 14:00:00 | ES | Futures | 1306.02 | 1308.12 | 1305.55 | 1306.25 | 54231.0 |
| 2008-05-13 14:30:00 | ES | Futures | 1306.25 | 1309.28 | 1305.79 | 1309.05 | 67388.0 |
| 2008-05-13 15:00:00 | ES | Futures | 1309.05 | 1310.68 | 1305.79 | 1307.42 | 102374.0 |
| 2008-05-13 15:30:00 | ES | Futures | 1307.42 | 1308.12 | 1305.32 | 1307.18 | 95787.0 |
| 2008-05-13 16:00:00 | ES | Futures | 1307.18 | 1308.58 | 1306.95 | 1308.12 | 49826.0 |
| 2008-05-13 16:30:00 | ES | Futures | 1307.65 | 1307.88 | 1306.25 | 1306.72 | 6002.0 |
| 2008-05-13 17:00:00 | ES | Futures | 1306.72 | 1307.42 | 1306.49 | 1307.18 | 1747.0 |
| 2008-05-13 18:00:00 | ES | Futures | 1307.18 | 1307.65 | 1306.95 | 1307.42 | 477.0 |
| 2008-05-13 18:30:00 | ES | Futures | 1307.42 | 1307.88 | 1306.72 | 1306.95 | 641.0 |
| 2008-05-13 19:00:00 | ES | Futures | 1307.18 | 1307.18 | 1306.95 | 1306.95 | 58.0 |
| 2008-05-13 19:30:00 | ES | Futures | 1306.95 | 1307.42 | 1306.49 | 1306.95 | 321.0 |
| 2008-05-13 20:00:00 | ES | Futures | 1306.95 | 1307.42 | 1306.72 | 1307.18 | 320.0 |
| 2008-05-13 20:30:00 | ES | Futures | 1307.18 | 1307.18 | 1306.49 | 1306.49 | 302.0 |
| 2008-05-13 21:00:00 | ES | Futures | 1306.49 | 1306.95 | 1306.25 | 1306.49 | 597.0 |
| 2008-05-13 21:30:00 | ES | Futures | 1306.49 | 1306.95 | 1306.02 | 1306.49 | 507.0 |
| 2008-05-13 22:00:00 | ES | Futures | 1306.25 | 1306.49 | 1306.02 | 1306.25 | 297.0 |
| 2008-05-13 22:30:00 | ES | Futures | 1306.25 | 1306.49 | 1306.02 | 1306.49 | 187.0 |
| 2008-05-13 23:00:00 | ES | Futures | 1306.25 | 1306.49 | 1306.02 | 1306.49 | 328.0 |
| 2008-05-13 23:30:00 | ES | Futures | 1306.25 | 1306.49 | 1305.79 | 1306.49 | 390.0 |
| 2008-05-13 00:00:00 | NQ | Futures | 2262.35 | 2262.63 | 2261.5 | 2262.63 | 40.0 |
| 2008-05-13 00:30:00 | NQ | Futures | 2262.06 | 2264.33 | 2261.5 | 2261.5 | 101.0 |
| 2008-05-13 01:00:00 | NQ | Futures | 2262.06 | 2264.89 | 2262.06 | 2263.76 | 31.0 |
> showing 50 of 2,271 rows — these rows as CSV