PREVIEW / futures_daily / 2014-10-23
file: by_date/futures_daily/2014/2014-10-23.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-23 | ES | Futures | 2010.31 | 2043.47 | 2007.96 | 2032.76 | 2014997.0 |
| 2014-10-23 | NQ | Futures | 4574.48 | 4664.59 | 4565.79 | 4641.99 | 348130.0 |
| 2014-10-23 | YM | Futures | 16664.6 | 16935.4 | 16641.2 | 16854.3 | 200392.0 |
| 2014-10-23 | CL | Futures | 154.41 | 158.15 | 153.69 | 157.61 | 354839.0 |
| 2014-10-23 | GC | Futures | 1628.7 | 1632.9 | 1608.5 | 1612.2 | 140066.0 |
| 2014-10-23 | ZN | Futures | 119.535146 | 119.666937 | 118.8469 | 119.037265 | 1420646.0 |
| 2014-10-23 | A6 | Futures | 0.84867 | 0.85275 | 0.84711 | 0.84789 | 90022.0 |
| 2014-10-23 | AD | Futures | 0.90239 | 0.90524 | 0.90067 | 0.9029 | 43698.0 |
| 2014-10-23 | ALI | Futures | 3053.64 | 3053.64 | 3053.64 | 3053.64 | 0.0 |
| 2014-10-23 | B | Futures | 87.93 | 90.5 | 87.32 | 90.13 | 306978.0 |
| 2014-10-23 | B6 | Futures | 1.6857 | 1.6875 | 1.6806 | 1.6841 | 77500.0 |
| 2014-10-23 | BFX | Futures | 3676.9 | 3717.4 | 3676.9 | 3712.3 | 8.0 |
| 2014-10-23 | BR | Futures | 0.21447 | 0.21463 | 0.2122 | 0.21272 | 128.0 |
| 2014-10-23 | BZ | Futures | 88.25 | 91.15 | 87.97 | 90.79 | 24796.0 |
| 2014-10-23 | C | Futures | 2153.0 | 2200.0 | 2135.0 | 2163.0 | 6900.0 |
| 2014-10-23 | CB | Futures | 136.851 | 137.775 | 134.5 | 135.27 | 53.0 |
| 2014-10-23 | CC | Futures | 2279.0 | 2344.0 | 2266.0 | 2303.0 | 15209.0 |
| 2014-10-23 | CNH | Futures | 7.0504 | 7.0504 | 7.0467 | 7.0473 | 2.0 |
| 2014-10-23 | CSC | Futures | 4.906 | 4.969 | 4.754 | 4.767 | 51.0 |
| 2014-10-23 | CT | Futures | 79.25 | 80.21 | 78.54 | 79.88 | 11799.0 |
| 2014-10-23 | DC | Futures | 39.93 | 40.51 | 38.64 | 38.85 | 513.0 |
| 2014-10-23 | DX | Futures | 81.514 | 81.685 | 81.405 | 81.586 | 20054.0 |
| 2014-10-23 | E1 | Futures | 1.34105 | 1.34399 | 1.33798 | 1.34105 | 28797.0 |
| 2014-10-23 | E6 | Futures | 1.48904 | 1.49257 | 1.48516 | 1.4894 | 169435.0 |
| 2014-10-23 | E7 | Futures | 1.4793 | 1.4833 | 1.4758 | 1.48 | 3127.0 |
| 2014-10-23 | ED | Futures | 95.4422 | 95.4422 | 95.4326 | 95.4374 | 92440.0 |
| 2014-10-23 | ER | Futures | 97.974 | 97.984 | 97.974 | 97.979 | 32469.0 |
| 2014-10-23 | EW | Futures | 1407.5 | 1435.0 | 1405.4 | 1426.8 | 22301.0 |
| 2014-10-23 | FBTP | Futures | 94.04 | 94.45 | 93.96 | 94.25 | 57272.0 |
| 2014-10-23 | FBTS | Futures | 98.162 | 98.277 | 98.153 | 98.215 | 12943.0 |
| 2014-10-23 | FCE | Futures | 3285.6 | 3360.2 | 3261.4 | 3351.7 | 143421.0 |
| 2014-10-23 | FDAX | Futures | 9723.7 | 9940.1 | 9658.6 | 9911.1 | 141410.0 |
| 2014-10-23 | FESX | Futures | 2155.7 | 2204.3 | 2145.6 | 2197.7 | 1345364.0 |
| 2014-10-23 | FGBL | Futures | 132.84 | 132.96 | 132.21 | 132.37 | 633907.0 |
| 2014-10-23 | FGBM | Futures | 123.03 | 123.05 | 122.82 | 122.87 | 304967.0 |
| 2014-10-23 | FGBS | Futures | 110.908 | 110.913 | 110.893 | 110.908 | 179815.0 |
| 2014-10-23 | FGBX | Futures | 144.72 | 144.98 | 143.03 | 143.47 | 19355.0 |
| 2014-10-23 | FMWO | Futures | 5483.1 | 5533.2 | 5474.3 | 5525.7 | 641.0 |
| 2014-10-23 | FOAT | Futures | 121.73 | 121.84 | 121.48 | 121.52 | 68292.0 |
| 2014-10-23 | FTDX | Futures | 1133.6 | 1149.7 | 1129.9 | 1142.6 | 286.0 |
| 2014-10-23 | FTI | Futures | 343.06 | 346.73 | 339.73 | 346.07 | 34487.0 |
| 2014-10-23 | FTUK | Futures | 4895.1 | 4955.4 | 4864.9 | 4945.7 | 103830.0 |
| 2014-10-23 | FVSA | Futures | 1749.99 | 1770.82 | 1666.65 | 1687.49 | 9697.0 |
| 2014-10-23 | FXXP | Futures | 244.9 | 248.9 | 244.1 | 248.5 | 8280.0 |
| 2014-10-23 | G | Futures | 99.15 | 99.37 | 98.61 | 98.74 | 132404.0 |
| 2014-10-23 | GF | Futures | 368.786 | 371.329 | 368.238 | 370.508 | 3737.0 |
| 2014-10-23 | GSCI | Futures | 911.81 | 921.75 | 911.64 | 921.49 | 33.0 |
| 2014-10-23 | HE | Futures | 120.458 | 120.862 | 118.473 | 119.415 | 15162.0 |
| 2014-10-23 | HG | Futures | 3.8223 | 3.8674 | 3.8166 | 3.856 | 33865.0 |
| 2014-10-23 | HH | Futures | 43.643 | 44.393 | 43.413 | 43.788 | 9856.0 |
> showing 50 of 105 rows — these rows as CSV