PREVIEW / futures_1hour / 2008-05-16
file: by_date/futures_1hour/2008/2008-05-16.parquet size: 36 KB rows: 986
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-16 00:00:00 | ES | Futures | 1324.41 | 1324.88 | 1323.95 | 1324.41 | 784.0 |
| 2008-05-16 01:00:00 | ES | Futures | 1324.18 | 1324.65 | 1323.48 | 1324.18 | 929.0 |
| 2008-05-16 02:00:00 | ES | Futures | 1324.18 | 1325.11 | 1323.72 | 1324.88 | 1843.0 |
| 2008-05-16 03:00:00 | ES | Futures | 1325.11 | 1325.81 | 1323.72 | 1325.35 | 9175.0 |
| 2008-05-16 04:00:00 | ES | Futures | 1325.58 | 1330.0 | 1325.58 | 1329.54 | 16923.0 |
| 2008-05-16 05:00:00 | ES | Futures | 1329.54 | 1330.93 | 1328.61 | 1329.77 | 11982.0 |
| 2008-05-16 06:00:00 | ES | Futures | 1330.0 | 1331.4 | 1329.54 | 1330.24 | 9750.0 |
| 2008-05-16 07:00:00 | ES | Futures | 1330.47 | 1330.7 | 1328.61 | 1328.84 | 20735.0 |
| 2008-05-16 08:00:00 | ES | Futures | 1328.61 | 1331.17 | 1327.67 | 1330.7 | 66186.0 |
| 2008-05-16 09:00:00 | ES | Futures | 1330.7 | 1330.93 | 1324.41 | 1324.88 | 243438.0 |
| 2008-05-16 10:00:00 | ES | Futures | 1325.11 | 1325.58 | 1319.29 | 1319.76 | 372967.0 |
| 2008-05-16 11:00:00 | ES | Futures | 1319.53 | 1321.62 | 1317.66 | 1320.46 | 265557.0 |
| 2008-05-16 12:00:00 | ES | Futures | 1320.46 | 1324.18 | 1319.29 | 1323.48 | 158968.0 |
| 2008-05-16 13:00:00 | ES | Futures | 1323.25 | 1324.88 | 1320.92 | 1322.79 | 166712.0 |
| 2008-05-16 14:00:00 | ES | Futures | 1322.79 | 1326.74 | 1321.16 | 1325.58 | 151919.0 |
| 2008-05-16 15:00:00 | ES | Futures | 1325.35 | 1328.37 | 1324.41 | 1327.21 | 204237.0 |
| 2008-05-16 16:00:00 | ES | Futures | 1327.44 | 1328.61 | 1327.21 | 1327.91 | 64389.0 |
| 2008-05-16 00:00:00 | NQ | Futures | 2300.53 | 2301.38 | 2299.4 | 2299.4 | 250.0 |
| 2008-05-16 01:00:00 | NQ | Futures | 2299.68 | 2300.81 | 2299.4 | 2299.96 | 47.0 |
| 2008-05-16 02:00:00 | NQ | Futures | 2300.25 | 2301.09 | 2298.27 | 2300.81 | 294.0 |
| 2008-05-16 03:00:00 | NQ | Futures | 2300.53 | 2302.22 | 2298.83 | 2301.09 | 546.0 |
| 2008-05-16 04:00:00 | NQ | Futures | 2301.94 | 2306.75 | 2301.66 | 2305.9 | 1159.0 |
| 2008-05-16 05:00:00 | NQ | Futures | 2305.9 | 2307.6 | 2304.77 | 2307.03 | 592.0 |
| 2008-05-16 06:00:00 | NQ | Futures | 2307.03 | 2309.58 | 2306.75 | 2308.73 | 991.0 |
| 2008-05-16 07:00:00 | NQ | Futures | 2309.01 | 2309.01 | 2305.05 | 2305.62 | 1097.0 |
| 2008-05-16 08:00:00 | NQ | Futures | 2305.62 | 2307.6 | 2301.38 | 2305.62 | 5912.0 |
| 2008-05-16 09:00:00 | NQ | Futures | 2305.34 | 2308.16 | 2293.46 | 2294.87 | 50417.0 |
| 2008-05-16 10:00:00 | NQ | Futures | 2294.87 | 2296.85 | 2282.99 | 2282.99 | 67755.0 |
| 2008-05-16 11:00:00 | NQ | Futures | 2283.28 | 2290.63 | 2277.05 | 2288.37 | 50292.0 |
| 2008-05-16 12:00:00 | NQ | Futures | 2288.37 | 2296.57 | 2285.26 | 2295.44 | 35774.0 |
| 2008-05-16 13:00:00 | NQ | Futures | 2295.15 | 2296.85 | 2283.28 | 2288.93 | 38329.0 |
| 2008-05-16 14:00:00 | NQ | Futures | 2288.93 | 2298.27 | 2286.39 | 2296.57 | 29434.0 |
| 2008-05-16 15:00:00 | NQ | Futures | 2296.57 | 2305.34 | 2292.89 | 2302.51 | 43974.0 |
| 2008-05-16 16:00:00 | NQ | Futures | 2302.22 | 2304.77 | 2301.94 | 2303.07 | 9357.0 |
| 2008-05-16 00:00:00 | YM | Futures | 11793.4 | 11797.9 | 11789.8 | 11791.6 | 54.0 |
| 2008-05-16 01:00:00 | YM | Futures | 11792.5 | 11792.5 | 11787.9 | 11791.6 | 70.0 |
| 2008-05-16 02:00:00 | YM | Futures | 11791.6 | 11799.7 | 11785.2 | 11799.7 | 135.0 |
| 2008-05-16 03:00:00 | YM | Futures | 11800.7 | 11805.2 | 11790.7 | 11799.7 | 358.0 |
| 2008-05-16 04:00:00 | YM | Futures | 11802.5 | 11831.6 | 11801.6 | 11828.8 | 1281.0 |
| 2008-05-16 05:00:00 | YM | Futures | 11828.8 | 11837.9 | 11823.4 | 11830.6 | 1252.0 |
| 2008-05-16 06:00:00 | YM | Futures | 11829.7 | 11842.5 | 11828.8 | 11834.3 | 516.0 |
| 2008-05-16 07:00:00 | YM | Futures | 11836.1 | 11838.8 | 11818.8 | 11824.3 | 1389.0 |
| 2008-05-16 08:00:00 | YM | Futures | 11824.3 | 11842.5 | 11811.6 | 11839.7 | 3874.0 |
| 2008-05-16 09:00:00 | YM | Futures | 11839.7 | 11839.7 | 11785.2 | 11789.8 | 15540.0 |
| 2008-05-16 10:00:00 | YM | Futures | 11790.7 | 11794.3 | 11742.5 | 11744.3 | 30156.0 |
| 2008-05-16 11:00:00 | YM | Futures | 11744.3 | 11750.7 | 11714.3 | 11731.6 | 24348.0 |
| 2008-05-16 12:00:00 | YM | Futures | 11730.7 | 11768.9 | 11722.5 | 11763.4 | 14597.0 |
| 2008-05-16 13:00:00 | YM | Futures | 11764.3 | 11777.0 | 11742.5 | 11758.9 | 15115.0 |
| 2008-05-16 14:00:00 | YM | Futures | 11758.9 | 11791.6 | 11745.2 | 11782.5 | 13488.0 |
| 2008-05-16 15:00:00 | YM | Futures | 11782.5 | 11806.1 | 11773.4 | 11793.4 | 14459.0 |
> showing 50 of 986 rows — these rows as CSV