PREVIEW / futures_1hour / 2008-02-08
file: by_date/futures_1hour/2008/2008-02-08.parquet size: 26 KB rows: 666
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-08 00:00:00 | ES | Futures | 1248.32 | 1248.32 | 1246.22 | 1246.45 | 2782.0 |
| 2008-02-08 01:00:00 | ES | Futures | 1246.69 | 1249.48 | 1246.45 | 1249.48 | 1817.0 |
| 2008-02-08 02:00:00 | ES | Futures | 1249.25 | 1249.48 | 1246.22 | 1249.02 | 5391.0 |
| 2008-02-08 03:00:00 | ES | Futures | 1249.02 | 1253.21 | 1248.09 | 1252.05 | 16432.0 |
| 2008-02-08 04:00:00 | ES | Futures | 1251.82 | 1252.28 | 1247.15 | 1248.09 | 13734.0 |
| 2008-02-08 05:00:00 | ES | Futures | 1248.09 | 1249.25 | 1244.35 | 1245.05 | 24350.0 |
| 2008-02-08 06:00:00 | ES | Futures | 1245.05 | 1246.45 | 1241.32 | 1241.79 | 24203.0 |
| 2008-02-08 07:00:00 | ES | Futures | 1241.79 | 1244.59 | 1239.46 | 1241.79 | 38725.0 |
| 2008-02-08 08:00:00 | ES | Futures | 1241.79 | 1244.12 | 1237.83 | 1241.32 | 45385.0 |
| 2008-02-08 09:00:00 | ES | Futures | 1241.32 | 1248.55 | 1240.16 | 1248.09 | 225753.0 |
| 2008-02-08 10:00:00 | ES | Futures | 1248.09 | 1249.95 | 1244.35 | 1247.39 | 231174.0 |
| 2008-02-08 11:00:00 | ES | Futures | 1247.62 | 1252.05 | 1242.26 | 1242.72 | 191089.0 |
| 2008-02-08 12:00:00 | ES | Futures | 1242.72 | 1243.89 | 1238.29 | 1242.96 | 183830.0 |
| 2008-02-08 13:00:00 | ES | Futures | 1242.96 | 1243.19 | 1232.0 | 1237.83 | 220315.0 |
| 2008-02-08 14:00:00 | ES | Futures | 1237.83 | 1242.26 | 1235.49 | 1237.13 | 139972.0 |
| 2008-02-08 15:00:00 | ES | Futures | 1236.89 | 1247.39 | 1235.96 | 1241.79 | 263389.0 |
| 2008-02-08 16:00:00 | ES | Futures | 1241.79 | 1242.26 | 1239.69 | 1241.09 | 57098.0 |
| 2008-02-08 00:00:00 | NQ | Futures | 2003.37 | 2003.37 | 1998.26 | 1999.11 | 242.0 |
| 2008-02-08 01:00:00 | NQ | Futures | 1999.68 | 2003.94 | 1998.83 | 2001.1 | 167.0 |
| 2008-02-08 02:00:00 | NQ | Futures | 2001.67 | 2003.65 | 1997.98 | 2002.8 | 198.0 |
| 2008-02-08 03:00:00 | NQ | Futures | 2001.38 | 2009.61 | 2001.1 | 2004.22 | 1451.0 |
| 2008-02-08 04:00:00 | NQ | Futures | 2005.64 | 2007.63 | 2000.81 | 2001.67 | 591.0 |
| 2008-02-08 05:00:00 | NQ | Futures | 2001.95 | 2003.65 | 1997.69 | 2000.53 | 678.0 |
| 2008-02-08 06:00:00 | NQ | Futures | 2000.53 | 2000.53 | 1990.31 | 1992.58 | 2184.0 |
| 2008-02-08 07:00:00 | NQ | Futures | 1992.3 | 1999.96 | 1990.31 | 1995.42 | 4326.0 |
| 2008-02-08 08:00:00 | NQ | Futures | 1995.99 | 2002.8 | 1992.58 | 1997.41 | 6807.0 |
| 2008-02-08 09:00:00 | NQ | Futures | 1997.41 | 2016.14 | 1991.73 | 2012.45 | 62572.0 |
| 2008-02-08 10:00:00 | NQ | Futures | 2012.45 | 2022.1 | 2008.76 | 2020.4 | 58443.0 |
| 2008-02-08 11:00:00 | NQ | Futures | 2020.12 | 2025.79 | 2006.21 | 2006.49 | 45145.0 |
| 2008-02-08 12:00:00 | NQ | Futures | 2006.21 | 2011.32 | 2001.38 | 2010.75 | 33323.0 |
| 2008-02-08 13:00:00 | NQ | Futures | 2010.75 | 2010.75 | 1986.91 | 1999.11 | 58503.0 |
| 2008-02-08 14:00:00 | NQ | Futures | 1999.11 | 2008.76 | 1994.29 | 1999.11 | 43321.0 |
| 2008-02-08 15:00:00 | NQ | Futures | 1999.39 | 2021.82 | 1995.42 | 2017.84 | 77314.0 |
| 2008-02-08 16:00:00 | NQ | Futures | 2017.84 | 2020.4 | 2012.74 | 2017.84 | 13039.0 |
| 2008-02-08 00:00:00 | YM | Futures | 11139.1 | 11142.7 | 11120.9 | 11121.8 | 217.0 |
| 2008-02-08 01:00:00 | YM | Futures | 11120.9 | 11141.8 | 11120.9 | 11141.8 | 78.0 |
| 2008-02-08 02:00:00 | YM | Futures | 11141.8 | 11147.3 | 11122.7 | 11141.8 | 109.0 |
| 2008-02-08 03:00:00 | YM | Futures | 11143.6 | 11174.5 | 11140.0 | 11162.7 | 825.0 |
| 2008-02-08 04:00:00 | YM | Futures | 11162.7 | 11163.6 | 11129.1 | 11136.4 | 624.0 |
| 2008-02-08 05:00:00 | YM | Futures | 11136.4 | 11144.5 | 11110.9 | 11115.5 | 505.0 |
| 2008-02-08 06:00:00 | YM | Futures | 11116.4 | 11121.8 | 11087.3 | 11088.2 | 667.0 |
| 2008-02-08 07:00:00 | YM | Futures | 11090.0 | 11109.1 | 11071.9 | 11088.2 | 1434.0 |
| 2008-02-08 08:00:00 | YM | Futures | 11090.0 | 11110.9 | 11059.1 | 11085.5 | 2745.0 |
| 2008-02-08 09:00:00 | YM | Futures | 11081.9 | 11124.6 | 11059.1 | 11122.7 | 17433.0 |
| 2008-02-08 10:00:00 | YM | Futures | 11122.7 | 11141.8 | 11093.7 | 11123.7 | 24290.0 |
| 2008-02-08 11:00:00 | YM | Futures | 11126.4 | 11160.0 | 11082.8 | 11084.6 | 16887.0 |
| 2008-02-08 12:00:00 | YM | Futures | 11084.6 | 11090.9 | 11038.3 | 11077.3 | 15817.0 |
| 2008-02-08 13:00:00 | YM | Futures | 11077.3 | 11077.3 | 10995.6 | 11033.7 | 23544.0 |
| 2008-02-08 14:00:00 | YM | Futures | 11034.6 | 11065.5 | 11011.9 | 11022.8 | 16250.0 |
| 2008-02-08 15:00:00 | YM | Futures | 11023.7 | 11108.2 | 11015.5 | 11065.5 | 23490.0 |
> showing 50 of 666 rows — these rows as CSV