PREVIEW / futures_daily / 2016-08-04
file: by_date/futures_daily/2016/2016-08-04.parquet size: 9 KB rows: 108
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 |
|---|---|---|---|---|---|---|---|
| 2016-08-04 | ES | Futures | 2328.62 | 2336.72 | 2325.65 | 2331.32 | 1239577.0 |
| 2016-08-04 | NQ | Futures | 5571.29 | 5595.46 | 5557.74 | 5591.63 | 167881.0 |
| 2016-08-04 | YM | Futures | 19087.5 | 19152.3 | 19063.5 | 19086.5 | 103806.0 |
| 2016-08-04 | CL | Futures | 46.65 | 47.7 | 45.83 | 47.53 | 598836.0 |
| 2016-08-04 | GC | Futures | 1750.9 | 1759.5 | 1738.6 | 1754.4 | 170002.0 |
| 2016-08-04 | ZN | Futures | 128.04493 | 128.542924 | 127.924204 | 128.407107 | 1115628.0 |
| 2016-08-04 | A6 | Futures | 0.771 | 0.7764 | 0.7707 | 0.77568 | 79175.0 |
| 2016-08-04 | AD | Futures | 0.78293 | 0.78769 | 0.78201 | 0.78667 | 61050.0 |
| 2016-08-04 | ALI | Futures | 2125.74 | 2125.74 | 2125.74 | 2125.74 | 0.0 |
| 2016-08-04 | B | Futures | 34.27 | 35.05 | 33.6 | 35.01 | 276418.0 |
| 2016-08-04 | B6 | Futures | 1.4051 | 1.4095 | 1.3822 | 1.3836 | 166483.0 |
| 2016-08-04 | BR | Futures | 0.2024 | 0.20659 | 0.2024 | 0.20579 | 1247.0 |
| 2016-08-04 | BZ | Futures | 34.11 | 34.86 | 33.43 | 34.83 | 25204.0 |
| 2016-08-04 | C | Futures | 2531.0 | 2565.0 | 2516.0 | 2560.0 | 12825.0 |
| 2016-08-04 | CB | Futures | 269.607 | 271.952 | 269.607 | 270.78 | 35.0 |
| 2016-08-04 | CC | Futures | 2194.0 | 2200.0 | 2159.0 | 2193.0 | 26591.0 |
| 2016-08-04 | CSC | Futures | 3.826 | 3.836 | 3.792 | 3.815 | 107.0 |
| 2016-08-04 | CT | Futures | 83.29 | 86.27 | 83.29 | 85.93 | 67.0 |
| 2016-08-04 | DC | Futures | 30.69 | 30.83 | 30.33 | 30.56 | 426.0 |
| 2016-08-04 | DX | Futures | 88.811 | 89.169 | 88.714 | 89.022 | 13791.0 |
| 2016-08-04 | E1 | Futures | 1.29032 | 1.29107 | 1.28731 | 1.28882 | 12515.0 |
| 2016-08-04 | E6 | Futures | 1.30028 | 1.30109 | 1.29615 | 1.29801 | 107982.0 |
| 2016-08-04 | E7 | Futures | 1.2934 | 1.2941 | 1.2894 | 1.2911 | 1407.0 |
| 2016-08-04 | EBM | Futures | 202.69 | 202.99 | 199.68 | 199.98 | 9281.0 |
| 2016-08-04 | ED | Futures | 95.6557 | 95.6605 | 95.6412 | 95.6557 | 268546.0 |
| 2016-08-04 | ER | Futures | 98.308 | 98.313 | 98.308 | 98.313 | 27748.0 |
| 2016-08-04 | EW | Futures | 1635.3 | 1644.6 | 1634.4 | 1637.0 | 10471.0 |
| 2016-08-04 | FBON | Futures | 123.57 | 124.13 | 123.41 | 124.03 | 256.0 |
| 2016-08-04 | FBTP | Futures | 109.61 | 110.44 | 109.61 | 110.31 | 96038.0 |
| 2016-08-04 | FBTS | Futures | 101.284 | 101.338 | 101.275 | 101.329 | 30848.0 |
| 2016-08-04 | FCE | Futures | 3795.2 | 3807.0 | 3773.0 | 3792.6 | 67925.0 |
| 2016-08-04 | FDAX | Futures | 10889.9 | 10938.8 | 10828.1 | 10869.1 | 82039.0 |
| 2016-08-04 | FDXM | Futures | 10609.0 | 10662.9 | 10554.0 | 10594.5 | 22643.0 |
| 2016-08-04 | FESX | Futures | 2292.2 | 2306.3 | 2282.1 | 2290.7 | 913531.0 |
| 2016-08-04 | FEU3 | Futures | 98.966 | 98.966 | 98.966 | 98.966 | 24.0 |
| 2016-08-04 | FGBL | Futures | 149.99 | 150.89 | 149.87 | 150.8 | 660720.0 |
| 2016-08-04 | FGBM | Futures | 128.69 | 128.97 | 128.67 | 128.94 | 412430.0 |
| 2016-08-04 | FGBS | Futures | 111.832 | 111.877 | 111.817 | 111.867 | 207988.0 |
| 2016-08-04 | FGBX | Futures | 188.36 | 190.56 | 187.75 | 190.33 | 36691.0 |
| 2016-08-04 | FMWO | Futures | 5699.0 | 5707.5 | 5699.0 | 5703.9 | 94.0 |
| 2016-08-04 | FOAT | Futures | 137.97 | 138.81 | 137.84 | 138.75 | 149781.0 |
| 2016-08-04 | FTDX | Futures | 1652.5 | 1652.5 | 1629.8 | 1635.6 | 118.0 |
| 2016-08-04 | FTI | Futures | 395.21 | 398.99 | 394.67 | 397.41 | 26407.0 |
| 2016-08-04 | FTUK | Futures | 5510.2 | 5601.9 | 5479.7 | 5580.6 | 159550.0 |
| 2016-08-04 | FVSA | Futures | 2298.68 | 2303.56 | 2157.15 | 2201.07 | 26717.0 |
| 2016-08-04 | FXXP | Futures | 272.6 | 273.2 | 271.1 | 272.5 | 20707.0 |
| 2016-08-04 | G | Futures | 114.88 | 116.42 | 114.68 | 116.34 | 245061.0 |
| 2016-08-04 | GF | Futures | 294.333 | 299.225 | 293.235 | 294.682 | 3387.0 |
| 2016-08-04 | GSCI | Futures | 482.52 | 490.34 | 480.8 | 489.55 | 473.0 |
| 2016-08-04 | HE | Futures | 82.011 | 82.045 | 79.658 | 80.938 | 16481.0 |
> showing 50 of 108 rows — these rows as CSV