PREVIEW / futures_daily / 2011-11-17
file: by_date/futures_daily/2011/2011-11-17.parquet size: 9 KB rows: 97
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 |
|---|---|---|---|---|---|---|---|
| 2011-11-17 | ES | Futures | 1229.09 | 1239.57 | 1204.38 | 1212.62 | 3096973.0 |
| 2011-11-17 | NQ | Futures | 2641.62 | 2662.73 | 2575.13 | 2589.11 | 369831.0 |
| 2011-11-17 | YM | Futures | 11382.9 | 11461.6 | 11185.0 | 11277.2 | 175347.0 |
| 2011-11-17 | CL | Futures | 190.73 | 193.79 | 184.36 | 185.46 | 420238.0 |
| 2011-11-17 | GC | Futures | 2382.6 | 2387.1 | 2310.1 | 2322.5 | 229938.0 |
| 2011-11-17 | ZN | Futures | 112.152939 | 112.380865 | 111.777532 | 112.260198 | 1277088.0 |
| 2011-11-17 | A6 | Futures | 0.88281 | 0.88668 | 0.87393 | 0.87481 | 145525.0 |
| 2011-11-17 | AD | Futures | 0.97644 | 0.97944 | 0.97114 | 0.97244 | 81618.0 |
| 2011-11-17 | B | Futures | 98.12 | 99.12 | 95.21 | 95.79 | 260238.0 |
| 2011-11-17 | B6 | Futures | 1.641 | 1.6501 | 1.6371 | 1.6439 | 91834.0 |
| 2011-11-17 | BFX | Futures | 2454.0 | 2454.0 | 2429.6 | 2429.6 | 210.0 |
| 2011-11-17 | BR | Futures | 0.25372 | 0.25449 | 0.25171 | 0.25277 | 106.0 |
| 2011-11-17 | BZ | Futures | 101.69 | 102.99 | 100.78 | 101.15 | 1291.0 |
| 2011-11-17 | C | Futures | 1671.0 | 1671.0 | 1649.0 | 1669.0 | 2486.0 |
| 2011-11-17 | CB | Futures | 93.135 | 93.135 | 92.053 | 92.053 | 7.0 |
| 2011-11-17 | CC | Futures | 1965.0 | 1969.0 | 1930.0 | 1942.0 | 12781.0 |
| 2011-11-17 | CT | Futures | 132.87 | 134.03 | 128.28 | 128.28 | 5166.0 |
| 2011-11-17 | DC | Futures | 31.96 | 32.05 | 30.68 | 30.68 | 759.0 |
| 2011-11-17 | DX | Futures | 77.143 | 77.251 | 76.706 | 77.054 | 23027.0 |
| 2011-11-17 | E1 | Futures | 1.42683 | 1.4343 | 1.42105 | 1.42669 | 26321.0 |
| 2011-11-17 | E6 | Futures | 1.6084 | 1.61832 | 1.60397 | 1.60923 | 324009.0 |
| 2011-11-17 | E7 | Futures | 1.5945 | 1.6044 | 1.5905 | 1.5955 | 5729.0 |
| 2011-11-17 | ED | Futures | 94.8504 | 94.8671 | 94.8027 | 94.8099 | 436533.0 |
| 2011-11-17 | ER | Futures | 97.253 | 97.258 | 97.179 | 97.194 | 313119.0 |
| 2011-11-17 | EW | Futures | 878.5 | 886.1 | 860.0 | 863.0 | 30340.0 |
| 2011-11-17 | FBTP | Futures | 55.91 | 56.86 | 55.18 | 56.75 | 13786.0 |
| 2011-11-17 | FBTS | Futures | 77.866 | 78.773 | 77.778 | 78.677 | 1164.0 |
| 2011-11-17 | FCE | Futures | 2173.1 | 2187.8 | 2116.7 | 2146.4 | 62333.0 |
| 2011-11-17 | FDAX | Futures | 6373.7 | 6435.6 | 6254.3 | 6350.9 | 212335.0 |
| 2011-11-17 | FESX | Futures | 1495.2 | 1509.9 | 1462.7 | 1489.2 | 1479560.0 |
| 2011-11-17 | FEU3 | Futures | 97.776 | 97.776 | 97.752 | 97.752 | 292.0 |
| 2011-11-17 | FGBL | Futures | 111.84 | 112.29 | 111.0 | 111.1 | 933174.0 |
| 2011-11-17 | FGBM | Futures | 111.97 | 112.2 | 111.46 | 111.57 | 513927.0 |
| 2011-11-17 | FGBS | Futures | 109.442 | 109.506 | 109.278 | 109.337 | 659765.0 |
| 2011-11-17 | FGBX | Futures | 116.17 | 117.03 | 114.51 | 114.82 | 7936.0 |
| 2011-11-17 | FTDX | Futures | 633.0 | 633.0 | 615.0 | 623.8 | 200.0 |
| 2011-11-17 | FTI | Futures | 245.89 | 247.45 | 240.43 | 243.79 | 24393.0 |
| 2011-11-17 | FTUK | Futures | 3903.9 | 3947.3 | 3830.7 | 3884.8 | 145488.0 |
| 2011-11-17 | FVSA | Futures | 16023.45 | 16259.09 | 15873.49 | 16237.66 | 2326.0 |
| 2011-11-17 | FXXP | Futures | 164.9 | 164.9 | 160.8 | 162.9 | 3830.0 |
| 2011-11-17 | G | Futures | 93.02 | 93.31 | 92.39 | 92.43 | 134699.0 |
| 2011-11-17 | GF | Futures | 320.257 | 323.004 | 317.295 | 322.196 | 3521.0 |
| 2011-11-17 | GSCI | Futures | 1041.92 | 1041.92 | 1009.83 | 1010.6 | 179.0 |
| 2011-11-17 | HE | Futures | 109.965 | 111.845 | 109.626 | 111.475 | 15339.0 |
| 2011-11-17 | HG | Futures | 4.5878 | 4.6209 | 4.4423 | 4.476 | 52912.0 |
| 2011-11-17 | HO | Futures | 2.5178 | 2.5214 | 2.4757 | 2.4815 | 19081.0 |
| 2011-11-17 | HRC | Futures | 2664.5 | 2664.5 | 2664.5 | 2664.5 | 0.0 |
| 2011-11-17 | J1 | Futures | 0.0163185 | 0.0163461 | 0.0163072 | 0.0163373 | 53534.0 |
| 2011-11-17 | J7 | Futures | 0.016212 | 0.016246 | 0.016212 | 0.016238 | 200.0 |
| 2011-11-17 | JB | Futures | 124.82 | 124.94 | 124.65 | 124.86 | 2383.0 |
> showing 50 of 97 rows — these rows as CSV