PREVIEW / futures_daily / 2010-11-04
file: by_date/futures_daily/2010/2010-11-04.parquet size: 9 KB rows: 91
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 |
|---|---|---|---|---|---|---|---|
| 2010-11-04 | ES | Futures | 1173.74 | 1194.57 | 1171.54 | 1194.33 | 2301698.0 |
| 2010-11-04 | NQ | Futures | 2454.31 | 2484.36 | 2451.76 | 2476.99 | 324318.0 |
| 2010-11-04 | YM | Futures | 10402.9 | 10603.0 | 10388.0 | 10595.5 | 127295.0 |
| 2010-11-04 | CL | Futures | 175.43 | 179.02 | 175.08 | 178.31 | 317997.0 |
| 2010-11-04 | GC | Futures | 1833.6 | 1894.0 | 1830.5 | 1880.0 | 241404.0 |
| 2010-11-04 | ZN | Futures | 104.896725 | 105.735486 | 104.883821 | 105.503214 | 1676657.0 |
| 2010-11-04 | A6 | Futures | 0.8403 | 0.85028 | 0.83702 | 0.8481 | 85253.0 |
| 2010-11-04 | AD | Futures | 0.98153 | 0.98886 | 0.97905 | 0.98668 | 94523.0 |
| 2010-11-04 | B | Futures | 73.89 | 75.27 | 73.88 | 75.03 | 100810.0 |
| 2010-11-04 | B6 | Futures | 1.6711 | 1.6916 | 1.6694 | 1.6897 | 144779.0 |
| 2010-11-04 | BFX | Futures | 3085.9 | 3097.1 | 3075.9 | 3093.1 | 161.0 |
| 2010-11-04 | BR | Futures | 0.25285 | 0.25413 | 0.25259 | 0.25413 | 25.0 |
| 2010-11-04 | BZ | Futures | 78.86 | 79.37 | 78.81 | 79.37 | 213.0 |
| 2010-11-04 | C | Futures | 1997.0 | 2013.0 | 1982.0 | 1984.0 | 7106.0 |
| 2010-11-04 | CB | Futures | 101.644 | 101.644 | 99.964 | 99.978 | 12.0 |
| 2010-11-04 | CC | Futures | 2288.0 | 2313.0 | 2262.0 | 2271.0 | 9162.0 |
| 2010-11-04 | CSC | Futures | 3.439 | 3.439 | 3.439 | 3.439 | 1.0 |
| 2010-11-04 | CT | Futures | 115.24 | 118.94 | 114.18 | 118.88 | 17161.0 |
| 2010-11-04 | DC | Futures | 23.13 | 23.96 | 23.05 | 23.71 | 950.0 |
| 2010-11-04 | DX | Futures | 76.774 | 76.874 | 76.001 | 76.242 | 26420.0 |
| 2010-11-04 | E1 | Futures | 1.35166 | 1.37266 | 1.34851 | 1.3703 | 48388.0 |
| 2010-11-04 | E6 | Futures | 1.67044 | 1.68866 | 1.66725 | 1.67991 | 410020.0 |
| 2010-11-04 | E7 | Futures | 1.6582 | 1.6757 | 1.6548 | 1.6672 | 6365.0 |
| 2010-11-04 | ED | Futures | 94.7506 | 94.7601 | 94.7506 | 94.7506 | 149117.0 |
| 2010-11-04 | ER | Futures | 97.188 | 97.193 | 97.178 | 97.188 | 73968.0 |
| 2010-11-04 | EW | Futures | 824.8 | 839.6 | 824.0 | 839.0 | 21383.0 |
| 2010-11-04 | FBTP | Futures | 67.07 | 67.14 | 66.7 | 66.96 | 6897.0 |
| 2010-11-04 | FCE | Futures | 2565.6 | 2604.5 | 2564.9 | 2593.8 | 145661.0 |
| 2010-11-04 | FDAX | Futures | 7174.7 | 7277.9 | 7168.8 | 7247.3 | 142688.0 |
| 2010-11-04 | FESX | Futures | 1777.5 | 1802.5 | 1774.4 | 1793.1 | 1387829.0 |
| 2010-11-04 | FEU3 | Futures | 97.751 | 97.756 | 97.746 | 97.751 | 167.0 |
| 2010-11-04 | FGBL | Futures | 102.93 | 103.39 | 102.27 | 103.14 | 1393803.0 |
| 2010-11-04 | FGBM | Futures | 105.99 | 106.52 | 105.71 | 106.3 | 670418.0 |
| 2010-11-04 | FGBS | Futures | 107.233 | 107.386 | 107.184 | 107.327 | 526883.0 |
| 2010-11-04 | FGBX | Futures | 107.21 | 107.53 | 105.54 | 106.86 | 7311.0 |
| 2010-11-04 | FTDX | Futures | 725.8 | 726.2 | 718.3 | 722.2 | 287.0 |
| 2010-11-04 | FTI | Futures | 273.09 | 277.1 | 273.09 | 276.3 | 34545.0 |
| 2010-11-04 | FTUK | Futures | 3987.1 | 4060.7 | 3986.7 | 4039.6 | 130971.0 |
| 2010-11-04 | G | Futures | 84.32 | 84.8 | 83.94 | 84.63 | 149365.0 |
| 2010-11-04 | GF | Futures | 277.837 | 279.285 | 276.201 | 277.271 | 690.0 |
| 2010-11-04 | GSCI | Futures | 971.37 | 979.04 | 969.22 | 975.82 | 488.0 |
| 2010-11-04 | HE | Futures | 90.396 | 92.46 | 90.024 | 91.513 | 18842.0 |
| 2010-11-04 | HG | Futures | 5.1319 | 5.228 | 5.0885 | 5.2213 | 40469.0 |
| 2010-11-04 | HO | Futures | 1.9684 | 2.0074 | 1.9646 | 2.002 | 41649.0 |
| 2010-11-04 | HRC | Futures | 2459.6 | 2459.6 | 2459.6 | 2459.6 | 0.0 |
| 2010-11-04 | J1 | Futures | 0.0154852 | 0.0155933 | 0.0154689 | 0.0155732 | 118730.0 |
| 2010-11-04 | J7 | Futures | 0.015364 | 0.015484 | 0.015364 | 0.015466 | 250.0 |
| 2010-11-04 | JB | Futures | 121.96 | 122.13 | 121.92 | 122.06 | 1744.0 |
| 2010-11-04 | KC | Futures | 489.78 | 518.92 | 489.16 | 510.36 | 20145.0 |
| 2010-11-04 | KE | Futures | 3137.39 | 3230.22 | 3125.92 | 3208.32 | 10382.0 |
> showing 50 of 91 rows — these rows as CSV