PREVIEW / futures_daily / 2015-07-14
file: by_date/futures_daily/2015/2015-07-14.parquet size: 9 KB rows: 105
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-07-14 | ES | Futures | 2219.26 | 2231.45 | 2215.55 | 2227.74 | 955518.0 |
| 2015-07-14 | NQ | Futures | 5238.95 | 5288.57 | 5235.74 | 5274.27 | 156246.0 |
| 2015-07-14 | YM | Futures | 18375.5 | 18472.0 | 18347.7 | 18446.3 | 86991.0 |
| 2015-07-14 | CL | Futures | 87.19 | 89.43 | 85.36 | 88.8 | 205986.0 |
| 2015-07-14 | GC | Futures | 1511.0 | 1513.8 | 1504.2 | 1506.5 | 109142.0 |
| 2015-07-14 | ZN | Futures | 119.676827 | 120.213361 | 119.632116 | 120.123938 | 928621.0 |
| 2015-07-14 | A6 | Futures | 0.73049 | 0.73821 | 0.7293 | 0.73524 | 67873.0 |
| 2015-07-14 | AD | Futures | 0.80185 | 0.80348 | 0.79776 | 0.80154 | 57933.0 |
| 2015-07-14 | ALI | Futures | 2309.46 | 2309.46 | 2309.46 | 2309.46 | 0.0 |
| 2015-07-14 | B | Futures | 54.02 | 54.88 | 52.81 | 54.6 | 330179.0 |
| 2015-07-14 | B6 | Futures | 1.6293 | 1.6457 | 1.6254 | 1.6445 | 96147.0 |
| 2015-07-14 | BFX | Futures | 4512.8 | 4540.6 | 4512.8 | 4540.6 | 19.0 |
| 2015-07-14 | BR | Futures | 0.18821 | 0.18884 | 0.1877 | 0.18818 | 1342.0 |
| 2015-07-14 | BZ | Futures | 53.85 | 54.82 | 52.78 | 54.57 | 37978.0 |
| 2015-07-14 | C | Futures | 2369.0 | 2399.0 | 2362.0 | 2394.0 | 14154.0 |
| 2015-07-14 | CB | Futures | 156.826 | 156.826 | 154.05 | 154.597 | 41.0 |
| 2015-07-14 | CC | Futures | 2433.0 | 2483.0 | 2423.0 | 2478.0 | 16120.0 |
| 2015-07-14 | CSC | Futures | 4.343 | 4.384 | 4.338 | 4.366 | 20.0 |
| 2015-07-14 | CT | Futures | 80.17 | 80.97 | 80.15 | 80.97 | 61.0 |
| 2015-07-14 | DC | Futures | 34.98 | 35.24 | 34.81 | 35.17 | 70.0 |
| 2015-07-14 | DX | Futures | 90.89 | 91.007 | 90.145 | 90.598 | 29547.0 |
| 2015-07-14 | E1 | Futures | 1.33913 | 1.35424 | 1.33481 | 1.34637 | 17139.0 |
| 2015-07-14 | E6 | Futures | 1.29402 | 1.30366 | 1.28921 | 1.29438 | 192394.0 |
| 2015-07-14 | E7 | Futures | 1.2865 | 1.2963 | 1.2821 | 1.2872 | 3601.0 |
| 2015-07-14 | EBM | Futures | 319.3 | 320.53 | 313.97 | 315.61 | 8914.0 |
| 2015-07-14 | ED | Futures | 95.6318 | 95.6558 | 95.627 | 95.651 | 156218.0 |
| 2015-07-14 | ER | Futures | 98.107 | 98.112 | 98.102 | 98.112 | 25930.0 |
| 2015-07-14 | EW | Futures | 1585.5 | 1594.9 | 1583.3 | 1593.4 | 13669.0 |
| 2015-07-14 | FBTP | Futures | 98.45 | 98.85 | 98.2 | 98.77 | 49076.0 |
| 2015-07-14 | FBTS | Futures | 99.75 | 99.777 | 99.697 | 99.75 | 12843.0 |
| 2015-07-14 | FCE | Futures | 4160.8 | 4207.9 | 4154.1 | 4196.6 | 83654.0 |
| 2015-07-14 | FDAX | Futures | 12728.8 | 12767.0 | 12619.9 | 12725.5 | 69794.0 |
| 2015-07-14 | FESX | Futures | 2665.0 | 2677.6 | 2641.3 | 2666.5 | 848887.0 |
| 2015-07-14 | FGBL | Futures | 134.81 | 135.39 | 134.67 | 135.06 | 481850.0 |
| 2015-07-14 | FGBM | Futures | 123.92 | 124.05 | 123.85 | 123.97 | 342004.0 |
| 2015-07-14 | FGBS | Futures | 111.203 | 111.218 | 111.188 | 111.198 | 160929.0 |
| 2015-07-14 | FGBX | Futures | 148.68 | 150.93 | 148.17 | 149.55 | 27344.0 |
| 2015-07-14 | FMWO | Futures | 5828.6 | 5854.4 | 5828.6 | 5854.4 | 29.0 |
| 2015-07-14 | FOAT | Futures | 122.89 | 123.37 | 122.79 | 123.2 | 50461.0 |
| 2015-07-14 | FTDX | Futures | 1642.3 | 1644.2 | 1632.9 | 1641.9 | 230.0 |
| 2015-07-14 | FTI | Futures | 420.94 | 424.48 | 419.73 | 423.86 | 19587.0 |
| 2015-07-14 | FTUK | Futures | 5310.7 | 5330.6 | 5291.7 | 5322.7 | 64007.0 |
| 2015-07-14 | FVSA | Futures | 1877.36 | 1881.74 | 1837.88 | 1868.58 | 4086.0 |
| 2015-07-14 | FXXP | Futures | 304.2 | 305.9 | 302.7 | 305.4 | 13827.0 |
| 2015-07-14 | G | Futures | 100.91 | 101.02 | 100.31 | 100.62 | 143377.0 |
| 2015-07-14 | GF | Futures | 360.441 | 366.264 | 360.143 | 364.351 | 6926.0 |
| 2015-07-14 | GSCI | Futures | 684.23 | 693.56 | 682.82 | 691.4 | 2049.0 |
| 2015-07-14 | HE | Futures | 82.968 | 85.872 | 82.856 | 84.811 | 25935.0 |
| 2015-07-14 | HG | Futures | 3.1699 | 3.1793 | 3.1312 | 3.1637 | 38289.0 |
| 2015-07-14 | HH | Futures | 34.731 | 35.409 | 34.162 | 34.368 | 2817.0 |
> showing 50 of 105 rows — these rows as CSV