PREVIEW / futures_daily / 2013-07-02
file: by_date/futures_daily/2013/2013-07-02.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 |
|---|---|---|---|---|---|---|---|
| 2013-07-02 | ES | Futures | 1654.89 | 1667.0 | 1648.2 | 1655.41 | 1670998.0 |
| 2013-07-02 | NQ | Futures | 3376.84 | 3402.29 | 3362.96 | 3381.47 | 202883.0 |
| 2013-07-02 | YM | Futures | 14754.4 | 14847.5 | 14664.2 | 14729.6 | 156302.0 |
| 2013-07-02 | CL | Futures | 170.81 | 173.96 | 170.32 | 173.49 | 285781.0 |
| 2013-07-02 | GC | Futures | 1663.0 | 1682.0 | 1644.5 | 1650.6 | 169736.0 |
| 2013-07-02 | ZN | Futures | 113.78415 | 113.92452 | 113.573595 | 113.742039 | 812642.0 |
| 2013-07-02 | A6 | Futures | 0.86179 | 0.86329 | 0.85194 | 0.85353 | 103625.0 |
| 2013-07-02 | AD | Futures | 0.95807 | 0.95827 | 0.95071 | 0.95414 | 68227.0 |
| 2013-07-02 | B | Futures | 99.68 | 100.74 | 99.59 | 100.64 | 128348.0 |
| 2013-07-02 | B6 | Futures | 1.5944 | 1.5968 | 1.5861 | 1.588 | 89633.0 |
| 2013-07-02 | BFX | Futures | 3052.1 | 3052.1 | 3024.4 | 3028.0 | 32.0 |
| 2013-07-02 | BR | Futures | 0.21754 | 0.21821 | 0.21705 | 0.21715 | 193.0 |
| 2013-07-02 | BZ | Futures | 100.37 | 101.42 | 100.31 | 101.32 | 14755.0 |
| 2013-07-02 | C | Futures | 1536.0 | 1559.0 | 1529.0 | 1557.0 | 3156.0 |
| 2013-07-02 | CB | Futures | 75.333 | 77.259 | 75.333 | 76.063 | 16.0 |
| 2013-07-02 | CC | Futures | 1617.0 | 1629.0 | 1606.0 | 1627.0 | 12554.0 |
| 2013-07-02 | CSC | Futures | 3.528 | 3.528 | 3.518 | 3.528 | 32.0 |
| 2013-07-02 | CT | Futures | 102.94 | 103.26 | 102.68 | 102.68 | 9.0 |
| 2013-07-02 | DC | Futures | 26.97 | 27.09 | 26.77 | 27.03 | 155.0 |
| 2013-07-02 | DX | Futures | 79.519 | 80.121 | 79.485 | 80.053 | 31751.0 |
| 2013-07-02 | E1 | Futures | 1.36077 | 1.36167 | 1.34946 | 1.35293 | 26529.0 |
| 2013-07-02 | E6 | Futures | 1.54205 | 1.54382 | 1.53025 | 1.5319 | 263432.0 |
| 2013-07-02 | E7 | Futures | 1.5316 | 1.5336 | 1.5204 | 1.5219 | 3123.0 |
| 2013-07-02 | ED | Futures | 95.2582 | 95.2725 | 95.2582 | 95.263 | 129874.0 |
| 2013-07-02 | ER | Futures | 97.788 | 97.813 | 97.788 | 97.803 | 94037.0 |
| 2013-07-02 | EW | Futures | 1191.2 | 1201.4 | 1184.2 | 1189.7 | 22624.0 |
| 2013-07-02 | FBTP | Futures | 77.12 | 77.42 | 76.87 | 77.24 | 24764.0 |
| 2013-07-02 | FBTS | Futures | 92.524 | 92.636 | 92.447 | 92.576 | 7188.0 |
| 2013-07-02 | FCE | Futures | 2922.2 | 2929.6 | 2875.2 | 2903.2 | 87403.0 |
| 2013-07-02 | FDAX | Futures | 8860.0 | 8876.1 | 8710.7 | 8779.0 | 111934.0 |
| 2013-07-02 | FDIV | Futures | 119.5 | 119.5 | 119.25 | 119.25 | 150.0 |
| 2013-07-02 | FESX | Futures | 1836.2 | 1842.5 | 1803.9 | 1822.9 | 803478.0 |
| 2013-07-02 | FEU3 | Futures | 98.409 | 98.413 | 98.409 | 98.413 | 4.0 |
| 2013-07-02 | FGBL | Futures | 118.54 | 119.05 | 118.42 | 118.64 | 552216.0 |
| 2013-07-02 | FGBM | Futures | 116.57 | 116.92 | 116.51 | 116.7 | 446310.0 |
| 2013-07-02 | FGBS | Futures | 110.183 | 110.278 | 110.168 | 110.223 | 359689.0 |
| 2013-07-02 | FGBX | Futures | 123.4 | 123.75 | 123.19 | 123.44 | 11315.0 |
| 2013-07-02 | FMWO | Futures | 4753.3 | 4753.3 | 4753.3 | 4753.3 | 0.0 |
| 2013-07-02 | FOAT | Futures | 105.74 | 105.93 | 105.61 | 105.78 | 31888.0 |
| 2013-07-02 | FTDX | Futures | 897.1 | 897.1 | 890.0 | 896.2 | 27.0 |
| 2013-07-02 | FTI | Futures | 302.52 | 303.26 | 300.78 | 303.09 | 26129.0 |
| 2013-07-02 | FTUK | Futures | 4674.8 | 4699.9 | 4655.3 | 4689.8 | 66064.0 |
| 2013-07-02 | FVSA | Futures | 3247.48 | 3351.05 | 3247.48 | 3306.66 | 1896.0 |
| 2013-07-02 | FXXP | Futures | 211.1 | 211.5 | 209.8 | 210.5 | 4538.0 |
| 2013-07-02 | G | Futures | 94.39 | 94.97 | 94.34 | 94.8 | 161810.0 |
| 2013-07-02 | GF | Futures | 254.418 | 255.724 | 253.534 | 254.25 | 2657.0 |
| 2013-07-02 | GSCI | Futures | 1012.36 | 1022.4 | 1012.36 | 1020.18 | 1456.0 |
| 2013-07-02 | HE | Futures | 100.103 | 100.413 | 99.173 | 99.819 | 21396.0 |
| 2013-07-02 | HG | Futures | 4.0006 | 4.0171 | 3.9677 | 3.988 | 53679.0 |
| 2013-07-02 | HH | Futures | 40.145 | 40.768 | 40.145 | 40.702 | 643.0 |
> showing 50 of 104 rows — these rows as CSV