PREVIEW / futures_daily / 2012-02-07
file: by_date/futures_daily/2012/2012-02-07.parquet size: 9 KB rows: 99
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 |
|---|---|---|---|---|---|---|---|
| 2012-02-07 | ES | Futures | 1343.78 | 1350.55 | 1336.5 | 1349.55 | 1498861.0 |
| 2012-02-07 | NQ | Futures | 2887.3 | 2898.73 | 2872.43 | 2892.44 | 176247.0 |
| 2012-02-07 | YM | Futures | 12355.3 | 12427.9 | 12309.9 | 12408.5 | 82689.0 |
| 2012-02-07 | CL | Futures | 181.53 | 185.27 | 179.12 | 183.92 | 415728.0 |
| 2012-02-07 | GC | Futures | 2306.6 | 2347.0 | 2293.4 | 2341.3 | 161623.0 |
| 2012-02-07 | ZN | Futures | 113.718859 | 113.799875 | 113.165253 | 113.340786 | 1038564.0 |
| 2012-02-07 | A6 | Futures | 0.94964 | 0.95863 | 0.94804 | 0.95596 | 117837.0 |
| 2012-02-07 | AD | Futures | 1.00683 | 1.00874 | 1.00312 | 1.00734 | 75404.0 |
| 2012-02-07 | B | Futures | 103.62 | 104.28 | 102.63 | 103.14 | 153145.0 |
| 2012-02-07 | B6 | Futures | 1.6536 | 1.6622 | 1.65 | 1.6612 | 86747.0 |
| 2012-02-07 | BFX | Futures | 2739.8 | 2748.8 | 2737.3 | 2748.8 | 33.0 |
| 2012-02-07 | BR | Futures | 0.26929 | 0.27081 | 0.26929 | 0.27065 | 186.0 |
| 2012-02-07 | BZ | Futures | 110.26 | 110.95 | 109.38 | 109.91 | 1603.0 |
| 2012-02-07 | C | Futures | 1493.0 | 1509.0 | 1485.0 | 1501.0 | 4120.0 |
| 2012-02-07 | CB | Futures | 80.331 | 80.331 | 79.927 | 79.927 | 20.0 |
| 2012-02-07 | CC | Futures | 1745.0 | 1752.0 | 1717.0 | 1743.0 | 14108.0 |
| 2012-02-07 | CSC | Futures | 3.791 | 3.791 | 3.749 | 3.754 | 43.0 |
| 2012-02-07 | CT | Futures | 124.04 | 124.84 | 121.52 | 121.8 | 14597.0 |
| 2012-02-07 | DC | Futures | 26.6 | 26.77 | 25.98 | 26.2 | 238.0 |
| 2012-02-07 | DX | Futures | 77.087 | 77.252 | 76.473 | 76.576 | 34344.0 |
| 2012-02-07 | E1 | Futures | 1.4284 | 1.44179 | 1.42315 | 1.43904 | 34507.0 |
| 2012-02-07 | E6 | Futures | 1.56895 | 1.58736 | 1.56477 | 1.58353 | 383182.0 |
| 2012-02-07 | E7 | Futures | 1.5546 | 1.572 | 1.5506 | 1.5691 | 5862.0 |
| 2012-02-07 | EBM | Futures | 290.9 | 292.54 | 285.66 | 290.24 | 14026.0 |
| 2012-02-07 | ED | Futures | 95.1059 | 95.1154 | 95.0963 | 95.1059 | 151868.0 |
| 2012-02-07 | ER | Futures | 97.459 | 97.469 | 97.43 | 97.459 | 76516.0 |
| 2012-02-07 | EW | Futures | 973.8 | 979.6 | 969.1 | 978.8 | 16269.0 |
| 2012-02-07 | FBTP | Futures | 64.58 | 65.22 | 64.12 | 64.77 | 11379.0 |
| 2012-02-07 | FBTS | Futures | 84.448 | 84.545 | 84.296 | 84.473 | 736.0 |
| 2012-02-07 | FCE | Futures | 2420.0 | 2436.0 | 2405.0 | 2429.6 | 85346.0 |
| 2012-02-07 | FDAX | Futures | 7459.1 | 7501.0 | 7382.9 | 7464.1 | 142195.0 |
| 2012-02-07 | FESX | Futures | 1674.1 | 1685.4 | 1661.4 | 1680.7 | 932928.0 |
| 2012-02-07 | FEU3 | Futures | 98.019 | 98.019 | 98.014 | 98.014 | 200.0 |
| 2012-02-07 | FGBL | Futures | 112.35 | 112.59 | 111.54 | 111.64 | 812768.0 |
| 2012-02-07 | FGBM | Futures | 113.33 | 113.45 | 112.92 | 112.98 | 461202.0 |
| 2012-02-07 | FGBS | Futures | 109.899 | 109.929 | 109.825 | 109.849 | 343281.0 |
| 2012-02-07 | FGBX | Futures | 117.1 | 117.55 | 115.34 | 115.55 | 8073.0 |
| 2012-02-07 | FTDX | Futures | 711.6 | 711.6 | 705.0 | 710.2 | 101.0 |
| 2012-02-07 | FTI | Futures | 270.81 | 272.23 | 269.84 | 271.98 | 28525.0 |
| 2012-02-07 | FTUK | Futures | 4225.6 | 4229.2 | 4188.4 | 4213.7 | 88375.0 |
| 2012-02-07 | FVSA | Futures | 9795.21 | 10044.89 | 9776.01 | 9872.04 | 2646.0 |
| 2012-02-07 | FXXP | Futures | 186.6 | 186.6 | 184.4 | 185.8 | 4672.0 |
| 2012-02-07 | G | Futures | 93.62 | 93.92 | 93.15 | 93.23 | 144542.0 |
| 2012-02-07 | GF | Futures | 327.014 | 329.559 | 326.696 | 328.711 | 3842.0 |
| 2012-02-07 | GSCI | Futures | 1042.86 | 1056.62 | 1042.78 | 1052.87 | 1379.0 |
| 2012-02-07 | HE | Futures | 106.8 | 107.797 | 106.679 | 107.676 | 16971.0 |
| 2012-02-07 | HG | Futures | 5.1144 | 5.119 | 5.0043 | 5.1124 | 60700.0 |
| 2012-02-07 | HO | Futures | 2.5797 | 2.6065 | 2.566 | 2.5823 | 86416.0 |
| 2012-02-07 | HRC | Futures | 2837.4 | 2837.4 | 2837.4 | 2837.4 | 0.0 |
| 2012-02-07 | J1 | Futures | 0.016405 | 0.0164151 | 0.0163197 | 0.0163661 | 77189.0 |
> showing 50 of 99 rows — these rows as CSV