PREVIEW / futures_daily / 2014-04-15
file: by_date/futures_daily/2014/2014-04-15.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-15 | ES | Futures | 1888.21 | 1907.87 | 1871.92 | 1903.22 | 2609484.0 |
| 2014-04-15 | NQ | Futures | 3995.49 | 4030.02 | 3919.22 | 4018.8 | 597761.0 |
| 2014-04-15 | YM | Futures | 16166.0 | 16323.6 | 16053.5 | 16271.4 | 277403.0 |
| 2014-04-15 | CL | Futures | 186.25 | 187.01 | 185.06 | 186.56 | 138800.0 |
| 2014-04-15 | GC | Futures | 1747.8 | 1750.3 | 1692.3 | 1713.3 | 188991.0 |
| 2014-04-15 | ZN | Futures | 115.431775 | 115.779461 | 115.301393 | 115.518697 | 1383060.0 |
| 2014-04-15 | A6 | Futures | 0.90096 | 0.90154 | 0.89318 | 0.89491 | 68719.0 |
| 2014-04-15 | AD | Futures | 0.92343 | 0.92373 | 0.91927 | 0.92211 | 39154.0 |
| 2014-04-15 | B | Futures | 112.39 | 113.34 | 111.88 | 112.94 | 234241.0 |
| 2014-04-15 | B6 | Futures | 1.757 | 1.7599 | 1.7489 | 1.7565 | 72662.0 |
| 2014-04-15 | BFX | Futures | 3664.4 | 3666.8 | 3614.5 | 3614.5 | 879.0 |
| 2014-04-15 | BR | Futures | 0.23471 | 0.235 | 0.23231 | 0.23249 | 1704.0 |
| 2014-04-15 | BZ | Futures | 114.58 | 115.5 | 114.03 | 115.11 | 7682.0 |
| 2014-04-15 | C | Futures | 1960.0 | 1966.0 | 1949.0 | 1950.0 | 3148.0 |
| 2014-04-15 | CB | Futures | 93.161 | 93.161 | 92.654 | 92.908 | 9.0 |
| 2014-04-15 | CC | Futures | 2209.0 | 2217.0 | 2188.0 | 2198.0 | 9952.0 |
| 2014-04-15 | CNH | Futures | 7.152 | 7.152 | 7.1463 | 7.1463 | 2.0 |
| 2014-04-15 | CSC | Futures | 4.404 | 4.45 | 4.404 | 4.404 | 29.0 |
| 2014-04-15 | CT | Futures | 102.28 | 102.93 | 100.19 | 101.07 | 9182.0 |
| 2014-04-15 | DC | Futures | 35.27 | 35.69 | 35.06 | 35.13 | 164.0 |
| 2014-04-15 | DX | Futures | 75.86 | 75.988 | 75.774 | 75.896 | 11180.0 |
| 2014-04-15 | E1 | Futures | 1.45907 | 1.46189 | 1.45599 | 1.45843 | 21900.0 |
| 2014-04-15 | E6 | Futures | 1.63115 | 1.63281 | 1.62761 | 1.63009 | 123820.0 |
| 2014-04-15 | E7 | Futures | 1.6204 | 1.6219 | 1.617 | 1.6192 | 2979.0 |
| 2014-04-15 | EBM | Futures | 300.86 | 312.84 | 300.16 | 311.78 | 28678.0 |
| 2014-04-15 | ED | Futures | 95.4043 | 95.4138 | 95.4043 | 95.4091 | 80700.0 |
| 2014-04-15 | ER | Futures | 97.842 | 97.852 | 97.842 | 97.852 | 34004.0 |
| 2014-04-15 | EW | Futures | 1364.4 | 1378.3 | 1348.7 | 1375.5 | 24691.0 |
| 2014-04-15 | FBTP | Futures | 88.16 | 88.67 | 88.12 | 88.57 | 40713.0 |
| 2014-04-15 | FBTS | Futures | 97.513 | 97.583 | 97.487 | 97.548 | 11556.0 |
| 2014-04-15 | FCE | Futures | 3431.3 | 3447.6 | 3383.3 | 3402.0 | 165648.0 |
| 2014-04-15 | FDAX | Futures | 10335.3 | 10339.7 | 10052.0 | 10145.3 | 171606.0 |
| 2014-04-15 | FESX | Futures | 2207.5 | 2213.3 | 2162.3 | 2178.8 | 1245489.0 |
| 2014-04-15 | FGBL | Futures | 124.16 | 124.82 | 124.12 | 124.74 | 652073.0 |
| 2014-04-15 | FGBM | Futures | 119.84 | 120.16 | 119.81 | 120.11 | 397451.0 |
| 2014-04-15 | FGBS | Futures | 110.538 | 110.623 | 110.538 | 110.603 | 309714.0 |
| 2014-04-15 | FGBX | Futures | 127.41 | 128.86 | 127.37 | 128.66 | 15173.0 |
| 2014-04-15 | FMWO | Futures | 5420.7 | 5420.7 | 5420.7 | 5420.7 | 0.0 |
| 2014-04-15 | FOAT | Futures | 113.35 | 114.05 | 113.35 | 114.02 | 51677.0 |
| 2014-04-15 | FTDX | Futures | 1109.1 | 1110.0 | 1055.2 | 1084.2 | 445.0 |
| 2014-04-15 | FTI | Futures | 336.94 | 337.76 | 332.87 | 334.73 | 47507.0 |
| 2014-04-15 | FTUK | Futures | 4975.0 | 4988.0 | 4919.7 | 4946.4 | 107458.0 |
| 2014-04-15 | FVSA | Futures | 1861.24 | 1923.12 | 1842.2 | 1918.36 | 12308.0 |
| 2014-04-15 | FXXP | Futures | 244.5 | 244.7 | 240.3 | 242.0 | 11266.0 |
| 2014-04-15 | G | Futures | 94.34 | 94.63 | 94.07 | 94.52 | 135564.0 |
| 2014-04-15 | GF | Futures | 287.195 | 287.195 | 285.007 | 286.121 | 2058.0 |
| 2014-04-15 | GSCI | Futures | 1092.01 | 1092.84 | 1084.39 | 1091.02 | 323.0 |
| 2014-04-15 | HE | Futures | 141.934 | 143.48 | 139.659 | 141.73 | 253.0 |
| 2014-04-15 | HG | Futures | 3.8418 | 3.8614 | 3.7582 | 3.786 | 66368.0 |
| 2014-04-15 | HH | Futures | 58.415 | 58.503 | 57.288 | 57.807 | 353.0 |
> showing 50 of 104 rows — these rows as CSV