PREVIEW / futures_daily / 2014-03-28
file: by_date/futures_daily/2014/2014-03-28.parquet size: 9 KB rows: 104
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-03-28 | ES | Futures | 1907.35 | 1923.91 | 1905.29 | 1914.6 | 1502152.0 |
| 2014-03-28 | NQ | Futures | 4097.93 | 4145.42 | 4088.15 | 4101.39 | 313345.0 |
| 2014-03-28 | YM | Futures | 16263.4 | 16408.0 | 16247.3 | 16306.6 | 155051.0 |
| 2014-03-28 | CL | Futures | 180.85 | 182.45 | 180.56 | 181.44 | 166326.0 |
| 2014-03-28 | GC | Futures | 1702.7 | 1712.1 | 1694.6 | 1705.4 | 171316.0 |
| 2014-03-28 | ZN | Futures | 114.736403 | 114.881272 | 114.417691 | 114.56256 | 976086.0 |
| 2014-03-28 | A6 | Futures | 0.88511 | 0.88838 | 0.88271 | 0.88424 | 65368.0 |
| 2014-03-28 | AD | Futures | 0.91725 | 0.92008 | 0.9136 | 0.91552 | 56095.0 |
| 2014-03-28 | B | Futures | 111.18 | 111.79 | 111.03 | 111.5 | 89868.0 |
| 2014-03-28 | B6 | Futures | 1.7444 | 1.7492 | 1.7436 | 1.7484 | 66472.0 |
| 2014-03-28 | BFX | Futures | 3768.0 | 3780.9 | 3767.8 | 3773.9 | 29.0 |
| 2014-03-28 | BR | Futures | 0.2296 | 0.23023 | 0.22833 | 0.22925 | 258.0 |
| 2014-03-28 | BZ | Futures | 113.25 | 113.93 | 113.25 | 113.63 | 5073.0 |
| 2014-03-28 | C | Futures | 1956.0 | 1990.0 | 1937.0 | 1975.0 | 10193.0 |
| 2014-03-28 | CB | Futures | 95.446 | 95.446 | 95.319 | 95.446 | 5.0 |
| 2014-03-28 | CC | Futures | 2186.0 | 2232.0 | 2166.0 | 2215.0 | 23131.0 |
| 2014-03-28 | CSC | Futures | 4.466 | 4.471 | 4.464 | 4.466 | 31.0 |
| 2014-03-28 | CT | Futures | 103.92 | 105.43 | 103.69 | 105.36 | 10719.0 |
| 2014-03-28 | DC | Futures | 35.58 | 35.65 | 35.32 | 35.49 | 127.0 |
| 2014-03-28 | DX | Futures | 76.282 | 76.382 | 76.197 | 76.32 | 12667.0 |
| 2014-03-28 | E1 | Futures | 1.44803 | 1.45124 | 1.44303 | 1.44803 | 25325.0 |
| 2014-03-28 | E6 | Futures | 1.62218 | 1.62584 | 1.61758 | 1.62324 | 167417.0 |
| 2014-03-28 | E7 | Futures | 1.6113 | 1.6149 | 1.6069 | 1.6124 | 3125.0 |
| 2014-03-28 | EBM | Futures | 296.98 | 298.75 | 295.58 | 295.58 | 12483.0 |
| 2014-03-28 | ED | Futures | 95.3995 | 95.3995 | 95.3947 | 95.3947 | 48309.0 |
| 2014-03-28 | ER | Futures | 97.857 | 97.871 | 97.842 | 97.847 | 99023.0 |
| 2014-03-28 | EW | Futures | 1392.1 | 1408.8 | 1391.2 | 1398.1 | 19744.0 |
| 2014-03-28 | FBTP | Futures | 87.22 | 87.53 | 87.1 | 87.23 | 71263.0 |
| 2014-03-28 | FBTS | Futures | 97.249 | 97.372 | 97.214 | 97.249 | 16888.0 |
| 2014-03-28 | FCE | Futures | 3410.4 | 3430.6 | 3409.6 | 3429.1 | 94297.0 |
| 2014-03-28 | FDAX | Futures | 10475.5 | 10614.6 | 10461.1 | 10604.7 | 99459.0 |
| 2014-03-28 | FDIV | Futures | 143.31 | 143.99 | 143.06 | 143.99 | 4.0 |
| 2014-03-28 | FESX | Futures | 2208.2 | 2232.7 | 2206.1 | 2229.8 | 882983.0 |
| 2014-03-28 | FGBL | Futures | 123.99 | 124.33 | 123.76 | 123.9 | 666137.0 |
| 2014-03-28 | FGBM | Futures | 119.82 | 120.02 | 119.68 | 119.76 | 452231.0 |
| 2014-03-28 | FGBS | Futures | 110.573 | 110.613 | 110.533 | 110.548 | 341917.0 |
| 2014-03-28 | FGBX | Futures | 127.09 | 127.74 | 126.91 | 127.11 | 19546.0 |
| 2014-03-28 | FMWO | Futures | 5507.7 | 5507.7 | 5507.7 | 5507.7 | 0.0 |
| 2014-03-28 | FOAT | Futures | 112.95 | 113.34 | 112.77 | 112.87 | 61685.0 |
| 2014-03-28 | FTDX | Futures | 1167.7 | 1176.6 | 1165.3 | 1171.9 | 208.0 |
| 2014-03-28 | FTI | Futures | 340.36 | 343.13 | 340.36 | 342.96 | 25624.0 |
| 2014-03-28 | FTUK | Futures | 4984.1 | 5014.3 | 4977.3 | 4998.2 | 91913.0 |
| 2014-03-28 | FVSA | Futures | 1805.56 | 1815.59 | 1785.5 | 1795.53 | 6149.0 |
| 2014-03-28 | FXXP | Futures | 245.6 | 246.9 | 245.6 | 246.7 | 5316.0 |
| 2014-03-28 | G | Futures | 93.94 | 94.02 | 93.43 | 93.48 | 126140.0 |
| 2014-03-28 | GF | Futures | 287.0 | 287.4 | 285.479 | 285.519 | 1962.0 |
| 2014-03-28 | GSCI | Futures | 1077.69 | 1078.68 | 1073.97 | 1073.97 | 90.0 |
| 2014-03-28 | HE | Futures | 147.096 | 148.35 | 145.171 | 146.046 | 262.0 |
| 2014-03-28 | HG | Futures | 3.7943 | 3.8627 | 3.7898 | 3.8545 | 47987.0 |
| 2014-03-28 | HH | Futures | 57.313 | 57.655 | 56.579 | 56.769 | 4922.0 |
> showing 50 of 104 rows — these rows as CSV