PREVIEW / futures_1hour / 2011-06-19
file: by_date/futures_1hour/2011/2011-06-19.parquet size: 14 KB rows: 267
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-06-19 18:00:00 | ES | Futures | 1261.99 | 1261.99 | 1257.25 | 1259.25 | 15032.0 |
| 2011-06-19 19:00:00 | ES | Futures | 1259.0 | 1261.99 | 1259.0 | 1259.5 | 5306.0 |
| 2011-06-19 20:00:00 | ES | Futures | 1259.25 | 1262.99 | 1259.0 | 1261.24 | 10931.0 |
| 2011-06-19 21:00:00 | ES | Futures | 1260.99 | 1262.99 | 1260.5 | 1262.49 | 7732.0 |
| 2011-06-19 22:00:00 | ES | Futures | 1262.74 | 1262.74 | 1259.0 | 1259.5 | 5084.0 |
| 2011-06-19 23:00:00 | ES | Futures | 1259.5 | 1260.0 | 1258.0 | 1258.5 | 3018.0 |
| 2011-06-19 18:00:00 | NQ | Futures | 2520.25 | 2520.25 | 2509.03 | 2514.21 | 1014.0 |
| 2011-06-19 19:00:00 | NQ | Futures | 2514.49 | 2519.1 | 2514.49 | 2515.36 | 630.0 |
| 2011-06-19 20:00:00 | NQ | Futures | 2515.07 | 2522.26 | 2514.49 | 2518.23 | 593.0 |
| 2011-06-19 21:00:00 | NQ | Futures | 2518.23 | 2521.97 | 2517.66 | 2521.11 | 443.0 |
| 2011-06-19 22:00:00 | NQ | Futures | 2521.11 | 2521.11 | 2513.92 | 2515.07 | 620.0 |
| 2011-06-19 23:00:00 | NQ | Futures | 2514.78 | 2514.78 | 2512.48 | 2512.77 | 279.0 |
| 2011-06-19 18:00:00 | YM | Futures | 11547.2 | 11547.2 | 11511.4 | 11525.9 | 259.0 |
| 2011-06-19 19:00:00 | YM | Futures | 11529.8 | 11551.1 | 11526.9 | 11531.7 | 126.0 |
| 2011-06-19 20:00:00 | YM | Futures | 11530.7 | 11557.8 | 11529.8 | 11541.4 | 419.0 |
| 2011-06-19 21:00:00 | YM | Futures | 11543.3 | 11559.8 | 11539.4 | 11555.9 | 298.0 |
| 2011-06-19 22:00:00 | YM | Futures | 11554.9 | 11554.9 | 11524.0 | 11532.7 | 405.0 |
| 2011-06-19 23:00:00 | YM | Futures | 11533.6 | 11534.6 | 11516.2 | 11519.1 | 207.0 |
| 2011-06-19 18:00:00 | CL | Futures | 159.62 | 160.18 | 159.36 | 159.74 | 1145.0 |
| 2011-06-19 19:00:00 | CL | Futures | 159.74 | 159.99 | 159.36 | 159.36 | 491.0 |
| 2011-06-19 20:00:00 | CL | Futures | 159.36 | 159.84 | 159.21 | 159.39 | 778.0 |
| 2011-06-19 21:00:00 | CL | Futures | 159.39 | 159.58 | 158.9 | 159.15 | 915.0 |
| 2011-06-19 22:00:00 | CL | Futures | 159.21 | 159.29 | 158.73 | 158.83 | 728.0 |
| 2011-06-19 23:00:00 | CL | Futures | 158.83 | 158.95 | 158.14 | 158.21 | 1189.0 |
| 2011-06-19 18:00:00 | GC | Futures | 2149.7 | 2151.8 | 2146.5 | 2149.0 | 1125.0 |
| 2011-06-19 19:00:00 | GC | Futures | 2149.0 | 2150.1 | 2146.9 | 2147.6 | 736.0 |
| 2011-06-19 20:00:00 | GC | Futures | 2147.9 | 2150.1 | 2147.4 | 2148.2 | 906.0 |
| 2011-06-19 21:00:00 | GC | Futures | 2147.9 | 2149.6 | 2147.9 | 2148.9 | 954.0 |
| 2011-06-19 22:00:00 | GC | Futures | 2149.0 | 2149.0 | 2146.5 | 2146.9 | 591.0 |
| 2011-06-19 23:00:00 | GC | Futures | 2146.7 | 2146.8 | 2144.7 | 2145.4 | 1036.0 |
| 2011-06-19 18:00:00 | ZN | Futures | 106.643204 | 106.697017 | 106.616298 | 106.656657 | 2171.0 |
| 2011-06-19 19:00:00 | ZN | Futures | 106.656657 | 106.697017 | 106.602845 | 106.683564 | 3179.0 |
| 2011-06-19 20:00:00 | ZN | Futures | 106.683564 | 106.71047 | 106.629751 | 106.656657 | 3810.0 |
| 2011-06-19 21:00:00 | ZN | Futures | 106.643204 | 106.67011 | 106.616298 | 106.629751 | 3203.0 |
| 2011-06-19 22:00:00 | ZN | Futures | 106.629751 | 106.697017 | 106.629751 | 106.683564 | 3006.0 |
| 2011-06-19 23:00:00 | ZN | Futures | 106.683564 | 106.723923 | 106.67011 | 106.723923 | 2972.0 |
> showing 36 of 267 rows — these rows as CSV