PREVIEW / futures_1hour / 2010-01-31
file: by_date/futures_1hour/2010/2010-01-31.parquet size: 13 KB rows: 251
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-01-31 18:00:00 | ES | Futures | 1041.15 | 1043.58 | 1039.2 | 1042.85 | 19668.0 |
| 2010-01-31 19:00:00 | ES | Futures | 1042.61 | 1044.8 | 1041.88 | 1043.34 | 12333.0 |
| 2010-01-31 20:00:00 | ES | Futures | 1043.34 | 1044.31 | 1039.69 | 1042.85 | 10965.0 |
| 2010-01-31 21:00:00 | ES | Futures | 1042.61 | 1043.34 | 1040.42 | 1042.36 | 7316.0 |
| 2010-01-31 22:00:00 | ES | Futures | 1042.36 | 1043.82 | 1040.66 | 1042.85 | 3983.0 |
| 2010-01-31 23:00:00 | ES | Futures | 1043.09 | 1043.58 | 1042.36 | 1043.09 | 2560.0 |
| 2010-01-31 18:00:00 | NQ | Futures | 1987.98 | 1992.83 | 1984.55 | 1990.84 | 1444.0 |
| 2010-01-31 19:00:00 | NQ | Futures | 1991.12 | 1994.26 | 1989.69 | 1991.12 | 907.0 |
| 2010-01-31 20:00:00 | NQ | Futures | 1991.12 | 1993.12 | 1985.69 | 1990.26 | 1420.0 |
| 2010-01-31 21:00:00 | NQ | Futures | 1989.98 | 1992.83 | 1987.41 | 1991.12 | 1254.0 |
| 2010-01-31 22:00:00 | NQ | Futures | 1991.12 | 1993.41 | 1988.26 | 1991.69 | 608.0 |
| 2010-01-31 23:00:00 | NQ | Futures | 1991.98 | 1993.12 | 1991.12 | 1992.83 | 227.0 |
| 2010-01-31 18:00:00 | YM | Futures | 9370.3 | 9395.5 | 9362.8 | 9390.9 | 908.0 |
| 2010-01-31 19:00:00 | YM | Futures | 9391.8 | 9405.8 | 9384.3 | 9395.5 | 686.0 |
| 2010-01-31 20:00:00 | YM | Futures | 9396.5 | 9403.0 | 9368.4 | 9389.9 | 772.0 |
| 2010-01-31 21:00:00 | YM | Futures | 9389.0 | 9393.7 | 9371.2 | 9386.2 | 451.0 |
| 2010-01-31 22:00:00 | YM | Futures | 9386.2 | 9396.5 | 9374.0 | 9389.9 | 310.0 |
| 2010-01-31 23:00:00 | YM | Futures | 9390.9 | 9394.6 | 9386.2 | 9393.7 | 349.0 |
| 2010-01-31 18:00:00 | CL | Futures | 155.71 | 155.76 | 155.07 | 155.59 | 1201.0 |
| 2010-01-31 19:00:00 | CL | Futures | 155.61 | 156.01 | 155.56 | 155.74 | 757.0 |
| 2010-01-31 20:00:00 | CL | Futures | 155.76 | 155.84 | 155.22 | 155.56 | 772.0 |
| 2010-01-31 21:00:00 | CL | Futures | 155.54 | 155.54 | 155.01 | 155.14 | 849.0 |
| 2010-01-31 22:00:00 | CL | Futures | 155.14 | 155.22 | 154.97 | 155.12 | 859.0 |
| 2010-01-31 23:00:00 | CL | Futures | 155.12 | 155.5 | 155.09 | 155.44 | 526.0 |
| 2010-01-31 18:00:00 | GC | Futures | 1523.2 | 1527.0 | 1521.2 | 1526.8 | 1525.0 |
| 2010-01-31 19:00:00 | GC | Futures | 1527.0 | 1527.5 | 1524.6 | 1525.7 | 2164.0 |
| 2010-01-31 20:00:00 | GC | Futures | 1525.8 | 1528.4 | 1522.9 | 1524.3 | 3340.0 |
| 2010-01-31 21:00:00 | GC | Futures | 1524.3 | 1525.0 | 1518.1 | 1520.6 | 2826.0 |
| 2010-01-31 22:00:00 | GC | Futures | 1520.5 | 1520.5 | 1516.5 | 1516.5 | 2029.0 |
| 2010-01-31 23:00:00 | GC | Futures | 1516.5 | 1521.2 | 1516.5 | 1520.5 | 1992.0 |
| 2010-01-31 18:00:00 | ZN | Futures | 96.075685 | 96.088376 | 95.974151 | 95.999535 | 5021.0 |
| 2010-01-31 19:00:00 | ZN | Futures | 95.986843 | 96.012226 | 95.936077 | 95.96146 | 9134.0 |
| 2010-01-31 20:00:00 | ZN | Futures | 95.974151 | 96.024918 | 95.974151 | 95.986843 | 6272.0 |
| 2010-01-31 21:00:00 | ZN | Futures | 95.974151 | 96.024918 | 95.974151 | 96.012226 | 3667.0 |
| 2010-01-31 22:00:00 | ZN | Futures | 96.012226 | 96.024918 | 95.999535 | 96.012226 | 2109.0 |
| 2010-01-31 23:00:00 | ZN | Futures | 96.012226 | 96.024918 | 95.999535 | 96.012226 | 2143.0 |
> showing 36 of 251 rows — these rows as CSV