PREVIEW / futures_daily / 2012-03-08
file: by_date/futures_daily/2012/2012-03-08.parquet size: 9 KB rows: 98
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-03-08 | ES | Futures | 1357.57 | 1373.38 | 1355.32 | 1371.37 | 1832191.0 |
| 2012-03-08 | NQ | Futures | 2982.5 | 3023.96 | 2978.5 | 3016.52 | 286625.0 |
| 2012-03-08 | YM | Futures | 12414.3 | 12522.7 | 12400.8 | 12485.9 | 87969.0 |
| 2012-03-08 | CL | Futures | 196.82 | 198.6 | 196.08 | 197.45 | 279597.0 |
| 2012-03-08 | GC | Futures | 2257.4 | 2282.9 | 2254.6 | 2274.8 | 156218.0 |
| 2012-03-08 | ZN | Futures | 113.651346 | 113.732574 | 113.353511 | 113.421201 | 793438.0 |
| 2012-03-08 | A6 | Futures | 0.94075 | 0.94858 | 0.9363 | 0.94742 | 171472.0 |
| 2012-03-08 | AD | Futures | 1.00573 | 1.01436 | 1.00433 | 1.01396 | 116124.0 |
| 2012-03-08 | B | Futures | 110.95 | 112.97 | 110.67 | 112.27 | 137076.0 |
| 2012-03-08 | B6 | Futures | 1.6456 | 1.6551 | 1.6437 | 1.6544 | 106886.0 |
| 2012-03-08 | BFX | Futures | 2753.1 | 2773.4 | 2753.1 | 2773.4 | 141.0 |
| 2012-03-08 | BR | Futures | 0.26427 | 0.26496 | 0.26401 | 0.26465 | 133.0 |
| 2012-03-08 | BZ | Futures | 118.88 | 120.11 | 118.88 | 119.42 | 767.0 |
| 2012-03-08 | C | Futures | 1482.0 | 1545.0 | 1472.0 | 1533.0 | 6222.0 |
| 2012-03-08 | CB | Futures | 82.887 | 82.887 | 82.887 | 82.887 | 1.0 |
| 2012-03-08 | CC | Futures | 1733.0 | 1829.0 | 1733.0 | 1822.0 | 16023.0 |
| 2012-03-08 | CSC | Futures | 3.726 | 3.726 | 3.701 | 3.701 | 10.0 |
| 2012-03-08 | CT | Futures | 113.15 | 113.8 | 111.76 | 112.08 | 9087.0 |
| 2012-03-08 | DC | Futures | 25.45 | 25.87 | 25.43 | 25.73 | 205.0 |
| 2012-03-08 | DX | Futures | 77.656 | 77.685 | 76.989 | 77.066 | 24568.0 |
| 2012-03-08 | E1 | Futures | 1.433 | 1.44704 | 1.43063 | 1.44534 | 49839.0 |
| 2012-03-08 | E6 | Futures | 1.57182 | 1.58879 | 1.57015 | 1.58652 | 289207.0 |
| 2012-03-08 | E7 | Futures | 1.5578 | 1.5743 | 1.5558 | 1.572 | 3902.0 |
| 2012-03-08 | EBM | Futures | 277.95 | 279.63 | 273.9 | 274.58 | 11867.0 |
| 2012-03-08 | ED | Futures | 95.0868 | 95.0916 | 95.0844 | 95.0892 | 116252.0 |
| 2012-03-08 | ER | Futures | 97.518 | 97.523 | 97.499 | 97.508 | 71486.0 |
| 2012-03-08 | EW | Futures | 970.5 | 984.0 | 969.9 | 982.5 | 55605.0 |
| 2012-03-08 | FBTP | Futures | 68.66 | 69.66 | 68.66 | 69.44 | 14948.0 |
| 2012-03-08 | FBTS | Futures | 86.682 | 86.779 | 86.429 | 86.527 | 2475.0 |
| 2012-03-08 | FCE | Futures | 2403.9 | 2467.8 | 2403.9 | 2456.5 | 151416.0 |
| 2012-03-08 | FDAX | Futures | 7398.9 | 7592.2 | 7397.8 | 7546.9 | 174090.0 |
| 2012-03-08 | FESX | Futures | 1652.0 | 1689.4 | 1650.7 | 1680.7 | 1441810.0 |
| 2012-03-08 | FEU3 | Futures | 98.058 | 98.063 | 98.058 | 98.063 | 106.0 |
| 2012-03-08 | FGBL | Futures | 113.55 | 113.68 | 113.18 | 113.43 | 782879.0 |
| 2012-03-08 | FGBM | Futures | 113.85 | 113.96 | 113.69 | 113.83 | 388351.0 |
| 2012-03-08 | FGBS | Futures | 110.014 | 110.029 | 109.959 | 109.999 | 415834.0 |
| 2012-03-08 | FGBX | Futures | 118.16 | 118.16 | 117.23 | 117.67 | 6677.0 |
| 2012-03-08 | FTDX | Futures | 699.0 | 706.9 | 696.7 | 705.0 | 178.0 |
| 2012-03-08 | FTI | Futures | 269.38 | 274.08 | 269.38 | 273.2 | 30714.0 |
| 2012-03-08 | FTUK | Futures | 4172.2 | 4234.2 | 4170.4 | 4222.3 | 116702.0 |
| 2012-03-08 | FVSA | Futures | 10091.0 | 10243.03 | 9653.92 | 9691.92 | 5406.0 |
| 2012-03-08 | FXXP | Futures | 185.5 | 187.1 | 185.0 | 187.0 | 2497.0 |
| 2012-03-08 | G | Futures | 94.33 | 94.54 | 94.06 | 94.39 | 95679.0 |
| 2012-03-08 | GF | Futures | 326.696 | 329.135 | 326.272 | 328.658 | 941.0 |
| 2012-03-08 | GSCI | Futures | 1097.7 | 1109.36 | 1097.7 | 1107.78 | 1579.0 |
| 2012-03-08 | HE | Futures | 105.592 | 106.528 | 105.41 | 106.045 | 28488.0 |
| 2012-03-08 | HG | Futures | 4.9439 | 5.0226 | 4.9361 | 4.9708 | 46168.0 |
| 2012-03-08 | HO | Futures | 2.6598 | 2.7101 | 2.6589 | 2.698 | 38210.0 |
| 2012-03-08 | HRC | Futures | 2715.2 | 2719.2 | 2715.2 | 2719.2 | 1.0 |
| 2012-03-08 | J1 | Futures | 0.0154734 | 0.0154859 | 0.0153641 | 0.0153842 | 115255.0 |
> showing 50 of 98 rows — these rows as CSV