PREVIEW / futures_daily / 2014-10-01
file: by_date/futures_daily/2014/2014-10-01.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-10-01 | ES | Futures | 2048.43 | 2054.7 | 2019.97 | 2027.28 | 2450968.0 |
| 2014-10-01 | NQ | Futures | 4677.92 | 4689.22 | 4595.92 | 4615.62 | 435753.0 |
| 2014-10-01 | YM | Futures | 17183.0 | 17230.7 | 16932.4 | 16983.1 | 227999.0 |
| 2014-10-01 | CL | Futures | 172.1 | 175.11 | 170.42 | 170.91 | 389246.0 |
| 2014-10-01 | GC | Futures | 1586.3 | 1600.2 | 1580.5 | 1594.3 | 146536.0 |
| 2014-10-01 | ZN | Futures | 116.957884 | 117.763278 | 116.855379 | 117.631486 | 1962214.0 |
| 2014-10-01 | A6 | Futures | 0.84537 | 0.84566 | 0.8374 | 0.84352 | 155217.0 |
| 2014-10-01 | AD | Futures | 0.90554 | 0.90859 | 0.90341 | 0.90737 | 71225.0 |
| 2014-10-01 | ALI | Futures | 2917.32 | 2917.32 | 2917.32 | 2917.32 | 0.0 |
| 2014-10-01 | B | Futures | 99.25 | 100.46 | 98.02 | 98.39 | 204293.0 |
| 2014-10-01 | B6 | Futures | 1.7033 | 1.7073 | 1.6977 | 1.6992 | 95734.0 |
| 2014-10-01 | BFX | Futures | 3866.9 | 3869.6 | 3866.8 | 3866.8 | 58.0 |
| 2014-10-01 | BR | Futures | 0.21806 | 0.21809 | 0.21361 | 0.21369 | 2401.0 |
| 2014-10-01 | BZ | Futures | 99.83 | 101.19 | 98.75 | 99.12 | 22427.0 |
| 2014-10-01 | C | Futures | 2241.0 | 2243.0 | 2142.0 | 2159.0 | 16099.0 |
| 2014-10-01 | CB | Futures | 146.37 | 146.37 | 136.427 | 137.968 | 28.0 |
| 2014-10-01 | CC | Futures | 2417.0 | 2417.0 | 2325.0 | 2342.0 | 29068.0 |
| 2014-10-01 | CNH | Futures | 7.1084 | 7.1096 | 7.1084 | 7.1084 | 2.0 |
| 2014-10-01 | CSC | Futures | 5.169 | 5.169 | 5.127 | 5.145 | 28.0 |
| 2014-10-01 | CT | Futures | 77.76 | 78.98 | 77.49 | 78.77 | 12260.0 |
| 2014-10-01 | DC | Futures | 41.22 | 41.53 | 40.97 | 41.03 | 283.0 |
| 2014-10-01 | DX | Futures | 81.685 | 81.917 | 81.533 | 81.71 | 38962.0 |
| 2014-10-01 | E1 | Futures | 1.33952 | 1.34041 | 1.33338 | 1.33696 | 40755.0 |
| 2014-10-01 | E6 | Futures | 1.48739 | 1.48869 | 1.48198 | 1.4848 | 264611.0 |
| 2014-10-01 | E7 | Futures | 1.4782 | 1.4793 | 1.4727 | 1.4755 | 3632.0 |
| 2014-10-01 | ED | Futures | 95.4374 | 95.447 | 95.4326 | 95.4422 | 255228.0 |
| 2014-10-01 | ER | Futures | 98.009 | 98.019 | 98.009 | 98.019 | 62776.0 |
| 2014-10-01 | EW | Futures | 1419.5 | 1423.6 | 1399.9 | 1405.1 | 35180.0 |
| 2014-10-01 | FBTP | Futures | 95.48 | 95.9 | 95.44 | 95.8 | 61954.0 |
| 2014-10-01 | FBTS | Futures | 98.686 | 98.792 | 98.686 | 98.766 | 13049.0 |
| 2014-10-01 | FCE | Futures | 3502.1 | 3526.0 | 3454.3 | 3476.3 | 126479.0 |
| 2014-10-01 | FDAX | Futures | 10335.6 | 10432.5 | 10220.0 | 10289.5 | 135505.0 |
| 2014-10-01 | FESX | Futures | 2318.0 | 2337.5 | 2290.5 | 2308.6 | 1045707.0 |
| 2014-10-01 | FGBL | Futures | 131.9 | 132.51 | 131.84 | 132.33 | 892526.0 |
| 2014-10-01 | FGBM | Futures | 122.98 | 123.15 | 122.95 | 123.09 | 419095.0 |
| 2014-10-01 | FGBS | Futures | 110.963 | 110.983 | 110.958 | 110.973 | 210883.0 |
| 2014-10-01 | FGBX | Futures | 142.09 | 143.51 | 142.01 | 143.13 | 30427.0 |
| 2014-10-01 | FMWO | Futures | 5633.5 | 5634.8 | 5594.6 | 5597.1 | 775.0 |
| 2014-10-01 | FOAT | Futures | 121.69 | 122.16 | 121.6 | 122.04 | 86599.0 |
| 2014-10-01 | FTDX | Futures | 1181.9 | 1190.8 | 1175.2 | 1179.5 | 160.0 |
| 2014-10-01 | FTI | Futures | 362.51 | 364.24 | 358.15 | 360.09 | 37001.0 |
| 2014-10-01 | FTUK | Futures | 5081.4 | 5098.4 | 5027.7 | 5053.2 | 107548.0 |
| 2014-10-01 | FVSA | Futures | 1489.85 | 1530.45 | 1473.62 | 1526.39 | 12208.0 |
| 2014-10-01 | FXXP | Futures | 258.9 | 260.2 | 256.1 | 257.6 | 7463.0 |
| 2014-10-01 | G | Futures | 96.94 | 97.63 | 96.85 | 97.45 | 237812.0 |
| 2014-10-01 | GF | Futures | 366.457 | 370.93 | 365.835 | 370.93 | 1866.0 |
| 2014-10-01 | GSCI | Futures | 969.47 | 976.96 | 962.23 | 963.75 | 304.0 |
| 2014-10-01 | HE | Futures | 126.851 | 128.13 | 124.765 | 127.693 | 19869.0 |
| 2014-10-01 | HG | Futures | 3.8141 | 3.8674 | 3.8052 | 3.8509 | 44752.0 |
| 2014-10-01 | HH | Futures | 50.014 | 50.413 | 48.539 | 48.636 | 1589.0 |
> showing 50 of 105 rows — these rows as CSV