PREVIEW / futures_daily / 2014-02-05
file: by_date/futures_daily/2014/2014-02-05.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-05 | ES | Futures | 1798.07 | 1804.77 | 1785.44 | 1797.81 | 2075514.0 |
| 2014-02-05 | NQ | Futures | 3968.44 | 3981.38 | 3922.46 | 3960.97 | 356874.0 |
| 2014-02-05 | YM | Futures | 15317.8 | 15390.7 | 15251.9 | 15342.8 | 200222.0 |
| 2014-02-05 | CL | Futures | 172.48 | 173.52 | 170.94 | 171.97 | 237671.0 |
| 2014-02-05 | GC | Futures | 1653.3 | 1680.0 | 1650.1 | 1656.8 | 127060.0 |
| 2014-02-05 | ZN | Futures | 115.464312 | 115.807701 | 115.192463 | 115.264002 | 1470239.0 |
| 2014-02-05 | A6 | Futures | 0.84758 | 0.84958 | 0.84348 | 0.84663 | 84723.0 |
| 2014-02-05 | AD | Futures | 0.91329 | 0.91653 | 0.90964 | 0.91329 | 64649.0 |
| 2014-02-05 | B | Futures | 108.15 | 108.66 | 107.82 | 108.49 | 129262.0 |
| 2014-02-05 | B6 | Futures | 1.7145 | 1.7162 | 1.7068 | 1.7131 | 109910.0 |
| 2014-02-05 | BFX | Futures | 3439.4 | 3452.1 | 3439.4 | 3452.1 | 3.0 |
| 2014-02-05 | BR | Futures | 0.21342 | 0.21505 | 0.2128 | 0.21466 | 2075.0 |
| 2014-02-05 | BZ | Futures | 110.22 | 110.84 | 110.02 | 110.69 | 8207.0 |
| 2014-02-05 | C | Futures | 1946.0 | 1959.0 | 1939.0 | 1947.0 | 9304.0 |
| 2014-02-05 | CB | Futures | 89.057 | 89.057 | 86.469 | 87.34 | 67.0 |
| 2014-02-05 | CC | Futures | 2148.0 | 2166.0 | 2140.0 | 2152.0 | 13843.0 |
| 2014-02-05 | CSC | Futures | 4.174 | 4.242 | 4.143 | 4.23 | 62.0 |
| 2014-02-05 | CT | Futures | 97.15 | 97.74 | 97.03 | 97.51 | 10082.0 |
| 2014-02-05 | DC | Futures | 32.12 | 32.73 | 31.76 | 32.61 | 526.0 |
| 2014-02-05 | DX | Futures | 77.232 | 77.356 | 76.856 | 77.15 | 24507.0 |
| 2014-02-05 | E1 | Futures | 1.42056 | 1.42608 | 1.41773 | 1.42158 | 29013.0 |
| 2014-02-05 | E6 | Futures | 1.59539 | 1.60023 | 1.59338 | 1.59763 | 209526.0 |
| 2014-02-05 | E7 | Futures | 1.5847 | 1.5898 | 1.5831 | 1.5872 | 4757.0 |
| 2014-02-05 | EBM | Futures | 271.13 | 271.48 | 269.04 | 270.08 | 12595.0 |
| 2014-02-05 | ED | Futures | 95.3758 | 95.3805 | 95.371 | 95.3758 | 101649.0 |
| 2014-02-05 | ER | Futures | 97.891 | 97.896 | 97.886 | 97.891 | 84549.0 |
| 2014-02-05 | EW | Futures | 1302.7 | 1305.6 | 1287.4 | 1299.5 | 21484.0 |
| 2014-02-05 | FBTP | Futures | 84.07 | 84.41 | 84.07 | 84.28 | 34159.0 |
| 2014-02-05 | FBTS | Futures | 96.406 | 96.476 | 96.398 | 96.45 | 10635.0 |
| 2014-02-05 | FCE | Futures | 3197.4 | 3218.0 | 3187.7 | 3203.7 | 129282.0 |
| 2014-02-05 | FDAX | Futures | 10106.4 | 10156.9 | 10075.9 | 10121.9 | 120023.0 |
| 2014-02-05 | FESX | Futures | 2078.2 | 2095.1 | 2072.6 | 2085.9 | 1014518.0 |
| 2014-02-05 | FGBL | Futures | 122.5 | 123.02 | 122.44 | 122.6 | 921885.0 |
| 2014-02-05 | FGBM | Futures | 119.31 | 119.55 | 119.28 | 119.36 | 619046.0 |
| 2014-02-05 | FGBS | Futures | 110.658 | 110.688 | 110.643 | 110.668 | 274011.0 |
| 2014-02-05 | FGBX | Futures | 125.15 | 126.09 | 125.01 | 125.23 | 20433.0 |
| 2014-02-05 | FMWO | Futures | 5157.8 | 5157.8 | 5151.6 | 5151.6 | 6.0 |
| 2014-02-05 | FOAT | Futures | 111.01 | 111.4 | 110.9 | 111.0 | 64926.0 |
| 2014-02-05 | FTDX | Futures | 1129.6 | 1136.2 | 1123.5 | 1128.2 | 201.0 |
| 2014-02-05 | FTI | Futures | 326.63 | 328.99 | 325.56 | 327.44 | 31756.0 |
| 2014-02-05 | FTUK | Futures | 4839.0 | 4868.6 | 4814.1 | 4852.7 | 104300.0 |
| 2014-02-05 | FVSA | Futures | 2275.0 | 2315.81 | 2218.89 | 2259.7 | 12213.0 |
| 2014-02-05 | FXXP | Futures | 232.2 | 234.0 | 232.0 | 233.1 | 4602.0 |
| 2014-02-05 | G | Futures | 93.57 | 93.97 | 93.44 | 93.54 | 205558.0 |
| 2014-02-05 | GF | Futures | 269.45 | 270.579 | 269.088 | 269.128 | 2566.0 |
| 2014-02-05 | GSCI | Futures | 1029.16 | 1029.16 | 1019.82 | 1022.11 | 145.0 |
| 2014-02-05 | HE | Futures | 112.922 | 115.035 | 112.71 | 114.733 | 20748.0 |
| 2014-02-05 | HG | Futures | 4.0341 | 4.0619 | 4.0227 | 4.0271 | 33340.0 |
| 2014-02-05 | HH | Futures | 57.904 | 60.699 | 53.049 | 53.442 | 3029.0 |
| 2014-02-05 | HO | Futures | 2.3954 | 2.4103 | 2.381 | 2.3958 | 56054.0 |
> showing 50 of 103 rows — these rows as CSV