PREVIEW / futures_daily / 2011-05-17
file: by_date/futures_daily/2011/2011-05-17.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 |
|---|---|---|---|---|---|---|---|
| 2011-05-17 | ES | Futures | 1312.01 | 1318.69 | 1302.85 | 1312.26 | 2292146.0 |
| 2011-05-17 | NQ | Futures | 2657.88 | 2671.83 | 2640.22 | 2661.86 | 338037.0 |
| 2011-05-17 | YM | Futures | 11758.8 | 11810.5 | 11611.2 | 11693.0 | 154936.0 |
| 2011-05-17 | CL | Futures | 187.46 | 188.9 | 183.54 | 187.17 | 242871.0 |
| 2011-05-17 | GC | Futures | 2016.7 | 2026.9 | 1991.1 | 2003.2 | 190079.0 |
| 2011-05-17 | ZN | Futures | 103.475876 | 103.805081 | 103.291521 | 103.607558 | 1300709.0 |
| 2011-05-17 | A6 | Futures | 0.90339 | 0.90871 | 0.89773 | 0.90759 | 120776.0 |
| 2011-05-17 | AD | Futures | 1.02072 | 1.024 | 1.01604 | 1.02291 | 85242.0 |
| 2011-05-17 | B | Futures | 93.71 | 94.9 | 91.71 | 93.34 | 220392.0 |
| 2011-05-17 | B6 | Futures | 1.6828 | 1.6933 | 1.6798 | 1.6875 | 127018.0 |
| 2011-05-17 | BFX | Futures | 3207.6 | 3210.2 | 3180.1 | 3180.1 | 1388.0 |
| 2011-05-17 | BR | Futures | 0.26781 | 0.26882 | 0.26706 | 0.26882 | 41.0 |
| 2011-05-17 | BZ | Futures | 99.47 | 99.56 | 97.15 | 98.36 | 462.0 |
| 2011-05-17 | C | Futures | 2032.0 | 2038.0 | 2007.0 | 2017.0 | 6031.0 |
| 2011-05-17 | CC | Futures | 2388.0 | 2393.0 | 2364.0 | 2372.0 | 9055.0 |
| 2011-05-17 | CT | Futures | 150.49 | 156.24 | 149.29 | 153.45 | 12381.0 |
| 2011-05-17 | DC | Futures | 29.33 | 29.91 | 29.31 | 29.76 | 217.0 |
| 2011-05-17 | DX | Futures | 75.442 | 75.636 | 75.098 | 75.168 | 40015.0 |
| 2011-05-17 | E1 | Futures | 1.4804 | 1.48878 | 1.47425 | 1.48721 | 33168.0 |
| 2011-05-17 | E6 | Futures | 1.67618 | 1.68577 | 1.67144 | 1.68411 | 349355.0 |
| 2011-05-17 | E7 | Futures | 1.6641 | 1.6732 | 1.6591 | 1.6716 | 6985.0 |
| 2011-05-17 | ED | Futures | 94.9597 | 94.9621 | 94.9573 | 94.9597 | 107973.0 |
| 2011-05-17 | ER | Futures | 97.277 | 97.291 | 97.277 | 97.281 | 99186.0 |
| 2011-05-17 | EW | Futures | 976.0 | 980.5 | 964.6 | 970.5 | 30389.0 |
| 2011-05-17 | FBTP | Futures | 65.17 | 65.33 | 65.17 | 65.19 | 4375.0 |
| 2011-05-17 | FCE | Futures | 2714.8 | 2740.5 | 2690.9 | 2697.1 | 112718.0 |
| 2011-05-17 | FDAX | Futures | 7840.0 | 7877.9 | 7743.4 | 7774.4 | 183374.0 |
| 2011-05-17 | FESX | Futures | 1820.3 | 1838.9 | 1808.7 | 1816.4 | 1461724.0 |
| 2011-05-17 | FEU3 | Futures | 97.825 | 97.83 | 97.825 | 97.825 | 6.0 |
| 2011-05-17 | FGBL | Futures | 99.38 | 99.6 | 99.12 | 99.56 | 1074337.0 |
| 2011-05-17 | FGBM | Futures | 103.87 | 103.94 | 103.65 | 103.91 | 649519.0 |
| 2011-05-17 | FGBS | Futures | 106.498 | 106.548 | 106.424 | 106.533 | 573415.0 |
| 2011-05-17 | FGBX | Futures | 96.02 | 96.45 | 95.44 | 96.39 | 2863.0 |
| 2011-05-17 | FTDX | Futures | 819.9 | 827.0 | 816.3 | 819.4 | 612.0 |
| 2011-05-17 | FTI | Futures | 287.09 | 289.39 | 284.92 | 285.29 | 35410.0 |
| 2011-05-17 | FTUK | Futures | 4092.7 | 4146.9 | 4081.9 | 4097.3 | 119494.0 |
| 2011-05-17 | FXXP | Futures | 186.0 | 186.9 | 184.7 | 185.0 | 929.0 |
| 2011-05-17 | G | Futures | 83.6 | 83.8 | 83.23 | 83.75 | 134402.0 |
| 2011-05-17 | GF | Futures | 305.609 | 305.609 | 299.974 | 301.949 | 4635.0 |
| 2011-05-17 | GSCI | Futures | 1057.46 | 1058.56 | 1037.58 | 1057.07 | 221.0 |
| 2011-05-17 | HE | Futures | 99.514 | 99.779 | 98.349 | 99.408 | 14739.0 |
| 2011-05-17 | HG | Futures | 5.2744 | 5.3667 | 5.2438 | 5.3122 | 38003.0 |
| 2011-05-17 | HO | Futures | 2.3764 | 2.4069 | 2.3325 | 2.3641 | 62017.0 |
| 2011-05-17 | HRC | Futures | 3077.0 | 3077.0 | 3077.0 | 3077.0 | 0.0 |
| 2011-05-17 | J1 | Futures | 0.0155405 | 0.0155619 | 0.0153646 | 0.0154237 | 121535.0 |
| 2011-05-17 | J7 | Futures | 0.015454 | 0.015465 | 0.015273 | 0.015329 | 403.0 |
| 2011-05-17 | JB | Futures | 122.51 | 122.56 | 122.31 | 122.31 | 1744.0 |
| 2011-05-17 | KC | Futures | 633.31 | 643.62 | 632.11 | 638.1 | 9447.0 |
| 2011-05-17 | KE | Futures | 3463.86 | 3548.78 | 3439.17 | 3532.98 | 11614.0 |
| 2011-05-17 | L | Futures | 98.423 | 98.443 | 98.423 | 98.443 | 44226.0 |
> showing 50 of 92 rows — these rows as CSV