PREVIEW / futures_daily / 2012-09-14
file: by_date/futures_daily/2012/2012-09-14.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-09-14 | ES | Futures | 1475.79 | 1494.11 | 1475.28 | 1484.95 | 2463875.0 |
| 2012-09-14 | NQ | Futures | 3245.3 | 3289.89 | 3245.3 | 3279.53 | 315187.0 |
| 2012-09-14 | YM | Futures | 13127.9 | 13256.8 | 13121.1 | 13200.2 | 134176.0 |
| 2012-09-14 | CL | Futures | 177.4 | 181.8 | 177.4 | 179.27 | 141037.0 |
| 2012-09-14 | GC | Futures | 2362.4 | 2376.8 | 2360.1 | 2366.8 | 195524.0 |
| 2012-09-14 | ZN | Futures | 116.835024 | 116.848758 | 115.777507 | 115.928581 | 1328743.0 |
| 2012-09-14 | A6 | Futures | 0.95016 | 0.95752 | 0.94889 | 0.95216 | 162856.0 |
| 2012-09-14 | AD | Futures | 1.0338 | 1.03972 | 1.02978 | 1.03229 | 121845.0 |
| 2012-09-14 | B | Futures | 105.46 | 107.55 | 105.39 | 106.37 | 181373.0 |
| 2012-09-14 | B6 | Futures | 1.6867 | 1.6972 | 1.6855 | 1.6936 | 130378.0 |
| 2012-09-14 | BFX | Futures | 2939.4 | 2949.7 | 2939.4 | 2944.9 | 137.0 |
| 2012-09-14 | BR | Futures | 0.23753 | 0.23828 | 0.23753 | 0.23828 | 148.0 |
| 2012-09-14 | BZ | Futures | 111.81 | 112.69 | 111.32 | 111.49 | 2177.0 |
| 2012-09-14 | C | Futures | 1723.0 | 1736.0 | 1705.0 | 1715.0 | 4233.0 |
| 2012-09-14 | CC | Futures | 1981.0 | 2017.0 | 1974.0 | 1992.0 | 10283.0 |
| 2012-09-14 | CSC | Futures | 4.084 | 4.084 | 4.084 | 4.084 | 1.0 |
| 2012-09-14 | CT | Futures | 97.02 | 99.42 | 97.02 | 99.31 | 51.0 |
| 2012-09-14 | DC | Futures | 30.65 | 31.03 | 30.6 | 30.85 | 204.0 |
| 2012-09-14 | DX | Futures | 76.903 | 76.917 | 76.254 | 76.508 | 36450.0 |
| 2012-09-14 | E1 | Futures | 1.37814 | 1.395 | 1.37763 | 1.39024 | 40222.0 |
| 2012-09-14 | E6 | Futures | 1.53027 | 1.55193 | 1.52968 | 1.54593 | 329684.0 |
| 2012-09-14 | E7 | Futures | 1.5211 | 1.5426 | 1.5206 | 1.5367 | 4710.0 |
| 2012-09-14 | ED | Futures | 95.2205 | 95.2301 | 95.211 | 95.2205 | 171248.0 |
| 2012-09-14 | ER | Futures | 97.837 | 97.847 | 97.827 | 97.837 | 139922.0 |
| 2012-09-14 | EW | Futures | 1031.5 | 1047.2 | 1031.3 | 1044.4 | 40918.0 |
| 2012-09-14 | FBTP | Futures | 71.39 | 71.63 | 71.07 | 71.25 | 17055.0 |
| 2012-09-14 | FBTS | Futures | 89.282 | 89.407 | 89.081 | 89.19 | 2731.0 |
| 2012-09-14 | FCE | Futures | 2656.7 | 2674.3 | 2650.7 | 2670.6 | 21716.0 |
| 2012-09-14 | FDAX | Futures | 8102.7 | 8131.0 | 8059.5 | 8090.6 | 144299.0 |
| 2012-09-14 | FESX | Futures | 1756.6 | 1765.5 | 1748.4 | 1754.6 | 413476.0 |
| 2012-09-14 | FEU3 | Futures | 98.463 | 98.463 | 98.458 | 98.458 | 3.0 |
| 2012-09-14 | FGBL | Futures | 117.07 | 117.08 | 115.84 | 115.95 | 974904.0 |
| 2012-09-14 | FGBM | Futures | 115.65 | 115.66 | 115.15 | 115.21 | 590457.0 |
| 2012-09-14 | FGBS | Futures | 110.273 | 110.283 | 110.193 | 110.203 | 461922.0 |
| 2012-09-14 | FGBX | Futures | 122.76 | 122.76 | 119.35 | 120.12 | 13636.0 |
| 2012-09-14 | FOAT | Futures | 102.77 | 102.92 | 102.02 | 102.2 | 24721.0 |
| 2012-09-14 | FTDX | Futures | 766.0 | 766.0 | 765.1 | 765.1 | 127.0 |
| 2012-09-14 | FTI | Futures | 288.69 | 289.93 | 287.5 | 288.6 | 1934.0 |
| 2012-09-14 | FTUK | Futures | 4286.3 | 4321.1 | 4281.6 | 4299.1 | 54850.0 |
| 2012-09-14 | FVSA | Futures | 5987.87 | 5987.87 | 5682.36 | 5914.55 | 9247.0 |
| 2012-09-14 | FXXP | Futures | 198.2 | 198.9 | 198.1 | 198.2 | 384.0 |
| 2012-09-14 | G | Futures | 98.08 | 98.41 | 97.25 | 97.47 | 188040.0 |
| 2012-09-14 | GF | Futures | 286.615 | 286.81 | 283.889 | 285.447 | 3427.0 |
| 2012-09-14 | GSCI | Futures | 1123.7 | 1124.91 | 1119.27 | 1120.88 | 2671.0 |
| 2012-09-14 | HE | Futures | 90.804 | 92.04 | 90.372 | 91.484 | 21457.0 |
| 2012-09-14 | HG | Futures | 4.7959 | 4.9322 | 4.7934 | 4.9251 | 56484.0 |
| 2012-09-14 | HH | Futures | 39.452 | 39.452 | 39.452 | 39.452 | 2081.0 |
| 2012-09-14 | HO | Futures | 2.6029 | 2.6423 | 2.6029 | 2.6221 | 24794.0 |
| 2012-09-14 | HRC | Futures | 2471.7 | 2471.7 | 2471.7 | 2471.7 | 0.0 |
| 2012-09-14 | J1 | Futures | 0.0161685 | 0.016171 | 0.0159807 | 0.0160033 | 144109.0 |
> showing 50 of 99 rows — these rows as CSV