PREVIEW / futures_daily / 2011-01-19
file: by_date/futures_daily/2011/2011-01-19.parquet size: 9 KB rows: 94
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 |
|---|---|---|---|---|---|---|---|
| 2011-01-19 | ES | Futures | 1274.21 | 1275.93 | 1255.01 | 1258.46 | 2322868.0 |
| 2011-01-19 | NQ | Futures | 2646.96 | 2663.99 | 2603.25 | 2604.96 | 293316.0 |
| 2011-01-19 | YM | Futures | 11056.1 | 11077.7 | 10996.2 | 11030.9 | 104655.0 |
| 2011-01-19 | CL | Futures | 187.57 | 189.24 | 186.06 | 186.78 | 325048.0 |
| 2011-01-19 | GC | Futures | 1859.2 | 1874.3 | 1856.1 | 1862.5 | 137094.0 |
| 2011-01-19 | ZN | Futures | 100.296565 | 100.543536 | 100.101587 | 100.478544 | 947718.0 |
| 2011-01-19 | A6 | Futures | 0.84079 | 0.84868 | 0.8391 | 0.84181 | 100948.0 |
| 2011-01-19 | AD | Futures | 0.99979 | 1.00247 | 0.99463 | 0.99513 | 70307.0 |
| 2011-01-19 | B | Futures | 83.24 | 83.97 | 83.07 | 83.59 | 171917.0 |
| 2011-01-19 | B6 | Futures | 1.6555 | 1.6631 | 1.6533 | 1.6578 | 114573.0 |
| 2011-01-19 | BFX | Futures | 3075.0 | 3084.6 | 3049.7 | 3049.7 | 1079.0 |
| 2011-01-19 | BR | Futures | 0.25584 | 0.25584 | 0.25506 | 0.25562 | 91.0 |
| 2011-01-19 | BZ | Futures | 89.13 | 89.41 | 88.56 | 89.04 | 369.0 |
| 2011-01-19 | C | Futures | 2191.0 | 2251.0 | 2188.0 | 2245.0 | 7878.0 |
| 2011-01-19 | CB | Futures | 114.989 | 116.734 | 114.989 | 116.734 | 1.0 |
| 2011-01-19 | CC | Futures | 2458.0 | 2525.0 | 2449.0 | 2516.0 | 14532.0 |
| 2011-01-19 | CSC | Futures | 3.501 | 3.519 | 3.484 | 3.503 | 4.0 |
| 2011-01-19 | CT | Futures | 126.94 | 129.0 | 126.7 | 127.72 | 11496.0 |
| 2011-01-19 | DC | Futures | 24.87 | 25.0 | 24.37 | 24.52 | 501.0 |
| 2011-01-19 | DX | Futures | 78.978 | 78.978 | 78.329 | 78.669 | 22198.0 |
| 2011-01-19 | E1 | Futures | 1.36133 | 1.37745 | 1.35936 | 1.37286 | 38159.0 |
| 2011-01-19 | E6 | Futures | 1.58315 | 1.60113 | 1.58078 | 1.59155 | 373392.0 |
| 2011-01-19 | E7 | Futures | 1.5703 | 1.5893 | 1.5691 | 1.5797 | 6960.0 |
| 2011-01-19 | EBM | Futures | 233.99 | 237.39 | 233.76 | 235.81 | 8365.0 |
| 2011-01-19 | ED | Futures | 94.8289 | 94.8337 | 94.8194 | 94.8289 | 140906.0 |
| 2011-01-19 | ER | Futures | 97.267 | 97.291 | 97.242 | 97.286 | 194427.0 |
| 2011-01-19 | EW | Futures | 925.4 | 926.8 | 906.6 | 909.8 | 24085.0 |
| 2011-01-19 | FBTP | Futures | 63.7 | 64.14 | 63.64 | 64.01 | 5723.0 |
| 2011-01-19 | FCE | Futures | 2686.1 | 2689.5 | 2646.1 | 2657.4 | 140066.0 |
| 2011-01-19 | FDAX | Futures | 7689.8 | 7702.7 | 7574.2 | 7591.8 | 131915.0 |
| 2011-01-19 | FESX | Futures | 1837.7 | 1838.3 | 1809.1 | 1814.7 | 1258058.0 |
| 2011-01-19 | FEU3 | Futures | 97.835 | 97.845 | 97.83 | 97.845 | 15.0 |
| 2011-01-19 | FGBL | Futures | 98.24 | 98.51 | 98.09 | 98.47 | 750018.0 |
| 2011-01-19 | FGBM | Futures | 103.98 | 104.16 | 103.89 | 104.07 | 474984.0 |
| 2011-01-19 | FGBS | Futures | 106.961 | 107.05 | 106.956 | 107.03 | 574291.0 |
| 2011-01-19 | FGBX | Futures | 96.38 | 96.87 | 96.12 | 96.63 | 3491.0 |
| 2011-01-19 | FTDX | Futures | 781.5 | 790.3 | 770.1 | 772.7 | 551.0 |
| 2011-01-19 | FTI | Futures | 293.06 | 293.34 | 287.01 | 287.7 | 42402.0 |
| 2011-01-19 | FTUK | Futures | 4189.9 | 4198.2 | 4112.4 | 4126.3 | 102086.0 |
| 2011-01-19 | FXXP | Futures | 184.7 | 184.8 | 182.6 | 182.7 | 2733.0 |
| 2011-01-19 | G | Futures | 80.55 | 80.77 | 80.42 | 80.68 | 115131.0 |
| 2011-01-19 | GF | Futures | 315.679 | 316.419 | 313.398 | 314.508 | 2451.0 |
| 2011-01-19 | GSCI | Futures | 1033.31 | 1033.31 | 1022.24 | 1024.31 | 137.0 |
| 2011-01-19 | HE | Futures | 101.338 | 102.097 | 100.551 | 100.813 | 14645.0 |
| 2011-01-19 | HG | Futures | 5.9093 | 5.9539 | 5.794 | 5.824 | 42924.0 |
| 2011-01-19 | HO | Futures | 2.2095 | 2.2391 | 2.2095 | 2.2237 | 40869.0 |
| 2011-01-19 | HRC | Futures | 2744.7 | 2744.7 | 2744.7 | 2744.7 | 0.0 |
| 2011-01-19 | J1 | Futures | 0.0152101 | 0.0153495 | 0.0151938 | 0.0153081 | 127259.0 |
| 2011-01-19 | J7 | Futures | 0.015093 | 0.015239 | 0.015093 | 0.015199 | 145.0 |
| 2011-01-19 | JB | Futures | 120.66 | 120.72 | 120.28 | 120.42 | 1692.0 |
> showing 50 of 94 rows — these rows as CSV