PREVIEW / futures_daily / 2014-12-10
file: by_date/futures_daily/2014/2014-12-10.parquet size: 9 KB rows: 103
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-12-10 | ES | Futures | 2149.5 | 2151.85 | 2113.46 | 2116.85 | 2376052.0 |
| 2014-12-10 | NQ | Futures | 4972.88 | 4981.57 | 4889.72 | 4898.99 | 382192.0 |
| 2014-12-10 | YM | Futures | 18038.2 | 18065.7 | 17754.1 | 17795.8 | 17479.0 |
| 2014-12-10 | CL | Futures | 122.08 | 122.28 | 116.49 | 117.48 | 456172.0 |
| 2014-12-10 | GC | Futures | 1611.5 | 1621.6 | 1603.7 | 1609.2 | 143319.0 |
| 2014-12-10 | ZN | Futures | 119.31948 | 119.864183 | 119.186984 | 119.746409 | 1284141.0 |
| 2014-12-10 | A6 | Futures | 0.80659 | 0.81208 | 0.80385 | 0.80679 | 68438.0 |
| 2014-12-10 | AD | Futures | 0.88787 | 0.88868 | 0.88359 | 0.88451 | 40228.0 |
| 2014-12-10 | ALI | Futures | 2942.18 | 2942.18 | 2942.18 | 2942.18 | 0.0 |
| 2014-12-10 | B | Futures | 68.75 | 68.96 | 65.95 | 66.71 | 200468.0 |
| 2014-12-10 | B6 | Futures | 1.6464 | 1.6518 | 1.6442 | 1.6501 | 73990.0 |
| 2014-12-10 | BR | Futures | 0.20772 | 0.20836 | 0.20659 | 0.20659 | 13.0 |
| 2014-12-10 | BZ | Futures | 69.13 | 69.53 | 66.55 | 67.3 | 21885.0 |
| 2014-12-10 | C | Futures | 2129.0 | 2131.0 | 2113.0 | 2115.0 | 6151.0 |
| 2014-12-10 | CB | Futures | 136.781 | 137.561 | 136.781 | 137.561 | 11.0 |
| 2014-12-10 | CC | Futures | 2176.0 | 2184.0 | 2157.0 | 2164.0 | 7932.0 |
| 2014-12-10 | CNH | Futures | 7.0963 | 7.0963 | 7.0908 | 7.0908 | 2.0 |
| 2014-12-10 | CSC | Futures | 4.688 | 4.702 | 4.637 | 4.66 | 73.0 |
| 2014-12-10 | CT | Futures | 76.29 | 77.65 | 75.88 | 76.08 | 16859.0 |
| 2014-12-10 | DC | Futures | 37.05 | 37.49 | 36.68 | 36.72 | 331.0 |
| 2014-12-10 | DX | Futures | 84.193 | 84.311 | 83.71 | 83.807 | 28314.0 |
| 2014-12-10 | E1 | Futures | 1.31676 | 1.32302 | 1.31497 | 1.32161 | 17878.0 |
| 2014-12-10 | E6 | Futures | 1.45703 | 1.46502 | 1.45503 | 1.46432 | 114993.0 |
| 2014-12-10 | E7 | Futures | 1.4479 | 1.4563 | 1.4463 | 1.4556 | 4629.0 |
| 2014-12-10 | EBM | Futures | 300.89 | 301.7 | 298.05 | 298.87 | 16989.0 |
| 2014-12-10 | ED | Futures | 95.4402 | 95.4498 | 95.4354 | 95.445 | 162670.0 |
| 2014-12-10 | ER | Futures | 98.004 | 98.009 | 97.994 | 97.999 | 87006.0 |
| 2014-12-10 | EW | Futures | 1500.0 | 1501.4 | 1472.0 | 1475.3 | 5314.0 |
| 2014-12-10 | FBTP | Futures | 97.56 | 97.78 | 97.18 | 97.56 | 84816.0 |
| 2014-12-10 | FBTS | Futures | 98.615 | 98.615 | 98.464 | 98.508 | 20775.0 |
| 2014-12-10 | FCE | Futures | 3479.8 | 3487.1 | 3398.0 | 3424.3 | 119257.0 |
| 2014-12-10 | FDAX | Futures | 10828.5 | 10860.3 | 10664.2 | 10751.3 | 132001.0 |
| 2014-12-10 | FESX | Futures | 2295.5 | 2300.6 | 2248.7 | 2268.1 | 291799.0 |
| 2014-12-10 | FGBL | Futures | 134.69 | 135.04 | 134.68 | 134.81 | 515533.0 |
| 2014-12-10 | FGBM | Futures | 123.28 | 123.32 | 123.24 | 123.27 | 252953.0 |
| 2014-12-10 | FGBS | Futures | 110.848 | 110.853 | 110.828 | 110.833 | 169695.0 |
| 2014-12-10 | FGBX | Futures | 150.58 | 151.86 | 150.52 | 151.32 | 21727.0 |
| 2014-12-10 | FMWO | Futures | 5720.0 | 5723.8 | 5684.9 | 5684.9 | 868.0 |
| 2014-12-10 | FOAT | Futures | 124.31 | 124.51 | 124.27 | 124.44 | 51147.0 |
| 2014-12-10 | FTDX | Futures | 1271.7 | 1275.4 | 1256.2 | 1267.5 | 4.0 |
| 2014-12-10 | FTI | Futures | 364.07 | 364.94 | 359.05 | 361.17 | 391.0 |
| 2014-12-10 | FTUK | Futures | 5058.6 | 5068.8 | 4997.0 | 5030.6 | 16040.0 |
| 2014-12-10 | FVSA | Futures | 1648.29 | 1771.36 | 1626.31 | 1736.2 | 12003.0 |
| 2014-12-10 | FXXP | Futures | 258.7 | 258.7 | 255.1 | 255.5 | 4479.0 |
| 2014-12-10 | G | Futures | 101.9 | 101.91 | 101.42 | 101.57 | 153272.0 |
| 2014-12-10 | GF | Futures | 373.043 | 373.164 | 368.671 | 371.599 | 4428.0 |
| 2014-12-10 | GSCI | Futures | 788.46 | 788.46 | 775.33 | 779.0 | 2720.0 |
| 2014-12-10 | HE | Futures | 114.167 | 115.274 | 112.859 | 113.429 | 12877.0 |
| 2014-12-10 | HG | Futures | 3.7118 | 3.7181 | 3.6673 | 3.6749 | 30772.0 |
| 2014-12-10 | HH | Futures | 43.926 | 44.862 | 43.721 | 44.514 | 2648.0 |
> showing 50 of 103 rows — these rows as CSV