PREVIEW / futures_daily / 2012-11-16
file: by_date/futures_daily/2012/2012-11-16.parquet size: 9 KB rows: 100
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-11-16 | ES | Futures | 1375.53 | 1384.69 | 1364.08 | 1383.93 | 2605521.0 |
| 2012-11-16 | NQ | Futures | 2902.71 | 2921.69 | 2867.32 | 2914.5 | 342959.0 |
| 2012-11-16 | YM | Futures | 12225.7 | 12277.4 | 12141.7 | 12274.5 | 167779.0 |
| 2012-11-16 | CL | Futures | 153.63 | 156.48 | 152.93 | 155.63 | 271209.0 |
| 2012-11-16 | GC | Futures | 2290.4 | 2292.7 | 2277.2 | 2289.4 | 136952.0 |
| 2012-11-16 | ZN | Futures | 117.810137 | 118.098551 | 117.727733 | 117.947477 | 948380.0 |
| 2012-11-16 | A6 | Futures | 0.93698 | 0.93844 | 0.93262 | 0.9368 | 131317.0 |
| 2012-11-16 | AD | Futures | 1.00278 | 1.00338 | 0.99726 | 1.00128 | 80802.0 |
| 2012-11-16 | B | Futures | 99.45 | 100.89 | 99.42 | 100.61 | 200902.0 |
| 2012-11-16 | B6 | Futures | 1.6567 | 1.6606 | 1.6537 | 1.6585 | 95161.0 |
| 2012-11-16 | BFX | Futures | 2802.9 | 2809.0 | 2777.6 | 2786.2 | 106.0 |
| 2012-11-16 | BR | Futures | 0.23364 | 0.23364 | 0.23223 | 0.23328 | 116.0 |
| 2012-11-16 | BZ | Futures | 102.98 | 103.98 | 102.66 | 103.74 | 432.0 |
| 2012-11-16 | C | Futures | 1620.0 | 1625.0 | 1569.0 | 1577.0 | 4893.0 |
| 2012-11-16 | CB | Futures | 91.525 | 91.525 | 91.525 | 91.525 | 1.0 |
| 2012-11-16 | CC | Futures | 1860.0 | 1871.0 | 1799.0 | 1809.0 | 18985.0 |
| 2012-11-16 | CSC | Futures | 3.906 | 3.929 | 3.889 | 3.922 | 82.0 |
| 2012-11-16 | CT | Futures | 95.18 | 96.1 | 93.14 | 93.85 | 11431.0 |
| 2012-11-16 | DC | Futures | 29.02 | 29.41 | 28.85 | 29.06 | 314.0 |
| 2012-11-16 | DX | Futures | 78.55 | 78.956 | 78.535 | 78.758 | 28853.0 |
| 2012-11-16 | E1 | Futures | 1.36643 | 1.36669 | 1.35665 | 1.36051 | 30941.0 |
| 2012-11-16 | E6 | Futures | 1.50542 | 1.50589 | 1.4947 | 1.49906 | 254596.0 |
| 2012-11-16 | E7 | Futures | 1.4962 | 1.4968 | 1.4859 | 1.4901 | 3416.0 |
| 2012-11-16 | ED | Futures | 95.2253 | 95.2253 | 95.211 | 95.2205 | 205480.0 |
| 2012-11-16 | ER | Futures | 97.881 | 97.886 | 97.876 | 97.881 | 59103.0 |
| 2012-11-16 | EW | Futures | 962.5 | 971.1 | 956.9 | 970.7 | 24888.0 |
| 2012-11-16 | FBTP | Futures | 72.82 | 73.09 | 72.72 | 72.94 | 13981.0 |
| 2012-11-16 | FBTS | Futures | 89.969 | 90.027 | 89.893 | 89.969 | 1828.0 |
| 2012-11-16 | FCE | Futures | 2536.1 | 2553.4 | 2513.1 | 2514.6 | 153387.0 |
| 2012-11-16 | FDAX | Futures | 7706.1 | 7734.6 | 7611.9 | 7623.4 | 161401.0 |
| 2012-11-16 | FESX | Futures | 1669.5 | 1677.7 | 1649.1 | 1652.5 | 1317791.0 |
| 2012-11-16 | FGBL | Futures | 119.78 | 119.89 | 119.51 | 119.77 | 501759.0 |
| 2012-11-16 | FGBM | Futures | 117.15 | 117.24 | 117.04 | 117.17 | 262021.0 |
| 2012-11-16 | FGBS | Futures | 110.527 | 110.552 | 110.517 | 110.537 | 141417.0 |
| 2012-11-16 | FGBX | Futures | 126.93 | 127.05 | 126.25 | 126.84 | 9067.0 |
| 2012-11-16 | FOAT | Futures | 104.98 | 105.17 | 104.93 | 105.08 | 26365.0 |
| 2012-11-16 | FTDX | Futures | 748.6 | 749.1 | 742.9 | 744.3 | 77.0 |
| 2012-11-16 | FTI | Futures | 278.24 | 278.62 | 273.95 | 274.12 | 51028.0 |
| 2012-11-16 | FTUK | Futures | 4144.4 | 4153.5 | 4090.9 | 4098.3 | 116634.0 |
| 2012-11-16 | FVSA | Futures | 4932.81 | 5036.3 | 4829.33 | 4978.81 | 6844.0 |
| 2012-11-16 | FXXP | Futures | 191.8 | 191.8 | 189.4 | 189.6 | 3087.0 |
| 2012-11-16 | G | Futures | 99.46 | 99.63 | 99.33 | 99.52 | 107390.0 |
| 2012-11-16 | GF | Futures | 275.618 | 276.424 | 274.859 | 276.282 | 1499.0 |
| 2012-11-16 | GSCI | Futures | 1026.98 | 1030.05 | 1020.53 | 1028.59 | 43.0 |
| 2012-11-16 | HE | Futures | 99.687 | 100.34 | 99.408 | 99.843 | 10978.0 |
| 2012-11-16 | HG | Futures | 4.4573 | 4.4644 | 4.3982 | 4.4355 | 45380.0 |
| 2012-11-16 | HH | Futures | 44.096 | 44.096 | 44.096 | 44.096 | 1550.0 |
| 2012-11-16 | HO | Futures | 2.4022 | 2.4291 | 2.392 | 2.4209 | 43073.0 |
| 2012-11-16 | HRC | Futures | 2458.3 | 2458.3 | 2458.3 | 2458.3 | 0.0 |
| 2012-11-16 | J1 | Futures | 0.0154323 | 0.0154799 | 0.015376 | 0.0154173 | 108491.0 |
> showing 50 of 100 rows — these rows as CSV