PREVIEW / futures_daily / 2011-12-23
file: by_date/futures_daily/2011/2011-12-23.parquet size: 9 KB rows: 96
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-12-23 | ES | Futures | 1253.96 | 1265.25 | 1253.2 | 1264.74 | 693965.0 |
| 2011-12-23 | NQ | Futures | 2586.82 | 2611.12 | 2584.81 | 2605.68 | 72450.0 |
| 2011-12-23 | YM | Futures | 11711.3 | 11827.3 | 11702.6 | 11814.8 | 43867.0 |
| 2011-12-23 | CL | Futures | 185.92 | 187.32 | 185.47 | 186.29 | 95270.0 |
| 2011-12-23 | GC | Futures | 2170.8 | 2181.3 | 2165.7 | 2168.4 | 40681.0 |
| 2011-12-23 | ZN | Futures | 112.760175 | 112.773677 | 112.179563 | 112.220071 | 312889.0 |
| 2011-12-23 | A6 | Futures | 0.89304 | 0.89794 | 0.89296 | 0.8966 | 33558.0 |
| 2011-12-23 | AD | Futures | 0.98144 | 0.98415 | 0.98074 | 0.98385 | 27794.0 |
| 2011-12-23 | B | Futures | 96.04 | 96.74 | 95.71 | 96.21 | 62494.0 |
| 2011-12-23 | B6 | Futures | 1.6377 | 1.6408 | 1.6276 | 1.6324 | 38875.0 |
| 2011-12-23 | BR | Futures | 0.24844 | 0.24844 | 0.24844 | 0.24844 | 149.0 |
| 2011-12-23 | BZ | Futures | 101.65 | 102.32 | 101.65 | 102.11 | 189.0 |
| 2011-12-23 | C | Futures | 1432.0 | 1446.0 | 1426.0 | 1434.0 | 3529.0 |
| 2011-12-23 | CB | Futures | 89.777 | 89.777 | 88.808 | 88.808 | 19.0 |
| 2011-12-23 | CC | Futures | 1713.0 | 1736.0 | 1705.0 | 1720.0 | 2508.0 |
| 2011-12-23 | CSC | Futures | 3.976 | 3.986 | 3.947 | 3.947 | 9.0 |
| 2011-12-23 | CT | Futures | 112.21 | 112.89 | 111.87 | 112.36 | 1891.0 |
| 2011-12-23 | DC | Futures | 28.93 | 28.96 | 28.53 | 28.59 | 186.0 |
| 2011-12-23 | DX | Futures | 78.07 | 78.23 | 77.924 | 78.095 | 7103.0 |
| 2011-12-23 | E1 | Futures | 1.40504 | 1.40898 | 1.40084 | 1.40464 | 8847.0 |
| 2011-12-23 | E6 | Futures | 1.5619 | 1.56692 | 1.55867 | 1.56238 | 77608.0 |
| 2011-12-23 | E7 | Futures | 1.5474 | 1.5526 | 1.5445 | 1.5481 | 1661.0 |
| 2011-12-23 | EBM | Futures | 243.4 | 244.71 | 242.74 | 244.05 | 3542.0 |
| 2011-12-23 | ED | Futures | 94.8909 | 94.8957 | 94.8527 | 94.8718 | 77817.0 |
| 2011-12-23 | ER | Futures | 97.184 | 97.194 | 97.159 | 97.194 | 33514.0 |
| 2011-12-23 | EW | Futures | 883.0 | 889.2 | 882.0 | 887.1 | 8634.0 |
| 2011-12-23 | FBTP | Futures | 58.68 | 58.69 | 57.74 | 58.2 | 2413.0 |
| 2011-12-23 | FBTS | Futures | 79.913 | 80.074 | 79.648 | 80.009 | 439.0 |
| 2011-12-23 | FCE | Futures | 2226.3 | 2230.6 | 2210.5 | 2221.6 | 23896.0 |
| 2011-12-23 | FDAX | Futures | 6545.8 | 6556.9 | 6461.9 | 6500.0 | 50623.0 |
| 2011-12-23 | FESX | Futures | 1532.3 | 1535.0 | 1520.3 | 1525.0 | 298405.0 |
| 2011-12-23 | FEU3 | Futures | 97.737 | 97.747 | 97.737 | 97.747 | 150.0 |
| 2011-12-23 | FGBL | Futures | 111.34 | 111.63 | 111.23 | 111.31 | 99827.0 |
| 2011-12-23 | FGBM | Futures | 112.54 | 112.63 | 112.39 | 112.48 | 68527.0 |
| 2011-12-23 | FGBS | Futures | 109.735 | 109.78 | 109.715 | 109.725 | 89875.0 |
| 2011-12-23 | FGBX | Futures | 116.72 | 117.18 | 116.42 | 116.7 | 1195.0 |
| 2011-12-23 | FTDX | Futures | 627.5 | 634.5 | 626.1 | 631.2 | 288.0 |
| 2011-12-23 | FTI | Futures | 258.66 | 259.08 | 255.93 | 258.49 | 13233.0 |
| 2011-12-23 | FTUK | Futures | 3927.0 | 3952.2 | 3920.5 | 3949.7 | 20461.0 |
| 2011-12-23 | FVSA | Futures | 11962.4 | 12401.02 | 11962.4 | 12381.08 | 611.0 |
| 2011-12-23 | FXXP | Futures | 170.4 | 170.5 | 169.7 | 170.3 | 1916.0 |
| 2011-12-23 | G | Futures | 94.36 | 94.78 | 94.26 | 94.44 | 12073.0 |
| 2011-12-23 | GF | Futures | 317.026 | 318.265 | 316.595 | 317.995 | 1326.0 |
| 2011-12-23 | GSCI | Futures | 1013.3 | 1019.49 | 1010.55 | 1010.55 | 208.0 |
| 2011-12-23 | HE | Futures | 104.294 | 106.113 | 104.202 | 105.835 | 12963.0 |
| 2011-12-23 | HG | Futures | 4.509 | 4.5888 | 4.5024 | 4.5763 | 15917.0 |
| 2011-12-23 | HO | Futures | 2.3497 | 2.3669 | 2.3422 | 2.3467 | 8676.0 |
| 2011-12-23 | HRC | Futures | 2825.8 | 2825.8 | 2825.8 | 2825.8 | 0.0 |
| 2011-12-23 | J1 | Futures | 0.0160987 | 0.0161288 | 0.0160798 | 0.0161175 | 20448.0 |
| 2011-12-23 | J7 | Futures | 0.016027 | 0.016058 | 0.016016 | 0.016051 | 83.0 |
> showing 50 of 96 rows — these rows as CSV