PREVIEW / futures_1hour / 2012-11-04
file: by_date/futures_1hour/2012/2012-11-04.parquet size: 14 KB rows: 277
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 |
|---|---|---|---|---|---|---|---|
| 2012-11-04 18:00:00 | ES | Futures | 1433.41 | 1436.47 | 1433.15 | 1434.17 | 15430.0 |
| 2012-11-04 19:00:00 | ES | Futures | 1434.17 | 1439.03 | 1434.17 | 1438.26 | 9729.0 |
| 2012-11-04 20:00:00 | ES | Futures | 1438.26 | 1440.3 | 1438.01 | 1439.54 | 6492.0 |
| 2012-11-04 21:00:00 | ES | Futures | 1439.28 | 1439.79 | 1437.24 | 1437.49 | 4512.0 |
| 2012-11-04 22:00:00 | ES | Futures | 1437.24 | 1438.77 | 1436.98 | 1438.26 | 2328.0 |
| 2012-11-04 23:00:00 | ES | Futures | 1438.26 | 1439.28 | 1438.26 | 1439.03 | 2096.0 |
| 2012-11-04 18:00:00 | NQ | Futures | 3069.07 | 3073.14 | 3062.38 | 3067.32 | 1210.0 |
| 2012-11-04 19:00:00 | NQ | Futures | 3067.32 | 3075.75 | 3067.32 | 3074.3 | 1043.0 |
| 2012-11-04 20:00:00 | NQ | Futures | 3074.59 | 3079.53 | 3074.3 | 3078.95 | 867.0 |
| 2012-11-04 21:00:00 | NQ | Futures | 3078.95 | 3079.82 | 3075.17 | 3075.17 | 750.0 |
| 2012-11-04 22:00:00 | NQ | Futures | 3075.17 | 3078.08 | 3074.3 | 3076.91 | 265.0 |
| 2012-11-04 23:00:00 | NQ | Futures | 3076.62 | 3078.95 | 3076.62 | 3078.37 | 222.0 |
| 2012-11-04 18:00:00 | YM | Futures | 12995.7 | 13008.7 | 12979.7 | 12992.7 | 1317.0 |
| 2012-11-04 19:00:00 | YM | Futures | 12991.7 | 13028.7 | 12991.7 | 13024.7 | 1506.0 |
| 2012-11-04 20:00:00 | YM | Futures | 13024.7 | 13036.7 | 13022.7 | 13031.7 | 863.0 |
| 2012-11-04 21:00:00 | YM | Futures | 13032.7 | 13034.7 | 13017.7 | 13018.7 | 530.0 |
| 2012-11-04 22:00:00 | YM | Futures | 13016.7 | 13026.7 | 13012.7 | 13023.7 | 302.0 |
| 2012-11-04 23:00:00 | YM | Futures | 13024.7 | 13029.7 | 13022.7 | 13026.7 | 272.0 |
| 2012-11-04 18:00:00 | CL | Futures | 137.55 | 137.96 | 137.47 | 137.76 | 1528.0 |
| 2012-11-04 19:00:00 | CL | Futures | 137.76 | 138.07 | 137.68 | 138.02 | 909.0 |
| 2012-11-04 20:00:00 | CL | Futures | 138.04 | 138.2 | 137.76 | 138.07 | 1414.0 |
| 2012-11-04 21:00:00 | CL | Futures | 138.06 | 138.12 | 137.88 | 137.91 | 1092.0 |
| 2012-11-04 22:00:00 | CL | Futures | 137.91 | 138.15 | 137.83 | 138.12 | 1038.0 |
| 2012-11-04 23:00:00 | CL | Futures | 138.12 | 138.49 | 138.12 | 138.38 | 1348.0 |
| 2012-11-04 18:00:00 | GC | Futures | 2313.1 | 2320.9 | 2312.1 | 2320.8 | 2320.0 |
| 2012-11-04 19:00:00 | GC | Futures | 2320.8 | 2324.1 | 2319.5 | 2322.7 | 4097.0 |
| 2012-11-04 20:00:00 | GC | Futures | 2322.9 | 2323.3 | 2317.6 | 2318.3 | 3703.0 |
| 2012-11-04 21:00:00 | GC | Futures | 2318.3 | 2319.1 | 2316.1 | 2316.7 | 2740.0 |
| 2012-11-04 22:00:00 | GC | Futures | 2316.5 | 2317.8 | 2315.1 | 2316.7 | 2021.0 |
| 2012-11-04 23:00:00 | GC | Futures | 2316.7 | 2318.4 | 2316.2 | 2317.1 | 1274.0 |
| 2012-11-04 18:00:00 | ZN | Futures | 117.868472 | 117.8962 | 117.840745 | 117.868472 | 3622.0 |
| 2012-11-04 19:00:00 | ZN | Futures | 117.868472 | 117.882336 | 117.813018 | 117.840745 | 4517.0 |
| 2012-11-04 20:00:00 | ZN | Futures | 117.840745 | 117.868472 | 117.826882 | 117.854609 | 5228.0 |
| 2012-11-04 21:00:00 | ZN | Futures | 117.854609 | 117.8962 | 117.854609 | 117.882336 | 3398.0 |
| 2012-11-04 22:00:00 | ZN | Futures | 117.882336 | 117.910063 | 117.868472 | 117.868472 | 2291.0 |
| 2012-11-04 23:00:00 | ZN | Futures | 117.882336 | 117.8962 | 117.868472 | 117.882336 | 1113.0 |
> showing 36 of 277 rows — these rows as CSV