PREVIEW / futures_daily / 2013-02-05
file: by_date/futures_daily/2013/2013-02-05.parquet size: 9 KB rows: 100
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 |
|---|---|---|---|---|---|---|---|
| 2013-02-05 | ES | Futures | 1527.12 | 1546.05 | 1526.86 | 1540.93 | 1741970.0 |
| 2013-02-05 | NQ | Futures | 3125.82 | 3182.63 | 3124.95 | 3171.09 | 243055.0 |
| 2013-02-05 | YM | Futures | 13569.5 | 13687.1 | 13565.5 | 13640.1 | 113758.0 |
| 2013-02-05 | CL | Futures | 169.4 | 171.06 | 169.02 | 170.3 | 188841.0 |
| 2013-02-05 | GC | Futures | 2227.0 | 2242.3 | 2216.0 | 2224.4 | 154153.0 |
| 2013-02-05 | ZN | Futures | 116.087269 | 116.128615 | 115.660021 | 115.742714 | 1204324.0 |
| 2013-02-05 | A6 | Futures | 0.95179 | 0.9549 | 0.94593 | 0.95014 | 106904.0 |
| 2013-02-05 | AD | Futures | 1.00279 | 1.0065 | 1.00219 | 1.0061 | 53639.0 |
| 2013-02-05 | B | Futures | 108.37 | 109.95 | 107.94 | 109.33 | 170078.0 |
| 2013-02-05 | B6 | Futures | 1.6458 | 1.6513 | 1.633 | 1.6362 | 143369.0 |
| 2013-02-05 | BFX | Futures | 3024.2 | 3037.8 | 3024.2 | 3037.8 | 37.0 |
| 2013-02-05 | BR | Futures | 0.24589 | 0.24675 | 0.24589 | 0.24635 | 112.0 |
| 2013-02-05 | BZ | Futures | 110.8 | 112.67 | 110.66 | 112.06 | 7781.0 |
| 2013-02-05 | C | Futures | 1534.0 | 1570.0 | 1526.0 | 1569.0 | 8124.0 |
| 2013-02-05 | CC | Futures | 1660.0 | 1704.0 | 1660.0 | 1701.0 | 14611.0 |
| 2013-02-05 | CSC | Futures | 3.616 | 3.616 | 3.556 | 3.586 | 32.0 |
| 2013-02-05 | CT | Futures | 102.76 | 103.05 | 101.68 | 102.58 | 17379.0 |
| 2013-02-05 | DC | Futures | 26.89 | 27.14 | 26.7 | 26.86 | 196.0 |
| 2013-02-05 | DX | Futures | 76.817 | 76.977 | 76.663 | 76.705 | 31432.0 |
| 2013-02-05 | E1 | Futures | 1.41702 | 1.41946 | 1.41264 | 1.41818 | 31753.0 |
| 2013-02-05 | E6 | Futures | 1.59267 | 1.60423 | 1.58772 | 1.60258 | 364363.0 |
| 2013-02-05 | E7 | Futures | 1.582 | 1.5933 | 1.577 | 1.5916 | 5711.0 |
| 2013-02-05 | EBM | Futures | 275.34 | 275.62 | 271.72 | 273.95 | 13210.0 |
| 2013-02-05 | ED | Futures | 95.2247 | 95.2342 | 95.2247 | 95.2295 | 64192.0 |
| 2013-02-05 | ER | Futures | 97.744 | 97.749 | 97.734 | 97.744 | 63476.0 |
| 2013-02-05 | EW | Futures | 1112.5 | 1121.1 | 1112.5 | 1117.3 | 17527.0 |
| 2013-02-05 | FBTP | Futures | 75.73 | 76.04 | 75.32 | 75.83 | 35513.0 |
| 2013-02-05 | FBTS | Futures | 91.129 | 91.442 | 91.086 | 91.349 | 7474.0 |
| 2013-02-05 | FCE | Futures | 2741.1 | 2784.3 | 2740.4 | 2771.5 | 115675.0 |
| 2013-02-05 | FDAX | Futures | 8328.4 | 8392.2 | 8324.0 | 8372.0 | 115621.0 |
| 2013-02-05 | FESX | Futures | 1785.9 | 1813.2 | 1781.8 | 1807.0 | 1082695.0 |
| 2013-02-05 | FEU3 | Futures | 98.349 | 98.349 | 98.344 | 98.349 | 18.0 |
| 2013-02-05 | FGBL | Futures | 117.91 | 118.14 | 117.32 | 117.54 | 928846.0 |
| 2013-02-05 | FGBM | Futures | 116.12 | 116.24 | 115.85 | 115.94 | 580281.0 |
| 2013-02-05 | FGBS | Futures | 110.068 | 110.098 | 110.013 | 110.028 | 416134.0 |
| 2013-02-05 | FGBX | Futures | 124.91 | 125.52 | 123.69 | 124.14 | 12161.0 |
| 2013-02-05 | FOAT | Futures | 104.33 | 104.45 | 103.95 | 104.12 | 42303.0 |
| 2013-02-05 | FTDX | Futures | 824.1 | 828.4 | 819.9 | 827.0 | 235.0 |
| 2013-02-05 | FTI | Futures | 299.94 | 300.24 | 298.31 | 298.95 | 33516.0 |
| 2013-02-05 | FTUK | Futures | 4568.6 | 4602.4 | 4559.7 | 4588.8 | 102131.0 |
| 2013-02-05 | FVSA | Futures | 3556.87 | 3556.87 | 3348.18 | 3429.84 | 9196.0 |
| 2013-02-05 | FXXP | Futures | 204.7 | 205.9 | 204.7 | 204.8 | 13128.0 |
| 2013-02-05 | G | Futures | 96.88 | 96.92 | 96.29 | 96.45 | 165883.0 |
| 2013-02-05 | GF | Futures | 277.716 | 279.911 | 277.436 | 277.482 | 2611.0 |
| 2013-02-05 | GSCI | Futures | 1088.87 | 1090.56 | 1086.7 | 1087.35 | 278.0 |
| 2013-02-05 | HE | Futures | 98.694 | 98.89 | 98.05 | 98.246 | 19948.0 |
| 2013-02-05 | HG | Futures | 4.8387 | 4.8567 | 4.8246 | 4.8413 | 40570.0 |
| 2013-02-05 | HH | Futures | 39.113 | 40.013 | 38.763 | 39.709 | 450.0 |
| 2013-02-05 | HO | Futures | 2.5484 | 2.5825 | 2.5396 | 2.5746 | 73654.0 |
| 2013-02-05 | HRC | Futures | 2346.5 | 2346.5 | 2346.5 | 2346.5 | 0.0 |
> showing 50 of 100 rows — these rows as CSV