PREVIEW / futures_daily / 2015-12-11
file: by_date/futures_daily/2015/2015-12-11.parquet size: 9 KB rows: 106
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 |
|---|---|---|---|---|---|---|---|
| 2015-12-11 | ES | Futures | 2181.49 | 2187.34 | 2132.82 | 2137.88 | 1577785.0 |
| 2015-12-11 | NQ | Futures | 5432.44 | 5447.34 | 5293.59 | 5307.33 | 226524.0 |
| 2015-12-11 | YM | Futures | 18112.1 | 18151.4 | 17731.3 | 17776.8 | 174443.0 |
| 2015-12-11 | CL | Futures | 56.58 | 56.9 | 54.3 | 55.02 | 505406.0 |
| 2015-12-11 | GC | Futures | 1381.8 | 1391.7 | 1369.3 | 1387.3 | 152623.0 |
| 2015-12-11 | ZN | Futures | 121.596088 | 122.558749 | 121.566005 | 122.408333 | 1280780.0 |
| 2015-12-11 | A6 | Futures | 0.72434 | 0.72524 | 0.71632 | 0.71693 | 82414.0 |
| 2015-12-11 | AD | Futures | 0.74977 | 0.75008 | 0.74323 | 0.74435 | 85089.0 |
| 2015-12-11 | ALI | Futures | 2136.52 | 2136.52 | 2136.52 | 2136.52 | 0.0 |
| 2015-12-11 | B | Futures | 34.78 | 34.97 | 32.88 | 33.4 | 281105.0 |
| 2015-12-11 | B6 | Futures | 1.5949 | 1.6037 | 1.5915 | 1.6026 | 80269.0 |
| 2015-12-11 | BR | Futures | 0.15906 | 0.15969 | 0.1578 | 0.15802 | 44.0 |
| 2015-12-11 | BZ | Futures | 34.55 | 34.66 | 32.59 | 33.1 | 26638.0 |
| 2015-12-11 | C | Futures | 2400.0 | 2410.0 | 2358.0 | 2398.0 | 14870.0 |
| 2015-12-11 | CB | Futures | 237.187 | 237.187 | 237.187 | 237.187 | 10.0 |
| 2015-12-11 | CC | Futures | 2474.0 | 2479.0 | 2440.0 | 2472.0 | 14001.0 |
| 2015-12-11 | CNH | Futures | 7.2433 | 7.2624 | 7.2433 | 7.2542 | 12.0 |
| 2015-12-11 | CSC | Futures | 3.915 | 3.915 | 3.878 | 3.893 | 91.0 |
| 2015-12-11 | CT | Futures | 74.7 | 74.86 | 74.3 | 74.63 | 9761.0 |
| 2015-12-11 | DC | Futures | 31.35 | 31.35 | 30.86 | 30.98 | 135.0 |
| 2015-12-11 | DX | Futures | 91.593 | 91.691 | 90.963 | 91.178 | 40128.0 |
| 2015-12-11 | E1 | Futures | 1.28243 | 1.29291 | 1.28041 | 1.29038 | 22153.0 |
| 2015-12-11 | E6 | Futures | 1.28274 | 1.29326 | 1.28087 | 1.28858 | 282255.0 |
| 2015-12-11 | E7 | Futures | 1.2757 | 1.2859 | 1.2739 | 1.2814 | 5450.0 |
| 2015-12-11 | EBM | Futures | 250.72 | 250.72 | 248.6 | 248.96 | 17045.0 |
| 2015-12-11 | ED | Futures | 95.5928 | 95.641 | 95.5928 | 95.6313 | 383266.0 |
| 2015-12-11 | ER | Futures | 98.205 | 98.215 | 98.2 | 98.21 | 49883.0 |
| 2015-12-11 | EW | Futures | 1485.0 | 1486.2 | 1456.5 | 1459.1 | 46436.0 |
| 2015-12-11 | FBON | Futures | 116.6 | 116.74 | 116.35 | 116.35 | 208.0 |
| 2015-12-11 | FBTP | Futures | 104.83 | 105.21 | 104.83 | 105.08 | 59911.0 |
| 2015-12-11 | FBTS | Futures | 100.597 | 100.641 | 100.588 | 100.615 | 25482.0 |
| 2015-12-11 | FCE | Futures | 3873.5 | 3875.6 | 3776.1 | 3802.0 | 136345.0 |
| 2015-12-11 | FDAX | Futures | 11672.3 | 11681.1 | 11309.4 | 11403.0 | 146776.0 |
| 2015-12-11 | FDXM | Futures | 10994.4 | 10994.4 | 10657.4 | 10740.4 | 549.0 |
| 2015-12-11 | FESX | Futures | 2478.7 | 2479.5 | 2410.3 | 2432.4 | 653674.0 |
| 2015-12-11 | FEU3 | Futures | 98.873 | 98.873 | 98.873 | 98.873 | 1.0 |
| 2015-12-11 | FGBL | Futures | 139.76 | 140.46 | 139.75 | 140.3 | 462028.0 |
| 2015-12-11 | FGBM | Futures | 125.69 | 125.94 | 125.68 | 125.87 | 282592.0 |
| 2015-12-11 | FGBS | Futures | 111.418 | 111.473 | 111.413 | 111.458 | 218641.0 |
| 2015-12-11 | FGBX | Futures | 157.06 | 159.45 | 156.94 | 158.83 | 23758.0 |
| 2015-12-11 | FMWO | Futures | 5554.4 | 5558.1 | 5490.1 | 5490.1 | 1957.0 |
| 2015-12-11 | FOAT | Futures | 128.27 | 128.84 | 128.27 | 128.71 | 51095.0 |
| 2015-12-11 | FTDX | Futures | 1720.4 | 1720.4 | 1694.5 | 1699.8 | 364.0 |
| 2015-12-11 | FTI | Futures | 382.35 | 382.35 | 372.91 | 375.05 | 2532.0 |
| 2015-12-11 | FTUK | Futures | 4922.9 | 4922.9 | 4787.9 | 4825.5 | 105092.0 |
| 2015-12-11 | FVSA | Futures | 2295.24 | 2650.18 | 2276.31 | 2470.34 | 22876.0 |
| 2015-12-11 | FXXP | Futures | 283.5 | 284.0 | 278.1 | 279.1 | 23320.0 |
| 2015-12-11 | G | Futures | 104.51 | 105.15 | 104.46 | 105.0 | 149880.0 |
| 2015-12-11 | GF | Futures | 295.042 | 297.407 | 288.142 | 293.643 | 4806.0 |
| 2015-12-11 | GSCI | Futures | 500.32 | 500.32 | 490.92 | 491.94 | 1927.0 |
> showing 50 of 106 rows — these rows as CSV