PREVIEW / futures_daily / 2014-06-11
file: by_date/futures_daily/2014/2014-06-11.parquet size: 9 KB rows: 101
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-06-11 | ES | Futures | 2018.32 | 2018.58 | 2005.64 | 2011.34 | 1348569.0 |
| 2014-06-11 | NQ | Futures | 4376.5 | 4379.67 | 4350.6 | 4372.18 | 203579.0 |
| 2014-06-11 | YM | Futures | 17027.6 | 17027.6 | 16894.4 | 16935.8 | 7967.0 |
| 2014-06-11 | CL | Futures | 189.72 | 190.65 | 189.48 | 189.9 | 187728.0 |
| 2014-06-11 | GC | Futures | 1660.6 | 1667.4 | 1657.4 | 1661.7 | 77036.0 |
| 2014-06-11 | ZN | Futures | 115.718761 | 116.010538 | 115.587462 | 115.850061 | 1081720.0 |
| 2014-06-11 | A6 | Futures | 0.89992 | 0.90311 | 0.89905 | 0.90098 | 60095.0 |
| 2014-06-11 | AD | Futures | 0.92931 | 0.93297 | 0.92911 | 0.93226 | 34655.0 |
| 2014-06-11 | ALI | Futures | 2812.0 | 2812.0 | 2803.47 | 2809.16 | 15.0 |
| 2014-06-11 | B | Futures | 113.9 | 114.69 | 113.85 | 114.47 | 203111.0 |
| 2014-06-11 | B6 | Futures | 1.7599 | 1.766 | 1.7584 | 1.7641 | 101969.0 |
| 2014-06-11 | BR | Futures | 0.2312 | 0.23147 | 0.23033 | 0.23044 | 144.0 |
| 2014-06-11 | BZ | Futures | 114.89 | 115.68 | 114.89 | 115.47 | 12126.0 |
| 2014-06-11 | C | Futures | 2034.0 | 2062.0 | 2020.0 | 2058.0 | 7725.0 |
| 2014-06-11 | CB | Futures | 109.149 | 109.554 | 108.995 | 109.554 | 10.0 |
| 2014-06-11 | CC | Futures | 2265.0 | 2291.0 | 2245.0 | 2279.0 | 25305.0 |
| 2014-06-11 | CNH | Futures | 7.1668 | 7.1691 | 7.1623 | 7.1623 | 20.0 |
| 2014-06-11 | CSC | Futures | 4.5 | 4.533 | 4.5 | 4.533 | 41.0 |
| 2014-06-11 | CT | Futures | 97.33 | 97.85 | 95.8 | 96.29 | 21288.0 |
| 2014-06-11 | DC | Futures | 35.53 | 35.88 | 35.53 | 35.74 | 127.0 |
| 2014-06-11 | DX | Futures | 76.821 | 76.897 | 76.683 | 76.795 | 17975.0 |
| 2014-06-11 | E1 | Futures | 1.42724 | 1.42853 | 1.42365 | 1.42532 | 12918.0 |
| 2014-06-11 | E6 | Futures | 1.59846 | 1.59987 | 1.59562 | 1.59645 | 139176.0 |
| 2014-06-11 | E7 | Futures | 1.5882 | 1.5894 | 1.5853 | 1.586 | 1778.0 |
| 2014-06-11 | ED | Futures | 95.4067 | 95.4115 | 95.4067 | 95.4115 | 79916.0 |
| 2014-06-11 | ER | Futures | 97.881 | 97.911 | 97.881 | 97.906 | 170394.0 |
| 2014-06-11 | EW | Futures | 1455.2 | 1457.8 | 1450.7 | 1456.7 | 8946.0 |
| 2014-06-11 | FBTP | Futures | 90.88 | 91.15 | 90.72 | 91.04 | 55855.0 |
| 2014-06-11 | FBTS | Futures | 97.912 | 98.01 | 97.894 | 97.983 | 18071.0 |
| 2014-06-11 | FCE | Futures | 3664.3 | 3664.3 | 3629.9 | 3637.5 | 97655.0 |
| 2014-06-11 | FDAX | Futures | 11065.2 | 11070.2 | 10954.8 | 10982.9 | 91442.0 |
| 2014-06-11 | FESX | Futures | 2379.2 | 2379.2 | 2356.9 | 2361.2 | 137992.0 |
| 2014-06-11 | FEU3 | Futures | 98.512 | 98.527 | 98.512 | 98.527 | 322.0 |
| 2014-06-11 | FGBL | Futures | 125.99 | 126.35 | 125.72 | 126.24 | 715725.0 |
| 2014-06-11 | FGBM | Futures | 120.84 | 121.06 | 120.76 | 121.02 | 449448.0 |
| 2014-06-11 | FGBS | Futures | 110.688 | 110.748 | 110.688 | 110.738 | 347244.0 |
| 2014-06-11 | FGBX | Futures | 129.19 | 129.8 | 128.91 | 129.59 | 15705.0 |
| 2014-06-11 | FMWO | Futures | 5751.3 | 5751.3 | 5751.3 | 5751.3 | 0.0 |
| 2014-06-11 | FOAT | Futures | 115.88 | 116.15 | 115.72 | 116.05 | 75341.0 |
| 2014-06-11 | FTDX | Futures | 1230.0 | 1231.9 | 1229.6 | 1231.9 | 1528.0 |
| 2014-06-11 | FTI | Futures | 359.04 | 359.13 | 356.93 | 358.18 | 937.0 |
| 2014-06-11 | FTUK | Futures | 5241.9 | 5243.8 | 5212.3 | 5223.1 | 13884.0 |
| 2014-06-11 | FVSA | Futures | 1326.18 | 1354.2 | 1316.84 | 1349.53 | 13154.0 |
| 2014-06-11 | FXXP | Futures | 261.7 | 261.7 | 261.0 | 261.1 | 3566.0 |
| 2014-06-11 | G | Futures | 93.03 | 93.35 | 92.84 | 93.29 | 156247.0 |
| 2014-06-11 | GF | Futures | 313.875 | 314.067 | 310.274 | 310.925 | 4233.0 |
| 2014-06-11 | GSCI | Futures | 1079.24 | 1081.07 | 1077.41 | 1077.82 | 1174.0 |
| 2014-06-11 | HE | Futures | 132.286 | 132.759 | 130.918 | 131.549 | 19020.0 |
| 2014-06-11 | HG | Futures | 3.9043 | 3.9228 | 3.873 | 3.8851 | 53665.0 |
| 2014-06-11 | HH | Futures | 57.627 | 57.842 | 57.145 | 57.145 | 2216.0 |
> showing 50 of 101 rows — these rows as CSV