PREVIEW / futures_daily / 2015-04-22
file: by_date/futures_daily/2015/2015-04-22.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-04-22 | ES | Futures | 2199.66 | 2212.01 | 2187.3 | 2208.33 | 1188586.0 |
| 2015-04-22 | NQ | Futures | 5146.86 | 5177.62 | 5106.8 | 5161.08 | 196846.0 |
| 2015-04-22 | YM | Futures | 18302.0 | 18386.9 | 18180.3 | 18355.2 | 146386.0 |
| 2015-04-22 | CL | Futures | 95.67 | 97.11 | 94.63 | 95.36 | 329631.0 |
| 2015-04-22 | GC | Futures | 1573.1 | 1575.9 | 1550.6 | 1553.0 | 152182.0 |
| 2015-04-22 | ZN | Futures | 122.574967 | 122.693368 | 121.908959 | 122.056961 | 1175589.0 |
| 2015-04-22 | A6 | Futures | 0.75822 | 0.76759 | 0.75763 | 0.76414 | 76918.0 |
| 2015-04-22 | AD | Futures | 0.83099 | 0.83609 | 0.83037 | 0.83405 | 46676.0 |
| 2015-04-22 | ALI | Futures | 2520.13 | 2520.13 | 2520.13 | 2520.13 | 0.0 |
| 2015-04-22 | B | Futures | 59.72 | 61.1 | 59.23 | 60.53 | 230058.0 |
| 2015-04-22 | B6 | Futures | 1.5702 | 1.5867 | 1.5692 | 1.5831 | 88657.0 |
| 2015-04-22 | BFX | Futures | 4597.1 | 4611.7 | 4536.2 | 4552.0 | 39.0 |
| 2015-04-22 | BR | Futures | 0.18608 | 0.18816 | 0.18608 | 0.18725 | 172.0 |
| 2015-04-22 | BZ | Futures | 59.22 | 60.55 | 58.72 | 60.0 | 19144.0 |
| 2015-04-22 | C | Futures | 2084.0 | 2100.0 | 2066.0 | 2076.0 | 10730.0 |
| 2015-04-22 | CB | Futures | 154.162 | 154.162 | 154.142 | 154.142 | 1.0 |
| 2015-04-22 | CC | Futures | 2051.0 | 2087.0 | 2043.0 | 2052.0 | 13574.0 |
| 2015-04-22 | CNH | Futures | 6.9924 | 6.9933 | 6.9886 | 6.9919 | 23.0 |
| 2015-04-22 | CSC | Futures | 4.572 | 4.572 | 4.503 | 4.503 | 16.0 |
| 2015-04-22 | CT | Futures | 80.51 | 81.06 | 79.72 | 80.1 | 2178.0 |
| 2015-04-22 | DC | Futures | 37.07 | 37.56 | 36.91 | 36.91 | 353.0 |
| 2015-04-22 | DX | Futures | 92.188 | 92.348 | 91.658 | 92.149 | 34953.0 |
| 2015-04-22 | E1 | Futures | 1.33596 | 1.34412 | 1.31404 | 1.31697 | 31839.0 |
| 2015-04-22 | E6 | Futures | 1.26342 | 1.27106 | 1.26013 | 1.26377 | 219904.0 |
| 2015-04-22 | E7 | Futures | 1.256 | 1.2636 | 1.2528 | 1.2565 | 4617.0 |
| 2015-04-22 | EBM | Futures | 292.85 | 294.46 | 290.85 | 294.46 | 11500.0 |
| 2015-04-22 | ED | Futures | 95.5525 | 95.5525 | 95.5381 | 95.5477 | 86069.0 |
| 2015-04-22 | ER | Futures | 98.073 | 98.073 | 98.063 | 98.068 | 29038.0 |
| 2015-04-22 | EW | Futures | 1601.2 | 1605.2 | 1587.1 | 1604.8 | 13783.0 |
| 2015-04-22 | FBTP | Futures | 102.3 | 102.83 | 102.18 | 102.67 | 104950.0 |
| 2015-04-22 | FBTS | Futures | 99.617 | 99.697 | 99.599 | 99.67 | 21815.0 |
| 2015-04-22 | FCE | Futures | 4237.7 | 4255.3 | 4187.9 | 4242.6 | 97525.0 |
| 2015-04-22 | FDAX | Futures | 13327.9 | 13397.3 | 13109.4 | 13210.9 | 125476.0 |
| 2015-04-22 | FDIV | Futures | 162.41 | 163.25 | 162.41 | 163.25 | 2.0 |
| 2015-04-22 | FESX | Futures | 2701.3 | 2717.5 | 2668.2 | 2698.4 | 968991.0 |
| 2015-04-22 | FEU3 | Futures | 98.71 | 98.71 | 98.71 | 98.71 | 50.0 |
| 2015-04-22 | FGBL | Futures | 142.13 | 142.31 | 141.36 | 141.43 | 716871.0 |
| 2015-04-22 | FGBM | Futures | 124.98 | 125.07 | 124.75 | 124.76 | 460924.0 |
| 2015-04-22 | FGBS | Futures | 111.283 | 111.308 | 111.263 | 111.273 | 174947.0 |
| 2015-04-22 | FGBX | Futures | 181.01 | 181.55 | 178.32 | 178.81 | 33466.0 |
| 2015-04-22 | FMWO | Futures | 5873.0 | 5886.5 | 5856.9 | 5881.6 | 306.0 |
| 2015-04-22 | FOAT | Futures | 130.79 | 131.09 | 130.29 | 130.38 | 84583.0 |
| 2015-04-22 | FTDX | Futures | 1574.4 | 1578.6 | 1554.2 | 1564.5 | 505.0 |
| 2015-04-22 | FTI | Futures | 434.97 | 438.8 | 433.14 | 436.24 | 31117.0 |
| 2015-04-22 | FTUK | Futures | 5534.7 | 5552.0 | 5476.7 | 5505.1 | 95774.0 |
| 2015-04-22 | FVSA | Futures | 1713.37 | 1784.59 | 1693.58 | 1752.94 | 14738.0 |
| 2015-04-22 | FXXP | Futures | 311.4 | 312.5 | 308.1 | 310.4 | 10978.0 |
| 2015-04-22 | G | Futures | 105.21 | 105.22 | 103.77 | 104.06 | 215834.0 |
| 2015-04-22 | GF | Futures | 355.945 | 357.578 | 352.508 | 355.301 | 3327.0 |
| 2015-04-22 | GSCI | Futures | 726.59 | 729.74 | 723.36 | 726.76 | 30.0 |
> showing 50 of 108 rows — these rows as CSV