PREVIEW / futures_daily / 2012-05-07
file: by_date/futures_daily/2012/2012-05-07.parquet size: 9 KB rows: 93
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-05-07 | ES | Futures | 1364.45 | 1380.82 | 1352.86 | 1376.29 | 1610579.0 |
| 2012-05-07 | NQ | Futures | 2990.62 | 3034.15 | 2963.4 | 3020.69 | 238011.0 |
| 2012-05-07 | YM | Futures | 12515.9 | 12634.6 | 12427.4 | 12602.5 | 112564.0 |
| 2012-05-07 | CL | Futures | 179.86 | 180.21 | 174.89 | 179.66 | 300474.0 |
| 2012-05-07 | GC | Futures | 2196.8 | 2197.7 | 2181.9 | 2191.1 | 91445.0 |
| 2012-05-07 | ZN | Futures | 115.045758 | 115.289442 | 114.89684 | 114.923916 | 645295.0 |
| 2012-05-07 | A6 | Futures | 0.91044 | 0.91556 | 0.90549 | 0.9143 | 109301.0 |
| 2012-05-07 | AD | Futures | 1.01064 | 1.01265 | 1.00632 | 1.01185 | 77516.0 |
| 2012-05-07 | B | Futures | 101.44 | 102.22 | 99.53 | 102.01 | 96466.0 |
| 2012-05-07 | B6 | Futures | 1.6951 | 1.6996 | 1.6909 | 1.6981 | 79542.0 |
| 2012-05-07 | BFX | Futures | 2632.6 | 2657.5 | 2632.6 | 2657.5 | 8.0 |
| 2012-05-07 | BR | Futures | 0.24612 | 0.24708 | 0.24612 | 0.24681 | 26.0 |
| 2012-05-07 | BZ | Futures | 108.07 | 108.87 | 107.63 | 108.71 | 1973.0 |
| 2012-05-07 | CB | Futures | 70.508 | 70.508 | 70.374 | 70.374 | 4.0 |
| 2012-05-07 | CC | Futures | 1719.0 | 1781.0 | 1697.0 | 1777.0 | 9121.0 |
| 2012-05-07 | CSC | Futures | 3.371 | 3.405 | 3.359 | 3.389 | 34.0 |
| 2012-05-07 | CT | Futures | 107.67 | 108.17 | 105.33 | 106.03 | 13426.0 |
| 2012-05-07 | DC | Futures | 23.12 | 23.58 | 23.0 | 23.4 | 247.0 |
| 2012-05-07 | DX | Futures | 77.308 | 77.642 | 77.153 | 77.235 | 21655.0 |
| 2012-05-07 | E1 | Futures | 1.41871 | 1.4246 | 1.41112 | 1.42303 | 43819.0 |
| 2012-05-07 | E6 | Futures | 1.55546 | 1.56 | 1.54675 | 1.55832 | 227383.0 |
| 2012-05-07 | E7 | Futures | 1.5411 | 1.5449 | 1.5319 | 1.5434 | 3159.0 |
| 2012-05-07 | ED | Futures | 95.0693 | 95.0693 | 95.0549 | 95.0693 | 90749.0 |
| 2012-05-07 | ER | Futures | 97.587 | 97.587 | 97.572 | 97.582 | 35985.0 |
| 2012-05-07 | EW | Futures | 966.4 | 980.0 | 956.9 | 978.8 | 23740.0 |
| 2012-05-07 | FBTP | Futures | 66.1 | 67.1 | 66.1 | 67.05 | 8210.0 |
| 2012-05-07 | FBTS | Futures | 85.315 | 85.721 | 85.298 | 85.681 | 684.0 |
| 2012-05-07 | FCE | Futures | 2203.4 | 2303.1 | 2203.0 | 2298.0 | 110707.0 |
| 2012-05-07 | FDAX | Futures | 7079.3 | 7294.8 | 7041.7 | 7267.2 | 137874.0 |
| 2012-05-07 | FESX | Futures | 1487.4 | 1555.7 | 1481.9 | 1550.2 | 1172772.0 |
| 2012-05-07 | FGBL | Futures | 116.7 | 116.8 | 116.25 | 116.29 | 294535.0 |
| 2012-05-07 | FGBM | Futures | 115.31 | 115.33 | 114.99 | 115.0 | 163344.0 |
| 2012-05-07 | FGBS | Futures | 110.233 | 110.248 | 110.163 | 110.168 | 132950.0 |
| 2012-05-07 | FGBX | Futures | 121.86 | 122.0 | 121.4 | 121.45 | 3321.0 |
| 2012-05-07 | FOAT | Futures | 95.92 | 96.52 | 95.59 | 96.37 | 8065.0 |
| 2012-05-07 | FTDX | Futures | 719.9 | 737.3 | 715.3 | 735.9 | 206.0 |
| 2012-05-07 | FTI | Futures | 255.0 | 264.07 | 253.87 | 263.16 | 13958.0 |
| 2012-05-07 | FVSA | Futures | 9871.14 | 9871.14 | 9391.63 | 9507.38 | 1626.0 |
| 2012-05-07 | FXXP | Futures | 179.3 | 183.7 | 179.2 | 183.3 | 3887.0 |
| 2012-05-07 | GF | Futures | 317.759 | 319.061 | 316.666 | 318.228 | 2042.0 |
| 2012-05-07 | GSCI | Futures | 1033.93 | 1036.95 | 1026.87 | 1033.77 | 2052.0 |
| 2012-05-07 | HE | Futures | 89.339 | 90.166 | 88.459 | 90.032 | 26733.0 |
| 2012-05-07 | HG | Futures | 4.8554 | 4.9483 | 4.8017 | 4.9418 | 37640.0 |
| 2012-05-07 | HO | Futures | 2.4734 | 2.4734 | 2.4283 | 2.4509 | 61582.0 |
| 2012-05-07 | HRC | Futures | 2609.8 | 2609.8 | 2609.8 | 2609.8 | 0.0 |
| 2012-05-07 | J1 | Futures | 0.01572 | 0.0157539 | 0.0156786 | 0.0156912 | 56872.0 |
| 2012-05-07 | J7 | Futures | 0.01565 | 0.015672 | 0.015606 | 0.015617 | 294.0 |
| 2012-05-07 | JB | Futures | 125.53 | 125.7 | 125.53 | 125.68 | 2368.0 |
| 2012-05-07 | KC | Futures | 393.6 | 397.21 | 391.35 | 394.95 | 7334.0 |
| 2012-05-07 | KE | Futures | 2238.95 | 2269.4 | 2222.83 | 2261.34 | 7333.0 |
> showing 50 of 93 rows — these rows as CSV