PREVIEW / futures_daily / 2014-01-06
file: by_date/futures_daily/2014/2014-01-06.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 |
|---|---|---|---|---|---|---|---|
| 2014-01-06 | ES | Futures | 1880.28 | 1889.04 | 1873.32 | 1876.93 | 1369207.0 |
| 2014-01-06 | NQ | Futures | 4058.69 | 4069.9 | 4030.24 | 4044.03 | 246009.0 |
| 2014-01-06 | YM | Futures | 16373.1 | 16446.0 | 16310.2 | 16339.2 | 115127.0 |
| 2014-01-06 | CL | Futures | 166.26 | 166.99 | 164.53 | 164.94 | 189379.0 |
| 2014-01-06 | GC | Futures | 1637.8 | 1652.0 | 1605.5 | 1639.2 | 152189.0 |
| 2014-01-06 | ZN | Futures | 112.717206 | 113.175057 | 112.574128 | 113.060594 | 683923.0 |
| 2014-01-06 | A6 | Futures | 0.84901 | 0.85215 | 0.84758 | 0.85025 | 71229.0 |
| 2014-01-06 | AD | Futures | 0.95045 | 0.95288 | 0.9464 | 0.94873 | 60211.0 |
| 2014-01-06 | B | Futures | 108.42 | 109.57 | 108.22 | 108.37 | 127605.0 |
| 2014-01-06 | B6 | Futures | 1.7233 | 1.7256 | 1.7154 | 1.7225 | 83519.0 |
| 2014-01-06 | BFX | Futures | 3511.2 | 3516.2 | 3498.3 | 3498.3 | 48.0 |
| 2014-01-06 | BR | Futures | 0.21469 | 0.21526 | 0.2143 | 0.21495 | 599.0 |
| 2014-01-06 | BZ | Futures | 110.92 | 111.73 | 110.37 | 110.53 | 8242.0 |
| 2014-01-06 | C | Futures | 1833.0 | 1834.0 | 1797.0 | 1801.0 | 9433.0 |
| 2014-01-06 | CB | Futures | 80.103 | 80.63 | 79.489 | 80.63 | 12.0 |
| 2014-01-06 | CC | Futures | 2010.0 | 2017.0 | 1971.0 | 1979.0 | 13653.0 |
| 2014-01-06 | CNH | Futures | 6.9703 | 6.9728 | 6.9668 | 6.9668 | 40.0 |
| 2014-01-06 | CSC | Futures | 3.857 | 3.884 | 3.857 | 3.884 | 37.0 |
| 2014-01-06 | CT | Futures | 94.56 | 95.55 | 94.25 | 95.36 | 9593.0 |
| 2014-01-06 | DC | Futures | 29.9 | 30.05 | 29.59 | 30.02 | 210.0 |
| 2014-01-06 | DX | Futures | 77.027 | 77.104 | 76.733 | 76.843 | 24665.0 |
| 2014-01-06 | E1 | Futures | 1.41927 | 1.42389 | 1.41593 | 1.42068 | 36195.0 |
| 2014-01-06 | E6 | Futures | 1.60495 | 1.61168 | 1.602 | 1.60955 | 164085.0 |
| 2014-01-06 | E7 | Futures | 1.5941 | 1.6013 | 1.5917 | 1.5991 | 5026.0 |
| 2014-01-06 | EBM | Futures | 282.96 | 284.01 | 281.57 | 281.92 | 16960.0 |
| 2014-01-06 | ED | Futures | 95.3614 | 95.3614 | 95.3566 | 95.3566 | 51667.0 |
| 2014-01-06 | ER | Futures | 97.876 | 97.881 | 97.867 | 97.867 | 47251.0 |
| 2014-01-06 | EW | Futures | 1359.2 | 1366.4 | 1350.3 | 1351.5 | 17064.0 |
| 2014-01-06 | FBTP | Futures | 83.13 | 83.15 | 82.94 | 83.05 | 19284.0 |
| 2014-01-06 | FBTS | Futures | 95.986 | 95.994 | 95.924 | 95.942 | 1.0 |
| 2014-01-06 | FCE | Futures | 3304.4 | 3321.9 | 3289.9 | 3295.4 | 86823.0 |
| 2014-01-06 | FDAX | Futures | 10462.4 | 10511.7 | 10432.4 | 10465.7 | 73022.0 |
| 2014-01-06 | FESX | Futures | 2156.3 | 2168.9 | 2151.3 | 2154.9 | 542285.0 |
| 2014-01-06 | FGBL | Futures | 118.35 | 118.82 | 118.35 | 118.74 | 384626.0 |
| 2014-01-06 | FGBM | Futures | 117.21 | 117.39 | 117.2 | 117.31 | 299359.0 |
| 2014-01-06 | FGBS | Futures | 110.343 | 110.363 | 110.333 | 110.333 | 221082.0 |
| 2014-01-06 | FGBX | Futures | 118.21 | 119.09 | 118.21 | 118.91 | 12322.0 |
| 2014-01-06 | FMWO | Futures | 5403.2 | 5403.2 | 5379.3 | 5379.3 | 100.0 |
| 2014-01-06 | FOAT | Futures | 107.62 | 107.84 | 107.58 | 107.79 | 28116.0 |
| 2014-01-06 | FTDX | Futures | 1105.6 | 1113.1 | 1103.3 | 1110.3 | 97.0 |
| 2014-01-06 | FTI | Futures | 345.05 | 346.04 | 343.25 | 343.59 | 23253.0 |
| 2014-01-06 | FTUK | Futures | 5062.3 | 5071.8 | 5041.5 | 5053.6 | 78402.0 |
| 2014-01-06 | FVSA | Futures | 1912.91 | 1918.28 | 1864.55 | 1912.91 | 5369.0 |
| 2014-01-06 | FXXP | Futures | 239.5 | 240.5 | 238.9 | 239.2 | 3843.0 |
| 2014-01-06 | G | Futures | 90.46 | 90.78 | 90.3 | 90.69 | 106119.0 |
| 2014-01-06 | GF | Futures | 270.863 | 271.145 | 270.219 | 270.501 | 1437.0 |
| 2014-01-06 | GSCI | Futures | 1012.45 | 1020.79 | 1012.45 | 1015.26 | 341.0 |
| 2014-01-06 | HE | Futures | 104.407 | 104.739 | 103.984 | 104.619 | 15497.0 |
| 2014-01-06 | HG | Futures | 4.2317 | 4.2494 | 4.2065 | 4.2431 | 38062.0 |
| 2014-01-06 | HH | Futures | 42.936 | 43.407 | 42.726 | 43.137 | 114.0 |
> showing 50 of 103 rows — these rows as CSV