PREVIEW / futures_daily / 2013-07-26
file: by_date/futures_daily/2013/2013-07-26.parquet size: 9 KB rows: 101
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 |
|---|---|---|---|---|---|---|---|
| 2013-07-26 | ES | Futures | 1736.26 | 1739.61 | 1720.55 | 1737.03 | 1400373.0 |
| 2013-07-26 | NQ | Futures | 3531.56 | 3555.27 | 3513.63 | 3551.8 | 183575.0 |
| 2013-07-26 | YM | Futures | 15357.0 | 15384.7 | 15207.3 | 15361.0 | 122848.0 |
| 2013-07-26 | CL | Futures | 184.36 | 184.48 | 181.46 | 182.86 | 208855.0 |
| 2013-07-26 | GC | Futures | 1764.0 | 1773.4 | 1735.6 | 1748.3 | 63640.0 |
| 2013-07-26 | ZN | Futures | 113.728002 | 113.92452 | 113.601669 | 113.812224 | 700602.0 |
| 2013-07-26 | A6 | Futures | 0.86376 | 0.8692 | 0.86273 | 0.86582 | 75917.0 |
| 2013-07-26 | AD | Futures | 0.97842 | 0.98064 | 0.97671 | 0.97862 | 51590.0 |
| 2013-07-26 | B | Futures | 104.7 | 104.85 | 103.65 | 104.23 | 56349.0 |
| 2013-07-26 | B6 | Futures | 1.6126 | 1.6159 | 1.6095 | 1.6124 | 80129.0 |
| 2013-07-26 | BFX | Futures | 3190.1 | 3190.1 | 3169.5 | 3169.5 | 33.0 |
| 2013-07-26 | BR | Futures | 0.21851 | 0.219 | 0.21774 | 0.21811 | 862.0 |
| 2013-07-26 | BZ | Futures | 105.4 | 105.4 | 104.41 | 104.99 | 4906.0 |
| 2013-07-26 | C | Futures | 1686.0 | 1693.0 | 1671.0 | 1672.0 | 4658.0 |
| 2013-07-26 | CB | Futures | 75.465 | 75.465 | 74.628 | 74.628 | 14.0 |
| 2013-07-26 | CC | Futures | 1746.0 | 1764.0 | 1741.0 | 1743.0 | 12353.0 |
| 2013-07-26 | CSC | Futures | 3.509 | 3.509 | 3.431 | 3.442 | 54.0 |
| 2013-07-26 | CT | Futures | 102.82 | 102.82 | 101.4 | 101.67 | 15.0 |
| 2013-07-26 | DC | Futures | 27.02 | 27.02 | 26.3 | 26.46 | 352.0 |
| 2013-07-26 | DX | Futures | 78.252 | 78.291 | 78.023 | 78.142 | 25295.0 |
| 2013-07-26 | E1 | Futures | 1.38275 | 1.38815 | 1.38185 | 1.38468 | 24775.0 |
| 2013-07-26 | E6 | Futures | 1.56672 | 1.56955 | 1.56424 | 1.56707 | 153736.0 |
| 2013-07-26 | E7 | Futures | 1.5566 | 1.5592 | 1.5542 | 1.5568 | 2244.0 |
| 2013-07-26 | ED | Futures | 95.2916 | 95.2964 | 95.2869 | 95.2916 | 48408.0 |
| 2013-07-26 | ER | Futures | 97.817 | 97.827 | 97.813 | 97.817 | 51167.0 |
| 2013-07-26 | EW | Futures | 1254.8 | 1257.3 | 1242.4 | 1248.5 | 18090.0 |
| 2013-07-26 | FBTP | Futures | 77.78 | 77.79 | 77.45 | 77.65 | 22021.0 |
| 2013-07-26 | FBTS | Futures | 93.031 | 93.049 | 92.954 | 93.023 | 6178.0 |
| 2013-07-26 | FCE | Futures | 3074.4 | 3095.7 | 3062.4 | 3071.7 | 79836.0 |
| 2013-07-26 | FDAX | Futures | 9254.6 | 9284.6 | 9120.9 | 9156.9 | 88146.0 |
| 2013-07-26 | FESX | Futures | 1933.7 | 1942.9 | 1917.6 | 1925.3 | 744891.0 |
| 2013-07-26 | FGBL | Futures | 119.41 | 119.53 | 119.04 | 119.3 | 542934.0 |
| 2013-07-26 | FGBM | Futures | 117.22 | 117.31 | 117.02 | 117.15 | 394457.0 |
| 2013-07-26 | FGBS | Futures | 110.303 | 110.328 | 110.283 | 110.293 | 271364.0 |
| 2013-07-26 | FGBX | Futures | 123.42 | 123.67 | 122.69 | 123.15 | 8887.0 |
| 2013-07-26 | FMWO | Futures | 4972.5 | 4972.5 | 4940.8 | 4940.8 | 24.0 |
| 2013-07-26 | FOAT | Futures | 106.4 | 106.54 | 106.2 | 106.32 | 31414.0 |
| 2013-07-26 | FTDX | Futures | 932.0 | 932.0 | 929.6 | 931.5 | 365.0 |
| 2013-07-26 | FTI | Futures | 324.05 | 324.7 | 320.24 | 321.2 | 22483.0 |
| 2013-07-26 | FTUK | Futures | 4921.5 | 4938.4 | 4864.5 | 4881.0 | 61452.0 |
| 2013-07-26 | FVSA | Futures | 2681.06 | 2787.73 | 2666.83 | 2780.62 | 2672.0 |
| 2013-07-26 | FXXP | Futures | 221.2 | 221.6 | 219.1 | 219.7 | 2096.0 |
| 2013-07-26 | G | Futures | 94.88 | 95.21 | 94.8 | 95.16 | 92811.0 |
| 2013-07-26 | GF | Futures | 256.693 | 257.999 | 256.314 | 257.114 | 1900.0 |
| 2013-07-26 | GSCI | Futures | 1048.56 | 1048.56 | 1038.17 | 1040.79 | 273.0 |
| 2013-07-26 | HE | Futures | 102.376 | 102.453 | 100.775 | 101.007 | 12456.0 |
| 2013-07-26 | HG | Futures | 4.0482 | 4.0527 | 3.9264 | 3.9404 | 56000.0 |
| 2013-07-26 | HH | Futures | 39.793 | 39.793 | 39.231 | 39.253 | 1646.0 |
| 2013-07-26 | HO | Futures | 2.4363 | 2.4407 | 2.4092 | 2.4198 | 45053.0 |
| 2013-07-26 | HRC | Futures | 2249.0 | 2249.0 | 2249.0 | 2249.0 | 0.0 |
> showing 50 of 101 rows — these rows as CSV