PREVIEW / futures_daily / 2014-01-08
file: by_date/futures_daily/2014/2014-01-08.parquet size: 9 KB rows: 107
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 |
|---|---|---|---|---|---|---|---|
| 2014-01-08 | ES | Futures | 1887.24 | 1891.36 | 1881.83 | 1889.04 | 1330414.0 |
| 2014-01-08 | NQ | Futures | 4079.09 | 4103.52 | 4074.21 | 4098.06 | 208163.0 |
| 2014-01-08 | YM | Futures | 16433.0 | 16457.0 | 16330.2 | 16381.1 | 120757.0 |
| 2014-01-08 | CL | Futures | 165.87 | 166.26 | 162.87 | 163.0 | 244855.0 |
| 2014-01-08 | GC | Futures | 1629.9 | 1630.9 | 1612.3 | 1622.6 | 157113.0 |
| 2014-01-08 | ZN | Futures | 113.189365 | 113.189365 | 112.631359 | 112.731514 | 1220424.0 |
| 2014-01-08 | A6 | Futures | 0.84558 | 0.84958 | 0.84405 | 0.8452 | 90163.0 |
| 2014-01-08 | AD | Futures | 0.93871 | 0.93901 | 0.93344 | 0.93547 | 86135.0 |
| 2014-01-08 | B | Futures | 109.04 | 109.51 | 108.55 | 108.66 | 174765.0 |
| 2014-01-08 | B6 | Futures | 1.7221 | 1.7296 | 1.7196 | 1.7274 | 88301.0 |
| 2014-01-08 | BFX | Futures | 3534.4 | 3543.0 | 3534.4 | 3543.0 | 7.0 |
| 2014-01-08 | BR | Futures | 0.21549 | 0.21567 | 0.21194 | 0.21394 | 77.0 |
| 2014-01-08 | BZ | Futures | 111.22 | 111.67 | 110.71 | 110.83 | 8761.0 |
| 2014-01-08 | C | Futures | 1809.0 | 1825.0 | 1801.0 | 1820.0 | 8555.0 |
| 2014-01-08 | CB | Futures | 81.329 | 83.145 | 81.329 | 82.924 | 51.0 |
| 2014-01-08 | CC | Futures | 1993.0 | 2015.0 | 1981.0 | 2004.0 | 11489.0 |
| 2014-01-08 | CNH | Futures | 6.9607 | 6.964 | 6.9562 | 6.964 | 25.0 |
| 2014-01-08 | CSC | Futures | 3.938 | 3.988 | 3.938 | 3.963 | 39.0 |
| 2014-01-08 | CT | Futures | 96.33 | 96.54 | 94.66 | 94.8 | 15895.0 |
| 2014-01-08 | DC | Futures | 30.49 | 30.71 | 30.32 | 30.52 | 413.0 |
| 2014-01-08 | DX | Futures | 77.089 | 77.346 | 77.008 | 77.182 | 38066.0 |
| 2014-01-08 | E1 | Futures | 1.4126 | 1.41491 | 1.40695 | 1.41041 | 35002.0 |
| 2014-01-08 | E6 | Futures | 1.60731 | 1.60943 | 1.59975 | 1.6033 | 209215.0 |
| 2014-01-08 | E7 | Futures | 1.5967 | 1.5989 | 1.5894 | 1.5928 | 6634.0 |
| 2014-01-08 | EBM | Futures | 280.87 | 281.22 | 277.39 | 277.74 | 22147.0 |
| 2014-01-08 | ED | Futures | 95.3614 | 95.3614 | 95.3566 | 95.3566 | 96982.0 |
| 2014-01-08 | ER | Futures | 97.852 | 97.857 | 97.832 | 97.837 | 91812.0 |
| 2014-01-08 | EW | Futures | 1360.8 | 1367.3 | 1355.6 | 1365.7 | 15325.0 |
| 2014-01-08 | FBTP | Futures | 83.38 | 83.6 | 83.31 | 83.39 | 39362.0 |
| 2014-01-08 | FBTS | Futures | 96.073 | 96.126 | 96.012 | 96.073 | 1.0 |
| 2014-01-08 | FCE | Futures | 3321.1 | 3329.7 | 3307.5 | 3320.3 | 85173.0 |
| 2014-01-08 | FDAX | Futures | 10547.2 | 10575.5 | 10507.3 | 10525.0 | 77263.0 |
| 2014-01-08 | FDIV | Futures | 143.6 | 144.04 | 143.6 | 143.85 | 35.0 |
| 2014-01-08 | FESX | Futures | 2185.1 | 2192.2 | 2177.4 | 2180.2 | 708278.0 |
| 2014-01-08 | FEU3 | Futures | 98.468 | 98.473 | 98.453 | 98.453 | 439.0 |
| 2014-01-08 | FGBL | Futures | 118.93 | 119.07 | 118.65 | 118.74 | 716245.0 |
| 2014-01-08 | FGBM | Futures | 117.42 | 117.53 | 117.22 | 117.3 | 436058.0 |
| 2014-01-08 | FGBS | Futures | 110.333 | 110.363 | 110.298 | 110.303 | 324062.0 |
| 2014-01-08 | FGBX | Futures | 119.14 | 119.42 | 118.68 | 118.83 | 16354.0 |
| 2014-01-08 | FMWO | Futures | 5410.7 | 5410.7 | 5405.7 | 5405.7 | 50.0 |
| 2014-01-08 | FOAT | Futures | 108.11 | 108.26 | 107.91 | 107.97 | 40238.0 |
| 2014-01-08 | FTDX | Futures | 1125.8 | 1125.8 | 1121.1 | 1122.1 | 194.0 |
| 2014-01-08 | FTI | Futures | 346.29 | 347.2 | 345.78 | 346.68 | 19502.0 |
| 2014-01-08 | FTUK | Futures | 5071.4 | 5079.4 | 5040.0 | 5043.8 | 69290.0 |
| 2014-01-08 | FVSA | Futures | 1853.8 | 1896.79 | 1816.19 | 1875.3 | 3160.0 |
| 2014-01-08 | FXXP | Futures | 240.7 | 241.8 | 240.7 | 241.2 | 5422.0 |
| 2014-01-08 | G | Futures | 90.8 | 90.97 | 90.6 | 90.64 | 148299.0 |
| 2014-01-08 | GF | Futures | 270.582 | 272.03 | 270.058 | 271.225 | 1767.0 |
| 2014-01-08 | GSCI | Futures | 1015.5 | 1015.5 | 1007.9 | 1007.98 | 1527.0 |
| 2014-01-08 | HE | Futures | 103.381 | 103.834 | 102.686 | 103.35 | 21592.0 |
> showing 50 of 107 rows — these rows as CSV