PREVIEW / futures_daily / 2014-04-23
file: by_date/futures_daily/2014/2014-04-23.parquet size: 9 KB rows: 104
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 |
|---|---|---|---|---|---|---|---|
| 2014-04-23 | ES | Futures | 1937.88 | 1945.89 | 1932.19 | 1937.88 | 1000557.0 |
| 2014-04-23 | NQ | Futures | 4126.14 | 4143.4 | 4081.82 | 4091.6 | 249723.0 |
| 2014-04-23 | YM | Futures | 16522.5 | 16572.7 | 16478.3 | 16527.5 | 99054.0 |
| 2014-04-23 | CL | Futures | 184.5 | 184.89 | 183.3 | 183.74 | 250645.0 |
| 2014-04-23 | GC | Futures | 1691.8 | 1698.5 | 1687.6 | 1692.6 | 98441.0 |
| 2014-04-23 | ZN | Futures | 114.736403 | 115.055115 | 114.649481 | 114.924733 | 1022979.0 |
| 2014-04-23 | A6 | Futures | 0.89635 | 0.89769 | 0.88722 | 0.88886 | 88465.0 |
| 2014-04-23 | AD | Futures | 0.91816 | 0.91907 | 0.91613 | 0.91796 | 44527.0 |
| 2014-04-23 | B | Futures | 113.09 | 113.13 | 112.16 | 112.68 | 181744.0 |
| 2014-04-23 | B6 | Futures | 1.7677 | 1.7688 | 1.761 | 1.763 | 74493.0 |
| 2014-04-23 | BFX | Futures | 3754.0 | 3754.0 | 3727.7 | 3727.7 | 13.0 |
| 2014-04-23 | BR | Futures | 0.23241 | 0.2345 | 0.23241 | 0.23426 | 265.0 |
| 2014-04-23 | BZ | Futures | 115.11 | 115.29 | 114.32 | 114.84 | 6163.0 |
| 2014-04-23 | C | Futures | 1953.0 | 1962.0 | 1944.0 | 1959.0 | 9100.0 |
| 2014-04-23 | CB | Futures | 93.542 | 93.669 | 93.415 | 93.542 | 4.0 |
| 2014-04-23 | CC | Futures | 2215.0 | 2230.0 | 2205.0 | 2218.0 | 6295.0 |
| 2014-04-23 | CNH | Futures | 7.165 | 7.1702 | 7.1635 | 7.1635 | 42.0 |
| 2014-04-23 | CSC | Futures | 4.383 | 4.404 | 4.372 | 4.386 | 20.0 |
| 2014-04-23 | CT | Futures | 102.29 | 104.76 | 100.88 | 104.42 | 7280.0 |
| 2014-04-23 | DC | Futures | 34.99 | 35.44 | 34.85 | 35.22 | 166.0 |
| 2014-04-23 | DX | Futures | 75.983 | 76.007 | 75.784 | 75.94 | 13261.0 |
| 2014-04-23 | E1 | Futures | 1.4506 | 1.45778 | 1.45008 | 1.45368 | 22826.0 |
| 2014-04-23 | E6 | Futures | 1.6295 | 1.63552 | 1.62879 | 1.6308 | 162973.0 |
| 2014-04-23 | E7 | Futures | 1.6188 | 1.6246 | 1.6182 | 1.6199 | 3102.0 |
| 2014-04-23 | EBM | Futures | 302.62 | 302.62 | 300.86 | 302.62 | 19232.0 |
| 2014-04-23 | ED | Futures | 95.4091 | 95.4091 | 95.4043 | 95.4091 | 55937.0 |
| 2014-04-23 | ER | Futures | 97.832 | 97.837 | 97.822 | 97.822 | 61745.0 |
| 2014-04-23 | EW | Futures | 1405.3 | 1411.0 | 1401.5 | 1405.5 | 13066.0 |
| 2014-04-23 | FBTP | Futures | 88.7 | 88.87 | 88.68 | 88.82 | 34407.0 |
| 2014-04-23 | FBTS | Futures | 97.548 | 97.575 | 97.513 | 97.539 | 10119.0 |
| 2014-04-23 | FCE | Futures | 3508.7 | 3509.9 | 3482.1 | 3485.7 | 75468.0 |
| 2014-04-23 | FDAX | Futures | 10630.1 | 10638.9 | 10552.2 | 10564.9 | 74183.0 |
| 2014-04-23 | FESX | Futures | 2257.1 | 2258.5 | 2239.1 | 2242.0 | 655283.0 |
| 2014-04-23 | FGBL | Futures | 124.13 | 124.33 | 123.96 | 124.26 | 547574.0 |
| 2014-04-23 | FGBM | Futures | 119.79 | 119.85 | 119.64 | 119.76 | 451301.0 |
| 2014-04-23 | FGBS | Futures | 110.518 | 110.523 | 110.468 | 110.508 | 258317.0 |
| 2014-04-23 | FGBX | Futures | 127.7 | 128.02 | 127.37 | 127.96 | 14909.0 |
| 2014-04-23 | FMWO | Futures | 5559.5 | 5559.5 | 5559.5 | 5559.5 | 0.0 |
| 2014-04-23 | FOAT | Futures | 113.46 | 113.6 | 113.31 | 113.57 | 43218.0 |
| 2014-04-23 | FTDX | Futures | 1152.7 | 1152.7 | 1141.9 | 1146.6 | 352.0 |
| 2014-04-23 | FTI | Futures | 340.13 | 340.22 | 338.88 | 339.31 | 19516.0 |
| 2014-04-23 | FTUK | Futures | 5060.0 | 5073.0 | 5045.9 | 5057.7 | 65397.0 |
| 2014-04-23 | FVSA | Futures | 1737.47 | 1785.07 | 1727.95 | 1761.27 | 6689.0 |
| 2014-04-23 | FXXP | Futures | 249.9 | 249.9 | 248.4 | 248.8 | 9698.0 |
| 2014-04-23 | G | Futures | 93.71 | 94.04 | 93.57 | 93.97 | 129938.0 |
| 2014-04-23 | GF | Futures | 284.211 | 284.728 | 283.694 | 284.29 | 1567.0 |
| 2014-04-23 | GSCI | Futures | 1092.26 | 1092.26 | 1087.87 | 1090.11 | 109.0 |
| 2014-04-23 | HE | Futures | 140.33 | 144.617 | 140.33 | 144.617 | 872.0 |
| 2014-04-23 | HG | Futures | 3.8755 | 3.8902 | 3.8563 | 3.8838 | 28479.0 |
| 2014-04-23 | HH | Futures | 60.25 | 60.503 | 59.82 | 59.87 | 8126.0 |
> showing 50 of 104 rows — these rows as CSV