PREVIEW / futures_daily / 2015-05-14
file: by_date/futures_daily/2015/2015-05-14.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-05-14 | ES | Futures | 2203.87 | 2227.26 | 2199.66 | 2226.47 | 1104560.0 |
| 2015-05-14 | NQ | Futures | 5138.44 | 5216.52 | 5123.35 | 5213.33 | 184396.0 |
| 2015-05-14 | YM | Futures | 18443.2 | 18629.3 | 18398.2 | 18618.1 | 121456.0 |
| 2015-05-14 | CL | Futures | 102.73 | 103.86 | 101.47 | 102.24 | 187240.0 |
| 2015-05-14 | GC | Futures | 1589.8 | 1606.4 | 1585.8 | 1603.2 | 177837.0 |
| 2015-05-14 | ZN | Futures | 120.221741 | 120.769347 | 120.14774 | 120.665746 | 1485118.0 |
| 2015-05-14 | A6 | Futures | 0.79816 | 0.80388 | 0.79392 | 0.79471 | 97405.0 |
| 2015-05-14 | AD | Futures | 0.85355 | 0.85631 | 0.84998 | 0.8509 | 57411.0 |
| 2015-05-14 | ALI | Futures | 2535.97 | 2535.97 | 2535.97 | 2535.97 | 0.0 |
| 2015-05-14 | B | Futures | 63.8 | 64.56 | 63.07 | 63.49 | 247258.0 |
| 2015-05-14 | B6 | Futures | 1.6567 | 1.6653 | 1.6552 | 1.6592 | 109848.0 |
| 2015-05-14 | BFX | Futures | 4413.0 | 4430.6 | 4413.0 | 4430.6 | 15.0 |
| 2015-05-14 | BR | Futures | 0.18788 | 0.18962 | 0.18779 | 0.18908 | 677.0 |
| 2015-05-14 | BZ | Futures | 63.03 | 63.93 | 62.48 | 62.88 | 17152.0 |
| 2015-05-14 | C | Futures | 2203.0 | 2215.0 | 2198.0 | 2214.0 | 4831.0 |
| 2015-05-14 | CB | Futures | 170.325 | 170.325 | 166.279 | 166.279 | 14.0 |
| 2015-05-14 | CC | Futures | 2265.0 | 2285.0 | 2257.0 | 2278.0 | 13504.0 |
| 2015-05-14 | CNH | Futures | 6.9824 | 6.9842 | 6.9824 | 6.9837 | 10.0 |
| 2015-05-14 | CSC | Futures | 4.511 | 4.567 | 4.498 | 4.556 | 75.0 |
| 2015-05-14 | CT | Futures | 83.0 | 84.06 | 82.62 | 83.81 | 13277.0 |
| 2015-05-14 | DC | Futures | 37.29 | 37.63 | 37.02 | 37.54 | 646.0 |
| 2015-05-14 | DX | Futures | 88.01 | 88.094 | 87.47 | 87.798 | 53546.0 |
| 2015-05-14 | E1 | Futures | 1.39153 | 1.40516 | 1.39013 | 1.39726 | 19475.0 |
| 2015-05-14 | E6 | Futures | 1.3355 | 1.34726 | 1.33397 | 1.34056 | 293565.0 |
| 2015-05-14 | E7 | Futures | 1.3278 | 1.3403 | 1.3264 | 1.3328 | 7924.0 |
| 2015-05-14 | EBM | Futures | 280.77 | 288.97 | 280.77 | 288.56 | 9929.0 |
| 2015-05-14 | ED | Futures | 95.5669 | 95.5716 | 95.5621 | 95.5669 | 121146.0 |
| 2015-05-14 | ER | Futures | 98.077 | 98.082 | 98.068 | 98.077 | 38489.0 |
| 2015-05-14 | EW | Futures | 1589.1 | 1605.4 | 1585.7 | 1604.9 | 13753.0 |
| 2015-05-14 | FBTP | Futures | 98.72 | 99.62 | 98.64 | 99.34 | 97808.0 |
| 2015-05-14 | FBTS | Futures | 99.652 | 99.679 | 99.626 | 99.652 | 15923.0 |
| 2015-05-14 | FCE | Futures | 4076.3 | 4154.4 | 4035.2 | 4140.7 | 62154.0 |
| 2015-05-14 | FDAX | Futures | 12574.1 | 12862.5 | 12453.7 | 12855.9 | 101056.0 |
| 2015-05-14 | FESX | Futures | 2589.3 | 2642.4 | 2565.0 | 2638.7 | 1038382.0 |
| 2015-05-14 | FGBL | Futures | 135.17 | 136.12 | 135.05 | 135.66 | 709421.0 |
| 2015-05-14 | FGBM | Futures | 123.61 | 123.75 | 123.58 | 123.65 | 435624.0 |
| 2015-05-14 | FGBS | Futures | 111.153 | 111.173 | 111.138 | 111.153 | 279639.0 |
| 2015-05-14 | FGBX | Futures | 154.1 | 156.91 | 153.67 | 155.57 | 40280.0 |
| 2015-05-14 | FMWO | Futures | 5911.2 | 5950.6 | 5911.2 | 5950.6 | 185.0 |
| 2015-05-14 | FOAT | Futures | 124.24 | 125.22 | 124.18 | 124.79 | 88602.0 |
| 2015-05-14 | FTDX | Futures | 1548.5 | 1570.6 | 1547.1 | 1567.8 | 83.0 |
| 2015-05-14 | FTI | Futures | 422.39 | 428.45 | 418.86 | 427.44 | 23230.0 |
| 2015-05-14 | FTUK | Futures | 5450.3 | 5494.5 | 5412.9 | 5487.0 | 84701.0 |
| 2015-05-14 | FVSA | Futures | 1720.09 | 1735.55 | 1662.11 | 1673.71 | 7829.0 |
| 2015-05-14 | FXXP | Futures | 301.3 | 306.2 | 299.1 | 306.0 | 10831.0 |
| 2015-05-14 | G | Futures | 101.5 | 101.91 | 101.22 | 101.61 | 202604.0 |
| 2015-05-14 | GF | Futures | 370.514 | 373.15 | 370.514 | 372.257 | 3778.0 |
| 2015-05-14 | GSCI | Futures | 768.52 | 771.41 | 764.11 | 766.82 | 70.0 |
| 2015-05-14 | HE | Futures | 91.938 | 92.182 | 90.797 | 91.177 | 16836.0 |
| 2015-05-14 | HG | Futures | 3.6794 | 3.6876 | 3.6468 | 3.6681 | 29845.0 |
> showing 50 of 107 rows — these rows as CSV