PREVIEW / futures_daily / 2010-09-01
file: by_date/futures_daily/2010/2010-09-01.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-09-01 | ES | Futures | 1025.83 | 1055.82 | 1024.85 | 1055.09 | 2355074.0 |
| 2010-09-01 | NQ | Futures | 2007.01 | 2065.58 | 2003.9 | 2059.92 | 389294.0 |
| 2010-09-01 | YM | Futures | 9277.3 | 9504.8 | 9264.4 | 9497.4 | 154684.0 |
| 2010-09-01 | CL | Futures | 151.25 | 157.11 | 151.18 | 155.91 | 396607.0 |
| 2010-09-01 | GC | Futures | 1699.5 | 1708.0 | 1691.1 | 1696.5 | 109812.0 |
| 2010-09-01 | ZN | Futures | 103.679545 | 103.679545 | 102.731881 | 103.052038 | 213030.0 |
| 2010-09-01 | A6 | Futures | 0.7385 | 0.75458 | 0.73767 | 0.75193 | 117091.0 |
| 2010-09-01 | AD | Futures | 0.92722 | 0.94184 | 0.92693 | 0.93839 | 109362.0 |
| 2010-09-01 | B | Futures | 64.47 | 66.52 | 64.46 | 66.16 | 72952.0 |
| 2010-09-01 | B6 | Futures | 1.5926 | 1.6076 | 1.5913 | 1.6027 | 126638.0 |
| 2010-09-01 | BFX | Futures | 2811.0 | 2888.2 | 2801.8 | 2885.3 | 245.0 |
| 2010-09-01 | BR | Futures | 0.2411 | 0.2411 | 0.2411 | 0.2411 | 57.0 |
| 2010-09-01 | BZ | Futures | 70.22 | 70.22 | 70.22 | 70.22 | 115.0 |
| 2010-09-01 | C | Futures | 2122.0 | 2137.0 | 2073.0 | 2100.0 | 4403.0 |
| 2010-09-01 | CB | Futures | 95.535 | 95.951 | 95.257 | 95.951 | 4.0 |
| 2010-09-01 | CC | Futures | 2267.0 | 2290.0 | 2241.0 | 2278.0 | 8213.0 |
| 2010-09-01 | CT | Futures | 74.94 | 76.33 | 74.87 | 75.82 | 31.0 |
| 2010-09-01 | DC | Futures | 24.42 | 24.51 | 24.34 | 24.47 | 131.0 |
| 2010-09-01 | DX | Futures | 83.839 | 83.924 | 82.876 | 83.203 | 23535.0 |
| 2010-09-01 | E1 | Futures | 1.29454 | 1.30505 | 1.28982 | 1.29244 | 48539.0 |
| 2010-09-01 | E6 | Futures | 1.50035 | 1.52021 | 1.49727 | 1.51312 | 313070.0 |
| 2010-09-01 | E7 | Futures | 1.4894 | 1.5093 | 1.4866 | 1.5022 | 4153.0 |
| 2010-09-01 | ED | Futures | 94.608 | 94.6175 | 94.608 | 94.6104 | 122523.0 |
| 2010-09-01 | ER | Futures | 97.326 | 97.326 | 97.316 | 97.326 | 58925.0 |
| 2010-09-01 | EW | Futures | 708.9 | 730.8 | 708.2 | 729.5 | 32627.0 |
| 2010-09-01 | FBTP | Futures | 67.24 | 67.6 | 67.24 | 67.46 | 4902.0 |
| 2010-09-01 | FCE | Futures | 2304.6 | 2393.0 | 2294.4 | 2390.7 | 173175.0 |
| 2010-09-01 | FDAX | Futures | 6453.3 | 6623.6 | 6392.4 | 6610.0 | 187157.0 |
| 2010-09-01 | FESX | Futures | 1626.6 | 1682.9 | 1615.4 | 1678.6 | 1677161.0 |
| 2010-09-01 | FEU3 | Futures | 97.879 | 97.884 | 97.874 | 97.884 | 212.0 |
| 2010-09-01 | FGBL | Futures | 104.75 | 104.94 | 103.89 | 104.05 | 1492844.0 |
| 2010-09-01 | FGBM | Futures | 106.96 | 107.1 | 106.54 | 106.69 | 706954.0 |
| 2010-09-01 | FGBS | Futures | 107.883 | 107.942 | 107.804 | 107.849 | 649241.0 |
| 2010-09-01 | FGBX | Futures | 111.76 | 111.76 | 109.14 | 109.46 | 12694.0 |
| 2010-09-01 | FTDX | Futures | 655.3 | 670.8 | 650.5 | 670.3 | 748.0 |
| 2010-09-01 | FTI | Futures | 253.1 | 260.45 | 252.03 | 260.01 | 45357.0 |
| 2010-09-01 | FTUK | Futures | 3608.0 | 3694.1 | 3592.2 | 3687.9 | 132314.0 |
| 2010-09-01 | G | Futures | 85.02 | 85.14 | 84.32 | 84.45 | 157284.0 |
| 2010-09-01 | GF | Futures | 288.806 | 289.817 | 287.289 | 287.858 | 899.0 |
| 2010-09-01 | GSCI | Futures | 855.47 | 867.52 | 854.28 | 863.96 | 422.0 |
| 2010-09-01 | HE | Futures | 98.734 | 99.096 | 97.614 | 98.734 | 15086.0 |
| 2010-09-01 | HG | Futures | 4.5119 | 4.6527 | 4.5026 | 4.6414 | 31264.0 |
| 2010-09-01 | HH | Futures | 35.15 | 35.234 | 35.15 | 35.178 | 5.0 |
| 2010-09-01 | HO | Futures | 1.7227 | 1.7737 | 1.7219 | 1.7607 | 17459.0 |
| 2010-09-01 | HRC | Futures | 2694.0 | 2730.7 | 2694.0 | 2730.7 | 10.0 |
| 2010-09-01 | J1 | Futures | 0.0149501 | 0.0150407 | 0.0148595 | 0.0148947 | 166661.0 |
| 2010-09-01 | J7 | Futures | 0.014836 | 0.014925 | 0.01475 | 0.014783 | 611.0 |
| 2010-09-01 | JB | Futures | 121.68 | 121.75 | 121.21 | 121.35 | 4433.0 |
| 2010-09-01 | KC | Futures | 445.51 | 456.8 | 444.65 | 452.21 | 8781.0 |
| 2010-09-01 | KE | Futures | 2947.56 | 3037.26 | 2944.43 | 3032.05 | 16641.0 |
> showing 50 of 91 rows — these rows as CSV