PREVIEW / futures_daily / 2012-03-12
file: by_date/futures_daily/2012/2012-03-12.parquet size: 9 KB rows: 99
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-12 | ES | Futures | 1377.65 | 1377.65 | 1370.87 | 1377.39 | 905373.0 |
| 2012-03-12 | NQ | Futures | 3029.67 | 3033.39 | 3013.66 | 3032.25 | 122352.0 |
| 2012-03-12 | YM | Futures | 12505.2 | 12549.0 | 12460.5 | 12542.2 | 106623.0 |
| 2012-03-12 | CL | Futures | 199.15 | 199.26 | 195.22 | 197.0 | 234727.0 |
| 2012-03-12 | GC | Futures | 2296.6 | 2299.8 | 2266.5 | 2276.3 | 152099.0 |
| 2012-03-12 | ZN | Futures | 113.285821 | 113.62427 | 113.245207 | 113.285821 | 586113.0 |
| 2012-03-12 | A6 | Futures | 0.94003 | 0.94093 | 0.93194 | 0.93419 | 25918.0 |
| 2012-03-12 | AD | Futures | 1.01356 | 1.01406 | 1.00933 | 1.01064 | 15582.0 |
| 2012-03-12 | B | Futures | 112.4 | 112.41 | 111.12 | 112.09 | 121718.0 |
| 2012-03-12 | B6 | Futures | 1.6378 | 1.6463 | 1.6364 | 1.6396 | 28395.0 |
| 2012-03-12 | BFX | Futures | 2788.8 | 2788.8 | 2781.1 | 2786.6 | 137.0 |
| 2012-03-12 | BR | Futures | 0.25995 | 0.25995 | 0.25757 | 0.25805 | 96.0 |
| 2012-03-12 | BZ | Futures | 119.12 | 119.23 | 118.25 | 119.23 | 351.0 |
| 2012-03-12 | C | Futures | 1550.0 | 1573.0 | 1536.0 | 1550.0 | 17031.0 |
| 2012-03-12 | CB | Futures | 82.215 | 82.215 | 82.08 | 82.08 | 13.0 |
| 2012-03-12 | CC | Futures | 1803.0 | 1846.0 | 1796.0 | 1813.0 | 8128.0 |
| 2012-03-12 | CSC | Futures | 3.714 | 3.714 | 3.692 | 3.692 | 9.0 |
| 2012-03-12 | CT | Futures | 110.36 | 111.58 | 108.89 | 110.13 | 12917.0 |
| 2012-03-12 | DC | Futures | 25.84 | 25.96 | 25.79 | 25.92 | 52.0 |
| 2012-03-12 | DX | Futures | 77.947 | 78.073 | 77.773 | 77.844 | 10241.0 |
| 2012-03-12 | E1 | Futures | 1.4267 | 1.43049 | 1.42172 | 1.42932 | 6566.0 |
| 2012-03-12 | E6 | Futures | 1.56668 | 1.57181 | 1.56214 | 1.5705 | 41924.0 |
| 2012-03-12 | E7 | Futures | 1.5524 | 1.5566 | 1.5472 | 1.5554 | 755.0 |
| 2012-03-12 | EBM | Futures | 280.98 | 285.36 | 280.64 | 285.02 | 10945.0 |
| 2012-03-12 | ED | Futures | 95.0836 | 95.0931 | 95.074 | 95.0836 | 106572.0 |
| 2012-03-12 | ER | Futures | 97.503 | 97.513 | 97.479 | 97.489 | 108110.0 |
| 2012-03-12 | EW | Futures | 992.9 | 994.9 | 985.8 | 990.5 | 57663.0 |
| 2012-03-12 | FBTP | Futures | 69.48 | 69.48 | 68.89 | 68.96 | 5240.0 |
| 2012-03-12 | FBTS | Futures | 86.804 | 86.804 | 86.283 | 86.332 | 989.0 |
| 2012-03-12 | FCE | Futures | 2463.9 | 2479.2 | 2455.1 | 2470.7 | 64802.0 |
| 2012-03-12 | FDAX | Futures | 7580.6 | 7646.3 | 7562.3 | 7617.6 | 158972.0 |
| 2012-03-12 | FESX | Futures | 1684.1 | 1693.7 | 1677.9 | 1686.2 | 688102.0 |
| 2012-03-12 | FEU3 | Futures | 98.058 | 98.063 | 98.058 | 98.063 | 2.0 |
| 2012-03-12 | FGBL | Futures | 113.65 | 114.02 | 113.57 | 113.87 | 431948.0 |
| 2012-03-12 | FGBM | Futures | 113.98 | 114.12 | 113.88 | 114.04 | 280467.0 |
| 2012-03-12 | FGBS | Futures | 110.029 | 110.034 | 109.979 | 110.019 | 295752.0 |
| 2012-03-12 | FGBX | Futures | 118.18 | 118.46 | 117.67 | 118.07 | 5722.0 |
| 2012-03-12 | FTDX | Futures | 715.3 | 716.2 | 713.4 | 713.4 | 70.0 |
| 2012-03-12 | FTI | Futures | 274.04 | 275.61 | 273.41 | 274.55 | 14902.0 |
| 2012-03-12 | FTUK | Futures | 4248.0 | 4267.7 | 4234.5 | 4256.0 | 55602.0 |
| 2012-03-12 | FVSA | Futures | 9121.81 | 9121.81 | 8770.33 | 8854.01 | 1100.0 |
| 2012-03-12 | FXXP | Futures | 188.2 | 188.7 | 188.1 | 188.3 | 6517.0 |
| 2012-03-12 | G | Futures | 94.46 | 94.96 | 94.41 | 94.83 | 102471.0 |
| 2012-03-12 | GF | Futures | 326.431 | 328.21 | 323.082 | 327.268 | 3682.0 |
| 2012-03-12 | GSCI | Futures | 1110.69 | 1116.63 | 1106.58 | 1116.16 | 2578.0 |
| 2012-03-12 | HE | Futures | 106.075 | 106.105 | 104.776 | 105.501 | 23392.0 |
| 2012-03-12 | HG | Futures | 5.0541 | 5.0672 | 5.0042 | 5.0311 | 37745.0 |
| 2012-03-12 | HO | Futures | 2.6915 | 2.6919 | 2.662 | 2.6816 | 15782.0 |
| 2012-03-12 | HRC | Futures | 2719.2 | 2719.2 | 2719.2 | 2719.2 | 0.0 |
| 2012-03-12 | J1 | Futures | 0.0152122 | 0.0152849 | 0.0152097 | 0.0152561 | 20884.0 |
> showing 50 of 99 rows — these rows as CSV