PREVIEW / futures_daily / 2011-12-13
file: by_date/futures_daily/2011/2011-12-13.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 |
|---|---|---|---|---|---|---|---|
| 2011-12-13 | ES | Futures | 1232.83 | 1247.56 | 1216.36 | 1224.1 | 1000947.0 |
| 2011-12-13 | NQ | Futures | 2618.79 | 2645.9 | 2577.69 | 2592.25 | 101723.0 |
| 2011-12-13 | YM | Futures | 11547.8 | 11677.4 | 11439.5 | 11503.4 | 150326.0 |
| 2011-12-13 | CL | Futures | 183.44 | 189.81 | 183.05 | 187.73 | 380754.0 |
| 2011-12-13 | GC | Futures | 2252.1 | 2270.6 | 2194.7 | 2245.4 | 182892.0 |
| 2011-12-13 | ZN | Futures | 112.436113 | 112.854693 | 112.220071 | 112.760175 | 927737.0 |
| 2011-12-13 | A6 | Futures | 0.88637 | 0.895 | 0.87881 | 0.88281 | 42903.0 |
| 2011-12-13 | AD | Futures | 0.97532 | 0.97883 | 0.96789 | 0.9704 | 44629.0 |
| 2011-12-13 | B | Futures | 95.49 | 98.72 | 95.27 | 97.21 | 157538.0 |
| 2011-12-13 | B6 | Futures | 1.6272 | 1.6322 | 1.6135 | 1.618 | 57415.0 |
| 2011-12-13 | BFX | Futures | 2448.7 | 2461.2 | 2432.5 | 2439.8 | 377.0 |
| 2011-12-13 | BR | Futures | 0.24792 | 0.24792 | 0.24792 | 0.24792 | 42.0 |
| 2011-12-13 | BZ | Futures | 102.05 | 104.04 | 101.82 | 103.17 | 847.0 |
| 2011-12-13 | C | Futures | 1463.0 | 1514.0 | 1446.0 | 1502.0 | 22547.0 |
| 2011-12-13 | CB | Futures | 88.808 | 88.808 | 88.808 | 88.808 | 22.0 |
| 2011-12-13 | CC | Futures | 1692.0 | 1756.0 | 1686.0 | 1739.0 | 19941.0 |
| 2011-12-13 | CT | Futures | 112.26 | 113.62 | 111.57 | 112.45 | 7745.0 |
| 2011-12-13 | DC | Futures | 28.28 | 28.53 | 28.28 | 28.53 | 66.0 |
| 2011-12-13 | DX | Futures | 78.143 | 78.941 | 77.865 | 78.789 | 21602.0 |
| 2011-12-13 | E1 | Futures | 1.40202 | 1.40832 | 1.38824 | 1.39126 | 12242.0 |
| 2011-12-13 | E6 | Futures | 1.57612 | 1.58425 | 1.55688 | 1.56047 | 165846.0 |
| 2011-12-13 | E7 | Futures | 1.5615 | 1.5697 | 1.5428 | 1.5462 | 1695.0 |
| 2011-12-13 | EBM | Futures | 228.99 | 232.59 | 228.66 | 231.93 | 8516.0 |
| 2011-12-13 | ED | Futures | 94.9339 | 94.9387 | 94.9053 | 94.9148 | 184855.0 |
| 2011-12-13 | ER | Futures | 97.164 | 97.169 | 97.145 | 97.164 | 107181.0 |
| 2011-12-13 | EW | Futures | 874.9 | 884.2 | 850.8 | 857.0 | 71458.0 |
| 2011-12-13 | FBTP | Futures | 57.96 | 58.05 | 57.27 | 57.61 | 8940.0 |
| 2011-12-13 | FBTS | Futures | 78.051 | 78.773 | 78.051 | 78.444 | 592.0 |
| 2011-12-13 | FCE | Futures | 2217.7 | 2224.5 | 2169.7 | 2200.5 | 108741.0 |
| 2011-12-13 | FDAX | Futures | 6318.4 | 6356.9 | 6189.2 | 6264.6 | 230487.0 |
| 2011-12-13 | FESX | Futures | 1516.9 | 1525.0 | 1483.5 | 1503.6 | 1251948.0 |
| 2011-12-13 | FEU3 | Futures | 97.702 | 97.717 | 97.702 | 97.717 | 1.0 |
| 2011-12-13 | FGBL | Futures | 110.56 | 110.79 | 110.03 | 110.55 | 459087.0 |
| 2011-12-13 | FGBM | Futures | 112.19 | 112.29 | 111.96 | 112.16 | 209799.0 |
| 2011-12-13 | FGBS | Futures | 109.68 | 109.7 | 109.611 | 109.665 | 215342.0 |
| 2011-12-13 | FGBX | Futures | 114.71 | 115.75 | 114.23 | 115.25 | 3707.0 |
| 2011-12-13 | FTDX | Futures | 618.2 | 623.8 | 609.4 | 621.4 | 3235.0 |
| 2011-12-13 | FTI | Futures | 250.9 | 252.62 | 248.8 | 250.94 | 31118.0 |
| 2011-12-13 | FTUK | Futures | 3898.5 | 3960.5 | 3878.6 | 3930.6 | 180425.0 |
| 2011-12-13 | FVSA | Futures | 14594.13 | 14753.63 | 14155.51 | 14235.26 | 2828.0 |
| 2011-12-13 | FXXP | Futures | 166.6 | 167.8 | 166.6 | 167.1 | 23751.0 |
| 2011-12-13 | G | Futures | 93.75 | 94.14 | 93.34 | 93.75 | 94344.0 |
| 2011-12-13 | GF | Futures | 308.302 | 311.372 | 308.033 | 309.971 | 3147.0 |
| 2011-12-13 | GSCI | Futures | 1007.73 | 1025.3 | 1007.73 | 1018.0 | 1775.0 |
| 2011-12-13 | HE | Futures | 106.883 | 106.883 | 106.02 | 106.513 | 12305.0 |
| 2011-12-13 | HG | Futures | 4.5545 | 4.6092 | 4.4556 | 4.5393 | 38629.0 |
| 2011-12-13 | HO | Futures | 2.3506 | 2.4221 | 2.3506 | 2.3844 | 18111.0 |
| 2011-12-13 | HRC | Futures | 2745.9 | 2745.9 | 2745.9 | 2745.9 | 0.0 |
| 2011-12-13 | J1 | Futures | 0.0161539 | 0.0162104 | 0.0161313 | 0.0161376 | 33335.0 |
| 2011-12-13 | J7 | Futures | 0.016083 | 0.016136 | 0.016065 | 0.016071 | 183.0 |
> showing 50 of 98 rows — these rows as CSV