PREVIEW / futures_daily / 2012-02-17
file: by_date/futures_daily/2012/2012-02-17.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-17 | ES | Futures | 1359.58 | 1366.1 | 1357.83 | 1364.6 | 1250939.0 |
| 2012-02-17 | NQ | Futures | 2966.2 | 2970.49 | 2941.33 | 2952.77 | 216108.0 |
| 2012-02-17 | YM | Futures | 12446.3 | 12518.8 | 12436.6 | 12503.3 | 80405.0 |
| 2012-02-17 | CL | Futures | 190.15 | 193.59 | 189.98 | 191.93 | 238124.0 |
| 2012-02-17 | GC | Futures | 2317.2 | 2326.7 | 2301.4 | 2311.2 | 116795.0 |
| 2012-02-17 | ZN | Futures | 113.232766 | 113.273273 | 112.854693 | 113.138248 | 850831.0 |
| 2012-02-17 | A6 | Futures | 0.95338 | 0.95792 | 0.94804 | 0.95071 | 102151.0 |
| 2012-02-17 | AD | Futures | 1.00673 | 1.00914 | 1.00463 | 1.00714 | 73895.0 |
| 2012-02-17 | B | Futures | 106.99 | 107.5 | 105.85 | 106.5 | 175525.0 |
| 2012-02-17 | B6 | Futures | 1.6514 | 1.6579 | 1.6502 | 1.6556 | 86835.0 |
| 2012-02-17 | BFX | Futures | 2790.9 | 2794.2 | 2788.8 | 2789.9 | 80.0 |
| 2012-02-17 | BR | Futures | 0.27271 | 0.27271 | 0.2725 | 0.2725 | 274.0 |
| 2012-02-17 | BZ | Futures | 114.18 | 114.44 | 112.81 | 113.5 | 815.0 |
| 2012-02-17 | C | Futures | 1544.0 | 1546.0 | 1517.0 | 1523.0 | 1405.0 |
| 2012-02-17 | CB | Futures | 78.851 | 79.12 | 78.851 | 78.851 | 6.0 |
| 2012-02-17 | CC | Futures | 1812.0 | 1819.0 | 1763.0 | 1784.0 | 9881.0 |
| 2012-02-17 | CSC | Futures | 3.72 | 3.761 | 3.72 | 3.752 | 27.0 |
| 2012-02-17 | CT | Futures | 119.07 | 120.13 | 117.6 | 117.78 | 6797.0 |
| 2012-02-17 | DC | Futures | 26.18 | 26.41 | 25.96 | 26.31 | 224.0 |
| 2012-02-17 | DX | Futures | 77.364 | 77.471 | 77.14 | 77.336 | 24236.0 |
| 2012-02-17 | E1 | Futures | 1.42853 | 1.43352 | 1.42604 | 1.42945 | 31834.0 |
| 2012-02-17 | E6 | Futures | 1.56991 | 1.57768 | 1.56776 | 1.5729 | 232493.0 |
| 2012-02-17 | E7 | Futures | 1.5552 | 1.5633 | 1.5535 | 1.5585 | 4145.0 |
| 2012-02-17 | EBM | Futures | 280.09 | 285.33 | 278.78 | 284.68 | 6007.0 |
| 2012-02-17 | ED | Futures | 95.082 | 95.0916 | 95.0677 | 95.082 | 177971.0 |
| 2012-02-17 | ER | Futures | 97.42 | 97.435 | 97.415 | 97.42 | 40866.0 |
| 2012-02-17 | EW | Futures | 990.9 | 997.8 | 989.1 | 991.6 | 12678.0 |
| 2012-02-17 | FBTP | Futures | 64.78 | 65.26 | 64.52 | 64.93 | 11060.0 |
| 2012-02-17 | FBTS | Futures | 84.32 | 84.44 | 84.176 | 84.336 | 1455.0 |
| 2012-02-17 | FCE | Futures | 2417.0 | 2438.5 | 2415.6 | 2428.6 | 110214.0 |
| 2012-02-17 | FDAX | Futures | 7502.2 | 7596.6 | 7502.2 | 7556.3 | 134469.0 |
| 2012-02-17 | FESX | Futures | 1677.4 | 1693.4 | 1676.1 | 1684.8 | 1126268.0 |
| 2012-02-17 | FGBL | Futures | 112.32 | 112.37 | 111.82 | 112.02 | 551820.0 |
| 2012-02-17 | FGBM | Futures | 113.23 | 113.3 | 113.01 | 113.1 | 307938.0 |
| 2012-02-17 | FGBS | Futures | 109.805 | 109.83 | 109.775 | 109.795 | 237187.0 |
| 2012-02-17 | FGBX | Futures | 117.25 | 117.38 | 116.36 | 116.7 | 6678.0 |
| 2012-02-17 | FTDX | Futures | 720.8 | 723.6 | 719.0 | 720.4 | 194.0 |
| 2012-02-17 | FTI | Futures | 275.01 | 278.2 | 274.75 | 275.81 | 39432.0 |
| 2012-02-17 | FTUK | Futures | 4247.2 | 4258.4 | 4236.1 | 4242.5 | 75468.0 |
| 2012-02-17 | FVSA | Futures | 10889.16 | 10889.16 | 10490.08 | 10699.12 | 4808.0 |
| 2012-02-17 | FXXP | Futures | 187.5 | 188.2 | 187.3 | 187.7 | 1670.0 |
| 2012-02-17 | G | Futures | 93.71 | 93.81 | 93.22 | 93.47 | 121161.0 |
| 2012-02-17 | GF | Futures | 332.952 | 337.3 | 332.899 | 335.974 | 3374.0 |
| 2012-02-17 | GSCI | Futures | 1083.53 | 1086.21 | 1080.06 | 1085.89 | 147.0 |
| 2012-02-17 | HE | Futures | 108.734 | 109.58 | 108.401 | 109.217 | 13187.0 |
| 2012-02-17 | HG | Futures | 5.0003 | 5.0337 | 4.8541 | 4.8718 | 13070.0 |
| 2012-02-17 | HO | Futures | 2.6026 | 2.606 | 2.5829 | 2.5937 | 13677.0 |
| 2012-02-17 | HRC | Futures | 2731.0 | 2731.0 | 2731.0 | 2731.0 | 0.0 |
| 2012-02-17 | J1 | Futures | 0.0159191 | 0.0159392 | 0.0157735 | 0.0158074 | 88465.0 |
| 2012-02-17 | J7 | Futures | 0.015866 | 0.015866 | 0.015711 | 0.015742 | 394.0 |
> showing 50 of 99 rows — these rows as CSV