PREVIEW / futures_daily / 2015-06-04
file: by_date/futures_daily/2015/2015-06-04.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-06-04 | ES | Futures | 2225.16 | 2225.42 | 2198.87 | 2207.02 | 1717287.0 |
| 2015-06-04 | NQ | Futures | 5255.7 | 5256.28 | 5193.59 | 5220.58 | 285057.0 |
| 2015-06-04 | YM | Futures | 18515.8 | 18515.8 | 18270.3 | 18334.8 | 222296.0 |
| 2015-06-04 | CL | Futures | 100.11 | 100.73 | 97.18 | 97.47 | 363345.0 |
| 2015-06-04 | GC | Futures | 1548.6 | 1549.7 | 1531.1 | 1534.8 | 155463.0 |
| 2015-06-04 | ZN | Futures | 119.614934 | 120.11814 | 119.141329 | 120.014538 | 66131.0 |
| 2015-06-04 | A6 | Futures | 0.7667 | 0.767 | 0.75556 | 0.75753 | 92534.0 |
| 2015-06-04 | AD | Futures | 0.81965 | 0.82077 | 0.81638 | 0.817 | 60645.0 |
| 2015-06-04 | ALI | Futures | 2362.61 | 2362.61 | 2362.61 | 2362.61 | 5.0 |
| 2015-06-04 | B | Futures | 60.74 | 60.91 | 58.78 | 58.98 | 175573.0 |
| 2015-06-04 | B6 | Futures | 1.6138 | 1.6253 | 1.6109 | 1.6176 | 87722.0 |
| 2015-06-04 | BFX | Futures | 4475.9 | 4475.9 | 4454.8 | 4465.7 | 8.0 |
| 2015-06-04 | BR | Futures | 0.18258 | 0.18279 | 0.18258 | 0.18279 | 1.0 |
| 2015-06-04 | BZ | Futures | 60.92 | 60.98 | 58.91 | 59.1 | 12427.0 |
| 2015-06-04 | C | Futures | 2287.0 | 2288.0 | 2265.0 | 2272.0 | 7513.0 |
| 2015-06-04 | CB | Futures | 163.107 | 163.107 | 162.499 | 162.905 | 10.0 |
| 2015-06-04 | CC | Futures | 2305.0 | 2310.0 | 2280.0 | 2291.0 | 15204.0 |
| 2015-06-04 | CNH | Futures | 6.9727 | 6.9773 | 6.9727 | 6.9745 | 8.0 |
| 2015-06-04 | CSC | Futures | 4.559 | 4.584 | 4.521 | 4.559 | 48.0 |
| 2015-06-04 | CT | Futures | 82.44 | 83.08 | 81.81 | 82.03 | 18239.0 |
| 2015-06-04 | DC | Futures | 37.19 | 37.19 | 36.63 | 37.04 | 113.0 |
| 2015-06-04 | DX | Futures | 89.606 | 89.789 | 88.892 | 89.665 | 62375.0 |
| 2015-06-04 | E1 | Futures | 1.36476 | 1.37394 | 1.3603 | 1.36642 | 23524.0 |
| 2015-06-04 | E6 | Futures | 1.32539 | 1.33844 | 1.31974 | 1.32245 | 373181.0 |
| 2015-06-04 | E7 | Futures | 1.3178 | 1.3306 | 1.3122 | 1.3148 | 8133.0 |
| 2015-06-04 | EBM | Futures | 295.53 | 301.27 | 292.66 | 300.86 | 7863.0 |
| 2015-06-04 | ED | Futures | 95.5597 | 95.5669 | 95.5597 | 95.5621 | 129533.0 |
| 2015-06-04 | ER | Futures | 98.082 | 98.082 | 98.077 | 98.082 | 41641.0 |
| 2015-06-04 | EW | Futures | 1611.1 | 1611.1 | 1592.4 | 1597.5 | 15701.0 |
| 2015-06-04 | FBTP | Futures | 97.35 | 97.86 | 96.52 | 97.59 | 161150.0 |
| 2015-06-04 | FBTS | Futures | 99.688 | 99.768 | 99.688 | 99.75 | 41443.0 |
| 2015-06-04 | FCE | Futures | 4149.8 | 4179.3 | 4070.5 | 4131.1 | 155348.0 |
| 2015-06-04 | FDAX | Futures | 12613.5 | 12707.2 | 12410.4 | 12606.2 | 126258.0 |
| 2015-06-04 | FESX | Futures | 2624.7 | 2646.8 | 2581.2 | 2621.0 | 1334769.0 |
| 2015-06-04 | FGBL | Futures | 133.89 | 134.95 | 132.91 | 134.63 | 1309193.0 |
| 2015-06-04 | FGBM | Futures | 123.31 | 123.62 | 122.98 | 123.52 | 984639.0 |
| 2015-06-04 | FGBS | Futures | 111.123 | 111.163 | 111.108 | 111.143 | 412033.0 |
| 2015-06-04 | FGBX | Futures | 151.98 | 154.46 | 148.8 | 153.43 | 86873.0 |
| 2015-06-04 | FMWO | Futures | 5897.6 | 5918.6 | 5887.8 | 5887.8 | 231.0 |
| 2015-06-04 | FOAT | Futures | 122.74 | 123.77 | 121.92 | 123.52 | 278486.0 |
| 2015-06-04 | FTDX | Futures | 1595.5 | 1598.8 | 1565.0 | 1589.8 | 109.0 |
| 2015-06-04 | FTI | Futures | 423.43 | 426.75 | 416.94 | 423.0 | 52372.0 |
| 2015-06-04 | FTUK | Futures | 5450.3 | 5455.0 | 5360.8 | 5406.6 | 140254.0 |
| 2015-06-04 | FVSA | Futures | 1727.82 | 1785.8 | 1704.63 | 1754.88 | 13084.0 |
| 2015-06-04 | FXXP | Futures | 302.2 | 303.7 | 297.8 | 301.5 | 15984.0 |
| 2015-06-04 | G | Futures | 100.62 | 101.56 | 100.06 | 101.43 | 262327.0 |
| 2015-06-04 | GF | Futures | 377.485 | 379.568 | 375.785 | 378.42 | 3013.0 |
| 2015-06-04 | GSCI | Futures | 741.0 | 741.0 | 727.32 | 728.93 | 229.0 |
| 2015-06-04 | HE | Futures | 89.328 | 89.328 | 87.561 | 87.67 | 15584.0 |
| 2015-06-04 | HG | Futures | 3.4209 | 3.4272 | 3.3582 | 3.3714 | 51155.0 |
> showing 50 of 107 rows — these rows as CSV