PREVIEW / futures_daily / 2014-02-20
file: by_date/futures_daily/2014/2014-02-20.parquet size: 9 KB rows: 105
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-02-20 | ES | Futures | 1882.34 | 1897.03 | 1873.32 | 1892.91 | 1608588.0 |
| 2014-02-20 | NQ | Futures | 4201.24 | 4227.11 | 4182.56 | 4220.78 | 269725.0 |
| 2014-02-20 | YM | Futures | 15995.7 | 16111.5 | 15921.8 | 16074.6 | 165696.0 |
| 2014-02-20 | CL | Futures | 183.09 | 183.36 | 182.0 | 182.84 | 194397.0 |
| 2014-02-20 | GC | Futures | 1728.2 | 1747.0 | 1723.0 | 1735.9 | 129024.0 |
| 2014-02-20 | ZN | Futures | 115.078 | 115.435697 | 114.791844 | 114.920614 | 1468950.0 |
| 2014-02-20 | A6 | Futures | 0.85616 | 0.85844 | 0.85034 | 0.85616 | 90280.0 |
| 2014-02-20 | AD | Futures | 0.91359 | 0.91501 | 0.91066 | 0.91116 | 63798.0 |
| 2014-02-20 | B | Futures | 113.35 | 113.45 | 112.52 | 113.26 | 151209.0 |
| 2014-02-20 | B6 | Futures | 1.7521 | 1.7543 | 1.7462 | 1.7498 | 98394.0 |
| 2014-02-20 | BFX | Futures | 3625.0 | 3634.2 | 3602.5 | 3634.2 | 263.0 |
| 2014-02-20 | BR | Futures | 0.21609 | 0.21857 | 0.21609 | 0.21764 | 213.0 |
| 2014-02-20 | BZ | Futures | 115.31 | 115.71 | 114.79 | 115.55 | 5272.0 |
| 2014-02-20 | C | Futures | 1944.0 | 1969.0 | 1936.0 | 1959.0 | 10173.0 |
| 2014-02-20 | CB | Futures | 87.831 | 87.831 | 87.551 | 87.831 | 7.0 |
| 2014-02-20 | CC | Futures | 2180.0 | 2225.0 | 2174.0 | 2210.0 | 16356.0 |
| 2014-02-20 | CNH | Futures | 6.9909 | 6.992 | 6.9909 | 6.992 | 12.0 |
| 2014-02-20 | CSC | Futures | 4.348 | 4.35 | 4.313 | 4.323 | 68.0 |
| 2014-02-20 | CT | Futures | 99.31 | 99.54 | 98.33 | 98.48 | 3435.0 |
| 2014-02-20 | DC | Futures | 33.26 | 33.72 | 33.03 | 33.64 | 544.0 |
| 2014-02-20 | DX | Futures | 76.281 | 76.519 | 76.143 | 76.377 | 19570.0 |
| 2014-02-20 | E1 | Futures | 1.44482 | 1.44931 | 1.4402 | 1.44379 | 23866.0 |
| 2014-02-20 | E6 | Futures | 1.62124 | 1.62454 | 1.61486 | 1.61959 | 181485.0 |
| 2014-02-20 | E7 | Futures | 1.6107 | 1.6139 | 1.6043 | 1.609 | 4151.0 |
| 2014-02-20 | EBM | Futures | 277.39 | 277.74 | 276.35 | 276.7 | 9328.0 |
| 2014-02-20 | ED | Futures | 95.3853 | 95.3877 | 95.3829 | 95.3853 | 57905.0 |
| 2014-02-20 | ER | Futures | 97.886 | 97.896 | 97.881 | 97.881 | 62615.0 |
| 2014-02-20 | EW | Futures | 1373.5 | 1384.2 | 1365.9 | 1382.9 | 13743.0 |
| 2014-02-20 | FBTP | Futures | 85.31 | 85.38 | 84.93 | 84.97 | 55502.0 |
| 2014-02-20 | FBTS | Futures | 96.626 | 96.652 | 96.547 | 96.555 | 9674.0 |
| 2014-02-20 | FCE | Futures | 3337.0 | 3379.6 | 3323.5 | 3374.6 | 81754.0 |
| 2014-02-20 | FDAX | Futures | 10613.2 | 10677.0 | 10540.6 | 10653.1 | 117463.0 |
| 2014-02-20 | FESX | Futures | 2175.3 | 2198.5 | 2164.7 | 2192.9 | 1047639.0 |
| 2014-02-20 | FGBL | Futures | 122.43 | 122.74 | 122.04 | 122.07 | 890209.0 |
| 2014-02-20 | FGBM | Futures | 119.34 | 119.52 | 119.13 | 119.16 | 615154.0 |
| 2014-02-20 | FGBS | Futures | 110.623 | 110.663 | 110.598 | 110.613 | 320610.0 |
| 2014-02-20 | FGBX | Futures | 123.98 | 124.55 | 123.34 | 123.4 | 17502.0 |
| 2014-02-20 | FMWO | Futures | 5403.2 | 5432.1 | 5403.2 | 5432.1 | 10.0 |
| 2014-02-20 | FOAT | Futures | 110.75 | 110.99 | 110.43 | 110.47 | 70328.0 |
| 2014-02-20 | FTDX | Futures | 1177.9 | 1183.6 | 1166.2 | 1183.6 | 213.0 |
| 2014-02-20 | FTI | Futures | 340.53 | 341.25 | 338.14 | 340.57 | 20576.0 |
| 2014-02-20 | FTUK | Futures | 5097.9 | 5149.4 | 5074.1 | 5129.3 | 102505.0 |
| 2014-02-20 | FVSA | Futures | 1866.43 | 1896.3 | 1816.66 | 1826.62 | 7018.0 |
| 2014-02-20 | FXXP | Futures | 243.5 | 245.5 | 242.9 | 245.1 | 4909.0 |
| 2014-02-20 | G | Futures | 93.31 | 93.48 | 92.59 | 92.65 | 212010.0 |
| 2014-02-20 | GF | Futures | 276.464 | 276.706 | 275.496 | 275.899 | 1576.0 |
| 2014-02-20 | GSCI | Futures | 1067.31 | 1073.06 | 1066.0 | 1073.06 | 126.0 |
| 2014-02-20 | HE | Futures | 117.541 | 118.537 | 116.545 | 118.145 | 17198.0 |
| 2014-02-20 | HG | Futures | 4.132 | 4.1459 | 4.1016 | 4.1326 | 21034.0 |
| 2014-02-20 | HH | Futures | 65.225 | 66.627 | 63.705 | 64.428 | 3387.0 |
> showing 50 of 105 rows — these rows as CSV