PREVIEW / futures_daily / 2011-08-08
file: by_date/futures_daily/2011/2011-08-08.parquet size: 9 KB rows: 94
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-08-08 | ES | Futures | 1159.24 | 1180.84 | 1101.88 | 1103.62 | 6173318.0 |
| 2011-08-08 | NQ | Futures | 2442.64 | 2471.96 | 2313.39 | 2320.79 | 731047.0 |
| 2011-08-08 | YM | Futures | 10549.8 | 10702.9 | 10120.6 | 10140.4 | 360230.0 |
| 2011-08-08 | CL | Futures | 164.26 | 164.3 | 153.64 | 155.83 | 521066.0 |
| 2011-08-08 | GC | Futures | 2270.6 | 2326.9 | 2270.6 | 2313.1 | 278274.0 |
| 2011-08-08 | ZN | Futures | 108.31578 | 109.699497 | 108.116206 | 109.486618 | 1882238.0 |
| 2011-08-08 | A6 | Futures | 0.90448 | 0.90448 | 0.88082 | 0.88351 | 240225.0 |
| 2011-08-08 | AD | Futures | 1.01423 | 1.01932 | 1.00255 | 1.00445 | 167268.0 |
| 2011-08-08 | B | Futures | 90.84 | 92.35 | 87.88 | 88.77 | 135243.0 |
| 2011-08-08 | B6 | Futures | 1.7103 | 1.715 | 1.6946 | 1.7006 | 135122.0 |
| 2011-08-08 | BFX | Futures | 2612.1 | 2645.3 | 2498.9 | 2498.9 | 244.0 |
| 2011-08-08 | BR | Futures | 0.27617 | 0.27662 | 0.2735 | 0.27599 | 475.0 |
| 2011-08-08 | BZ | Futures | 94.22 | 94.22 | 91.69 | 91.69 | 883.0 |
| 2011-08-08 | C | Futures | 1989.0 | 2011.0 | 1973.0 | 2002.0 | 5555.0 |
| 2011-08-08 | CC | Futures | 2329.0 | 2344.0 | 2296.0 | 2309.0 | 14758.0 |
| 2011-08-08 | CT | Futures | 130.33 | 134.2 | 127.83 | 128.49 | 79.0 |
| 2011-08-08 | DC | Futures | 34.01 | 34.39 | 33.48 | 33.69 | 460.0 |
| 2011-08-08 | DX | Futures | 73.672 | 74.489 | 73.435 | 74.215 | 38445.0 |
| 2011-08-08 | E1 | Futures | 1.7244 | 1.74925 | 1.71054 | 1.73186 | 65631.0 |
| 2011-08-08 | E6 | Futures | 1.70421 | 1.70944 | 1.67701 | 1.68402 | 470736.0 |
| 2011-08-08 | E7 | Futures | 1.6892 | 1.6969 | 1.6648 | 1.6717 | 5971.0 |
| 2011-08-08 | ED | Futures | 94.9382 | 94.9525 | 94.8763 | 94.9001 | 431378.0 |
| 2011-08-08 | ER | Futures | 97.588 | 97.732 | 97.573 | 97.653 | 165443.0 |
| 2011-08-08 | EW | Futures | 820.6 | 829.1 | 763.5 | 764.2 | 72300.0 |
| 2011-08-08 | FBTP | Futures | 60.72 | 62.87 | 60.72 | 62.48 | 27751.0 |
| 2011-08-08 | FCE | Futures | 2256.9 | 2351.0 | 2127.2 | 2204.1 | 336348.0 |
| 2011-08-08 | FDAX | Futures | 6498.1 | 6714.0 | 6109.2 | 6371.0 | 363032.0 |
| 2011-08-08 | FESX | Futures | 1494.5 | 1559.3 | 1417.5 | 1474.6 | 3503878.0 |
| 2011-08-08 | FEU3 | Futures | 98.148 | 98.228 | 98.148 | 98.193 | 27.0 |
| 2011-08-08 | FGBL | Futures | 105.57 | 107.25 | 104.74 | 106.76 | 1216535.0 |
| 2011-08-08 | FGBM | Futures | 108.3 | 109.32 | 107.94 | 109.01 | 651906.0 |
| 2011-08-08 | FGBS | Futures | 108.492 | 108.895 | 108.382 | 108.706 | 664867.0 |
| 2011-08-08 | FGBX | Futures | 103.91 | 105.88 | 101.87 | 104.9 | 9530.0 |
| 2011-08-08 | FTDX | Futures | 619.8 | 643.0 | 581.9 | 606.4 | 726.0 |
| 2011-08-08 | FTI | Futures | 240.79 | 246.72 | 227.91 | 234.41 | 92347.0 |
| 2011-08-08 | FTUK | Futures | 3641.5 | 3723.0 | 3421.4 | 3580.2 | 283230.0 |
| 2011-08-08 | FXXP | Futures | 159.1 | 162.7 | 152.2 | 155.7 | 4172.0 |
| 2011-08-08 | G | Futures | 88.0 | 89.02 | 87.95 | 88.8 | 128127.0 |
| 2011-08-08 | GF | Futures | 309.444 | 310.664 | 307.062 | 308.108 | 1152.0 |
| 2011-08-08 | GSCI | Futures | 1009.64 | 1015.48 | 987.93 | 988.25 | 2275.0 |
| 2011-08-08 | HE | Futures | 111.756 | 112.061 | 110.046 | 110.321 | 14532.0 |
| 2011-08-08 | HG | Futures | 5.3658 | 5.453 | 5.1853 | 5.2369 | 70638.0 |
| 2011-08-08 | HO | Futures | 2.3762 | 2.3762 | 2.2531 | 2.2683 | 68697.0 |
| 2011-08-08 | HRC | Futures | 2890.0 | 2890.0 | 2890.0 | 2890.0 | 0.0 |
| 2011-08-08 | J1 | Futures | 0.016086 | 0.0162368 | 0.0160244 | 0.0162029 | 124891.0 |
| 2011-08-08 | J7 | Futures | 0.015981 | 0.016126 | 0.015922 | 0.016095 | 532.0 |
| 2011-08-08 | JB | Futures | 123.83 | 124.03 | 123.37 | 123.93 | 2760.0 |
| 2011-08-08 | KC | Futures | 560.56 | 560.68 | 547.32 | 554.06 | 13447.0 |
| 2011-08-08 | KE | Futures | 2938.37 | 3003.67 | 2892.28 | 2900.92 | 13713.0 |
| 2011-08-08 | L | Futures | 98.473 | 98.473 | 98.453 | 98.453 | 44194.0 |
> showing 50 of 94 rows — these rows as CSV