PREVIEW / futures_daily / 2014-07-11
file: by_date/futures_daily/2014/2014-07-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-07-11 | ES | Futures | 2033.18 | 2039.68 | 2028.77 | 2038.64 | 1364154.0 |
| 2014-07-11 | NQ | Futures | 4470.03 | 4498.58 | 4467.14 | 4496.85 | 200877.0 |
| 2014-07-11 | YM | Futures | 16987.3 | 17044.8 | 16936.8 | 17032.7 | 104397.0 |
| 2014-07-11 | CL | Futures | 187.89 | 188.0 | 183.47 | 184.18 | 272550.0 |
| 2014-07-11 | GC | Futures | 1761.0 | 1766.1 | 1758.5 | 1762.1 | 97170.0 |
| 2014-07-11 | ZN | Futures | 116.827514 | 117.060936 | 116.739981 | 116.915047 | 662222.0 |
| 2014-07-11 | A6 | Futures | 0.90369 | 0.90533 | 0.90214 | 0.9033 | 55217.0 |
| 2014-07-11 | AD | Futures | 0.95186 | 0.95389 | 0.94434 | 0.94465 | 75963.0 |
| 2014-07-11 | ALI | Futures | 2858.11 | 2858.11 | 2858.11 | 2858.11 | 5.0 |
| 2014-07-11 | B | Futures | 114.58 | 114.73 | 112.5 | 112.81 | 356173.0 |
| 2014-07-11 | B6 | Futures | 1.8004 | 1.8021 | 1.7956 | 1.7985 | 55859.0 |
| 2014-07-11 | BR | Futures | 0.23408 | 0.23426 | 0.2335 | 0.23405 | 402.0 |
| 2014-07-11 | BZ | Futures | 115.14 | 115.3 | 113.22 | 113.53 | 19639.0 |
| 2014-07-11 | C | Futures | 2012.0 | 2028.0 | 2005.0 | 2024.0 | 5928.0 |
| 2014-07-11 | CB | Futures | 117.408 | 118.554 | 117.31 | 118.554 | 35.0 |
| 2014-07-11 | CC | Futures | 2262.0 | 2273.0 | 2254.0 | 2270.0 | 7718.0 |
| 2014-07-11 | CSC | Futures | 4.272 | 4.287 | 4.238 | 4.243 | 16.0 |
| 2014-07-11 | CT | Futures | 86.63 | 87.56 | 86.11 | 86.72 | 42.0 |
| 2014-07-11 | DC | Futures | 34.39 | 34.82 | 34.14 | 34.39 | 230.0 |
| 2014-07-11 | DX | Futures | 76.114 | 76.204 | 76.005 | 76.156 | 11980.0 |
| 2014-07-11 | E1 | Futures | 1.43711 | 1.43904 | 1.4357 | 1.43763 | 20713.0 |
| 2014-07-11 | E6 | Futures | 1.60601 | 1.60801 | 1.60412 | 1.60613 | 96545.0 |
| 2014-07-11 | E7 | Futures | 1.5954 | 1.5974 | 1.5935 | 1.5957 | 1099.0 |
| 2014-07-11 | ED | Futures | 95.4115 | 95.4162 | 95.4115 | 95.4115 | 83613.0 |
| 2014-07-11 | ER | Futures | 97.906 | 97.906 | 97.896 | 97.901 | 24092.0 |
| 2014-07-11 | EW | Futures | 1464.6 | 1469.4 | 1457.9 | 1463.8 | 13047.0 |
| 2014-07-11 | FBTP | Futures | 90.91 | 91.3 | 90.69 | 91.26 | 81165.0 |
| 2014-07-11 | FBTS | Futures | 98.134 | 98.232 | 98.108 | 98.223 | 16812.0 |
| 2014-07-11 | FCE | Futures | 3441.1 | 3458.3 | 3431.9 | 3447.5 | 100051.0 |
| 2014-07-11 | FDAX | Futures | 10671.7 | 10695.9 | 10601.2 | 10628.2 | 85179.0 |
| 2014-07-11 | FESX | Futures | 2272.1 | 2281.4 | 2258.4 | 2265.6 | 805532.0 |
| 2014-07-11 | FGBL | Futures | 128.38 | 128.45 | 128.16 | 128.38 | 464628.0 |
| 2014-07-11 | FGBM | Futures | 121.67 | 121.74 | 121.61 | 121.72 | 291179.0 |
| 2014-07-11 | FGBS | Futures | 110.778 | 110.788 | 110.773 | 110.783 | 146356.0 |
| 2014-07-11 | FGBX | Futures | 134.14 | 134.39 | 133.88 | 134.16 | 15051.0 |
| 2014-07-11 | FMWO | Futures | 5758.8 | 5758.8 | 5752.5 | 5752.5 | 20.0 |
| 2014-07-11 | FOAT | Futures | 118.08 | 118.18 | 117.91 | 118.12 | 48031.0 |
| 2014-07-11 | FTDX | Futures | 1184.6 | 1193.1 | 1182.8 | 1189.3 | 431.0 |
| 2014-07-11 | FTI | Futures | 349.09 | 349.52 | 347.57 | 348.35 | 168.0 |
| 2014-07-11 | FTUK | Futures | 5101.2 | 5113.1 | 5087.7 | 5098.9 | 67161.0 |
| 2014-07-11 | FVSA | Futures | 1358.13 | 1396.81 | 1319.44 | 1383.91 | 9616.0 |
| 2014-07-11 | FXXP | Futures | 253.2 | 254.1 | 252.2 | 252.7 | 5038.0 |
| 2014-07-11 | G | Futures | 94.25 | 94.48 | 94.08 | 94.44 | 110222.0 |
| 2014-07-11 | GF | Futures | 322.266 | 323.837 | 318.243 | 322.42 | 8813.0 |
| 2014-07-11 | GSCI | Futures | 1064.15 | 1064.15 | 1052.94 | 1053.86 | 1532.0 |
| 2014-07-11 | HE | Futures | 133.905 | 135.348 | 132.882 | 135.033 | 22274.0 |
| 2014-07-11 | HG | Futures | 4.181 | 4.1855 | 4.1497 | 4.1784 | 37506.0 |
| 2014-07-11 | HH | Futures | 52.135 | 52.426 | 51.971 | 52.426 | 418.0 |
| 2014-07-11 | HO | Futures | 2.3235 | 2.3235 | 2.286 | 2.2943 | 28479.0 |
| 2014-07-11 | HRC | Futures | 2457.6 | 2457.6 | 2457.6 | 2457.6 | 0.0 |
> showing 50 of 101 rows — these rows as CSV