PREVIEW / futures_daily / 2014-12-03
file: by_date/futures_daily/2014/2014-12-03.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-12-03 | ES | Futures | 2158.64 | 2168.56 | 2155.24 | 2164.9 | 925314.0 |
| 2014-12-03 | NQ | Futures | 4992.87 | 5006.78 | 4969.11 | 4995.77 | 190809.0 |
| 2014-12-03 | YM | Futures | 18126.5 | 18177.2 | 18099.1 | 18156.9 | 84779.0 |
| 2014-12-03 | CL | Futures | 130.31 | 131.53 | 128.77 | 129.89 | 293483.0 |
| 2014-12-03 | GC | Futures | 1567.6 | 1590.3 | 1562.2 | 1582.1 | 145106.0 |
| 2014-12-03 | ZN | Futures | 118.949404 | 119.037265 | 118.802969 | 118.920117 | 82930.0 |
| 2014-12-03 | A6 | Futures | 0.8202 | 0.82224 | 0.81446 | 0.81582 | 104308.0 |
| 2014-12-03 | AD | Futures | 0.89041 | 0.89508 | 0.88939 | 0.89356 | 59642.0 |
| 2014-12-03 | ALI | Futures | 2947.9 | 2947.9 | 2947.9 | 2947.9 | 0.0 |
| 2014-12-03 | B | Futures | 73.81 | 74.3 | 72.32 | 72.75 | 150041.0 |
| 2014-12-03 | B6 | Futures | 1.6437 | 1.6523 | 1.6415 | 1.6486 | 87802.0 |
| 2014-12-03 | BFX | Futures | 3977.6 | 3995.8 | 3977.6 | 3989.7 | 10.0 |
| 2014-12-03 | BR | Futures | 0.21029 | 0.21098 | 0.21029 | 0.2109 | 32.0 |
| 2014-12-03 | BZ | Futures | 74.63 | 74.95 | 72.95 | 73.4 | 20993.0 |
| 2014-12-03 | C | Futures | 2077.0 | 2079.0 | 2061.0 | 2064.0 | 2009.0 |
| 2014-12-03 | CB | Futures | 138.835 | 140.067 | 138.835 | 140.067 | 13.0 |
| 2014-12-03 | CC | Futures | 2109.0 | 2117.0 | 2099.0 | 2105.0 | 6228.0 |
| 2014-12-03 | CNH | Futures | 7.0579 | 7.0579 | 7.053 | 7.053 | 3.0 |
| 2014-12-03 | CSC | Futures | 4.688 | 4.694 | 4.646 | 4.691 | 128.0 |
| 2014-12-03 | CT | Futures | 75.6 | 76.95 | 75.49 | 76.17 | 11613.0 |
| 2014-12-03 | DC | Futures | 37.63 | 37.63 | 37.07 | 37.47 | 157.0 |
| 2014-12-03 | DX | Futures | 84.177 | 84.542 | 84.134 | 84.479 | 34681.0 |
| 2014-12-03 | E1 | Futures | 1.31561 | 1.31625 | 1.30704 | 1.30781 | 44097.0 |
| 2014-12-03 | E6 | Futures | 1.45773 | 1.45867 | 1.44808 | 1.44914 | 254613.0 |
| 2014-12-03 | E7 | Futures | 1.4489 | 1.4496 | 1.439 | 1.44 | 3676.0 |
| 2014-12-03 | ED | Futures | 95.4398 | 95.4422 | 95.4374 | 95.4398 | 127773.0 |
| 2014-12-03 | ER | Futures | 98.004 | 98.014 | 98.004 | 98.009 | 41458.0 |
| 2014-12-03 | EW | Futures | 1493.2 | 1507.3 | 1489.6 | 1503.9 | 12107.0 |
| 2014-12-03 | FBTP | Futures | 97.97 | 98.36 | 97.95 | 98.2 | 151257.0 |
| 2014-12-03 | FBTS | Futures | 98.757 | 98.863 | 98.739 | 98.801 | 33772.0 |
| 2014-12-03 | FCE | Futures | 3551.6 | 3565.8 | 3543.5 | 3553.6 | 69783.0 |
| 2014-12-03 | FDAX | Futures | 10914.0 | 10954.5 | 10880.5 | 10937.0 | 78196.0 |
| 2014-12-03 | FESX | Futures | 2347.0 | 2358.5 | 2340.4 | 2352.8 | 781939.0 |
| 2014-12-03 | FGBL | Futures | 134.13 | 134.3 | 133.99 | 134.16 | 1279325.0 |
| 2014-12-03 | FGBM | Futures | 123.13 | 123.31 | 123.11 | 123.25 | 947288.0 |
| 2014-12-03 | FGBS | Futures | 110.843 | 110.873 | 110.838 | 110.863 | 530545.0 |
| 2014-12-03 | FGBX | Futures | 148.47 | 149.11 | 147.91 | 148.31 | 65220.0 |
| 2014-12-03 | FMWO | Futures | 5775.2 | 5795.2 | 5775.2 | 5791.5 | 190.0 |
| 2014-12-03 | FOAT | Futures | 124.07 | 124.31 | 124.03 | 124.17 | 127571.0 |
| 2014-12-03 | FTDX | Futures | 1270.7 | 1296.3 | 1270.7 | 1291.5 | 324.0 |
| 2014-12-03 | FTI | Futures | 372.59 | 373.94 | 372.33 | 372.63 | 23704.0 |
| 2014-12-03 | FTUK | Futures | 5207.1 | 5224.5 | 5191.2 | 5199.0 | 73054.0 |
| 2014-12-03 | FVSA | Futures | 1547.19 | 1547.19 | 1498.84 | 1498.84 | 9733.0 |
| 2014-12-03 | FXXP | Futures | 263.9 | 265.7 | 263.6 | 265.4 | 13267.0 |
| 2014-12-03 | G | Futures | 101.0 | 101.3 | 100.64 | 100.72 | 212521.0 |
| 2014-12-03 | GF | Futures | 378.298 | 378.338 | 373.886 | 376.774 | 5641.0 |
| 2014-12-03 | GSCI | Futures | 812.45 | 818.36 | 807.38 | 809.83 | 270.0 |
| 2014-12-03 | HE | Futures | 118.359 | 119.131 | 116.112 | 116.548 | 17674.0 |
| 2014-12-03 | HG | Futures | 3.668 | 3.6794 | 3.6337 | 3.6483 | 34501.0 |
| 2014-12-03 | HH | Futures | 45.775 | 45.943 | 45.115 | 45.703 | 1128.0 |
> showing 50 of 105 rows — these rows as CSV