PREVIEW / futures_daily / 2012-05-14
file: by_date/futures_daily/2012/2012-05-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-05-14 | ES | Futures | 1356.39 | 1361.42 | 1343.54 | 1344.29 | 1912994.0 |
| 2012-05-14 | NQ | Futures | 2981.16 | 2993.77 | 2959.97 | 2961.69 | 245850.0 |
| 2012-05-14 | YM | Futures | 12401.2 | 12445.9 | 12279.6 | 12306.9 | 160946.0 |
| 2012-05-14 | CL | Futures | 176.34 | 176.34 | 172.31 | 174.34 | 79881.0 |
| 2012-05-14 | GC | Futures | 2119.5 | 2119.9 | 2078.7 | 2086.7 | 162291.0 |
| 2012-05-14 | ZN | Futures | 115.343594 | 115.763271 | 115.316518 | 115.600815 | 1000344.0 |
| 2012-05-14 | A6 | Futures | 0.89685 | 0.89973 | 0.89253 | 0.8937 | 139871.0 |
| 2012-05-14 | AD | Futures | 1.0038 | 1.00601 | 0.99998 | 1.00239 | 75061.0 |
| 2012-05-14 | B | Futures | 100.87 | 100.87 | 99.06 | 100.37 | 204421.0 |
| 2012-05-14 | B6 | Futures | 1.6863 | 1.692 | 1.6843 | 1.6899 | 111815.0 |
| 2012-05-14 | BFX | Futures | 2594.1 | 2594.1 | 2589.8 | 2589.9 | 1555.0 |
| 2012-05-14 | BR | Futures | 0.23935 | 0.23935 | 0.23694 | 0.23875 | 428.0 |
| 2012-05-14 | BZ | Futures | 107.28 | 107.28 | 105.58 | 106.96 | 2395.0 |
| 2012-05-14 | C | Futures | 1519.0 | 1527.0 | 1501.0 | 1503.0 | 10322.0 |
| 2012-05-14 | CB | Futures | 74.814 | 75.89 | 74.814 | 74.814 | 13.0 |
| 2012-05-14 | CC | Futures | 1736.0 | 1736.0 | 1674.0 | 1705.0 | 11562.0 |
| 2012-05-14 | CSC | Futures | 3.4 | 3.451 | 3.38 | 3.391 | 27.0 |
| 2012-05-14 | CT | Futures | 96.36 | 97.75 | 95.24 | 96.42 | 15066.0 |
| 2012-05-14 | DC | Futures | 24.45 | 24.74 | 24.05 | 24.12 | 439.0 |
| 2012-05-14 | DX | Futures | 78.054 | 78.344 | 77.986 | 78.236 | 30319.0 |
| 2012-05-14 | E1 | Futures | 1.4068 | 1.40693 | 1.39816 | 1.40051 | 44808.0 |
| 2012-05-14 | E6 | Futures | 1.53815 | 1.54078 | 1.53075 | 1.53338 | 268593.0 |
| 2012-05-14 | E7 | Futures | 1.5238 | 1.526 | 1.5157 | 1.5187 | 2716.0 |
| 2012-05-14 | ED | Futures | 95.043 | 95.0478 | 95.0287 | 95.0406 | 285756.0 |
| 2012-05-14 | ER | Futures | 97.513 | 97.518 | 97.479 | 97.489 | 151444.0 |
| 2012-05-14 | EW | Futures | 970.1 | 974.5 | 958.2 | 960.2 | 30356.0 |
| 2012-05-14 | FBTP | Futures | 66.34 | 66.47 | 65.18 | 65.63 | 26798.0 |
| 2012-05-14 | FBTS | Futures | 85.363 | 85.363 | 84.721 | 84.875 | 4558.0 |
| 2012-05-14 | FCE | Futures | 2259.4 | 2262.0 | 2217.0 | 2232.8 | 37081.0 |
| 2012-05-14 | FDAX | Futures | 7196.4 | 7216.3 | 7081.5 | 7150.0 | 154257.0 |
| 2012-05-14 | FESX | Futures | 1519.8 | 1525.3 | 1492.2 | 1506.0 | 1316077.0 |
| 2012-05-14 | FGBL | Futures | 117.29 | 117.82 | 117.21 | 117.58 | 656746.0 |
| 2012-05-14 | FGBM | Futures | 115.45 | 115.7 | 115.41 | 115.57 | 425545.0 |
| 2012-05-14 | FGBS | Futures | 110.218 | 110.273 | 110.213 | 110.248 | 305589.0 |
| 2012-05-14 | FGBX | Futures | 124.14 | 126.26 | 123.95 | 125.22 | 9026.0 |
| 2012-05-14 | FOAT | Futures | 96.28 | 96.36 | 95.87 | 96.11 | 16066.0 |
| 2012-05-14 | FTDX | Futures | 727.0 | 727.0 | 719.5 | 722.8 | 88.0 |
| 2012-05-14 | FTI | Futures | 261.81 | 261.81 | 256.61 | 258.0 | 5953.0 |
| 2012-05-14 | FTUK | Futures | 4011.9 | 4030.2 | 3950.7 | 3976.2 | 129233.0 |
| 2012-05-14 | FVSA | Futures | 9507.38 | 9788.84 | 9444.83 | 9710.66 | 3164.0 |
| 2012-05-14 | FXXP | Futures | 180.0 | 180.0 | 177.5 | 178.7 | 3488.0 |
| 2012-05-14 | G | Futures | 96.52 | 97.17 | 96.51 | 96.98 | 107996.0 |
| 2012-05-14 | GF | Futures | 310.249 | 311.038 | 308.078 | 310.249 | 3182.0 |
| 2012-05-14 | GSCI | Futures | 1004.96 | 1010.76 | 1002.98 | 1007.03 | 480.0 |
| 2012-05-14 | HE | Futures | 91.099 | 91.606 | 90.566 | 91.073 | 24201.0 |
| 2012-05-14 | HG | Futures | 4.7774 | 4.8121 | 4.5849 | 4.6543 | 70852.0 |
| 2012-05-14 | HO | Futures | 2.4362 | 2.4362 | 2.3955 | 2.4082 | 57243.0 |
| 2012-05-14 | HRC | Futures | 2629.4 | 2629.4 | 2629.4 | 2629.4 | 0.0 |
| 2012-05-14 | J1 | Futures | 0.0156924 | 0.0157401 | 0.0156423 | 0.015705 | 70062.0 |
| 2012-05-14 | J7 | Futures | 0.015616 | 0.015667 | 0.015569 | 0.015631 | 446.0 |
> showing 50 of 99 rows — these rows as CSV