PREVIEW / futures_daily / 2013-07-15
file: by_date/futures_daily/2013/2013-07-15.parquet size: 9 KB rows: 103
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 |
|---|---|---|---|---|---|---|---|
| 2013-07-15 | ES | Futures | 1720.04 | 1729.82 | 1719.78 | 1727.76 | 911484.0 |
| 2013-07-15 | NQ | Futures | 3542.83 | 3558.74 | 3542.83 | 3554.69 | 112409.0 |
| 2013-07-15 | YM | Futures | 15231.1 | 15307.4 | 15225.2 | 15279.7 | 63039.0 |
| 2013-07-15 | CL | Futures | 184.55 | 185.48 | 182.11 | 184.99 | 106059.0 |
| 2013-07-15 | GC | Futures | 1704.4 | 1717.3 | 1689.3 | 1703.9 | 116682.0 |
| 2013-07-15 | ZN | Futures | 113.334965 | 113.742039 | 113.026151 | 113.64378 | 762137.0 |
| 2013-07-15 | A6 | Futures | 0.84818 | 0.85203 | 0.84405 | 0.84987 | 89637.0 |
| 2013-07-15 | AD | Futures | 0.96794 | 0.96915 | 0.96422 | 0.96542 | 49612.0 |
| 2013-07-15 | B | Futures | 105.01 | 105.3 | 104.17 | 105.11 | 218951.0 |
| 2013-07-15 | B6 | Futures | 1.5831 | 1.5853 | 1.5749 | 1.5828 | 88762.0 |
| 2013-07-15 | BR | Futures | 0.21717 | 0.22059 | 0.21717 | 0.2198 | 66.0 |
| 2013-07-15 | BZ | Futures | 105.55 | 105.99 | 104.89 | 105.82 | 8236.0 |
| 2013-07-15 | C | Futures | 1632.0 | 1647.0 | 1629.0 | 1639.0 | 5579.0 |
| 2013-07-15 | CB | Futures | 76.745 | 76.745 | 76.745 | 76.745 | 1.0 |
| 2013-07-15 | CC | Futures | 1663.0 | 1673.0 | 1651.0 | 1660.0 | 10516.0 |
| 2013-07-15 | CNH | Futures | 7.133 | 7.1337 | 7.133 | 7.1337 | 2.0 |
| 2013-07-15 | CSC | Futures | 3.444 | 3.452 | 3.444 | 3.448 | 14.0 |
| 2013-07-15 | CT | Futures | 101.22 | 101.8 | 100.39 | 101.65 | 21.0 |
| 2013-07-15 | DC | Futures | 26.3 | 26.5 | 26.27 | 26.34 | 116.0 |
| 2013-07-15 | DX | Futures | 79.433 | 79.915 | 79.356 | 79.51 | 27749.0 |
| 2013-07-15 | E1 | Futures | 1.35872 | 1.35987 | 1.34882 | 1.35653 | 22683.0 |
| 2013-07-15 | E6 | Futures | 1.54229 | 1.54394 | 1.53367 | 1.54241 | 180810.0 |
| 2013-07-15 | E7 | Futures | 1.5328 | 1.5338 | 1.5238 | 1.5323 | 2481.0 |
| 2013-07-15 | ED | Futures | 95.2773 | 95.2869 | 95.2725 | 95.2821 | 73104.0 |
| 2013-07-15 | ER | Futures | 97.817 | 97.822 | 97.808 | 97.817 | 68976.0 |
| 2013-07-15 | EW | Futures | 1239.8 | 1248.1 | 1239.8 | 1247.1 | 12223.0 |
| 2013-07-15 | FBTP | Futures | 76.93 | 77.05 | 76.62 | 76.99 | 16773.0 |
| 2013-07-15 | FBTS | Futures | 92.619 | 92.748 | 92.55 | 92.722 | 5585.0 |
| 2013-07-15 | FCE | Futures | 2990.5 | 3010.2 | 2987.8 | 2999.0 | 106402.0 |
| 2013-07-15 | FDAX | Futures | 9139.2 | 9184.1 | 9115.3 | 9133.1 | 62270.0 |
| 2013-07-15 | FDIV | Futures | 124.42 | 124.52 | 124.42 | 124.52 | 100.0 |
| 2013-07-15 | FESX | Futures | 1881.8 | 1893.8 | 1877.6 | 1883.9 | 519603.0 |
| 2013-07-15 | FGBL | Futures | 120.29 | 120.3 | 119.93 | 120.06 | 411512.0 |
| 2013-07-15 | FGBM | Futures | 117.58 | 117.59 | 117.34 | 117.47 | 247954.0 |
| 2013-07-15 | FGBS | Futures | 110.387 | 110.392 | 110.333 | 110.362 | 200955.0 |
| 2013-07-15 | FGBX | Futures | 125.82 | 125.93 | 124.92 | 125.01 | 6860.0 |
| 2013-07-15 | FMWO | Futures | 4928.1 | 4928.1 | 4928.1 | 4928.1 | 0.0 |
| 2013-07-15 | FOAT | Futures | 106.85 | 106.97 | 106.75 | 106.87 | 20321.0 |
| 2013-07-15 | FTDX | Futures | 938.5 | 941.8 | 933.4 | 933.8 | 68.0 |
| 2013-07-15 | FTI | Futures | 319.1 | 320.77 | 319.1 | 319.89 | 4098.0 |
| 2013-07-15 | FTUK | Futures | 4881.4 | 4920.4 | 4876.2 | 4900.5 | 60346.0 |
| 2013-07-15 | FVSA | Futures | 2901.52 | 2937.07 | 2873.07 | 2915.74 | 3127.0 |
| 2013-07-15 | FXXP | Futures | 218.9 | 219.1 | 217.6 | 218.3 | 2725.0 |
| 2013-07-15 | G | Futures | 95.14 | 95.35 | 94.95 | 95.12 | 95383.0 |
| 2013-07-15 | GF | Futures | 253.955 | 257.535 | 253.955 | 257.198 | 3957.0 |
| 2013-07-15 | GSCI | Futures | 1047.5 | 1055.51 | 1047.5 | 1055.11 | 257.0 |
| 2013-07-15 | HE | Futures | 98.502 | 99.69 | 98.476 | 98.709 | 18706.0 |
| 2013-07-15 | HG | Futures | 4.0095 | 4.0209 | 3.9651 | 3.9899 | 40183.0 |
| 2013-07-15 | HH | Futures | 40.579 | 40.958 | 39.532 | 40.924 | 170.0 |
| 2013-07-15 | HO | Futures | 2.4346 | 2.4431 | 2.4231 | 2.4316 | 25935.0 |
> showing 50 of 103 rows — these rows as CSV