PREVIEW / futures_daily / 2013-06-14
file: by_date/futures_daily/2013/2013-06-14.parquet size: 9 KB rows: 100
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-06-14 | ES | Futures | 1680.39 | 1683.99 | 1665.71 | 1667.0 | 1838320.0 |
| 2013-06-14 | NQ | Futures | 3421.66 | 3427.16 | 3393.61 | 3397.37 | 227209.0 |
| 2013-06-14 | YM | Futures | 14979.4 | 15004.1 | 14839.6 | 14855.5 | 141102.0 |
| 2013-06-14 | CL | Futures | 168.79 | 171.54 | 168.33 | 170.83 | 126328.0 |
| 2013-06-14 | GC | Futures | 1838.4 | 1847.6 | 1829.1 | 1842.1 | 100911.0 |
| 2013-06-14 | ZN | Futures | 116.114297 | 116.605593 | 116.10026 | 116.437148 | 1097459.0 |
| 2013-06-14 | A6 | Futures | 0.89969 | 0.90007 | 0.89172 | 0.89481 | 140482.0 |
| 2013-06-14 | AD | Futures | 0.98971 | 0.99202 | 0.98678 | 0.9884 | 60769.0 |
| 2013-06-14 | B | Futures | 101.49 | 103.12 | 101.01 | 102.43 | 197141.0 |
| 2013-06-14 | B6 | Futures | 1.6467 | 1.6471 | 1.6365 | 1.6454 | 112803.0 |
| 2013-06-14 | BR | Futures | 0.22896 | 0.22896 | 0.22693 | 0.22749 | 338.0 |
| 2013-06-14 | BZ | Futures | 101.85 | 103.63 | 101.54 | 102.95 | 6523.0 |
| 2013-06-14 | C | Futures | 1612.0 | 1619.0 | 1568.0 | 1571.0 | 9023.0 |
| 2013-06-14 | CB | Futures | 78.766 | 78.814 | 78.694 | 78.694 | 27.0 |
| 2013-06-14 | CC | Futures | 1723.0 | 1726.0 | 1681.0 | 1683.0 | 24540.0 |
| 2013-06-14 | CNH | Futures | 7.1518 | 7.1518 | 7.1453 | 7.1487 | 31.0 |
| 2013-06-14 | CSC | Futures | 3.539 | 3.545 | 3.539 | 3.539 | 8.0 |
| 2013-06-14 | CT | Futures | 109.66 | 110.95 | 107.95 | 109.41 | 26393.0 |
| 2013-06-14 | DC | Futures | 27.08 | 27.22 | 27.06 | 27.08 | 105.0 |
| 2013-06-14 | DX | Futures | 77.383 | 77.607 | 77.206 | 77.263 | 48600.0 |
| 2013-06-14 | E1 | Futures | 1.39483 | 1.39895 | 1.38789 | 1.39483 | 45488.0 |
| 2013-06-14 | E6 | Futures | 1.57875 | 1.57899 | 1.56967 | 1.5751 | 234874.0 |
| 2013-06-14 | E7 | Futures | 1.5682 | 1.5687 | 1.5594 | 1.5648 | 2907.0 |
| 2013-06-14 | ED | Futures | 95.2821 | 95.2869 | 95.2773 | 95.2821 | 241119.0 |
| 2013-06-14 | ER | Futures | 97.817 | 97.842 | 97.817 | 97.837 | 88642.0 |
| 2013-06-14 | EW | Futures | 1196.0 | 1200.5 | 1188.0 | 1190.2 | 31014.0 |
| 2013-06-14 | FBTP | Futures | 77.77 | 78.5 | 77.77 | 78.13 | 33728.0 |
| 2013-06-14 | FBTS | Futures | 92.455 | 92.636 | 92.43 | 92.541 | 9597.0 |
| 2013-06-14 | FCE | Futures | 2952.4 | 2966.0 | 2926.8 | 2943.9 | 12639.0 |
| 2013-06-14 | FDAX | Futures | 9051.5 | 9102.6 | 8978.7 | 9040.9 | 114443.0 |
| 2013-06-14 | FESX | Futures | 1869.2 | 1881.1 | 1853.1 | 1867.8 | 277118.0 |
| 2013-06-14 | FEU3 | Futures | 98.438 | 98.448 | 98.438 | 98.448 | 30.0 |
| 2013-06-14 | FGBL | Futures | 120.12 | 120.52 | 120.05 | 120.46 | 574177.0 |
| 2013-06-14 | FGBM | Futures | 117.37 | 117.59 | 117.34 | 117.54 | 382044.0 |
| 2013-06-14 | FGBS | Futures | 110.303 | 110.333 | 110.293 | 110.323 | 327592.0 |
| 2013-06-14 | FGBX | Futures | 125.59 | 126.28 | 125.53 | 126.01 | 7556.0 |
| 2013-06-14 | FMWO | Futures | 4795.1 | 4795.1 | 4795.1 | 4795.1 | 0.0 |
| 2013-06-14 | FOAT | Futures | 107.32 | 107.69 | 107.23 | 107.62 | 38121.0 |
| 2013-06-14 | FTI | Futures | 303.78 | 305.09 | 301.95 | 303.35 | 632.0 |
| 2013-06-14 | FTUK | Futures | 4723.9 | 4727.3 | 4673.3 | 4700.3 | 43436.0 |
| 2013-06-14 | FVSA | Futures | 3291.87 | 3299.26 | 3188.3 | 3232.69 | 3327.0 |
| 2013-06-14 | FXXP | Futures | 214.3 | 214.3 | 213.8 | 213.8 | 8897.0 |
| 2013-06-14 | G | Futures | 97.0 | 97.4 | 96.99 | 97.31 | 120840.0 |
| 2013-06-14 | GF | Futures | 244.688 | 245.067 | 241.613 | 241.613 | 2199.0 |
| 2013-06-14 | GSCI | Futures | 1037.45 | 1043.29 | 1037.45 | 1038.28 | 394.0 |
| 2013-06-14 | HE | Futures | 98.213 | 98.413 | 96.919 | 97.641 | 18943.0 |
| 2013-06-14 | HG | Futures | 4.0946 | 4.1074 | 4.0615 | 4.0787 | 47090.0 |
| 2013-06-14 | HH | Futures | 42.485 | 42.485 | 41.923 | 41.945 | 954.0 |
| 2013-06-14 | HO | Futures | 2.3653 | 2.3995 | 2.3549 | 2.3843 | 13739.0 |
| 2013-06-14 | HRC | Futures | 2127.3 | 2127.3 | 2127.3 | 2127.3 | 0.0 |
> showing 50 of 100 rows — these rows as CSV