PREVIEW / futures_daily / 2016-07-06
file: by_date/futures_daily/2016/2016-07-06.parquet size: 9 KB rows: 109
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-07-06 | ES | Futures | 2250.08 | 2261.41 | 2230.37 | 2260.87 | 2054794.0 |
| 2016-07-06 | NQ | Futures | 5193.51 | 5234.17 | 5146.06 | 5233.0 | 253791.0 |
| 2016-07-06 | YM | Futures | 18563.2 | 18632.1 | 18402.3 | 18627.9 | 179302.0 |
| 2016-07-06 | CL | Futures | 54.4 | 55.7 | 53.34 | 55.09 | 607663.0 |
| 2016-07-06 | GC | Futures | 1747.1 | 1772.2 | 1744.9 | 1758.8 | 237060.0 |
| 2016-07-06 | ZN | Futures | 129.26728 | 129.644548 | 129.010737 | 129.101281 | 1433749.0 |
| 2016-07-06 | A6 | Futures | 0.75717 | 0.76398 | 0.75167 | 0.76297 | 113004.0 |
| 2016-07-06 | AD | Futures | 0.7882 | 0.79045 | 0.7838 | 0.78994 | 63115.0 |
| 2016-07-06 | ALI | Futures | 2154.13 | 2154.45 | 2154.13 | 2154.45 | 3.0 |
| 2016-07-06 | B | Futures | 38.37 | 39.37 | 37.66 | 38.96 | 279124.0 |
| 2016-07-06 | B6 | Futures | 1.3734 | 1.3746 | 1.35 | 1.3636 | 150859.0 |
| 2016-07-06 | BFX | Futures | 3786.8 | 3799.7 | 3786.8 | 3799.7 | 4.0 |
| 2016-07-06 | BR | Futures | 0.19677 | 0.19751 | 0.19607 | 0.19651 | 33.0 |
| 2016-07-06 | BZ | Futures | 38.27 | 39.21 | 37.52 | 38.81 | 33332.0 |
| 2016-07-06 | C | Futures | 2616.0 | 2646.0 | 2611.0 | 2641.0 | 2191.0 |
| 2016-07-06 | CB | Futures | 280.743 | 281.329 | 275.498 | 275.498 | 36.0 |
| 2016-07-06 | CC | Futures | 2248.0 | 2264.0 | 2233.0 | 2258.0 | 11827.0 |
| 2016-07-06 | CNH | Futures | 7.2665 | 7.2665 | 7.2624 | 7.2624 | 1.0 |
| 2016-07-06 | CSC | Futures | 3.532 | 3.614 | 3.509 | 3.589 | 60.0 |
| 2016-07-06 | CT | Futures | 74.4 | 74.4 | 73.45 | 74.04 | 8.0 |
| 2016-07-06 | DC | Futures | 28.4 | 29.14 | 28.15 | 28.87 | 210.0 |
| 2016-07-06 | DX | Futures | 89.597 | 89.871 | 89.327 | 89.407 | 31233.0 |
| 2016-07-06 | E1 | Futures | 1.28606 | 1.29094 | 1.28193 | 1.29057 | 15859.0 |
| 2016-07-06 | E6 | Futures | 1.29172 | 1.29725 | 1.28753 | 1.29621 | 144979.0 |
| 2016-07-06 | E7 | Futures | 1.2852 | 1.2903 | 1.2807 | 1.2893 | 3602.0 |
| 2016-07-06 | EBM | Futures | 186.45 | 187.05 | 184.04 | 184.94 | 11734.0 |
| 2016-07-06 | ED | Futures | 95.8341 | 95.8438 | 95.8149 | 95.8245 | 298705.0 |
| 2016-07-06 | ER | Futures | 98.337 | 98.342 | 98.332 | 98.337 | 42045.0 |
| 2016-07-06 | EW | Futures | 1568.8 | 1577.5 | 1555.4 | 1575.9 | 19191.0 |
| 2016-07-06 | FBON | Futures | 122.58 | 122.99 | 122.25 | 122.55 | 328.0 |
| 2016-07-06 | FBTP | Futures | 109.13 | 109.77 | 109.01 | 109.36 | 90868.0 |
| 2016-07-06 | FBTS | Futures | 101.293 | 101.32 | 101.275 | 101.293 | 18320.0 |
| 2016-07-06 | FCE | Futures | 3601.2 | 3619.1 | 3537.6 | 3559.4 | 134831.0 |
| 2016-07-06 | FDAX | Futures | 10043.3 | 10132.7 | 9885.8 | 9958.7 | 121988.0 |
| 2016-07-06 | FDXM | Futures | 9795.8 | 9876.7 | 9637.1 | 9707.1 | 29466.0 |
| 2016-07-06 | FESX | Futures | 2178.7 | 2193.6 | 2141.1 | 2156.8 | 1842707.0 |
| 2016-07-06 | FGBL | Futures | 151.15 | 151.29 | 150.79 | 150.92 | 612857.0 |
| 2016-07-06 | FGBM | Futures | 129.2 | 129.24 | 129.1 | 129.15 | 468894.0 |
| 2016-07-06 | FGBS | Futures | 111.987 | 112.002 | 111.972 | 111.982 | 249683.0 |
| 2016-07-06 | FGBX | Futures | 192.57 | 193.83 | 191.16 | 191.63 | 35831.0 |
| 2016-07-06 | FMWO | Futures | 5472.9 | 5472.9 | 5414.5 | 5444.9 | 367.0 |
| 2016-07-06 | FOAT | Futures | 138.79 | 139.05 | 138.57 | 138.69 | 95025.0 |
| 2016-07-06 | FTDX | Futures | 1509.8 | 1512.2 | 1487.6 | 1491.5 | 124.0 |
| 2016-07-06 | FTI | Futures | 385.4 | 387.38 | 377.31 | 379.87 | 41160.0 |
| 2016-07-06 | FTUK | Futures | 5419.6 | 5445.5 | 5319.9 | 5352.1 | 181537.0 |
| 2016-07-06 | FVSA | Futures | 2664.81 | 2786.17 | 2624.36 | 2720.43 | 15736.0 |
| 2016-07-06 | FXXP | Futures | 259.1 | 261.0 | 255.2 | 256.7 | 35499.0 |
| 2016-07-06 | G | Futures | 114.97 | 115.5 | 114.8 | 115.03 | 162496.0 |
| 2016-07-06 | GF | Futures | 288.442 | 291.737 | 285.647 | 288.692 | 4981.0 |
| 2016-07-06 | GSCI | Futures | 523.54 | 531.16 | 523.54 | 530.14 | 453.0 |
> showing 50 of 109 rows — these rows as CSV