PREVIEW / futures_1hour / 2008-02-10
file: by_date/futures_1hour/2008/2008-02-10.parquet size: 11 KB rows: 166
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-10 18:00:00 | ES | Futures | 1239.92 | 1241.56 | 1239.92 | 1240.62 | 3307.0 |
| 2008-02-10 19:00:00 | ES | Futures | 1240.62 | 1241.32 | 1237.13 | 1237.59 | 4434.0 |
| 2008-02-10 20:00:00 | ES | Futures | 1237.59 | 1239.23 | 1235.73 | 1236.89 | 3304.0 |
| 2008-02-10 21:00:00 | ES | Futures | 1236.89 | 1237.59 | 1235.26 | 1235.96 | 3476.0 |
| 2008-02-10 22:00:00 | ES | Futures | 1235.96 | 1235.96 | 1232.0 | 1234.8 | 4423.0 |
| 2008-02-10 23:00:00 | ES | Futures | 1234.8 | 1236.43 | 1234.33 | 1234.8 | 1193.0 |
| 2008-02-10 18:00:00 | NQ | Futures | 2015.01 | 2019.26 | 2015.01 | 2016.71 | 159.0 |
| 2008-02-10 19:00:00 | NQ | Futures | 2016.43 | 2016.99 | 2010.75 | 2010.75 | 545.0 |
| 2008-02-10 20:00:00 | NQ | Futures | 2011.32 | 2011.6 | 2009.61 | 2009.61 | 175.0 |
| 2008-02-10 21:00:00 | NQ | Futures | 2009.61 | 2009.61 | 2006.77 | 2007.06 | 202.0 |
| 2008-02-10 22:00:00 | NQ | Futures | 2007.34 | 2007.63 | 2002.52 | 2004.79 | 238.0 |
| 2008-02-10 23:00:00 | NQ | Futures | 2005.07 | 2008.19 | 2005.07 | 2006.21 | 124.0 |
| 2008-02-10 18:00:00 | YM | Futures | 11048.2 | 11082.8 | 11048.2 | 11061.0 | 146.0 |
| 2008-02-10 19:00:00 | YM | Futures | 11061.9 | 11065.5 | 11041.9 | 11041.9 | 172.0 |
| 2008-02-10 20:00:00 | YM | Futures | 11041.9 | 11054.6 | 11029.2 | 11034.6 | 225.0 |
| 2008-02-10 21:00:00 | YM | Futures | 11039.2 | 11042.8 | 11021.0 | 11029.2 | 252.0 |
| 2008-02-10 22:00:00 | YM | Futures | 11028.3 | 11029.2 | 11010.1 | 11021.0 | 477.0 |
| 2008-02-10 23:00:00 | YM | Futures | 11022.8 | 11037.3 | 11017.4 | 11026.4 | 140.0 |
| 2008-02-10 18:00:00 | CL | Futures | 342.74 | 346.28 | 342.7 | 345.61 | 2801.0 |
| 2008-02-10 19:00:00 | CL | Futures | 345.57 | 345.87 | 344.72 | 345.01 | 634.0 |
| 2008-02-10 20:00:00 | CL | Futures | 345.09 | 345.24 | 344.01 | 344.12 | 424.0 |
| 2008-02-10 21:00:00 | CL | Futures | 344.16 | 344.57 | 343.67 | 343.89 | 465.0 |
| 2008-02-10 22:00:00 | CL | Futures | 343.93 | 344.19 | 343.71 | 343.71 | 210.0 |
| 2008-02-10 23:00:00 | CL | Futures | 343.74 | 344.12 | 343.22 | 344.04 | 400.0 |
| 2008-02-10 18:00:00 | GC | Futures | 1345.3 | 1349.3 | 1343.4 | 1348.7 | 1623.0 |
| 2008-02-10 19:00:00 | GC | Futures | 1348.9 | 1350.6 | 1348.3 | 1349.6 | 908.0 |
| 2008-02-10 20:00:00 | GC | Futures | 1349.8 | 1350.6 | 1348.5 | 1350.3 | 713.0 |
| 2008-02-10 21:00:00 | GC | Futures | 1350.1 | 1350.6 | 1347.1 | 1347.7 | 775.0 |
| 2008-02-10 22:00:00 | GC | Futures | 1347.4 | 1348.0 | 1344.7 | 1346.0 | 920.0 |
| 2008-02-10 23:00:00 | GC | Futures | 1346.1 | 1348.0 | 1345.3 | 1346.6 | 708.0 |
| 2008-02-10 18:00:00 | ZN | Futures | 85.396958 | 85.419742 | 85.351388 | 85.419742 | 2018.0 |
| 2008-02-10 19:00:00 | ZN | Futures | 85.40835 | 85.453919 | 85.385565 | 85.431135 | 1516.0 |
| 2008-02-10 20:00:00 | ZN | Futures | 85.419742 | 85.488096 | 85.419742 | 85.488096 | 1594.0 |
| 2008-02-10 21:00:00 | ZN | Futures | 85.488096 | 85.545058 | 85.488096 | 85.545058 | 4000.0 |
| 2008-02-10 22:00:00 | ZN | Futures | 85.545058 | 85.579235 | 85.545058 | 85.567843 | 1105.0 |
| 2008-02-10 23:00:00 | ZN | Futures | 85.55645 | 85.567843 | 85.533666 | 85.533666 | 1278.0 |
> showing 36 of 166 rows — these rows as CSV