PREVIEW / futures_daily / 2010-10-26
file: by_date/futures_daily/2010/2010-10-26.parquet size: 9 KB rows: 92
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-10-26 | ES | Futures | 1158.55 | 1160.76 | 1150.71 | 1159.29 | 1743843.0 |
| 2010-10-26 | NQ | Futures | 2391.66 | 2406.12 | 2372.67 | 2399.32 | 255462.0 |
| 2010-10-26 | YM | Futures | 10338.7 | 10361.0 | 10269.8 | 10350.8 | 100721.0 |
| 2010-10-26 | CL | Futures | 170.03 | 170.87 | 168.67 | 170.19 | 265930.0 |
| 2010-10-26 | GC | Futures | 1821.8 | 1826.6 | 1805.2 | 1819.5 | 156544.0 |
| 2010-10-26 | ZN | Futures | 104.316045 | 104.419277 | 103.748268 | 103.825692 | 1367643.0 |
| 2010-10-26 | A6 | Futures | 0.82594 | 0.82829 | 0.81889 | 0.82074 | 85583.0 |
| 2010-10-26 | AD | Futures | 0.97013 | 0.97192 | 0.96369 | 0.96597 | 70464.0 |
| 2010-10-26 | B | Futures | 71.16 | 71.65 | 70.87 | 71.47 | 56099.0 |
| 2010-10-26 | B6 | Futures | 1.6318 | 1.6497 | 1.6281 | 1.643 | 158375.0 |
| 2010-10-26 | BFX | Futures | 3075.7 | 3084.8 | 3067.4 | 3078.2 | 132.0 |
| 2010-10-26 | BR | Futures | 0.24922 | 0.24965 | 0.24875 | 0.24939 | 38.0 |
| 2010-10-26 | BZ | Futures | 75.6 | 75.6 | 75.6 | 75.6 | 234.0 |
| 2010-10-26 | C | Futures | 2133.0 | 2137.0 | 2086.0 | 2096.0 | 6845.0 |
| 2010-10-26 | CB | Futures | 104.422 | 104.838 | 104.422 | 104.838 | 8.0 |
| 2010-10-26 | CC | Futures | 2420.0 | 2438.0 | 2385.0 | 2392.0 | 9999.0 |
| 2010-10-26 | CSC | Futures | 3.633 | 3.633 | 3.633 | 3.633 | 4.0 |
| 2010-10-26 | CT | Futures | 107.6 | 110.46 | 104.55 | 109.69 | 25782.0 |
| 2010-10-26 | DC | Futures | 24.71 | 24.77 | 24.56 | 24.71 | 192.0 |
| 2010-10-26 | DX | Futures | 77.757 | 78.289 | 77.486 | 78.158 | 23428.0 |
| 2010-10-26 | E1 | Futures | 1.35218 | 1.35349 | 1.32894 | 1.33223 | 51152.0 |
| 2010-10-26 | E6 | Futures | 1.64986 | 1.65294 | 1.63437 | 1.63709 | 340318.0 |
| 2010-10-26 | E7 | Futures | 1.6371 | 1.6404 | 1.6218 | 1.6247 | 4921.0 |
| 2010-10-26 | ED | Futures | 94.7363 | 94.7363 | 94.7221 | 94.7268 | 224352.0 |
| 2010-10-26 | ER | Futures | 97.168 | 97.173 | 97.134 | 97.154 | 136205.0 |
| 2010-10-26 | EW | Futures | 813.4 | 817.6 | 805.1 | 812.0 | 22995.0 |
| 2010-10-26 | FBTP | Futures | 67.75 | 67.83 | 67.57 | 67.62 | 3078.0 |
| 2010-10-26 | FCE | Futures | 2559.2 | 2560.9 | 2528.0 | 2549.3 | 121490.0 |
| 2010-10-26 | FDAX | Futures | 7152.1 | 7159.1 | 7086.0 | 7134.4 | 126350.0 |
| 2010-10-26 | FESX | Futures | 1783.1 | 1786.2 | 1764.4 | 1778.1 | 1058812.0 |
| 2010-10-26 | FEU3 | Futures | 97.726 | 97.726 | 97.706 | 97.716 | 18.0 |
| 2010-10-26 | FGBL | Futures | 102.6 | 102.63 | 102.16 | 102.29 | 857082.0 |
| 2010-10-26 | FGBM | Futures | 105.79 | 105.82 | 105.46 | 105.58 | 461338.0 |
| 2010-10-26 | FGBS | Futures | 107.223 | 107.253 | 107.105 | 107.159 | 527518.0 |
| 2010-10-26 | FGBX | Futures | 106.07 | 106.17 | 105.32 | 105.79 | 2854.0 |
| 2010-10-26 | FTDX | Futures | 717.0 | 721.4 | 713.0 | 718.3 | 478.0 |
| 2010-10-26 | FTI | Futures | 273.09 | 273.37 | 270.45 | 272.09 | 27973.0 |
| 2010-10-26 | FTUK | Futures | 3957.4 | 3959.4 | 3909.0 | 3935.3 | 104592.0 |
| 2010-10-26 | G | Futures | 84.7 | 84.7 | 83.83 | 83.92 | 175023.0 |
| 2010-10-26 | GF | Futures | 281.74 | 282.369 | 280.859 | 281.614 | 958.0 |
| 2010-10-26 | GSCI | Futures | 930.58 | 937.43 | 929.1 | 934.55 | 96.0 |
| 2010-10-26 | HE | Futures | 92.866 | 94.185 | 92.663 | 92.934 | 13374.0 |
| 2010-10-26 | HG | Futures | 5.1466 | 5.1959 | 5.1245 | 5.1639 | 29644.0 |
| 2010-10-26 | HO | Futures | 1.9186 | 1.9243 | 1.9048 | 1.9137 | 42098.0 |
| 2010-10-26 | HRC | Futures | 2504.7 | 2504.7 | 2504.7 | 2504.7 | 0.0 |
| 2010-10-26 | J1 | Futures | 0.0155518 | 0.015587 | 0.0153885 | 0.0154124 | 113222.0 |
| 2010-10-26 | J7 | Futures | 0.015449 | 0.015478 | 0.015284 | 0.015307 | 316.0 |
| 2010-10-26 | JB | Futures | 122.3 | 122.3 | 122.12 | 122.12 | 920.0 |
| 2010-10-26 | KC | Futures | 496.85 | 507.39 | 493.75 | 500.32 | 12182.0 |
| 2010-10-26 | KE | Futures | 3012.23 | 3109.23 | 2999.71 | 3081.07 | 11948.0 |
> showing 50 of 92 rows — these rows as CSV