PREVIEW / futures_daily / 2015-09-14
file: by_date/futures_daily/2015/2015-09-14.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-09-14 | ES | Futures | 2077.51 | 2089.47 | 2059.96 | 2067.93 | 1574502.0 |
| 2015-09-14 | NQ | Futures | 5049.81 | 5081.96 | 5005.97 | 5027.3 | 201299.0 |
| 2015-09-14 | YM | Futures | 16868.5 | 16954.2 | 16740.6 | 16796.3 | 129390.0 |
| 2015-09-14 | CL | Futures | 72.79 | 73.03 | 70.82 | 71.36 | 171247.0 |
| 2015-09-14 | GC | Futures | 1429.0 | 1432.6 | 1423.3 | 1429.9 | 74178.0 |
| 2015-09-14 | ZN | Futures | 122.090016 | 122.314529 | 121.985244 | 122.179821 | 550448.0 |
| 2015-09-14 | A6 | Futures | 0.70543 | 0.71193 | 0.70313 | 0.71043 | 68005.0 |
| 2015-09-14 | AD | Futures | 0.77199 | 0.77424 | 0.77097 | 0.77209 | 47455.0 |
| 2015-09-14 | ALI | Futures | 2190.96 | 2190.96 | 2190.96 | 2190.96 | 0.0 |
| 2015-09-14 | B | Futures | 44.41 | 44.64 | 42.82 | 42.91 | 250979.0 |
| 2015-09-14 | B6 | Futures | 1.624 | 1.6285 | 1.6181 | 1.6247 | 55359.0 |
| 2015-09-14 | BFX | Futures | 4129.4 | 4131.8 | 4112.0 | 4112.0 | 38.0 |
| 2015-09-14 | BR | Futures | 0.15238 | 0.157 | 0.15161 | 0.15644 | 135.0 |
| 2015-09-14 | BZ | Futures | 44.48 | 44.5 | 42.82 | 42.91 | 22505.0 |
| 2015-09-14 | C | Futures | 2332.0 | 2354.0 | 2328.0 | 2352.0 | 8757.0 |
| 2015-09-14 | CB | Futures | 193.87 | 193.87 | 193.87 | 193.87 | 2.0 |
| 2015-09-14 | CC | Futures | 2390.0 | 2411.0 | 2382.0 | 2410.0 | 11455.0 |
| 2015-09-14 | CNH | Futures | 7.1823 | 7.1904 | 7.1822 | 7.1841 | 32.0 |
| 2015-09-14 | CSC | Futures | 4.401 | 4.424 | 4.401 | 4.401 | 32.0 |
| 2015-09-14 | CT | Futures | 78.61 | 78.86 | 77.72 | 77.72 | 6.0 |
| 2015-09-14 | DC | Futures | 35.08 | 35.12 | 34.66 | 34.83 | 223.0 |
| 2015-09-14 | DX | Futures | 89.121 | 89.434 | 88.911 | 89.235 | 20243.0 |
| 2015-09-14 | E1 | Futures | 1.31334 | 1.31639 | 1.30928 | 1.3136 | 10862.0 |
| 2015-09-14 | E6 | Futures | 1.33005 | 1.33438 | 1.32396 | 1.32747 | 156093.0 |
| 2015-09-14 | E7 | Futures | 1.3234 | 1.3271 | 1.3166 | 1.3201 | 3155.0 |
| 2015-09-14 | EBM | Futures | 248.09 | 250.28 | 246.63 | 249.55 | 22396.0 |
| 2015-09-14 | ED | Futures | 95.6535 | 95.6631 | 95.6535 | 95.6535 | 211434.0 |
| 2015-09-14 | ER | Futures | 98.126 | 98.131 | 98.122 | 98.126 | 53875.0 |
| 2015-09-14 | EW | Futures | 1487.4 | 1496.1 | 1475.6 | 1477.8 | 33705.0 |
| 2015-09-14 | FBTP | Futures | 101.28 | 101.57 | 101.24 | 101.31 | 37903.0 |
| 2015-09-14 | FBTS | Futures | 100.186 | 100.204 | 100.177 | 100.186 | 9967.0 |
| 2015-09-14 | FCE | Futures | 3808.7 | 3821.6 | 3747.0 | 3754.9 | 59877.0 |
| 2015-09-14 | FDAX | Futures | 11253.0 | 11306.0 | 11145.2 | 11239.2 | 120053.0 |
| 2015-09-14 | FESX | Futures | 2398.3 | 2405.0 | 2364.6 | 2380.3 | 1090199.0 |
| 2015-09-14 | FEU3 | Futures | 98.774 | 98.774 | 98.774 | 98.774 | 260.0 |
| 2015-09-14 | FGBL | Futures | 138.1 | 138.38 | 137.92 | 138.17 | 342085.0 |
| 2015-09-14 | FGBM | Futures | 125.03 | 125.11 | 124.95 | 125.06 | 226569.0 |
| 2015-09-14 | FGBS | Futures | 111.238 | 111.263 | 111.228 | 111.253 | 82683.0 |
| 2015-09-14 | FGBX | Futures | 155.78 | 156.69 | 155.25 | 156.04 | 17798.0 |
| 2015-09-14 | FMWO | Futures | 5413.8 | 5416.3 | 5376.9 | 5376.9 | 955.0 |
| 2015-09-14 | FOAT | Futures | 126.19 | 126.39 | 126.0 | 126.2 | 35658.0 |
| 2015-09-14 | FTDX | Futures | 1633.4 | 1637.2 | 1631.5 | 1633.4 | 930.0 |
| 2015-09-14 | FTI | Futures | 374.99 | 377.99 | 370.69 | 371.6 | 17634.0 |
| 2015-09-14 | FTUK | Futures | 4927.5 | 4955.2 | 4851.9 | 4880.9 | 132674.0 |
| 2015-09-14 | FVSA | Futures | 2616.87 | 2681.59 | 2552.14 | 2607.62 | 12756.0 |
| 2015-09-14 | FXXP | Futures | 277.0 | 278.8 | 273.9 | 275.1 | 58345.0 |
| 2015-09-14 | G | Futures | 104.7 | 104.76 | 104.41 | 104.51 | 110633.0 |
| 2015-09-14 | GF | Futures | 346.009 | 346.852 | 343.257 | 345.876 | 4256.0 |
| 2015-09-14 | GSCI | Futures | 589.57 | 590.79 | 586.88 | 586.88 | 2425.0 |
| 2015-09-14 | HE | Futures | 92.165 | 92.678 | 90.73 | 91.379 | 16953.0 |
> showing 50 of 106 rows — these rows as CSV