PREVIEW / futures_1hour / 2008-02-05
file: by_date/futures_1hour/2008/2008-02-05.parquet size: 31 KB rows: 838
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-05 00:00:00 | ES | Futures | 1283.29 | 1286.56 | 1283.29 | 1286.56 | 1516.0 |
| 2008-02-05 01:00:00 | ES | Futures | 1286.32 | 1287.72 | 1284.46 | 1287.49 | 2000.0 |
| 2008-02-05 02:00:00 | ES | Futures | 1287.72 | 1287.95 | 1285.62 | 1287.26 | 4874.0 |
| 2008-02-05 03:00:00 | ES | Futures | 1287.26 | 1288.19 | 1284.46 | 1285.16 | 9221.0 |
| 2008-02-05 04:00:00 | ES | Futures | 1285.16 | 1286.79 | 1282.83 | 1284.46 | 12040.0 |
| 2008-02-05 05:00:00 | ES | Futures | 1284.46 | 1288.19 | 1284.22 | 1285.86 | 10829.0 |
| 2008-02-05 06:00:00 | ES | Futures | 1285.62 | 1286.32 | 1283.29 | 1284.69 | 8134.0 |
| 2008-02-05 07:00:00 | ES | Futures | 1284.46 | 1284.46 | 1279.33 | 1280.96 | 33793.0 |
| 2008-02-05 08:00:00 | ES | Futures | 1280.73 | 1282.13 | 1266.04 | 1266.74 | 117095.0 |
| 2008-02-05 09:00:00 | ES | Futures | 1266.97 | 1271.63 | 1261.61 | 1269.54 | 402261.0 |
| 2008-02-05 10:00:00 | ES | Futures | 1269.54 | 1271.87 | 1261.61 | 1263.94 | 369532.0 |
| 2008-02-05 11:00:00 | ES | Futures | 1263.94 | 1267.9 | 1259.51 | 1266.27 | 272844.0 |
| 2008-02-05 12:00:00 | ES | Futures | 1266.27 | 1266.97 | 1257.64 | 1260.21 | 197056.0 |
| 2008-02-05 13:00:00 | ES | Futures | 1260.21 | 1263.47 | 1253.21 | 1255.31 | 257363.0 |
| 2008-02-05 14:00:00 | ES | Futures | 1255.08 | 1261.37 | 1252.05 | 1254.85 | 254534.0 |
| 2008-02-05 15:00:00 | ES | Futures | 1254.85 | 1256.25 | 1247.39 | 1248.32 | 441786.0 |
| 2008-02-05 16:00:00 | ES | Futures | 1248.09 | 1254.15 | 1247.39 | 1252.75 | 104293.0 |
| 2008-02-05 17:00:00 | ES | Futures | 1252.51 | 1254.38 | 1252.05 | 1252.75 | 3870.0 |
| 2008-02-05 18:00:00 | ES | Futures | 1253.21 | 1253.21 | 1251.35 | 1252.75 | 3564.0 |
| 2008-02-05 19:00:00 | ES | Futures | 1252.75 | 1255.31 | 1251.58 | 1252.98 | 4256.0 |
| 2008-02-05 20:00:00 | ES | Futures | 1252.75 | 1252.98 | 1249.72 | 1250.42 | 3335.0 |
| 2008-02-05 21:00:00 | ES | Futures | 1250.65 | 1251.58 | 1249.72 | 1249.95 | 1782.0 |
| 2008-02-05 22:00:00 | ES | Futures | 1249.95 | 1250.88 | 1249.02 | 1249.72 | 2724.0 |
| 2008-02-05 23:00:00 | ES | Futures | 1249.72 | 1251.35 | 1248.32 | 1249.95 | 2863.0 |
| 2008-02-05 00:00:00 | NQ | Futures | 2070.64 | 2074.05 | 2069.5 | 2074.05 | 90.0 |
| 2008-02-05 01:00:00 | NQ | Futures | 2074.05 | 2076.88 | 2071.77 | 2076.6 | 263.0 |
| 2008-02-05 02:00:00 | NQ | Futures | 2076.6 | 2078.02 | 2075.46 | 2077.74 | 481.0 |
| 2008-02-05 03:00:00 | NQ | Futures | 2077.45 | 2078.3 | 2074.05 | 2076.6 | 627.0 |
| 2008-02-05 04:00:00 | NQ | Futures | 2076.6 | 2077.74 | 2073.19 | 2074.61 | 501.0 |
| 2008-02-05 05:00:00 | NQ | Futures | 2074.61 | 2078.59 | 2073.76 | 2075.75 | 462.0 |
| 2008-02-05 06:00:00 | NQ | Futures | 2076.03 | 2076.88 | 2072.63 | 2076.03 | 494.0 |
| 2008-02-05 07:00:00 | NQ | Futures | 2075.46 | 2075.46 | 2067.52 | 2069.22 | 2069.0 |
| 2008-02-05 08:00:00 | NQ | Futures | 2069.22 | 2073.19 | 2045.95 | 2047.08 | 11572.0 |
| 2008-02-05 09:00:00 | NQ | Futures | 2047.08 | 2062.98 | 2041.4 | 2060.71 | 77822.0 |
| 2008-02-05 10:00:00 | NQ | Futures | 2060.42 | 2065.53 | 2047.93 | 2053.04 | 78080.0 |
| 2008-02-05 11:00:00 | NQ | Futures | 2053.04 | 2058.15 | 2046.51 | 2054.74 | 45530.0 |
| 2008-02-05 12:00:00 | NQ | Futures | 2055.03 | 2056.16 | 2042.26 | 2043.96 | 37697.0 |
| 2008-02-05 13:00:00 | NQ | Futures | 2043.67 | 2048.22 | 2031.19 | 2033.17 | 54045.0 |
| 2008-02-05 14:00:00 | NQ | Futures | 2033.46 | 2041.69 | 2027.5 | 2031.19 | 51404.0 |
| 2008-02-05 15:00:00 | NQ | Futures | 2031.19 | 2032.89 | 2019.55 | 2021.25 | 89973.0 |
| 2008-02-05 16:00:00 | NQ | Futures | 2021.53 | 2032.04 | 2019.55 | 2030.9 | 17800.0 |
| 2008-02-05 17:00:00 | NQ | Futures | 2030.62 | 2032.6 | 2028.35 | 2028.35 | 778.0 |
| 2008-02-05 18:00:00 | NQ | Futures | 2028.91 | 2029.2 | 2027.78 | 2028.91 | 407.0 |
| 2008-02-05 19:00:00 | NQ | Futures | 2029.2 | 2030.9 | 2027.21 | 2027.78 | 583.0 |
| 2008-02-05 20:00:00 | NQ | Futures | 2027.78 | 2027.78 | 2022.39 | 2022.95 | 238.0 |
| 2008-02-05 21:00:00 | NQ | Futures | 2023.24 | 2024.37 | 2020.97 | 2020.97 | 119.0 |
| 2008-02-05 22:00:00 | NQ | Futures | 2021.25 | 2022.39 | 2017.28 | 2020.97 | 227.0 |
| 2008-02-05 23:00:00 | NQ | Futures | 2022.1 | 2023.81 | 2017.56 | 2021.82 | 73.0 |
| 2008-02-05 00:00:00 | YM | Futures | 11435.3 | 11449.8 | 11432.5 | 11449.8 | 73.0 |
| 2008-02-05 01:00:00 | YM | Futures | 11450.7 | 11465.2 | 11445.3 | 11464.3 | 151.0 |
> showing 50 of 838 rows — these rows as CSV