PREVIEW / futures_daily / 2015-04-14
file: by_date/futures_daily/2015/2015-04-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-04-14 | ES | Futures | 2194.4 | 2200.45 | 2182.57 | 2198.61 | 1267366.0 |
| 2015-04-14 | NQ | Futures | 5114.93 | 5125.38 | 5069.94 | 5105.93 | 220750.0 |
| 2015-04-14 | YM | Futures | 18327.6 | 18408.4 | 18229.4 | 18374.6 | 145024.0 |
| 2015-04-14 | CL | Futures | 91.37 | 93.99 | 91.13 | 93.17 | 226502.0 |
| 2015-04-14 | GC | Futures | 1568.6 | 1571.9 | 1548.6 | 1560.5 | 161058.0 |
| 2015-04-14 | ZN | Futures | 122.278964 | 122.85617 | 122.234563 | 122.486166 | 1168721.0 |
| 2015-04-14 | A6 | Futures | 0.74569 | 0.75171 | 0.74244 | 0.75003 | 108134.0 |
| 2015-04-14 | AD | Futures | 0.80995 | 0.81986 | 0.80954 | 0.81689 | 60641.0 |
| 2015-04-14 | ALI | Futures | 2570.83 | 2570.83 | 2570.83 | 2570.83 | 3.0 |
| 2015-04-14 | B | Futures | 57.06 | 58.32 | 56.88 | 57.71 | 296470.0 |
| 2015-04-14 | B6 | Futures | 1.5434 | 1.5573 | 1.5366 | 1.555 | 109644.0 |
| 2015-04-14 | BFX | Futures | 4666.6 | 4697.0 | 4666.6 | 4669.6 | 17.0 |
| 2015-04-14 | BR | Futures | 0.18055 | 0.18363 | 0.18055 | 0.18349 | 59.0 |
| 2015-04-14 | BZ | Futures | 56.7 | 57.79 | 56.42 | 57.2 | 27469.0 |
| 2015-04-14 | C | Futures | 2131.0 | 2154.0 | 2127.0 | 2149.0 | 2741.0 |
| 2015-04-14 | CB | Futures | 147.548 | 148.074 | 147.548 | 147.669 | 3.0 |
| 2015-04-14 | CC | Futures | 2066.0 | 2105.0 | 2063.0 | 2100.0 | 24065.0 |
| 2015-04-14 | CNH | Futures | 7.0294 | 7.0294 | 7.025 | 7.0256 | 9.0 |
| 2015-04-14 | CSC | Futures | 4.276 | 4.29 | 4.263 | 4.268 | 70.0 |
| 2015-04-14 | CT | Futures | 83.48 | 83.84 | 82.58 | 82.92 | 17232.0 |
| 2015-04-14 | DC | Futures | 34.75 | 35.09 | 34.66 | 34.73 | 119.0 |
| 2015-04-14 | DX | Futures | 93.686 | 93.883 | 92.559 | 92.902 | 65992.0 |
| 2015-04-14 | E1 | Futures | 1.30563 | 1.32054 | 1.30385 | 1.31277 | 23427.0 |
| 2015-04-14 | E6 | Futures | 1.24354 | 1.26024 | 1.23931 | 1.25448 | 309968.0 |
| 2015-04-14 | E7 | Futures | 1.2364 | 1.2528 | 1.2323 | 1.2472 | 7691.0 |
| 2015-04-14 | EBM | Futures | 300.47 | 302.48 | 299.27 | 299.67 | 25294.0 |
| 2015-04-14 | ED | Futures | 95.5381 | 95.5477 | 95.5333 | 95.5429 | 132083.0 |
| 2015-04-14 | ER | Futures | 98.063 | 98.077 | 98.063 | 98.073 | 64291.0 |
| 2015-04-14 | EW | Futures | 1600.6 | 1605.4 | 1590.0 | 1603.4 | 15278.0 |
| 2015-04-14 | FBTP | Futures | 103.74 | 103.88 | 103.48 | 103.57 | 87911.0 |
| 2015-04-14 | FBTS | Futures | 99.661 | 99.697 | 99.617 | 99.643 | 18740.0 |
| 2015-04-14 | FCE | Futures | 4258.6 | 4278.0 | 4220.4 | 4243.0 | 135954.0 |
| 2015-04-14 | FDAX | Futures | 13701.8 | 13731.2 | 13550.4 | 13603.1 | 107239.0 |
| 2015-04-14 | FESX | Futures | 2759.5 | 2769.1 | 2726.4 | 2740.4 | 1116541.0 |
| 2015-04-14 | FGBL | Futures | 141.57 | 141.81 | 141.47 | 141.74 | 455024.0 |
| 2015-04-14 | FGBM | Futures | 124.99 | 125.06 | 124.96 | 125.01 | 304596.0 |
| 2015-04-14 | FGBS | Futures | 111.318 | 111.328 | 111.308 | 111.318 | 120577.0 |
| 2015-04-14 | FGBX | Futures | 177.9 | 178.81 | 177.59 | 178.67 | 19467.0 |
| 2015-04-14 | FMWO | Futures | 5837.2 | 5850.8 | 5827.3 | 5850.8 | 74.0 |
| 2015-04-14 | FOAT | Futures | 130.31 | 130.55 | 130.23 | 130.49 | 52587.0 |
| 2015-04-14 | FTDX | Futures | 1586.6 | 1595.5 | 1574.4 | 1577.6 | 134.0 |
| 2015-04-14 | FTI | Futures | 436.76 | 439.76 | 434.1 | 435.93 | 28370.0 |
| 2015-04-14 | FTUK | Futures | 5524.0 | 5548.1 | 5514.2 | 5536.2 | 94353.0 |
| 2015-04-14 | FVSA | Futures | 1566.96 | 1630.27 | 1566.96 | 1602.57 | 7768.0 |
| 2015-04-14 | FXXP | Futures | 313.8 | 314.3 | 311.1 | 312.1 | 11318.0 |
| 2015-04-14 | G | Futures | 105.01 | 105.72 | 104.93 | 105.6 | 140804.0 |
| 2015-04-14 | GF | Futures | 360.843 | 364.194 | 359.898 | 362.261 | 3544.0 |
| 2015-04-14 | GSCI | Futures | 701.66 | 715.27 | 701.66 | 711.7 | 1148.0 |
| 2015-04-14 | HE | Futures | 83.28 | 83.28 | 82.065 | 82.933 | 437.0 |
| 2015-04-14 | HG | Futures | 3.452 | 3.4635 | 3.3987 | 3.4304 | 69898.0 |
> showing 50 of 106 rows — these rows as CSV