PREVIEW / futures_daily / 2013-08-26
file: by_date/futures_daily/2013/2013-08-26.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 |
|---|---|---|---|---|---|---|---|
| 2013-08-26 | ES | Futures | 1710.51 | 1717.46 | 1702.79 | 1703.82 | 1213990.0 |
| 2013-08-26 | NQ | Futures | 3609.35 | 3640.58 | 3605.88 | 3610.21 | 189292.0 |
| 2013-08-26 | YM | Futures | 14852.5 | 14900.1 | 14788.1 | 14799.0 | 100672.0 |
| 2013-08-26 | CL | Futures | 187.93 | 188.74 | 185.56 | 186.19 | 165995.0 |
| 2013-08-26 | GC | Futures | 1850.2 | 1860.8 | 1836.2 | 1842.4 | 103038.0 |
| 2013-08-26 | ZN | Futures | 112.240077 | 112.534855 | 112.113744 | 112.338336 | 1078713.0 |
| 2013-08-26 | A6 | Futures | 0.84574 | 0.84997 | 0.84359 | 0.84612 | 66286.0 |
| 2013-08-26 | AD | Futures | 0.95797 | 0.95928 | 0.95595 | 0.95877 | 38373.0 |
| 2013-08-26 | B | Futures | 108.88 | 109.32 | 108.21 | 108.38 | 42643.0 |
| 2013-08-26 | B6 | Futures | 1.6329 | 1.6367 | 1.6308 | 1.633 | 46327.0 |
| 2013-08-26 | BFX | Futures | 3318.8 | 3322.4 | 3318.8 | 3322.4 | 10.0 |
| 2013-08-26 | BR | Futures | 0.2094 | 0.2094 | 0.2094 | 0.2094 | 865.0 |
| 2013-08-26 | BZ | Futures | 109.68 | 109.71 | 109.06 | 109.2 | 2101.0 |
| 2013-08-26 | CB | Futures | 69.539 | 69.659 | 69.395 | 69.419 | 14.0 |
| 2013-08-26 | CC | Futures | 1836.0 | 1854.0 | 1831.0 | 1849.0 | 4766.0 |
| 2013-08-26 | CNH | Futures | 7.0832 | 7.0832 | 7.0797 | 7.0797 | 1.0 |
| 2013-08-26 | CSC | Futures | 3.261 | 3.282 | 3.261 | 3.28 | 45.0 |
| 2013-08-26 | CT | Futures | 101.3 | 101.53 | 101.29 | 101.53 | 5.0 |
| 2013-08-26 | DC | Futures | 24.87 | 25.03 | 24.76 | 25.03 | 87.0 |
| 2013-08-26 | DX | Futures | 77.794 | 77.942 | 77.703 | 77.833 | 16701.0 |
| 2013-08-26 | E1 | Futures | 1.39612 | 1.39625 | 1.39021 | 1.39252 | 15440.0 |
| 2013-08-26 | E6 | Futures | 1.57934 | 1.58088 | 1.57639 | 1.57828 | 95099.0 |
| 2013-08-26 | E7 | Futures | 1.5692 | 1.5706 | 1.5661 | 1.568 | 1650.0 |
| 2013-08-26 | ED | Futures | 95.3084 | 95.3084 | 95.306 | 95.306 | 42319.0 |
| 2013-08-26 | ER | Futures | 97.822 | 97.832 | 97.817 | 97.832 | 14865.0 |
| 2013-08-26 | EW | Futures | 1239.4 | 1246.1 | 1235.8 | 1240.0 | 17417.0 |
| 2013-08-26 | FBTP | Futures | 78.3 | 78.3 | 77.76 | 77.93 | 12795.0 |
| 2013-08-26 | FBTS | Futures | 93.298 | 93.315 | 93.186 | 93.212 | 3695.0 |
| 2013-08-26 | FCE | Futures | 3143.3 | 3146.7 | 3112.8 | 3136.7 | 42270.0 |
| 2013-08-26 | FDAX | Futures | 9358.9 | 9378.9 | 9308.4 | 9355.1 | 40983.0 |
| 2013-08-26 | FESX | Futures | 1987.1 | 1987.8 | 1967.4 | 1978.6 | 291851.0 |
| 2013-08-26 | FEU3 | Futures | 98.443 | 98.443 | 98.443 | 98.443 | 1.0 |
| 2013-08-26 | FGBL | Futures | 116.93 | 117.35 | 116.86 | 117.27 | 215574.0 |
| 2013-08-26 | FGBM | Futures | 115.96 | 116.21 | 115.93 | 116.18 | 145452.0 |
| 2013-08-26 | FGBS | Futures | 110.108 | 110.163 | 110.103 | 110.153 | 108275.0 |
| 2013-08-26 | FGBX | Futures | 119.15 | 119.66 | 118.88 | 119.49 | 4239.0 |
| 2013-08-26 | FMWO | Futures | 4959.8 | 4959.8 | 4959.8 | 4959.8 | 0.0 |
| 2013-08-26 | FOAT | Futures | 104.95 | 105.26 | 104.86 | 105.2 | 8850.0 |
| 2013-08-26 | FTDX | Futures | 985.6 | 986.6 | 980.5 | 982.3 | 39.0 |
| 2013-08-26 | FTI | Futures | 327.86 | 327.86 | 324.71 | 326.02 | 10686.0 |
| 2013-08-26 | FVSA | Futures | 2561.99 | 2655.15 | 2561.99 | 2588.61 | 3079.0 |
| 2013-08-26 | FXXP | Futures | 224.2 | 224.6 | 223.2 | 224.5 | 601.0 |
| 2013-08-26 | GF | Futures | 257.905 | 258.398 | 253.383 | 253.424 | 2812.0 |
| 2013-08-26 | GSCI | Futures | 1069.16 | 1073.19 | 1068.5 | 1070.8 | 104.0 |
| 2013-08-26 | HE | Futures | 103.522 | 104.188 | 103.492 | 104.067 | 10928.0 |
| 2013-08-26 | HG | Futures | 4.2494 | 4.2988 | 4.1823 | 4.2126 | 20854.0 |
| 2013-08-26 | HH | Futures | 38.393 | 38.393 | 37.951 | 38.361 | 333.0 |
| 2013-08-26 | HO | Futures | 2.4807 | 2.4831 | 2.4589 | 2.4654 | 9121.0 |
| 2013-08-26 | HRC | Futures | 2266.5 | 2266.5 | 2266.5 | 2266.5 | 0.0 |
| 2013-08-26 | J1 | Futures | 0.0127628 | 0.0128069 | 0.0127301 | 0.0127578 | 77441.0 |
> showing 50 of 99 rows — these rows as CSV