PREVIEW / futures_daily / 2012-05-11
file: by_date/futures_daily/2012/2012-05-11.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-05-11 | ES | Futures | 1367.97 | 1373.77 | 1354.37 | 1360.42 | 1840516.0 |
| 2012-05-11 | NQ | Futures | 3000.93 | 3024.99 | 2976.01 | 2991.19 | 266269.0 |
| 2012-05-11 | YM | Futures | 12480.0 | 12528.6 | 12373.0 | 12436.2 | 130526.0 |
| 2012-05-11 | CL | Futures | 177.07 | 178.3 | 175.29 | 176.34 | 260539.0 |
| 2012-05-11 | GC | Futures | 2130.2 | 2132.5 | 2101.4 | 2117.5 | 151009.0 |
| 2012-05-11 | ZN | Futures | 115.23529 | 115.357132 | 115.126986 | 115.30298 | 780782.0 |
| 2012-05-11 | A6 | Futures | 0.90198 | 0.90378 | 0.89784 | 0.89874 | 143200.0 |
| 2012-05-11 | AD | Futures | 1.00269 | 1.00994 | 1.00259 | 1.00511 | 104873.0 |
| 2012-05-11 | B | Futures | 101.09 | 101.59 | 100.43 | 101.07 | 170653.0 |
| 2012-05-11 | B6 | Futures | 1.6931 | 1.694 | 1.6853 | 1.6864 | 103329.0 |
| 2012-05-11 | BR | Futures | 0.24326 | 0.24462 | 0.24145 | 0.24319 | 92.0 |
| 2012-05-11 | BZ | Futures | 107.49 | 108.25 | 107.06 | 107.71 | 3852.0 |
| 2012-05-11 | C | Futures | 1525.0 | 1544.0 | 1519.0 | 1538.0 | 5723.0 |
| 2012-05-11 | CB | Futures | 73.065 | 73.885 | 73.065 | 73.885 | 6.0 |
| 2012-05-11 | CC | Futures | 1748.0 | 1757.0 | 1727.0 | 1748.0 | 7005.0 |
| 2012-05-11 | CSC | Futures | 3.371 | 3.462 | 3.355 | 3.428 | 82.0 |
| 2012-05-11 | CT | Futures | 99.7 | 100.02 | 94.39 | 96.61 | 26753.0 |
| 2012-05-11 | DC | Futures | 23.61 | 24.61 | 23.46 | 24.43 | 572.0 |
| 2012-05-11 | DX | Futures | 77.85 | 77.976 | 77.714 | 77.902 | 21689.0 |
| 2012-05-11 | E1 | Futures | 1.40994 | 1.41256 | 1.40719 | 1.40889 | 37610.0 |
| 2012-05-11 | E6 | Futures | 1.54364 | 1.54698 | 1.54066 | 1.54281 | 221596.0 |
| 2012-05-11 | E7 | Futures | 1.5293 | 1.5327 | 1.526 | 1.528 | 2381.0 |
| 2012-05-11 | ED | Futures | 95.0358 | 95.0502 | 95.0311 | 95.0454 | 195391.0 |
| 2012-05-11 | ER | Futures | 97.528 | 97.538 | 97.503 | 97.513 | 142152.0 |
| 2012-05-11 | EW | Futures | 975.6 | 982.3 | 964.6 | 974.1 | 28403.0 |
| 2012-05-11 | FBTP | Futures | 66.39 | 66.73 | 66.23 | 66.54 | 13343.0 |
| 2012-05-11 | FBTS | Futures | 85.428 | 85.599 | 85.396 | 85.485 | 1138.0 |
| 2012-05-11 | FCE | Futures | 2235.5 | 2263.7 | 2203.4 | 2259.4 | 144986.0 |
| 2012-05-11 | FDAX | Futures | 7142.3 | 7288.2 | 7127.9 | 7279.4 | 160318.0 |
| 2012-05-11 | FESX | Futures | 1517.1 | 1542.6 | 1507.4 | 1539.1 | 1318918.0 |
| 2012-05-11 | FEU3 | Futures | 98.112 | 98.112 | 98.088 | 98.088 | 3.0 |
| 2012-05-11 | FGBL | Futures | 117.15 | 117.33 | 116.84 | 117.07 | 618799.0 |
| 2012-05-11 | FGBM | Futures | 115.45 | 115.49 | 115.28 | 115.34 | 330353.0 |
| 2012-05-11 | FGBS | Futures | 110.233 | 110.243 | 110.193 | 110.208 | 227269.0 |
| 2012-05-11 | FGBX | Futures | 123.52 | 124.1 | 123.06 | 123.82 | 6081.0 |
| 2012-05-11 | FOAT | Futures | 96.1 | 96.37 | 96.06 | 96.33 | 10739.0 |
| 2012-05-11 | FTDX | Futures | 724.6 | 732.1 | 724.2 | 732.1 | 246.0 |
| 2012-05-11 | FTI | Futures | 260.04 | 264.24 | 259.26 | 263.9 | 184.0 |
| 2012-05-11 | FTUK | Futures | 4014.5 | 4060.8 | 3995.9 | 4054.6 | 112336.0 |
| 2012-05-11 | FVSA | Futures | 9805.0 | 9838.07 | 9490.84 | 9507.38 | 6429.0 |
| 2012-05-11 | FXXP | Futures | 180.0 | 181.9 | 179.1 | 181.7 | 1872.0 |
| 2012-05-11 | G | Futures | 96.26 | 96.57 | 96.12 | 96.22 | 120490.0 |
| 2012-05-11 | GF | Futures | 312.963 | 312.963 | 310.446 | 310.792 | 2982.0 |
| 2012-05-11 | GSCI | Futures | 1018.77 | 1026.79 | 1017.03 | 1017.34 | 1753.0 |
| 2012-05-11 | HE | Futures | 90.513 | 91.606 | 89.792 | 90.993 | 25486.0 |
| 2012-05-11 | HG | Futures | 4.8187 | 4.8239 | 4.7362 | 4.7774 | 54909.0 |
| 2012-05-11 | HO | Futures | 2.4514 | 2.4529 | 2.427 | 2.4362 | 42251.0 |
| 2012-05-11 | HRC | Futures | 2629.4 | 2629.4 | 2629.4 | 2629.4 | 0.0 |
| 2012-05-11 | J1 | Futures | 0.0156999 | 0.0157325 | 0.0156799 | 0.0157025 | 65618.0 |
| 2012-05-11 | J7 | Futures | 0.015631 | 0.015657 | 0.015606 | 0.015628 | 433.0 |
> showing 50 of 98 rows — these rows as CSV