PREVIEW / futures_1hour / 2011-01-02
file: by_date/futures_1hour/2011/2011-01-02.parquet size: 13 KB rows: 248
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 |
|---|---|---|---|---|---|---|---|
| 2011-01-02 18:00:00 | ES | Futures | 1243.07 | 1244.81 | 1242.33 | 1243.82 | 7479.0 |
| 2011-01-02 19:00:00 | ES | Futures | 1243.82 | 1244.56 | 1242.83 | 1244.06 | 2715.0 |
| 2011-01-02 20:00:00 | ES | Futures | 1244.06 | 1244.31 | 1243.82 | 1244.06 | 2095.0 |
| 2011-01-02 21:00:00 | ES | Futures | 1244.06 | 1244.56 | 1243.82 | 1244.31 | 1556.0 |
| 2011-01-02 22:00:00 | ES | Futures | 1244.31 | 1248.02 | 1244.31 | 1247.28 | 6798.0 |
| 2011-01-02 23:00:00 | ES | Futures | 1247.28 | 1248.02 | 1246.79 | 1247.28 | 2696.0 |
| 2011-01-02 18:00:00 | NQ | Futures | 2548.85 | 2553.15 | 2547.99 | 2550.57 | 1127.0 |
| 2011-01-02 19:00:00 | NQ | Futures | 2550.86 | 2552.29 | 2548.56 | 2551.43 | 191.0 |
| 2011-01-02 20:00:00 | NQ | Futures | 2551.43 | 2552.01 | 2550.57 | 2550.57 | 207.0 |
| 2011-01-02 21:00:00 | NQ | Futures | 2550.57 | 2552.58 | 2550.28 | 2552.58 | 255.0 |
| 2011-01-02 22:00:00 | NQ | Futures | 2552.58 | 2558.32 | 2552.29 | 2556.89 | 667.0 |
| 2011-01-02 23:00:00 | NQ | Futures | 2556.6 | 2558.61 | 2556.6 | 2558.03 | 211.0 |
| 2011-01-02 18:00:00 | YM | Futures | 11059.5 | 11069.1 | 11055.7 | 11064.3 | 431.0 |
| 2011-01-02 19:00:00 | YM | Futures | 11064.3 | 11068.1 | 11056.6 | 11066.2 | 207.0 |
| 2011-01-02 20:00:00 | YM | Futures | 11064.3 | 11068.1 | 11064.3 | 11065.3 | 121.0 |
| 2011-01-02 21:00:00 | YM | Futures | 11065.3 | 11071.0 | 11065.3 | 11069.1 | 125.0 |
| 2011-01-02 22:00:00 | YM | Futures | 11070.0 | 11093.0 | 11070.0 | 11092.1 | 452.0 |
| 2011-01-02 23:00:00 | YM | Futures | 11090.2 | 11096.9 | 11089.2 | 11089.2 | 136.0 |
| 2011-01-02 18:00:00 | CL | Futures | 169.37 | 169.65 | 169.18 | 169.33 | 1043.0 |
| 2011-01-02 19:00:00 | CL | Futures | 169.33 | 169.46 | 169.2 | 169.37 | 411.0 |
| 2011-01-02 20:00:00 | CL | Futures | 169.37 | 169.5 | 169.3 | 169.42 | 584.0 |
| 2011-01-02 21:00:00 | CL | Futures | 169.44 | 170.28 | 169.44 | 170.28 | 963.0 |
| 2011-01-02 22:00:00 | CL | Futures | 170.3 | 170.37 | 170.02 | 170.11 | 881.0 |
| 2011-01-02 23:00:00 | CL | Futures | 170.09 | 170.19 | 169.98 | 170.06 | 555.0 |
| 2011-01-02 18:00:00 | GC | Futures | 1984.0 | 1984.0 | 1979.5 | 1979.8 | 1737.0 |
| 2011-01-02 19:00:00 | GC | Futures | 1980.2 | 1980.2 | 1975.8 | 1978.3 | 1691.0 |
| 2011-01-02 20:00:00 | GC | Futures | 1978.6 | 1979.8 | 1977.4 | 1978.7 | 493.0 |
| 2011-01-02 21:00:00 | GC | Futures | 1978.6 | 1979.7 | 1977.4 | 1979.1 | 383.0 |
| 2011-01-02 22:00:00 | GC | Futures | 1979.3 | 1981.6 | 1976.7 | 1979.7 | 1248.0 |
| 2011-01-02 23:00:00 | GC | Futures | 1979.5 | 1982.2 | 1978.1 | 1979.7 | 1195.0 |
| 2011-01-02 18:00:00 | ZN | Futures | 101.167307 | 101.193587 | 101.035904 | 101.062184 | 1850.0 |
| 2011-01-02 19:00:00 | ZN | Futures | 101.049044 | 101.075324 | 101.035904 | 101.049044 | 1438.0 |
| 2011-01-02 20:00:00 | ZN | Futures | 101.062184 | 101.075324 | 100.996483 | 100.996483 | 1292.0 |
| 2011-01-02 21:00:00 | ZN | Futures | 100.996483 | 101.035904 | 100.930781 | 101.009623 | 1972.0 |
| 2011-01-02 22:00:00 | ZN | Futures | 101.022763 | 101.035904 | 100.970202 | 100.983342 | 934.0 |
| 2011-01-02 23:00:00 | ZN | Futures | 100.970202 | 100.983342 | 100.957062 | 100.957062 | 123.0 |
> showing 36 of 248 rows — these rows as CSV