PREVIEW / futures_daily / 2010-11-18
file: by_date/futures_daily/2010/2010-11-18.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-11-18 | ES | Futures | 1154.38 | 1175.21 | 1153.65 | 1173.99 | 2067180.0 |
| 2010-11-18 | NQ | Futures | 2378.34 | 2434.18 | 2376.36 | 2420.01 | 299550.0 |
| 2010-11-18 | YM | Futures | 10228.0 | 10402.9 | 10227.0 | 10399.2 | 108413.0 |
| 2010-11-18 | CL | Futures | 166.41 | 170.31 | 166.17 | 169.25 | 369365.0 |
| 2010-11-18 | GC | Futures | 1816.0 | 1847.2 | 1813.2 | 1839.1 | 197603.0 |
| 2010-11-18 | ZN | Futures | 103.064355 | 103.128875 | 102.444963 | 102.806275 | 1281475.0 |
| 2010-11-18 | A6 | Futures | 0.82066 | 0.82905 | 0.8199 | 0.82804 | 76168.0 |
| 2010-11-18 | AD | Futures | 0.96686 | 0.97509 | 0.96647 | 0.96944 | 83463.0 |
| 2010-11-18 | B | Futures | 71.04 | 72.74 | 71.04 | 72.35 | 174653.0 |
| 2010-11-18 | B6 | Futures | 1.651 | 1.6666 | 1.6492 | 1.6653 | 105433.0 |
| 2010-11-18 | BFX | Futures | 3050.5 | 3077.1 | 3050.5 | 3076.7 | 1957.0 |
| 2010-11-18 | BR | Futures | 0.24901 | 0.24901 | 0.24901 | 0.24901 | 51.0 |
| 2010-11-18 | BZ | Futures | 76.31 | 76.89 | 75.92 | 76.53 | 428.0 |
| 2010-11-18 | C | Futures | 2054.0 | 2116.0 | 2051.0 | 2112.0 | 6305.0 |
| 2010-11-18 | CB | Futures | 94.979 | 94.979 | 94.965 | 94.965 | 8.0 |
| 2010-11-18 | CC | Futures | 2317.0 | 2393.0 | 2317.0 | 2385.0 | 14929.0 |
| 2010-11-18 | CSC | Futures | 3.427 | 3.427 | 3.427 | 3.427 | 1.0 |
| 2010-11-18 | CT | Futures | 109.1 | 113.34 | 108.77 | 113.34 | 4260.0 |
| 2010-11-18 | DC | Futures | 22.98 | 23.31 | 22.95 | 23.21 | 447.0 |
| 2010-11-18 | DX | Futures | 79.287 | 79.372 | 78.78 | 78.98 | 20079.0 |
| 2010-11-18 | E1 | Futures | 1.32461 | 1.33249 | 1.31319 | 1.31765 | 44316.0 |
| 2010-11-18 | E6 | Futures | 1.59994 | 1.61686 | 1.59994 | 1.61225 | 329522.0 |
| 2010-11-18 | E7 | Futures | 1.588 | 1.6045 | 1.5878 | 1.6 | 5169.0 |
| 2010-11-18 | ED | Futures | 94.7458 | 94.7577 | 94.7435 | 94.753 | 140549.0 |
| 2010-11-18 | ER | Futures | 97.232 | 97.247 | 97.232 | 97.242 | 143040.0 |
| 2010-11-18 | EW | Futures | 819.7 | 837.0 | 819.4 | 832.7 | 20646.0 |
| 2010-11-18 | FBTP | Futures | 65.66 | 65.72 | 65.31 | 65.42 | 7594.0 |
| 2010-11-18 | FCE | Futures | 2557.2 | 2593.7 | 2557.2 | 2586.0 | 101743.0 |
| 2010-11-18 | FDAX | Futures | 7271.5 | 7362.4 | 7270.4 | 7345.7 | 149681.0 |
| 2010-11-18 | FESX | Futures | 1763.1 | 1785.6 | 1761.9 | 1780.0 | 1285751.0 |
| 2010-11-18 | FEU3 | Futures | 97.805 | 97.81 | 97.8 | 97.805 | 2064.0 |
| 2010-11-18 | FGBL | Futures | 101.27 | 101.35 | 100.67 | 100.82 | 1268559.0 |
| 2010-11-18 | FGBM | Futures | 105.41 | 105.47 | 105.02 | 105.14 | 720884.0 |
| 2010-11-18 | FGBS | Futures | 107.213 | 107.253 | 107.105 | 107.149 | 599510.0 |
| 2010-11-18 | FGBX | Futures | 102.84 | 102.93 | 101.17 | 101.66 | 5242.0 |
| 2010-11-18 | FTDX | Futures | 690.6 | 702.5 | 690.6 | 701.6 | 970.0 |
| 2010-11-18 | FTI | Futures | 276.81 | 279.23 | 276.33 | 278.5 | 29997.0 |
| 2010-11-18 | FTUK | Futures | 3937.3 | 3998.2 | 3937.3 | 3981.9 | 98053.0 |
| 2010-11-18 | G | Futures | 82.38 | 82.53 | 81.73 | 81.94 | 171591.0 |
| 2010-11-18 | GF | Futures | 286.224 | 289.836 | 285.726 | 289.089 | 2530.0 |
| 2010-11-18 | GSCI | Futures | 923.21 | 931.75 | 923.21 | 929.72 | 383.0 |
| 2010-11-18 | HE | Futures | 93.15 | 95.313 | 92.962 | 95.062 | 11030.0 |
| 2010-11-18 | HG | Futures | 4.9777 | 5.1343 | 4.9577 | 5.1157 | 11515.0 |
| 2010-11-18 | HO | Futures | 1.9383 | 1.9534 | 1.9363 | 1.9467 | 4972.0 |
| 2010-11-18 | HRC | Futures | 2391.9 | 2391.9 | 2391.9 | 2391.9 | 0.0 |
| 2010-11-18 | J1 | Futures | 0.0151034 | 0.0151185 | 0.0149929 | 0.0150544 | 125121.0 |
| 2010-11-18 | J7 | Futures | 0.014984 | 0.015012 | 0.014892 | 0.014951 | 222.0 |
| 2010-11-18 | JB | Futures | 120.85 | 120.96 | 120.3 | 120.33 | 4307.0 |
| 2010-11-18 | KC | Futures | 495.98 | 520.41 | 495.98 | 517.43 | 5655.0 |
| 2010-11-18 | KE | Futures | 2904.8 | 3003.89 | 2904.8 | 2963.21 | 8616.0 |
> showing 50 of 92 rows — these rows as CSV