PREVIEW / futures_daily / 2013-08-09
file: by_date/futures_daily/2013/2013-08-09.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-09 | ES | Futures | 1744.76 | 1747.08 | 1732.91 | 1736.78 | 1662642.0 |
| 2013-08-09 | NQ | Futures | 3619.76 | 3626.12 | 3594.02 | 3601.25 | 199820.0 |
| 2013-08-09 | YM | Futures | 15317.4 | 15335.2 | 15169.7 | 15239.0 | 142970.0 |
| 2013-08-09 | CL | Futures | 181.41 | 185.55 | 180.97 | 185.08 | 303796.0 |
| 2013-08-09 | GC | Futures | 1734.4 | 1741.1 | 1724.7 | 1735.4 | 96809.0 |
| 2013-08-09 | ZN | Futures | 113.868372 | 113.980668 | 113.770113 | 113.92452 | 520223.0 |
| 2013-08-09 | A6 | Futures | 0.85184 | 0.86263 | 0.85025 | 0.86254 | 101369.0 |
| 2013-08-09 | AD | Futures | 0.97459 | 0.97973 | 0.97228 | 0.97963 | 80585.0 |
| 2013-08-09 | B | Futures | 103.31 | 104.87 | 103.23 | 104.79 | 144684.0 |
| 2013-08-09 | B6 | Futures | 1.6284 | 1.6308 | 1.6244 | 1.6261 | 74505.0 |
| 2013-08-09 | BFX | Futures | 3368.6 | 3383.4 | 3368.6 | 3375.9 | 38.0 |
| 2013-08-09 | BR | Futures | 0.21665 | 0.21739 | 0.21588 | 0.21722 | 294.0 |
| 2013-08-09 | BZ | Futures | 104.23 | 105.62 | 104.0 | 105.56 | 8996.0 |
| 2013-08-09 | C | Futures | 1754.0 | 1755.0 | 1733.0 | 1748.0 | 4674.0 |
| 2013-08-09 | CB | Futures | 71.279 | 71.518 | 70.681 | 70.681 | 19.0 |
| 2013-08-09 | CC | Futures | 1851.0 | 1853.0 | 1827.0 | 1848.0 | 23257.0 |
| 2013-08-09 | CSC | Futures | 3.492 | 3.492 | 3.366 | 3.395 | 15.0 |
| 2013-08-09 | CT | Futures | 106.15 | 106.15 | 105.83 | 106.05 | 18.0 |
| 2013-08-09 | DC | Futures | 26.47 | 26.95 | 25.64 | 25.98 | 609.0 |
| 2013-08-09 | DX | Futures | 77.507 | 77.626 | 77.383 | 77.574 | 18619.0 |
| 2013-08-09 | E1 | Futures | 1.39779 | 1.39895 | 1.39303 | 1.3938 | 21847.0 |
| 2013-08-09 | E6 | Futures | 1.57923 | 1.58041 | 1.57356 | 1.57451 | 142452.0 |
| 2013-08-09 | E7 | Futures | 1.5692 | 1.5701 | 1.5633 | 1.5642 | 2309.0 |
| 2013-08-09 | ED | Futures | 95.3012 | 95.3012 | 95.2964 | 95.2964 | 30309.0 |
| 2013-08-09 | ER | Futures | 97.822 | 97.827 | 97.817 | 97.827 | 14578.0 |
| 2013-08-09 | EW | Futures | 1258.2 | 1263.1 | 1252.1 | 1258.0 | 15058.0 |
| 2013-08-09 | FBTP | Futures | 78.9 | 79.06 | 78.78 | 78.98 | 16363.0 |
| 2013-08-09 | FBTS | Futures | 93.358 | 93.393 | 93.307 | 93.367 | 3178.0 |
| 2013-08-09 | FCE | Futures | 3149.0 | 3163.7 | 3131.2 | 3151.7 | 105610.0 |
| 2013-08-09 | FDAX | Futures | 9255.7 | 9297.9 | 9195.8 | 9243.5 | 78598.0 |
| 2013-08-09 | FESX | Futures | 1982.2 | 1990.6 | 1968.8 | 1980.8 | 635292.0 |
| 2013-08-09 | FEU3 | Futures | 98.438 | 98.438 | 98.438 | 98.438 | 3.0 |
| 2013-08-09 | FGBL | Futures | 118.98 | 119.33 | 118.91 | 119.13 | 336922.0 |
| 2013-08-09 | FGBM | Futures | 116.95 | 117.17 | 116.93 | 117.07 | 190530.0 |
| 2013-08-09 | FGBS | Futures | 110.253 | 110.293 | 110.248 | 110.283 | 124984.0 |
| 2013-08-09 | FGBX | Futures | 123.11 | 123.92 | 122.96 | 123.48 | 6633.0 |
| 2013-08-09 | FMWO | Futures | 4996.5 | 4996.5 | 4996.5 | 4996.5 | 0.0 |
| 2013-08-09 | FOAT | Futures | 106.68 | 106.93 | 106.53 | 106.83 | 22185.0 |
| 2013-08-09 | FTDX | Futures | 961.6 | 963.0 | 956.0 | 960.7 | 103.0 |
| 2013-08-09 | FTI | Futures | 326.19 | 328.6 | 325.14 | 327.59 | 20919.0 |
| 2013-08-09 | FTUK | Futures | 4883.7 | 4932.8 | 4871.7 | 4911.8 | 61490.0 |
| 2013-08-09 | FVSA | Futures | 2567.27 | 2624.17 | 2553.05 | 2588.61 | 3428.0 |
| 2013-08-09 | FXXP | Futures | 224.3 | 225.6 | 223.6 | 225.0 | 10757.0 |
| 2013-08-09 | G | Futures | 93.74 | 94.11 | 93.66 | 93.95 | 80424.0 |
| 2013-08-09 | GF | Futures | 259.473 | 260.105 | 258.125 | 259.22 | 947.0 |
| 2013-08-09 | GSCI | Futures | 1028.93 | 1043.08 | 1028.93 | 1042.02 | 2368.0 |
| 2013-08-09 | HE | Futures | 102.766 | 103.038 | 102.313 | 102.797 | 12743.0 |
| 2013-08-09 | HG | Futures | 4.1307 | 4.2094 | 4.1136 | 4.1954 | 70717.0 |
| 2013-08-09 | HH | Futures | 36.311 | 36.532 | 35.507 | 35.584 | 1407.0 |
| 2013-08-09 | HO | Futures | 2.3787 | 2.4101 | 2.3671 | 2.404 | 55920.0 |
> showing 50 of 103 rows — these rows as CSV