PREVIEW / futures_daily / 2011-10-10
file: by_date/futures_daily/2011/2011-10-10.parquet size: 9 KB rows: 95
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 |
|---|---|---|---|---|---|---|---|
| 2011-10-10 | ES | Futures | 1155.72 | 1190.16 | 1154.47 | 1188.91 | 1776333.0 |
| 2011-10-10 | NQ | Futures | 2518.05 | 2599.38 | 2514.63 | 2598.81 | 223258.0 |
| 2011-10-10 | YM | Futures | 10644.1 | 10927.5 | 10644.1 | 10920.8 | 96497.0 |
| 2011-10-10 | CL | Futures | 156.03 | 162.33 | 156.03 | 161.05 | 264825.0 |
| 2011-10-10 | GC | Futures | 2214.9 | 2267.9 | 2214.1 | 2255.8 | 92090.0 |
| 2011-10-10 | ZN | Futures | 110.557458 | 110.611087 | 109.458051 | 109.484865 | 249586.0 |
| 2011-10-10 | A6 | Futures | 0.85132 | 0.87331 | 0.85053 | 0.87314 | 104191.0 |
| 2011-10-10 | AD | Futures | 0.96233 | 0.97444 | 0.96163 | 0.97284 | 53394.0 |
| 2011-10-10 | B | Futures | 91.03 | 93.77 | 90.72 | 93.24 | 180153.0 |
| 2011-10-10 | B6 | Futures | 1.6222 | 1.6364 | 1.6195 | 1.6351 | 77502.0 |
| 2011-10-10 | BR | Futures | 0.25465 | 0.25557 | 0.25465 | 0.25539 | 49.0 |
| 2011-10-10 | BZ | Futures | 96.43 | 98.99 | 96.43 | 98.55 | 665.0 |
| 2011-10-10 | C | Futures | 1827.0 | 1834.0 | 1805.0 | 1807.0 | 3509.0 |
| 2011-10-10 | CB | Futures | 93.834 | 93.834 | 93.834 | 93.834 | 5.0 |
| 2011-10-10 | CC | Futures | 2082.0 | 2119.0 | 2078.0 | 2083.0 | 6448.0 |
| 2011-10-10 | CSC | Futures | 4.044 | 4.044 | 3.898 | 3.898 | 24.0 |
| 2011-10-10 | CT | Futures | 131.66 | 133.95 | 131.64 | 133.23 | 5454.0 |
| 2011-10-10 | DC | Futures | 28.66 | 28.66 | 27.27 | 27.4 | 256.0 |
| 2011-10-10 | DX | Futures | 77.629 | 77.732 | 76.25 | 76.388 | 25643.0 |
| 2011-10-10 | E1 | Futures | 1.41869 | 1.45976 | 1.41712 | 1.4553 | 25036.0 |
| 2011-10-10 | E6 | Futures | 1.59943 | 1.63624 | 1.59812 | 1.63194 | 256950.0 |
| 2011-10-10 | E7 | Futures | 1.5864 | 1.6224 | 1.5847 | 1.618 | 4796.0 |
| 2011-10-10 | ED | Futures | 94.9268 | 94.9507 | 94.922 | 94.9411 | 46750.0 |
| 2011-10-10 | ER | Futures | 97.248 | 97.258 | 97.204 | 97.213 | 94055.0 |
| 2011-10-10 | EW | Futures | 805.5 | 830.6 | 805.4 | 828.0 | 23419.0 |
| 2011-10-10 | FBTP | Futures | 62.79 | 62.79 | 62.6 | 62.69 | 3532.0 |
| 2011-10-10 | FBTS | Futures | 82.361 | 82.433 | 82.305 | 82.417 | 1038.0 |
| 2011-10-10 | FCE | Futures | 2232.0 | 2263.1 | 2210.6 | 2257.4 | 92243.0 |
| 2011-10-10 | FDAX | Futures | 6236.4 | 6389.5 | 6146.3 | 6355.3 | 148058.0 |
| 2011-10-10 | FESX | Futures | 1519.8 | 1542.4 | 1501.2 | 1535.8 | 1120375.0 |
| 2011-10-10 | FEU3 | Futures | 97.781 | 97.791 | 97.771 | 97.771 | 34.0 |
| 2011-10-10 | FGBL | Futures | 109.78 | 109.87 | 108.74 | 108.92 | 633070.0 |
| 2011-10-10 | FGBM | Futures | 110.41 | 110.45 | 109.89 | 109.97 | 289663.0 |
| 2011-10-10 | FGBS | Futures | 108.94 | 108.959 | 108.78 | 108.825 | 392032.0 |
| 2011-10-10 | FGBX | Futures | 111.92 | 111.92 | 110.27 | 110.6 | 7412.0 |
| 2011-10-10 | FTDX | Futures | 610.4 | 623.8 | 602.6 | 615.0 | 211.0 |
| 2011-10-10 | FTI | Futures | 239.52 | 242.17 | 237.13 | 241.92 | 36.0 |
| 2011-10-10 | FTUK | Futures | 3779.3 | 3867.6 | 3779.3 | 3854.3 | 89878.0 |
| 2011-10-10 | FVSA | Futures | 17412.83 | 17455.1 | 16483.02 | 16483.02 | 8045.0 |
| 2011-10-10 | FXXP | Futures | 161.7 | 164.3 | 161.4 | 163.9 | 1926.0 |
| 2011-10-10 | G | Futures | 90.75 | 90.96 | 89.85 | 90.04 | 121629.0 |
| 2011-10-10 | GF | Futures | 316.133 | 319.232 | 313.81 | 316.742 | 3211.0 |
| 2011-10-10 | GSCI | Futures | 961.59 | 974.83 | 961.59 | 971.54 | 1618.0 |
| 2011-10-10 | HE | Futures | 114.721 | 115.428 | 112.504 | 112.793 | 17946.0 |
| 2011-10-10 | HG | Futures | 4.3404 | 4.4873 | 4.3371 | 4.4568 | 38977.0 |
| 2011-10-10 | HO | Futures | 2.2902 | 2.3424 | 2.28 | 2.3278 | 28956.0 |
| 2011-10-10 | HRC | Futures | 2706.8 | 2706.8 | 2706.8 | 2706.8 | 0.0 |
| 2011-10-10 | J1 | Futures | 0.0163712 | 0.0164253 | 0.0163624 | 0.0164001 | 43282.0 |
| 2011-10-10 | J7 | Futures | 0.016287 | 0.016327 | 0.016264 | 0.016301 | 180.0 |
| 2011-10-10 | JB | Futures | 124.43 | 124.49 | 124.36 | 124.4 | 317.0 |
> showing 50 of 95 rows — these rows as CSV