PREVIEW / futures_daily / 2012-10-11
file: by_date/futures_daily/2012/2012-10-11.parquet size: 9 KB rows: 96
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-10-11 | ES | Futures | 1451.11 | 1464.85 | 1446.53 | 1453.9 | 1585045.0 |
| 2012-10-11 | NQ | Futures | 3132.54 | 3159.0 | 3120.46 | 3121.9 | 248073.0 |
| 2012-10-11 | YM | Futures | 12954.1 | 13046.9 | 12916.1 | 12953.2 | 112961.0 |
| 2012-10-11 | CL | Futures | 164.73 | 167.74 | 164.4 | 166.17 | 300087.0 |
| 2012-10-11 | GC | Futures | 2356.4 | 2372.0 | 2350.1 | 2364.0 | 117573.0 |
| 2012-10-11 | ZN | Futures | 117.205842 | 117.247044 | 116.75262 | 117.137172 | 1007180.0 |
| 2012-10-11 | A6 | Futures | 0.92399 | 0.93044 | 0.9229 | 0.92762 | 113470.0 |
| 2012-10-11 | AD | Futures | 1.02075 | 1.02637 | 1.01904 | 1.02366 | 65643.0 |
| 2012-10-11 | B | Futures | 104.07 | 105.34 | 103.79 | 105.09 | 194917.0 |
| 2012-10-11 | B6 | Futures | 1.6706 | 1.6763 | 1.6691 | 1.6752 | 78283.0 |
| 2012-10-11 | BR | Futures | 0.23648 | 0.23689 | 0.23614 | 0.23665 | 173.0 |
| 2012-10-11 | BZ | Futures | 108.79 | 109.25 | 108.68 | 109.06 | 630.0 |
| 2012-10-11 | C | Futures | 1555.0 | 1570.0 | 1534.0 | 1539.0 | 5923.0 |
| 2012-10-11 | CB | Futures | 94.736 | 94.736 | 94.602 | 94.736 | 3.0 |
| 2012-10-11 | CC | Futures | 1790.0 | 1805.0 | 1765.0 | 1773.0 | 11979.0 |
| 2012-10-11 | CSC | Futures | 4.173 | 4.225 | 4.173 | 4.225 | 16.0 |
| 2012-10-11 | CT | Futures | 92.91 | 92.91 | 90.86 | 91.25 | 19264.0 |
| 2012-10-11 | DC | Futures | 31.14 | 31.58 | 31.14 | 31.52 | 200.0 |
| 2012-10-11 | DX | Futures | 77.629 | 77.775 | 77.276 | 77.353 | 17275.0 |
| 2012-10-11 | E1 | Futures | 1.37196 | 1.3802 | 1.36797 | 1.37866 | 27890.0 |
| 2012-10-11 | E6 | Futures | 1.51508 | 1.52614 | 1.51119 | 1.52355 | 223709.0 |
| 2012-10-11 | E7 | Futures | 1.5064 | 1.517 | 1.5023 | 1.5144 | 3784.0 |
| 2012-10-11 | ED | Futures | 95.2253 | 95.2349 | 95.2253 | 95.2301 | 72702.0 |
| 2012-10-11 | ER | Futures | 97.876 | 97.881 | 97.866 | 97.866 | 48352.0 |
| 2012-10-11 | EW | Futures | 994.4 | 1006.1 | 990.9 | 999.2 | 19103.0 |
| 2012-10-11 | FBTP | Futures | 71.22 | 71.84 | 70.98 | 71.79 | 21907.0 |
| 2012-10-11 | FBTS | Futures | 89.265 | 89.474 | 89.114 | 89.474 | 4984.0 |
| 2012-10-11 | FCE | Futures | 2509.0 | 2561.0 | 2506.0 | 2553.5 | 111528.0 |
| 2012-10-11 | FDAX | Futures | 7880.8 | 8006.8 | 7869.3 | 7981.6 | 126473.0 |
| 2012-10-11 | FESX | Futures | 1660.6 | 1694.7 | 1655.9 | 1689.2 | 992852.0 |
| 2012-10-11 | FGBL | Futures | 118.41 | 118.59 | 117.83 | 117.97 | 666759.0 |
| 2012-10-11 | FGBM | Futures | 116.32 | 116.47 | 116.09 | 116.15 | 371639.0 |
| 2012-10-11 | FGBS | Futures | 110.348 | 110.377 | 110.308 | 110.323 | 304711.0 |
| 2012-10-11 | FGBX | Futures | 125.53 | 126.12 | 124.35 | 124.64 | 7492.0 |
| 2012-10-11 | FOAT | Futures | 103.91 | 104.11 | 103.84 | 103.88 | 29709.0 |
| 2012-10-11 | FTDX | Futures | 759.4 | 771.2 | 755.6 | 763.6 | 102.0 |
| 2012-10-11 | FTI | Futures | 280.59 | 282.44 | 280.59 | 281.88 | 128.0 |
| 2012-10-11 | FTUK | Futures | 4195.6 | 4259.2 | 4195.6 | 4249.4 | 78910.0 |
| 2012-10-11 | FVSA | Futures | 5547.94 | 5547.94 | 5327.98 | 5364.64 | 2273.0 |
| 2012-10-11 | FXXP | Futures | 193.0 | 195.2 | 192.9 | 194.9 | 2016.0 |
| 2012-10-11 | G | Futures | 99.39 | 99.4 | 98.82 | 98.95 | 148811.0 |
| 2012-10-11 | GF | Futures | 281.123 | 281.411 | 275.987 | 276.131 | 4206.0 |
| 2012-10-11 | GSCI | Futures | 1087.38 | 1091.26 | 1083.42 | 1087.86 | 2292.0 |
| 2012-10-11 | HE | Futures | 96.766 | 96.953 | 95.151 | 96.331 | 25111.0 |
| 2012-10-11 | HG | Futures | 4.7696 | 4.8557 | 4.7445 | 4.821 | 45569.0 |
| 2012-10-11 | HH | Futures | 45.955 | 45.955 | 45.955 | 45.955 | 2844.0 |
| 2012-10-11 | HO | Futures | 2.5862 | 2.6271 | 2.5845 | 2.6199 | 46205.0 |
| 2012-10-11 | HRC | Futures | 2430.8 | 2430.8 | 2430.8 | 2430.8 | 0.0 |
| 2012-10-11 | J1 | Futures | 0.0160283 | 0.0160709 | 0.0159382 | 0.0159907 | 94067.0 |
| 2012-10-11 | J7 | Futures | 0.015964 | 0.016003 | 0.015871 | 0.015923 | 682.0 |
> showing 50 of 96 rows — these rows as CSV