PREVIEW / futures_1hour / 2008-01-08
file: by_date/futures_1hour/2008/2008-01-08.parquet size: 28 KB rows: 743
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-01-08 00:00:00 | ES | Futures | 1328.52 | 1330.16 | 1328.29 | 1329.46 | 1249.0 |
| 2008-01-08 01:00:00 | ES | Futures | 1329.46 | 1330.16 | 1328.52 | 1328.52 | 1151.0 |
| 2008-01-08 02:00:00 | ES | Futures | 1328.29 | 1329.22 | 1327.59 | 1328.99 | 3506.0 |
| 2008-01-08 03:00:00 | ES | Futures | 1328.99 | 1332.02 | 1328.29 | 1331.32 | 11603.0 |
| 2008-01-08 04:00:00 | ES | Futures | 1331.32 | 1332.02 | 1330.16 | 1332.02 | 9078.0 |
| 2008-01-08 05:00:00 | ES | Futures | 1331.79 | 1332.25 | 1330.62 | 1331.55 | 7165.0 |
| 2008-01-08 06:00:00 | ES | Futures | 1331.55 | 1332.72 | 1331.32 | 1332.25 | 7433.0 |
| 2008-01-08 07:00:00 | ES | Futures | 1332.02 | 1337.15 | 1332.02 | 1336.92 | 31811.0 |
| 2008-01-08 08:00:00 | ES | Futures | 1336.92 | 1337.38 | 1332.02 | 1333.42 | 40108.0 |
| 2008-01-08 09:00:00 | ES | Futures | 1333.42 | 1338.32 | 1331.09 | 1335.52 | 225378.0 |
| 2008-01-08 10:00:00 | ES | Futures | 1335.29 | 1340.88 | 1332.95 | 1335.29 | 348206.0 |
| 2008-01-08 11:00:00 | ES | Futures | 1335.05 | 1336.22 | 1322.0 | 1324.79 | 389024.0 |
| 2008-01-08 12:00:00 | ES | Futures | 1324.79 | 1327.82 | 1322.23 | 1325.49 | 181181.0 |
| 2008-01-08 13:00:00 | ES | Futures | 1325.49 | 1332.95 | 1322.23 | 1332.72 | 319280.0 |
| 2008-01-08 14:00:00 | ES | Futures | 1332.72 | 1335.98 | 1319.66 | 1320.83 | 362635.0 |
| 2008-01-08 15:00:00 | ES | Futures | 1320.83 | 1322.0 | 1300.55 | 1302.41 | 801119.0 |
| 2008-01-08 16:00:00 | ES | Futures | 1302.41 | 1304.28 | 1299.15 | 1302.64 | 142276.0 |
| 2008-01-08 17:00:00 | ES | Futures | 1302.64 | 1303.81 | 1301.94 | 1303.81 | 2275.0 |
| 2008-01-08 18:00:00 | ES | Futures | 1303.34 | 1303.81 | 1301.24 | 1301.71 | 7770.0 |
| 2008-01-08 19:00:00 | ES | Futures | 1301.71 | 1304.28 | 1301.71 | 1303.58 | 2330.0 |
| 2008-01-08 20:00:00 | ES | Futures | 1303.58 | 1305.67 | 1303.58 | 1305.44 | 3010.0 |
| 2008-01-08 21:00:00 | ES | Futures | 1305.44 | 1305.91 | 1304.04 | 1304.74 | 2118.0 |
| 2008-01-08 22:00:00 | ES | Futures | 1304.74 | 1305.91 | 1303.34 | 1305.44 | 1569.0 |
| 2008-01-08 23:00:00 | ES | Futures | 1305.21 | 1306.84 | 1304.98 | 1306.37 | 2552.0 |
| 2008-01-08 00:00:00 | NQ | Futures | 2247.19 | 2250.31 | 2246.62 | 2248.04 | 264.0 |
| 2008-01-08 01:00:00 | NQ | Futures | 2248.33 | 2249.46 | 2247.19 | 2247.47 | 183.0 |
| 2008-01-08 02:00:00 | NQ | Futures | 2247.19 | 2248.33 | 2246.34 | 2247.76 | 263.0 |
| 2008-01-08 03:00:00 | NQ | Futures | 2247.19 | 2254.85 | 2246.62 | 2252.3 | 1741.0 |
| 2008-01-08 04:00:00 | NQ | Futures | 2252.58 | 2253.15 | 2249.74 | 2252.3 | 713.0 |
| 2008-01-08 05:00:00 | NQ | Futures | 2252.02 | 2252.3 | 2250.31 | 2251.16 | 374.0 |
| 2008-01-08 06:00:00 | NQ | Futures | 2251.45 | 2252.3 | 2249.18 | 2250.88 | 877.0 |
| 2008-01-08 07:00:00 | NQ | Futures | 2250.88 | 2261.95 | 2249.74 | 2260.81 | 2616.0 |
| 2008-01-08 08:00:00 | NQ | Futures | 2260.25 | 2261.1 | 2250.6 | 2252.3 | 5991.0 |
| 2008-01-08 09:00:00 | NQ | Futures | 2252.3 | 2254.57 | 2239.53 | 2249.74 | 51776.0 |
| 2008-01-08 10:00:00 | NQ | Futures | 2249.74 | 2269.05 | 2246.91 | 2258.54 | 86501.0 |
| 2008-01-08 11:00:00 | NQ | Futures | 2258.26 | 2260.81 | 2233.28 | 2242.08 | 73909.0 |
| 2008-01-08 12:00:00 | NQ | Futures | 2242.36 | 2252.02 | 2236.12 | 2248.04 | 42492.0 |
| 2008-01-08 13:00:00 | NQ | Futures | 2248.04 | 2258.26 | 2239.53 | 2257.41 | 63715.0 |
| 2008-01-08 14:00:00 | NQ | Futures | 2257.41 | 2268.76 | 2235.27 | 2237.26 | 72620.0 |
| 2008-01-08 15:00:00 | NQ | Futures | 2237.54 | 2240.66 | 2185.31 | 2185.6 | 160938.0 |
| 2008-01-08 16:00:00 | NQ | Futures | 2185.6 | 2191.56 | 2181.91 | 2190.42 | 23343.0 |
| 2008-01-08 17:00:00 | NQ | Futures | 2190.99 | 2192.12 | 2190.14 | 2191.84 | 281.0 |
| 2008-01-08 18:00:00 | NQ | Futures | 2191.56 | 2192.41 | 2188.15 | 2188.43 | 970.0 |
| 2008-01-08 19:00:00 | NQ | Futures | 2189.0 | 2192.41 | 2188.72 | 2192.41 | 288.0 |
| 2008-01-08 20:00:00 | NQ | Futures | 2191.27 | 2195.53 | 2191.27 | 2194.96 | 481.0 |
| 2008-01-08 21:00:00 | NQ | Futures | 2195.53 | 2196.67 | 2194.11 | 2194.96 | 234.0 |
| 2008-01-08 22:00:00 | NQ | Futures | 2194.68 | 2196.67 | 2193.26 | 2196.67 | 113.0 |
| 2008-01-08 23:00:00 | NQ | Futures | 2196.38 | 2198.37 | 2196.38 | 2197.8 | 153.0 |
| 2008-01-08 00:00:00 | YM | Futures | 11712.4 | 11724.2 | 11710.5 | 11717.8 | 127.0 |
| 2008-01-08 01:00:00 | YM | Futures | 11718.7 | 11720.5 | 11712.4 | 11712.4 | 205.0 |
> showing 50 of 743 rows — these rows as CSV