PREVIEW / futures_daily / 2013-09-19
file: by_date/futures_daily/2013/2013-09-19.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 |
|---|---|---|---|---|---|---|---|
| 2013-09-19 | ES | Futures | 1765.29 | 1773.76 | 1759.89 | 1764.26 | 1860579.0 |
| 2013-09-19 | NQ | Futures | 3703.42 | 3718.64 | 3703.42 | 3712.33 | 212425.0 |
| 2013-09-19 | YM | Futures | 15523.9 | 15579.6 | 15479.1 | 15495.1 | 123610.0 |
| 2013-09-19 | CL | Futures | 190.21 | 191.47 | 186.88 | 187.41 | 301286.0 |
| 2013-09-19 | GC | Futures | 1805.3 | 1819.0 | 1796.7 | 1811.0 | 180030.0 |
| 2013-09-19 | ZN | Futures | 113.918043 | 114.172957 | 113.422378 | 113.479025 | 1437341.0 |
| 2013-09-19 | A6 | Futures | 0.89208 | 0.89454 | 0.88547 | 0.8866 | 99285.0 |
| 2013-09-19 | AD | Futures | 0.98562 | 0.99016 | 0.98208 | 0.98269 | 78093.0 |
| 2013-09-19 | B | Futures | 109.79 | 110.13 | 107.42 | 107.66 | 201584.0 |
| 2013-09-19 | B6 | Futures | 1.6926 | 1.6939 | 1.6809 | 1.682 | 138043.0 |
| 2013-09-19 | BFX | Futures | 3424.0 | 3424.0 | 3410.5 | 3412.4 | 28.0 |
| 2013-09-19 | BR | Futures | 0.22784 | 0.22784 | 0.22619 | 0.22743 | 183.0 |
| 2013-09-19 | BZ | Futures | 110.61 | 110.95 | 108.26 | 108.47 | 6103.0 |
| 2013-09-19 | C | Futures | 1831.0 | 1839.0 | 1809.0 | 1826.0 | 7968.0 |
| 2013-09-19 | CB | Futures | 72.176 | 72.896 | 72.056 | 72.896 | 28.0 |
| 2013-09-19 | CC | Futures | 1960.0 | 1980.0 | 1941.0 | 1960.0 | 10325.0 |
| 2013-09-19 | CSC | Futures | 3.251 | 3.251 | 3.242 | 3.247 | 12.0 |
| 2013-09-19 | CT | Futures | 101.82 | 101.82 | 101.35 | 101.63 | 7.0 |
| 2013-09-19 | DC | Futures | 24.81 | 24.93 | 24.76 | 24.89 | 104.0 |
| 2013-09-19 | DX | Futures | 76.495 | 76.757 | 76.371 | 76.681 | 36224.0 |
| 2013-09-19 | E1 | Futures | 1.40832 | 1.41475 | 1.4073 | 1.41218 | 42711.0 |
| 2013-09-19 | E6 | Futures | 1.59469 | 1.60177 | 1.59374 | 1.59669 | 224931.0 |
| 2013-09-19 | E7 | Futures | 1.5848 | 1.5916 | 1.5836 | 1.5864 | 3014.0 |
| 2013-09-19 | ED | Futures | 95.3303 | 95.3399 | 95.3255 | 95.3351 | 112518.0 |
| 2013-09-19 | ER | Futures | 97.847 | 97.852 | 97.842 | 97.842 | 84901.0 |
| 2013-09-19 | EW | Futures | 1279.6 | 1285.7 | 1274.5 | 1278.9 | 17475.0 |
| 2013-09-19 | FBTP | Futures | 78.61 | 78.99 | 78.37 | 78.6 | 44764.0 |
| 2013-09-19 | FBTS | Futures | 93.696 | 93.8 | 93.653 | 93.722 | 8972.0 |
| 2013-09-19 | FCE | Futures | 3261.3 | 3261.7 | 3228.1 | 3239.3 | 60470.0 |
| 2013-09-19 | FDAX | Futures | 9709.6 | 9741.8 | 9624.8 | 9643.6 | 36826.0 |
| 2013-09-19 | FESX | Futures | 2065.6 | 2065.6 | 2039.0 | 2045.3 | 661264.0 |
| 2013-09-19 | FEU3 | Futures | 98.468 | 98.468 | 98.463 | 98.463 | 5561.0 |
| 2013-09-19 | FGBL | Futures | 118.74 | 118.79 | 117.88 | 117.99 | 875771.0 |
| 2013-09-19 | FGBM | Futures | 117.35 | 117.42 | 116.89 | 116.96 | 574111.0 |
| 2013-09-19 | FGBS | Futures | 110.413 | 110.433 | 110.328 | 110.363 | 466987.0 |
| 2013-09-19 | FGBX | Futures | 120.51 | 120.51 | 118.02 | 118.37 | 26823.0 |
| 2013-09-19 | FMWO | Futures | 5187.7 | 5187.7 | 5170.0 | 5170.0 | 15.0 |
| 2013-09-19 | FOAT | Futures | 106.17 | 106.59 | 105.69 | 105.82 | 69467.0 |
| 2013-09-19 | FTDX | Futures | 1008.7 | 1019.1 | 1007.8 | 1013.4 | 112.0 |
| 2013-09-19 | FTI | Futures | 332.45 | 334.22 | 330.5 | 331.28 | 14658.0 |
| 2013-09-19 | FTUK | Futures | 4954.2 | 4973.3 | 4934.7 | 4945.9 | 106903.0 |
| 2013-09-19 | FVSA | Futures | 2477.89 | 2484.41 | 2412.68 | 2458.33 | 5056.0 |
| 2013-09-19 | FXXP | Futures | 230.8 | 230.9 | 227.6 | 229.2 | 5172.0 |
| 2013-09-19 | G | Futures | 91.32 | 91.53 | 90.88 | 90.98 | 200315.0 |
| 2013-09-19 | GF | Futures | 258.798 | 259.817 | 258.513 | 259.817 | 1661.0 |
| 2013-09-19 | GSCI | Futures | 1089.19 | 1090.61 | 1075.45 | 1077.04 | 185.0 |
| 2013-09-19 | HE | Futures | 111.098 | 111.446 | 110.244 | 110.497 | 14412.0 |
| 2013-09-19 | HG | Futures | 4.1981 | 4.25 | 4.1924 | 4.238 | 44655.0 |
| 2013-09-19 | HH | Futures | 40.348 | 41.19 | 39.775 | 40.164 | 4147.0 |
| 2013-09-19 | HO | Futures | 2.4388 | 2.4511 | 2.3993 | 2.4046 | 16582.0 |
> showing 50 of 103 rows — these rows as CSV