PREVIEW / futures_daily / 2015-04-27
file: by_date/futures_daily/2015/2015-04-27.parquet size: 9 KB rows: 107
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-27 | ES | Futures | 2222.0 | 2228.84 | 2208.33 | 2213.07 | 1210483.0 |
| 2015-04-27 | NQ | Futures | 5262.96 | 5289.08 | 5235.39 | 5253.38 | 224600.0 |
| 2015-04-27 | YM | Futures | 18441.1 | 18525.0 | 18358.3 | 18401.2 | 126183.0 |
| 2015-04-27 | CL | Futures | 97.3 | 98.3 | 95.97 | 96.77 | 250558.0 |
| 2015-04-27 | GC | Futures | 1543.1 | 1578.9 | 1540.9 | 1574.4 | 207200.0 |
| 2015-04-27 | ZN | Futures | 122.589767 | 122.737769 | 122.308564 | 122.486166 | 697063.0 |
| 2015-04-27 | A6 | Futures | 0.76946 | 0.77429 | 0.76631 | 0.77222 | 79720.0 |
| 2015-04-27 | AD | Futures | 0.83762 | 0.84467 | 0.8367 | 0.84406 | 51228.0 |
| 2015-04-27 | ALI | Futures | 2542.31 | 2542.31 | 2542.31 | 2542.31 | 0.0 |
| 2015-04-27 | B | Futures | 62.99 | 63.1 | 62.04 | 62.43 | 108441.0 |
| 2015-04-27 | B6 | Futures | 1.5973 | 1.6059 | 1.5897 | 1.6018 | 77697.0 |
| 2015-04-27 | BFX | Futures | 4545.9 | 4613.0 | 4545.9 | 4613.0 | 2.0 |
| 2015-04-27 | BR | Futures | 0.1911 | 0.19481 | 0.1911 | 0.19364 | 7218.0 |
| 2015-04-27 | BZ | Futures | 62.44 | 62.45 | 61.48 | 61.83 | 12551.0 |
| 2015-04-27 | C | Futures | 2141.0 | 2167.0 | 2135.0 | 2163.0 | 2192.0 |
| 2015-04-27 | CB | Futures | 156.165 | 159.139 | 156.165 | 159.139 | 15.0 |
| 2015-04-27 | CC | Futures | 2130.0 | 2167.0 | 2117.0 | 2156.0 | 13337.0 |
| 2015-04-27 | CNH | Futures | 6.99 | 7.0204 | 6.99 | 7.0119 | 35.0 |
| 2015-04-27 | CSC | Futures | 4.65 | 4.666 | 4.604 | 4.612 | 41.0 |
| 2015-04-27 | CT | Futures | 83.62 | 85.03 | 82.99 | 83.43 | 22922.0 |
| 2015-04-27 | DC | Futures | 38.03 | 38.41 | 37.74 | 37.76 | 181.0 |
| 2015-04-27 | DX | Futures | 91.197 | 91.512 | 90.723 | 91.025 | 40079.0 |
| 2015-04-27 | E1 | Futures | 1.33775 | 1.34501 | 1.33214 | 1.33533 | 18486.0 |
| 2015-04-27 | E6 | Futures | 1.2787 | 1.28576 | 1.27306 | 1.28023 | 200968.0 |
| 2015-04-27 | E7 | Futures | 1.2717 | 1.2782 | 1.2657 | 1.2728 | 4758.0 |
| 2015-04-27 | EBM | Futures | 293.25 | 293.25 | 287.24 | 288.04 | 18412.0 |
| 2015-04-27 | ED | Futures | 95.5477 | 95.5525 | 95.5429 | 95.5477 | 79452.0 |
| 2015-04-27 | ER | Futures | 98.063 | 98.077 | 98.063 | 98.073 | 115808.0 |
| 2015-04-27 | EW | Futures | 1605.2 | 1611.5 | 1589.9 | 1593.2 | 18407.0 |
| 2015-04-27 | FBTP | Futures | 102.48 | 103.22 | 102.1 | 103.0 | 96301.0 |
| 2015-04-27 | FBTS | Futures | 99.661 | 99.741 | 99.626 | 99.706 | 16160.0 |
| 2015-04-27 | FCE | Futures | 4228.2 | 4305.5 | 4181.3 | 4291.1 | 130108.0 |
| 2015-04-27 | FDAX | Futures | 13161.5 | 13407.8 | 13045.6 | 13385.6 | 125378.0 |
| 2015-04-27 | FESX | Futures | 2692.5 | 2746.3 | 2664.5 | 2735.9 | 1137124.0 |
| 2015-04-27 | FEU3 | Futures | 98.705 | 98.715 | 98.705 | 98.715 | 1.0 |
| 2015-04-27 | FGBL | Futures | 141.61 | 141.75 | 141.29 | 141.43 | 392338.0 |
| 2015-04-27 | FGBM | Futures | 124.84 | 124.89 | 124.82 | 124.83 | 241051.0 |
| 2015-04-27 | FGBS | Futures | 111.283 | 111.308 | 111.283 | 111.293 | 148479.0 |
| 2015-04-27 | FGBX | Futures | 178.38 | 179.01 | 177.01 | 177.47 | 21105.0 |
| 2015-04-27 | FMWO | Futures | 5926.0 | 5969.1 | 5924.8 | 5965.4 | 171.0 |
| 2015-04-27 | FOAT | Futures | 130.4 | 130.52 | 130.22 | 130.31 | 37580.0 |
| 2015-04-27 | FTDX | Futures | 1553.2 | 1576.7 | 1542.4 | 1576.2 | 250.0 |
| 2015-04-27 | FTI | Futures | 435.76 | 441.85 | 431.66 | 440.68 | 34479.0 |
| 2015-04-27 | FTUK | Futures | 5545.7 | 5585.5 | 5505.5 | 5557.9 | 100659.0 |
| 2015-04-27 | FVSA | Futures | 1717.32 | 1760.85 | 1657.97 | 1657.97 | 13214.0 |
| 2015-04-27 | FXXP | Futures | 310.3 | 314.1 | 308.1 | 313.5 | 10145.0 |
| 2015-04-27 | G | Futures | 104.54 | 104.59 | 104.05 | 104.13 | 89942.0 |
| 2015-04-27 | GF | Futures | 360.671 | 365.741 | 360.671 | 363.292 | 2207.0 |
| 2015-04-27 | GSCI | Futures | 740.63 | 741.57 | 736.21 | 738.68 | 63.0 |
| 2015-04-27 | HE | Futures | 83.338 | 84.176 | 83.048 | 83.598 | 169.0 |
> showing 50 of 107 rows — these rows as CSV