PREVIEW / futures_1hour / 2008-02-01
file: by_date/futures_1hour/2008/2008-02-01.parquet size: 27 KB rows: 659
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-02-01 00:00:00 | ES | Futures | 1282.83 | 1283.76 | 1280.26 | 1281.19 | 1432.0 |
| 2008-02-01 01:00:00 | ES | Futures | 1280.96 | 1281.66 | 1279.09 | 1281.66 | 2519.0 |
| 2008-02-01 02:00:00 | ES | Futures | 1281.66 | 1285.62 | 1280.73 | 1285.39 | 6602.0 |
| 2008-02-01 03:00:00 | ES | Futures | 1285.39 | 1288.42 | 1284.92 | 1286.32 | 17185.0 |
| 2008-02-01 04:00:00 | ES | Futures | 1286.56 | 1288.42 | 1284.69 | 1286.32 | 11366.0 |
| 2008-02-01 05:00:00 | ES | Futures | 1286.32 | 1287.72 | 1284.69 | 1287.26 | 10365.0 |
| 2008-02-01 06:00:00 | ES | Futures | 1287.02 | 1301.01 | 1286.79 | 1300.78 | 60260.0 |
| 2008-02-01 07:00:00 | ES | Futures | 1300.78 | 1303.81 | 1295.65 | 1301.94 | 75186.0 |
| 2008-02-01 08:00:00 | ES | Futures | 1301.94 | 1302.18 | 1285.86 | 1286.79 | 222403.0 |
| 2008-02-01 09:00:00 | ES | Futures | 1286.79 | 1295.18 | 1282.83 | 1293.32 | 278538.0 |
| 2008-02-01 10:00:00 | ES | Futures | 1293.55 | 1303.58 | 1283.76 | 1287.72 | 583207.0 |
| 2008-02-01 11:00:00 | ES | Futures | 1287.49 | 1295.18 | 1285.62 | 1293.32 | 206915.0 |
| 2008-02-01 12:00:00 | ES | Futures | 1293.32 | 1294.48 | 1287.72 | 1288.89 | 137188.0 |
| 2008-02-01 13:00:00 | ES | Futures | 1288.89 | 1296.12 | 1288.42 | 1291.45 | 136872.0 |
| 2008-02-01 14:00:00 | ES | Futures | 1291.22 | 1301.01 | 1290.99 | 1299.61 | 173423.0 |
| 2008-02-01 15:00:00 | ES | Futures | 1299.61 | 1302.88 | 1296.35 | 1302.41 | 243750.0 |
| 2008-02-01 16:00:00 | ES | Futures | 1302.18 | 1303.34 | 1301.24 | 1302.88 | 71647.0 |
| 2008-02-01 00:00:00 | NQ | Futures | 2090.79 | 2090.79 | 2085.97 | 2085.97 | 115.0 |
| 2008-02-01 01:00:00 | NQ | Futures | 2086.82 | 2086.82 | 2081.14 | 2084.26 | 198.0 |
| 2008-02-01 02:00:00 | NQ | Futures | 2085.68 | 2093.63 | 2083.41 | 2092.5 | 435.0 |
| 2008-02-01 03:00:00 | NQ | Futures | 2091.93 | 2097.89 | 2088.52 | 2091.64 | 2454.0 |
| 2008-02-01 04:00:00 | NQ | Futures | 2091.36 | 2095.05 | 2086.82 | 2087.95 | 834.0 |
| 2008-02-01 05:00:00 | NQ | Futures | 2088.81 | 2094.48 | 2087.95 | 2093.06 | 1244.0 |
| 2008-02-01 06:00:00 | NQ | Futures | 2093.06 | 2133.37 | 2091.93 | 2128.54 | 5878.0 |
| 2008-02-01 07:00:00 | NQ | Futures | 2128.54 | 2131.38 | 2114.64 | 2125.42 | 6183.0 |
| 2008-02-01 08:00:00 | NQ | Futures | 2124.57 | 2132.23 | 2099.88 | 2111.51 | 24895.0 |
| 2008-02-01 09:00:00 | NQ | Futures | 2111.23 | 2112.36 | 2097.04 | 2107.54 | 66325.0 |
| 2008-02-01 10:00:00 | NQ | Futures | 2107.54 | 2124.85 | 2078.87 | 2083.13 | 118114.0 |
| 2008-02-01 11:00:00 | NQ | Futures | 2083.13 | 2097.89 | 2078.87 | 2096.75 | 42203.0 |
| 2008-02-01 12:00:00 | NQ | Futures | 2096.19 | 2096.47 | 2086.53 | 2089.37 | 28796.0 |
| 2008-02-01 13:00:00 | NQ | Futures | 2089.37 | 2105.27 | 2089.09 | 2097.32 | 33183.0 |
| 2008-02-01 14:00:00 | NQ | Futures | 2097.32 | 2117.19 | 2095.05 | 2114.35 | 32013.0 |
| 2008-02-01 15:00:00 | NQ | Futures | 2114.35 | 2119.18 | 2107.54 | 2111.8 | 47936.0 |
| 2008-02-01 16:00:00 | NQ | Futures | 2112.08 | 2119.46 | 2108.67 | 2117.76 | 11590.0 |
| 2008-02-01 00:00:00 | YM | Futures | 11468.0 | 11470.7 | 11450.7 | 11454.3 | 150.0 |
| 2008-02-01 01:00:00 | YM | Futures | 11454.3 | 11454.3 | 11437.1 | 11454.3 | 243.0 |
| 2008-02-01 02:00:00 | YM | Futures | 11456.2 | 11487.1 | 11450.7 | 11480.7 | 531.0 |
| 2008-02-01 03:00:00 | YM | Futures | 11480.7 | 11508.9 | 11478.9 | 11493.4 | 651.0 |
| 2008-02-01 04:00:00 | YM | Futures | 11494.3 | 11507.9 | 11482.5 | 11492.5 | 576.0 |
| 2008-02-01 05:00:00 | YM | Futures | 11492.5 | 11504.3 | 11482.5 | 11503.4 | 331.0 |
| 2008-02-01 06:00:00 | YM | Futures | 11503.4 | 11596.1 | 11499.8 | 11581.5 | 2886.0 |
| 2008-02-01 07:00:00 | YM | Futures | 11581.5 | 11611.5 | 11558.8 | 11603.3 | 2642.0 |
| 2008-02-01 08:00:00 | YM | Futures | 11600.6 | 11603.3 | 11479.8 | 11487.1 | 10982.0 |
| 2008-02-01 09:00:00 | YM | Futures | 11487.1 | 11554.3 | 11458.0 | 11533.4 | 23761.0 |
| 2008-02-01 10:00:00 | YM | Futures | 11533.4 | 11600.6 | 11450.7 | 11474.3 | 46776.0 |
| 2008-02-01 11:00:00 | YM | Futures | 11474.3 | 11532.5 | 11459.8 | 11514.3 | 18436.0 |
| 2008-02-01 12:00:00 | YM | Futures | 11513.4 | 11522.5 | 11467.1 | 11476.1 | 14458.0 |
| 2008-02-01 13:00:00 | YM | Futures | 11476.1 | 11533.4 | 11474.3 | 11495.2 | 12322.0 |
| 2008-02-01 14:00:00 | YM | Futures | 11495.2 | 11564.3 | 11489.8 | 11550.6 | 15067.0 |
| 2008-02-01 15:00:00 | YM | Futures | 11549.7 | 11580.6 | 11522.5 | 11578.8 | 19825.0 |
> showing 50 of 659 rows — these rows as CSV