PREVIEW / futures_daily / 2010-10-18
file: by_date/futures_daily/2010/2010-10-18.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-10-18 | ES | Futures | 1150.95 | 1158.8 | 1141.64 | 1154.87 | 1465558.0 |
| 2010-10-18 | NQ | Futures | 2375.5 | 2386.56 | 2361.61 | 2374.94 | 254281.0 |
| 2010-10-18 | YM | Futures | 10245.6 | 10331.3 | 10177.7 | 10277.3 | 101320.0 |
| 2010-10-18 | CL | Futures | 169.47 | 173.08 | 167.02 | 172.77 | 284111.0 |
| 2010-10-18 | GC | Futures | 1863.5 | 1869.8 | 1839.3 | 1865.0 | 134145.0 |
| 2010-10-18 | ZN | Futures | 104.277333 | 104.845109 | 104.277333 | 104.793493 | 865161.0 |
| 2010-10-18 | A6 | Futures | 0.82494 | 0.82913 | 0.81705 | 0.82813 | 85607.0 |
| 2010-10-18 | AD | Futures | 0.97707 | 0.97865 | 0.96726 | 0.97519 | 81558.0 |
| 2010-10-18 | B | Futures | 71.27 | 72.52 | 69.97 | 72.41 | 174269.0 |
| 2010-10-18 | B6 | Futures | 1.6586 | 1.6608 | 1.6434 | 1.6534 | 85364.0 |
| 2010-10-18 | BFX | Futures | 3036.9 | 3050.5 | 3027.3 | 3050.5 | 76.0 |
| 2010-10-18 | BR | Futures | 0.25452 | 0.25492 | 0.25396 | 0.25492 | 47.0 |
| 2010-10-18 | BZ | Futures | 74.8 | 77.07 | 74.8 | 76.99 | 165.0 |
| 2010-10-18 | C | Futures | 2019.0 | 2056.0 | 2017.0 | 2029.0 | 5401.0 |
| 2010-10-18 | CB | Futures | 98.173 | 98.173 | 98.173 | 98.173 | 1.0 |
| 2010-10-18 | CC | Futures | 2317.0 | 2350.0 | 2302.0 | 2313.0 | 7322.0 |
| 2010-10-18 | CT | Futures | 92.4 | 96.3 | 91.41 | 95.96 | 12631.0 |
| 2010-10-18 | DC | Futures | 24.72 | 24.76 | 24.52 | 24.57 | 222.0 |
| 2010-10-18 | DX | Futures | 77.501 | 78.113 | 77.371 | 77.383 | 20058.0 |
| 2010-10-18 | E1 | Futures | 1.37083 | 1.3766 | 1.36045 | 1.37227 | 33302.0 |
| 2010-10-18 | E6 | Futures | 1.65175 | 1.65483 | 1.63508 | 1.65459 | 316840.0 |
| 2010-10-18 | E7 | Futures | 1.6391 | 1.6423 | 1.6228 | 1.642 | 4958.0 |
| 2010-10-18 | ED | Futures | 94.7173 | 94.7221 | 94.6936 | 94.7031 | 306818.0 |
| 2010-10-18 | ER | Futures | 97.232 | 97.232 | 97.188 | 97.198 | 135210.0 |
| 2010-10-18 | EW | Futures | 805.3 | 808.5 | 798.2 | 806.2 | 17123.0 |
| 2010-10-18 | FBTP | Futures | 68.07 | 68.07 | 67.89 | 68.0 | 2823.0 |
| 2010-10-18 | FCE | Futures | 2521.7 | 2552.3 | 2514.0 | 2539.3 | 96184.0 |
| 2010-10-18 | FDAX | Futures | 6965.5 | 7057.4 | 6955.8 | 7019.8 | 119277.0 |
| 2010-10-18 | FESX | Futures | 1761.2 | 1783.7 | 1754.4 | 1773.7 | 798765.0 |
| 2010-10-18 | FEU3 | Futures | 97.79 | 97.79 | 97.761 | 97.761 | 1306.0 |
| 2010-10-18 | FGBL | Futures | 103.35 | 103.39 | 103.09 | 103.24 | 676858.0 |
| 2010-10-18 | FGBM | Futures | 106.52 | 106.58 | 106.31 | 106.4 | 400460.0 |
| 2010-10-18 | FGBS | Futures | 107.479 | 107.509 | 107.361 | 107.401 | 470938.0 |
| 2010-10-18 | FGBX | Futures | 106.05 | 106.21 | 105.5 | 106.01 | 3258.0 |
| 2010-10-18 | FTDX | Futures | 709.5 | 714.3 | 708.6 | 711.3 | 315.0 |
| 2010-10-18 | FTI | Futures | 271.61 | 274.14 | 270.73 | 272.97 | 23260.0 |
| 2010-10-18 | FTUK | Futures | 3927.7 | 3973.3 | 3904.2 | 3957.4 | 79511.0 |
| 2010-10-18 | G | Futures | 84.74 | 84.8 | 84.39 | 84.56 | 81267.0 |
| 2010-10-18 | GF | Futures | 275.446 | 276.579 | 274.124 | 275.823 | 1388.0 |
| 2010-10-18 | GSCI | Futures | 926.29 | 942.14 | 925.79 | 941.15 | 199.0 |
| 2010-10-18 | HE | Futures | 93.306 | 93.34 | 91.479 | 92.054 | 12592.0 |
| 2010-10-18 | HG | Futures | 5.1199 | 5.1786 | 5.0425 | 5.1452 | 30282.0 |
| 2010-10-18 | HO | Futures | 1.8976 | 1.9392 | 1.8806 | 1.9364 | 27582.0 |
| 2010-10-18 | HRC | Futures | 2549.8 | 2549.8 | 2549.8 | 2549.8 | 0.0 |
| 2010-10-18 | J1 | Futures | 0.015435 | 0.0154915 | 0.0154237 | 0.0154752 | 71696.0 |
| 2010-10-18 | J7 | Futures | 0.015322 | 0.015384 | 0.01532 | 0.015369 | 171.0 |
| 2010-10-18 | JB | Futures | 122.58 | 122.66 | 122.39 | 122.52 | 1648.0 |
| 2010-10-18 | KC | Futures | 461.51 | 466.84 | 455.68 | 460.27 | 7978.0 |
| 2010-10-18 | KE | Futures | 3100.89 | 3122.79 | 3049.78 | 3053.95 | 11523.0 |
| 2010-10-18 | L | Futures | 98.145 | 98.165 | 98.135 | 98.135 | 34733.0 |
> showing 50 of 91 rows — these rows as CSV