PREVIEW / futures_daily / 2012-07-10
file: by_date/futures_daily/2012/2012-07-10.parquet size: 9 KB rows: 97
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 |
|---|---|---|---|---|---|---|---|
| 2012-07-10 | ES | Futures | 1366.16 | 1373.75 | 1347.42 | 1352.49 | 2020477.0 |
| 2012-07-10 | NQ | Futures | 2991.07 | 3013.45 | 2948.03 | 2958.93 | 250297.0 |
| 2012-07-10 | YM | Futures | 12307.6 | 12386.2 | 12168.9 | 12209.7 | 151052.0 |
| 2012-07-10 | CL | Futures | 156.55 | 156.75 | 152.55 | 153.03 | 291409.0 |
| 2012-07-10 | GC | Futures | 2124.3 | 2141.5 | 2091.3 | 2111.9 | 151155.0 |
| 2012-07-10 | ZN | Futures | 117.216926 | 117.353114 | 117.094357 | 117.339495 | 626012.0 |
| 2012-07-10 | A6 | Futures | 0.91195 | 0.91546 | 0.90773 | 0.91016 | 120335.0 |
| 2012-07-10 | AD | Futures | 0.98205 | 0.98466 | 0.97864 | 0.97874 | 73885.0 |
| 2012-07-10 | B | Futures | 89.52 | 89.52 | 87.47 | 87.65 | 202619.0 |
| 2012-07-10 | B6 | Futures | 1.6226 | 1.6249 | 1.6174 | 1.6201 | 80723.0 |
| 2012-07-10 | BR | Futures | 0.2326 | 0.2332 | 0.23195 | 0.23207 | 694.0 |
| 2012-07-10 | BZ | Futures | 94.42 | 95.21 | 93.91 | 93.91 | 3547.0 |
| 2012-07-10 | C | Futures | 1633.0 | 1649.0 | 1612.0 | 1637.0 | 14550.0 |
| 2012-07-10 | CB | Futures | 85.336 | 85.565 | 85.309 | 85.309 | 12.0 |
| 2012-07-10 | CC | Futures | 1747.0 | 1758.0 | 1710.0 | 1738.0 | 11752.0 |
| 2012-07-10 | CSC | Futures | 3.847 | 3.86 | 3.845 | 3.858 | 15.0 |
| 2012-07-10 | CT | Futures | 93.16 | 93.8 | 92.3 | 92.3 | 59.0 |
| 2012-07-10 | DC | Futures | 28.44 | 28.49 | 28.15 | 28.28 | 95.0 |
| 2012-07-10 | DX | Futures | 80.857 | 81.192 | 80.692 | 81.104 | 18930.0 |
| 2012-07-10 | E1 | Futures | 1.32615 | 1.32808 | 1.3175 | 1.3193 | 35315.0 |
| 2012-07-10 | E6 | Futures | 1.45422 | 1.45622 | 1.44454 | 1.44655 | 226816.0 |
| 2012-07-10 | E7 | Futures | 1.4452 | 1.4472 | 1.4354 | 1.4376 | 3028.0 |
| 2012-07-10 | ED | Futures | 95.1417 | 95.1465 | 95.1322 | 95.1417 | 83304.0 |
| 2012-07-10 | ER | Futures | 97.66 | 97.68 | 97.656 | 97.675 | 82245.0 |
| 2012-07-10 | EW | Futures | 956.8 | 962.5 | 940.1 | 944.1 | 24623.0 |
| 2012-07-10 | FBTP | Futures | 64.51 | 65.83 | 64.51 | 65.34 | 19104.0 |
| 2012-07-10 | FBTS | Futures | 84.153 | 84.79 | 84.07 | 84.368 | 3230.0 |
| 2012-07-10 | FCE | Futures | 2338.7 | 2373.9 | 2333.1 | 2351.7 | 113921.0 |
| 2012-07-10 | FDAX | Futures | 6981.4 | 7090.6 | 6933.4 | 7042.0 | 141362.0 |
| 2012-07-10 | FESX | Futures | 1504.1 | 1527.8 | 1498.7 | 1514.9 | 1038690.0 |
| 2012-07-10 | FGBL | Futures | 119.05 | 119.14 | 118.66 | 119.03 | 580717.0 |
| 2012-07-10 | FGBM | Futures | 116.56 | 116.64 | 116.39 | 116.49 | 360619.0 |
| 2012-07-10 | FGBS | Futures | 110.427 | 110.442 | 110.378 | 110.407 | 242011.0 |
| 2012-07-10 | FGBX | Futures | 126.79 | 127.58 | 126.53 | 127.03 | 6802.0 |
| 2012-07-10 | FOAT | Futures | 100.06 | 100.57 | 100.06 | 100.33 | 18810.0 |
| 2012-07-10 | FTDX | Futures | 706.3 | 709.6 | 705.8 | 705.8 | 36.0 |
| 2012-07-10 | FTI | Futures | 262.33 | 265.05 | 262.24 | 264.54 | 21.0 |
| 2012-07-10 | FTUK | Futures | 4081.7 | 4110.1 | 4060.6 | 4097.7 | 84972.0 |
| 2012-07-10 | FVSA | Futures | 7868.44 | 7913.66 | 7476.52 | 7642.33 | 963.0 |
| 2012-07-10 | FXXP | Futures | 181.5 | 183.3 | 180.8 | 182.9 | 778.0 |
| 2012-07-10 | G | Futures | 99.71 | 99.76 | 99.51 | 99.69 | 110166.0 |
| 2012-07-10 | GF | Futures | 284.987 | 286.122 | 282.668 | 282.915 | 3335.0 |
| 2012-07-10 | GSCI | Futures | 974.43 | 975.3 | 959.47 | 964.32 | 1455.0 |
| 2012-07-10 | HE | Futures | 99.817 | 100.164 | 98.374 | 98.427 | 29134.0 |
| 2012-07-10 | HG | Futures | 4.4291 | 4.4317 | 4.357 | 4.3776 | 40283.0 |
| 2012-07-10 | HO | Futures | 2.2304 | 2.2435 | 2.216 | 2.2212 | 27622.0 |
| 2012-07-10 | HRC | Futures | 2450.1 | 2450.1 | 2450.1 | 2450.1 | 50.0 |
| 2012-07-10 | J1 | Futures | 0.0157652 | 0.0158353 | 0.0157589 | 0.0157927 | 59739.0 |
| 2012-07-10 | J7 | Futures | 0.01571 | 0.015771 | 0.015708 | 0.015731 | 182.0 |
| 2012-07-10 | JB | Futures | 126.47 | 126.5 | 126.35 | 126.35 | 2180.0 |
> showing 50 of 97 rows — these rows as CSV