PREVIEW / futures_daily / 2011-06-06
file: by_date/futures_daily/2011/2011-06-06.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-06-06 | ES | Futures | 1285.78 | 1286.02 | 1270.43 | 1272.16 | 2185300.0 |
| 2011-06-06 | NQ | Futures | 2606.34 | 2618.58 | 2586.69 | 2589.83 | 222242.0 |
| 2011-06-06 | YM | Futures | 11407.2 | 11415.6 | 11335.7 | 11363.9 | 101824.0 |
| 2011-06-06 | CL | Futures | 192.92 | 193.42 | 189.33 | 190.21 | 289670.0 |
| 2011-06-06 | GC | Futures | 2090.4 | 2104.6 | 2086.4 | 2094.0 | 100185.0 |
| 2011-06-06 | ZN | Futures | 105.174576 | 105.266754 | 104.871707 | 105.135071 | 32282.0 |
| 2011-06-06 | A6 | Futures | 0.91908 | 0.92269 | 0.91617 | 0.91763 | 94703.0 |
| 2011-06-06 | AD | Futures | 1.01813 | 1.01932 | 1.01405 | 1.01494 | 78642.0 |
| 2011-06-06 | B | Futures | 98.88 | 98.98 | 97.19 | 97.6 | 70979.0 |
| 2011-06-06 | B6 | Futures | 1.7056 | 1.7099 | 1.6974 | 1.6986 | 83749.0 |
| 2011-06-06 | BFX | Futures | 3107.4 | 3119.6 | 3094.3 | 3098.3 | 130.0 |
| 2011-06-06 | BR | Futures | 0.27751 | 0.27751 | 0.27619 | 0.27671 | 113.0 |
| 2011-06-06 | BZ | Futures | 102.23 | 102.23 | 101.78 | 101.78 | 267.0 |
| 2011-06-06 | C | Futures | 1922.0 | 1951.0 | 1919.0 | 1927.0 | 4733.0 |
| 2011-06-06 | CB | Futures | 115.614 | 115.888 | 115.614 | 115.888 | 9.0 |
| 2011-06-06 | CC | Futures | 2291.0 | 2315.0 | 2277.0 | 2282.0 | 11196.0 |
| 2011-06-06 | CT | Futures | 159.9 | 161.89 | 154.04 | 154.04 | 12340.0 |
| 2011-06-06 | DC | Futures | 31.5 | 31.7 | 31.18 | 31.3 | 400.0 |
| 2011-06-06 | DX | Futures | 73.402 | 73.715 | 73.297 | 73.63 | 33303.0 |
| 2011-06-06 | E1 | Futures | 1.56839 | 1.57232 | 1.56132 | 1.56499 | 28637.0 |
| 2011-06-06 | E6 | Futures | 1.7328 | 1.73623 | 1.72403 | 1.72758 | 235621.0 |
| 2011-06-06 | E7 | Futures | 1.7198 | 1.7233 | 1.7114 | 1.7147 | 3973.0 |
| 2011-06-06 | ED | Futures | 94.9668 | 94.9692 | 94.9644 | 94.9644 | 97311.0 |
| 2011-06-06 | ER | Futures | 97.326 | 97.331 | 97.321 | 97.326 | 68823.0 |
| 2011-06-06 | EW | Futures | 955.6 | 956.1 | 940.2 | 942.0 | 23353.0 |
| 2011-06-06 | FBTP | Futures | 65.83 | 65.85 | 65.61 | 65.66 | 9730.0 |
| 2011-06-06 | FCE | Futures | 2684.6 | 2688.8 | 2657.6 | 2677.0 | 115632.0 |
| 2011-06-06 | FDAX | Futures | 7581.6 | 7612.0 | 7519.7 | 7574.7 | 144983.0 |
| 2011-06-06 | FESX | Futures | 1779.9 | 1782.5 | 1756.2 | 1771.6 | 1085252.0 |
| 2011-06-06 | FEU3 | Futures | 97.87 | 97.87 | 97.865 | 97.87 | 22.0 |
| 2011-06-06 | FGBL | Futures | 100.2 | 100.59 | 100.2 | 100.39 | 910541.0 |
| 2011-06-06 | FGBM | Futures | 104.44 | 104.69 | 104.42 | 104.58 | 707865.0 |
| 2011-06-06 | FGBS | Futures | 106.741 | 106.806 | 106.726 | 106.776 | 1017831.0 |
| 2011-06-06 | FGBX | Futures | 97.27 | 97.27 | 96.19 | 96.52 | 20407.0 |
| 2011-06-06 | FTDX | Futures | 796.7 | 805.1 | 794.0 | 802.5 | 184.0 |
| 2011-06-06 | FTI | Futures | 278.2 | 279.35 | 276.39 | 278.28 | 25366.0 |
| 2011-06-06 | FTUK | Futures | 4094.8 | 4118.6 | 4072.8 | 4104.2 | 93808.0 |
| 2011-06-06 | FXXP | Futures | 182.5 | 182.7 | 181.5 | 181.9 | 1021.0 |
| 2011-06-06 | G | Futures | 84.22 | 84.3 | 84.09 | 84.19 | 69514.0 |
| 2011-06-06 | GF | Futures | 289.167 | 293.757 | 287.831 | 288.412 | 2358.0 |
| 2011-06-06 | GSCI | Futures | 1098.87 | 1098.87 | 1080.55 | 1083.29 | 63.0 |
| 2011-06-06 | HE | Futures | 94.076 | 94.076 | 92.689 | 93.623 | 13545.0 |
| 2011-06-06 | HG | Futures | 5.4717 | 5.5454 | 5.4717 | 5.5029 | 26252.0 |
| 2011-06-06 | HO | Futures | 2.5001 | 2.5001 | 2.4595 | 2.4695 | 11345.0 |
| 2011-06-06 | HRC | Futures | 3118.0 | 3118.0 | 3118.0 | 3118.0 | 0.0 |
| 2011-06-06 | J1 | Futures | 0.0156536 | 0.0157089 | 0.0156272 | 0.0156925 | 77039.0 |
| 2011-06-06 | J7 | Futures | 0.015558 | 0.015618 | 0.01553 | 0.015596 | 158.0 |
| 2011-06-06 | JB | Futures | 122.9 | 123.07 | 122.68 | 122.71 | 6908.0 |
| 2011-06-06 | KC | Futures | 648.3 | 649.25 | 622.28 | 624.67 | 14867.0 |
| 2011-06-06 | KE | Futures | 3610.98 | 3635.67 | 3515.2 | 3515.2 | 16349.0 |
> showing 50 of 95 rows — these rows as CSV