PREVIEW / futures_daily / 2012-08-08
file: by_date/futures_daily/2012/2012-08-08.parquet size: 9 KB rows: 99
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 |
|---|---|---|---|---|---|---|---|
| 2012-08-08 | ES | Futures | 1414.26 | 1418.06 | 1408.19 | 1416.04 | 1227991.0 |
| 2012-08-08 | NQ | Futures | 3107.86 | 3118.47 | 3099.82 | 3106.71 | 176853.0 |
| 2012-08-08 | YM | Futures | 12725.8 | 12763.6 | 12656.9 | 12728.7 | 82212.0 |
| 2012-08-08 | CL | Futures | 169.53 | 171.91 | 168.46 | 169.43 | 269931.0 |
| 2012-08-08 | GC | Futures | 2155.8 | 2162.3 | 2144.1 | 2157.6 | 84409.0 |
| 2012-08-08 | ZN | Futures | 116.38618 | 116.60408 | 116.195517 | 116.345323 | 829756.0 |
| 2012-08-08 | A6 | Futures | 0.94576 | 0.9481 | 0.94343 | 0.94657 | 107541.0 |
| 2012-08-08 | AD | Futures | 1.00481 | 1.00822 | 1.00291 | 1.00672 | 78577.0 |
| 2012-08-08 | B | Futures | 99.96 | 101.33 | 99.23 | 100.39 | 174710.0 |
| 2012-08-08 | B6 | Futures | 1.6325 | 1.6383 | 1.6274 | 1.6354 | 92144.0 |
| 2012-08-08 | BFX | Futures | 2804.6 | 2811.8 | 2799.9 | 2805.1 | 30.0 |
| 2012-08-08 | BR | Futures | 0.23439 | 0.23532 | 0.23355 | 0.23468 | 105.0 |
| 2012-08-08 | BZ | Futures | 105.84 | 106.56 | 105.8 | 105.8 | 7665.0 |
| 2012-08-08 | C | Futures | 1703.0 | 1715.0 | 1690.0 | 1709.0 | 5868.0 |
| 2012-08-08 | CB | Futures | 95.267 | 95.267 | 95.267 | 95.267 | 3.0 |
| 2012-08-08 | CC | Futures | 1842.0 | 1871.0 | 1839.0 | 1862.0 | 16897.0 |
| 2012-08-08 | CSC | Futures | 4.116 | 4.14 | 4.092 | 4.127 | 60.0 |
| 2012-08-08 | CT | Futures | 98.64 | 99.85 | 97.3 | 99.46 | 54.0 |
| 2012-08-08 | DC | Futures | 30.49 | 30.73 | 30.23 | 30.58 | 318.0 |
| 2012-08-08 | DX | Futures | 79.954 | 80.144 | 79.877 | 80.017 | 16235.0 |
| 2012-08-08 | E1 | Futures | 1.33338 | 1.33389 | 1.32589 | 1.32886 | 30829.0 |
| 2012-08-08 | E6 | Futures | 1.46306 | 1.46354 | 1.45457 | 1.45799 | 185922.0 |
| 2012-08-08 | E7 | Futures | 1.4527 | 1.4543 | 1.4455 | 1.4489 | 3356.0 |
| 2012-08-08 | ED | Futures | 95.1847 | 95.1895 | 95.1752 | 95.1847 | 83727.0 |
| 2012-08-08 | ER | Futures | 97.803 | 97.822 | 97.798 | 97.813 | 52530.0 |
| 2012-08-08 | EW | Futures | 968.6 | 972.6 | 965.4 | 969.5 | 16031.0 |
| 2012-08-08 | FBTP | Futures | 65.62 | 66.06 | 65.41 | 66.03 | 13112.0 |
| 2012-08-08 | FBTS | Futures | 86.452 | 86.592 | 86.154 | 86.518 | 2009.0 |
| 2012-08-08 | FCE | Futures | 2568.7 | 2570.9 | 2546.0 | 2561.3 | 90805.0 |
| 2012-08-08 | FDAX | Futures | 7597.2 | 7611.9 | 7541.5 | 7599.9 | 107511.0 |
| 2012-08-08 | FESX | Futures | 1648.2 | 1650.2 | 1631.9 | 1644.8 | 890112.0 |
| 2012-08-08 | FEU3 | Futures | 98.394 | 98.394 | 98.394 | 98.394 | 100.0 |
| 2012-08-08 | FGBL | Futures | 117.59 | 118.26 | 117.58 | 117.91 | 621588.0 |
| 2012-08-08 | FGBM | Futures | 115.99 | 116.31 | 115.97 | 116.16 | 340938.0 |
| 2012-08-08 | FGBS | Futures | 110.482 | 110.537 | 110.477 | 110.502 | 174002.0 |
| 2012-08-08 | FGBX | Futures | 124.89 | 126.56 | 124.89 | 125.72 | 5140.0 |
| 2012-08-08 | FOAT | Futures | 102.31 | 102.67 | 102.31 | 102.53 | 12907.0 |
| 2012-08-08 | FTDX | Futures | 742.1 | 742.1 | 729.6 | 731.9 | 169.0 |
| 2012-08-08 | FTI | Futures | 283.66 | 283.66 | 281.28 | 283.03 | 24540.0 |
| 2012-08-08 | FTUK | Futures | 4216.0 | 4246.3 | 4204.4 | 4238.6 | 69881.0 |
| 2012-08-08 | FVSA | Futures | 6748.2 | 6803.63 | 6568.06 | 6595.78 | 1644.0 |
| 2012-08-08 | FXXP | Futures | 192.0 | 192.8 | 191.5 | 192.7 | 2190.0 |
| 2012-08-08 | G | Futures | 100.0 | 100.3 | 99.84 | 99.88 | 116272.0 |
| 2012-08-08 | GF | Futures | 273.738 | 278.178 | 273.738 | 275.859 | 978.0 |
| 2012-08-08 | GSCI | Futures | 1050.51 | 1052.98 | 1042.0 | 1047.33 | 1485.0 |
| 2012-08-08 | HE | Futures | 93.245 | 93.801 | 92.472 | 93.461 | 21488.0 |
| 2012-08-08 | HG | Futures | 4.4175 | 4.4227 | 4.384 | 4.4079 | 46203.0 |
| 2012-08-08 | HO | Futures | 2.4427 | 2.4771 | 2.4306 | 2.4658 | 53014.0 |
| 2012-08-08 | HRC | Futures | 2529.1 | 2529.1 | 2529.1 | 2529.1 | 0.0 |
| 2012-08-08 | J1 | Futures | 0.0159506 | 0.0160246 | 0.0159368 | 0.0159682 | 71082.0 |
> showing 50 of 99 rows — these rows as CSV