PREVIEW / futures_daily / 2017-01-10
file: by_date/futures_daily/2017/2017-01-10.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-01-10 | ES | Futures | 2454.94 | 2465.24 | 2449.52 | 2454.13 | 1304523.0 |
| 2017-01-10 | NQ | Futures | 5918.97 | 5948.44 | 5901.59 | 5929.87 | 153774.0 |
| 2017-01-10 | YM | Futures | 20882.7 | 20944.8 | 20818.4 | 20842.6 | 110885.0 |
| 2017-01-10 | CL | Futures | 55.47 | 56.04 | 54.27 | 54.38 | 632573.0 |
| 2017-01-10 | GC | Futures | 1517.0 | 1529.0 | 1515.6 | 1522.4 | 224813.0 |
| 2017-01-10 | ZN | Futures | 122.088158 | 122.17985 | 121.889491 | 122.02703 | 907696.0 |
| 2017-01-10 | A6 | Futures | 0.75241 | 0.75508 | 0.74955 | 0.75344 | 82722.0 |
| 2017-01-10 | AD | Futures | 0.77311 | 0.77474 | 0.77091 | 0.77255 | 44776.0 |
| 2017-01-10 | ALI | Futures | 2371.69 | 2383.32 | 2371.69 | 2383.32 | 14.0 |
| 2017-01-10 | B | Futures | 40.94 | 41.24 | 39.92 | 39.96 | 332978.0 |
| 2017-01-10 | B6 | Futures | 1.2789 | 1.2803 | 1.2716 | 1.2775 | 97426.0 |
| 2017-01-10 | BFX | Futures | 4388.1 | 4400.9 | 4388.1 | 4400.9 | 1.0 |
| 2017-01-10 | BR | Futures | 0.2202 | 0.22048 | 0.21874 | 0.21931 | 65.0 |
| 2017-01-10 | BZ | Futures | 40.55 | 40.92 | 39.62 | 39.67 | 33801.0 |
| 2017-01-10 | C | Futures | 1843.0 | 1867.0 | 1829.0 | 1864.0 | 7751.0 |
| 2017-01-10 | CB | Futures | 279.146 | 279.207 | 278.292 | 278.292 | 10.0 |
| 2017-01-10 | CC | Futures | 1660.0 | 1685.0 | 1645.0 | 1680.0 | 13519.0 |
| 2017-01-10 | CNH | Futures | 7.3687 | 7.3743 | 7.3538 | 7.3684 | 76.0 |
| 2017-01-10 | CSC | Futures | 4.05 | 4.064 | 4.041 | 4.059 | 57.0 |
| 2017-01-10 | CT | Futures | 83.85 | 84.66 | 83.65 | 84.08 | 14463.0 |
| 2017-01-10 | DC | Futures | 33.26 | 33.86 | 33.15 | 33.53 | 298.0 |
| 2017-01-10 | DX | Futures | 94.831 | 95.055 | 94.491 | 94.967 | 33331.0 |
| 2017-01-10 | E1 | Futures | 1.22599 | 1.22983 | 1.2219 | 1.22314 | 16215.0 |
| 2017-01-10 | E6 | Futures | 1.22553 | 1.23079 | 1.22195 | 1.22282 | 168448.0 |
| 2017-01-10 | E7 | Futures | 1.2196 | 1.2245 | 1.2157 | 1.2166 | 3009.0 |
| 2017-01-10 | EBM | Futures | 194.84 | 194.84 | 192.28 | 193.42 | 19858.0 |
| 2017-01-10 | ED | Futures | 95.5665 | 95.5713 | 95.5617 | 95.5665 | 265573.0 |
| 2017-01-10 | ER | Futures | 98.298 | 98.303 | 98.293 | 98.303 | 79026.0 |
| 2017-01-10 | EW | Futures | 1776.4 | 1795.1 | 1771.7 | 1788.0 | 15596.0 |
| 2017-01-10 | FBON | Futures | 121.81 | 122.16 | 121.7 | 121.9 | 134.0 |
| 2017-01-10 | FBTP | Futures | 106.38 | 106.7 | 106.18 | 106.37 | 74287.0 |
| 2017-01-10 | FBTS | Futures | 101.846 | 101.864 | 101.828 | 101.837 | 18684.0 |
| 2017-01-10 | FCE | Futures | 4292.4 | 4316.1 | 4281.0 | 4298.1 | 63392.0 |
| 2017-01-10 | FDAX | Futures | 12186.1 | 12248.4 | 12182.9 | 12229.4 | 60786.0 |
| 2017-01-10 | FDXM | Futures | 12132.8 | 12199.0 | 12132.8 | 12180.1 | 14033.0 |
| 2017-01-10 | FESX | Futures | 2639.1 | 2648.7 | 2629.5 | 2639.9 | 686502.0 |
| 2017-01-10 | FEU3 | Futures | 98.971 | 98.971 | 98.971 | 98.971 | 7.0 |
| 2017-01-10 | FGBL | Futures | 147.13 | 147.33 | 146.93 | 147.11 | 617957.0 |
| 2017-01-10 | FGBM | Futures | 128.95 | 129.0 | 128.87 | 128.92 | 419342.0 |
| 2017-01-10 | FGBS | Futures | 112.132 | 112.157 | 112.127 | 112.142 | 192264.0 |
| 2017-01-10 | FGBX | Futures | 168.05 | 168.69 | 167.32 | 167.97 | 38847.0 |
| 2017-01-10 | FMWO | Futures | 5939.5 | 5962.4 | 5939.5 | 5958.8 | 1189.0 |
| 2017-01-10 | FOAT | Futures | 132.74 | 133.01 | 132.52 | 132.72 | 81324.0 |
| 2017-01-10 | FTDX | Futures | 1818.5 | 1818.5 | 1801.9 | 1808.2 | 180.0 |
| 2017-01-10 | FTI | Futures | 441.24 | 441.24 | 440.28 | 440.69 | 39.0 |
| 2017-01-10 | FTUK | Futures | 6078.8 | 6122.9 | 6070.7 | 6119.0 | 88475.0 |
| 2017-01-10 | FVSA | Futures | 912.59 | 912.59 | 890.66 | 896.15 | 19585.0 |
| 2017-01-10 | FXXP | Futures | 300.1 | 301.3 | 299.2 | 300.8 | 21569.0 |
| 2017-01-10 | G | Futures | 111.44 | 111.66 | 111.19 | 111.33 | 156647.0 |
| 2017-01-10 | GF | Futures | 288.387 | 296.366 | 286.506 | 296.366 | 7487.0 |
> showing 50 of 109 rows — these rows as CSV