PREVIEW / futures_30min / 2010-01-31
file: by_date/futures_30min/2010/2010-01-31.parquet size: 18 KB rows: 457
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 | 1042.12 | 1039.2 | 1040.9 | 12574.0 |
| 2010-01-31 18:30:00 | ES | Futures | 1040.9 | 1043.58 | 1040.66 | 1042.85 | 7094.0 |
| 2010-01-31 19:00:00 | ES | Futures | 1042.61 | 1044.55 | 1041.88 | 1044.55 | 7197.0 |
| 2010-01-31 19:30:00 | ES | Futures | 1044.55 | 1044.8 | 1043.09 | 1043.34 | 5136.0 |
| 2010-01-31 20:00:00 | ES | Futures | 1043.34 | 1044.31 | 1042.36 | 1042.61 | 4719.0 |
| 2010-01-31 20:30:00 | ES | Futures | 1042.61 | 1043.09 | 1039.69 | 1042.85 | 6246.0 |
| 2010-01-31 21:00:00 | ES | Futures | 1042.61 | 1042.85 | 1040.42 | 1042.12 | 5087.0 |
| 2010-01-31 21:30:00 | ES | Futures | 1041.88 | 1043.34 | 1041.63 | 1042.36 | 2229.0 |
| 2010-01-31 22:00:00 | ES | Futures | 1042.36 | 1042.36 | 1040.66 | 1042.12 | 2327.0 |
| 2010-01-31 22:30:00 | ES | Futures | 1042.36 | 1043.82 | 1042.12 | 1042.85 | 1656.0 |
| 2010-01-31 23:00:00 | ES | Futures | 1043.09 | 1043.58 | 1042.36 | 1043.09 | 1214.0 |
| 2010-01-31 23:30:00 | ES | Futures | 1043.09 | 1043.58 | 1042.36 | 1043.09 | 1346.0 |
| 2010-01-31 18:00:00 | NQ | Futures | 1987.98 | 1990.55 | 1984.55 | 1987.69 | 1108.0 |
| 2010-01-31 18:30:00 | NQ | Futures | 1987.98 | 1992.83 | 1987.41 | 1990.84 | 336.0 |
| 2010-01-31 19:00:00 | NQ | Futures | 1991.12 | 1994.26 | 1989.69 | 1993.12 | 582.0 |
| 2010-01-31 19:30:00 | NQ | Futures | 1993.12 | 1993.69 | 1990.84 | 1991.12 | 325.0 |
| 2010-01-31 20:00:00 | NQ | Futures | 1991.12 | 1993.12 | 1989.98 | 1991.12 | 473.0 |
| 2010-01-31 20:30:00 | NQ | Futures | 1990.55 | 1990.55 | 1985.69 | 1990.26 | 947.0 |
| 2010-01-31 21:00:00 | NQ | Futures | 1989.98 | 1991.12 | 1987.41 | 1989.69 | 876.0 |
| 2010-01-31 21:30:00 | NQ | Futures | 1990.26 | 1992.83 | 1989.69 | 1991.12 | 378.0 |
| 2010-01-31 22:00:00 | NQ | Futures | 1991.12 | 1991.41 | 1988.26 | 1991.12 | 351.0 |
| 2010-01-31 22:30:00 | NQ | Futures | 1991.12 | 1993.41 | 1990.84 | 1991.69 | 257.0 |
| 2010-01-31 23:00:00 | NQ | Futures | 1991.98 | 1993.12 | 1991.41 | 1991.98 | 101.0 |
| 2010-01-31 23:30:00 | NQ | Futures | 1992.26 | 1993.12 | 1991.12 | 1992.83 | 126.0 |
| 2010-01-31 18:00:00 | YM | Futures | 9370.3 | 9382.4 | 9362.8 | 9375.0 | 547.0 |
| 2010-01-31 18:30:00 | YM | Futures | 9375.9 | 9395.5 | 9374.0 | 9390.9 | 361.0 |
| 2010-01-31 19:00:00 | YM | Futures | 9391.8 | 9404.9 | 9384.3 | 9402.1 | 432.0 |
| 2010-01-31 19:30:00 | YM | Futures | 9404.0 | 9405.8 | 9395.5 | 9395.5 | 254.0 |
| 2010-01-31 20:00:00 | YM | Futures | 9396.5 | 9403.0 | 9388.1 | 9390.9 | 322.0 |
| 2010-01-31 20:30:00 | YM | Futures | 9391.8 | 9391.8 | 9368.4 | 9389.9 | 450.0 |
| 2010-01-31 21:00:00 | YM | Futures | 9389.0 | 9390.9 | 9371.2 | 9383.4 | 314.0 |
| 2010-01-31 21:30:00 | YM | Futures | 9382.4 | 9393.7 | 9380.6 | 9386.2 | 137.0 |
| 2010-01-31 22:00:00 | YM | Futures | 9386.2 | 9386.2 | 9374.0 | 9383.4 | 144.0 |
| 2010-01-31 22:30:00 | YM | Futures | 9386.2 | 9396.5 | 9384.3 | 9389.9 | 166.0 |
| 2010-01-31 23:00:00 | YM | Futures | 9390.9 | 9394.6 | 9388.1 | 9390.9 | 237.0 |
| 2010-01-31 23:30:00 | YM | Futures | 9391.8 | 9394.6 | 9386.2 | 9393.7 | 112.0 |
| 2010-01-31 18:00:00 | CL | Futures | 155.71 | 155.76 | 155.07 | 155.39 | 702.0 |
| 2010-01-31 18:30:00 | CL | Futures | 155.39 | 155.65 | 155.33 | 155.59 | 499.0 |
| 2010-01-31 19:00:00 | CL | Futures | 155.61 | 156.01 | 155.56 | 155.97 | 451.0 |
| 2010-01-31 19:30:00 | CL | Futures | 155.99 | 155.99 | 155.67 | 155.74 | 306.0 |
| 2010-01-31 20:00:00 | CL | Futures | 155.76 | 155.84 | 155.54 | 155.63 | 309.0 |
| 2010-01-31 20:30:00 | CL | Futures | 155.61 | 155.61 | 155.22 | 155.56 | 463.0 |
| 2010-01-31 21:00:00 | CL | Futures | 155.54 | 155.54 | 155.18 | 155.29 | 362.0 |
| 2010-01-31 21:30:00 | CL | Futures | 155.29 | 155.35 | 155.01 | 155.14 | 487.0 |
| 2010-01-31 22:00:00 | CL | Futures | 155.14 | 155.2 | 154.97 | 155.2 | 590.0 |
| 2010-01-31 22:30:00 | CL | Futures | 155.18 | 155.22 | 155.07 | 155.12 | 269.0 |
| 2010-01-31 23:00:00 | CL | Futures | 155.12 | 155.27 | 155.09 | 155.14 | 138.0 |
| 2010-01-31 23:30:00 | CL | Futures | 155.14 | 155.5 | 155.09 | 155.44 | 388.0 |
| 2010-01-31 18:00:00 | GC | Futures | 1523.2 | 1526.8 | 1521.2 | 1526.5 | 1138.0 |
| 2010-01-31 18:30:00 | GC | Futures | 1526.7 | 1527.0 | 1525.6 | 1526.8 | 387.0 |
> showing 50 of 457 rows — these rows as CSV