PREVIEW / futures_1hour / 2010-02-03
file: by_date/futures_1hour/2010/2010-02-03.parquet size: 46 KB rows: 1,393
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 |
|---|---|---|---|---|---|---|---|
| 2010-02-03 00:00:00 | ES | Futures | 1068.39 | 1069.12 | 1068.15 | 1068.88 | 1974.0 |
| 2010-02-03 01:00:00 | ES | Futures | 1068.88 | 1070.34 | 1068.39 | 1069.61 | 4809.0 |
| 2010-02-03 02:00:00 | ES | Futures | 1069.61 | 1070.58 | 1068.64 | 1069.37 | 9736.0 |
| 2010-02-03 03:00:00 | ES | Futures | 1069.37 | 1070.1 | 1066.45 | 1068.88 | 32116.0 |
| 2010-02-03 04:00:00 | ES | Futures | 1069.12 | 1070.34 | 1068.39 | 1069.12 | 21481.0 |
| 2010-02-03 05:00:00 | ES | Futures | 1069.37 | 1069.61 | 1066.93 | 1068.39 | 13828.0 |
| 2010-02-03 06:00:00 | ES | Futures | 1068.39 | 1069.85 | 1067.42 | 1069.61 | 10139.0 |
| 2010-02-03 07:00:00 | ES | Futures | 1069.61 | 1069.85 | 1066.69 | 1066.69 | 25667.0 |
| 2010-02-03 08:00:00 | ES | Futures | 1066.69 | 1068.15 | 1063.04 | 1064.01 | 104566.0 |
| 2010-02-03 09:00:00 | ES | Futures | 1064.26 | 1069.85 | 1063.53 | 1069.37 | 233332.0 |
| 2010-02-03 10:00:00 | ES | Futures | 1069.37 | 1069.37 | 1061.82 | 1064.74 | 340954.0 |
| 2010-02-03 11:00:00 | ES | Futures | 1064.74 | 1066.69 | 1061.09 | 1061.34 | 228480.0 |
| 2010-02-03 12:00:00 | ES | Futures | 1061.34 | 1064.99 | 1061.09 | 1064.01 | 154038.0 |
| 2010-02-03 13:00:00 | ES | Futures | 1064.01 | 1067.66 | 1063.77 | 1065.23 | 141009.0 |
| 2010-02-03 14:00:00 | ES | Futures | 1065.23 | 1065.96 | 1062.55 | 1064.5 | 158197.0 |
| 2010-02-03 15:00:00 | ES | Futures | 1064.5 | 1067.18 | 1063.04 | 1064.26 | 264307.0 |
| 2010-02-03 16:00:00 | ES | Futures | 1064.26 | 1068.15 | 1064.01 | 1067.91 | 103410.0 |
| 2010-02-03 17:00:00 | ES | Futures | 1067.66 | 1068.64 | 1067.42 | 1067.42 | 5350.0 |
| 2010-02-03 18:00:00 | ES | Futures | 1067.91 | 1068.64 | 1067.42 | 1067.42 | 4858.0 |
| 2010-02-03 19:00:00 | ES | Futures | 1067.66 | 1067.91 | 1065.72 | 1066.2 | 6674.0 |
| 2010-02-03 20:00:00 | ES | Futures | 1066.2 | 1066.45 | 1065.47 | 1065.72 | 3375.0 |
| 2010-02-03 21:00:00 | ES | Futures | 1065.47 | 1066.93 | 1065.47 | 1066.69 | 2520.0 |
| 2010-02-03 22:00:00 | ES | Futures | 1066.69 | 1067.66 | 1066.2 | 1066.2 | 4316.0 |
| 2010-02-03 23:00:00 | ES | Futures | 1066.2 | 1066.45 | 1064.99 | 1065.47 | 3774.0 |
| 2010-02-03 00:00:00 | NQ | Futures | 2021.11 | 2022.83 | 2021.11 | 2022.54 | 137.0 |
| 2010-02-03 01:00:00 | NQ | Futures | 2022.54 | 2025.11 | 2021.97 | 2023.68 | 248.0 |
| 2010-02-03 02:00:00 | NQ | Futures | 2023.97 | 2025.97 | 2022.54 | 2023.68 | 717.0 |
| 2010-02-03 03:00:00 | NQ | Futures | 2023.68 | 2025.11 | 2019.11 | 2023.4 | 2765.0 |
| 2010-02-03 04:00:00 | NQ | Futures | 2023.68 | 2025.97 | 2022.54 | 2023.68 | 1451.0 |
| 2010-02-03 05:00:00 | NQ | Futures | 2023.4 | 2024.82 | 2019.68 | 2023.11 | 1629.0 |
| 2010-02-03 06:00:00 | NQ | Futures | 2022.83 | 2026.25 | 2021.4 | 2025.11 | 1095.0 |
| 2010-02-03 07:00:00 | NQ | Futures | 2025.11 | 2026.25 | 2020.25 | 2020.25 | 1478.0 |
| 2010-02-03 08:00:00 | NQ | Futures | 2020.54 | 2023.4 | 2014.83 | 2015.97 | 7407.0 |
| 2010-02-03 09:00:00 | NQ | Futures | 2015.97 | 2029.97 | 2015.11 | 2029.11 | 45108.0 |
| 2010-02-03 10:00:00 | NQ | Futures | 2028.54 | 2031.11 | 2017.11 | 2025.11 | 62465.0 |
| 2010-02-03 11:00:00 | NQ | Futures | 2024.82 | 2033.39 | 2023.68 | 2023.68 | 43205.0 |
| 2010-02-03 12:00:00 | NQ | Futures | 2023.68 | 2033.97 | 2022.83 | 2031.68 | 32475.0 |
| 2010-02-03 13:00:00 | NQ | Futures | 2031.39 | 2039.11 | 2031.11 | 2036.25 | 27460.0 |
| 2010-02-03 14:00:00 | NQ | Futures | 2036.25 | 2037.68 | 2031.97 | 2035.96 | 25874.0 |
| 2010-02-03 15:00:00 | NQ | Futures | 2035.96 | 2040.53 | 2034.54 | 2037.11 | 43645.0 |
| 2010-02-03 16:00:00 | NQ | Futures | 2036.82 | 2046.25 | 2035.96 | 2044.25 | 17867.0 |
| 2010-02-03 17:00:00 | NQ | Futures | 2044.53 | 2046.82 | 2043.96 | 2043.96 | 901.0 |
| 2010-02-03 18:00:00 | NQ | Futures | 2045.68 | 2047.39 | 2045.39 | 2045.68 | 926.0 |
| 2010-02-03 19:00:00 | NQ | Futures | 2045.68 | 2046.25 | 2042.82 | 2043.68 | 755.0 |
| 2010-02-03 20:00:00 | NQ | Futures | 2043.68 | 2043.96 | 2042.25 | 2043.11 | 351.0 |
| 2010-02-03 21:00:00 | NQ | Futures | 2043.11 | 2044.25 | 2043.11 | 2043.39 | 329.0 |
| 2010-02-03 22:00:00 | NQ | Futures | 2043.68 | 2045.1 | 2042.53 | 2043.39 | 428.0 |
| 2010-02-03 23:00:00 | NQ | Futures | 2043.11 | 2043.11 | 2041.11 | 2041.39 | 338.0 |
| 2010-02-03 00:00:00 | YM | Futures | 9574.3 | 9581.8 | 9574.3 | 9581.8 | 206.0 |
| 2010-02-03 01:00:00 | YM | Futures | 9580.8 | 9593.0 | 9577.1 | 9585.5 | 447.0 |
> showing 50 of 1,393 rows — these rows as CSV