PREVIEW / futures_daily / 2014-02-03
file: by_date/futures_daily/2014/2014-02-03.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-02-03 | ES | Futures | 1832.35 | 1838.79 | 1785.7 | 1786.22 | 3026524.0 |
| 2014-02-03 | NQ | Futures | 4039.72 | 4057.83 | 3937.69 | 3943.15 | 438269.0 |
| 2014-02-03 | YM | Futures | 15619.3 | 15672.2 | 15255.9 | 15267.9 | 271065.0 |
| 2014-02-03 | CL | Futures | 172.0 | 172.96 | 169.99 | 170.29 | 293312.0 |
| 2014-02-03 | GC | Futures | 1637.2 | 1669.0 | 1635.1 | 1660.8 | 124745.0 |
| 2014-02-03 | ZN | Futures | 115.178155 | 115.836316 | 115.020769 | 115.764777 | 1618164.0 |
| 2014-02-03 | A6 | Futures | 0.83262 | 0.84024 | 0.83043 | 0.83195 | 91125.0 |
| 2014-02-03 | AD | Futures | 0.90964 | 0.91623 | 0.90863 | 0.91157 | 70199.0 |
| 2014-02-03 | B | Futures | 108.59 | 108.89 | 107.59 | 108.22 | 156543.0 |
| 2014-02-03 | B6 | Futures | 1.7256 | 1.7265 | 1.7107 | 1.7124 | 147462.0 |
| 2014-02-03 | BFX | Futures | 3447.3 | 3448.9 | 3442.2 | 3442.2 | 64.0 |
| 2014-02-03 | BR | Futures | 0.21409 | 0.21409 | 0.21088 | 0.21135 | 133.0 |
| 2014-02-03 | BZ | Futures | 110.72 | 111.09 | 109.78 | 110.4 | 8258.0 |
| 2014-02-03 | C | Futures | 1938.0 | 1967.0 | 1938.0 | 1965.0 | 7204.0 |
| 2014-02-03 | CB | Futures | 89.793 | 89.793 | 88.321 | 89.057 | 19.0 |
| 2014-02-03 | CC | Futures | 2161.0 | 2181.0 | 2149.0 | 2172.0 | 12774.0 |
| 2014-02-03 | CSC | Futures | 4.329 | 4.329 | 4.211 | 4.218 | 62.0 |
| 2014-02-03 | CT | Futures | 97.86 | 97.93 | 96.64 | 96.93 | 13194.0 |
| 2014-02-03 | DC | Futures | 33.5 | 33.5 | 32.43 | 32.59 | 588.0 |
| 2014-02-03 | DX | Futures | 77.394 | 77.427 | 77.113 | 77.132 | 20221.0 |
| 2014-02-03 | E1 | Futures | 1.41632 | 1.4262 | 1.41388 | 1.42556 | 32470.0 |
| 2014-02-03 | E6 | Futures | 1.5922 | 1.59787 | 1.59078 | 1.59728 | 226387.0 |
| 2014-02-03 | E7 | Futures | 1.5813 | 1.5874 | 1.5805 | 1.5869 | 4979.0 |
| 2014-02-03 | EBM | Futures | 266.95 | 269.04 | 266.6 | 267.3 | 13395.0 |
| 2014-02-03 | ED | Futures | 95.3758 | 95.3758 | 95.3662 | 95.371 | 126711.0 |
| 2014-02-03 | ER | Futures | 97.891 | 97.901 | 97.881 | 97.891 | 82121.0 |
| 2014-02-03 | EW | Futures | 1341.5 | 1343.5 | 1285.6 | 1286.0 | 61387.0 |
| 2014-02-03 | FBTP | Futures | 84.15 | 84.33 | 84.05 | 84.13 | 43450.0 |
| 2014-02-03 | FBTS | Futures | 96.31 | 96.389 | 96.284 | 96.336 | 9574.0 |
| 2014-02-03 | FCE | Futures | 3225.8 | 3256.5 | 3164.0 | 3195.5 | 171219.0 |
| 2014-02-03 | FDAX | Futures | 10303.2 | 10383.6 | 10083.1 | 10196.8 | 152225.0 |
| 2014-02-03 | FESX | Futures | 2114.8 | 2130.9 | 2063.4 | 2085.2 | 1327386.0 |
| 2014-02-03 | FGBL | Futures | 122.53 | 122.81 | 122.19 | 122.56 | 748681.0 |
| 2014-02-03 | FGBM | Futures | 119.32 | 119.46 | 119.18 | 119.32 | 525304.0 |
| 2014-02-03 | FGBS | Futures | 110.678 | 110.693 | 110.643 | 110.668 | 302499.0 |
| 2014-02-03 | FGBX | Futures | 125.17 | 125.46 | 124.43 | 125.07 | 16297.0 |
| 2014-02-03 | FMWO | Futures | 5174.2 | 5174.2 | 5174.2 | 5174.2 | 0.0 |
| 2014-02-03 | FOAT | Futures | 111.1 | 111.12 | 110.83 | 111.07 | 38630.0 |
| 2014-02-03 | FTDX | Futures | 1148.4 | 1151.6 | 1125.8 | 1139.9 | 170.0 |
| 2014-02-03 | FTI | Futures | 328.56 | 332.11 | 324.79 | 328.09 | 42276.0 |
| 2014-02-03 | FTUK | Futures | 4879.5 | 4907.9 | 4802.3 | 4851.9 | 126826.0 |
| 2014-02-03 | FVSA | Futures | 2142.38 | 2290.3 | 2111.77 | 2280.1 | 7648.0 |
| 2014-02-03 | FXXP | Futures | 235.4 | 237.3 | 231.2 | 232.9 | 6255.0 |
| 2014-02-03 | G | Futures | 93.35 | 93.58 | 92.95 | 93.48 | 191647.0 |
| 2014-02-03 | GF | Futures | 272.635 | 272.635 | 270.539 | 270.861 | 4095.0 |
| 2014-02-03 | GSCI | Futures | 1017.69 | 1019.98 | 1012.85 | 1017.03 | 509.0 |
| 2014-02-03 | HE | Futures | 114.492 | 114.522 | 112.046 | 112.137 | 21952.0 |
| 2014-02-03 | HG | Futures | 4.0334 | 4.0448 | 4.0101 | 4.0208 | 35726.0 |
| 2014-02-03 | HH | Futures | 51.19 | 52.56 | 51.136 | 52.114 | 782.0 |
| 2014-02-03 | HO | Futures | 2.3969 | 2.4132 | 2.3712 | 2.4044 | 72566.0 |
> showing 50 of 103 rows — these rows as CSV