PREVIEW / futures_1hour / 2009-11-10
file: by_date/futures_1hour/2009/2009-11-10.parquet size: 43 KB rows: 1,305
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 |
|---|---|---|---|---|---|---|---|
| 2009-11-10 00:00:00 | ES | Futures | 1056.09 | 1056.33 | 1054.15 | 1054.15 | 9037.0 |
| 2009-11-10 01:00:00 | ES | Futures | 1054.39 | 1055.36 | 1053.66 | 1055.12 | 4957.0 |
| 2009-11-10 02:00:00 | ES | Futures | 1055.12 | 1055.36 | 1053.66 | 1053.91 | 9889.0 |
| 2009-11-10 03:00:00 | ES | Futures | 1053.91 | 1055.36 | 1052.94 | 1054.63 | 36858.0 |
| 2009-11-10 04:00:00 | ES | Futures | 1054.88 | 1056.57 | 1054.39 | 1055.12 | 19608.0 |
| 2009-11-10 05:00:00 | ES | Futures | 1055.36 | 1057.06 | 1052.94 | 1056.57 | 26418.0 |
| 2009-11-10 06:00:00 | ES | Futures | 1056.57 | 1056.57 | 1054.63 | 1054.88 | 13315.0 |
| 2009-11-10 07:00:00 | ES | Futures | 1054.63 | 1055.6 | 1053.66 | 1054.88 | 22714.0 |
| 2009-11-10 08:00:00 | ES | Futures | 1054.88 | 1055.36 | 1053.42 | 1054.15 | 31897.0 |
| 2009-11-10 09:00:00 | ES | Futures | 1053.91 | 1059.48 | 1052.94 | 1057.54 | 222085.0 |
| 2009-11-10 10:00:00 | ES | Futures | 1057.3 | 1060.45 | 1054.39 | 1054.63 | 321401.0 |
| 2009-11-10 11:00:00 | ES | Futures | 1054.39 | 1056.81 | 1052.45 | 1054.63 | 279620.0 |
| 2009-11-10 12:00:00 | ES | Futures | 1054.63 | 1055.12 | 1051.24 | 1054.88 | 177882.0 |
| 2009-11-10 13:00:00 | ES | Futures | 1054.63 | 1055.12 | 1052.45 | 1054.63 | 122241.0 |
| 2009-11-10 14:00:00 | ES | Futures | 1054.63 | 1057.78 | 1053.66 | 1057.06 | 139210.0 |
| 2009-11-10 15:00:00 | ES | Futures | 1057.3 | 1059.24 | 1055.12 | 1056.81 | 269890.0 |
| 2009-11-10 16:00:00 | ES | Futures | 1056.81 | 1059.72 | 1056.81 | 1059.24 | 70971.0 |
| 2009-11-10 17:00:00 | ES | Futures | 1059.48 | 1059.96 | 1058.99 | 1059.72 | 2466.0 |
| 2009-11-10 18:00:00 | ES | Futures | 1059.72 | 1060.2 | 1058.99 | 1059.96 | 3567.0 |
| 2009-11-10 19:00:00 | ES | Futures | 1059.96 | 1062.87 | 1059.96 | 1061.42 | 10303.0 |
| 2009-11-10 20:00:00 | ES | Futures | 1061.42 | 1061.66 | 1059.72 | 1060.2 | 5439.0 |
| 2009-11-10 21:00:00 | ES | Futures | 1059.96 | 1061.66 | 1059.72 | 1060.93 | 6485.0 |
| 2009-11-10 22:00:00 | ES | Futures | 1061.17 | 1061.42 | 1058.99 | 1059.24 | 3010.0 |
| 2009-11-10 23:00:00 | ES | Futures | 1059.48 | 1059.72 | 1058.99 | 1058.99 | 3021.0 |
| 2009-11-10 00:00:00 | NQ | Futures | 2012.04 | 2012.04 | 2008.05 | 2008.34 | 528.0 |
| 2009-11-10 01:00:00 | NQ | Futures | 2008.34 | 2010.33 | 2007.77 | 2009.76 | 290.0 |
| 2009-11-10 02:00:00 | NQ | Futures | 2010.05 | 2010.62 | 2008.62 | 2009.48 | 1111.0 |
| 2009-11-10 03:00:00 | NQ | Futures | 2009.48 | 2012.62 | 2007.2 | 2011.76 | 2347.0 |
| 2009-11-10 04:00:00 | NQ | Futures | 2012.04 | 2014.33 | 2009.19 | 2009.76 | 2511.0 |
| 2009-11-10 05:00:00 | NQ | Futures | 2009.48 | 2014.9 | 2006.63 | 2014.33 | 2428.0 |
| 2009-11-10 06:00:00 | NQ | Futures | 2014.04 | 2014.33 | 2010.33 | 2010.62 | 860.0 |
| 2009-11-10 07:00:00 | NQ | Futures | 2010.33 | 2013.76 | 2009.76 | 2012.04 | 2057.0 |
| 2009-11-10 08:00:00 | NQ | Futures | 2012.04 | 2012.9 | 2010.62 | 2011.76 | 2739.0 |
| 2009-11-10 09:00:00 | NQ | Futures | 2011.76 | 2026.59 | 2009.76 | 2023.17 | 41429.0 |
| 2009-11-10 10:00:00 | NQ | Futures | 2023.17 | 2026.59 | 2012.9 | 2014.33 | 44285.0 |
| 2009-11-10 11:00:00 | NQ | Futures | 2014.04 | 2018.32 | 2010.33 | 2014.61 | 32215.0 |
| 2009-11-10 12:00:00 | NQ | Futures | 2014.61 | 2018.32 | 2010.62 | 2017.75 | 24387.0 |
| 2009-11-10 13:00:00 | NQ | Futures | 2018.03 | 2018.89 | 2014.33 | 2018.03 | 21309.0 |
| 2009-11-10 14:00:00 | NQ | Futures | 2017.75 | 2024.02 | 2016.61 | 2022.88 | 29361.0 |
| 2009-11-10 15:00:00 | NQ | Futures | 2022.88 | 2025.73 | 2017.46 | 2020.32 | 36775.0 |
| 2009-11-10 16:00:00 | NQ | Futures | 2020.03 | 2024.59 | 2019.46 | 2023.74 | 8056.0 |
| 2009-11-10 17:00:00 | NQ | Futures | 2023.74 | 2024.59 | 2022.88 | 2024.31 | 271.0 |
| 2009-11-10 18:00:00 | NQ | Futures | 2024.02 | 2024.88 | 2023.17 | 2024.88 | 195.0 |
| 2009-11-10 19:00:00 | NQ | Futures | 2024.88 | 2027.73 | 2024.88 | 2026.87 | 1147.0 |
| 2009-11-10 20:00:00 | NQ | Futures | 2026.87 | 2026.87 | 2023.74 | 2024.31 | 532.0 |
| 2009-11-10 21:00:00 | NQ | Futures | 2024.31 | 2027.16 | 2024.31 | 2025.73 | 380.0 |
| 2009-11-10 22:00:00 | NQ | Futures | 2025.73 | 2026.3 | 2022.88 | 2023.17 | 207.0 |
| 2009-11-10 23:00:00 | NQ | Futures | 2023.17 | 2024.02 | 2022.88 | 2023.17 | 167.0 |
| 2009-11-10 00:00:00 | YM | Futures | 9472.1 | 9472.1 | 9455.3 | 9455.3 | 628.0 |
| 2009-11-10 01:00:00 | YM | Futures | 9456.3 | 9465.6 | 9453.5 | 9461.8 | 420.0 |
> showing 50 of 1,305 rows — these rows as CSV