PREVIEW / futures_daily / 2012-03-02
file: by_date/futures_daily/2012/2012-03-02.parquet size: 9 KB rows: 98
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-03-02 | ES | Futures | 1379.4 | 1381.91 | 1369.87 | 1373.63 | 1458860.0 |
| 2012-03-02 | NQ | Futures | 3024.24 | 3030.53 | 3010.8 | 3023.1 | 179764.0 |
| 2012-03-02 | YM | Futures | 12546.8 | 12566.2 | 12486.9 | 12541.0 | 88584.0 |
| 2012-03-02 | CL | Futures | 201.47 | 201.99 | 196.0 | 197.67 | 299664.0 |
| 2012-03-02 | GC | Futures | 2302.9 | 2310.5 | 2283.8 | 2289.6 | 147086.0 |
| 2012-03-02 | ZN | Futures | 113.165253 | 113.664849 | 113.09774 | 113.543325 | 111051.0 |
| 2012-03-02 | A6 | Futures | 0.96023 | 0.96104 | 0.95294 | 0.95392 | 95818.0 |
| 2012-03-02 | AD | Futures | 1.01818 | 1.01878 | 1.01376 | 1.01537 | 76234.0 |
| 2012-03-02 | B | Futures | 112.23 | 112.23 | 109.7 | 110.15 | 122555.0 |
| 2012-03-02 | B6 | Futures | 1.6677 | 1.6689 | 1.654 | 1.6548 | 96839.0 |
| 2012-03-02 | BFX | Futures | 2796.1 | 2815.7 | 2796.1 | 2807.1 | 245.0 |
| 2012-03-02 | BR | Futures | 0.27329 | 0.27329 | 0.27116 | 0.27116 | 25.0 |
| 2012-03-02 | BZ | Futures | 118.49 | 118.52 | 116.72 | 117.17 | 792.0 |
| 2012-03-02 | C | Futures | 1526.0 | 1526.0 | 1496.0 | 1499.0 | 3523.0 |
| 2012-03-02 | CB | Futures | 84.233 | 84.233 | 83.695 | 83.964 | 15.0 |
| 2012-03-02 | CC | Futures | 1800.0 | 1817.0 | 1770.0 | 1776.0 | 7001.0 |
| 2012-03-02 | CSC | Futures | 3.692 | 3.692 | 3.63 | 3.673 | 60.0 |
| 2012-03-02 | CT | Futures | 112.41 | 113.26 | 109.88 | 110.42 | 11545.0 |
| 2012-03-02 | DC | Futures | 25.91 | 26.01 | 25.05 | 25.42 | 174.0 |
| 2012-03-02 | DX | Futures | 76.722 | 77.393 | 76.688 | 77.342 | 30063.0 |
| 2012-03-02 | E1 | Futures | 1.44967 | 1.45098 | 1.4347 | 1.43667 | 44559.0 |
| 2012-03-02 | E6 | Futures | 1.59178 | 1.59381 | 1.57636 | 1.57851 | 260353.0 |
| 2012-03-02 | E7 | Futures | 1.577 | 1.5791 | 1.562 | 1.5641 | 4226.0 |
| 2012-03-02 | EBM | Futures | 279.11 | 285.0 | 279.11 | 284.35 | 2553.0 |
| 2012-03-02 | ED | Futures | 95.0987 | 95.1107 | 95.0963 | 95.1059 | 122685.0 |
| 2012-03-02 | ER | Futures | 97.494 | 97.553 | 97.489 | 97.538 | 210678.0 |
| 2012-03-02 | EW | Futures | 993.4 | 995.4 | 979.7 | 982.6 | 20794.0 |
| 2012-03-02 | FBTP | Futures | 68.35 | 68.71 | 67.85 | 68.63 | 14903.0 |
| 2012-03-02 | FBTS | Futures | 86.287 | 86.576 | 86.126 | 86.568 | 1872.0 |
| 2012-03-02 | FCE | Futures | 2479.1 | 2482.3 | 2465.7 | 2472.1 | 82068.0 |
| 2012-03-02 | FDAX | Futures | 7688.2 | 7691.5 | 7618.1 | 7647.4 | 113117.0 |
| 2012-03-02 | FESX | Futures | 1710.2 | 1711.5 | 1696.8 | 1702.1 | 813766.0 |
| 2012-03-02 | FEU3 | Futures | 98.098 | 98.098 | 98.093 | 98.093 | 999.0 |
| 2012-03-02 | FGBL | Futures | 112.89 | 113.43 | 112.8 | 113.34 | 657594.0 |
| 2012-03-02 | FGBM | Futures | 113.51 | 113.85 | 113.48 | 113.8 | 418660.0 |
| 2012-03-02 | FGBS | Futures | 109.929 | 109.999 | 109.919 | 109.989 | 544987.0 |
| 2012-03-02 | FGBX | Futures | 117.6 | 118.66 | 117.46 | 118.46 | 11084.0 |
| 2012-03-02 | FTDX | Futures | 719.9 | 720.8 | 715.3 | 720.8 | 348.0 |
| 2012-03-02 | FTI | Futures | 274.96 | 276.52 | 274.08 | 275.64 | 26771.0 |
| 2012-03-02 | FTUK | Futures | 4271.8 | 4277.5 | 4239.3 | 4254.4 | 84627.0 |
| 2012-03-02 | FVSA | Futures | 9254.84 | 9254.84 | 9064.8 | 9140.81 | 1968.0 |
| 2012-03-02 | FXXP | Futures | 189.2 | 189.4 | 188.2 | 188.9 | 2099.0 |
| 2012-03-02 | G | Futures | 93.79 | 94.48 | 93.66 | 94.38 | 105455.0 |
| 2012-03-02 | GF | Futures | 336.876 | 337.194 | 334.649 | 335.285 | 4698.0 |
| 2012-03-02 | GSCI | Futures | 1117.15 | 1119.75 | 1104.87 | 1107.94 | 269.0 |
| 2012-03-02 | HE | Futures | 109.006 | 109.64 | 109.006 | 109.278 | 22573.0 |
| 2012-03-02 | HG | Futures | 5.1544 | 5.178 | 5.0986 | 5.117 | 41237.0 |
| 2012-03-02 | HO | Futures | 2.6865 | 2.6865 | 2.6288 | 2.6399 | 28219.0 |
| 2012-03-02 | HRC | Futures | 2719.2 | 2719.2 | 2719.2 | 2719.2 | 0.0 |
| 2012-03-02 | J1 | Futures | 0.0154784 | 0.0154872 | 0.0153365 | 0.0153503 | 90496.0 |
> showing 50 of 98 rows — these rows as CSV