PREVIEW / futures_1hour / 2008-04-11
file: by_date/futures_1hour/2008/2008-04-11.parquet size: 36 KB rows: 996
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-04-11 00:00:00 | ES | Futures | 1273.42 | 1274.59 | 1272.49 | 1273.89 | 1215.0 |
| 2008-04-11 01:00:00 | ES | Futures | 1273.66 | 1274.59 | 1273.19 | 1274.35 | 1738.0 |
| 2008-04-11 02:00:00 | ES | Futures | 1274.35 | 1274.59 | 1272.03 | 1272.72 | 4071.0 |
| 2008-04-11 03:00:00 | ES | Futures | 1272.96 | 1274.12 | 1270.86 | 1273.42 | 11549.0 |
| 2008-04-11 04:00:00 | ES | Futures | 1273.66 | 1275.05 | 1271.79 | 1272.72 | 11146.0 |
| 2008-04-11 05:00:00 | ES | Futures | 1272.72 | 1273.19 | 1271.56 | 1272.96 | 5276.0 |
| 2008-04-11 06:00:00 | ES | Futures | 1272.96 | 1274.35 | 1261.55 | 1262.71 | 52865.0 |
| 2008-04-11 07:00:00 | ES | Futures | 1262.94 | 1262.94 | 1256.42 | 1259.45 | 70644.0 |
| 2008-04-11 08:00:00 | ES | Futures | 1259.22 | 1259.45 | 1253.4 | 1255.26 | 73473.0 |
| 2008-04-11 09:00:00 | ES | Futures | 1255.49 | 1256.66 | 1252.7 | 1253.63 | 255317.0 |
| 2008-04-11 10:00:00 | ES | Futures | 1253.86 | 1259.22 | 1251.3 | 1256.66 | 364668.0 |
| 2008-04-11 11:00:00 | ES | Futures | 1256.89 | 1257.12 | 1253.16 | 1255.96 | 199578.0 |
| 2008-04-11 12:00:00 | ES | Futures | 1255.73 | 1255.96 | 1248.97 | 1251.07 | 177098.0 |
| 2008-04-11 13:00:00 | ES | Futures | 1251.07 | 1252.47 | 1247.11 | 1248.51 | 163457.0 |
| 2008-04-11 14:00:00 | ES | Futures | 1248.51 | 1248.97 | 1244.55 | 1246.18 | 182890.0 |
| 2008-04-11 15:00:00 | ES | Futures | 1246.41 | 1247.11 | 1240.36 | 1243.15 | 348861.0 |
| 2008-04-11 16:00:00 | ES | Futures | 1242.92 | 1244.32 | 1242.69 | 1243.85 | 82004.0 |
| 2008-04-11 00:00:00 | NQ | Futures | 2110.47 | 2111.32 | 2109.05 | 2111.32 | 76.0 |
| 2008-04-11 01:00:00 | NQ | Futures | 2110.18 | 2111.88 | 2109.9 | 2111.6 | 34.0 |
| 2008-04-11 02:00:00 | NQ | Futures | 2112.16 | 2112.16 | 2108.77 | 2111.03 | 515.0 |
| 2008-04-11 03:00:00 | NQ | Futures | 2111.03 | 2112.16 | 2108.2 | 2111.88 | 849.0 |
| 2008-04-11 04:00:00 | NQ | Futures | 2111.88 | 2114.14 | 2108.77 | 2111.03 | 682.0 |
| 2008-04-11 05:00:00 | NQ | Futures | 2110.75 | 2112.73 | 2109.9 | 2112.16 | 857.0 |
| 2008-04-11 06:00:00 | NQ | Futures | 2111.88 | 2115.28 | 2090.95 | 2092.65 | 4975.0 |
| 2008-04-11 07:00:00 | NQ | Futures | 2092.65 | 2094.91 | 2085.58 | 2094.35 | 4428.0 |
| 2008-04-11 08:00:00 | NQ | Futures | 2094.06 | 2095.76 | 2073.98 | 2076.24 | 14532.0 |
| 2008-04-11 09:00:00 | NQ | Futures | 2076.53 | 2081.05 | 2073.7 | 2075.4 | 43348.0 |
| 2008-04-11 10:00:00 | NQ | Futures | 2075.11 | 2077.94 | 2065.21 | 2071.15 | 60606.0 |
| 2008-04-11 11:00:00 | NQ | Futures | 2071.15 | 2073.7 | 2066.35 | 2072.57 | 32517.0 |
| 2008-04-11 12:00:00 | NQ | Futures | 2072.57 | 2072.85 | 2057.86 | 2061.54 | 35495.0 |
| 2008-04-11 13:00:00 | NQ | Futures | 2061.54 | 2063.8 | 2047.96 | 2051.92 | 36180.0 |
| 2008-04-11 14:00:00 | NQ | Futures | 2051.64 | 2053.05 | 2040.89 | 2044.85 | 40428.0 |
| 2008-04-11 15:00:00 | NQ | Futures | 2044.57 | 2045.7 | 2035.23 | 2042.59 | 57526.0 |
| 2008-04-11 16:00:00 | NQ | Futures | 2042.87 | 2046.27 | 2040.33 | 2044.57 | 13692.0 |
| 2008-04-11 00:00:00 | YM | Futures | 11470.8 | 11476.3 | 11468.1 | 11476.3 | 158.0 |
| 2008-04-11 01:00:00 | YM | Futures | 11474.5 | 11482.6 | 11474.5 | 11482.6 | 162.0 |
| 2008-04-11 02:00:00 | YM | Futures | 11482.6 | 11483.5 | 11464.5 | 11474.5 | 389.0 |
| 2008-04-11 03:00:00 | YM | Futures | 11474.5 | 11481.7 | 11456.3 | 11475.4 | 1126.0 |
| 2008-04-11 04:00:00 | YM | Futures | 11476.3 | 11484.4 | 11464.5 | 11470.8 | 756.0 |
| 2008-04-11 05:00:00 | YM | Futures | 11468.1 | 11473.5 | 11461.7 | 11468.1 | 245.0 |
| 2008-04-11 06:00:00 | YM | Futures | 11468.1 | 11479.9 | 11382.7 | 11390.9 | 2124.0 |
| 2008-04-11 07:00:00 | YM | Futures | 11389.9 | 11391.8 | 11351.8 | 11370.0 | 3939.0 |
| 2008-04-11 08:00:00 | YM | Futures | 11370.0 | 11370.9 | 11319.1 | 11329.1 | 5901.0 |
| 2008-04-11 09:00:00 | YM | Futures | 11330.9 | 11338.2 | 11296.4 | 11310.0 | 20898.0 |
| 2008-04-11 10:00:00 | YM | Futures | 11310.9 | 11323.6 | 11268.2 | 11310.9 | 30869.0 |
| 2008-04-11 11:00:00 | YM | Futures | 11310.0 | 11319.1 | 11282.7 | 11309.1 | 14689.0 |
| 2008-04-11 12:00:00 | YM | Futures | 11310.0 | 11311.8 | 11257.3 | 11272.7 | 14131.0 |
| 2008-04-11 13:00:00 | YM | Futures | 11272.7 | 11280.9 | 11229.1 | 11240.0 | 13748.0 |
| 2008-04-11 14:00:00 | YM | Futures | 11240.0 | 11243.7 | 11202.8 | 11216.4 | 19253.0 |
| 2008-04-11 15:00:00 | YM | Futures | 11216.4 | 11224.6 | 11172.8 | 11200.0 | 19525.0 |
> showing 50 of 996 rows — these rows as CSV