PREVIEW / futures_daily / 2012-08-09
file: by_date/futures_daily/2012/2012-08-09.parquet size: 9 KB rows: 98
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-09 | ES | Futures | 1416.29 | 1421.61 | 1411.48 | 1418.31 | 1179356.0 |
| 2012-08-09 | NQ | Futures | 3107.28 | 3125.65 | 3102.98 | 3119.33 | 151552.0 |
| 2012-08-09 | YM | Futures | 12731.6 | 12791.8 | 12691.8 | 12746.2 | 83054.0 |
| 2012-08-09 | CL | Futures | 169.57 | 170.99 | 168.92 | 169.44 | 258637.0 |
| 2012-08-09 | GC | Futures | 2156.4 | 2164.3 | 2152.5 | 2163.2 | 69240.0 |
| 2012-08-09 | ZN | Futures | 116.27723 | 116.413417 | 116.059329 | 116.318086 | 892276.0 |
| 2012-08-09 | A6 | Futures | 0.94729 | 0.95116 | 0.94576 | 0.94792 | 108612.0 |
| 2012-08-09 | AD | Futures | 1.00712 | 1.01093 | 1.00672 | 1.01002 | 85275.0 |
| 2012-08-09 | B | Futures | 100.26 | 101.64 | 99.91 | 101.38 | 135420.0 |
| 2012-08-09 | B6 | Futures | 1.6361 | 1.6393 | 1.6307 | 1.6338 | 87099.0 |
| 2012-08-09 | BFX | Futures | 2802.2 | 2821.4 | 2801.0 | 2817.1 | 8.0 |
| 2012-08-09 | BR | Futures | 0.2348 | 0.23597 | 0.2347 | 0.23573 | 140.0 |
| 2012-08-09 | BZ | Futures | 106.34 | 107.01 | 106.19 | 106.85 | 4539.0 |
| 2012-08-09 | C | Futures | 1697.0 | 1713.0 | 1669.0 | 1696.0 | 7407.0 |
| 2012-08-09 | CB | Futures | 96.881 | 96.881 | 95.267 | 95.267 | 3.0 |
| 2012-08-09 | CC | Futures | 1862.0 | 1876.0 | 1829.0 | 1868.0 | 21116.0 |
| 2012-08-09 | CSC | Futures | 4.105 | 4.149 | 4.105 | 4.142 | 8.0 |
| 2012-08-09 | CT | Futures | 98.96 | 100.38 | 98.96 | 99.57 | 55.0 |
| 2012-08-09 | DC | Futures | 30.49 | 30.68 | 30.23 | 30.58 | 358.0 |
| 2012-08-09 | DX | Futures | 79.935 | 80.43 | 79.853 | 80.28 | 17787.0 |
| 2012-08-09 | E1 | Futures | 1.32989 | 1.33222 | 1.31969 | 1.32266 | 28158.0 |
| 2012-08-09 | E6 | Futures | 1.45917 | 1.46177 | 1.44738 | 1.45091 | 189274.0 |
| 2012-08-09 | E7 | Futures | 1.4499 | 1.4527 | 1.4384 | 1.4419 | 3576.0 |
| 2012-08-09 | ED | Futures | 95.18 | 95.1847 | 95.1704 | 95.18 | 109190.0 |
| 2012-08-09 | ER | Futures | 97.808 | 97.832 | 97.803 | 97.822 | 87648.0 |
| 2012-08-09 | EW | Futures | 969.7 | 975.7 | 967.6 | 972.8 | 16463.0 |
| 2012-08-09 | FBTP | Futures | 66.13 | 66.45 | 65.96 | 66.31 | 13119.0 |
| 2012-08-09 | FBTS | Futures | 86.659 | 86.725 | 86.353 | 86.518 | 2712.0 |
| 2012-08-09 | FCE | Futures | 2571.7 | 2584.7 | 2546.4 | 2574.3 | 91571.0 |
| 2012-08-09 | FDAX | Futures | 7622.8 | 7646.8 | 7522.9 | 7599.3 | 126687.0 |
| 2012-08-09 | FESX | Futures | 1653.6 | 1660.3 | 1629.9 | 1645.5 | 860976.0 |
| 2012-08-09 | FEU3 | Futures | 98.399 | 98.404 | 98.399 | 98.404 | 1.0 |
| 2012-08-09 | FGBL | Futures | 117.81 | 118.25 | 117.59 | 117.75 | 537869.0 |
| 2012-08-09 | FGBM | Futures | 116.12 | 116.35 | 116.03 | 116.15 | 320539.0 |
| 2012-08-09 | FGBS | Futures | 110.502 | 110.542 | 110.477 | 110.522 | 174617.0 |
| 2012-08-09 | FGBX | Futures | 125.46 | 126.3 | 124.89 | 125.4 | 4940.0 |
| 2012-08-09 | FOAT | Futures | 102.54 | 102.86 | 102.45 | 102.56 | 13247.0 |
| 2012-08-09 | FTDX | Futures | 733.3 | 733.3 | 726.3 | 732.8 | 70.0 |
| 2012-08-09 | FTI | Futures | 283.66 | 285.2 | 282.64 | 284.9 | 34183.0 |
| 2012-08-09 | FTUK | Futures | 4237.9 | 4264.5 | 4228.1 | 4241.9 | 64101.0 |
| 2012-08-09 | FVSA | Futures | 6554.21 | 6734.35 | 6554.21 | 6595.78 | 1435.0 |
| 2012-08-09 | FXXP | Futures | 193.5 | 193.7 | 192.6 | 193.5 | 1231.0 |
| 2012-08-09 | G | Futures | 99.8 | 99.97 | 99.44 | 99.55 | 106991.0 |
| 2012-08-09 | GF | Futures | 276.303 | 276.649 | 274.33 | 274.527 | 719.0 |
| 2012-08-09 | GSCI | Futures | 1051.31 | 1057.83 | 1051.31 | 1052.9 | 1769.0 |
| 2012-08-09 | HE | Futures | 93.708 | 94.913 | 93.338 | 93.863 | 22609.0 |
| 2012-08-09 | HG | Futures | 4.4066 | 4.4356 | 4.3847 | 4.4124 | 44636.0 |
| 2012-08-09 | HO | Futures | 2.465 | 2.4981 | 2.4562 | 2.4896 | 56740.0 |
| 2012-08-09 | HRC | Futures | 2533.1 | 2533.1 | 2533.1 | 2533.1 | 0.0 |
| 2012-08-09 | J1 | Futures | 0.015982 | 0.0160145 | 0.0159068 | 0.0159531 | 75299.0 |
> showing 50 of 98 rows — these rows as CSV