PREVIEW / futures_daily / 2013-01-02
file: by_date/futures_daily/2013/2013-01-02.parquet size: 9 KB rows: 101
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 |
|---|---|---|---|---|---|---|---|
| 2013-01-02 | ES | Futures | 1476.47 | 1491.82 | 1471.61 | 1490.8 | 1939767.0 |
| 2013-01-02 | NQ | Futures | 3098.43 | 3163.59 | 3098.43 | 3158.98 | 285939.0 |
| 2013-01-02 | YM | Futures | 12921.3 | 13085.1 | 12910.5 | 13072.3 | 151501.0 |
| 2013-01-02 | CL | Futures | 162.9 | 166.6 | 162.51 | 165.27 | 203865.0 |
| 2013-01-02 | GC | Futures | 2234.0 | 2259.3 | 2226.7 | 2250.5 | 132828.0 |
| 2013-01-02 | ZN | Futures | 116.376694 | 116.638556 | 116.335348 | 116.555863 | 751382.0 |
| 2013-01-02 | A6 | Futures | 0.95316 | 0.95774 | 0.95307 | 0.95454 | 78849.0 |
| 2013-01-02 | AD | Futures | 1.01513 | 1.01763 | 1.01402 | 1.01533 | 63211.0 |
| 2013-01-02 | B | Futures | 103.27 | 104.68 | 103.27 | 104.3 | 118333.0 |
| 2013-01-02 | B6 | Futures | 1.7033 | 1.7048 | 1.6951 | 1.6973 | 78103.0 |
| 2013-01-02 | BFX | Futures | 3038.7 | 3038.9 | 3030.5 | 3038.7 | 80.0 |
| 2013-01-02 | BR | Futures | 0.23843 | 0.23868 | 0.23819 | 0.23819 | 152.0 |
| 2013-01-02 | BZ | Futures | 106.12 | 106.8 | 105.83 | 106.62 | 1291.0 |
| 2013-01-02 | C | Futures | 1542.0 | 1543.0 | 1522.0 | 1532.0 | 9015.0 |
| 2013-01-02 | CB | Futures | 82.882 | 84.315 | 82.882 | 84.315 | 10.0 |
| 2013-01-02 | CC | Futures | 1694.0 | 1712.0 | 1688.0 | 1704.0 | 11254.0 |
| 2013-01-02 | CSC | Futures | 3.841 | 3.841 | 3.841 | 3.841 | 1.0 |
| 2013-01-02 | CT | Futures | 95.33 | 96.84 | 94.28 | 94.84 | 18354.0 |
| 2013-01-02 | DC | Futures | 28.97 | 29.02 | 28.85 | 28.94 | 65.0 |
| 2013-01-02 | DX | Futures | 76.788 | 77.184 | 76.634 | 77.105 | 18898.0 |
| 2013-01-02 | E1 | Futures | 1.41225 | 1.41573 | 1.40093 | 1.40311 | 27307.0 |
| 2013-01-02 | E6 | Futures | 1.56354 | 1.56731 | 1.55233 | 1.55493 | 170097.0 |
| 2013-01-02 | E7 | Futures | 1.5523 | 1.5565 | 1.5418 | 1.5443 | 3103.0 |
| 2013-01-02 | EBM | Futures | 278.12 | 282.01 | 272.84 | 273.95 | 14998.0 |
| 2013-01-02 | ED | Futures | 95.2295 | 95.239 | 95.2199 | 95.2342 | 90762.0 |
| 2013-01-02 | ER | Futures | 97.842 | 97.852 | 97.832 | 97.837 | 48603.0 |
| 2013-01-02 | EW | Futures | 1045.0 | 1066.3 | 1045.0 | 1065.0 | 29489.0 |
| 2013-01-02 | FBTP | Futures | 75.43 | 76.81 | 75.37 | 76.63 | 21438.0 |
| 2013-01-02 | FBTS | Futures | 90.849 | 91.298 | 90.849 | 91.264 | 5337.0 |
| 2013-01-02 | FCE | Futures | 2791.8 | 2812.1 | 2781.2 | 2809.1 | 106005.0 |
| 2013-01-02 | FDAX | Futures | 8458.3 | 8524.9 | 8439.2 | 8495.5 | 117745.0 |
| 2013-01-02 | FESX | Futures | 1819.3 | 1843.1 | 1816.6 | 1839.7 | 940750.0 |
| 2013-01-02 | FEU3 | Futures | 98.443 | 98.443 | 98.443 | 98.443 | 2.0 |
| 2013-01-02 | FGBL | Futures | 119.73 | 119.77 | 118.97 | 119.08 | 553926.0 |
| 2013-01-02 | FGBM | Futures | 117.37 | 117.42 | 116.99 | 117.05 | 363779.0 |
| 2013-01-02 | FGBS | Futures | 110.492 | 110.532 | 110.402 | 110.427 | 457943.0 |
| 2013-01-02 | FGBX | Futures | 127.93 | 127.93 | 125.82 | 126.17 | 7024.0 |
| 2013-01-02 | FOAT | Futures | 106.06 | 106.06 | 105.54 | 105.62 | 29141.0 |
| 2013-01-02 | FTDX | Futures | 797.6 | 799.0 | 793.8 | 799.0 | 449.0 |
| 2013-01-02 | FTI | Futures | 299.13 | 301.83 | 298.31 | 300.8 | 31493.0 |
| 2013-01-02 | FTUK | Futures | 4315.2 | 4420.0 | 4315.2 | 4404.2 | 113207.0 |
| 2013-01-02 | FVSA | Futures | 4121.93 | 4121.93 | 3604.15 | 3807.2 | 10170.0 |
| 2013-01-02 | FXXP | Futures | 204.1 | 206.0 | 204.1 | 205.7 | 3540.0 |
| 2013-01-02 | G | Futures | 98.3 | 98.33 | 97.4 | 97.5 | 117888.0 |
| 2013-01-02 | GF | Futures | 288.236 | 289.28 | 285.011 | 286.908 | 1750.0 |
| 2013-01-02 | GSCI | Futures | 1057.89 | 1060.38 | 1049.51 | 1050.72 | 717.0 |
| 2013-01-02 | HE | Futures | 98.925 | 99.154 | 97.921 | 98.896 | 20178.0 |
| 2013-01-02 | HG | Futures | 4.6885 | 4.8271 | 4.6795 | 4.7976 | 48423.0 |
| 2013-01-02 | HH | Futures | 38.942 | 38.942 | 37.299 | 37.956 | 696.0 |
| 2013-01-02 | HO | Futures | 2.4337 | 2.4655 | 2.4337 | 2.4485 | 23658.0 |
> showing 50 of 101 rows — these rows as CSV