PREVIEW / futures_daily / 2015-07-08
file: by_date/futures_daily/2015/2015-07-08.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-08 | ES | Futures | 2197.0 | 2197.27 | 2158.05 | 2161.23 | 2393226.0 |
| 2015-07-08 | NQ | Futures | 5163.35 | 5163.35 | 5062.95 | 5074.62 | 335132.0 |
| 2015-07-08 | YM | Futures | 18154.7 | 18155.7 | 17874.3 | 17913.3 | 253841.0 |
| 2015-07-08 | CL | Futures | 88.37 | 88.45 | 85.03 | 86.27 | 434752.0 |
| 2015-07-08 | GC | Futures | 1507.1 | 1519.9 | 1496.5 | 1519.5 | 168006.0 |
| 2015-07-08 | ZN | Futures | 121.033065 | 121.703732 | 121.003257 | 121.49508 | 1475469.0 |
| 2015-07-08 | A6 | Futures | 0.73475 | 0.73604 | 0.72752 | 0.73227 | 108564.0 |
| 2015-07-08 | AD | Futures | 0.80348 | 0.80502 | 0.80011 | 0.80175 | 78041.0 |
| 2015-07-08 | ALI | Futures | 2276.06 | 2276.06 | 2276.06 | 2276.06 | 0.0 |
| 2015-07-08 | B | Futures | 53.74 | 54.11 | 52.44 | 53.4 | 264126.0 |
| 2015-07-08 | B6 | Futures | 1.6258 | 1.6272 | 1.6128 | 1.6153 | 85885.0 |
| 2015-07-08 | BFX | Futures | 4235.8 | 4250.4 | 4235.8 | 4237.1 | 3.0 |
| 2015-07-08 | BR | Futures | 0.18396 | 0.18414 | 0.18159 | 0.18195 | 331.0 |
| 2015-07-08 | BZ | Futures | 53.73 | 54.08 | 52.41 | 53.37 | 27948.0 |
| 2015-07-08 | C | Futures | 2323.0 | 2337.0 | 2323.0 | 2335.0 | 2410.0 |
| 2015-07-08 | CC | Futures | 2382.0 | 2392.0 | 2380.0 | 2388.0 | 9029.0 |
| 2015-07-08 | CNH | Futures | 7.0237 | 7.0322 | 7.0223 | 7.0249 | 85.0 |
| 2015-07-08 | CSC | Futures | 4.376 | 4.389 | 4.376 | 4.376 | 38.0 |
| 2015-07-08 | CT | Futures | 80.83 | 81.11 | 79.31 | 80.12 | 34.0 |
| 2015-07-08 | DC | Futures | 35.13 | 35.19 | 35.02 | 35.13 | 68.0 |
| 2015-07-08 | DX | Futures | 90.712 | 90.885 | 90.056 | 90.306 | 39484.0 |
| 2015-07-08 | E1 | Futures | 1.34421 | 1.3531 | 1.33849 | 1.34599 | 18647.0 |
| 2015-07-08 | E6 | Futures | 1.2932 | 1.30448 | 1.2905 | 1.3006 | 215436.0 |
| 2015-07-08 | E7 | Futures | 1.2864 | 1.2972 | 1.2834 | 1.2934 | 4805.0 |
| 2015-07-08 | EBM | Futures | 324.22 | 326.27 | 320.53 | 321.35 | 17613.0 |
| 2015-07-08 | ED | Futures | 95.651 | 95.675 | 95.651 | 95.675 | 226004.0 |
| 2015-07-08 | ER | Futures | 98.077 | 98.087 | 98.073 | 98.087 | 36191.0 |
| 2015-07-08 | EW | Futures | 1572.8 | 1572.8 | 1546.5 | 1552.6 | 25122.0 |
| 2015-07-08 | FBTP | Futures | 96.96 | 97.75 | 96.78 | 97.47 | 74438.0 |
| 2015-07-08 | FBTS | Futures | 99.296 | 99.385 | 99.225 | 99.323 | 14894.0 |
| 2015-07-08 | FCE | Futures | 3859.9 | 3893.2 | 3833.2 | 3865.3 | 120405.0 |
| 2015-07-08 | FDAX | Futures | 11896.4 | 11946.1 | 11773.7 | 11885.3 | 114636.0 |
| 2015-07-08 | FESX | Futures | 2451.9 | 2474.1 | 2427.4 | 2457.8 | 1482969.0 |
| 2015-07-08 | FGBL | Futures | 136.91 | 137.61 | 136.59 | 136.7 | 709613.0 |
| 2015-07-08 | FGBM | Futures | 124.48 | 124.59 | 124.34 | 124.37 | 597024.0 |
| 2015-07-08 | FGBS | Futures | 111.278 | 111.298 | 111.263 | 111.263 | 231558.0 |
| 2015-07-08 | FGBX | Futures | 154.71 | 157.57 | 154.71 | 155.5 | 43200.0 |
| 2015-07-08 | FMWO | Futures | 5657.5 | 5666.1 | 5642.7 | 5653.8 | 728.0 |
| 2015-07-08 | FOAT | Futures | 123.95 | 124.3 | 123.81 | 123.95 | 68954.0 |
| 2015-07-08 | FTDX | Futures | 1526.9 | 1531.2 | 1514.7 | 1521.3 | 188.0 |
| 2015-07-08 | FTI | Futures | 402.36 | 403.45 | 397.16 | 400.96 | 43454.0 |
| 2015-07-08 | FTUK | Futures | 5094.9 | 5137.5 | 5071.9 | 5114.4 | 108196.0 |
| 2015-07-08 | FVSA | Futures | 2116.93 | 2221.57 | 2116.93 | 2169.25 | 9668.0 |
| 2015-07-08 | FXXP | Futures | 286.3 | 287.3 | 283.9 | 285.2 | 14061.0 |
| 2015-07-08 | G | Futures | 103.22 | 103.45 | 102.29 | 102.45 | 200377.0 |
| 2015-07-08 | GF | Futures | 369.282 | 370.217 | 362.439 | 363.204 | 7514.0 |
| 2015-07-08 | GSCI | Futures | 685.14 | 689.81 | 677.89 | 681.89 | 2329.0 |
| 2015-07-08 | HE | Futures | 85.425 | 85.676 | 82.995 | 84.671 | 29239.0 |
| 2015-07-08 | HG | Futures | 3.0744 | 3.1468 | 2.9715 | 3.1162 | 113766.0 |
| 2015-07-08 | HH | Futures | 32.734 | 33.315 | 32.395 | 32.492 | 1233.0 |
> showing 50 of 105 rows — these rows as CSV