PREVIEW / futures_daily / 2014-03-14
file: by_date/futures_daily/2014/2014-03-14.parquet size: 9 KB rows: 102
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-03-14 | ES | Futures | 1903.73 | 1910.2 | 1895.46 | 1896.49 | 2197833.0 |
| 2014-03-14 | NQ | Futures | 4197.5 | 4206.71 | 4166.14 | 4168.15 | 368543.0 |
| 2014-03-14 | YM | Futures | 16114.8 | 16165.0 | 16042.5 | 16057.6 | 168669.0 |
| 2014-03-14 | CL | Futures | 174.74 | 176.58 | 174.44 | 175.89 | 126249.0 |
| 2014-03-14 | GC | Futures | 1807.1 | 1830.2 | 1803.6 | 1817.8 | 185259.0 |
| 2014-03-14 | ZN | Futures | 115.533183 | 115.895356 | 115.402801 | 115.576644 | 1725502.0 |
| 2014-03-14 | A6 | Futures | 0.86282 | 0.86397 | 0.85898 | 0.86148 | 83156.0 |
| 2014-03-14 | AD | Futures | 0.9141 | 0.9141 | 0.91055 | 0.91157 | 81987.0 |
| 2014-03-14 | B | Futures | 109.93 | 111.62 | 109.82 | 111.32 | 221700.0 |
| 2014-03-14 | B6 | Futures | 1.746 | 1.7494 | 1.7422 | 1.7467 | 89368.0 |
| 2014-03-14 | BR | Futures | 0.2193 | 0.2193 | 0.2193 | 0.2193 | 38.0 |
| 2014-03-14 | BZ | Futures | 111.95 | 113.81 | 111.95 | 113.56 | 6857.0 |
| 2014-03-14 | C | Futures | 1962.0 | 1985.0 | 1960.0 | 1969.0 | 10906.0 |
| 2014-03-14 | CB | Futures | 92.908 | 92.908 | 91.892 | 92.146 | 55.0 |
| 2014-03-14 | CC | Futures | 2229.0 | 2242.0 | 2212.0 | 2221.0 | 9252.0 |
| 2014-03-14 | CNH | Futures | 7.0661 | 7.082 | 7.0645 | 7.0778 | 112.0 |
| 2014-03-14 | CSC | Futures | 4.339 | 4.395 | 4.339 | 4.395 | 6.0 |
| 2014-03-14 | CT | Futures | 103.04 | 104.08 | 101.79 | 103.62 | 9212.0 |
| 2014-03-14 | DC | Futures | 34.47 | 35.18 | 34.47 | 35.1 | 185.0 |
| 2014-03-14 | DX | Futures | 75.746 | 75.841 | 75.47 | 75.592 | 28771.0 |
| 2014-03-14 | E1 | Futures | 1.46857 | 1.47562 | 1.46574 | 1.47177 | 38963.0 |
| 2014-03-14 | E6 | Futures | 1.63741 | 1.64532 | 1.6347 | 1.64131 | 232175.0 |
| 2014-03-14 | E7 | Futures | 1.6264 | 1.6344 | 1.6238 | 1.6304 | 5047.0 |
| 2014-03-14 | EBM | Futures | 296.63 | 300.51 | 295.58 | 298.04 | 16506.0 |
| 2014-03-14 | ED | Futures | 95.3851 | 95.3899 | 95.3804 | 95.3851 | 171560.0 |
| 2014-03-14 | ER | Futures | 97.857 | 97.862 | 97.827 | 97.832 | 104496.0 |
| 2014-03-14 | EW | Futures | 1400.5 | 1410.2 | 1393.5 | 1403.3 | 33794.0 |
| 2014-03-14 | FBTP | Futures | 86.08 | 86.49 | 86.08 | 86.42 | 46991.0 |
| 2014-03-14 | FBTS | Futures | 96.976 | 97.047 | 96.95 | 97.003 | 10813.0 |
| 2014-03-14 | FCE | Futures | 3280.1 | 3286.7 | 3247.1 | 3273.5 | 13674.0 |
| 2014-03-14 | FDAX | Futures | 9915.6 | 10087.0 | 9880.7 | 10039.3 | 162874.0 |
| 2014-03-14 | FESX | Futures | 2107.0 | 2117.7 | 2084.7 | 2108.4 | 529046.0 |
| 2014-03-14 | FGBL | Futures | 124.05 | 124.24 | 123.71 | 123.8 | 1024372.0 |
| 2014-03-14 | FGBM | Futures | 119.93 | 120.03 | 119.73 | 119.78 | 541744.0 |
| 2014-03-14 | FGBS | Futures | 110.583 | 110.593 | 110.513 | 110.533 | 364749.0 |
| 2014-03-14 | FGBX | Futures | 126.72 | 127.25 | 126.24 | 126.46 | 25310.0 |
| 2014-03-14 | FMWO | Futures | 5408.2 | 5418.3 | 5406.9 | 5406.9 | 224.0 |
| 2014-03-14 | FOAT | Futures | 112.24 | 112.5 | 112.1 | 112.23 | 62839.0 |
| 2014-03-14 | FTDX | Futures | 1147.5 | 1147.5 | 1121.7 | 1139.1 | 4.0 |
| 2014-03-14 | FTI | Futures | 326.83 | 327.38 | 324.01 | 326.4 | 456.0 |
| 2014-03-14 | FTUK | Futures | 4937.2 | 4947.9 | 4914.0 | 4927.3 | 36340.0 |
| 2014-03-14 | FVSA | Futures | 2046.3 | 2116.52 | 2026.24 | 2076.39 | 39258.0 |
| 2014-03-14 | FXXP | Futures | 237.5 | 238.0 | 236.8 | 237.4 | 7413.0 |
| 2014-03-14 | G | Futures | 93.67 | 94.05 | 93.64 | 93.82 | 170040.0 |
| 2014-03-14 | GF | Futures | 282.077 | 284.278 | 281.557 | 283.718 | 2110.0 |
| 2014-03-14 | GSCI | Futures | 1057.36 | 1064.96 | 1057.36 | 1064.47 | 138.0 |
| 2014-03-14 | HE | Futures | 144.262 | 144.805 | 142.33 | 144.081 | 24453.0 |
| 2014-03-14 | HG | Futures | 3.6954 | 3.7543 | 3.6904 | 3.7391 | 46583.0 |
| 2014-03-14 | HH | Futures | 57.061 | 57.752 | 57.048 | 57.686 | 1305.0 |
| 2014-03-14 | HO | Futures | 2.3111 | 2.3358 | 2.309 | 2.3278 | 19051.0 |
> showing 50 of 102 rows — these rows as CSV