PREVIEW / futures_daily / 2014-12-17
file: by_date/futures_daily/2014/2014-12-17.parquet size: 9 KB rows: 108
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-12-17 | ES | Futures | 2061.41 | 2107.79 | 2060.62 | 2104.9 | 2765611.0 |
| 2014-12-17 | NQ | Futures | 4743.56 | 4841.9 | 4735.73 | 4826.23 | 509046.0 |
| 2014-12-17 | YM | Futures | 17340.6 | 17647.1 | 17330.4 | 17611.5 | 297392.0 |
| 2014-12-17 | CL | Futures | 109.39 | 116.08 | 106.94 | 111.23 | 340243.0 |
| 2014-12-17 | GC | Futures | 1564.5 | 1574.8 | 1547.1 | 1563.5 | 169510.0 |
| 2014-12-17 | ZN | Futures | 120.335278 | 120.453052 | 119.555027 | 119.613914 | 1297023.0 |
| 2014-12-17 | A6 | Futures | 0.80003 | 0.80218 | 0.78896 | 0.78945 | 105386.0 |
| 2014-12-17 | AD | Futures | 0.87412 | 0.87921 | 0.87086 | 0.87126 | 95392.0 |
| 2014-12-17 | ALI | Futures | 2914.36 | 2914.36 | 2914.36 | 2914.36 | 0.0 |
| 2014-12-17 | B | Futures | 61.89 | 65.51 | 60.66 | 63.21 | 304053.0 |
| 2014-12-17 | B6 | Futures | 1.6547 | 1.655 | 1.6326 | 1.6342 | 122677.0 |
| 2014-12-17 | BFX | Futures | 3818.8 | 3843.0 | 3803.4 | 3841.1 | 74.0 |
| 2014-12-17 | BR | Futures | 0.1976 | 0.20207 | 0.1976 | 0.20041 | 45.0 |
| 2014-12-17 | BZ | Futures | 62.48 | 66.13 | 61.22 | 63.78 | 27234.0 |
| 2014-12-17 | C | Futures | 2100.0 | 2117.0 | 2097.0 | 2117.0 | 6765.0 |
| 2014-12-17 | CB | Futures | 134.933 | 134.933 | 134.111 | 134.316 | 74.0 |
| 2014-12-17 | CC | Futures | 2154.0 | 2163.0 | 2133.0 | 2151.0 | 8336.0 |
| 2014-12-17 | CNH | Futures | 7.1121 | 7.1131 | 7.1106 | 7.1106 | 12.0 |
| 2014-12-17 | CSC | Futures | 4.475 | 4.484 | 4.438 | 4.447 | 181.0 |
| 2014-12-17 | CT | Futures | 76.44 | 77.78 | 75.98 | 77.46 | 11228.0 |
| 2014-12-17 | DC | Futures | 34.57 | 34.83 | 34.48 | 34.71 | 152.0 |
| 2014-12-17 | DX | Futures | 83.478 | 84.59 | 83.379 | 84.554 | 60781.0 |
| 2014-12-17 | E1 | Futures | 1.33208 | 1.33234 | 1.31191 | 1.3128 | 70839.0 |
| 2014-12-17 | E6 | Futures | 1.47267 | 1.47302 | 1.45009 | 1.45114 | 319531.0 |
| 2014-12-17 | E7 | Futures | 1.4636 | 1.4642 | 1.4415 | 1.4425 | 5729.0 |
| 2014-12-17 | EBM | Futures | 316.71 | 325.63 | 315.09 | 324.01 | 47397.0 |
| 2014-12-17 | ED | Futures | 95.4306 | 95.4546 | 95.4259 | 95.4306 | 355438.0 |
| 2014-12-17 | ER | Futures | 97.994 | 97.999 | 97.984 | 97.994 | 83594.0 |
| 2014-12-17 | EW | Futures | 1450.0 | 1482.2 | 1447.1 | 1480.4 | 36408.0 |
| 2014-12-17 | FBTP | Futures | 97.77 | 98.11 | 97.49 | 98.0 | 51180.0 |
| 2014-12-17 | FBTS | Futures | 98.322 | 98.411 | 98.251 | 98.366 | 26483.0 |
| 2014-12-17 | FCE | Futures | 3292.5 | 3401.5 | 3292.1 | 3358.2 | 81663.0 |
| 2014-12-17 | FDAX | Futures | 10477.4 | 10749.4 | 10477.4 | 10640.6 | 73260.0 |
| 2014-12-17 | FDIV | Futures | 136.41 | 137.38 | 136.41 | 137.38 | 105.0 |
| 2014-12-17 | FESX | Futures | 2160.0 | 2227.8 | 2160.0 | 2202.6 | 1485560.0 |
| 2014-12-17 | FEU3 | Futures | 98.616 | 98.616 | 98.611 | 98.611 | 30.0 |
| 2014-12-17 | FGBL | Futures | 135.73 | 136.1 | 135.64 | 135.82 | 551706.0 |
| 2014-12-17 | FGBM | Futures | 123.44 | 123.61 | 123.44 | 123.54 | 251134.0 |
| 2014-12-17 | FGBS | Futures | 110.928 | 110.943 | 110.918 | 110.928 | 189607.0 |
| 2014-12-17 | FGBX | Futures | 154.77 | 155.55 | 154.11 | 154.77 | 31523.0 |
| 2014-12-17 | FMWO | Futures | 5514.4 | 5540.7 | 5506.9 | 5540.7 | 647.0 |
| 2014-12-17 | FOAT | Futures | 125.13 | 125.45 | 125.05 | 125.27 | 58688.0 |
| 2014-12-17 | FTDX | Futures | 1218.2 | 1242.6 | 1215.8 | 1236.0 | 643.0 |
| 2014-12-17 | FTI | Futures | 345.72 | 353.16 | 343.77 | 349.49 | 20410.0 |
| 2014-12-17 | FTUK | Futures | 4841.9 | 4943.2 | 4816.6 | 4910.9 | 140716.0 |
| 2014-12-17 | FVSA | Futures | 1900.95 | 1943.63 | 1831.12 | 1866.04 | 15118.0 |
| 2014-12-17 | FXXP | Futures | 245.3 | 249.7 | 244.8 | 248.8 | 41483.0 |
| 2014-12-17 | G | Futures | 102.7 | 103.1 | 102.55 | 102.94 | 140922.0 |
| 2014-12-17 | GF | Futures | 347.532 | 347.532 | 347.532 | 347.532 | 1060.0 |
| 2014-12-17 | GSCI | Futures | 737.4 | 764.59 | 737.14 | 749.25 | 81.0 |
> showing 50 of 108 rows — these rows as CSV