PREVIEW / futures_daily / 2015-12-02
file: by_date/futures_daily/2015/2015-12-02.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-12-02 | ES | Futures | 2233.35 | 2239.2 | 2207.28 | 2214.2 | 1725833.0 |
| 2015-12-02 | NQ | Futures | 5512.82 | 5541.46 | 5470.14 | 5488.85 | 231812.0 |
| 2015-12-02 | YM | Futures | 18432.7 | 18474.0 | 18257.3 | 18322.3 | 132073.0 |
| 2015-12-02 | CL | Futures | 64.39 | 64.82 | 61.53 | 61.69 | 545289.0 |
| 2015-12-02 | GC | Futures | 1377.3 | 1381.3 | 1353.4 | 1359.1 | 124024.0 |
| 2015-12-02 | ZN | Futures | 122.179821 | 122.194789 | 121.745764 | 121.940341 | 58676.0 |
| 2015-12-02 | A6 | Futures | 0.73214 | 0.73414 | 0.72903 | 0.73013 | 85209.0 |
| 2015-12-02 | AD | Futures | 0.76656 | 0.76953 | 0.7639 | 0.76636 | 75252.0 |
| 2015-12-02 | ALI | Futures | 2150.57 | 2150.57 | 2150.57 | 2150.57 | 0.0 |
| 2015-12-02 | B | Futures | 39.12 | 39.45 | 37.56 | 37.61 | 178427.0 |
| 2015-12-02 | B6 | Futures | 1.5876 | 1.588 | 1.5684 | 1.5731 | 96596.0 |
| 2015-12-02 | BR | Futures | 0.1595 | 0.1595 | 0.15762 | 0.15894 | 47.0 |
| 2015-12-02 | BZ | Futures | 38.82 | 39.09 | 37.24 | 37.28 | 19521.0 |
| 2015-12-02 | C | Futures | 2404.0 | 2420.0 | 2392.0 | 2419.0 | 2941.0 |
| 2015-12-02 | CB | Futures | 246.155 | 246.155 | 243.681 | 245.845 | 13.0 |
| 2015-12-02 | CC | Futures | 2461.0 | 2466.0 | 2441.0 | 2457.0 | 10170.0 |
| 2015-12-02 | CNH | Futures | 7.1663 | 7.1678 | 7.1609 | 7.1673 | 133.0 |
| 2015-12-02 | CSC | Futures | 4.027 | 4.027 | 3.998 | 4.01 | 147.0 |
| 2015-12-02 | CT | Futures | 74.46 | 74.89 | 74.09 | 74.38 | 14232.0 |
| 2015-12-02 | DC | Futures | 32.14 | 32.14 | 32.01 | 32.12 | 113.0 |
| 2015-12-02 | DX | Futures | 93.404 | 94.036 | 93.372 | 93.545 | 37695.0 |
| 2015-12-02 | E1 | Futures | 1.23635 | 1.24662 | 1.23115 | 1.24535 | 35240.0 |
| 2015-12-02 | E6 | Futures | 1.24488 | 1.2457 | 1.23622 | 1.24395 | 260714.0 |
| 2015-12-02 | E7 | Futures | 1.2378 | 1.2388 | 1.2292 | 1.2371 | 4421.0 |
| 2015-12-02 | EBM | Futures | 257.96 | 259.05 | 257.22 | 258.32 | 10850.0 |
| 2015-12-02 | ED | Futures | 95.6607 | 95.6631 | 95.6439 | 95.6463 | 312749.0 |
| 2015-12-02 | ER | Futures | 98.274 | 98.279 | 98.259 | 98.269 | 158577.0 |
| 2015-12-02 | EW | Futures | 1552.9 | 1557.2 | 1532.6 | 1537.4 | 17880.0 |
| 2015-12-02 | FBON | Futures | 117.52 | 117.97 | 117.49 | 117.68 | 1574.0 |
| 2015-12-02 | FBTP | Futures | 106.21 | 106.48 | 106.08 | 106.34 | 197574.0 |
| 2015-12-02 | FBTS | Futures | 100.856 | 100.883 | 100.82 | 100.883 | 60228.0 |
| 2015-12-02 | FCE | Futures | 4122.9 | 4130.5 | 4058.2 | 4100.0 | 86976.0 |
| 2015-12-02 | FDAX | Futures | 12461.4 | 12482.9 | 12201.5 | 12325.4 | 103033.0 |
| 2015-12-02 | FDXM | Futures | 11642.1 | 11661.6 | 11400.3 | 11515.5 | 14332.0 |
| 2015-12-02 | FESX | Futures | 2619.4 | 2623.9 | 2571.4 | 2599.9 | 1151152.0 |
| 2015-12-02 | FGBL | Futures | 140.97 | 141.26 | 140.81 | 140.98 | 1161031.0 |
| 2015-12-02 | FGBM | Futures | 126.29 | 126.4 | 126.22 | 126.34 | 1041028.0 |
| 2015-12-02 | FGBS | Futures | 111.648 | 111.658 | 111.618 | 111.653 | 607060.0 |
| 2015-12-02 | FGBX | Futures | 158.18 | 158.94 | 157.92 | 158.63 | 75211.0 |
| 2015-12-02 | FMWO | Futures | 5734.9 | 5734.9 | 5708.9 | 5708.9 | 14.0 |
| 2015-12-02 | FOAT | Futures | 129.53 | 129.77 | 129.35 | 129.55 | 169050.0 |
| 2015-12-02 | FTDX | Futures | 1766.2 | 1781.8 | 1762.9 | 1776.2 | 517.0 |
| 2015-12-02 | FTI | Futures | 407.68 | 408.68 | 402.38 | 405.89 | 28863.0 |
| 2015-12-02 | FTUK | Futures | 5162.7 | 5186.0 | 5125.3 | 5167.9 | 88339.0 |
| 2015-12-02 | FVSA | Futures | 2087.01 | 2096.48 | 2016.03 | 2034.96 | 16694.0 |
| 2015-12-02 | FXXP | Futures | 301.1 | 301.5 | 296.5 | 299.4 | 10892.0 |
| 2015-12-02 | G | Futures | 105.22 | 105.69 | 105.22 | 105.47 | 192192.0 |
| 2015-12-02 | GF | Futures | 316.275 | 317.868 | 308.651 | 310.243 | 5161.0 |
| 2015-12-02 | GSCI | Futures | 529.84 | 531.66 | 518.68 | 519.55 | 169.0 |
| 2015-12-02 | HE | Futures | 85.831 | 86.154 | 84.432 | 84.863 | 12390.0 |
> showing 50 of 107 rows — these rows as CSV