PREVIEW / futures_daily / 2014-11-25
file: by_date/futures_daily/2014/2014-11-25.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-11-25 | ES | Futures | 2159.42 | 2165.43 | 2154.72 | 2159.68 | 977855.0 |
| 2014-11-25 | NQ | Futures | 4962.73 | 4987.36 | 4956.65 | 4974.9 | 169153.0 |
| 2014-11-25 | YM | Futures | 18050.4 | 18093.0 | 18021.0 | 18066.6 | 79840.0 |
| 2014-11-25 | CL | Futures | 145.56 | 147.63 | 142.09 | 142.83 | 294447.0 |
| 2014-11-25 | GC | Futures | 1568.3 | 1574.6 | 1557.6 | 1567.8 | 127833.0 |
| 2014-11-25 | ZN | Futures | 118.817612 | 119.169057 | 118.729751 | 119.13977 | 2740779.0 |
| 2014-11-25 | A6 | Futures | 0.83584 | 0.83633 | 0.82622 | 0.8269 | 128602.0 |
| 2014-11-25 | AD | Futures | 0.89996 | 0.90392 | 0.89711 | 0.90209 | 58866.0 |
| 2014-11-25 | ALI | Futures | 3073.68 | 3073.68 | 3073.68 | 3073.68 | 52.0 |
| 2014-11-25 | B | Futures | 82.38 | 83.55 | 81.09 | 81.38 | 124186.0 |
| 2014-11-25 | B6 | Futures | 1.6502 | 1.6539 | 1.6447 | 1.6509 | 72109.0 |
| 2014-11-25 | BFX | Futures | 3928.4 | 3958.8 | 3928.4 | 3942.9 | 35.0 |
| 2014-11-25 | BR | Futures | 0.21272 | 0.21272 | 0.21073 | 0.21073 | 1379.0 |
| 2014-11-25 | BZ | Futures | 83.22 | 84.29 | 81.81 | 82.1 | 13715.0 |
| 2014-11-25 | C | Futures | 2044.0 | 2050.0 | 2016.0 | 2018.0 | 6376.0 |
| 2014-11-25 | CB | Futures | 138.013 | 138.013 | 137.192 | 137.192 | 4.0 |
| 2014-11-25 | CC | Futures | 2117.0 | 2122.0 | 2072.0 | 2084.0 | 12848.0 |
| 2014-11-25 | CNH | Futures | 7.0545 | 7.0545 | 7.0528 | 7.0528 | 1.0 |
| 2014-11-25 | CSC | Futures | 4.859 | 4.881 | 4.83 | 4.83 | 73.0 |
| 2014-11-25 | CT | Futures | 75.11 | 76.13 | 74.98 | 75.75 | 10402.0 |
| 2014-11-25 | DC | Futures | 39.18 | 39.27 | 38.94 | 38.94 | 68.0 |
| 2014-11-25 | DX | Futures | 83.75 | 83.916 | 83.413 | 83.5 | 33882.0 |
| 2014-11-25 | E1 | Futures | 1.32277 | 1.3275 | 1.31868 | 1.32584 | 35009.0 |
| 2014-11-25 | E6 | Futures | 1.46444 | 1.47009 | 1.45997 | 1.46821 | 206182.0 |
| 2014-11-25 | E7 | Futures | 1.455 | 1.4607 | 1.4508 | 1.459 | 3518.0 |
| 2014-11-25 | ED | Futures | 95.4398 | 95.4422 | 95.4374 | 95.4398 | 88142.0 |
| 2014-11-25 | ER | Futures | 97.999 | 98.004 | 97.994 | 97.999 | 35885.0 |
| 2014-11-25 | EW | Futures | 1513.9 | 1519.9 | 1508.1 | 1514.9 | 9284.0 |
| 2014-11-25 | FBTP | Futures | 97.01 | 97.28 | 96.97 | 97.24 | 50817.0 |
| 2014-11-25 | FBTS | Futures | 98.774 | 98.837 | 98.766 | 98.801 | 14795.0 |
| 2014-11-25 | FCE | Futures | 3543.1 | 3562.9 | 3528.1 | 3544.3 | 91544.0 |
| 2014-11-25 | FDAX | Futures | 10757.3 | 10872.3 | 10719.0 | 10786.3 | 107958.0 |
| 2014-11-25 | FESX | Futures | 2331.0 | 2351.3 | 2319.4 | 2330.3 | 1051318.0 |
| 2014-11-25 | FGBL | Futures | 133.9 | 134.29 | 133.86 | 134.19 | 574522.0 |
| 2014-11-25 | FGBM | Futures | 123.22 | 123.27 | 123.19 | 123.25 | 319640.0 |
| 2014-11-25 | FGBS | Futures | 110.863 | 110.878 | 110.853 | 110.863 | 196510.0 |
| 2014-11-25 | FGBX | Futures | 147.0 | 148.21 | 146.9 | 147.77 | 24091.0 |
| 2014-11-25 | FMWO | Futures | 5806.5 | 5812.8 | 5792.7 | 5792.7 | 957.0 |
| 2014-11-25 | FOAT | Futures | 123.54 | 123.92 | 123.49 | 123.9 | 50281.0 |
| 2014-11-25 | FTDX | Futures | 1269.8 | 1273.6 | 1264.1 | 1265.1 | 230.0 |
| 2014-11-25 | FTI | Futures | 368.64 | 370.29 | 366.55 | 367.9 | 28286.0 |
| 2014-11-25 | FTUK | Futures | 5201.3 | 5221.0 | 5184.3 | 5188.5 | 79938.0 |
| 2014-11-25 | FVSA | Futures | 1560.38 | 1569.17 | 1534.01 | 1555.98 | 8095.0 |
| 2014-11-25 | FXXP | Futures | 262.7 | 264.3 | 262.0 | 262.6 | 10372.0 |
| 2014-11-25 | G | Futures | 100.57 | 100.82 | 100.42 | 100.68 | 268108.0 |
| 2014-11-25 | GF | Futures | 372.482 | 373.485 | 369.634 | 371.238 | 4481.0 |
| 2014-11-25 | GSCI | Futures | 884.5 | 884.5 | 870.99 | 872.59 | 139.0 |
| 2014-11-25 | HE | Futures | 121.847 | 122.719 | 119.734 | 120.506 | 15182.0 |
| 2014-11-25 | HG | Futures | 3.8191 | 3.842 | 3.7601 | 3.7823 | 53383.0 |
| 2014-11-25 | HH | Futures | 50.988 | 52.886 | 50.772 | 52.886 | 1223.0 |
> showing 50 of 105 rows — these rows as CSV