PREVIEW / futures_daily / 2017-02-13
file: by_date/futures_daily/2017/2017-02-13.parquet size: 9 KB rows: 109
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 |
|---|---|---|---|---|---|---|---|
| 2017-02-13 | ES | Futures | 2508.88 | 2524.87 | 2507.79 | 2521.89 | 1210205.0 |
| 2017-02-13 | NQ | Futures | 6163.24 | 6201.25 | 6160.29 | 6198.59 | 144520.0 |
| 2017-02-13 | YM | Futures | 21311.4 | 21483.1 | 21304.0 | 21469.4 | 106394.0 |
| 2017-02-13 | CL | Futures | 57.64 | 57.74 | 56.51 | 56.69 | 266515.0 |
| 2017-02-13 | GC | Futures | 1576.7 | 1576.9 | 1558.9 | 1565.9 | 176619.0 |
| 2017-02-13 | ZN | Futures | 121.996466 | 122.011748 | 121.706107 | 121.858927 | 826475.0 |
| 2017-02-13 | A6 | Futures | 0.78467 | 0.7858 | 0.78088 | 0.78242 | 56788.0 |
| 2017-02-13 | AD | Futures | 0.78067 | 0.78256 | 0.77862 | 0.78179 | 39478.0 |
| 2017-02-13 | ALI | Futures | 2529.7 | 2529.7 | 2529.7 | 2529.7 | 30.0 |
| 2017-02-13 | B | Futures | 41.8 | 41.89 | 40.86 | 40.99 | 234314.0 |
| 2017-02-13 | B6 | Futures | 1.3109 | 1.316 | 1.3097 | 1.3146 | 69954.0 |
| 2017-02-13 | BFX | Futures | 4359.0 | 4381.4 | 4359.0 | 4381.4 | 5.0 |
| 2017-02-13 | BR | Futures | 0.22756 | 0.22792 | 0.22692 | 0.22763 | 1037.0 |
| 2017-02-13 | BZ | Futures | 41.65 | 41.67 | 40.67 | 40.79 | 25049.0 |
| 2017-02-13 | C | Futures | 1652.0 | 1657.0 | 1612.0 | 1615.0 | 8498.0 |
| 2017-02-13 | CB | Futures | 261.417 | 261.417 | 259.464 | 259.983 | 22.0 |
| 2017-02-13 | CC | Futures | 1486.0 | 1496.0 | 1467.0 | 1470.0 | 29578.0 |
| 2017-02-13 | CNH | Futures | 7.2799 | 7.2826 | 7.2717 | 7.2718 | 50.0 |
| 2017-02-13 | CSC | Futures | 3.875 | 3.875 | 3.861 | 3.863 | 73.0 |
| 2017-02-13 | CT | Futures | 87.19 | 88.4 | 87.18 | 88.01 | 28877.0 |
| 2017-02-13 | DC | Futures | 32.38 | 32.42 | 32.1 | 32.23 | 117.0 |
| 2017-02-13 | DX | Futures | 93.844 | 94.142 | 93.639 | 93.993 | 23850.0 |
| 2017-02-13 | E1 | Futures | 1.23628 | 1.23876 | 1.23256 | 1.23417 | 12982.0 |
| 2017-02-13 | E6 | Futures | 1.22917 | 1.23241 | 1.22467 | 1.22548 | 138249.0 |
| 2017-02-13 | E7 | Futures | 1.2226 | 1.226 | 1.2183 | 1.2192 | 2613.0 |
| 2017-02-13 | EBM | Futures | 195.41 | 197.12 | 194.27 | 197.12 | 18825.0 |
| 2017-02-13 | ED | Futures | 95.5665 | 95.5689 | 95.5641 | 95.5641 | 124829.0 |
| 2017-02-13 | ER | Futures | 98.298 | 98.303 | 98.293 | 98.298 | 28506.0 |
| 2017-02-13 | EW | Futures | 1832.4 | 1842.3 | 1830.8 | 1835.1 | 11137.0 |
| 2017-02-13 | FBON | Futures | 119.99 | 120.43 | 119.67 | 120.28 | 915.0 |
| 2017-02-13 | FBTP | Futures | 103.47 | 103.89 | 103.02 | 103.88 | 129582.0 |
| 2017-02-13 | FBTS | Futures | 101.512 | 101.53 | 101.43 | 101.512 | 41972.0 |
| 2017-02-13 | FCE | Futures | 4252.3 | 4316.1 | 4251.9 | 4299.8 | 73170.0 |
| 2017-02-13 | FDAX | Futures | 12314.3 | 12465.8 | 12312.8 | 12435.7 | 69686.0 |
| 2017-02-13 | FDXM | Futures | 12269.4 | 12415.6 | 12264.2 | 12385.6 | 22653.0 |
| 2017-02-13 | FESX | Futures | 2617.5 | 2651.1 | 2617.5 | 2646.3 | 975477.0 |
| 2017-02-13 | FGBL | Futures | 147.84 | 147.93 | 147.61 | 147.69 | 510190.0 |
| 2017-02-13 | FGBM | Futures | 129.32 | 129.37 | 129.27 | 129.3 | 368815.0 |
| 2017-02-13 | FGBS | Futures | 112.272 | 112.287 | 112.257 | 112.272 | 191021.0 |
| 2017-02-13 | FGBX | Futures | 166.87 | 167.1 | 166.04 | 166.49 | 36681.0 |
| 2017-02-13 | FMWO | Futures | 6075.8 | 6099.9 | 6075.8 | 6098.7 | 874.0 |
| 2017-02-13 | FOAT | Futures | 130.41 | 130.81 | 130.17 | 130.71 | 97613.0 |
| 2017-02-13 | FTDX | Futures | 1841.1 | 1851.9 | 1840.1 | 1842.1 | 237.0 |
| 2017-02-13 | FTI | Futures | 444.89 | 448.93 | 444.71 | 447.66 | 8853.0 |
| 2017-02-13 | FTUK | Futures | 6113.5 | 6132.6 | 6097.0 | 6125.0 | 84515.0 |
| 2017-02-13 | FVSA | Futures | 736.58 | 742.86 | 713.56 | 721.93 | 29733.0 |
| 2017-02-13 | FXXP | Futures | 304.2 | 306.6 | 304.2 | 306.2 | 30405.0 |
| 2017-02-13 | G | Futures | 112.41 | 112.42 | 111.99 | 112.09 | 116930.0 |
| 2017-02-13 | GF | Futures | 278.356 | 280.123 | 274.708 | 277.729 | 7332.0 |
| 2017-02-13 | GSCI | Futures | 521.21 | 522.05 | 519.28 | 519.41 | 2738.0 |
> showing 50 of 109 rows — these rows as CSV