PREVIEW / futures_daily / 2012-02-14
file: by_date/futures_daily/2012/2012-02-14.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-14 | ES | Futures | 1354.06 | 1356.82 | 1342.52 | 1352.56 | 1739688.0 |
| 2012-02-14 | NQ | Futures | 2938.47 | 2947.62 | 2919.89 | 2945.9 | 193336.0 |
| 2012-02-14 | YM | Futures | 12411.4 | 12433.7 | 12331.2 | 12417.2 | 105543.0 |
| 2012-02-14 | CL | Futures | 187.17 | 189.31 | 186.42 | 187.26 | 174492.0 |
| 2012-02-14 | GC | Futures | 2308.7 | 2316.6 | 2295.0 | 2300.2 | 148107.0 |
| 2012-02-14 | ZN | Futures | 113.46231 | 113.705357 | 113.286776 | 113.664849 | 1038863.0 |
| 2012-02-14 | A6 | Futures | 0.95053 | 0.95151 | 0.94226 | 0.94297 | 133027.0 |
| 2012-02-14 | AD | Futures | 1.00242 | 1.00503 | 1.00031 | 1.00131 | 82788.0 |
| 2012-02-14 | B | Futures | 104.61 | 105.01 | 103.79 | 104.52 | 212958.0 |
| 2012-02-14 | B6 | Futures | 1.6462 | 1.6483 | 1.6351 | 1.6363 | 109948.0 |
| 2012-02-14 | BFX | Futures | 2752.8 | 2768.0 | 2731.4 | 2731.8 | 1486.0 |
| 2012-02-14 | BR | Futures | 0.27149 | 0.27154 | 0.27011 | 0.27131 | 227.0 |
| 2012-02-14 | BZ | Futures | 110.91 | 111.76 | 110.61 | 111.38 | 815.0 |
| 2012-02-14 | C | Futures | 1459.0 | 1510.0 | 1446.0 | 1508.0 | 8301.0 |
| 2012-02-14 | CB | Futures | 79.658 | 79.658 | 79.658 | 79.658 | 6.0 |
| 2012-02-14 | CC | Futures | 1672.0 | 1767.0 | 1647.0 | 1727.0 | 18147.0 |
| 2012-02-14 | CSC | Futures | 3.732 | 3.732 | 3.708 | 3.708 | 4.0 |
| 2012-02-14 | CT | Futures | 117.78 | 118.93 | 117.2 | 118.81 | 11053.0 |
| 2012-02-14 | DC | Futures | 25.83 | 26.18 | 25.78 | 26.08 | 287.0 |
| 2012-02-14 | DX | Futures | 77.087 | 77.637 | 76.907 | 77.567 | 32448.0 |
| 2012-02-14 | E1 | Futures | 1.43208 | 1.43615 | 1.4225 | 1.42447 | 32109.0 |
| 2012-02-14 | E6 | Futures | 1.57481 | 1.57995 | 1.56345 | 1.56513 | 281658.0 |
| 2012-02-14 | E7 | Futures | 1.5607 | 1.5655 | 1.5493 | 1.5508 | 4913.0 |
| 2012-02-14 | EBM | Futures | 269.93 | 276.81 | 269.93 | 276.49 | 8515.0 |
| 2012-02-14 | ED | Futures | 95.0939 | 95.1059 | 95.0892 | 95.0987 | 158662.0 |
| 2012-02-14 | ER | Futures | 97.42 | 97.479 | 97.41 | 97.44 | 73014.0 |
| 2012-02-14 | EW | Futures | 979.7 | 981.7 | 972.7 | 980.3 | 20059.0 |
| 2012-02-14 | FBTP | Futures | 64.57 | 65.03 | 64.31 | 64.95 | 10815.0 |
| 2012-02-14 | FBTS | Futures | 84.312 | 84.521 | 84.312 | 84.376 | 3319.0 |
| 2012-02-14 | FCE | Futures | 2387.0 | 2401.4 | 2370.7 | 2384.1 | 111161.0 |
| 2012-02-14 | FDAX | Futures | 7423.2 | 7504.9 | 7392.3 | 7434.8 | 141099.0 |
| 2012-02-14 | FESX | Futures | 1660.7 | 1676.7 | 1652.7 | 1664.0 | 868022.0 |
| 2012-02-14 | FGBL | Futures | 112.07 | 112.28 | 111.59 | 112.1 | 739110.0 |
| 2012-02-14 | FGBM | Futures | 113.2 | 113.24 | 112.92 | 113.12 | 490525.0 |
| 2012-02-14 | FGBS | Futures | 109.82 | 109.84 | 109.755 | 109.8 | 368954.0 |
| 2012-02-14 | FGBX | Futures | 115.86 | 117.05 | 115.34 | 116.42 | 4392.0 |
| 2012-02-14 | FTDX | Futures | 717.6 | 725.0 | 714.3 | 717.6 | 125.0 |
| 2012-02-14 | FTI | Futures | 269.75 | 271.94 | 268.2 | 269.67 | 23133.0 |
| 2012-02-14 | FTUK | Futures | 4229.2 | 4238.6 | 4206.5 | 4223.8 | 94894.0 |
| 2012-02-14 | FVSA | Futures | 10661.12 | 10946.17 | 10490.08 | 10718.13 | 5543.0 |
| 2012-02-14 | FXXP | Futures | 185.1 | 186.2 | 184.6 | 185.3 | 2594.0 |
| 2012-02-14 | G | Futures | 93.71 | 94.29 | 93.65 | 94.13 | 140006.0 |
| 2012-02-14 | GF | Futures | 327.544 | 332.528 | 327.438 | 331.362 | 3536.0 |
| 2012-02-14 | GSCI | Futures | 1069.12 | 1073.37 | 1066.91 | 1068.17 | 341.0 |
| 2012-02-14 | HE | Futures | 106.589 | 108.401 | 106.347 | 108.311 | 17382.0 |
| 2012-02-14 | HG | Futures | 5.055 | 5.09 | 4.9911 | 5.0313 | 55831.0 |
| 2012-02-14 | HO | Futures | 2.5573 | 2.5775 | 2.5455 | 2.5612 | 55906.0 |
| 2012-02-14 | HRC | Futures | 2868.9 | 2868.9 | 2868.9 | 2868.9 | 0.0 |
| 2012-02-14 | J1 | Futures | 0.0161866 | 0.0162355 | 0.0159894 | 0.0160045 | 123919.0 |
| 2012-02-14 | J7 | Futures | 0.016156 | 0.016163 | 0.015926 | 0.015938 | 322.0 |
> showing 50 of 99 rows — these rows as CSV