PREVIEW / futures_1hour / 2008-05-13
file: by_date/futures_1hour/2008/2008-05-13.parquet size: 43 KB rows: 1,231
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.28 | 1308.12 | 1308.35 | 1140.0 |
| 2008-05-13 01:00:00 | ES | Futures | 1308.35 | 1309.98 | 1308.35 | 1309.28 | 1732.0 |
| 2008-05-13 02:00:00 | ES | Futures | 1309.28 | 1310.44 | 1308.81 | 1310.21 | 3721.0 |
| 2008-05-13 03:00:00 | ES | Futures | 1310.21 | 1310.21 | 1306.02 | 1306.72 | 12720.0 |
| 2008-05-13 04:00:00 | ES | Futures | 1306.72 | 1307.42 | 1305.09 | 1305.79 | 9875.0 |
| 2008-05-13 05:00:00 | ES | Futures | 1305.79 | 1306.25 | 1302.29 | 1303.69 | 18757.0 |
| 2008-05-13 06:00:00 | ES | Futures | 1303.92 | 1305.09 | 1301.36 | 1304.39 | 15843.0 |
| 2008-05-13 07:00:00 | ES | Futures | 1304.16 | 1304.86 | 1302.53 | 1303.92 | 16844.0 |
| 2008-05-13 08:00:00 | ES | Futures | 1304.16 | 1313.94 | 1303.69 | 1312.07 | 123160.0 |
| 2008-05-13 09:00:00 | ES | Futures | 1312.31 | 1312.54 | 1304.86 | 1305.32 | 212419.0 |
| 2008-05-13 10:00:00 | ES | Futures | 1305.55 | 1307.18 | 1302.06 | 1302.29 | 251609.0 |
| 2008-05-13 11:00:00 | ES | Futures | 1302.53 | 1305.09 | 1300.66 | 1304.62 | 203418.0 |
| 2008-05-13 12:00:00 | ES | Futures | 1304.39 | 1307.42 | 1303.92 | 1304.86 | 149502.0 |
| 2008-05-13 13:00:00 | ES | Futures | 1304.62 | 1307.65 | 1303.23 | 1306.25 | 118635.0 |
| 2008-05-13 14:00:00 | ES | Futures | 1306.02 | 1309.28 | 1305.55 | 1309.05 | 121619.0 |
| 2008-05-13 15:00:00 | ES | Futures | 1309.05 | 1310.68 | 1305.32 | 1307.18 | 198161.0 |
| 2008-05-13 16:00:00 | ES | Futures | 1307.18 | 1308.58 | 1306.25 | 1306.72 | 55828.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.88 | 1306.72 | 1306.95 | 1118.0 |
| 2008-05-13 19:00:00 | ES | Futures | 1307.18 | 1307.42 | 1306.49 | 1306.95 | 379.0 |
| 2008-05-13 20:00:00 | ES | Futures | 1306.95 | 1307.42 | 1306.49 | 1306.49 | 622.0 |
| 2008-05-13 21:00:00 | ES | Futures | 1306.49 | 1306.95 | 1306.02 | 1306.49 | 1104.0 |
| 2008-05-13 22:00:00 | ES | Futures | 1306.25 | 1306.49 | 1306.02 | 1306.49 | 484.0 |
| 2008-05-13 23:00:00 | ES | Futures | 1306.25 | 1306.49 | 1305.79 | 1306.49 | 718.0 |
| 2008-05-13 00:00:00 | NQ | Futures | 2262.35 | 2264.33 | 2261.5 | 2261.5 | 141.0 |
| 2008-05-13 01:00:00 | NQ | Futures | 2262.06 | 2264.89 | 2262.06 | 2263.19 | 100.0 |
| 2008-05-13 02:00:00 | NQ | Futures | 2262.63 | 2266.31 | 2262.63 | 2264.61 | 247.0 |
| 2008-05-13 03:00:00 | NQ | Futures | 2265.17 | 2265.17 | 2258.39 | 2259.52 | 909.0 |
| 2008-05-13 04:00:00 | NQ | Futures | 2259.24 | 2260.65 | 2256.69 | 2257.26 | 914.0 |
| 2008-05-13 05:00:00 | NQ | Futures | 2256.97 | 2258.1 | 2254.43 | 2255.84 | 1057.0 |
| 2008-05-13 06:00:00 | NQ | Futures | 2255.56 | 2258.1 | 2253.01 | 2257.54 | 680.0 |
| 2008-05-13 07:00:00 | NQ | Futures | 2257.26 | 2257.82 | 2253.3 | 2255.56 | 1288.0 |
| 2008-05-13 08:00:00 | NQ | Futures | 2255.84 | 2267.15 | 2254.99 | 2265.17 | 6846.0 |
| 2008-05-13 09:00:00 | NQ | Futures | 2265.46 | 2267.15 | 2254.71 | 2257.26 | 39960.0 |
| 2008-05-13 10:00:00 | NQ | Futures | 2257.54 | 2266.02 | 2249.62 | 2250.18 | 53042.0 |
| 2008-05-13 11:00:00 | NQ | Futures | 2250.18 | 2254.43 | 2246.22 | 2252.45 | 39440.0 |
| 2008-05-13 12:00:00 | NQ | Futures | 2252.45 | 2260.37 | 2251.88 | 2254.99 | 26775.0 |
| 2008-05-13 13:00:00 | NQ | Futures | 2255.28 | 2262.35 | 2252.16 | 2259.24 | 25195.0 |
| 2008-05-13 14:00:00 | NQ | Futures | 2259.24 | 2269.7 | 2258.67 | 2269.13 | 27732.0 |
| 2008-05-13 15:00:00 | NQ | Futures | 2269.13 | 2272.81 | 2264.89 | 2267.72 | 41060.0 |
| 2008-05-13 16:00:00 | NQ | Futures | 2268.0 | 2270.27 | 2266.31 | 2267.72 | 7409.0 |
| 2008-05-13 17:00:00 | NQ | Futures | 2266.59 | 2269.13 | 2266.59 | 2266.87 | 217.0 |
| 2008-05-13 18:00:00 | NQ | Futures | 2268.0 | 2268.57 | 2266.87 | 2266.87 | 79.0 |
| 2008-05-13 19:00:00 | NQ | Futures | 2267.15 | 2268.57 | 2266.59 | 2266.59 | 53.0 |
| 2008-05-13 20:00:00 | NQ | Futures | 2267.15 | 2268.0 | 2266.59 | 2266.87 | 12.0 |
| 2008-05-13 21:00:00 | NQ | Futures | 2266.59 | 2267.72 | 2266.02 | 2266.02 | 32.0 |
| 2008-05-13 22:00:00 | NQ | Futures | 2266.02 | 2266.02 | 2266.02 | 2266.02 | 4.0 |
| 2008-05-13 23:00:00 | NQ | Futures | 2266.59 | 2266.59 | 2266.02 | 2266.31 | 49.0 |
| 2008-05-13 00:00:00 | YM | Futures | 11692.5 | 11697.1 | 11689.8 | 11689.8 | 62.0 |
| 2008-05-13 01:00:00 | YM | Futures | 11692.5 | 11703.4 | 11692.5 | 11699.8 | 102.0 |
> showing 50 of 1,231 rows — these rows as CSV