PREVIEW / futures_daily / 2011-06-08
file: by_date/futures_daily/2011/2011-06-08.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-06-08 | ES | Futures | 1272.16 | 1274.88 | 1263.5 | 1264.24 | 2695851.0 |
| 2011-06-08 | NQ | Futures | 2589.26 | 2594.38 | 2558.79 | 2560.22 | 274206.0 |
| 2011-06-08 | YM | Futures | 11347.9 | 11369.5 | 11286.8 | 11310.3 | 124115.0 |
| 2011-06-08 | CL | Futures | 191.3 | 195.74 | 188.31 | 193.53 | 484275.0 |
| 2011-06-08 | GC | Futures | 2091.0 | 2094.3 | 2073.2 | 2082.5 | 111685.0 |
| 2011-06-08 | ZN | Futures | 105.056062 | 105.561651 | 104.962927 | 105.348771 | 1435582.0 |
| 2011-06-08 | A6 | Futures | 0.91857 | 0.91908 | 0.90742 | 0.91059 | 134769.0 |
| 2011-06-08 | AD | Futures | 1.02171 | 1.02211 | 1.01375 | 1.01654 | 95015.0 |
| 2011-06-08 | B | Futures | 99.66 | 101.13 | 98.67 | 100.5 | 141005.0 |
| 2011-06-08 | B6 | Futures | 1.7079 | 1.7086 | 1.6981 | 1.7028 | 123079.0 |
| 2011-06-08 | BFX | Futures | 3098.3 | 3102.7 | 3073.1 | 3076.6 | 113.0 |
| 2011-06-08 | BR | Futures | 0.27666 | 0.27666 | 0.27666 | 0.27666 | 75.0 |
| 2011-06-08 | BZ | Futures | 103.4 | 104.92 | 103.4 | 104.8 | 617.0 |
| 2011-06-08 | C | Futures | 1938.0 | 1968.0 | 1938.0 | 1965.0 | 4403.0 |
| 2011-06-08 | CB | Futures | 114.929 | 115.066 | 114.929 | 115.066 | 9.0 |
| 2011-06-08 | CC | Futures | 2301.0 | 2329.0 | 2293.0 | 2316.0 | 10946.0 |
| 2011-06-08 | CT | Futures | 146.44 | 148.61 | 142.83 | 143.57 | 16785.0 |
| 2011-06-08 | DC | Futures | 30.34 | 30.9 | 30.19 | 30.68 | 282.0 |
| 2011-06-08 | DX | Futures | 73.218 | 73.626 | 73.193 | 73.57 | 40814.0 |
| 2011-06-08 | E1 | Futures | 1.56512 | 1.56865 | 1.5625 | 1.56459 | 48375.0 |
| 2011-06-08 | E6 | Futures | 1.73978 | 1.74026 | 1.72486 | 1.72664 | 312970.0 |
| 2011-06-08 | E7 | Futures | 1.7266 | 1.7272 | 1.7121 | 1.7138 | 5981.0 |
| 2011-06-08 | ED | Futures | 94.9668 | 94.974 | 94.9668 | 94.9716 | 212666.0 |
| 2011-06-08 | ER | Futures | 97.316 | 97.316 | 97.296 | 97.306 | 189275.0 |
| 2011-06-08 | EW | Futures | 944.7 | 946.4 | 933.8 | 934.0 | 34106.0 |
| 2011-06-08 | FBTP | Futures | 65.29 | 65.33 | 65.12 | 65.16 | 7586.0 |
| 2011-06-08 | FCE | Futures | 2667.6 | 2675.3 | 2643.3 | 2659.6 | 145549.0 |
| 2011-06-08 | FDAX | Futures | 7538.9 | 7573.1 | 7466.8 | 7535.7 | 166315.0 |
| 2011-06-08 | FESX | Futures | 1763.9 | 1771.6 | 1749.8 | 1761.3 | 1353189.0 |
| 2011-06-08 | FEU3 | Futures | 97.855 | 97.855 | 97.85 | 97.85 | 92.0 |
| 2011-06-08 | FGBL | Futures | 100.01 | 100.28 | 99.9 | 100.18 | 1052759.0 |
| 2011-06-08 | FGBM | Futures | 104.39 | 104.71 | 104.33 | 104.6 | 640163.0 |
| 2011-06-08 | FGBS | Futures | 106.702 | 106.826 | 106.677 | 106.781 | 590237.0 |
| 2011-06-08 | FGBX | Futures | 95.5 | 95.97 | 95.5 | 95.88 | 5734.0 |
| 2011-06-08 | FTDX | Futures | 791.3 | 795.8 | 785.0 | 788.2 | 469.0 |
| 2011-06-08 | FTI | Futures | 276.44 | 277.46 | 273.89 | 275.33 | 45586.0 |
| 2011-06-08 | FTUK | Futures | 4095.5 | 4103.5 | 4045.5 | 4066.1 | 125205.0 |
| 2011-06-08 | FXXP | Futures | 181.3 | 181.3 | 179.5 | 180.2 | 12375.0 |
| 2011-06-08 | G | Futures | 83.97 | 84.18 | 83.57 | 84.12 | 131132.0 |
| 2011-06-08 | GF | Futures | 290.852 | 291.665 | 288.237 | 290.038 | 1988.0 |
| 2011-06-08 | GSCI | Futures | 1084.08 | 1108.73 | 1084.08 | 1101.69 | 2991.0 |
| 2011-06-08 | HE | Futures | 95.437 | 98.291 | 95.037 | 97.464 | 29771.0 |
| 2011-06-08 | HG | Futures | 5.5175 | 5.5255 | 5.382 | 5.4584 | 46312.0 |
| 2011-06-08 | HO | Futures | 2.5151 | 2.5432 | 2.4908 | 2.5312 | 14132.0 |
| 2011-06-08 | HRC | Futures | 3118.0 | 3118.0 | 3118.0 | 3118.0 | 0.0 |
| 2011-06-08 | J1 | Futures | 0.0156825 | 0.0157642 | 0.0156435 | 0.0157189 | 136368.0 |
| 2011-06-08 | J7 | Futures | 0.015569 | 0.015669 | 0.015554 | 0.015623 | 318.0 |
| 2011-06-08 | KC | Futures | 629.71 | 634.99 | 618.68 | 632.71 | 13164.0 |
| 2011-06-08 | KE | Futures | 3452.01 | 3538.9 | 3442.14 | 3495.46 | 17876.0 |
| 2011-06-08 | KRW | Futures | 0.0009064 | 0.0009064 | 0.0009064 | 0.0009064 | 112.0 |
> showing 50 of 95 rows — these rows as CSV