PREVIEW / futures_daily / 2012-09-10
file: by_date/futures_daily/2012/2012-09-10.parquet size: 9 KB rows: 93
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-09-10 | ES | Futures | 1455.03 | 1456.29 | 1443.89 | 1444.65 | 1096739.0 |
| 2012-09-10 | NQ | Futures | 3239.27 | 3241.0 | 3195.95 | 3195.95 | 188797.0 |
| 2012-09-10 | YM | Futures | 12899.4 | 12926.8 | 12845.7 | 12847.7 | 2705.0 |
| 2012-09-10 | CL | Futures | 174.11 | 174.81 | 172.48 | 174.65 | 221996.0 |
| 2012-09-10 | GC | Futures | 2320.5 | 2326.2 | 2305.8 | 2312.2 | 111150.0 |
| 2012-09-10 | ZN | Futures | 116.903694 | 117.109704 | 116.738886 | 116.780088 | 702944.0 |
| 2012-09-10 | A6 | Futures | 0.93389 | 0.93535 | 0.93053 | 0.93135 | 9895.0 |
| 2012-09-10 | AD | Futures | 1.02476 | 1.02667 | 1.02316 | 1.02456 | 44626.0 |
| 2012-09-10 | B | Futures | 103.66 | 104.48 | 103.46 | 104.23 | 129897.0 |
| 2012-09-10 | B6 | Futures | 1.6727 | 1.6736 | 1.6663 | 1.6705 | 23252.0 |
| 2012-09-10 | BR | Futures | 0.23711 | 0.23711 | 0.23663 | 0.23663 | 89.0 |
| 2012-09-10 | BZ | Futures | 108.7 | 109.29 | 108.64 | 109.24 | 1503.0 |
| 2012-09-10 | C | Futures | 1734.0 | 1745.0 | 1696.0 | 1732.0 | 6879.0 |
| 2012-09-10 | CC | Futures | 2005.0 | 2014.0 | 1947.0 | 2001.0 | 14449.0 |
| 2012-09-10 | CSC | Futures | 3.996 | 3.996 | 3.96 | 3.96 | 9.0 |
| 2012-09-10 | CT | Futures | 99.77 | 100.02 | 98.77 | 98.77 | 15.0 |
| 2012-09-10 | DC | Futures | 29.92 | 29.95 | 29.46 | 29.57 | 104.0 |
| 2012-09-10 | DX | Futures | 77.876 | 78.06 | 77.78 | 78.006 | 3302.0 |
| 2012-09-10 | E1 | Futures | 1.36566 | 1.36604 | 1.35922 | 1.36192 | 12833.0 |
| 2012-09-10 | E6 | Futures | 1.50966 | 1.51001 | 1.50354 | 1.50518 | 33057.0 |
| 2012-09-10 | E7 | Futures | 1.5003 | 1.5006 | 1.4948 | 1.4962 | 270.0 |
| 2012-09-10 | ED | Futures | 95.1919 | 95.2014 | 95.1871 | 95.1966 | 114505.0 |
| 2012-09-10 | ER | Futures | 97.847 | 97.857 | 97.832 | 97.852 | 92683.0 |
| 2012-09-10 | EW | Futures | 1018.1 | 1022.2 | 1014.2 | 1014.2 | 761.0 |
| 2012-09-10 | FBTP | Futures | 70.65 | 70.89 | 70.01 | 70.32 | 14839.0 |
| 2012-09-10 | FBTS | Futures | 88.804 | 89.282 | 88.804 | 89.131 | 2823.0 |
| 2012-09-10 | FCE | Futures | 2617.5 | 2629.8 | 2600.4 | 2613.4 | 67736.0 |
| 2012-09-10 | FDAX | Futures | 7869.6 | 7899.0 | 7845.0 | 7878.3 | 82419.0 |
| 2012-09-10 | FESX | Futures | 1717.8 | 1721.2 | 1703.5 | 1714.4 | 130261.0 |
| 2012-09-10 | FGBL | Futures | 117.44 | 117.78 | 117.11 | 117.27 | 583995.0 |
| 2012-09-10 | FGBM | Futures | 115.92 | 116.05 | 115.72 | 115.82 | 343860.0 |
| 2012-09-10 | FGBS | Futures | 110.333 | 110.348 | 110.298 | 110.338 | 255362.0 |
| 2012-09-10 | FGBX | Futures | 123.84 | 124.51 | 122.36 | 123.1 | 10549.0 |
| 2012-09-10 | FOAT | Futures | 102.56 | 102.58 | 102.11 | 102.18 | 18070.0 |
| 2012-09-10 | FTDX | Futures | 754.7 | 754.7 | 754.7 | 754.7 | 556.0 |
| 2012-09-10 | FTI | Futures | 287.5 | 287.84 | 285.58 | 286.34 | 125.0 |
| 2012-09-10 | FTUK | Futures | 4211.3 | 4225.9 | 4198.9 | 4217.9 | 11135.0 |
| 2012-09-10 | FVSA | Futures | 6046.02 | 6148.5 | 5943.55 | 6097.26 | 6297.0 |
| 2012-09-10 | FXXP | Futures | 195.1 | 195.3 | 195.1 | 195.3 | 1359.0 |
| 2012-09-10 | G | Futures | 99.73 | 99.75 | 99.04 | 99.19 | 106627.0 |
| 2012-09-10 | GF | Futures | 284.279 | 285.885 | 283.549 | 285.349 | 2473.0 |
| 2012-09-10 | GSCI | Futures | 1090.97 | 1095.81 | 1090.73 | 1095.81 | 1376.0 |
| 2012-09-10 | HE | Futures | 88.116 | 90.217 | 88.116 | 89.692 | 27278.0 |
| 2012-09-10 | HG | Futures | 4.6835 | 4.7548 | 4.6687 | 4.74 | 59209.0 |
| 2012-09-10 | HH | Futures | 36.865 | 38.058 | 36.865 | 37.696 | 205.0 |
| 2012-09-10 | HO | Futures | 2.5572 | 2.5687 | 2.5503 | 2.5666 | 23126.0 |
| 2012-09-10 | HRC | Futures | 2471.7 | 2471.7 | 2471.7 | 2471.7 | 0.0 |
| 2012-09-10 | J1 | Futures | 0.0160108 | 0.0160271 | 0.0159983 | 0.0160133 | 19548.0 |
| 2012-09-10 | J7 | Futures | 0.015948 | 0.015948 | 0.015926 | 0.015945 | 44.0 |
| 2012-09-10 | JB | Futures | 126.43 | 126.72 | 126.43 | 126.65 | 2225.0 |
> showing 50 of 93 rows — these rows as CSV