PREVIEW / futures_daily / 2015-11-05
file: by_date/futures_daily/2015/2015-11-05.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 |
|---|---|---|---|---|---|---|---|
| 2015-11-05 | ES | Futures | 2229.09 | 2238.93 | 2216.86 | 2227.5 | 1538081.0 |
| 2015-11-05 | NQ | Futures | 5504.93 | 5527.43 | 5464.59 | 5489.73 | 246167.0 |
| 2015-11-05 | YM | Futures | 18364.6 | 18433.7 | 18272.8 | 18367.7 | 126619.0 |
| 2015-11-05 | CL | Futures | 73.94 | 74.07 | 71.64 | 71.77 | 437646.0 |
| 2015-11-05 | GC | Futures | 1428.8 | 1434.6 | 1422.8 | 1425.4 | 144642.0 |
| 2015-11-05 | ZN | Futures | 121.611056 | 121.715829 | 121.341641 | 121.491316 | 1287589.0 |
| 2015-11-05 | A6 | Futures | 0.71273 | 0.71563 | 0.71123 | 0.71303 | 58810.0 |
| 2015-11-05 | AD | Futures | 0.77875 | 0.77916 | 0.7765 | 0.77783 | 39870.0 |
| 2015-11-05 | ALI | Futures | 2109.36 | 2109.36 | 2109.36 | 2109.36 | 0.0 |
| 2015-11-05 | B | Futures | 43.7 | 43.9 | 42.97 | 43.02 | 154892.0 |
| 2015-11-05 | B6 | Futures | 1.62 | 1.6215 | 1.6008 | 1.6013 | 152277.0 |
| 2015-11-05 | BR | Futures | 0.16063 | 0.16211 | 0.16057 | 0.16205 | 767.0 |
| 2015-11-05 | BZ | Futures | 43.46 | 43.6 | 42.72 | 42.75 | 15675.0 |
| 2015-11-05 | C | Futures | 2325.0 | 2375.0 | 2324.0 | 2370.0 | 9579.0 |
| 2015-11-05 | CB | Futures | 217.366 | 217.366 | 216.505 | 216.505 | 3.0 |
| 2015-11-05 | CC | Futures | 2387.0 | 2417.0 | 2381.0 | 2411.0 | 18321.0 |
| 2015-11-05 | CNH | Futures | 7.0778 | 7.0958 | 7.0767 | 7.0958 | 77.0 |
| 2015-11-05 | CSC | Futures | 4.235 | 4.286 | 4.235 | 4.286 | 77.0 |
| 2015-11-05 | CT | Futures | 74.53 | 74.74 | 74.09 | 74.32 | 15134.0 |
| 2015-11-05 | DC | Futures | 33.86 | 34.3 | 33.86 | 34.21 | 219.0 |
| 2015-11-05 | DX | Futures | 91.67 | 91.88 | 91.52 | 91.702 | 27038.0 |
| 2015-11-05 | E1 | Futures | 1.27808 | 1.27986 | 1.2725 | 1.27605 | 19832.0 |
| 2015-11-05 | E6 | Futures | 1.27358 | 1.27722 | 1.26972 | 1.27581 | 215243.0 |
| 2015-11-05 | E7 | Futures | 1.2664 | 1.2702 | 1.2627 | 1.2688 | 3587.0 |
| 2015-11-05 | EBM | Futures | 268.19 | 269.65 | 267.82 | 268.55 | 28988.0 |
| 2015-11-05 | ED | Futures | 95.7063 | 95.7159 | 95.7015 | 95.7111 | 212907.0 |
| 2015-11-05 | ER | Futures | 98.2 | 98.21 | 98.195 | 98.2 | 42369.0 |
| 2015-11-05 | EW | Futures | 1541.3 | 1547.4 | 1530.5 | 1541.1 | 14686.0 |
| 2015-11-05 | FBON | Futures | 114.83 | 115.06 | 114.37 | 114.48 | 1975.0 |
| 2015-11-05 | FBTP | Futures | 103.99 | 104.09 | 103.59 | 103.7 | 124761.0 |
| 2015-11-05 | FBTS | Futures | 100.534 | 100.561 | 100.507 | 100.525 | 20523.0 |
| 2015-11-05 | FCE | Futures | 4136.7 | 4175.5 | 4113.0 | 4151.7 | 92043.0 |
| 2015-11-05 | FDAX | Futures | 11970.2 | 12077.6 | 11874.4 | 11997.2 | 92811.0 |
| 2015-11-05 | FDXM | Futures | 11179.0 | 11281.9 | 11094.7 | 11207.9 | 9993.0 |
| 2015-11-05 | FESX | Futures | 2578.9 | 2602.1 | 2559.4 | 2581.9 | 1163825.0 |
| 2015-11-05 | FEU3 | Futures | 98.848 | 98.853 | 98.848 | 98.848 | 10.0 |
| 2015-11-05 | FGBL | Futures | 139.21 | 139.37 | 138.91 | 139.06 | 720787.0 |
| 2015-11-05 | FGBM | Futures | 125.56 | 125.61 | 125.45 | 125.51 | 492286.0 |
| 2015-11-05 | FGBS | Futures | 111.438 | 111.438 | 111.408 | 111.428 | 300922.0 |
| 2015-11-05 | FGBX | Futures | 157.2 | 157.71 | 155.82 | 156.33 | 42472.0 |
| 2015-11-05 | FMWO | Futures | 5746.0 | 5758.4 | 5701.5 | 5716.4 | 443.0 |
| 2015-11-05 | FOAT | Futures | 127.63 | 127.92 | 127.45 | 127.62 | 154323.0 |
| 2015-11-05 | FTDX | Futures | 1708.3 | 1727.8 | 1708.3 | 1720.2 | 195.0 |
| 2015-11-05 | FTI | Futures | 408.04 | 409.87 | 404.77 | 405.77 | 32254.0 |
| 2015-11-05 | FTUK | Futures | 5122.9 | 5150.6 | 5096.0 | 5101.6 | 98168.0 |
| 2015-11-05 | FVSA | Futures | 2026.45 | 2067.81 | 2003.48 | 2031.05 | 5826.0 |
| 2015-11-05 | FXXP | Futures | 296.4 | 297.0 | 294.1 | 294.6 | 22016.0 |
| 2015-11-05 | G | Futures | 103.44 | 103.87 | 103.37 | 103.69 | 200734.0 |
| 2015-11-05 | GF | Futures | 334.223 | 334.72 | 325.55 | 328.17 | 5220.0 |
| 2015-11-05 | GSCI | Futures | 579.6 | 580.89 | 574.43 | 574.59 | 65.0 |
> showing 50 of 108 rows — these rows as CSV