PREVIEW / futures_1hour / 2008-11-02
file: by_date/futures_1hour/2008/2008-11-02.parquet size: 14 KB rows: 238
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-11-02 18:00:00 | ES | Futures | 914.18 | 916.78 | 910.39 | 913.47 | 9039.0 |
| 2008-11-02 19:00:00 | ES | Futures | 913.47 | 916.54 | 912.52 | 916.31 | 3520.0 |
| 2008-11-02 20:00:00 | ES | Futures | 916.31 | 924.83 | 915.6 | 924.35 | 6542.0 |
| 2008-11-02 21:00:00 | ES | Futures | 924.12 | 927.43 | 923.41 | 923.64 | 6557.0 |
| 2008-11-02 22:00:00 | ES | Futures | 923.64 | 925.77 | 919.86 | 924.35 | 5259.0 |
| 2008-11-02 23:00:00 | ES | Futures | 924.35 | 925.3 | 921.51 | 925.06 | 1554.0 |
| 2008-11-02 18:00:00 | NQ | Futures | 1516.68 | 1516.68 | 1507.06 | 1511.31 | 369.0 |
| 2008-11-02 19:00:00 | NQ | Futures | 1511.59 | 1515.55 | 1510.46 | 1514.99 | 172.0 |
| 2008-11-02 20:00:00 | NQ | Futures | 1515.27 | 1532.53 | 1513.57 | 1531.96 | 688.0 |
| 2008-11-02 21:00:00 | NQ | Futures | 1529.7 | 1535.36 | 1528.0 | 1528.0 | 142.0 |
| 2008-11-02 22:00:00 | NQ | Futures | 1528.57 | 1529.13 | 1521.21 | 1529.13 | 413.0 |
| 2008-11-02 23:00:00 | NQ | Futures | 1526.87 | 1529.13 | 1522.34 | 1528.85 | 60.0 |
| 2008-11-02 18:00:00 | YM | Futures | 8454.0 | 8470.3 | 8415.8 | 8442.2 | 652.0 |
| 2008-11-02 19:00:00 | YM | Futures | 8444.9 | 8472.2 | 8435.8 | 8468.5 | 292.0 |
| 2008-11-02 20:00:00 | YM | Futures | 8469.4 | 8546.7 | 8464.9 | 8544.9 | 807.0 |
| 2008-11-02 21:00:00 | YM | Futures | 8544.9 | 8568.6 | 8538.6 | 8540.4 | 786.0 |
| 2008-11-02 22:00:00 | YM | Futures | 8543.1 | 8557.7 | 8505.8 | 8548.6 | 612.0 |
| 2008-11-02 23:00:00 | YM | Futures | 8545.8 | 8554.0 | 8526.7 | 8554.0 | 324.0 |
| 2008-11-02 18:00:00 | CL | Futures | 252.7 | 253.79 | 250.11 | 251.76 | 714.0 |
| 2008-11-02 19:00:00 | CL | Futures | 251.91 | 253.19 | 251.27 | 252.92 | 338.0 |
| 2008-11-02 20:00:00 | CL | Futures | 252.81 | 256.11 | 252.81 | 256.04 | 784.0 |
| 2008-11-02 21:00:00 | CL | Futures | 256.07 | 257.8 | 255.66 | 257.27 | 673.0 |
| 2008-11-02 22:00:00 | CL | Futures | 257.39 | 258.7 | 256.49 | 258.62 | 560.0 |
| 2008-11-02 23:00:00 | CL | Futures | 258.4 | 258.7 | 257.72 | 258.47 | 330.0 |
| 2008-11-02 18:00:00 | GC | Futures | 1037.6 | 1041.2 | 1037.3 | 1041.0 | 708.0 |
| 2008-11-02 19:00:00 | GC | Futures | 1040.9 | 1042.6 | 1036.2 | 1042.0 | 744.0 |
| 2008-11-02 20:00:00 | GC | Futures | 1042.0 | 1048.7 | 1040.9 | 1045.0 | 1033.0 |
| 2008-11-02 21:00:00 | GC | Futures | 1045.0 | 1047.0 | 1042.0 | 1044.4 | 729.0 |
| 2008-11-02 22:00:00 | GC | Futures | 1043.4 | 1050.1 | 1042.6 | 1049.1 | 1066.0 |
| 2008-11-02 23:00:00 | GC | Futures | 1049.0 | 1052.6 | 1045.2 | 1048.4 | 982.0 |
| 2008-11-02 18:00:00 | ZN | Futures | 85.509522 | 85.533147 | 85.474085 | 85.521334 | 682.0 |
| 2008-11-02 19:00:00 | ZN | Futures | 85.533147 | 85.615833 | 85.533147 | 85.568584 | 628.0 |
| 2008-11-02 20:00:00 | ZN | Futures | 85.556771 | 85.568584 | 85.45046 | 85.462272 | 945.0 |
| 2008-11-02 21:00:00 | ZN | Futures | 85.45046 | 85.45046 | 85.332337 | 85.355961 | 2318.0 |
| 2008-11-02 22:00:00 | ZN | Futures | 85.344149 | 85.355961 | 85.320524 | 85.332337 | 510.0 |
| 2008-11-02 23:00:00 | ZN | Futures | 85.332337 | 85.391398 | 85.320524 | 85.355961 | 488.0 |
> showing 36 of 238 rows — these rows as CSV