PREVIEW / futures_daily / 2015-11-20
file: by_date/futures_daily/2015/2015-11-20.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 |
|---|---|---|---|---|---|---|---|
| 2015-11-20 | ES | Futures | 2210.74 | 2228.03 | 2208.35 | 2221.91 | 1273905.0 |
| 2015-11-20 | NQ | Futures | 5444.71 | 5485.34 | 5439.45 | 5483.0 | 177125.0 |
| 2015-11-20 | YM | Futures | 18283.1 | 18452.3 | 18261.4 | 18366.7 | 103435.0 |
| 2015-11-20 | CL | Futures | 64.7 | 66.04 | 63.9 | 64.71 | 432642.0 |
| 2015-11-20 | GC | Futures | 1393.8 | 1403.5 | 1387.6 | 1389.4 | 157703.0 |
| 2015-11-20 | ZN | Futures | 121.401511 | 121.611056 | 121.311706 | 121.341641 | 955504.0 |
| 2015-11-20 | A6 | Futures | 0.71823 | 0.72433 | 0.71763 | 0.72333 | 102625.0 |
| 2015-11-20 | AD | Futures | 0.77035 | 0.77179 | 0.76666 | 0.76759 | 72449.0 |
| 2015-11-20 | ALI | Futures | 2078.35 | 2078.35 | 2078.35 | 2078.35 | 0.0 |
| 2015-11-20 | B | Futures | 39.15 | 40.14 | 38.87 | 39.39 | 245339.0 |
| 2015-11-20 | B6 | Futures | 1.6098 | 1.612 | 1.5987 | 1.5997 | 74901.0 |
| 2015-11-20 | BR | Futures | 0.16522 | 0.16645 | 0.16451 | 0.16509 | 1940.0 |
| 2015-11-20 | BZ | Futures | 38.83 | 39.88 | 38.62 | 39.14 | 29144.0 |
| 2015-11-20 | C | Futures | 2453.0 | 2482.0 | 2431.0 | 2450.0 | 7323.0 |
| 2015-11-20 | CB | Futures | 246.004 | 249.965 | 245.536 | 245.536 | 34.0 |
| 2015-11-20 | CC | Futures | 2500.0 | 2522.0 | 2463.0 | 2483.0 | 17409.0 |
| 2015-11-20 | CNH | Futures | 7.1314 | 7.1435 | 7.1277 | 7.1435 | 95.0 |
| 2015-11-20 | CSC | Futures | 4.081 | 4.133 | 4.081 | 4.104 | 44.0 |
| 2015-11-20 | CT | Futures | 74.12 | 74.35 | 71.76 | 72.02 | 3775.0 |
| 2015-11-20 | DC | Futures | 32.81 | 33.06 | 32.7 | 32.79 | 322.0 |
| 2015-11-20 | DX | Futures | 92.759 | 93.25 | 92.661 | 93.174 | 30327.0 |
| 2015-11-20 | E1 | Futures | 1.25246 | 1.25385 | 1.24459 | 1.24599 | 25256.0 |
| 2015-11-20 | E6 | Futures | 1.25707 | 1.25777 | 1.24676 | 1.24828 | 216641.0 |
| 2015-11-20 | E7 | Futures | 1.2504 | 1.2507 | 1.24 | 1.2414 | 4179.0 |
| 2015-11-20 | EBM | Futures | 259.42 | 260.51 | 257.22 | 257.59 | 19297.0 |
| 2015-11-20 | ED | Futures | 95.6823 | 95.6847 | 95.6775 | 95.6775 | 105297.0 |
| 2015-11-20 | ER | Futures | 98.234 | 98.259 | 98.234 | 98.249 | 125545.0 |
| 2015-11-20 | EW | Futures | 1515.4 | 1530.1 | 1514.2 | 1525.3 | 15466.0 |
| 2015-11-20 | FBON | Futures | 115.62 | 116.31 | 115.62 | 116.14 | 587.0 |
| 2015-11-20 | FBTP | Futures | 105.24 | 105.57 | 105.14 | 105.39 | 73129.0 |
| 2015-11-20 | FBTS | Futures | 100.668 | 100.722 | 100.668 | 100.713 | 15598.0 |
| 2015-11-20 | FCE | Futures | 4103.7 | 4124.2 | 4076.1 | 4103.7 | 85227.0 |
| 2015-11-20 | FDAX | Futures | 12185.5 | 12297.9 | 12169.0 | 12253.8 | 83807.0 |
| 2015-11-20 | FDXM | Futures | 11382.8 | 11489.8 | 11367.4 | 11447.6 | 11233.0 |
| 2015-11-20 | FESX | Futures | 2581.2 | 2601.4 | 2567.7 | 2589.4 | 983005.0 |
| 2015-11-20 | FEU3 | Futures | 98.892 | 98.902 | 98.892 | 98.902 | 100.0 |
| 2015-11-20 | FGBL | Futures | 140.56 | 140.76 | 140.4 | 140.61 | 485668.0 |
| 2015-11-20 | FGBM | Futures | 126.0 | 126.1 | 125.99 | 126.06 | 339085.0 |
| 2015-11-20 | FGBS | Futures | 111.548 | 111.568 | 111.543 | 111.558 | 206348.0 |
| 2015-11-20 | FGBX | Futures | 159.71 | 160.85 | 159.16 | 160.73 | 28228.0 |
| 2015-11-20 | FMWO | Futures | 5701.5 | 5715.1 | 5689.2 | 5707.7 | 284.0 |
| 2015-11-20 | FOAT | Futures | 129.13 | 129.31 | 128.99 | 129.11 | 74213.0 |
| 2015-11-20 | FTDX | Futures | 1738.7 | 1740.1 | 1726.4 | 1734.9 | 107.0 |
| 2015-11-20 | FTI | Futures | 406.63 | 409.67 | 405.24 | 407.37 | 34205.0 |
| 2015-11-20 | FTUK | Futures | 5085.9 | 5115.3 | 5069.8 | 5093.9 | 101367.0 |
| 2015-11-20 | FVSA | Futures | 2139.07 | 2153.27 | 2077.55 | 2105.94 | 8999.0 |
| 2015-11-20 | FXXP | Futures | 297.4 | 298.5 | 296.0 | 297.4 | 16197.0 |
| 2015-11-20 | G | Futures | 104.32 | 104.57 | 104.23 | 104.51 | 136687.0 |
| 2015-11-20 | GF | Futures | 313.042 | 318.302 | 311.015 | 315.889 | 3949.0 |
| 2015-11-20 | GSCI | Futures | 534.04 | 535.31 | 533.33 | 533.88 | 42.0 |
> showing 50 of 107 rows — these rows as CSV