PREVIEW / futures_daily / 2011-07-11
file: by_date/futures_daily/2011/2011-07-11.parquet size: 9 KB rows: 95
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 |
|---|---|---|---|---|---|---|---|
| 2011-07-11 | ES | Futures | 1330.05 | 1330.3 | 1302.74 | 1309.45 | 2432258.0 |
| 2011-07-11 | NQ | Futures | 2737.86 | 2737.86 | 2677.5 | 2695.44 | 280079.0 |
| 2011-07-11 | YM | Futures | 11910.2 | 11910.2 | 11736.3 | 11807.2 | 126772.0 |
| 2011-07-11 | CL | Futures | 184.4 | 185.64 | 180.63 | 182.57 | 311449.0 |
| 2011-07-11 | GC | Futures | 2091.0 | 2108.1 | 2087.1 | 2096.7 | 147083.0 |
| 2011-07-11 | ZN | Futures | 105.441906 | 106.080545 | 105.255637 | 106.053935 | 1361924.0 |
| 2011-07-11 | A6 | Futures | 0.925 | 0.92535 | 0.91648 | 0.91778 | 110412.0 |
| 2011-07-11 | AD | Futures | 1.03618 | 1.03638 | 1.0274 | 1.0291 | 77710.0 |
| 2011-07-11 | B | Futures | 100.19 | 100.23 | 97.63 | 99.29 | 149491.0 |
| 2011-07-11 | B6 | Futures | 1.6662 | 1.6673 | 1.6506 | 1.6534 | 118428.0 |
| 2011-07-11 | BFX | Futures | 2998.2 | 2999.4 | 2967.7 | 2974.6 | 83.0 |
| 2011-07-11 | BR | Futures | 0.28036 | 0.28036 | 0.2784 | 0.27905 | 473.0 |
| 2011-07-11 | BZ | Futures | 103.68 | 103.68 | 102.34 | 103.12 | 912.0 |
| 2011-07-11 | C | Futures | 2094.0 | 2115.0 | 2088.0 | 2092.0 | 13448.0 |
| 2011-07-11 | CC | Futures | 2442.0 | 2449.0 | 2413.0 | 2418.0 | 9265.0 |
| 2011-07-11 | CSC | Futures | 4.6 | 4.6 | 4.595 | 4.595 | 1.0 |
| 2011-07-11 | CT | Futures | 150.24 | 150.24 | 144.8 | 144.8 | 55.0 |
| 2011-07-11 | DC | Futures | 30.98 | 31.05 | 30.83 | 30.97 | 67.0 |
| 2011-07-11 | DX | Futures | 74.831 | 75.816 | 74.811 | 75.637 | 35976.0 |
| 2011-07-11 | E1 | Futures | 1.56498 | 1.57099 | 1.56001 | 1.56694 | 49760.0 |
| 2011-07-11 | E6 | Futures | 1.68556 | 1.68651 | 1.65777 | 1.66228 | 419777.0 |
| 2011-07-11 | E7 | Futures | 1.6742 | 1.6742 | 1.6458 | 1.6501 | 6721.0 |
| 2011-07-11 | ED | Futures | 94.9477 | 94.9477 | 94.8858 | 94.8953 | 492958.0 |
| 2011-07-11 | ER | Futures | 97.281 | 97.341 | 97.276 | 97.326 | 231204.0 |
| 2011-07-11 | EW | Futures | 992.5 | 993.2 | 971.0 | 974.6 | 18418.0 |
| 2011-07-11 | FBTP | Futures | 62.62 | 62.66 | 60.33 | 60.39 | 13435.0 |
| 2011-07-11 | FCE | Futures | 2712.5 | 2712.5 | 2627.3 | 2648.5 | 273655.0 |
| 2011-07-11 | FDAX | Futures | 7917.6 | 7924.6 | 7703.4 | 7752.0 | 174261.0 |
| 2011-07-11 | FESX | Futures | 1781.8 | 1781.8 | 1728.0 | 1738.2 | 2053871.0 |
| 2011-07-11 | FEU3 | Futures | 97.84 | 97.87 | 97.84 | 97.865 | 4.0 |
| 2011-07-11 | FGBL | Futures | 102.28 | 103.77 | 102.17 | 103.6 | 1419462.0 |
| 2011-07-11 | FGBM | Futures | 106.11 | 107.11 | 106.06 | 106.99 | 809249.0 |
| 2011-07-11 | FGBS | Futures | 107.313 | 107.741 | 107.298 | 107.696 | 1042639.0 |
| 2011-07-11 | FGBX | Futures | 98.2 | 100.99 | 98.18 | 100.52 | 8624.0 |
| 2011-07-11 | FTDX | Futures | 802.9 | 802.9 | 779.7 | 782.8 | 791.0 |
| 2011-07-11 | FTI | Futures | 281.2 | 281.32 | 276.18 | 277.47 | 12033.0 |
| 2011-07-11 | FTUK | Futures | 4204.8 | 4216.1 | 4135.3 | 4156.9 | 125477.0 |
| 2011-07-11 | FXXP | Futures | 184.3 | 184.4 | 181.5 | 182.1 | 1639.0 |
| 2011-07-11 | G | Futures | 85.35 | 86.09 | 85.15 | 85.94 | 142018.0 |
| 2011-07-11 | GF | Futures | 332.219 | 334.95 | 330.07 | 333.149 | 4236.0 |
| 2011-07-11 | GSCI | Futures | 1082.12 | 1092.37 | 1082.12 | 1092.37 | 1859.0 |
| 2011-07-11 | HE | Futures | 105.62 | 109.256 | 105.317 | 109.256 | 23445.0 |
| 2011-07-11 | HG | Futures | 5.8305 | 5.843 | 5.7307 | 5.7743 | 40997.0 |
| 2011-07-11 | HO | Futures | 2.5108 | 2.5303 | 2.4693 | 2.5083 | 24392.0 |
| 2011-07-11 | HRC | Futures | 3031.0 | 3031.0 | 3031.0 | 3031.0 | 0.0 |
| 2011-07-11 | J1 | Futures | 0.0156159 | 0.0157001 | 0.0155568 | 0.0156888 | 110033.0 |
| 2011-07-11 | J7 | Futures | 0.015485 | 0.015594 | 0.015455 | 0.015584 | 354.0 |
| 2011-07-11 | JB | Futures | 122.4 | 122.88 | 122.35 | 122.84 | 2322.0 |
| 2011-07-11 | KC | Futures | 621.48 | 622.19 | 605.87 | 612.85 | 12858.0 |
| 2011-07-11 | KE | Futures | 2800.1 | 2811.62 | 2699.27 | 2731.92 | 9041.0 |
> showing 50 of 95 rows — these rows as CSV