PREVIEW / futures_daily / 2014-01-24
file: by_date/futures_daily/2014/2014-01-24.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-01-24 | ES | Futures | 1880.28 | 1884.4 | 1834.92 | 1836.99 | 2566321.0 |
| 2014-01-24 | NQ | Futures | 4153.82 | 4163.02 | 4055.53 | 4060.7 | 379834.0 |
| 2014-01-24 | YM | Futures | 16125.5 | 16155.5 | 15770.1 | 15791.0 | 233435.0 |
| 2014-01-24 | CL | Futures | 171.95 | 172.71 | 169.97 | 170.66 | 239673.0 |
| 2014-01-24 | GC | Futures | 1673.2 | 1685.8 | 1664.0 | 1674.0 | 161723.0 |
| 2014-01-24 | ZN | Futures | 114.205222 | 114.920614 | 114.162298 | 114.519994 | 1875923.0 |
| 2014-01-24 | A6 | Futures | 0.83176 | 0.83348 | 0.82261 | 0.82757 | 119582.0 |
| 2014-01-24 | AD | Futures | 0.91076 | 0.91511 | 0.90813 | 0.9139 | 85718.0 |
| 2014-01-24 | B | Futures | 109.76 | 110.23 | 108.49 | 110.06 | 108858.0 |
| 2014-01-24 | B6 | Futures | 1.7472 | 1.7504 | 1.7304 | 1.7334 | 157070.0 |
| 2014-01-24 | BR | Futures | 0.21256 | 0.21427 | 0.21103 | 0.21365 | 801.0 |
| 2014-01-24 | BZ | Futures | 112.07 | 112.44 | 110.71 | 112.29 | 10330.0 |
| 2014-01-24 | C | Futures | 1868.0 | 1882.0 | 1864.0 | 1876.0 | 9316.0 |
| 2014-01-24 | CB | Futures | 91.633 | 91.633 | 91.633 | 91.633 | 18.0 |
| 2014-01-24 | CC | Futures | 2074.0 | 2088.0 | 2062.0 | 2072.0 | 15068.0 |
| 2014-01-24 | CNH | Futures | 6.9596 | 6.9698 | 6.9596 | 6.9692 | 38.0 |
| 2014-01-24 | CSC | Futures | 4.186 | 4.195 | 4.102 | 4.106 | 26.0 |
| 2014-01-24 | CT | Futures | 99.53 | 100.56 | 98.62 | 99.44 | 15263.0 |
| 2014-01-24 | DC | Futures | 32.12 | 32.5 | 31.82 | 32.04 | 448.0 |
| 2014-01-24 | DX | Futures | 76.614 | 76.685 | 76.286 | 76.591 | 26805.0 |
| 2014-01-24 | E1 | Futures | 1.43095 | 1.44251 | 1.42826 | 1.43481 | 45735.0 |
| 2014-01-24 | E6 | Futures | 1.61628 | 1.62195 | 1.61274 | 1.61439 | 244123.0 |
| 2014-01-24 | E7 | Futures | 1.605 | 1.6114 | 1.6022 | 1.6039 | 7403.0 |
| 2014-01-24 | EBM | Futures | 270.43 | 270.43 | 267.65 | 268.34 | 10639.0 |
| 2014-01-24 | ED | Futures | 95.3662 | 95.3662 | 95.3519 | 95.3614 | 325179.0 |
| 2014-01-24 | ER | Futures | 97.862 | 97.862 | 97.842 | 97.852 | 193970.0 |
| 2014-01-24 | EW | Futures | 1377.0 | 1379.1 | 1334.8 | 1336.4 | 27426.0 |
| 2014-01-24 | FBTP | Futures | 83.53 | 83.53 | 83.09 | 83.25 | 70553.0 |
| 2014-01-24 | FBTS | Futures | 96.135 | 96.135 | 95.986 | 96.029 | 16626.0 |
| 2014-01-24 | FCE | Futures | 3332.0 | 3339.8 | 3220.0 | 3237.5 | 225892.0 |
| 2014-01-24 | FDAX | Futures | 10721.3 | 10730.2 | 10365.3 | 10411.4 | 187376.0 |
| 2014-01-24 | FDIV | Futures | 146.54 | 146.54 | 142.77 | 142.77 | 1.0 |
| 2014-01-24 | FESX | Futures | 2196.4 | 2199.2 | 2116.2 | 2125.3 | 1674544.0 |
| 2014-01-24 | FEU3 | Futures | 98.463 | 98.468 | 98.463 | 98.468 | 100.0 |
| 2014-01-24 | FGBL | Futures | 121.12 | 121.6 | 121.02 | 121.4 | 966420.0 |
| 2014-01-24 | FGBM | Futures | 118.56 | 118.82 | 118.5 | 118.72 | 598980.0 |
| 2014-01-24 | FGBS | Futures | 110.523 | 110.583 | 110.513 | 110.563 | 446444.0 |
| 2014-01-24 | FGBX | Futures | 122.62 | 123.41 | 122.38 | 123.16 | 18435.0 |
| 2014-01-24 | FMWO | Futures | 5386.8 | 5386.8 | 5312.6 | 5312.6 | 3.0 |
| 2014-01-24 | FOAT | Futures | 109.27 | 109.62 | 109.1 | 109.55 | 66037.0 |
| 2014-01-24 | FTDX | Futures | 1173.7 | 1173.7 | 1131.9 | 1145.5 | 494.0 |
| 2014-01-24 | FTI | Futures | 345.56 | 346.25 | 334.98 | 336.87 | 49962.0 |
| 2014-01-24 | FTUK | Futures | 5097.5 | 5106.6 | 4966.6 | 4999.9 | 151242.0 |
| 2014-01-24 | FVSA | Futures | 1805.72 | 2025.05 | 1805.72 | 2025.05 | 18950.0 |
| 2014-01-24 | FXXP | Futures | 244.0 | 244.3 | 237.5 | 237.6 | 16421.0 |
| 2014-01-24 | G | Futures | 92.56 | 93.05 | 92.52 | 92.75 | 212741.0 |
| 2014-01-24 | GF | Futures | 273.562 | 273.965 | 271.748 | 272.272 | 2621.0 |
| 2014-01-24 | GSCI | Futures | 1022.44 | 1026.38 | 1020.72 | 1025.39 | 68.0 |
| 2014-01-24 | HE | Futures | 112.559 | 113.616 | 112.559 | 113.556 | 16502.0 |
| 2014-01-24 | HG | Futures | 4.1408 | 4.1673 | 4.1181 | 4.132 | 49012.0 |
> showing 50 of 105 rows — these rows as CSV