PREVIEW / futures_daily / 2012-03-07
file: by_date/futures_daily/2012/2012-03-07.parquet size: 9 KB rows: 100
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-07 | ES | Futures | 1346.28 | 1359.08 | 1346.03 | 1357.57 | 1893777.0 |
| 2012-03-07 | NQ | Futures | 2961.63 | 2989.93 | 2959.91 | 2983.36 | 260566.0 |
| 2012-03-07 | YM | Futures | 12321.5 | 12425.9 | 12321.5 | 12418.2 | 119855.0 |
| 2012-03-07 | CL | Futures | 194.39 | 197.39 | 193.32 | 196.67 | 333242.0 |
| 2012-03-07 | GC | Futures | 2243.0 | 2261.4 | 2238.6 | 2255.0 | 157557.0 |
| 2012-03-07 | ZN | Futures | 113.813377 | 113.813377 | 113.583833 | 113.651346 | 30028.0 |
| 2012-03-07 | A6 | Futures | 0.93754 | 0.94137 | 0.93398 | 0.93977 | 140159.0 |
| 2012-03-07 | AD | Futures | 1.00202 | 1.00613 | 1.00091 | 1.00463 | 90132.0 |
| 2012-03-07 | B | Futures | 109.24 | 111.33 | 109.08 | 111.0 | 154131.0 |
| 2012-03-07 | B6 | Futures | 1.643 | 1.6473 | 1.6409 | 1.6453 | 78812.0 |
| 2012-03-07 | BFX | Futures | 2703.2 | 2735.0 | 2703.2 | 2734.7 | 18.0 |
| 2012-03-07 | BR | Futures | 0.2658 | 0.2658 | 0.26286 | 0.26506 | 110.0 |
| 2012-03-07 | BZ | Futures | 116.11 | 118.29 | 116.11 | 118.07 | 1239.0 |
| 2012-03-07 | C | Futures | 1489.0 | 1490.0 | 1476.0 | 1480.0 | 3144.0 |
| 2012-03-07 | CB | Futures | 83.156 | 83.156 | 82.349 | 82.887 | 13.0 |
| 2012-03-07 | CC | Futures | 1744.0 | 1763.0 | 1720.0 | 1733.0 | 5926.0 |
| 2012-03-07 | CSC | Futures | 3.659 | 3.673 | 3.659 | 3.673 | 23.0 |
| 2012-03-07 | CT | Futures | 114.39 | 114.56 | 112.32 | 112.78 | 11759.0 |
| 2012-03-07 | DC | Futures | 25.33 | 26.01 | 25.12 | 25.45 | 315.0 |
| 2012-03-07 | DX | Futures | 77.7 | 77.846 | 77.52 | 77.635 | 25326.0 |
| 2012-03-07 | E1 | Futures | 1.42853 | 1.43352 | 1.4267 | 1.43208 | 40666.0 |
| 2012-03-07 | E6 | Futures | 1.56812 | 1.57361 | 1.56537 | 1.5717 | 248830.0 |
| 2012-03-07 | E7 | Futures | 1.5539 | 1.5592 | 1.5511 | 1.5573 | 3445.0 |
| 2012-03-07 | EBM | Futures | 280.64 | 281.99 | 276.94 | 276.94 | 10258.0 |
| 2012-03-07 | ED | Futures | 95.0892 | 95.0916 | 95.082 | 95.0892 | 78489.0 |
| 2012-03-07 | ER | Futures | 97.518 | 97.528 | 97.508 | 97.513 | 63790.0 |
| 2012-03-07 | EW | Futures | 961.7 | 971.9 | 961.4 | 971.1 | 29501.0 |
| 2012-03-07 | FBTP | Futures | 67.79 | 68.73 | 67.48 | 68.52 | 16424.0 |
| 2012-03-07 | FBTS | Futures | 86.315 | 86.584 | 86.169 | 86.486 | 3578.0 |
| 2012-03-07 | FCE | Futures | 2370.7 | 2400.4 | 2370.7 | 2396.2 | 128340.0 |
| 2012-03-07 | FDAX | Futures | 7328.2 | 7380.1 | 7303.4 | 7372.4 | 138716.0 |
| 2012-03-07 | FESX | Futures | 1631.3 | 1648.7 | 1629.3 | 1646.6 | 1202933.0 |
| 2012-03-07 | FEU3 | Futures | 98.078 | 98.078 | 98.068 | 98.068 | 200.0 |
| 2012-03-07 | FGBL | Futures | 113.57 | 113.8 | 113.48 | 113.61 | 1038325.0 |
| 2012-03-07 | FGBM | Futures | 113.83 | 113.95 | 113.74 | 113.86 | 723291.0 |
| 2012-03-07 | FGBS | Futures | 109.989 | 110.029 | 109.959 | 110.014 | 593805.0 |
| 2012-03-07 | FGBX | Futures | 117.92 | 118.42 | 117.38 | 118.16 | 14873.0 |
| 2012-03-07 | FTDX | Futures | 689.3 | 696.2 | 686.5 | 696.2 | 280.0 |
| 2012-03-07 | FTI | Futures | 266.73 | 269.12 | 266.1 | 268.66 | 31580.0 |
| 2012-03-07 | FTUK | Futures | 4138.3 | 4181.2 | 4136.5 | 4175.8 | 111669.0 |
| 2012-03-07 | FVSA | Futures | 10167.02 | 10452.07 | 10091.0 | 10186.02 | 2875.0 |
| 2012-03-07 | FXXP | Futures | 183.1 | 184.1 | 182.6 | 184.1 | 6431.0 |
| 2012-03-07 | G | Futures | 94.46 | 94.73 | 94.39 | 94.43 | 134027.0 |
| 2012-03-07 | GF | Futures | 328.234 | 328.711 | 323.78 | 326.378 | 2342.0 |
| 2012-03-07 | GSCI | Futures | 1092.35 | 1101.01 | 1088.88 | 1097.7 | 2023.0 |
| 2012-03-07 | HE | Futures | 105.229 | 105.833 | 104.685 | 105.561 | 33090.0 |
| 2012-03-07 | HG | Futures | 4.902 | 4.9636 | 4.8692 | 4.9387 | 52653.0 |
| 2012-03-07 | HO | Futures | 2.64 | 2.6656 | 2.6251 | 2.6596 | 32809.0 |
| 2012-03-07 | HRC | Futures | 2719.2 | 2719.2 | 2719.2 | 2719.2 | 0.0 |
| 2012-03-07 | J1 | Futures | 0.0155462 | 0.0155839 | 0.0154595 | 0.0154621 | 91965.0 |
> showing 50 of 100 rows — these rows as CSV