PREVIEW / futures_1hour / 2008-01-21
file: by_date/futures_1hour/2008/2008-01-21.parquet size: 24 KB rows: 567
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-01-21 00:00:00 | ES | Futures | 1231.76 | 1232.0 | 1229.43 | 1229.9 | 3688.0 |
| 2008-01-21 01:00:00 | ES | Futures | 1229.9 | 1230.83 | 1228.5 | 1228.97 | 2071.0 |
| 2008-01-21 02:00:00 | ES | Futures | 1228.97 | 1228.97 | 1218.24 | 1219.41 | 17927.0 |
| 2008-01-21 03:00:00 | ES | Futures | 1219.41 | 1220.57 | 1195.86 | 1204.72 | 57786.0 |
| 2008-01-21 04:00:00 | ES | Futures | 1204.72 | 1209.61 | 1199.82 | 1207.05 | 25315.0 |
| 2008-01-21 05:00:00 | ES | Futures | 1207.05 | 1208.68 | 1183.5 | 1188.63 | 54070.0 |
| 2008-01-21 06:00:00 | ES | Futures | 1188.63 | 1193.99 | 1171.61 | 1178.37 | 70970.0 |
| 2008-01-21 07:00:00 | ES | Futures | 1178.37 | 1194.46 | 1175.81 | 1190.5 | 64818.0 |
| 2008-01-21 08:00:00 | ES | Futures | 1190.73 | 1197.26 | 1186.76 | 1197.02 | 55933.0 |
| 2008-01-21 09:00:00 | ES | Futures | 1197.02 | 1198.19 | 1190.26 | 1196.09 | 41754.0 |
| 2008-01-21 10:00:00 | ES | Futures | 1196.09 | 1196.32 | 1183.27 | 1184.67 | 56624.0 |
| 2008-01-21 11:00:00 | ES | Futures | 1184.67 | 1187.23 | 1178.6 | 1180.24 | 40526.0 |
| 2008-01-21 18:00:00 | ES | Futures | 1179.77 | 1187.0 | 1179.77 | 1185.83 | 28625.0 |
| 2008-01-21 19:00:00 | ES | Futures | 1185.83 | 1186.3 | 1176.51 | 1177.21 | 25839.0 |
| 2008-01-21 20:00:00 | ES | Futures | 1177.21 | 1183.5 | 1174.87 | 1176.74 | 24765.0 |
| 2008-01-21 21:00:00 | ES | Futures | 1176.97 | 1185.83 | 1176.27 | 1184.9 | 8756.0 |
| 2008-01-21 22:00:00 | ES | Futures | 1184.9 | 1188.16 | 1180.94 | 1182.1 | 9843.0 |
| 2008-01-21 23:00:00 | ES | Futures | 1182.1 | 1182.33 | 1174.87 | 1178.14 | 9665.0 |
| 2008-01-21 00:00:00 | NQ | Futures | 2095.62 | 2095.62 | 2091.93 | 2092.78 | 218.0 |
| 2008-01-21 01:00:00 | NQ | Futures | 2092.21 | 2093.91 | 2091.08 | 2091.36 | 109.0 |
| 2008-01-21 02:00:00 | NQ | Futures | 2091.08 | 2091.08 | 2074.9 | 2078.87 | 3005.0 |
| 2008-01-21 03:00:00 | NQ | Futures | 2078.87 | 2080.29 | 2034.02 | 2053.04 | 5140.0 |
| 2008-01-21 04:00:00 | NQ | Futures | 2053.89 | 2058.15 | 2047.65 | 2052.76 | 2168.0 |
| 2008-01-21 05:00:00 | NQ | Futures | 2052.76 | 2055.03 | 2020.97 | 2031.75 | 3383.0 |
| 2008-01-21 06:00:00 | NQ | Futures | 2030.62 | 2037.43 | 1992.87 | 2004.79 | 4958.0 |
| 2008-01-21 07:00:00 | NQ | Futures | 2006.21 | 2033.46 | 1999.96 | 2030.05 | 4573.0 |
| 2008-01-21 08:00:00 | NQ | Futures | 2030.62 | 2040.55 | 2027.78 | 2039.42 | 3220.0 |
| 2008-01-21 09:00:00 | NQ | Futures | 2038.85 | 2042.54 | 2030.62 | 2041.4 | 3016.0 |
| 2008-01-21 10:00:00 | NQ | Futures | 2041.4 | 2041.97 | 2019.26 | 2019.26 | 5997.0 |
| 2008-01-21 11:00:00 | NQ | Futures | 2020.12 | 2024.66 | 2009.61 | 2014.15 | 2992.0 |
| 2008-01-21 18:00:00 | NQ | Futures | 2020.68 | 2023.52 | 2013.59 | 2020.97 | 1781.0 |
| 2008-01-21 19:00:00 | NQ | Futures | 2021.82 | 2022.1 | 2005.36 | 2012.17 | 1465.0 |
| 2008-01-21 20:00:00 | NQ | Futures | 2011.6 | 2019.83 | 1998.26 | 2011.32 | 1681.0 |
| 2008-01-21 21:00:00 | NQ | Futures | 2010.75 | 2024.09 | 2008.76 | 2021.25 | 507.0 |
| 2008-01-21 22:00:00 | NQ | Futures | 2021.53 | 2029.77 | 2017.84 | 2019.83 | 853.0 |
| 2008-01-21 23:00:00 | NQ | Futures | 2018.7 | 2019.55 | 2009.05 | 2010.46 | 822.0 |
| 2008-01-21 00:00:00 | YM | Futures | 10965.6 | 10965.6 | 10948.3 | 10954.7 | 245.0 |
| 2008-01-21 01:00:00 | YM | Futures | 10955.6 | 10964.7 | 10944.7 | 10944.7 | 241.0 |
| 2008-01-21 02:00:00 | YM | Futures | 10944.7 | 10947.4 | 10861.1 | 10869.3 | 1462.0 |
| 2008-01-21 03:00:00 | YM | Futures | 10868.4 | 10878.4 | 10647.6 | 10775.7 | 2826.0 |
| 2008-01-21 04:00:00 | YM | Futures | 10780.2 | 10800.2 | 10745.7 | 10779.3 | 1186.0 |
| 2008-01-21 05:00:00 | YM | Futures | 10784.8 | 10797.5 | 10635.8 | 10658.5 | 2362.0 |
| 2008-01-21 06:00:00 | YM | Futures | 10656.7 | 10697.6 | 10541.3 | 10561.3 | 2331.0 |
| 2008-01-21 07:00:00 | YM | Futures | 10566.7 | 10691.2 | 10543.1 | 10673.0 | 1568.0 |
| 2008-01-21 08:00:00 | YM | Futures | 10673.9 | 10729.4 | 10638.5 | 10728.5 | 2022.0 |
| 2008-01-21 09:00:00 | YM | Futures | 10724.8 | 10733.0 | 10665.8 | 10705.7 | 2308.0 |
| 2008-01-21 10:00:00 | YM | Futures | 10704.8 | 10708.5 | 10570.4 | 10576.7 | 4344.0 |
| 2008-01-21 11:00:00 | YM | Futures | 10576.7 | 10593.1 | 10516.8 | 10525.9 | 3072.0 |
| 2008-01-21 18:00:00 | YM | Futures | 10534.0 | 10998.3 | 10533.1 | 10584.9 | 1333.0 |
| 2008-01-21 19:00:00 | YM | Futures | 10584.9 | 10589.5 | 10515.9 | 10519.5 | 1338.0 |
> showing 50 of 567 rows — these rows as CSV