PREVIEW / futures_daily / 2014-02-07
file: by_date/futures_daily/2014/2014-02-07.parquet size: 9 KB rows: 103
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 |
|---|---|---|---|---|---|---|---|
| 2014-02-07 | ES | Futures | 1822.55 | 1849.36 | 1812.5 | 1848.84 | 2344919.0 |
| 2014-02-07 | NQ | Futures | 4012.99 | 4094.61 | 4000.06 | 4090.3 | 367851.0 |
| 2014-02-07 | YM | Futures | 15538.4 | 15724.2 | 15446.6 | 15714.2 | 206297.0 |
| 2014-02-07 | CL | Futures | 173.01 | 177.02 | 171.49 | 176.38 | 270407.0 |
| 2014-02-07 | GC | Futures | 1656.8 | 1676.7 | 1655.0 | 1664.7 | 136028.0 |
| 2014-02-07 | ZN | Futures | 115.020769 | 115.636006 | 114.663073 | 115.34985 | 1765816.0 |
| 2014-02-07 | A6 | Futures | 0.85101 | 0.85558 | 0.84825 | 0.85177 | 85908.0 |
| 2014-02-07 | AD | Futures | 0.914 | 0.9225 | 0.91309 | 0.91704 | 71486.0 |
| 2014-02-07 | B | Futures | 109.63 | 111.94 | 109.14 | 111.77 | 179980.0 |
| 2014-02-07 | B6 | Futures | 1.714 | 1.7243 | 1.7118 | 1.7236 | 111857.0 |
| 2014-02-07 | BR | Futures | 0.2158 | 0.21728 | 0.21528 | 0.21614 | 1586.0 |
| 2014-02-07 | BZ | Futures | 111.8 | 114.19 | 111.31 | 114.03 | 9646.0 |
| 2014-02-07 | C | Futures | 1951.0 | 1975.0 | 1948.0 | 1971.0 | 6688.0 |
| 2014-02-07 | CB | Futures | 85.868 | 85.868 | 85.132 | 85.377 | 49.0 |
| 2014-02-07 | CC | Futures | 2159.0 | 2196.0 | 2156.0 | 2183.0 | 23886.0 |
| 2014-02-07 | CNH | Futures | 6.9458 | 6.9496 | 6.9446 | 6.9446 | 13.0 |
| 2014-02-07 | CSC | Futures | 4.321 | 4.321 | 4.211 | 4.22 | 23.0 |
| 2014-02-07 | CT | Futures | 98.12 | 100.4 | 97.88 | 99.73 | 25390.0 |
| 2014-02-07 | DC | Futures | 33.03 | 33.45 | 32.4 | 32.43 | 609.0 |
| 2014-02-07 | DX | Futures | 76.994 | 77.118 | 76.676 | 76.797 | 20863.0 |
| 2014-02-07 | E1 | Futures | 1.42543 | 1.43468 | 1.42325 | 1.43057 | 26348.0 |
| 2014-02-07 | E6 | Futures | 1.60424 | 1.61085 | 1.59964 | 1.60873 | 236950.0 |
| 2014-02-07 | E7 | Futures | 1.5937 | 1.6002 | 1.5893 | 1.5982 | 5061.0 |
| 2014-02-07 | EBM | Futures | 269.74 | 271.48 | 269.39 | 271.13 | 10941.0 |
| 2014-02-07 | ED | Futures | 95.3805 | 95.3853 | 95.3758 | 95.3758 | 112495.0 |
| 2014-02-07 | ER | Futures | 97.867 | 97.876 | 97.862 | 97.876 | 74561.0 |
| 2014-02-07 | EW | Futures | 1317.6 | 1334.5 | 1308.8 | 1333.6 | 17262.0 |
| 2014-02-07 | FBTP | Futures | 84.23 | 84.78 | 84.23 | 84.72 | 59704.0 |
| 2014-02-07 | FBTS | Futures | 96.398 | 96.52 | 96.354 | 96.494 | 10831.0 |
| 2014-02-07 | FCE | Futures | 3268.2 | 3309.4 | 3244.1 | 3288.8 | 121904.0 |
| 2014-02-07 | FDAX | Futures | 10297.1 | 10372.6 | 10230.6 | 10317.7 | 115341.0 |
| 2014-02-07 | FESX | Futures | 2126.7 | 2153.5 | 2107.7 | 2138.0 | 1206895.0 |
| 2014-02-07 | FGBL | Futures | 121.97 | 122.66 | 121.96 | 122.39 | 937329.0 |
| 2014-02-07 | FGBM | Futures | 118.97 | 119.41 | 118.97 | 119.26 | 639667.0 |
| 2014-02-07 | FGBS | Futures | 110.578 | 110.668 | 110.578 | 110.633 | 417508.0 |
| 2014-02-07 | FGBX | Futures | 124.21 | 125.19 | 124.19 | 124.68 | 24356.0 |
| 2014-02-07 | FMWO | Futures | 5277.4 | 5277.4 | 5277.4 | 5277.4 | 0.0 |
| 2014-02-07 | FOAT | Futures | 110.46 | 110.94 | 110.46 | 110.82 | 58115.0 |
| 2014-02-07 | FTDX | Futures | 1151.6 | 1152.6 | 1147.4 | 1151.2 | 108.0 |
| 2014-02-07 | FTI | Futures | 333.57 | 334.77 | 331.47 | 333.18 | 31326.0 |
| 2014-02-07 | FTUK | Futures | 4929.5 | 4958.3 | 4907.9 | 4932.9 | 106648.0 |
| 2014-02-07 | FVSA | Futures | 2081.16 | 2142.38 | 1979.15 | 1984.25 | 16903.0 |
| 2014-02-07 | FXXP | Futures | 236.7 | 239.5 | 236.0 | 238.0 | 6422.0 |
| 2014-02-07 | G | Futures | 93.12 | 93.5 | 92.97 | 93.34 | 180422.0 |
| 2014-02-07 | GF | Futures | 269.894 | 270.861 | 268.967 | 270.539 | 3437.0 |
| 2014-02-07 | GSCI | Futures | 1029.9 | 1043.02 | 1029.9 | 1040.31 | 1364.0 |
| 2014-02-07 | HE | Futures | 113.797 | 114.461 | 113.737 | 114.401 | 10303.0 |
| 2014-02-07 | HG | Futures | 4.0726 | 4.1023 | 4.0701 | 4.0871 | 45126.0 |
| 2014-02-07 | HH | Futures | 51.02 | 52.454 | 50.414 | 50.733 | 850.0 |
| 2014-02-07 | HO | Futures | 2.4033 | 2.4424 | 2.3927 | 2.4386 | 61804.0 |
> showing 50 of 103 rows — these rows as CSV