PREVIEW / futures_daily / 2013-09-26
file: by_date/futures_daily/2013/2013-09-26.parquet size: 9 KB rows: 101
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 |
|---|---|---|---|---|---|---|---|
| 2013-09-26 | ES | Futures | 1732.42 | 1743.72 | 1731.65 | 1738.58 | 1466733.0 |
| 2013-09-26 | NQ | Futures | 3678.16 | 3715.77 | 3677.87 | 3705.15 | 208824.0 |
| 2013-09-26 | YM | Futures | 15136.9 | 15242.3 | 15131.9 | 15184.6 | 128399.0 |
| 2013-09-26 | CL | Futures | 181.11 | 182.86 | 180.93 | 182.4 | 183778.0 |
| 2013-09-26 | GC | Futures | 1763.1 | 1772.2 | 1744.7 | 1751.2 | 159097.0 |
| 2013-09-26 | ZN | Futures | 114.328737 | 114.42787 | 114.130471 | 114.286252 | 928675.0 |
| 2013-09-26 | A6 | Futures | 0.8799 | 0.88348 | 0.87763 | 0.87933 | 63091.0 |
| 2013-09-26 | AD | Futures | 0.97773 | 0.97885 | 0.97521 | 0.97804 | 38330.0 |
| 2013-09-26 | B | Futures | 106.84 | 107.98 | 106.73 | 107.93 | 118547.0 |
| 2013-09-26 | B6 | Futures | 1.6867 | 1.6886 | 1.6784 | 1.683 | 82162.0 |
| 2013-09-26 | BR | Futures | 0.22637 | 0.22637 | 0.22324 | 0.22357 | 107.0 |
| 2013-09-26 | BZ | Futures | 107.6 | 108.6 | 107.5 | 108.57 | 8230.0 |
| 2013-09-26 | C | Futures | 1781.0 | 1819.0 | 1776.0 | 1814.0 | 8068.0 |
| 2013-09-26 | CB | Futures | 75.294 | 75.294 | 74.754 | 74.814 | 4.0 |
| 2013-09-26 | CC | Futures | 1912.0 | 1946.0 | 1904.0 | 1935.0 | 12075.0 |
| 2013-09-26 | CSC | Futures | 3.247 | 3.259 | 3.247 | 3.259 | 9.0 |
| 2013-09-26 | CT | Futures | 99.47 | 100.4 | 99.3 | 100.27 | 7964.0 |
| 2013-09-26 | DC | Futures | 24.79 | 24.9 | 24.73 | 24.89 | 88.0 |
| 2013-09-26 | DX | Futures | 76.686 | 76.948 | 76.61 | 76.832 | 17852.0 |
| 2013-09-26 | E1 | Futures | 1.41398 | 1.41501 | 1.41025 | 1.41269 | 21255.0 |
| 2013-09-26 | E6 | Futures | 1.59622 | 1.59657 | 1.59008 | 1.59197 | 140716.0 |
| 2013-09-26 | E7 | Futures | 1.586 | 1.5863 | 1.5799 | 1.5817 | 2003.0 |
| 2013-09-26 | ED | Futures | 95.3351 | 95.3351 | 95.3255 | 95.3303 | 86022.0 |
| 2013-09-26 | ER | Futures | 97.842 | 97.847 | 97.832 | 97.842 | 56946.0 |
| 2013-09-26 | EW | Futures | 1263.9 | 1273.9 | 1263.1 | 1271.3 | 18187.0 |
| 2013-09-26 | FBTP | Futures | 79.04 | 79.04 | 78.35 | 78.43 | 52333.0 |
| 2013-09-26 | FBTS | Futures | 93.947 | 93.955 | 93.748 | 93.765 | 6583.0 |
| 2013-09-26 | FCE | Futures | 3240.1 | 3246.3 | 3220.0 | 3233.5 | 81663.0 |
| 2013-09-26 | FDAX | Futures | 9636.4 | 9651.4 | 9575.9 | 9610.3 | 70808.0 |
| 2013-09-26 | FESX | Futures | 2048.8 | 2052.3 | 2032.7 | 2041.1 | 691107.0 |
| 2013-09-26 | FGBL | Futures | 119.08 | 119.29 | 118.96 | 119.1 | 620956.0 |
| 2013-09-26 | FGBM | Futures | 117.43 | 117.52 | 117.35 | 117.45 | 374943.0 |
| 2013-09-26 | FGBS | Futures | 110.388 | 110.403 | 110.363 | 110.388 | 267905.0 |
| 2013-09-26 | FGBX | Futures | 120.45 | 121.15 | 120.27 | 120.82 | 11035.0 |
| 2013-09-26 | FMWO | Futures | 5113.0 | 5113.0 | 5105.4 | 5108.0 | 40.0 |
| 2013-09-26 | FOAT | Futures | 106.58 | 106.78 | 106.5 | 106.6 | 36811.0 |
| 2013-09-26 | FTDX | Futures | 1015.3 | 1017.2 | 1011.5 | 1014.8 | 86.0 |
| 2013-09-26 | FTI | Futures | 328.94 | 329.46 | 326.65 | 327.38 | 22188.0 |
| 2013-09-26 | FTUK | Futures | 4887.4 | 4916.7 | 4878.8 | 4898.3 | 59184.0 |
| 2013-09-26 | FVSA | Futures | 2321.39 | 2386.6 | 2321.39 | 2347.47 | 2632.0 |
| 2013-09-26 | FXXP | Futures | 228.1 | 228.5 | 227.1 | 227.7 | 2112.0 |
| 2013-09-26 | G | Futures | 92.14 | 92.52 | 92.03 | 92.26 | 178094.0 |
| 2013-09-26 | GF | Futures | 266.052 | 268.172 | 265.889 | 267.968 | 2201.0 |
| 2013-09-26 | GSCI | Futures | 1065.32 | 1067.75 | 1062.22 | 1066.99 | 58.0 |
| 2013-09-26 | HE | Futures | 111.952 | 112.016 | 110.244 | 111.035 | 18983.0 |
| 2013-09-26 | HG | Futures | 4.1411 | 4.2089 | 4.1291 | 4.1873 | 42726.0 |
| 2013-09-26 | HH | Futures | 37.481 | 38.164 | 37.097 | 38.079 | 1464.0 |
| 2013-09-26 | HO | Futures | 2.3729 | 2.3993 | 2.3688 | 2.3973 | 16388.0 |
| 2013-09-26 | HRC | Futures | 2277.5 | 2277.5 | 2277.5 | 2277.5 | 88.0 |
| 2013-09-26 | J1 | Futures | 0.0127867 | 0.0128094 | 0.0126961 | 0.0127414 | 135013.0 |
> showing 50 of 101 rows — these rows as CSV