PREVIEW / futures_daily / 2013-05-28
file: by_date/futures_daily/2013/2013-05-28.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-05-28 | ES | Futures | 1693.99 | 1717.34 | 1688.08 | 1698.61 | 2091551.0 |
| 2013-05-28 | NQ | Futures | 3455.16 | 3507.72 | 3447.94 | 3469.31 | 238818.0 |
| 2013-05-28 | YM | Futures | 15070.9 | 15270.8 | 15036.5 | 15137.9 | 179762.0 |
| 2013-05-28 | CL | Futures | 163.73 | 167.27 | 162.58 | 165.69 | 240990.0 |
| 2013-05-28 | GC | Futures | 1841.9 | 1861.1 | 1822.4 | 1831.6 | 126897.0 |
| 2013-05-28 | ZN | Futures | 116.91934 | 117.002824 | 115.834048 | 116.112328 | 2983900.0 |
| 2013-05-28 | A6 | Futures | 0.88944 | 0.89368 | 0.88455 | 0.88851 | 158323.0 |
| 2013-05-28 | AD | Futures | 0.97371 | 0.97381 | 0.96477 | 0.96718 | 84739.0 |
| 2013-05-28 | B | Futures | 98.97 | 100.99 | 98.88 | 100.56 | 63666.0 |
| 2013-05-28 | B6 | Futures | 1.5824 | 1.5858 | 1.5721 | 1.5761 | 134350.0 |
| 2013-05-28 | BFX | Futures | 3277.6 | 3277.9 | 3277.6 | 3277.9 | 1.0 |
| 2013-05-28 | BR | Futures | 0.23703 | 0.23703 | 0.2351 | 0.2351 | 4220.0 |
| 2013-05-28 | BZ | Futures | 99.33 | 101.49 | 99.04 | 101.07 | 6206.0 |
| 2013-05-28 | C | Futures | 1636.0 | 1645.0 | 1611.0 | 1613.0 | 7196.0 |
| 2013-05-28 | CB | Futures | 80.129 | 80.129 | 79.651 | 79.77 | 27.0 |
| 2013-05-28 | CC | Futures | 1684.0 | 1696.0 | 1650.0 | 1653.0 | 16002.0 |
| 2013-05-28 | CNH | Futures | 7.1471 | 7.1471 | 7.1368 | 7.1446 | 54.0 |
| 2013-05-28 | CT | Futures | 97.68 | 99.39 | 97.47 | 97.58 | 14342.0 |
| 2013-05-28 | DC | Futures | 27.2 | 27.31 | 27.19 | 27.25 | 48.0 |
| 2013-05-28 | DX | Futures | 80.466 | 81.082 | 80.447 | 80.896 | 39145.0 |
| 2013-05-28 | E1 | Futures | 1.33747 | 1.34133 | 1.31522 | 1.32204 | 55751.0 |
| 2013-05-28 | E6 | Futures | 1.52533 | 1.52698 | 1.51507 | 1.51802 | 308706.0 |
| 2013-05-28 | E7 | Futures | 1.5155 | 1.5171 | 1.5052 | 1.5081 | 4206.0 |
| 2013-05-28 | ED | Futures | 95.2731 | 95.2731 | 95.2635 | 95.2683 | 198389.0 |
| 2013-05-28 | ER | Futures | 97.827 | 97.837 | 97.822 | 97.832 | 81343.0 |
| 2013-05-28 | EW | Futures | 1213.1 | 1231.7 | 1207.7 | 1216.8 | 20450.0 |
| 2013-05-28 | FBTP | Futures | 79.38 | 79.55 | 79.17 | 79.28 | 31634.0 |
| 2013-05-28 | FBTS | Futures | 92.954 | 93.066 | 92.937 | 92.972 | 9673.0 |
| 2013-05-28 | FCE | Futures | 3087.1 | 3142.1 | 3085.2 | 3125.8 | 119909.0 |
| 2013-05-28 | FDAX | Futures | 9340.6 | 9482.9 | 9333.3 | 9445.1 | 111674.0 |
| 2013-05-28 | FDIV | Futures | 127.95 | 128.35 | 127.95 | 128.35 | 25.0 |
| 2013-05-28 | FESX | Futures | 1955.3 | 1992.4 | 1953.9 | 1984.7 | 1020298.0 |
| 2013-05-28 | FGBL | Futures | 120.82 | 121.01 | 120.34 | 120.54 | 1003880.0 |
| 2013-05-28 | FGBM | Futures | 117.72 | 117.86 | 117.52 | 117.64 | 653292.0 |
| 2013-05-28 | FGBS | Futures | 110.482 | 110.522 | 110.437 | 110.472 | 347830.0 |
| 2013-05-28 | FGBX | Futures | 125.94 | 126.51 | 125.2 | 125.5 | 15518.0 |
| 2013-05-28 | FMWO | Futures | 4937.1 | 4940.9 | 4932.0 | 4932.0 | 68.0 |
| 2013-05-28 | FOAT | Futures | 108.53 | 108.68 | 108.29 | 108.41 | 59474.0 |
| 2013-05-28 | FTDX | Futures | 921.7 | 931.6 | 921.7 | 928.8 | 79.0 |
| 2013-05-28 | FTI | Futures | 319.22 | 324.7 | 319.14 | 323.23 | 26794.0 |
| 2013-05-28 | FTUK | Futures | 4964.9 | 5036.6 | 4961.5 | 5022.1 | 107245.0 |
| 2013-05-28 | FVSA | Futures | 2944.86 | 2944.86 | 2838.05 | 2891.46 | 6067.0 |
| 2013-05-28 | FXXP | Futures | 224.8 | 227.2 | 224.8 | 226.5 | 4562.0 |
| 2013-05-28 | G | Futures | 98.23 | 98.53 | 97.96 | 98.11 | 330534.0 |
| 2013-05-28 | GF | Futures | 243.003 | 245.404 | 242.034 | 245.109 | 2721.0 |
| 2013-05-28 | GSCI | Futures | 1018.95 | 1026.32 | 1018.95 | 1020.4 | 1501.0 |
| 2013-05-28 | HE | Futures | 92.923 | 93.487 | 92.531 | 92.898 | 10617.0 |
| 2013-05-28 | HG | Futures | 4.1946 | 4.2621 | 4.1628 | 4.2233 | 61809.0 |
| 2013-05-28 | HH | Futures | 48.71 | 48.901 | 46.889 | 47.463 | 664.0 |
| 2013-05-28 | HO | Futures | 2.3017 | 2.3551 | 2.301 | 2.3441 | 6769.0 |
> showing 50 of 103 rows — these rows as CSV