PREVIEW / futures_1hour / 2008-02-27
file: by_date/futures_1hour/2008/2008-02-27.parquet size: 39 KB rows: 1,136
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-27 00:00:00 | ES | Futures | 1289.12 | 1290.05 | 1288.89 | 1289.12 | 445.0 |
| 2008-02-27 01:00:00 | ES | Futures | 1288.89 | 1290.05 | 1288.42 | 1288.65 | 1096.0 |
| 2008-02-27 02:00:00 | ES | Futures | 1288.65 | 1290.05 | 1287.95 | 1289.59 | 4881.0 |
| 2008-02-27 03:00:00 | ES | Futures | 1289.35 | 1291.45 | 1286.56 | 1286.56 | 23060.0 |
| 2008-02-27 04:00:00 | ES | Futures | 1286.79 | 1287.49 | 1284.69 | 1285.39 | 21501.0 |
| 2008-02-27 05:00:00 | ES | Futures | 1285.16 | 1287.72 | 1283.99 | 1286.56 | 14464.0 |
| 2008-02-27 06:00:00 | ES | Futures | 1286.56 | 1288.65 | 1285.62 | 1287.72 | 16222.0 |
| 2008-02-27 07:00:00 | ES | Futures | 1287.72 | 1288.19 | 1283.99 | 1284.69 | 23567.0 |
| 2008-02-27 08:00:00 | ES | Futures | 1284.69 | 1285.86 | 1278.63 | 1281.43 | 102993.0 |
| 2008-02-27 09:00:00 | ES | Futures | 1281.43 | 1286.32 | 1279.79 | 1285.62 | 190515.0 |
| 2008-02-27 10:00:00 | ES | Futures | 1285.62 | 1296.35 | 1281.19 | 1291.92 | 449702.0 |
| 2008-02-27 11:00:00 | ES | Futures | 1291.69 | 1295.65 | 1290.29 | 1295.18 | 199972.0 |
| 2008-02-27 12:00:00 | ES | Futures | 1295.18 | 1295.18 | 1290.52 | 1293.78 | 127864.0 |
| 2008-02-27 13:00:00 | ES | Futures | 1293.55 | 1295.18 | 1288.19 | 1288.89 | 135842.0 |
| 2008-02-27 14:00:00 | ES | Futures | 1288.89 | 1289.35 | 1282.13 | 1288.19 | 218563.0 |
| 2008-02-27 15:00:00 | ES | Futures | 1288.42 | 1290.99 | 1285.39 | 1286.79 | 223484.0 |
| 2008-02-27 16:00:00 | ES | Futures | 1286.79 | 1288.19 | 1285.39 | 1287.95 | 55177.0 |
| 2008-02-27 17:00:00 | ES | Futures | 1287.72 | 1288.42 | 1287.49 | 1287.95 | 3121.0 |
| 2008-02-27 18:00:00 | ES | Futures | 1288.19 | 1288.42 | 1284.46 | 1285.16 | 4728.0 |
| 2008-02-27 19:00:00 | ES | Futures | 1285.16 | 1285.62 | 1283.29 | 1283.52 | 3819.0 |
| 2008-02-27 20:00:00 | ES | Futures | 1283.76 | 1284.46 | 1282.83 | 1283.06 | 2694.0 |
| 2008-02-27 21:00:00 | ES | Futures | 1283.06 | 1283.52 | 1282.36 | 1283.29 | 2118.0 |
| 2008-02-27 22:00:00 | ES | Futures | 1283.29 | 1284.46 | 1282.59 | 1283.99 | 2206.0 |
| 2008-02-27 23:00:00 | ES | Futures | 1284.22 | 1284.92 | 1282.59 | 1282.83 | 2619.0 |
| 2008-02-27 00:00:00 | NQ | Futures | 2042.82 | 2042.82 | 2041.12 | 2041.12 | 52.0 |
| 2008-02-27 01:00:00 | NQ | Futures | 2040.84 | 2042.54 | 2039.7 | 2040.27 | 106.0 |
| 2008-02-27 02:00:00 | NQ | Futures | 2040.27 | 2041.97 | 2037.71 | 2041.12 | 375.0 |
| 2008-02-27 03:00:00 | NQ | Futures | 2041.12 | 2043.96 | 2035.44 | 2035.44 | 963.0 |
| 2008-02-27 04:00:00 | NQ | Futures | 2035.44 | 2036.58 | 2032.32 | 2034.02 | 1179.0 |
| 2008-02-27 05:00:00 | NQ | Futures | 2034.02 | 2036.86 | 2031.19 | 2036.01 | 781.0 |
| 2008-02-27 06:00:00 | NQ | Futures | 2034.88 | 2039.7 | 2034.31 | 2038.85 | 833.0 |
| 2008-02-27 07:00:00 | NQ | Futures | 2038.57 | 2039.7 | 2029.48 | 2030.33 | 2399.0 |
| 2008-02-27 08:00:00 | NQ | Futures | 2030.33 | 2030.62 | 2019.55 | 2022.95 | 10613.0 |
| 2008-02-27 09:00:00 | NQ | Futures | 2022.67 | 2033.17 | 2017.84 | 2030.62 | 48317.0 |
| 2008-02-27 10:00:00 | NQ | Futures | 2030.05 | 2053.04 | 2024.09 | 2042.82 | 79126.0 |
| 2008-02-27 11:00:00 | NQ | Futures | 2042.82 | 2053.89 | 2040.27 | 2053.04 | 46575.0 |
| 2008-02-27 12:00:00 | NQ | Futures | 2053.33 | 2054.74 | 2043.11 | 2050.2 | 33487.0 |
| 2008-02-27 13:00:00 | NQ | Futures | 2049.92 | 2052.47 | 2037.15 | 2039.98 | 33898.0 |
| 2008-02-27 14:00:00 | NQ | Futures | 2039.7 | 2046.23 | 2027.78 | 2045.95 | 41483.0 |
| 2008-02-27 15:00:00 | NQ | Futures | 2045.95 | 2052.47 | 2039.7 | 2045.38 | 50883.0 |
| 2008-02-27 16:00:00 | NQ | Futures | 2045.38 | 2051.05 | 2041.69 | 2050.49 | 10738.0 |
| 2008-02-27 17:00:00 | NQ | Futures | 2050.49 | 2053.61 | 2049.92 | 2051.91 | 2055.0 |
| 2008-02-27 18:00:00 | NQ | Futures | 2051.91 | 2052.19 | 2048.78 | 2048.78 | 369.0 |
| 2008-02-27 19:00:00 | NQ | Futures | 2049.35 | 2049.35 | 2044.81 | 2046.23 | 494.0 |
| 2008-02-27 20:00:00 | NQ | Futures | 2046.51 | 2047.93 | 2045.09 | 2045.09 | 56.0 |
| 2008-02-27 21:00:00 | NQ | Futures | 2045.38 | 2045.95 | 2044.53 | 2045.95 | 138.0 |
| 2008-02-27 22:00:00 | NQ | Futures | 2045.38 | 2048.22 | 2044.24 | 2048.22 | 81.0 |
| 2008-02-27 23:00:00 | NQ | Futures | 2048.22 | 2049.07 | 2045.09 | 2045.09 | 169.0 |
| 2008-02-27 00:00:00 | YM | Futures | 11529.7 | 11536.1 | 11527.0 | 11528.8 | 62.0 |
| 2008-02-27 01:00:00 | YM | Futures | 11529.7 | 11535.2 | 11526.1 | 11526.1 | 41.0 |
> showing 50 of 1,136 rows — these rows as CSV