PREVIEW / futures_daily / 2014-08-04
file: by_date/futures_daily/2014/2014-08-04.parquet size: 9 KB rows: 102
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 |
|---|---|---|---|---|---|---|---|
| 2014-08-04 | ES | Futures | 1993.97 | 2012.67 | 1989.04 | 2006.95 | 1605356.0 |
| 2014-08-04 | NQ | Futures | 4468.58 | 4517.91 | 4461.95 | 4495.99 | 250762.0 |
| 2014-08-04 | YM | Futures | 16576.6 | 16676.5 | 16525.2 | 16634.1 | 137613.0 |
| 2014-08-04 | CL | Futures | 179.8 | 181.64 | 179.36 | 180.94 | 204262.0 |
| 2014-08-04 | GC | Futures | 1699.1 | 1700.4 | 1688.1 | 1690.6 | 67872.0 |
| 2014-08-04 | ZN | Futures | 116.944225 | 117.236002 | 116.87128 | 117.060936 | 752790.0 |
| 2014-08-04 | A6 | Futures | 0.89711 | 0.89972 | 0.89673 | 0.89924 | 50293.0 |
| 2014-08-04 | AD | Futures | 0.92931 | 0.93043 | 0.92799 | 0.93002 | 30356.0 |
| 2014-08-04 | ALI | Futures | 2956.86 | 2956.86 | 2956.86 | 2956.86 | 0.0 |
| 2014-08-04 | B | Futures | 110.63 | 111.63 | 110.52 | 111.3 | 150486.0 |
| 2014-08-04 | B6 | Futures | 1.7683 | 1.7723 | 1.767 | 1.7711 | 63935.0 |
| 2014-08-04 | BFX | Futures | 3718.0 | 3728.8 | 3708.5 | 3710.4 | 60.0 |
| 2014-08-04 | BR | Futures | 0.2317 | 0.23255 | 0.23097 | 0.23152 | 415.0 |
| 2014-08-04 | BZ | Futures | 111.59 | 112.5 | 111.4 | 112.18 | 17249.0 |
| 2014-08-04 | C | Futures | 2118.0 | 2143.0 | 2114.0 | 2117.0 | 6109.0 |
| 2014-08-04 | CB | Futures | 129.677 | 131.074 | 129.677 | 130.795 | 9.0 |
| 2014-08-04 | CC | Futures | 2356.0 | 2380.0 | 2340.0 | 2348.0 | 19103.0 |
| 2014-08-04 | CSC | Futures | 4.611 | 4.689 | 4.611 | 4.676 | 16.0 |
| 2014-08-04 | CT | Futures | 78.86 | 81.0 | 78.86 | 80.64 | 19.0 |
| 2014-08-04 | DC | Futures | 37.5 | 38.28 | 37.5 | 38.01 | 405.0 |
| 2014-08-04 | DX | Futures | 77.262 | 77.324 | 77.229 | 77.272 | 11582.0 |
| 2014-08-04 | E1 | Futures | 1.41571 | 1.41596 | 1.41327 | 1.41404 | 30010.0 |
| 2014-08-04 | E6 | Futures | 1.58465 | 1.585 | 1.58241 | 1.58359 | 102537.0 |
| 2014-08-04 | E7 | Futures | 1.5743 | 1.5746 | 1.5722 | 1.5733 | 834.0 |
| 2014-08-04 | ED | Futures | 95.4115 | 95.4162 | 95.4115 | 95.4115 | 49677.0 |
| 2014-08-04 | ER | Futures | 97.891 | 97.891 | 97.886 | 97.886 | 10574.0 |
| 2014-08-04 | EW | Futures | 1417.4 | 1426.9 | 1408.0 | 1424.3 | 19756.0 |
| 2014-08-04 | FBTP | Futures | 92.44 | 92.73 | 92.28 | 92.6 | 35341.0 |
| 2014-08-04 | FBTS | Futures | 98.419 | 98.508 | 98.41 | 98.472 | 4934.0 |
| 2014-08-04 | FCE | Futures | 3352.1 | 3379.1 | 3342.5 | 3353.7 | 110142.0 |
| 2014-08-04 | FDAX | Futures | 10161.2 | 10201.4 | 10055.5 | 10091.3 | 133630.0 |
| 2014-08-04 | FESX | Futures | 2218.9 | 2228.2 | 2200.2 | 2210.2 | 996379.0 |
| 2014-08-04 | FGBL | Futures | 129.04 | 129.19 | 128.98 | 129.09 | 391468.0 |
| 2014-08-04 | FGBM | Futures | 121.79 | 121.83 | 121.75 | 121.79 | 230944.0 |
| 2014-08-04 | FGBS | Futures | 110.773 | 110.778 | 110.763 | 110.768 | 94944.0 |
| 2014-08-04 | FGBX | Futures | 136.39 | 136.75 | 136.23 | 136.65 | 20831.0 |
| 2014-08-04 | FMWO | Futures | 5666.9 | 5670.7 | 5658.1 | 5658.1 | 255.0 |
| 2014-08-04 | FOAT | Futures | 119.13 | 119.3 | 119.08 | 119.22 | 30544.0 |
| 2014-08-04 | FTDX | Futures | 1114.5 | 1114.5 | 1094.3 | 1100.0 | 346.0 |
| 2014-08-04 | FTI | Futures | 346.06 | 346.19 | 340.6 | 341.77 | 38074.0 |
| 2014-08-04 | FTUK | Futures | 5096.2 | 5128.9 | 5090.4 | 5103.1 | 80590.0 |
| 2014-08-04 | FVSA | Futures | 1566.45 | 1587.68 | 1545.23 | 1562.21 | 8813.0 |
| 2014-08-04 | FXXP | Futures | 250.1 | 250.5 | 248.2 | 249.0 | 9420.0 |
| 2014-08-04 | G | Futures | 94.94 | 95.16 | 94.93 | 95.1 | 97097.0 |
| 2014-08-04 | GF | Futures | 338.244 | 340.734 | 335.447 | 338.665 | 2450.0 |
| 2014-08-04 | GSCI | Futures | 1032.37 | 1039.98 | 1032.37 | 1037.97 | 366.0 |
| 2014-08-04 | HE | Futures | 124.28 | 126.396 | 123.797 | 125.278 | 16726.0 |
| 2014-08-04 | HG | Futures | 4.1081 | 4.158 | 4.0896 | 4.1465 | 45661.0 |
| 2014-08-04 | HH | Futures | 48.874 | 48.874 | 48.671 | 48.671 | 196.0 |
| 2014-08-04 | HO | Futures | 2.2886 | 2.3082 | 2.2846 | 2.2926 | 56250.0 |
> showing 50 of 102 rows — these rows as CSV