PREVIEW / futures_1hour / 2010-02-02
file: by_date/futures_1hour/2010/2010-02-02.parquet size: 46 KB rows: 1,412
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-02 00:00:00 | ES | Futures | 1055.26 | 1056.23 | 1054.28 | 1054.53 | 2749.0 |
| 2010-02-02 01:00:00 | ES | Futures | 1054.28 | 1055.74 | 1054.04 | 1054.53 | 3221.0 |
| 2010-02-02 02:00:00 | ES | Futures | 1054.28 | 1057.69 | 1054.28 | 1057.2 | 12097.0 |
| 2010-02-02 03:00:00 | ES | Futures | 1057.2 | 1057.69 | 1052.82 | 1055.26 | 35035.0 |
| 2010-02-02 04:00:00 | ES | Futures | 1055.5 | 1058.42 | 1054.53 | 1058.18 | 20401.0 |
| 2010-02-02 05:00:00 | ES | Futures | 1058.18 | 1062.55 | 1058.18 | 1061.58 | 39383.0 |
| 2010-02-02 06:00:00 | ES | Futures | 1061.58 | 1061.58 | 1058.66 | 1059.39 | 24367.0 |
| 2010-02-02 07:00:00 | ES | Futures | 1059.39 | 1061.58 | 1059.15 | 1059.88 | 24263.0 |
| 2010-02-02 08:00:00 | ES | Futures | 1060.12 | 1060.37 | 1057.2 | 1057.93 | 44750.0 |
| 2010-02-02 09:00:00 | ES | Futures | 1057.93 | 1059.64 | 1055.26 | 1056.96 | 225708.0 |
| 2010-02-02 10:00:00 | ES | Futures | 1056.72 | 1065.72 | 1055.01 | 1064.5 | 418879.0 |
| 2010-02-02 11:00:00 | ES | Futures | 1064.5 | 1065.23 | 1061.58 | 1064.26 | 231901.0 |
| 2010-02-02 12:00:00 | ES | Futures | 1064.01 | 1067.42 | 1063.28 | 1067.18 | 156383.0 |
| 2010-02-02 13:00:00 | ES | Futures | 1067.18 | 1069.85 | 1065.23 | 1069.12 | 198505.0 |
| 2010-02-02 14:00:00 | ES | Futures | 1069.37 | 1069.61 | 1065.96 | 1068.15 | 165116.0 |
| 2010-02-02 15:00:00 | ES | Futures | 1068.15 | 1071.8 | 1066.93 | 1069.85 | 344484.0 |
| 2010-02-02 16:00:00 | ES | Futures | 1069.85 | 1069.85 | 1067.18 | 1068.88 | 127564.0 |
| 2010-02-02 17:00:00 | ES | Futures | 1069.12 | 1069.12 | 1068.39 | 1068.88 | 1819.0 |
| 2010-02-02 18:00:00 | ES | Futures | 1068.64 | 1070.1 | 1068.64 | 1068.64 | 6187.0 |
| 2010-02-02 19:00:00 | ES | Futures | 1068.64 | 1069.61 | 1067.66 | 1067.91 | 7012.0 |
| 2010-02-02 20:00:00 | ES | Futures | 1067.91 | 1068.64 | 1067.42 | 1067.66 | 3590.0 |
| 2010-02-02 21:00:00 | ES | Futures | 1067.66 | 1067.91 | 1065.96 | 1067.42 | 6029.0 |
| 2010-02-02 22:00:00 | ES | Futures | 1067.18 | 1068.15 | 1066.69 | 1068.15 | 4590.0 |
| 2010-02-02 23:00:00 | ES | Futures | 1068.15 | 1069.12 | 1066.69 | 1068.39 | 4212.0 |
| 2010-02-02 00:00:00 | NQ | Futures | 2004.26 | 2006.26 | 2002.26 | 2002.55 | 408.0 |
| 2010-02-02 01:00:00 | NQ | Futures | 2002.55 | 2004.83 | 2001.97 | 2003.12 | 279.0 |
| 2010-02-02 02:00:00 | NQ | Futures | 2003.12 | 2008.54 | 2002.26 | 2007.12 | 664.0 |
| 2010-02-02 03:00:00 | NQ | Futures | 2007.4 | 2007.97 | 2000.26 | 2003.69 | 2467.0 |
| 2010-02-02 04:00:00 | NQ | Futures | 2003.69 | 2009.12 | 2002.55 | 2008.83 | 1634.0 |
| 2010-02-02 05:00:00 | NQ | Futures | 2008.54 | 2015.4 | 2008.54 | 2013.4 | 3705.0 |
| 2010-02-02 06:00:00 | NQ | Futures | 2013.69 | 2013.69 | 2008.83 | 2009.97 | 1395.0 |
| 2010-02-02 07:00:00 | NQ | Futures | 2009.97 | 2014.26 | 2009.97 | 2011.69 | 1428.0 |
| 2010-02-02 08:00:00 | NQ | Futures | 2011.4 | 2011.97 | 2004.55 | 2006.54 | 4131.0 |
| 2010-02-02 09:00:00 | NQ | Futures | 2006.26 | 2013.69 | 2001.97 | 2003.4 | 51963.0 |
| 2010-02-02 10:00:00 | NQ | Futures | 2004.26 | 2019.4 | 1996.83 | 2013.11 | 82982.0 |
| 2010-02-02 11:00:00 | NQ | Futures | 2013.11 | 2019.4 | 2008.54 | 2016.83 | 37812.0 |
| 2010-02-02 12:00:00 | NQ | Futures | 2017.11 | 2021.97 | 2015.4 | 2021.11 | 25794.0 |
| 2010-02-02 13:00:00 | NQ | Futures | 2021.11 | 2026.25 | 2015.68 | 2023.4 | 26933.0 |
| 2010-02-02 14:00:00 | NQ | Futures | 2023.4 | 2025.11 | 2018.83 | 2025.11 | 24861.0 |
| 2010-02-02 15:00:00 | NQ | Futures | 2024.82 | 2031.39 | 2022.83 | 2025.68 | 48561.0 |
| 2010-02-02 16:00:00 | NQ | Futures | 2025.68 | 2025.97 | 2020.25 | 2023.68 | 13592.0 |
| 2010-02-02 17:00:00 | NQ | Futures | 2023.4 | 2023.68 | 2022.83 | 2022.83 | 20.0 |
| 2010-02-02 18:00:00 | NQ | Futures | 2022.54 | 2024.82 | 2022.54 | 2022.83 | 375.0 |
| 2010-02-02 19:00:00 | NQ | Futures | 2022.54 | 2023.68 | 2020.83 | 2021.4 | 357.0 |
| 2010-02-02 20:00:00 | NQ | Futures | 2021.4 | 2021.97 | 2020.54 | 2020.83 | 209.0 |
| 2010-02-02 21:00:00 | NQ | Futures | 2020.83 | 2020.83 | 2016.83 | 2020.25 | 542.0 |
| 2010-02-02 22:00:00 | NQ | Futures | 2019.97 | 2021.4 | 2019.11 | 2020.83 | 254.0 |
| 2010-02-02 23:00:00 | NQ | Futures | 2020.83 | 2022.25 | 2018.54 | 2021.11 | 323.0 |
| 2010-02-02 00:00:00 | YM | Futures | 9469.5 | 9475.1 | 9462.0 | 9463.9 | 282.0 |
| 2010-02-02 01:00:00 | YM | Futures | 9462.9 | 9473.2 | 9461.1 | 9465.7 | 455.0 |
> showing 50 of 1,412 rows — these rows as CSV