PREVIEW / futures_1hour / 2009-02-22
file: by_date/futures_1hour/2009/2009-02-22.parquet size: 12 KB rows: 212
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 |
|---|---|---|---|---|---|---|---|
| 2009-02-22 18:00:00 | ES | Futures | 730.53 | 732.43 | 723.89 | 724.36 | 9273.0 |
| 2009-02-22 19:00:00 | ES | Futures | 724.13 | 726.26 | 723.89 | 725.79 | 4973.0 |
| 2009-02-22 20:00:00 | ES | Futures | 725.79 | 740.02 | 725.31 | 737.17 | 18342.0 |
| 2009-02-22 21:00:00 | ES | Futures | 736.93 | 739.78 | 735.75 | 739.07 | 5466.0 |
| 2009-02-22 22:00:00 | ES | Futures | 739.07 | 739.54 | 737.17 | 737.65 | 3023.0 |
| 2009-02-22 23:00:00 | ES | Futures | 737.41 | 739.31 | 737.17 | 738.6 | 2381.0 |
| 2009-02-22 18:00:00 | NQ | Futures | 1326.62 | 1328.04 | 1314.48 | 1314.76 | 864.0 |
| 2009-02-22 19:00:00 | NQ | Futures | 1314.48 | 1317.87 | 1313.92 | 1317.87 | 235.0 |
| 2009-02-22 20:00:00 | NQ | Futures | 1318.15 | 1341.03 | 1317.59 | 1336.79 | 940.0 |
| 2009-02-22 21:00:00 | NQ | Futures | 1335.94 | 1340.46 | 1333.97 | 1339.9 | 254.0 |
| 2009-02-22 22:00:00 | NQ | Futures | 1340.18 | 1340.18 | 1336.51 | 1337.35 | 181.0 |
| 2009-02-22 23:00:00 | NQ | Futures | 1336.79 | 1340.18 | 1336.51 | 1340.18 | 101.0 |
| 2009-02-22 18:00:00 | YM | Futures | 6713.4 | 6715.2 | 6660.5 | 6664.1 | 704.0 |
| 2009-02-22 19:00:00 | YM | Futures | 6660.5 | 6674.2 | 6656.9 | 6667.8 | 386.0 |
| 2009-02-22 20:00:00 | YM | Futures | 6668.7 | 6781.7 | 6666.0 | 6760.7 | 1426.0 |
| 2009-02-22 21:00:00 | YM | Futures | 6761.7 | 6780.8 | 6749.8 | 6775.3 | 382.0 |
| 2009-02-22 22:00:00 | YM | Futures | 6775.3 | 6776.2 | 6758.9 | 6761.7 | 288.0 |
| 2009-02-22 23:00:00 | YM | Futures | 6760.7 | 6774.4 | 6758.9 | 6768.9 | 119.0 |
| 2009-02-22 18:00:00 | CL | Futures | 102.77 | 104.02 | 102.54 | 103.08 | 514.0 |
| 2009-02-22 19:00:00 | CL | Futures | 102.98 | 103.34 | 102.93 | 103.08 | 128.0 |
| 2009-02-22 20:00:00 | CL | Futures | 103.03 | 103.89 | 102.28 | 103.65 | 865.0 |
| 2009-02-22 21:00:00 | CL | Futures | 103.65 | 104.02 | 103.32 | 103.99 | 514.0 |
| 2009-02-22 22:00:00 | CL | Futures | 103.99 | 104.27 | 103.89 | 104.25 | 461.0 |
| 2009-02-22 23:00:00 | CL | Futures | 104.2 | 104.53 | 104.07 | 104.4 | 301.0 |
| 2009-02-22 18:00:00 | GC | Futures | 1414.8 | 1419.2 | 1412.5 | 1418.2 | 1646.0 |
| 2009-02-22 19:00:00 | GC | Futures | 1418.5 | 1418.9 | 1413.7 | 1416.1 | 1046.0 |
| 2009-02-22 20:00:00 | GC | Futures | 1415.9 | 1416.1 | 1409.3 | 1411.7 | 2051.0 |
| 2009-02-22 21:00:00 | GC | Futures | 1411.7 | 1412.5 | 1408.1 | 1409.4 | 1778.0 |
| 2009-02-22 22:00:00 | GC | Futures | 1409.4 | 1409.4 | 1403.3 | 1405.3 | 2543.0 |
| 2009-02-22 23:00:00 | GC | Futures | 1405.3 | 1408.0 | 1405.1 | 1406.8 | 604.0 |
| 2009-02-22 18:00:00 | ZN | Futures | 94.97975 | 95.184707 | 94.955637 | 95.148538 | 2090.0 |
| 2009-02-22 19:00:00 | ZN | Futures | 95.148538 | 95.220876 | 95.112369 | 95.160595 | 2594.0 |
| 2009-02-22 20:00:00 | ZN | Futures | 95.148538 | 95.160595 | 94.71451 | 94.762736 | 9023.0 |
| 2009-02-22 21:00:00 | ZN | Futures | 94.762736 | 94.859186 | 94.750679 | 94.823017 | 3635.0 |
| 2009-02-22 22:00:00 | ZN | Futures | 94.810961 | 94.907412 | 94.810961 | 94.895355 | 1546.0 |
| 2009-02-22 23:00:00 | ZN | Futures | 94.895355 | 94.919468 | 94.859186 | 94.871243 | 854.0 |
> showing 36 of 212 rows — these rows as CSV