PREVIEW / futures_1hour / 2008-02-20
file: by_date/futures_1hour/2008/2008-02-20.parquet size: 33 KB rows: 891
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-20 00:00:00 | ES | Futures | 1256.71 | 1257.88 | 1255.31 | 1256.25 | 3817.0 |
| 2008-02-20 01:00:00 | ES | Futures | 1256.25 | 1256.48 | 1254.61 | 1255.31 | 3609.0 |
| 2008-02-20 02:00:00 | ES | Futures | 1255.08 | 1257.88 | 1254.38 | 1255.31 | 10579.0 |
| 2008-02-20 03:00:00 | ES | Futures | 1255.31 | 1258.58 | 1253.45 | 1257.64 | 20603.0 |
| 2008-02-20 04:00:00 | ES | Futures | 1257.64 | 1261.84 | 1255.55 | 1261.84 | 18547.0 |
| 2008-02-20 05:00:00 | ES | Futures | 1261.61 | 1261.61 | 1255.55 | 1256.01 | 14610.0 |
| 2008-02-20 06:00:00 | ES | Futures | 1256.01 | 1256.71 | 1253.91 | 1254.15 | 11930.0 |
| 2008-02-20 07:00:00 | ES | Futures | 1254.15 | 1255.31 | 1249.48 | 1252.75 | 37195.0 |
| 2008-02-20 08:00:00 | ES | Futures | 1252.51 | 1254.85 | 1242.96 | 1246.92 | 107859.0 |
| 2008-02-20 09:00:00 | ES | Futures | 1247.15 | 1253.21 | 1244.82 | 1249.48 | 261654.0 |
| 2008-02-20 10:00:00 | ES | Futures | 1249.48 | 1254.38 | 1246.22 | 1250.65 | 306072.0 |
| 2008-02-20 11:00:00 | ES | Futures | 1250.65 | 1254.15 | 1249.02 | 1251.58 | 143122.0 |
| 2008-02-20 12:00:00 | ES | Futures | 1251.58 | 1264.17 | 1250.65 | 1260.21 | 349702.0 |
| 2008-02-20 13:00:00 | ES | Futures | 1260.21 | 1266.74 | 1258.58 | 1262.31 | 196931.0 |
| 2008-02-20 14:00:00 | ES | Futures | 1262.31 | 1272.8 | 1257.88 | 1270.93 | 380047.0 |
| 2008-02-20 15:00:00 | ES | Futures | 1270.93 | 1271.63 | 1264.17 | 1268.6 | 238183.0 |
| 2008-02-20 16:00:00 | ES | Futures | 1268.37 | 1268.84 | 1266.04 | 1266.97 | 68734.0 |
| 2008-02-20 17:00:00 | ES | Futures | 1267.2 | 1267.9 | 1266.74 | 1267.2 | 1593.0 |
| 2008-02-20 18:00:00 | ES | Futures | 1267.44 | 1269.77 | 1267.44 | 1269.07 | 2940.0 |
| 2008-02-20 19:00:00 | ES | Futures | 1269.07 | 1271.17 | 1268.84 | 1269.54 | 2395.0 |
| 2008-02-20 20:00:00 | ES | Futures | 1269.54 | 1271.17 | 1269.3 | 1271.17 | 1152.0 |
| 2008-02-20 21:00:00 | ES | Futures | 1270.93 | 1271.17 | 1268.6 | 1268.6 | 1153.0 |
| 2008-02-20 22:00:00 | ES | Futures | 1268.84 | 1271.17 | 1268.37 | 1271.17 | 1597.0 |
| 2008-02-20 23:00:00 | ES | Futures | 1270.93 | 1271.87 | 1270.23 | 1270.93 | 979.0 |
| 2008-02-20 00:00:00 | NQ | Futures | 2015.57 | 2017.28 | 2013.59 | 2014.15 | 355.0 |
| 2008-02-20 01:00:00 | NQ | Futures | 2014.15 | 2014.44 | 2011.03 | 2012.17 | 369.0 |
| 2008-02-20 02:00:00 | NQ | Futures | 2011.03 | 2015.29 | 2010.18 | 2011.32 | 527.0 |
| 2008-02-20 03:00:00 | NQ | Futures | 2011.03 | 2012.17 | 2007.63 | 2011.03 | 3124.0 |
| 2008-02-20 04:00:00 | NQ | Futures | 2011.03 | 2017.84 | 2007.06 | 2017.56 | 680.0 |
| 2008-02-20 05:00:00 | NQ | Futures | 2016.71 | 2017.56 | 2010.46 | 2011.88 | 860.0 |
| 2008-02-20 06:00:00 | NQ | Futures | 2011.6 | 2012.17 | 2009.05 | 2009.9 | 753.0 |
| 2008-02-20 07:00:00 | NQ | Futures | 2009.33 | 2011.32 | 2002.52 | 2006.21 | 2203.0 |
| 2008-02-20 08:00:00 | NQ | Futures | 2005.92 | 2012.17 | 1990.03 | 1992.58 | 19247.0 |
| 2008-02-20 09:00:00 | NQ | Futures | 1992.58 | 2011.88 | 1991.73 | 2005.36 | 54509.0 |
| 2008-02-20 10:00:00 | NQ | Futures | 2005.36 | 2015.86 | 1999.68 | 2004.79 | 55407.0 |
| 2008-02-20 11:00:00 | NQ | Futures | 2004.5 | 2007.63 | 2000.25 | 2003.65 | 23943.0 |
| 2008-02-20 12:00:00 | NQ | Futures | 2003.65 | 2028.63 | 2002.8 | 2018.7 | 75388.0 |
| 2008-02-20 13:00:00 | NQ | Futures | 2018.41 | 2029.77 | 2013.87 | 2024.66 | 44683.0 |
| 2008-02-20 14:00:00 | NQ | Futures | 2024.66 | 2038.85 | 2014.15 | 2036.86 | 70056.0 |
| 2008-02-20 15:00:00 | NQ | Futures | 2036.58 | 2037.43 | 2024.66 | 2032.6 | 54744.0 |
| 2008-02-20 16:00:00 | NQ | Futures | 2032.6 | 2036.58 | 2029.48 | 2032.04 | 11164.0 |
| 2008-02-20 17:00:00 | NQ | Futures | 2032.32 | 2033.74 | 2031.47 | 2032.89 | 234.0 |
| 2008-02-20 18:00:00 | NQ | Futures | 2033.46 | 2036.86 | 2033.17 | 2035.44 | 186.0 |
| 2008-02-20 19:00:00 | NQ | Futures | 2035.73 | 2036.86 | 2035.16 | 2035.73 | 114.0 |
| 2008-02-20 20:00:00 | NQ | Futures | 2035.44 | 2036.86 | 2035.16 | 2035.73 | 55.0 |
| 2008-02-20 21:00:00 | NQ | Futures | 2036.29 | 2037.71 | 2034.59 | 2034.59 | 129.0 |
| 2008-02-20 22:00:00 | NQ | Futures | 2035.16 | 2037.71 | 2034.02 | 2037.71 | 112.0 |
| 2008-02-20 23:00:00 | NQ | Futures | 2037.71 | 2037.71 | 2037.15 | 2037.71 | 38.0 |
| 2008-02-20 00:00:00 | YM | Futures | 11199.1 | 11207.2 | 11193.6 | 11200.9 | 117.0 |
| 2008-02-20 01:00:00 | YM | Futures | 11195.4 | 11197.2 | 11180.9 | 11185.4 | 289.0 |
> showing 50 of 891 rows — these rows as CSV