PREVIEW / futures_daily / 2012-02-24
file: by_date/futures_daily/2012/2012-02-24.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-02-24 | ES | Futures | 1367.86 | 1373.38 | 1366.36 | 1368.11 | 1165825.0 |
| 2012-02-24 | NQ | Futures | 2973.64 | 2984.22 | 2971.06 | 2975.07 | 147647.0 |
| 2012-02-24 | YM | Futures | 12548.8 | 12586.5 | 12502.3 | 12534.3 | 82410.0 |
| 2012-02-24 | CL | Futures | 201.3 | 203.69 | 199.99 | 203.36 | 267713.0 |
| 2012-02-24 | GC | Futures | 2386.3 | 2389.5 | 2372.0 | 2378.8 | 139752.0 |
| 2012-02-24 | ZN | Futures | 113.273273 | 113.448807 | 113.205761 | 113.367792 | 1059740.0 |
| 2012-02-24 | A6 | Futures | 0.95258 | 0.95472 | 0.94884 | 0.95 | 99275.0 |
| 2012-02-24 | AD | Futures | 1.00593 | 1.00663 | 1.00272 | 1.00292 | 75950.0 |
| 2012-02-24 | B | Futures | 110.1 | 111.91 | 109.85 | 111.83 | 80148.0 |
| 2012-02-24 | B6 | Futures | 1.6454 | 1.662 | 1.6431 | 1.6605 | 145632.0 |
| 2012-02-24 | BFX | Futures | 2759.6 | 2767.1 | 2759.6 | 2767.1 | 14.0 |
| 2012-02-24 | BR | Futures | 0.27405 | 0.27484 | 0.27309 | 0.27436 | 300.0 |
| 2012-02-24 | BZ | Futures | 117.33 | 118.96 | 117.03 | 118.96 | 458.0 |
| 2012-02-24 | C | Futures | 1529.0 | 1553.0 | 1525.0 | 1534.0 | 2331.0 |
| 2012-02-24 | CB | Futures | 84.367 | 84.367 | 83.829 | 84.098 | 39.0 |
| 2012-02-24 | CC | Futures | 1785.0 | 1826.0 | 1775.0 | 1793.0 | 8353.0 |
| 2012-02-24 | CSC | Futures | 3.696 | 3.708 | 3.696 | 3.696 | 5.0 |
| 2012-02-24 | CT | Futures | 111.76 | 113.54 | 111.41 | 112.82 | 7863.0 |
| 2012-02-24 | DC | Futures | 25.37 | 25.53 | 25.27 | 25.32 | 183.0 |
| 2012-02-24 | DX | Futures | 76.58 | 76.717 | 76.172 | 76.309 | 34081.0 |
| 2012-02-24 | E1 | Futures | 1.45715 | 1.47015 | 1.45439 | 1.46713 | 43505.0 |
| 2012-02-24 | E6 | Futures | 1.59812 | 1.61222 | 1.59668 | 1.60888 | 263776.0 |
| 2012-02-24 | E7 | Futures | 1.5839 | 1.5974 | 1.5822 | 1.5942 | 4363.0 |
| 2012-02-24 | EBM | Futures | 274.85 | 274.85 | 271.24 | 271.9 | 4306.0 |
| 2012-02-24 | ED | Futures | 95.0701 | 95.0748 | 95.0653 | 95.0677 | 89803.0 |
| 2012-02-24 | ER | Futures | 97.425 | 97.449 | 97.425 | 97.444 | 61604.0 |
| 2012-02-24 | EW | Futures | 991.7 | 996.5 | 989.6 | 991.0 | 16423.0 |
| 2012-02-24 | FBTP | Futures | 65.36 | 65.91 | 65.31 | 65.64 | 7987.0 |
| 2012-02-24 | FBTS | Futures | 84.609 | 84.794 | 84.585 | 84.721 | 1033.0 |
| 2012-02-24 | FCE | Futures | 2446.3 | 2455.1 | 2437.8 | 2450.2 | 88619.0 |
| 2012-02-24 | FDAX | Futures | 7568.4 | 7612.6 | 7539.7 | 7584.4 | 109068.0 |
| 2012-02-24 | FESX | Futures | 1684.8 | 1693.4 | 1678.7 | 1688.1 | 807828.0 |
| 2012-02-24 | FEU3 | Futures | 97.999 | 97.999 | 97.999 | 97.999 | 50.0 |
| 2012-02-24 | FGBL | Futures | 112.48 | 112.62 | 112.33 | 112.51 | 485220.0 |
| 2012-02-24 | FGBM | Futures | 113.31 | 113.49 | 113.27 | 113.42 | 282119.0 |
| 2012-02-24 | FGBS | Futures | 109.795 | 109.864 | 109.785 | 109.845 | 300018.0 |
| 2012-02-24 | FGBX | Futures | 117.64 | 117.81 | 117.29 | 117.6 | 4541.0 |
| 2012-02-24 | FTDX | Futures | 717.6 | 721.3 | 717.6 | 719.4 | 120.0 |
| 2012-02-24 | FTI | Futures | 275.22 | 275.76 | 272.36 | 273.16 | 27962.0 |
| 2012-02-24 | FTUK | Futures | 4277.5 | 4287.6 | 4255.9 | 4267.4 | 72507.0 |
| 2012-02-24 | FVSA | Futures | 9862.96 | 9862.96 | 9539.89 | 9596.9 | 8540.0 |
| 2012-02-24 | FXXP | Futures | 187.0 | 187.4 | 186.5 | 187.0 | 976.0 |
| 2012-02-24 | G | Futures | 93.92 | 94.32 | 93.86 | 94.27 | 190475.0 |
| 2012-02-24 | GF | Futures | 334.331 | 335.444 | 333.429 | 334.384 | 2244.0 |
| 2012-02-24 | GSCI | Futures | 1117.39 | 1129.2 | 1115.58 | 1129.2 | 450.0 |
| 2012-02-24 | HE | Futures | 108.522 | 109.187 | 108.341 | 108.432 | 14908.0 |
| 2012-02-24 | HG | Futures | 5.0115 | 5.0986 | 4.9695 | 5.0737 | 27415.0 |
| 2012-02-24 | HO | Futures | 2.6869 | 2.7089 | 2.6739 | 2.7074 | 19286.0 |
| 2012-02-24 | HRC | Futures | 2731.0 | 2731.0 | 2731.0 | 2731.0 | 0.0 |
| 2012-02-24 | J1 | Futures | 0.0157019 | 0.0157107 | 0.0154633 | 0.0155085 | 95870.0 |
> showing 50 of 98 rows — these rows as CSV