PREVIEW / futures_daily / 2013-08-28
file: by_date/futures_daily/2013/2013-08-28.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-08-28 | ES | Futures | 1677.04 | 1688.37 | 1673.43 | 1681.16 | 1652221.0 |
| 2013-08-28 | NQ | Futures | 3541.39 | 3568.28 | 3535.03 | 3549.2 | 188487.0 |
| 2013-08-28 | YM | Futures | 14625.5 | 14717.7 | 14609.7 | 14675.1 | 114210.0 |
| 2013-08-28 | CL | Futures | 191.99 | 197.3 | 191.8 | 193.54 | 336171.0 |
| 2013-08-28 | GC | Futures | 1872.9 | 1896.5 | 1869.0 | 1876.4 | 167016.0 |
| 2013-08-28 | ZN | Futures | 112.970002 | 113.054225 | 112.422558 | 112.534855 | 2402128.0 |
| 2013-08-28 | A6 | Futures | 0.84171 | 0.84208 | 0.83326 | 0.83805 | 89108.0 |
| 2013-08-28 | AD | Futures | 0.96129 | 0.96139 | 0.95807 | 0.96069 | 51276.0 |
| 2013-08-28 | B | Futures | 112.62 | 114.58 | 112.24 | 113.86 | 167955.0 |
| 2013-08-28 | B6 | Futures | 1.6299 | 1.6306 | 1.6173 | 1.6278 | 128563.0 |
| 2013-08-28 | BR | Futures | 0.21008 | 0.21421 | 0.21008 | 0.21359 | 312.0 |
| 2013-08-28 | BZ | Futures | 113.15 | 115.41 | 113.1 | 114.73 | 9962.0 |
| 2013-08-28 | C | Futures | 1729.0 | 1760.0 | 1728.0 | 1755.0 | 3414.0 |
| 2013-08-28 | CB | Futures | 70.833 | 70.905 | 70.258 | 70.498 | 30.0 |
| 2013-08-28 | CC | Futures | 1828.0 | 1869.0 | 1825.0 | 1862.0 | 11831.0 |
| 2013-08-28 | CSC | Futures | 3.28 | 3.28 | 3.251 | 3.269 | 12.0 |
| 2013-08-28 | CT | Futures | 101.37 | 101.37 | 99.87 | 100.05 | 5.0 |
| 2013-08-28 | DC | Futures | 24.9 | 24.93 | 24.74 | 24.83 | 39.0 |
| 2013-08-28 | DX | Futures | 77.569 | 78.023 | 77.54 | 77.856 | 31643.0 |
| 2013-08-28 | E1 | Futures | 1.40087 | 1.40177 | 1.39188 | 1.39483 | 28146.0 |
| 2013-08-28 | E6 | Futures | 1.58064 | 1.58123 | 1.57002 | 1.57415 | 209542.0 |
| 2013-08-28 | E7 | Futures | 1.5702 | 1.5709 | 1.5599 | 1.5639 | 3298.0 |
| 2013-08-28 | ED | Futures | 95.3108 | 95.3108 | 95.306 | 95.3084 | 76725.0 |
| 2013-08-28 | ER | Futures | 97.827 | 97.832 | 97.827 | 97.832 | 16397.0 |
| 2013-08-28 | EW | Futures | 1214.6 | 1222.3 | 1211.4 | 1216.1 | 15508.0 |
| 2013-08-28 | FBTP | Futures | 77.47 | 77.87 | 77.4 | 77.85 | 25512.0 |
| 2013-08-28 | FBTS | Futures | 93.031 | 93.169 | 93.023 | 93.16 | 6130.0 |
| 2013-08-28 | FCE | Futures | 3052.7 | 3065.8 | 3033.4 | 3053.8 | 94172.0 |
| 2013-08-28 | FDAX | Futures | 9124.7 | 9144.7 | 8984.9 | 9056.5 | 115758.0 |
| 2013-08-28 | FESX | Futures | 1924.6 | 1933.7 | 1908.5 | 1924.6 | 999578.0 |
| 2013-08-28 | FEU3 | Futures | 98.443 | 98.443 | 98.443 | 98.443 | 63.0 |
| 2013-08-28 | FGBL | Futures | 117.88 | 117.99 | 117.34 | 117.47 | 646730.0 |
| 2013-08-28 | FGBM | Futures | 116.47 | 116.54 | 116.19 | 116.29 | 437831.0 |
| 2013-08-28 | FGBS | Futures | 110.218 | 110.228 | 110.158 | 110.183 | 220107.0 |
| 2013-08-28 | FGBX | Futures | 120.43 | 120.64 | 119.57 | 119.82 | 17346.0 |
| 2013-08-28 | FMWO | Futures | 4867.3 | 4867.3 | 4863.5 | 4863.5 | 79.0 |
| 2013-08-28 | FOAT | Futures | 105.47 | 105.51 | 105.13 | 105.22 | 29225.0 |
| 2013-08-28 | FTDX | Futures | 948.4 | 957.4 | 940.9 | 950.3 | 89.0 |
| 2013-08-28 | FTI | Futures | 317.64 | 319.17 | 316.16 | 318.12 | 26643.0 |
| 2013-08-28 | FTUK | Futures | 4793.3 | 4831.2 | 4790.7 | 4818.4 | 69785.0 |
| 2013-08-28 | FVSA | Futures | 2908.02 | 3014.5 | 2821.52 | 2927.99 | 11528.0 |
| 2013-08-28 | FXXP | Futures | 219.1 | 219.9 | 218.0 | 219.4 | 9684.0 |
| 2013-08-28 | G | Futures | 91.76 | 92.19 | 91.39 | 91.51 | 204210.0 |
| 2013-08-28 | GF | Futures | 255.562 | 257.494 | 255.397 | 256.384 | 1350.0 |
| 2013-08-28 | GSCI | Futures | 1095.48 | 1102.71 | 1092.85 | 1100.41 | 481.0 |
| 2013-08-28 | HE | Futures | 104.732 | 104.793 | 103.946 | 104.097 | 13905.0 |
| 2013-08-28 | HG | Futures | 4.2177 | 4.2475 | 4.1861 | 4.1924 | 36177.0 |
| 2013-08-28 | HH | Futures | 38.782 | 38.879 | 37.908 | 38.674 | 1234.0 |
| 2013-08-28 | HO | Futures | 2.5466 | 2.5704 | 2.5286 | 2.5624 | 16718.0 |
| 2013-08-28 | HRC | Futures | 2266.5 | 2266.5 | 2266.5 | 2266.5 | 0.0 |
> showing 50 of 103 rows — these rows as CSV