PREVIEW / futures_daily / 2014-03-21
file: by_date/futures_daily/2014/2014-03-21.parquet size: 9 KB rows: 106
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-03-21 | ES | Futures | 1929.34 | 1941.76 | 1919.77 | 1921.32 | 1750423.0 |
| 2014-03-21 | NQ | Futures | 4247.86 | 4273.76 | 4182.83 | 4188.87 | 379137.0 |
| 2014-03-21 | YM | Futures | 16324.7 | 16445.1 | 16274.4 | 16287.5 | 185327.0 |
| 2014-03-21 | CL | Futures | 175.94 | 178.9 | 175.33 | 177.49 | 191289.0 |
| 2014-03-21 | GC | Futures | 1752.3 | 1770.3 | 1750.6 | 1761.1 | 148313.0 |
| 2014-03-21 | ZN | Futures | 114.461151 | 114.548073 | 114.287308 | 114.461151 | 984094.0 |
| 2014-03-21 | A6 | Futures | 0.86311 | 0.86926 | 0.86282 | 0.86801 | 72293.0 |
| 2014-03-21 | AD | Futures | 0.90011 | 0.90569 | 0.89859 | 0.90285 | 80426.0 |
| 2014-03-21 | B | Futures | 109.28 | 110.87 | 109.06 | 110.0 | 167796.0 |
| 2014-03-21 | B6 | Futures | 1.734 | 1.7352 | 1.7305 | 1.7325 | 67188.0 |
| 2014-03-21 | BFX | Futures | 3725.4 | 3737.6 | 3725.4 | 3733.8 | 188.0 |
| 2014-03-21 | BR | Futures | 0.22301 | 0.22301 | 0.22198 | 0.22277 | 222.0 |
| 2014-03-21 | BZ | Futures | 111.49 | 113.08 | 111.26 | 112.2 | 4245.0 |
| 2014-03-21 | C | Futures | 1974.0 | 1988.0 | 1965.0 | 1970.0 | 9785.0 |
| 2014-03-21 | CB | Futures | 94.164 | 94.431 | 94.164 | 94.304 | 10.0 |
| 2014-03-21 | CC | Futures | 2216.0 | 2225.0 | 2191.0 | 2195.0 | 11074.0 |
| 2014-03-21 | CNH | Futures | 7.1312 | 7.1312 | 7.1172 | 7.1227 | 4.0 |
| 2014-03-21 | CSC | Futures | 4.517 | 4.529 | 4.517 | 4.529 | 26.0 |
| 2014-03-21 | CT | Futures | 103.46 | 105.2 | 103.46 | 104.88 | 10067.0 |
| 2014-03-21 | DC | Futures | 35.6 | 36.17 | 35.48 | 36.15 | 88.0 |
| 2014-03-21 | DX | Futures | 76.32 | 76.368 | 76.187 | 76.25 | 20164.0 |
| 2014-03-21 | E1 | Futures | 1.45329 | 1.45689 | 1.45227 | 1.45509 | 21759.0 |
| 2014-03-21 | E6 | Futures | 1.62679 | 1.63021 | 1.6249 | 1.6282 | 140894.0 |
| 2014-03-21 | E7 | Futures | 1.6158 | 1.6193 | 1.6142 | 1.6174 | 3049.0 |
| 2014-03-21 | EBM | Futures | 298.04 | 298.75 | 295.22 | 296.98 | 9225.0 |
| 2014-03-21 | ED | Futures | 95.3804 | 95.3851 | 95.3804 | 95.3804 | 87636.0 |
| 2014-03-21 | ER | Futures | 97.803 | 97.813 | 97.793 | 97.798 | 78910.0 |
| 2014-03-21 | EW | Futures | 1421.3 | 1435.2 | 1418.5 | 1420.0 | 21883.0 |
| 2014-03-21 | FBTP | Futures | 86.31 | 86.52 | 86.31 | 86.46 | 34924.0 |
| 2014-03-21 | FBTS | Futures | 97.02 | 97.064 | 96.968 | 97.038 | 9714.0 |
| 2014-03-21 | FCE | Futures | 3363.7 | 3379.7 | 3334.2 | 3366.1 | 117812.0 |
| 2014-03-21 | FDAX | Futures | 10303.2 | 10378.3 | 10257.4 | 10360.7 | 101668.0 |
| 2014-03-21 | FDIV | Futures | 139.3 | 139.88 | 138.51 | 139.88 | 4.0 |
| 2014-03-21 | FESX | Futures | 2172.3 | 2186.0 | 2152.9 | 2178.8 | 978550.0 |
| 2014-03-21 | FEU3 | Futures | 98.418 | 98.418 | 98.418 | 98.418 | 2.0 |
| 2014-03-21 | FGBL | Futures | 122.86 | 123.05 | 122.81 | 122.98 | 415161.0 |
| 2014-03-21 | FGBM | Futures | 119.27 | 119.34 | 119.21 | 119.28 | 291212.0 |
| 2014-03-21 | FGBS | Futures | 110.413 | 110.448 | 110.398 | 110.428 | 250732.0 |
| 2014-03-21 | FGBX | Futures | 125.18 | 125.73 | 125.16 | 125.56 | 10847.0 |
| 2014-03-21 | FMWO | Futures | 5488.8 | 5488.8 | 5488.8 | 5488.8 | 127.0 |
| 2014-03-21 | FOAT | Futures | 111.69 | 111.97 | 111.68 | 111.93 | 46831.0 |
| 2014-03-21 | FTDX | Futures | 1162.5 | 1176.1 | 1154.5 | 1162.5 | 516.0 |
| 2014-03-21 | FTI | Futures | 333.87 | 335.88 | 331.52 | 334.0 | 37686.0 |
| 2014-03-21 | FTUK | Futures | 4939.5 | 4967.4 | 4919.7 | 4959.4 | 119080.0 |
| 2014-03-21 | FVSA | Futures | 1850.7 | 1860.73 | 1820.6 | 1825.62 | 14164.0 |
| 2014-03-21 | FXXP | Futures | 241.7 | 243.0 | 240.7 | 242.5 | 8143.0 |
| 2014-03-21 | G | Futures | 93.13 | 93.32 | 92.95 | 93.21 | 123599.0 |
| 2014-03-21 | GF | Futures | 279.756 | 281.317 | 278.675 | 280.596 | 1140.0 |
| 2014-03-21 | GSCI | Futures | 1060.67 | 1064.47 | 1055.62 | 1057.86 | 128.0 |
| 2014-03-21 | HE | Futures | 147.446 | 148.758 | 145.696 | 147.3 | 213.0 |
> showing 50 of 106 rows — these rows as CSV