PREVIEW / futures_daily / 2012-01-06
file: by_date/futures_daily/2012/2012-01-06.parquet size: 9 KB rows: 97
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2012-01-06 | ES | Futures | 1277.79 | 1286.82 | 1271.27 | 1278.79 | 1691991.0 |
| 2012-01-06 | NQ | Futures | 2676.3 | 2697.46 | 2667.44 | 2690.02 | 158875.0 |
| 2012-01-06 | YM | Futures | 11926.9 | 11999.5 | 11867.9 | 11903.7 | 96123.0 |
| 2012-01-06 | CL | Futures | 189.41 | 192.12 | 188.54 | 189.81 | 290458.0 |
| 2012-01-06 | GC | Futures | 2190.5 | 2203.9 | 2172.4 | 2182.9 | 155211.0 |
| 2012-01-06 | ZN | Futures | 112.773677 | 113.111242 | 112.42261 | 112.989719 | 931949.0 |
| 2012-01-06 | A6 | Futures | 0.9055 | 0.90719 | 0.90043 | 0.90372 | 95720.0 |
| 2012-01-06 | AD | Futures | 0.98254 | 0.98525 | 0.97421 | 0.97602 | 68563.0 |
| 2012-01-06 | B | Futures | 99.8 | 100.97 | 99.59 | 100.54 | 139529.0 |
| 2012-01-06 | B6 | Futures | 1.6187 | 1.6219 | 1.6062 | 1.6113 | 79764.0 |
| 2012-01-06 | BFX | Futures | 2526.2 | 2535.7 | 2504.3 | 2508.9 | 55.0 |
| 2012-01-06 | BR | Futures | 0.25136 | 0.25136 | 0.24954 | 0.24973 | 492.0 |
| 2012-01-06 | BZ | Futures | 106.63 | 107.0 | 105.81 | 106.7 | 806.0 |
| 2012-01-06 | C | Futures | 1347.0 | 1379.0 | 1347.0 | 1361.0 | 7825.0 |
| 2012-01-06 | CB | Futures | 89.346 | 89.884 | 89.346 | 89.884 | 10.0 |
| 2012-01-06 | CC | Futures | 1563.0 | 1603.0 | 1553.0 | 1572.0 | 9462.0 |
| 2012-01-06 | CSC | Futures | 4.078 | 4.081 | 4.073 | 4.081 | 9.0 |
| 2012-01-06 | CT | Futures | 122.35 | 123.54 | 121.58 | 123.46 | 7416.0 |
| 2012-01-06 | DC | Futures | 29.87 | 30.21 | 29.62 | 29.99 | 293.0 |
| 2012-01-06 | DX | Futures | 79.077 | 79.539 | 78.892 | 79.42 | 26604.0 |
| 2012-01-06 | E1 | Futures | 1.3801 | 1.38259 | 1.37183 | 1.37603 | 22520.0 |
| 2012-01-06 | E6 | Futures | 1.52975 | 1.53238 | 1.51839 | 1.5215 | 227148.0 |
| 2012-01-06 | E7 | Futures | 1.5155 | 1.5184 | 1.5045 | 1.5076 | 4477.0 |
| 2012-01-06 | EBM | Futures | 253.88 | 257.49 | 253.88 | 255.85 | 10837.0 |
| 2012-01-06 | ED | Futures | 94.9339 | 94.9769 | 94.9292 | 94.9626 | 280184.0 |
| 2012-01-06 | ER | Futures | 97.326 | 97.366 | 97.317 | 97.336 | 142343.0 |
| 2012-01-06 | EW | Futures | 892.0 | 901.3 | 887.4 | 895.8 | 20880.0 |
| 2012-01-06 | FBTP | Futures | 57.61 | 57.61 | 57.1 | 57.36 | 7436.0 |
| 2012-01-06 | FBTS | Futures | 79.793 | 79.873 | 79.512 | 79.592 | 694.0 |
| 2012-01-06 | FCE | Futures | 2254.9 | 2281.8 | 2235.2 | 2244.9 | 69984.0 |
| 2012-01-06 | FDAX | Futures | 6741.8 | 6802.6 | 6644.1 | 6692.7 | 138914.0 |
| 2012-01-06 | FESX | Futures | 1543.7 | 1562.4 | 1523.6 | 1531.0 | 840502.0 |
| 2012-01-06 | FGBL | Futures | 112.18 | 112.49 | 111.9 | 112.36 | 420617.0 |
| 2012-01-06 | FGBM | Futures | 113.04 | 113.27 | 112.95 | 113.12 | 228804.0 |
| 2012-01-06 | FGBS | Futures | 109.854 | 109.924 | 109.835 | 109.879 | 207015.0 |
| 2012-01-06 | FGBX | Futures | 117.79 | 118.07 | 117.05 | 117.79 | 3292.0 |
| 2012-01-06 | FTDX | Futures | 650.7 | 664.6 | 650.7 | 660.0 | 91.0 |
| 2012-01-06 | FTI | Futures | 261.93 | 263.49 | 259.88 | 261.05 | 31674.0 |
| 2012-01-06 | FTUK | Futures | 4035.2 | 4071.6 | 4017.8 | 4042.7 | 78848.0 |
| 2012-01-06 | FVSA | Futures | 12401.02 | 12401.02 | 12221.59 | 12261.46 | 3583.0 |
| 2012-01-06 | FXXP | Futures | 174.8 | 175.8 | 173.5 | 174.1 | 1469.0 |
| 2012-01-06 | G | Futures | 94.26 | 94.74 | 94.0 | 94.53 | 85600.0 |
| 2012-01-06 | GF | Futures | 319.18 | 320.203 | 316.757 | 317.295 | 1199.0 |
| 2012-01-06 | GSCI | Futures | 1041.14 | 1043.65 | 1033.69 | 1039.18 | 344.0 |
| 2012-01-06 | HE | Futures | 103.37 | 104.263 | 103.37 | 103.431 | 17094.0 |
| 2012-01-06 | HG | Futures | 4.4998 | 4.5703 | 4.476 | 4.5307 | 37019.0 |
| 2012-01-06 | HO | Futures | 2.4644 | 2.4974 | 2.4575 | 2.4795 | 29845.0 |
| 2012-01-06 | HRC | Futures | 2876.8 | 2876.8 | 2876.8 | 2876.8 | 75.0 |
| 2012-01-06 | J1 | Futures | 0.0162933 | 0.0163322 | 0.0162519 | 0.0163184 | 58527.0 |
| 2012-01-06 | J7 | Futures | 0.016227 | 0.016261 | 0.016187 | 0.016251 | 355.0 |
> showing 50 of 97 rows — these rows as CSV