PREVIEW / futures_1hour / 2011-02-06
file: by_date/futures_1hour/2011/2011-02-06.parquet size: 14 KB rows: 268
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-02-06 18:00:00 | ES | Futures | 1293.8 | 1294.04 | 1292.56 | 1292.81 | 5088.0 |
| 2011-02-06 19:00:00 | ES | Futures | 1292.81 | 1293.55 | 1292.56 | 1292.81 | 2972.0 |
| 2011-02-06 20:00:00 | ES | Futures | 1293.05 | 1293.8 | 1292.56 | 1293.55 | 2766.0 |
| 2011-02-06 21:00:00 | ES | Futures | 1293.3 | 1293.8 | 1292.81 | 1293.3 | 1691.0 |
| 2011-02-06 22:00:00 | ES | Futures | 1293.3 | 1294.54 | 1292.81 | 1294.54 | 3565.0 |
| 2011-02-06 23:00:00 | ES | Futures | 1294.54 | 1295.78 | 1293.8 | 1294.79 | 5266.0 |
| 2011-02-06 18:00:00 | NQ | Futures | 2684.04 | 2684.04 | 2680.88 | 2680.88 | 243.0 |
| 2011-02-06 19:00:00 | NQ | Futures | 2680.88 | 2682.61 | 2680.88 | 2680.88 | 78.0 |
| 2011-02-06 20:00:00 | NQ | Futures | 2681.17 | 2683.47 | 2680.88 | 2682.32 | 140.0 |
| 2011-02-06 21:00:00 | NQ | Futures | 2682.61 | 2682.89 | 2680.88 | 2681.17 | 125.0 |
| 2011-02-06 22:00:00 | NQ | Futures | 2681.17 | 2683.47 | 2680.31 | 2683.18 | 124.0 |
| 2011-02-06 23:00:00 | NQ | Futures | 2683.47 | 2685.76 | 2682.32 | 2683.47 | 221.0 |
| 2011-02-06 18:00:00 | YM | Futures | 11537.4 | 11539.4 | 11526.9 | 11529.8 | 245.0 |
| 2011-02-06 19:00:00 | YM | Futures | 11527.9 | 11533.6 | 11527.9 | 11528.8 | 116.0 |
| 2011-02-06 20:00:00 | YM | Futures | 11528.8 | 11533.6 | 11526.9 | 11532.7 | 96.0 |
| 2011-02-06 21:00:00 | YM | Futures | 11534.6 | 11536.5 | 11529.8 | 11531.7 | 90.0 |
| 2011-02-06 22:00:00 | YM | Futures | 11532.7 | 11541.3 | 11529.8 | 11539.4 | 132.0 |
| 2011-02-06 23:00:00 | YM | Futures | 11539.4 | 11550.9 | 11539.4 | 11543.2 | 211.0 |
| 2011-02-06 18:00:00 | CL | Futures | 163.33 | 164.01 | 163.33 | 163.88 | 1845.0 |
| 2011-02-06 19:00:00 | CL | Futures | 163.9 | 164.14 | 163.81 | 163.94 | 835.0 |
| 2011-02-06 20:00:00 | CL | Futures | 163.94 | 164.21 | 163.55 | 163.97 | 903.0 |
| 2011-02-06 21:00:00 | CL | Futures | 163.99 | 163.99 | 163.04 | 163.28 | 824.0 |
| 2011-02-06 22:00:00 | CL | Futures | 163.29 | 163.62 | 163.24 | 163.37 | 646.0 |
| 2011-02-06 23:00:00 | CL | Futures | 163.35 | 163.62 | 163.33 | 163.48 | 270.0 |
| 2011-02-06 18:00:00 | GC | Futures | 1881.7 | 1881.7 | 1876.2 | 1878.0 | 2225.0 |
| 2011-02-06 19:00:00 | GC | Futures | 1878.1 | 1881.5 | 1878.1 | 1879.8 | 1044.0 |
| 2011-02-06 20:00:00 | GC | Futures | 1879.5 | 1883.4 | 1879.5 | 1882.2 | 1071.0 |
| 2011-02-06 21:00:00 | GC | Futures | 1882.0 | 1883.3 | 1880.5 | 1880.8 | 504.0 |
| 2011-02-06 22:00:00 | GC | Futures | 1880.8 | 1881.9 | 1880.4 | 1881.1 | 428.0 |
| 2011-02-06 23:00:00 | GC | Futures | 1881.1 | 1881.6 | 1880.4 | 1880.9 | 478.0 |
| 2011-02-06 18:00:00 | ZN | Futures | 99.748152 | 99.787573 | 99.721872 | 99.761293 | 4516.0 |
| 2011-02-06 19:00:00 | ZN | Futures | 99.774433 | 99.813854 | 99.748152 | 99.800714 | 10606.0 |
| 2011-02-06 20:00:00 | ZN | Futures | 99.787573 | 99.826994 | 99.787573 | 99.800714 | 3798.0 |
| 2011-02-06 21:00:00 | ZN | Futures | 99.813854 | 99.813854 | 99.787573 | 99.813854 | 2107.0 |
| 2011-02-06 22:00:00 | ZN | Futures | 99.813854 | 99.813854 | 99.721872 | 99.735012 | 6058.0 |
| 2011-02-06 23:00:00 | ZN | Futures | 99.721872 | 99.735012 | 99.708731 | 99.721872 | 2536.0 |
> showing 36 of 268 rows — these rows as CSV