PREVIEW / futures_daily / 2015-02-27
file: by_date/futures_daily/2015/2015-02-27.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-02-27 | ES | Futures | 2211.03 | 2212.6 | 2201.86 | 2203.95 | 1207187.0 |
| 2015-02-27 | NQ | Futures | 5175.48 | 5178.09 | 5145.89 | 5154.59 | 173304.0 |
| 2015-02-27 | YM | Futures | 18539.3 | 18539.3 | 18451.7 | 18461.9 | 82630.0 |
| 2015-02-27 | CL | Futures | 90.61 | 92.4 | 89.67 | 92.07 | 399494.0 |
| 2015-02-27 | GC | Futures | 1580.5 | 1594.1 | 1574.4 | 1586.1 | 113768.0 |
| 2015-02-27 | ZN | Futures | 120.821094 | 121.056642 | 120.61499 | 120.997755 | 354793.0 |
| 2015-02-27 | A6 | Futures | 0.7632 | 0.76682 | 0.76124 | 0.76447 | 77067.0 |
| 2015-02-27 | AD | Futures | 0.81341 | 0.8181 | 0.8127 | 0.81361 | 53420.0 |
| 2015-02-27 | ALI | Futures | 2676.49 | 2676.49 | 2676.49 | 2676.49 | 0.0 |
| 2015-02-27 | B | Futures | 60.36 | 62.39 | 60.27 | 62.15 | 145228.0 |
| 2015-02-27 | B6 | Futures | 1.6201 | 1.6254 | 1.6174 | 1.6231 | 85598.0 |
| 2015-02-27 | BFX | Futures | 4465.7 | 4483.2 | 4443.3 | 4483.2 | 124.0 |
| 2015-02-27 | BR | Futures | 0.19045 | 0.19492 | 0.19045 | 0.1943 | 124.0 |
| 2015-02-27 | BZ | Futures | 60.44 | 61.82 | 59.78 | 61.6 | 24566.0 |
| 2015-02-27 | C | Futures | 2209.0 | 2225.0 | 2202.0 | 2221.0 | 7773.0 |
| 2015-02-27 | CB | Futures | 147.062 | 147.062 | 147.062 | 147.062 | 2.0 |
| 2015-02-27 | CC | Futures | 2205.0 | 2229.0 | 2198.0 | 2227.0 | 15393.0 |
| 2015-02-27 | CNH | Futures | 7.1525 | 7.1582 | 7.1495 | 7.1495 | 58.0 |
| 2015-02-27 | CSC | Futures | 4.572 | 4.692 | 4.572 | 4.634 | 39.0 |
| 2015-02-27 | CT | Futures | 83.4 | 83.94 | 81.49 | 83.22 | 15978.0 |
| 2015-02-27 | DC | Futures | 37.13 | 38.55 | 37.13 | 38.03 | 192.0 |
| 2015-02-27 | DX | Futures | 90.142 | 90.341 | 89.787 | 90.228 | 33726.0 |
| 2015-02-27 | E1 | Futures | 1.34115 | 1.35213 | 1.33783 | 1.33808 | 22670.0 |
| 2015-02-27 | E6 | Futures | 1.3174 | 1.32317 | 1.3147 | 1.31682 | 220392.0 |
| 2015-02-27 | E7 | Futures | 1.3093 | 1.3153 | 1.3069 | 1.309 | 4233.0 |
| 2015-02-27 | EBM | Futures | 302.51 | 304.95 | 300.89 | 304.14 | 9251.0 |
| 2015-02-27 | ED | Futures | 95.457 | 95.4594 | 95.457 | 95.4594 | 99800.0 |
| 2015-02-27 | ER | Futures | 98.063 | 98.073 | 98.063 | 98.068 | 41941.0 |
| 2015-02-27 | EW | Futures | 1579.5 | 1581.8 | 1572.5 | 1573.4 | 13524.0 |
| 2015-02-27 | FBTP | Futures | 102.67 | 103.14 | 102.67 | 102.88 | 120031.0 |
| 2015-02-27 | FBTS | Futures | 99.563 | 99.634 | 99.555 | 99.59 | 24218.0 |
| 2015-02-27 | FCE | Futures | 3985.4 | 4028.1 | 3982.6 | 4026.5 | 87173.0 |
| 2015-02-27 | FDAX | Futures | 12565.7 | 12658.9 | 12549.0 | 12639.0 | 91050.0 |
| 2015-02-27 | FESX | Futures | 2570.1 | 2594.6 | 2568.0 | 2587.4 | 1033400.0 |
| 2015-02-27 | FGBL | Futures | 139.91 | 139.91 | 139.41 | 139.62 | 844131.0 |
| 2015-02-27 | FGBM | Futures | 124.81 | 124.82 | 124.67 | 124.72 | 407618.0 |
| 2015-02-27 | FGBS | Futures | 111.233 | 111.243 | 111.208 | 111.223 | 180784.0 |
| 2015-02-27 | FGBX | Futures | 168.24 | 168.24 | 166.06 | 167.12 | 33988.0 |
| 2015-02-27 | FMWO | Futures | 5841.3 | 5862.3 | 5841.3 | 5852.4 | 39.0 |
| 2015-02-27 | FOAT | Futures | 128.5 | 128.55 | 128.27 | 128.38 | 81385.0 |
| 2015-02-27 | FTDX | Futures | 1483.8 | 1485.2 | 1477.7 | 1485.2 | 92.0 |
| 2015-02-27 | FTI | Futures | 416.11 | 418.18 | 414.38 | 417.75 | 22802.0 |
| 2015-02-27 | FTUK | Futures | 5392.3 | 5409.4 | 5373.2 | 5394.6 | 110376.0 |
| 2015-02-27 | FVSA | Futures | 1691.98 | 1736.74 | 1691.98 | 1691.98 | 12087.0 |
| 2015-02-27 | FXXP | Futures | 295.4 | 296.3 | 294.2 | 296.0 | 11447.0 |
| 2015-02-27 | G | Futures | 103.63 | 103.65 | 103.05 | 103.23 | 200027.0 |
| 2015-02-27 | GF | Futures | 338.448 | 342.623 | 336.424 | 340.599 | 3772.0 |
| 2015-02-27 | GSCI | Futures | 715.97 | 725.25 | 715.97 | 720.78 | 321.0 |
| 2015-02-27 | HE | Futures | 89.348 | 91.427 | 88.811 | 90.522 | 20985.0 |
| 2015-02-27 | HG | Futures | 3.4279 | 3.4304 | 3.3796 | 3.4196 | 40255.0 |
> showing 50 of 106 rows — these rows as CSV