PREVIEW / futures_daily / 2014-02-04
file: by_date/futures_daily/2014/2014-02-04.parquet size: 9 KB rows: 105
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-02-04 | ES | Futures | 1791.89 | 1807.61 | 1787.5 | 1797.55 | 2325416.0 |
| 2014-02-04 | NQ | Futures | 3954.07 | 3993.45 | 3944.88 | 3968.44 | 324399.0 |
| 2014-02-04 | YM | Futures | 15298.8 | 15392.7 | 15257.9 | 15313.8 | 211683.0 |
| 2014-02-04 | CL | Futures | 170.47 | 172.75 | 170.18 | 171.63 | 204282.0 |
| 2014-02-04 | GC | Futures | 1658.2 | 1661.8 | 1643.5 | 1649.3 | 93152.0 |
| 2014-02-04 | ZN | Futures | 115.750469 | 115.807701 | 115.435697 | 115.507236 | 1231484.0 |
| 2014-02-04 | A6 | Futures | 0.83147 | 0.84996 | 0.82957 | 0.84891 | 130292.0 |
| 2014-02-04 | AD | Futures | 0.91045 | 0.91562 | 0.90944 | 0.91349 | 52745.0 |
| 2014-02-04 | B | Futures | 108.02 | 108.39 | 107.69 | 107.99 | 110211.0 |
| 2014-02-04 | B6 | Futures | 1.7131 | 1.7164 | 1.7073 | 1.7139 | 103297.0 |
| 2014-02-04 | BFX | Futures | 3424.3 | 3461.8 | 3424.3 | 3446.7 | 24.0 |
| 2014-02-04 | BR | Futures | 0.21228 | 0.21427 | 0.21228 | 0.21342 | 867.0 |
| 2014-02-04 | BZ | Futures | 110.17 | 110.58 | 109.89 | 110.17 | 4926.0 |
| 2014-02-04 | C | Futures | 1964.0 | 1968.0 | 1937.0 | 1942.0 | 6966.0 |
| 2014-02-04 | CB | Futures | 87.831 | 89.057 | 87.831 | 88.922 | 27.0 |
| 2014-02-04 | CC | Futures | 2174.0 | 2179.0 | 2140.0 | 2146.0 | 16196.0 |
| 2014-02-04 | CNH | Futures | 6.9483 | 6.9483 | 6.9441 | 6.9443 | 3.0 |
| 2014-02-04 | CSC | Futures | 4.218 | 4.244 | 4.157 | 4.174 | 44.0 |
| 2014-02-04 | CT | Futures | 97.03 | 98.4 | 97.03 | 97.37 | 11715.0 |
| 2014-02-04 | DC | Futures | 32.47 | 33.29 | 31.85 | 32.12 | 924.0 |
| 2014-02-04 | DX | Futures | 77.189 | 77.337 | 77.099 | 77.241 | 14224.0 |
| 2014-02-04 | E1 | Futures | 1.42505 | 1.42543 | 1.41696 | 1.41991 | 23886.0 |
| 2014-02-04 | E6 | Futures | 1.5968 | 1.59822 | 1.59279 | 1.5955 | 181062.0 |
| 2014-02-04 | E7 | Futures | 1.5863 | 1.5877 | 1.5825 | 1.5851 | 4127.0 |
| 2014-02-04 | EBM | Futures | 267.99 | 271.48 | 266.6 | 270.43 | 13238.0 |
| 2014-02-04 | ED | Futures | 95.371 | 95.3758 | 95.3662 | 95.371 | 98926.0 |
| 2014-02-04 | ER | Futures | 97.896 | 97.901 | 97.886 | 97.896 | 96806.0 |
| 2014-02-04 | EW | Futures | 1290.5 | 1307.4 | 1287.5 | 1301.2 | 31091.0 |
| 2014-02-04 | FBTP | Futures | 84.03 | 84.14 | 83.88 | 84.1 | 38199.0 |
| 2014-02-04 | FBTS | Futures | 96.319 | 96.415 | 96.275 | 96.398 | 9020.0 |
| 2014-02-04 | FCE | Futures | 3173.7 | 3214.2 | 3166.7 | 3202.5 | 149726.0 |
| 2014-02-04 | FDAX | Futures | 10114.2 | 10172.9 | 10063.7 | 10137.4 | 151191.0 |
| 2014-02-04 | FESX | Futures | 2069.0 | 2094.4 | 2066.2 | 2085.9 | 1272729.0 |
| 2014-02-04 | FEU3 | Futures | 98.512 | 98.512 | 98.512 | 98.512 | 31.0 |
| 2014-02-04 | FGBL | Futures | 122.64 | 122.73 | 122.41 | 122.52 | 657091.0 |
| 2014-02-04 | FGBM | Futures | 119.36 | 119.41 | 119.27 | 119.33 | 513149.0 |
| 2014-02-04 | FGBS | Futures | 110.673 | 110.688 | 110.653 | 110.663 | 269181.0 |
| 2014-02-04 | FGBX | Futures | 125.27 | 125.36 | 124.86 | 125.07 | 20591.0 |
| 2014-02-04 | FMWO | Futures | 5130.2 | 5151.6 | 5130.2 | 5151.6 | 72.0 |
| 2014-02-04 | FOAT | Futures | 111.15 | 111.22 | 110.87 | 110.98 | 53843.0 |
| 2014-02-04 | FTDX | Futures | 1126.8 | 1136.6 | 1112.7 | 1129.1 | 272.0 |
| 2014-02-04 | FTI | Futures | 325.82 | 328.39 | 324.27 | 327.31 | 33641.0 |
| 2014-02-04 | FTUK | Futures | 4814.8 | 4863.6 | 4812.6 | 4844.0 | 129374.0 |
| 2014-02-04 | FVSA | Futures | 2295.4 | 2331.11 | 2208.69 | 2264.8 | 10965.0 |
| 2014-02-04 | FXXP | Futures | 231.4 | 233.4 | 231.0 | 232.7 | 6900.0 |
| 2014-02-04 | G | Futures | 93.57 | 93.63 | 93.32 | 93.46 | 182559.0 |
| 2014-02-04 | GF | Futures | 270.821 | 271.667 | 269.088 | 269.209 | 5358.0 |
| 2014-02-04 | GSCI | Futures | 1020.72 | 1022.85 | 1020.72 | 1021.29 | 255.0 |
| 2014-02-04 | HE | Futures | 112.378 | 112.922 | 112.106 | 112.469 | 11451.0 |
| 2014-02-04 | HG | Futures | 4.0189 | 4.0499 | 4.0132 | 4.0315 | 41130.0 |
> showing 50 of 105 rows — these rows as CSV