PREVIEW / futures_daily / 2014-08-07
file: by_date/futures_daily/2014/2014-08-07.parquet size: 9 KB rows: 104
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-08-07 | ES | Futures | 1989.04 | 2000.46 | 1973.45 | 1979.17 | 1954046.0 |
| 2014-08-07 | NQ | Futures | 4464.26 | 4491.08 | 4431.38 | 4449.84 | 329596.0 |
| 2014-08-07 | YM | Futures | 16540.3 | 16606.9 | 16426.3 | 16467.6 | 189173.0 |
| 2014-08-07 | CL | Futures | 178.37 | 179.89 | 177.74 | 179.2 | 286531.0 |
| 2014-08-07 | GC | Futures | 1713.8 | 1726.7 | 1709.1 | 1721.5 | 122429.0 |
| 2014-08-07 | ZN | Futures | 117.192235 | 117.659078 | 117.075524 | 117.571545 | 1341545.0 |
| 2014-08-07 | A6 | Futures | 0.90117 | 0.90224 | 0.89257 | 0.89364 | 104794.0 |
| 2014-08-07 | AD | Futures | 0.92962 | 0.93063 | 0.92769 | 0.9287 | 49796.0 |
| 2014-08-07 | ALI | Futures | 2947.55 | 2947.55 | 2947.55 | 2947.55 | 20.0 |
| 2014-08-07 | B | Futures | 110.65 | 111.88 | 110.15 | 111.41 | 192414.0 |
| 2014-08-07 | B6 | Futures | 1.7709 | 1.7723 | 1.768 | 1.7692 | 71646.0 |
| 2014-08-07 | BFX | Futures | 3719.1 | 3722.6 | 3699.3 | 3699.3 | 60.0 |
| 2014-08-07 | BR | Futures | 0.23091 | 0.23091 | 0.22778 | 0.2282 | 1732.0 |
| 2014-08-07 | BZ | Futures | 111.45 | 112.74 | 111.01 | 112.28 | 17330.0 |
| 2014-08-07 | C | Futures | 2127.0 | 2133.0 | 2120.0 | 2132.0 | 8640.0 |
| 2014-08-07 | CB | Futures | 130.795 | 132.192 | 130.795 | 131.912 | 8.0 |
| 2014-08-07 | CC | Futures | 2365.0 | 2376.0 | 2356.0 | 2373.0 | 16254.0 |
| 2014-08-07 | CNH | Futures | 7.0891 | 7.0898 | 7.0866 | 7.0866 | 27.0 |
| 2014-08-07 | CT | Futures | 80.67 | 80.67 | 79.99 | 80.19 | 12.0 |
| 2014-08-07 | DC | Futures | 37.63 | 37.85 | 37.5 | 37.69 | 165.0 |
| 2014-08-07 | DX | Futures | 77.362 | 77.571 | 77.315 | 77.462 | 27733.0 |
| 2014-08-07 | E1 | Futures | 1.41276 | 1.41417 | 1.40814 | 1.41071 | 33588.0 |
| 2014-08-07 | E6 | Futures | 1.57934 | 1.58064 | 1.57391 | 1.57639 | 201751.0 |
| 2014-08-07 | E7 | Futures | 1.5692 | 1.5703 | 1.5637 | 1.5661 | 2232.0 |
| 2014-08-07 | ED | Futures | 95.4162 | 95.4162 | 95.4115 | 95.4162 | 66274.0 |
| 2014-08-07 | ER | Futures | 97.896 | 97.901 | 97.891 | 97.896 | 30824.0 |
| 2014-08-07 | EW | Futures | 1418.9 | 1429.0 | 1411.1 | 1414.0 | 14932.0 |
| 2014-08-07 | FBTP | Futures | 91.76 | 92.23 | 91.38 | 91.58 | 87145.0 |
| 2014-08-07 | FBTS | Futures | 98.348 | 98.481 | 98.339 | 98.365 | 12617.0 |
| 2014-08-07 | FCE | Futures | 3342.5 | 3351.3 | 3276.5 | 3300.8 | 150520.0 |
| 2014-08-07 | FDAX | Futures | 10061.6 | 10101.7 | 9884.2 | 9956.9 | 165993.0 |
| 2014-08-07 | FESX | Futures | 2191.6 | 2201.6 | 2150.6 | 2166.4 | 1478356.0 |
| 2014-08-07 | FEU3 | Futures | 98.517 | 98.517 | 98.517 | 98.517 | 25.0 |
| 2014-08-07 | FGBL | Futures | 129.48 | 129.99 | 129.44 | 129.77 | 708900.0 |
| 2014-08-07 | FGBM | Futures | 121.95 | 122.08 | 121.93 | 122.02 | 419090.0 |
| 2014-08-07 | FGBS | Futures | 110.803 | 110.823 | 110.788 | 110.803 | 293965.0 |
| 2014-08-07 | FGBX | Futures | 137.69 | 139.28 | 137.69 | 138.56 | 24780.0 |
| 2014-08-07 | FMWO | Futures | 5622.9 | 5631.7 | 5604.0 | 5604.0 | 505.0 |
| 2014-08-07 | FOAT | Futures | 119.27 | 119.64 | 119.24 | 119.54 | 58217.0 |
| 2014-08-07 | FTDX | Futures | 1089.2 | 1096.7 | 1085.4 | 1088.3 | 241.0 |
| 2014-08-07 | FTI | Futures | 343.07 | 344.76 | 339.26 | 340.99 | 35216.0 |
| 2014-08-07 | FTUK | Futures | 5076.9 | 5087.7 | 5026.6 | 5046.9 | 109737.0 |
| 2014-08-07 | FVSA | Futures | 1557.96 | 1604.66 | 1540.98 | 1600.41 | 12714.0 |
| 2014-08-07 | FXXP | Futures | 247.4 | 248.1 | 245.0 | 246.0 | 9239.0 |
| 2014-08-07 | G | Futures | 95.47 | 95.66 | 95.18 | 95.5 | 144216.0 |
| 2014-08-07 | GF | Futures | 338.895 | 340.198 | 334.604 | 334.604 | 2101.0 |
| 2014-08-07 | GSCI | Futures | 1035.63 | 1038.31 | 1031.78 | 1036.55 | 1116.0 |
| 2014-08-07 | HE | Futures | 123.222 | 123.222 | 119.928 | 121.197 | 22708.0 |
| 2014-08-07 | HG | Futures | 4.0474 | 4.0723 | 4.0359 | 4.0596 | 58433.0 |
| 2014-08-07 | HH | Futures | 50.22 | 50.423 | 48.95 | 49.204 | 326.0 |
> showing 50 of 104 rows — these rows as CSV