PREVIEW / futures_1hour / 2010-02-10
file: by_date/futures_1hour/2010/2010-02-10.parquet size: 46 KB rows: 1,377
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-10 00:00:00 | ES | Futures | 1035.07 | 1035.8 | 1034.34 | 1035.55 | 3782.0 |
| 2010-02-10 01:00:00 | ES | Futures | 1035.31 | 1037.01 | 1035.07 | 1036.77 | 7835.0 |
| 2010-02-10 02:00:00 | ES | Futures | 1036.53 | 1037.26 | 1035.07 | 1035.55 | 11301.0 |
| 2010-02-10 03:00:00 | ES | Futures | 1035.55 | 1037.74 | 1033.85 | 1034.58 | 45539.0 |
| 2010-02-10 04:00:00 | ES | Futures | 1034.58 | 1037.99 | 1034.09 | 1037.99 | 14463.0 |
| 2010-02-10 05:00:00 | ES | Futures | 1037.74 | 1043.09 | 1036.53 | 1040.9 | 61030.0 |
| 2010-02-10 06:00:00 | ES | Futures | 1040.9 | 1042.12 | 1039.93 | 1041.88 | 19073.0 |
| 2010-02-10 07:00:00 | ES | Futures | 1041.88 | 1043.58 | 1037.26 | 1037.99 | 61338.0 |
| 2010-02-10 08:00:00 | ES | Futures | 1038.23 | 1039.2 | 1036.04 | 1038.23 | 75169.0 |
| 2010-02-10 09:00:00 | ES | Futures | 1037.99 | 1040.9 | 1035.07 | 1037.26 | 198413.0 |
| 2010-02-10 10:00:00 | ES | Futures | 1037.26 | 1037.99 | 1027.77 | 1032.63 | 472269.0 |
| 2010-02-10 11:00:00 | ES | Futures | 1032.88 | 1036.28 | 1030.44 | 1033.61 | 225033.0 |
| 2010-02-10 12:00:00 | ES | Futures | 1033.61 | 1040.42 | 1032.63 | 1038.23 | 208949.0 |
| 2010-02-10 13:00:00 | ES | Futures | 1037.99 | 1042.61 | 1037.99 | 1039.93 | 206639.0 |
| 2010-02-10 14:00:00 | ES | Futures | 1039.69 | 1041.39 | 1036.28 | 1037.26 | 185704.0 |
| 2010-02-10 15:00:00 | ES | Futures | 1037.26 | 1039.69 | 1034.58 | 1036.53 | 266161.0 |
| 2010-02-10 16:00:00 | ES | Futures | 1036.53 | 1037.5 | 1034.34 | 1035.07 | 104987.0 |
| 2010-02-10 17:00:00 | ES | Futures | 1035.07 | 1035.55 | 1034.58 | 1035.07 | 1201.0 |
| 2010-02-10 18:00:00 | ES | Futures | 1035.31 | 1036.04 | 1035.07 | 1036.04 | 2452.0 |
| 2010-02-10 19:00:00 | ES | Futures | 1035.8 | 1039.2 | 1035.8 | 1038.72 | 9956.0 |
| 2010-02-10 20:00:00 | ES | Futures | 1038.47 | 1039.93 | 1037.99 | 1039.69 | 6431.0 |
| 2010-02-10 21:00:00 | ES | Futures | 1039.44 | 1040.9 | 1038.96 | 1039.93 | 7291.0 |
| 2010-02-10 22:00:00 | ES | Futures | 1039.69 | 1040.42 | 1039.2 | 1040.17 | 2454.0 |
| 2010-02-10 23:00:00 | ES | Futures | 1040.42 | 1041.15 | 1040.17 | 1040.66 | 2395.0 |
| 2010-02-10 00:00:00 | NQ | Futures | 1998.26 | 1999.12 | 1996.83 | 1998.83 | 220.0 |
| 2010-02-10 01:00:00 | NQ | Futures | 1998.55 | 2001.97 | 1998.55 | 2000.83 | 268.0 |
| 2010-02-10 02:00:00 | NQ | Futures | 2000.55 | 2002.83 | 1998.55 | 1999.12 | 636.0 |
| 2010-02-10 03:00:00 | NQ | Futures | 1999.4 | 2004.26 | 1996.83 | 1999.4 | 3759.0 |
| 2010-02-10 04:00:00 | NQ | Futures | 1999.4 | 2005.12 | 1999.12 | 2005.12 | 1286.0 |
| 2010-02-10 05:00:00 | NQ | Futures | 2005.12 | 2013.97 | 2003.4 | 2009.4 | 4925.0 |
| 2010-02-10 06:00:00 | NQ | Futures | 2009.4 | 2011.69 | 2006.54 | 2009.69 | 2567.0 |
| 2010-02-10 07:00:00 | NQ | Futures | 2009.4 | 2012.83 | 2001.69 | 2002.83 | 3518.0 |
| 2010-02-10 08:00:00 | NQ | Futures | 2002.83 | 2005.97 | 1999.4 | 2003.4 | 4845.0 |
| 2010-02-10 09:00:00 | NQ | Futures | 2003.69 | 2009.4 | 1996.83 | 2002.55 | 33475.0 |
| 2010-02-10 10:00:00 | NQ | Futures | 2002.83 | 2003.4 | 1983.41 | 1991.12 | 70057.0 |
| 2010-02-10 11:00:00 | NQ | Futures | 1991.41 | 1996.26 | 1986.84 | 1991.12 | 31161.0 |
| 2010-02-10 12:00:00 | NQ | Futures | 1991.12 | 2003.12 | 1988.55 | 2000.55 | 34544.0 |
| 2010-02-10 13:00:00 | NQ | Futures | 2000.55 | 2007.4 | 1999.12 | 2003.12 | 29824.0 |
| 2010-02-10 14:00:00 | NQ | Futures | 2002.83 | 2005.12 | 1997.12 | 1999.4 | 26677.0 |
| 2010-02-10 15:00:00 | NQ | Futures | 1999.4 | 2002.83 | 1994.55 | 1996.26 | 37450.0 |
| 2010-02-10 16:00:00 | NQ | Futures | 1996.26 | 1997.12 | 1991.98 | 1995.12 | 8715.0 |
| 2010-02-10 17:00:00 | NQ | Futures | 1994.83 | 1995.12 | 1993.98 | 1994.26 | 45.0 |
| 2010-02-10 18:00:00 | NQ | Futures | 1994.26 | 1995.98 | 1994.26 | 1995.41 | 116.0 |
| 2010-02-10 19:00:00 | NQ | Futures | 1995.69 | 2001.4 | 1995.41 | 2000.83 | 506.0 |
| 2010-02-10 20:00:00 | NQ | Futures | 2000.83 | 2001.4 | 1999.4 | 2000.83 | 457.0 |
| 2010-02-10 21:00:00 | NQ | Futures | 2000.55 | 2002.55 | 2000.55 | 2001.12 | 555.0 |
| 2010-02-10 22:00:00 | NQ | Futures | 2001.4 | 2001.97 | 2000.26 | 2001.97 | 196.0 |
| 2010-02-10 23:00:00 | NQ | Futures | 2001.97 | 2005.12 | 2001.97 | 2003.4 | 226.0 |
| 2010-02-10 00:00:00 | YM | Futures | 9348.8 | 9351.6 | 9341.3 | 9349.7 | 222.0 |
| 2010-02-10 01:00:00 | YM | Futures | 9349.7 | 9365.6 | 9348.8 | 9361.9 | 331.0 |
> showing 50 of 1,377 rows — these rows as CSV