PREVIEW / futures_daily / 2016-02-17
file: by_date/futures_daily/2016/2016-02-17.parquet size: 10 KB rows: 110
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 |
|---|---|---|---|---|---|---|---|
| 2016-02-17 | ES | Futures | 2016.91 | 2059.37 | 2009.7 | 2053.76 | 1854185.0 |
| 2016-02-17 | NQ | Futures | 4794.45 | 4937.17 | 4769.24 | 4919.88 | 291649.0 |
| 2016-02-17 | YM | Futures | 16691.3 | 17026.6 | 16634.4 | 16984.2 | 169513.0 |
| 2016-02-17 | CL | Futures | 39.19 | 42.29 | 38.71 | 41.44 | 458686.0 |
| 2016-02-17 | GC | Futures | 1544.3 | 1560.4 | 1537.0 | 1556.6 | 162454.0 |
| 2016-02-17 | ZN | Futures | 126.063436 | 126.304101 | 125.326399 | 125.567064 | 1483319.0 |
| 2016-02-17 | A6 | Futures | 0.71171 | 0.71933 | 0.70901 | 0.71733 | 87188.0 |
| 2016-02-17 | AD | Futures | 0.73719 | 0.74803 | 0.73566 | 0.74507 | 74018.0 |
| 2016-02-17 | ALI | Futures | 2070.69 | 2070.69 | 2070.69 | 2070.69 | 20.0 |
| 2016-02-17 | B | Futures | 27.34 | 29.4 | 26.74 | 28.99 | 355922.0 |
| 2016-02-17 | B6 | Futures | 1.5053 | 1.5088 | 1.4975 | 1.5033 | 88733.0 |
| 2016-02-17 | BFX | Futures | 3859.8 | 3954.6 | 3859.8 | 3953.5 | 81.0 |
| 2016-02-17 | BR | Futures | 0.15347 | 0.1578 | 0.15347 | 0.15727 | 3951.0 |
| 2016-02-17 | BZ | Futures | 27.0 | 29.16 | 26.56 | 28.77 | 40298.0 |
| 2016-02-17 | C | Futures | 2153.0 | 2200.0 | 2146.0 | 2182.0 | 8268.0 |
| 2016-02-17 | CB | Futures | 258.524 | 258.524 | 258.524 | 258.524 | 4.0 |
| 2016-02-17 | CC | Futures | 2075.0 | 2135.0 | 2057.0 | 2109.0 | 21807.0 |
| 2016-02-17 | CNH | Futures | 7.1853 | 7.1919 | 7.1853 | 7.1873 | 7.0 |
| 2016-02-17 | CSC | Futures | 3.731 | 3.74 | 3.731 | 3.74 | 3.0 |
| 2016-02-17 | CT | Futures | 69.97 | 70.17 | 69.93 | 70.13 | 16713.0 |
| 2016-02-17 | DC | Futures | 29.66 | 29.83 | 29.66 | 29.72 | 163.0 |
| 2016-02-17 | DX | Futures | 90.598 | 90.72 | 90.281 | 90.425 | 14185.0 |
| 2016-02-17 | E1 | Futures | 1.27864 | 1.28256 | 1.27119 | 1.27523 | 19434.0 |
| 2016-02-17 | E6 | Futures | 1.30355 | 1.30805 | 1.29946 | 1.30332 | 172728.0 |
| 2016-02-17 | E7 | Futures | 1.296 | 1.3007 | 1.2923 | 1.296 | 3054.0 |
| 2016-02-17 | EBM | Futures | 216.11 | 216.82 | 214.35 | 216.47 | 9615.0 |
| 2016-02-17 | ED | Futures | 95.6434 | 95.6458 | 95.6313 | 95.6385 | 229055.0 |
| 2016-02-17 | ER | Futures | 98.293 | 98.293 | 98.283 | 98.293 | 56475.0 |
| 2016-02-17 | EW | Futures | 1354.8 | 1385.0 | 1350.9 | 1379.3 | 19685.0 |
| 2016-02-17 | FBON | Futures | 115.76 | 115.76 | 115.54 | 115.67 | 323.0 |
| 2016-02-17 | FBTP | Futures | 104.64 | 104.93 | 104.59 | 104.74 | 76705.0 |
| 2016-02-17 | FBTS | Futures | 100.748 | 100.793 | 100.713 | 100.748 | 14972.0 |
| 2016-02-17 | FCE | Futures | 3431.5 | 3539.4 | 3414.9 | 3524.8 | 128767.0 |
| 2016-02-17 | FDAX | Futures | 9933.9 | 10212.6 | 9900.3 | 10167.6 | 99523.0 |
| 2016-02-17 | FDXM | Futures | 9490.0 | 9766.8 | 9468.2 | 9722.2 | 22506.0 |
| 2016-02-17 | FESX | Futures | 2151.0 | 2213.4 | 2141.1 | 2201.2 | 1543128.0 |
| 2016-02-17 | FEU3 | Futures | 98.947 | 98.952 | 98.947 | 98.952 | 502.0 |
| 2016-02-17 | FGBL | Futures | 145.04 | 145.11 | 144.57 | 144.72 | 656446.0 |
| 2016-02-17 | FGBM | Futures | 127.46 | 127.49 | 127.3 | 127.38 | 423987.0 |
| 2016-02-17 | FGBS | Futures | 111.783 | 111.788 | 111.733 | 111.758 | 258689.0 |
| 2016-02-17 | FGBX | Futures | 170.56 | 170.64 | 168.9 | 169.56 | 38938.0 |
| 2016-02-17 | FMWO | Futures | 5112.3 | 5224.4 | 5112.3 | 5221.9 | 309.0 |
| 2016-02-17 | FOAT | Futures | 131.44 | 131.59 | 131.15 | 131.35 | 93085.0 |
| 2016-02-17 | FTDX | Futures | 1478.1 | 1526.6 | 1478.1 | 1519.8 | 383.0 |
| 2016-02-17 | FTI | Futures | 357.21 | 367.04 | 355.88 | 366.07 | 21015.0 |
| 2016-02-17 | FTUK | Futures | 4776.9 | 4907.8 | 4743.1 | 4872.4 | 146054.0 |
| 2016-02-17 | FVSA | Futures | 3489.76 | 3489.76 | 3320.25 | 3337.78 | 15166.0 |
| 2016-02-17 | FXXP | Futures | 251.4 | 258.5 | 250.9 | 258.0 | 26845.0 |
| 2016-02-17 | G | Futures | 108.42 | 108.52 | 107.77 | 107.89 | 217459.0 |
| 2016-02-17 | GF | Futures | 303.856 | 310.237 | 303.709 | 306.31 | 4207.0 |
> showing 50 of 110 rows — these rows as CSV