PREVIEW / futures_daily / 2012-07-30
file: by_date/futures_daily/2012/2012-07-30.parquet size: 9 KB rows: 98
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-07-30 | ES | Futures | 1396.79 | 1405.15 | 1393.25 | 1398.06 | 1486890.0 |
| 2012-07-30 | NQ | Futures | 3030.09 | 3050.47 | 3016.61 | 3025.22 | 235413.0 |
| 2012-07-30 | YM | Futures | 12629.7 | 12682.1 | 12595.8 | 12613.2 | 104687.0 |
| 2012-07-30 | CL | Futures | 163.6 | 165.07 | 162.13 | 162.95 | 191095.0 |
| 2012-07-30 | GC | Futures | 2172.9 | 2176.3 | 2159.7 | 2168.3 | 111653.0 |
| 2012-07-30 | ZN | Futures | 116.985407 | 117.339495 | 116.808362 | 117.28502 | 840589.0 |
| 2012-07-30 | A6 | Futures | 0.93812 | 0.94064 | 0.93533 | 0.94028 | 105735.0 |
| 2012-07-30 | AD | Futures | 0.99709 | 1.0002 | 0.99619 | 0.9997 | 85241.0 |
| 2012-07-30 | B | Futures | 95.63 | 96.12 | 94.94 | 95.51 | 66584.0 |
| 2012-07-30 | B6 | Futures | 1.6442 | 1.6449 | 1.6378 | 1.6416 | 77248.0 |
| 2012-07-30 | BR | Futures | 0.23482 | 0.23482 | 0.2326 | 0.23331 | 715.0 |
| 2012-07-30 | BZ | Futures | 100.66 | 100.66 | 100.66 | 100.66 | 518.0 |
| 2012-07-30 | C | Futures | 1629.0 | 1644.0 | 1627.0 | 1638.0 | 2947.0 |
| 2012-07-30 | CB | Futures | 90.961 | 90.961 | 90.692 | 90.692 | 15.0 |
| 2012-07-30 | CC | Futures | 1756.0 | 1775.0 | 1748.0 | 1764.0 | 11063.0 |
| 2012-07-30 | CSC | Futures | 3.956 | 3.979 | 3.949 | 3.973 | 36.0 |
| 2012-07-30 | CT | Futures | 93.24 | 93.79 | 92.46 | 93.03 | 80.0 |
| 2012-07-30 | DC | Futures | 29.07 | 29.45 | 28.99 | 29.39 | 213.0 |
| 2012-07-30 | DX | Futures | 80.323 | 80.605 | 80.299 | 80.433 | 13967.0 |
| 2012-07-30 | E1 | Futures | 1.32369 | 1.32473 | 1.31569 | 1.3193 | 29250.0 |
| 2012-07-30 | E6 | Futures | 1.45209 | 1.45292 | 1.44301 | 1.44726 | 182033.0 |
| 2012-07-30 | E7 | Futures | 1.4439 | 1.444 | 1.434 | 1.4383 | 2724.0 |
| 2012-07-30 | ED | Futures | 95.2038 | 95.2134 | 95.1943 | 95.2038 | 134429.0 |
| 2012-07-30 | ER | Futures | 97.852 | 97.852 | 97.793 | 97.822 | 161449.0 |
| 2012-07-30 | EW | Futures | 961.4 | 964.3 | 954.1 | 956.4 | 23398.0 |
| 2012-07-30 | FBTP | Futures | 65.87 | 66.0 | 65.01 | 65.37 | 28385.0 |
| 2012-07-30 | FBTS | Futures | 85.154 | 85.385 | 85.021 | 85.236 | 3842.0 |
| 2012-07-30 | FCE | Futures | 2466.4 | 2479.8 | 2447.4 | 2470.1 | 125459.0 |
| 2012-07-30 | FDAX | Futures | 7376.6 | 7421.9 | 7318.2 | 7405.0 | 130700.0 |
| 2012-07-30 | FESX | Futures | 1569.0 | 1585.9 | 1559.6 | 1581.2 | 1209944.0 |
| 2012-07-30 | FEU3 | Futures | 98.404 | 98.404 | 98.399 | 98.404 | 35.0 |
| 2012-07-30 | FGBL | Futures | 118.18 | 118.66 | 118.11 | 118.44 | 581013.0 |
| 2012-07-30 | FGBM | Futures | 116.3 | 116.4 | 116.19 | 116.29 | 377937.0 |
| 2012-07-30 | FGBS | Futures | 110.587 | 110.607 | 110.552 | 110.557 | 279266.0 |
| 2012-07-30 | FGBX | Futures | 125.55 | 126.71 | 125.19 | 125.83 | 6282.0 |
| 2012-07-30 | FOAT | Futures | 101.72 | 102.15 | 101.56 | 101.91 | 16583.0 |
| 2012-07-30 | FTDX | Futures | 724.9 | 728.6 | 724.5 | 727.2 | 94.0 |
| 2012-07-30 | FTI | Futures | 276.47 | 279.49 | 275.06 | 278.47 | 32749.0 |
| 2012-07-30 | FTUK | Futures | 4076.3 | 4123.9 | 4062.8 | 4115.9 | 87196.0 |
| 2012-07-30 | FVSA | Futures | 7191.62 | 7247.04 | 7011.48 | 7177.76 | 2202.0 |
| 2012-07-30 | FXXP | Futures | 186.7 | 189.0 | 186.7 | 188.6 | 3015.0 |
| 2012-07-30 | G | Futures | 100.33 | 100.34 | 99.89 | 100.13 | 114536.0 |
| 2012-07-30 | GF | Futures | 268.409 | 273.886 | 267.965 | 272.849 | 4030.0 |
| 2012-07-30 | GSCI | Futures | 1024.25 | 1027.43 | 1023.37 | 1027.43 | 205.0 |
| 2012-07-30 | HE | Futures | 101.768 | 101.768 | 100.699 | 101.073 | 6672.0 |
| 2012-07-30 | HG | Futures | 4.4175 | 4.4517 | 4.3834 | 4.4008 | 44088.0 |
| 2012-07-30 | HO | Futures | 2.3634 | 2.3689 | 2.3473 | 2.3559 | 55451.0 |
| 2012-07-30 | HRC | Futures | 2509.4 | 2509.4 | 2509.4 | 2509.4 | 0.0 |
| 2012-07-30 | J1 | Futures | 0.0159732 | 0.0160509 | 0.0159619 | 0.0160434 | 58866.0 |
| 2012-07-30 | J7 | Futures | 0.015909 | 0.015987 | 0.015903 | 0.01598 | 118.0 |
> showing 50 of 98 rows — these rows as CSV