PREVIEW / futures_daily / 2011-10-19
file: by_date/futures_daily/2011/2011-10-19.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-19 | ES | Futures | 1220.61 | 1225.1 | 1199.39 | 1204.38 | 2430802.0 |
| 2011-10-19 | NQ | Futures | 2699.83 | 2703.25 | 2631.91 | 2645.9 | 332866.0 |
| 2011-10-19 | YM | Futures | 11071.6 | 11116.8 | 10956.3 | 10993.8 | 138389.0 |
| 2011-10-19 | CL | Futures | 166.08 | 168.26 | 161.39 | 161.88 | 366337.0 |
| 2011-10-19 | GC | Futures | 2236.4 | 2250.6 | 2215.7 | 2223.7 | 118146.0 |
| 2011-10-19 | ZN | Futures | 110.329532 | 110.745161 | 110.101606 | 110.557458 | 1144371.0 |
| 2011-10-19 | A6 | Futures | 0.89591 | 0.90374 | 0.89072 | 0.8924 | 125557.0 |
| 2011-10-19 | AD | Futures | 0.98434 | 0.99065 | 0.97784 | 0.98014 | 83747.0 |
| 2011-10-19 | B | Futures | 97.11 | 97.79 | 94.53 | 94.76 | 242727.0 |
| 2011-10-19 | B6 | Futures | 1.6387 | 1.6539 | 1.6376 | 1.6441 | 105209.0 |
| 2011-10-19 | BFX | Futures | 2579.4 | 2579.4 | 2558.5 | 2562.8 | 519.0 |
| 2011-10-19 | BR | Futures | 0.25259 | 0.25259 | 0.25259 | 0.25259 | 227.0 |
| 2011-10-19 | BZ | Futures | 102.84 | 103.34 | 99.92 | 100.15 | 1933.0 |
| 2011-10-19 | C | Futures | 1789.0 | 1796.0 | 1765.0 | 1786.0 | 5585.0 |
| 2011-10-19 | CB | Futures | 95.341 | 95.888 | 95.341 | 95.888 | 10.0 |
| 2011-10-19 | CC | Futures | 2039.0 | 2076.0 | 2018.0 | 2041.0 | 8179.0 |
| 2011-10-19 | CSC | Futures | 4.02 | 4.02 | 4.012 | 4.012 | 47.0 |
| 2011-10-19 | CT | Futures | 129.37 | 130.75 | 128.41 | 128.56 | 7705.0 |
| 2011-10-19 | DC | Futures | 29.02 | 29.12 | 28.21 | 28.28 | 235.0 |
| 2011-10-19 | DX | Futures | 76.034 | 76.073 | 75.41 | 76.0 | 30270.0 |
| 2011-10-19 | E1 | Futures | 1.46029 | 1.46737 | 1.4532 | 1.45451 | 24230.0 |
| 2011-10-19 | E6 | Futures | 1.64067 | 1.6568 | 1.63947 | 1.6421 | 291119.0 |
| 2011-10-19 | E7 | Futures | 1.6276 | 1.6428 | 1.6256 | 1.6281 | 5647.0 |
| 2011-10-19 | ED | Futures | 94.965 | 94.9841 | 94.9602 | 94.965 | 139132.0 |
| 2011-10-19 | ER | Futures | 97.184 | 97.199 | 97.159 | 97.179 | 142271.0 |
| 2011-10-19 | EW | Futures | 852.8 | 856.7 | 836.7 | 842.4 | 30173.0 |
| 2011-10-19 | FBTP | Futures | 61.52 | 61.61 | 61.22 | 61.41 | 7121.0 |
| 2011-10-19 | FBTS | Futures | 81.679 | 81.831 | 81.622 | 81.711 | 1065.0 |
| 2011-10-19 | FCE | Futures | 2278.3 | 2282.9 | 2236.6 | 2263.5 | 132549.0 |
| 2011-10-19 | FDAX | Futures | 6460.6 | 6502.4 | 6345.5 | 6426.9 | 159780.0 |
| 2011-10-19 | FESX | Futures | 1545.8 | 1555.1 | 1524.5 | 1543.1 | 1161727.0 |
| 2011-10-19 | FEU3 | Futures | 97.742 | 97.742 | 97.732 | 97.737 | 78.0 |
| 2011-10-19 | FGBL | Futures | 109.32 | 109.59 | 108.67 | 109.3 | 954403.0 |
| 2011-10-19 | FGBM | Futures | 110.38 | 110.54 | 110.04 | 110.33 | 443749.0 |
| 2011-10-19 | FGBS | Futures | 108.925 | 108.974 | 108.825 | 108.885 | 523922.0 |
| 2011-10-19 | FGBX | Futures | 110.2 | 110.77 | 108.95 | 109.85 | 6806.0 |
| 2011-10-19 | FTDX | Futures | 625.6 | 633.4 | 613.6 | 632.0 | 171.0 |
| 2011-10-19 | FTI | Futures | 248.87 | 250.86 | 245.9 | 248.75 | 18520.0 |
| 2011-10-19 | FTUK | Futures | 3907.8 | 3920.0 | 3841.4 | 3888.4 | 108826.0 |
| 2011-10-19 | FVSA | Futures | 15668.07 | 15897.26 | 15313.88 | 15751.42 | 1647.0 |
| 2011-10-19 | FXXP | Futures | 164.4 | 165.3 | 163.9 | 164.5 | 6307.0 |
| 2011-10-19 | G | Futures | 90.81 | 91.01 | 90.28 | 90.7 | 119593.0 |
| 2011-10-19 | GF | Futures | 317.904 | 319.232 | 314.971 | 315.691 | 2180.0 |
| 2011-10-19 | GSCI | Futures | 999.36 | 1006.33 | 977.42 | 980.94 | 204.0 |
| 2011-10-19 | HE | Futures | 117.003 | 117.42 | 115.589 | 115.781 | 19102.0 |
| 2011-10-19 | HG | Futures | 4.4648 | 4.4694 | 4.2424 | 4.3113 | 50167.0 |
| 2011-10-19 | HO | Futures | 2.4378 | 2.4578 | 2.391 | 2.3936 | 52096.0 |
| 2011-10-19 | HRC | Futures | 2706.8 | 2706.8 | 2706.8 | 2706.8 | 10.0 |
| 2011-10-19 | J1 | Futures | 0.0163738 | 0.0164039 | 0.0163587 | 0.0163763 | 57669.0 |
| 2011-10-19 | J7 | Futures | 0.016274 | 0.016303 | 0.016261 | 0.016277 | 338.0 |
> showing 50 of 95 rows — these rows as CSV