PREVIEW / futures_daily / 2015-04-01
file: by_date/futures_daily/2015/2015-04-01.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-04-01 | ES | Futures | 2163.91 | 2166.8 | 2138.15 | 2158.65 | 1818878.0 |
| 2015-04-01 | NQ | Futures | 5017.69 | 5032.2 | 4944.84 | 5007.53 | 311506.0 |
| 2015-04-01 | YM | Futures | 18088.2 | 18133.2 | 17874.5 | 18017.7 | 217492.0 |
| 2015-04-01 | CL | Futures | 83.74 | 88.85 | 82.86 | 88.22 | 451104.0 |
| 2015-04-01 | GC | Futures | 1548.2 | 1581.6 | 1544.7 | 1580.9 | 151135.0 |
| 2015-04-01 | ZN | Futures | 122.101362 | 122.678568 | 121.95336 | 122.545367 | 1138578.0 |
| 2015-04-01 | A6 | Futures | 0.74757 | 0.75299 | 0.7449 | 0.74648 | 116148.0 |
| 2015-04-01 | AD | Futures | 0.80454 | 0.81118 | 0.8026 | 0.80832 | 59634.0 |
| 2015-04-01 | ALI | Futures | 2614.86 | 2614.86 | 2614.86 | 2614.86 | 0.0 |
| 2015-04-01 | B | Futures | 54.21 | 56.66 | 53.8 | 56.15 | 203788.0 |
| 2015-04-01 | B6 | Futures | 1.5594 | 1.5646 | 1.5506 | 1.5599 | 93950.0 |
| 2015-04-01 | BFX | Futures | 4510.3 | 4533.9 | 4499.5 | 4518.8 | 707.0 |
| 2015-04-01 | BR | Futures | 0.1781 | 0.1781 | 0.17593 | 0.17641 | 22.0 |
| 2015-04-01 | BZ | Futures | 53.63 | 56.12 | 53.38 | 55.65 | 25716.0 |
| 2015-04-01 | C | Futures | 2074.0 | 2109.0 | 2073.0 | 2098.0 | 6445.0 |
| 2015-04-01 | CB | Futures | 148.802 | 148.802 | 146.941 | 147.265 | 9.0 |
| 2015-04-01 | CC | Futures | 1984.0 | 2036.0 | 1984.0 | 2029.0 | 26605.0 |
| 2015-04-01 | CSC | Futures | 4.436 | 4.436 | 4.292 | 4.335 | 141.0 |
| 2015-04-01 | CT | Futures | 80.69 | 81.08 | 80.03 | 80.21 | 10684.0 |
| 2015-04-01 | DC | Futures | 36.12 | 36.12 | 34.8 | 35.18 | 324.0 |
| 2015-04-01 | DX | Futures | 92.705 | 92.935 | 92.259 | 92.465 | 48579.0 |
| 2015-04-01 | E1 | Futures | 1.31443 | 1.32513 | 1.31175 | 1.32258 | 19120.0 |
| 2015-04-01 | E6 | Futures | 1.26436 | 1.2713 | 1.26165 | 1.26706 | 237236.0 |
| 2015-04-01 | E7 | Futures | 1.2568 | 1.2639 | 1.2542 | 1.2597 | 5407.0 |
| 2015-04-01 | EBM | Futures | 302.08 | 306.89 | 300.88 | 306.09 | 19680.0 |
| 2015-04-01 | ED | Futures | 95.5237 | 95.5285 | 95.5189 | 95.5237 | 125350.0 |
| 2015-04-01 | ER | Futures | 98.058 | 98.058 | 98.048 | 98.053 | 32867.0 |
| 2015-04-01 | EW | Futures | 1592.9 | 1594.5 | 1573.5 | 1587.9 | 19775.0 |
| 2015-04-01 | FBTP | Futures | 103.73 | 104.1 | 103.53 | 103.85 | 94074.0 |
| 2015-04-01 | FBTS | Futures | 99.608 | 99.688 | 99.599 | 99.635 | 24454.0 |
| 2015-04-01 | FCE | Futures | 4076.1 | 4157.4 | 4070.0 | 4116.4 | 117035.0 |
| 2015-04-01 | FDAX | Futures | 13204.8 | 13477.2 | 13169.3 | 13352.4 | 121438.0 |
| 2015-04-01 | FDIV | Futures | 166.67 | 166.67 | 166.58 | 166.62 | 84.0 |
| 2015-04-01 | FESX | Futures | 2657.8 | 2710.9 | 2653.4 | 2685.8 | 1117006.0 |
| 2015-04-01 | FGBL | Futures | 141.01 | 141.45 | 140.87 | 141.21 | 572243.0 |
| 2015-04-01 | FGBM | Futures | 124.82 | 124.88 | 124.71 | 124.82 | 447329.0 |
| 2015-04-01 | FGBS | Futures | 111.248 | 111.278 | 111.233 | 111.263 | 199921.0 |
| 2015-04-01 | FGBX | Futures | 178.18 | 178.81 | 177.23 | 178.16 | 37469.0 |
| 2015-04-01 | FMWO | Futures | 5721.3 | 5733.6 | 5717.6 | 5725.0 | 188.0 |
| 2015-04-01 | FOAT | Futures | 129.64 | 130.13 | 129.46 | 129.94 | 101455.0 |
| 2015-04-01 | FTDX | Futures | 1508.2 | 1525.1 | 1496.9 | 1516.2 | 149.0 |
| 2015-04-01 | FTI | Futures | 421.46 | 427.78 | 419.86 | 423.76 | 32095.0 |
| 2015-04-01 | FTUK | Futures | 5269.8 | 5359.7 | 5268.2 | 5320.6 | 125824.0 |
| 2015-04-01 | FVSA | Futures | 1863.41 | 1863.41 | 1808.36 | 1829.53 | 12809.0 |
| 2015-04-01 | FXXP | Futures | 299.0 | 303.6 | 298.3 | 301.5 | 16276.0 |
| 2015-04-01 | G | Futures | 105.0 | 105.4 | 104.6 | 105.31 | 161648.0 |
| 2015-04-01 | GF | Futures | 370.171 | 372.503 | 368.814 | 370.892 | 1354.0 |
| 2015-04-01 | GSCI | Futures | 684.91 | 704.03 | 683.61 | 699.46 | 791.0 |
| 2015-04-01 | HE | Futures | 79.231 | 80.186 | 79.231 | 80.041 | 272.0 |
| 2015-04-01 | HG | Futures | 3.4825 | 3.5086 | 3.4425 | 3.4921 | 50004.0 |
> showing 50 of 106 rows — these rows as CSV