PREVIEW / futures_daily / 2014-04-17
file: by_date/futures_daily/2014/2014-04-17.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 |
|---|---|---|---|---|---|---|---|
| 2014-04-17 | ES | Futures | 1916.67 | 1928.31 | 1911.23 | 1922.36 | 1254621.0 |
| 2014-04-17 | NQ | Futures | 4035.2 | 4077.79 | 4020.23 | 4055.63 | 269150.0 |
| 2014-04-17 | YM | Futures | 16375.9 | 16453.2 | 16345.7 | 16410.0 | 125082.0 |
| 2014-04-17 | CL | Futures | 186.65 | 188.23 | 186.11 | 187.23 | 172449.0 |
| 2014-04-17 | GC | Futures | 1715.6 | 1718.7 | 1703.4 | 1704.8 | 91061.0 |
| 2014-04-17 | ZN | Futures | 115.344854 | 115.475236 | 114.620508 | 114.736403 | 1095096.0 |
| 2014-04-17 | A6 | Futures | 0.89664 | 0.89875 | 0.89203 | 0.8926 | 53176.0 |
| 2014-04-17 | AD | Futures | 0.91927 | 0.92191 | 0.91897 | 0.92008 | 31317.0 |
| 2014-04-17 | B | Futures | 113.19 | 113.8 | 112.65 | 113.12 | 163987.0 |
| 2014-04-17 | B6 | Futures | 1.7647 | 1.7693 | 1.7635 | 1.7648 | 52593.0 |
| 2014-04-17 | BFX | Futures | 3674.7 | 3700.8 | 3674.7 | 3700.8 | 1.0 |
| 2014-04-17 | BR | Futures | 0.23265 | 0.23313 | 0.23115 | 0.23128 | 35.0 |
| 2014-04-17 | BZ | Futures | 115.39 | 115.97 | 114.81 | 115.29 | 6076.0 |
| 2014-04-17 | C | Futures | 1935.0 | 1966.0 | 1935.0 | 1963.0 | 11236.0 |
| 2014-04-17 | CB | Futures | 92.654 | 93.542 | 92.654 | 93.542 | 48.0 |
| 2014-04-17 | CC | Futures | 2195.0 | 2228.0 | 2192.0 | 2227.0 | 10457.0 |
| 2014-04-17 | CNH | Futures | 7.142 | 7.1422 | 7.1393 | 7.1408 | 20.0 |
| 2014-04-17 | CSC | Futures | 4.421 | 4.444 | 4.386 | 4.41 | 88.0 |
| 2014-04-17 | CT | Futures | 102.24 | 102.64 | 101.21 | 101.35 | 10050.0 |
| 2014-04-17 | DC | Futures | 35.3 | 35.56 | 35.1 | 35.29 | 195.0 |
| 2014-04-17 | DX | Futures | 75.879 | 75.955 | 75.67 | 75.91 | 7529.0 |
| 2014-04-17 | E1 | Futures | 1.45599 | 1.46266 | 1.45291 | 1.45535 | 19995.0 |
| 2014-04-17 | E6 | Futures | 1.6308 | 1.6367 | 1.63021 | 1.63115 | 108892.0 |
| 2014-04-17 | E7 | Futures | 1.62 | 1.6258 | 1.6193 | 1.6203 | 2077.0 |
| 2014-04-17 | EBM | Futures | 307.2 | 307.91 | 305.09 | 306.5 | 13680.0 |
| 2014-04-17 | ED | Futures | 95.4091 | 95.4138 | 95.4043 | 95.4091 | 88831.0 |
| 2014-04-17 | ER | Futures | 97.842 | 97.847 | 97.832 | 97.837 | 30480.0 |
| 2014-04-17 | EW | Futures | 1383.6 | 1394.8 | 1380.9 | 1390.4 | 14021.0 |
| 2014-04-17 | FBTP | Futures | 88.74 | 88.89 | 88.44 | 88.55 | 35341.0 |
| 2014-04-17 | FBTS | Futures | 97.557 | 97.592 | 97.478 | 97.504 | 5646.0 |
| 2014-04-17 | FCE | Futures | 3448.0 | 3485.7 | 3437.3 | 3468.2 | 105319.0 |
| 2014-04-17 | FDAX | Futures | 10301.6 | 10473.8 | 10261.3 | 10412.6 | 94174.0 |
| 2014-04-17 | FESX | Futures | 2213.3 | 2239.1 | 2200.3 | 2224.8 | 827018.0 |
| 2014-04-17 | FGBL | Futures | 124.64 | 124.68 | 123.96 | 124.34 | 470543.0 |
| 2014-04-17 | FGBM | Futures | 120.02 | 120.06 | 119.66 | 119.82 | 316580.0 |
| 2014-04-17 | FGBS | Futures | 110.583 | 110.598 | 110.493 | 110.523 | 221709.0 |
| 2014-04-17 | FGBX | Futures | 128.53 | 128.63 | 127.39 | 128.07 | 12916.0 |
| 2014-04-17 | FMWO | Futures | 5527.9 | 5527.9 | 5527.9 | 5527.9 | 0.0 |
| 2014-04-17 | FOAT | Futures | 113.93 | 114.02 | 113.38 | 113.68 | 50441.0 |
| 2014-04-17 | FTDX | Futures | 1117.0 | 1136.2 | 1113.3 | 1123.1 | 149.0 |
| 2014-04-17 | FTI | Futures | 337.89 | 339.4 | 335.55 | 338.02 | 33531.0 |
| 2014-04-17 | FTUK | Futures | 4984.1 | 5037.1 | 4961.6 | 5013.9 | 88323.0 |
| 2014-04-17 | FVSA | Futures | 1813.64 | 1827.92 | 1780.31 | 1780.31 | 9117.0 |
| 2014-04-17 | FXXP | Futures | 245.0 | 247.0 | 244.3 | 246.5 | 6451.0 |
| 2014-04-17 | G | Futures | 94.25 | 94.31 | 93.75 | 94.07 | 114770.0 |
| 2014-04-17 | GF | Futures | 285.603 | 286.081 | 283.296 | 283.375 | 3114.0 |
| 2014-04-17 | GSCI | Futures | 1093.67 | 1098.14 | 1092.26 | 1095.99 | 95.0 |
| 2014-04-17 | HE | Futures | 141.963 | 144.355 | 141.963 | 144.063 | 374.0 |
| 2014-04-17 | HG | Futures | 3.838 | 3.8709 | 3.8304 | 3.8589 | 28253.0 |
| 2014-04-17 | HH | Futures | 57.516 | 60.009 | 56.769 | 60.009 | 2267.0 |
> showing 50 of 104 rows — these rows as CSV