PREVIEW / futures_daily / 2013-12-31
file: by_date/futures_daily/2013/2013-12-31.parquet size: 9 KB rows: 90
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 |
|---|---|---|---|---|---|---|---|
| 2013-12-31 | ES | Futures | 1892.14 | 1903.48 | 1890.85 | 1897.81 | 653055.0 |
| 2013-12-31 | NQ | Futures | 4100.07 | 4132.55 | 4098.35 | 4119.91 | 71635.0 |
| 2013-12-31 | YM | Futures | 16419.1 | 16513.9 | 16410.1 | 16468.0 | 38314.0 |
| 2013-12-31 | CL | Futures | 175.21 | 175.46 | 173.27 | 173.75 | 113907.0 |
| 2013-12-31 | GC | Futures | 1585.4 | 1607.4 | 1564.2 | 1591.9 | 123138.0 |
| 2013-12-31 | ZN | Futures | 112.845977 | 112.8889 | 112.416741 | 112.674282 | 351455.0 |
| 2013-12-31 | A6 | Futures | 0.84424 | 0.84901 | 0.84415 | 0.84644 | 32310.0 |
| 2013-12-31 | AD | Futures | 0.94893 | 0.95258 | 0.94843 | 0.95106 | 28362.0 |
| 2013-12-31 | B | Futures | 113.05 | 113.28 | 112.16 | 112.55 | 40007.0 |
| 2013-12-31 | B6 | Futures | 1.7318 | 1.7409 | 1.7297 | 1.7394 | 39433.0 |
| 2013-12-31 | BFX | Futures | 3527.1 | 3536.6 | 3517.3 | 3536.6 | 67.0 |
| 2013-12-31 | BR | Futures | 0.21616 | 0.21616 | 0.21616 | 0.21616 | 74.0 |
| 2013-12-31 | BZ | Futures | 115.36 | 115.51 | 114.41 | 114.79 | 2618.0 |
| 2013-12-31 | C | Futures | 1811.0 | 1830.0 | 1809.0 | 1826.0 | 4499.0 |
| 2013-12-31 | CB | Futures | 78.557 | 79.489 | 78.14 | 78.999 | 37.0 |
| 2013-12-31 | CC | Futures | 2013.0 | 2025.0 | 2006.0 | 2011.0 | 7470.0 |
| 2013-12-31 | CNH | Futures | 6.9852 | 6.987 | 6.9789 | 6.987 | 70.0 |
| 2013-12-31 | CSC | Futures | 3.733 | 3.733 | 3.693 | 3.725 | 15.0 |
| 2013-12-31 | CT | Futures | 96.3 | 97.25 | 96.23 | 96.51 | 9252.0 |
| 2013-12-31 | DC | Futures | 28.72 | 28.83 | 28.38 | 28.72 | 282.0 |
| 2013-12-31 | DX | Futures | 76.176 | 76.409 | 76.162 | 76.256 | 6602.0 |
| 2013-12-31 | E1 | Futures | 1.44623 | 1.44867 | 1.43763 | 1.44507 | 17167.0 |
| 2013-12-31 | E6 | Futures | 1.62856 | 1.63045 | 1.62218 | 1.62761 | 64841.0 |
| 2013-12-31 | E7 | Futures | 1.6183 | 1.6197 | 1.6116 | 1.617 | 3995.0 |
| 2013-12-31 | EBM | Futures | 284.7 | 285.4 | 284.01 | 284.7 | 3780.0 |
| 2013-12-31 | ED | Futures | 95.3519 | 95.3519 | 95.3423 | 95.3471 | 41715.0 |
| 2013-12-31 | ER | Futures | 97.867 | 97.876 | 97.857 | 97.862 | 19458.0 |
| 2013-12-31 | EW | Futures | 1365.1 | 1372.2 | 1364.3 | 1368.1 | 11271.0 |
| 2013-12-31 | FCE | Futures | 3343.3 | 3352.3 | 3339.0 | 3349.9 | 15141.0 |
| 2013-12-31 | FTI | Futures | 344.15 | 345.78 | 344.15 | 345.52 | 2699.0 |
| 2013-12-31 | FTUK | Futures | 5065.7 | 5077.9 | 5060.5 | 5069.5 | 17604.0 |
| 2013-12-31 | G | Futures | 90.0 | 90.2 | 89.89 | 90.14 | 22594.0 |
| 2013-12-31 | GF | Futures | 269.173 | 269.736 | 268.126 | 268.368 | 897.0 |
| 2013-12-31 | GSCI | Futures | 1045.66 | 1046.9 | 1043.84 | 1046.07 | 1240.0 |
| 2013-12-31 | HE | Futures | 102.807 | 103.622 | 102.233 | 103.169 | 12817.0 |
| 2013-12-31 | HG | Futures | 4.2671 | 4.3044 | 4.2519 | 4.2898 | 28532.0 |
| 2013-12-31 | HH | Futures | 43.447 | 43.547 | 42.295 | 42.375 | 1170.0 |
| 2013-12-31 | HO | Futures | 2.4336 | 2.4469 | 2.4328 | 2.4414 | 11879.0 |
| 2013-12-31 | HRC | Futures | 2403.0 | 2403.0 | 2403.0 | 2403.0 | 0.0 |
| 2013-12-31 | J1 | Futures | 0.0119789 | 0.0120041 | 0.0119474 | 0.0119575 | 35832.0 |
| 2013-12-31 | J7 | Futures | 0.011969 | 0.011994 | 0.011942 | 0.011949 | 252.0 |
| 2013-12-31 | JB | Futures | 128.51 | 128.55 | 128.31 | 128.35 | 439.0 |
| 2013-12-31 | KC | Futures | 213.77 | 214.23 | 206.21 | 206.49 | 11340.0 |
| 2013-12-31 | KE | Futures | 2054.69 | 2078.12 | 2044.99 | 2070.04 | 8420.0 |
| 2013-12-31 | L | Futures | 98.841 | 98.841 | 98.821 | 98.836 | 15573.0 |
| 2013-12-31 | LBS | Futures | 599.1 | 602.0 | 589.2 | 591.0 | 180.0 |
| 2013-12-31 | LE | Futures | 160.098 | 160.661 | 159.505 | 159.535 | 16619.0 |
| 2013-12-31 | MFS | Futures | 1779.0 | 1792.4 | 1779.0 | 1783.3 | 8061.0 |
| 2013-12-31 | MGC | Futures | 1554.2 | 1575.0 | 1533.1 | 1559.9 | 2565.0 |
| 2013-12-31 | MME | Futures | 941.1 | 950.7 | 940.3 | 949.4 | 12610.0 |
> showing 50 of 90 rows — these rows as CSV