PREVIEW / futures_daily / 2013-07-18
file: by_date/futures_daily/2013/2013-07-18.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 |
|---|---|---|---|---|---|---|---|
| 2013-07-18 | ES | Futures | 1726.99 | 1739.09 | 1721.84 | 1730.85 | 1355890.0 |
| 2013-07-18 | NQ | Futures | 3557.29 | 3570.89 | 3523.46 | 3525.19 | 179562.0 |
| 2013-07-18 | YM | Futures | 15294.6 | 15395.7 | 15263.8 | 15344.1 | 103102.0 |
| 2013-07-18 | CL | Futures | 185.74 | 188.95 | 185.01 | 188.29 | 206309.0 |
| 2013-07-18 | GC | Futures | 1691.8 | 1709.7 | 1690.3 | 1704.8 | 123913.0 |
| 2013-07-18 | ZN | Futures | 114.078928 | 114.345631 | 113.742039 | 113.868372 | 1011918.0 |
| 2013-07-18 | A6 | Futures | 0.8631 | 0.86366 | 0.85381 | 0.85672 | 87040.0 |
| 2013-07-18 | AD | Futures | 0.96694 | 0.96966 | 0.96371 | 0.96895 | 48447.0 |
| 2013-07-18 | B | Futures | 105.65 | 105.88 | 105.07 | 105.72 | 196437.0 |
| 2013-07-18 | B6 | Futures | 1.5943 | 1.5976 | 1.5884 | 1.5948 | 102731.0 |
| 2013-07-18 | BFX | Futures | 3157.8 | 3177.8 | 3157.8 | 3177.8 | 21.0 |
| 2013-07-18 | BR | Futures | 0.22004 | 0.22054 | 0.22004 | 0.22054 | 12.0 |
| 2013-07-18 | BZ | Futures | 106.23 | 106.55 | 105.8 | 106.43 | 3702.0 |
| 2013-07-18 | C | Futures | 1689.0 | 1708.0 | 1687.0 | 1706.0 | 10938.0 |
| 2013-07-18 | CB | Futures | 77.259 | 77.259 | 76.553 | 77.139 | 12.0 |
| 2013-07-18 | CC | Futures | 1719.0 | 1757.0 | 1716.0 | 1754.0 | 16551.0 |
| 2013-07-18 | CNH | Futures | 7.1325 | 7.1361 | 7.1321 | 7.1344 | 16.0 |
| 2013-07-18 | CSC | Futures | 3.518 | 3.526 | 3.505 | 3.505 | 6.0 |
| 2013-07-18 | CT | Futures | 99.99 | 101.82 | 99.5 | 101.22 | 33.0 |
| 2013-07-18 | DC | Futures | 26.99 | 27.22 | 26.87 | 27.02 | 282.0 |
| 2013-07-18 | DX | Futures | 79.151 | 79.476 | 79.093 | 79.28 | 25495.0 |
| 2013-07-18 | E1 | Futures | 1.36656 | 1.36707 | 1.35666 | 1.36051 | 24238.0 |
| 2013-07-18 | E6 | Futures | 1.54925 | 1.54937 | 1.54229 | 1.54654 | 172521.0 |
| 2013-07-18 | E7 | Futures | 1.5391 | 1.5391 | 1.5323 | 1.5364 | 2650.0 |
| 2013-07-18 | ED | Futures | 95.2869 | 95.2916 | 95.2821 | 95.2869 | 69237.0 |
| 2013-07-18 | ER | Futures | 97.822 | 97.842 | 97.817 | 97.832 | 49307.0 |
| 2013-07-18 | EW | Futures | 1244.7 | 1255.5 | 1241.0 | 1252.1 | 15319.0 |
| 2013-07-18 | FBTP | Futures | 76.83 | 77.5 | 76.66 | 77.29 | 35328.0 |
| 2013-07-18 | FBTS | Futures | 92.619 | 92.86 | 92.593 | 92.808 | 8144.0 |
| 2013-07-18 | FCE | Futures | 2989.0 | 3040.8 | 2981.6 | 3036.1 | 76703.0 |
| 2013-07-18 | FDAX | Futures | 9144.2 | 9257.9 | 9120.3 | 9240.2 | 88829.0 |
| 2013-07-18 | FESX | Futures | 1876.2 | 1908.5 | 1872.0 | 1904.3 | 915514.0 |
| 2013-07-18 | FGBL | Futures | 120.53 | 120.87 | 120.51 | 120.77 | 585012.0 |
| 2013-07-18 | FGBM | Futures | 117.77 | 117.95 | 117.75 | 117.91 | 344501.0 |
| 2013-07-18 | FGBS | Futures | 110.427 | 110.462 | 110.417 | 110.452 | 237901.0 |
| 2013-07-18 | FGBX | Futures | 125.59 | 126.28 | 125.55 | 125.88 | 6508.0 |
| 2013-07-18 | FMWO | Futures | 4956.0 | 4963.6 | 4956.0 | 4963.6 | 102.0 |
| 2013-07-18 | FOAT | Futures | 107.01 | 107.33 | 107.01 | 107.23 | 45715.0 |
| 2013-07-18 | FTDX | Futures | 930.5 | 938.5 | 930.1 | 938.1 | 53.0 |
| 2013-07-18 | FTI | Futures | 319.01 | 322.3 | 318.27 | 321.6 | 22410.0 |
| 2013-07-18 | FTUK | Futures | 4890.4 | 4959.8 | 4880.7 | 4938.8 | 92246.0 |
| 2013-07-18 | FVSA | Futures | 2915.74 | 2915.74 | 2787.73 | 2801.95 | 3658.0 |
| 2013-07-18 | FXXP | Futures | 217.7 | 220.6 | 217.4 | 219.9 | 7171.0 |
| 2013-07-18 | G | Futures | 95.5 | 95.86 | 95.47 | 95.74 | 113122.0 |
| 2013-07-18 | GF | Futures | 254.629 | 257.367 | 254.587 | 256.229 | 2410.0 |
| 2013-07-18 | GSCI | Futures | 1056.41 | 1069.01 | 1056.41 | 1065.41 | 375.0 |
| 2013-07-18 | HE | Futures | 99.303 | 100.336 | 99.122 | 99.819 | 14164.0 |
| 2013-07-18 | HG | Futures | 3.9753 | 3.9835 | 3.9416 | 3.9734 | 34477.0 |
| 2013-07-18 | HH | Futures | 41.069 | 42.673 | 41.025 | 42.462 | 3957.0 |
| 2013-07-18 | HO | Futures | 2.4661 | 2.5006 | 2.4628 | 2.4898 | 42972.0 |
> showing 50 of 103 rows — these rows as CSV