PREVIEW / futures_daily / 2014-12-01
file: by_date/futures_daily/2014/2014-12-01.parquet size: 9 KB rows: 106
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-12-01 | ES | Futures | 2155.24 | 2156.03 | 2139.57 | 2142.18 | 1471696.0 |
| 2014-12-01 | NQ | Futures | 5019.23 | 5024.74 | 4952.88 | 4967.95 | 324373.0 |
| 2014-12-01 | YM | Futures | 18042.3 | 18067.7 | 17958.1 | 18012.9 | 139627.0 |
| 2014-12-01 | CL | Futures | 127.23 | 134.05 | 122.83 | 133.01 | 504122.0 |
| 2014-12-01 | GC | Futures | 1517.6 | 1598.2 | 1494.4 | 1594.4 | 342307.0 |
| 2014-12-01 | ZN | Futures | 119.813373 | 120.018382 | 119.300849 | 119.505858 | 237116.0 |
| 2014-12-01 | A6 | Futures | 0.82331 | 0.82836 | 0.81718 | 0.82632 | 126156.0 |
| 2014-12-01 | AD | Futures | 0.88868 | 0.89762 | 0.88614 | 0.89731 | 82770.0 |
| 2014-12-01 | ALI | Futures | 3016.51 | 3016.51 | 3016.51 | 3016.51 | 0.0 |
| 2014-12-01 | B | Futures | 73.03 | 75.84 | 70.19 | 75.37 | 172821.0 |
| 2014-12-01 | B6 | Futures | 1.6436 | 1.6568 | 1.638 | 1.6544 | 101061.0 |
| 2014-12-01 | BFX | Futures | 3966.5 | 3966.5 | 3946.1 | 3960.9 | 26.0 |
| 2014-12-01 | BR | Futures | 0.21057 | 0.21057 | 0.21057 | 0.21057 | 5.0 |
| 2014-12-01 | BZ | Futures | 72.97 | 76.51 | 70.85 | 76.04 | 21289.0 |
| 2014-12-01 | C | Futures | 2053.0 | 2086.0 | 2051.0 | 2086.0 | 9366.0 |
| 2014-12-01 | CB | Futures | 137.212 | 138.219 | 137.192 | 137.192 | 42.0 |
| 2014-12-01 | CC | Futures | 2104.0 | 2139.0 | 2102.0 | 2137.0 | 12699.0 |
| 2014-12-01 | CNH | Futures | 7.0738 | 7.0738 | 7.0648 | 7.0648 | 2.0 |
| 2014-12-01 | CSC | Futures | 4.807 | 4.807 | 4.648 | 4.651 | 218.0 |
| 2014-12-01 | CT | Futures | 76.57 | 77.01 | 75.46 | 75.58 | 16435.0 |
| 2014-12-01 | DC | Futures | 38.57 | 38.57 | 36.84 | 36.98 | 380.0 |
| 2014-12-01 | DX | Futures | 83.887 | 84.015 | 83.351 | 83.519 | 43344.0 |
| 2014-12-01 | E1 | Futures | 1.32213 | 1.33057 | 1.31996 | 1.32648 | 47105.0 |
| 2014-12-01 | E6 | Futures | 1.46515 | 1.47245 | 1.46209 | 1.46891 | 241437.0 |
| 2014-12-01 | E7 | Futures | 1.4557 | 1.4631 | 1.453 | 1.4597 | 3000.0 |
| 2014-12-01 | ED | Futures | 95.4398 | 95.4422 | 95.4374 | 95.4398 | 109038.0 |
| 2014-12-01 | ER | Futures | 97.999 | 98.004 | 97.994 | 98.004 | 40411.0 |
| 2014-12-01 | EW | Futures | 1499.7 | 1503.0 | 1482.2 | 1483.4 | 16315.0 |
| 2014-12-01 | FBTP | Futures | 97.96 | 98.14 | 97.91 | 97.98 | 90221.0 |
| 2014-12-01 | FBTS | Futures | 98.757 | 98.766 | 98.694 | 98.703 | 21456.0 |
| 2014-12-01 | FCE | Futures | 3536.2 | 3550.0 | 3507.0 | 3542.7 | 101307.0 |
| 2014-12-01 | FDAX | Futures | 10874.5 | 10937.0 | 10842.2 | 10910.1 | 103908.0 |
| 2014-12-01 | FESX | Futures | 2340.4 | 2345.5 | 2323.8 | 2338.3 | 841054.0 |
| 2014-12-01 | FEU3 | Futures | 98.621 | 98.626 | 98.621 | 98.626 | 533.0 |
| 2014-12-01 | FGBL | Futures | 134.75 | 134.8 | 134.05 | 134.37 | 749030.0 |
| 2014-12-01 | FGBM | Futures | 123.3 | 123.32 | 123.0 | 123.13 | 616886.0 |
| 2014-12-01 | FGBS | Futures | 110.853 | 110.853 | 110.803 | 110.818 | 394081.0 |
| 2014-12-01 | FGBX | Futures | 149.83 | 150.09 | 148.15 | 149.01 | 32407.0 |
| 2014-12-01 | FMWO | Futures | 5745.1 | 5766.4 | 5745.1 | 5758.9 | 218.0 |
| 2014-12-01 | FOAT | Futures | 124.66 | 124.74 | 124.23 | 124.42 | 76489.0 |
| 2014-12-01 | FTDX | Futures | 1284.9 | 1284.9 | 1263.6 | 1272.2 | 130.0 |
| 2014-12-01 | FTI | Futures | 370.07 | 370.07 | 366.59 | 368.16 | 30664.0 |
| 2014-12-01 | FTUK | Futures | 5158.8 | 5168.0 | 5132.9 | 5149.1 | 109761.0 |
| 2014-12-01 | FVSA | Futures | 1547.19 | 1577.96 | 1534.01 | 1555.98 | 7695.0 |
| 2014-12-01 | FXXP | Futures | 262.0 | 262.8 | 261.0 | 262.0 | 9418.0 |
| 2014-12-01 | G | Futures | 101.48 | 101.97 | 101.44 | 101.72 | 162742.0 |
| 2014-12-01 | GF | Futures | 371.078 | 375.57 | 370.958 | 375.57 | 4554.0 |
| 2014-12-01 | GSCI | Futures | 814.31 | 836.61 | 814.31 | 834.92 | 259.0 |
| 2014-12-01 | HE | Futures | 117.789 | 119.734 | 116.481 | 119.298 | 18335.0 |
| 2014-12-01 | HG | Futures | 3.614 | 3.7054 | 3.5282 | 3.6813 | 98985.0 |
> showing 50 of 106 rows — these rows as CSV