PREVIEW / futures_daily / 2015-08-21
file: by_date/futures_daily/2015/2015-08-21.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 |
|---|---|---|---|---|---|---|---|
| 2015-08-21 | ES | Futures | 2147.46 | 2150.37 | 2084.93 | 2089.43 | 4168331.0 |
| 2015-08-21 | NQ | Futures | 5099.43 | 5100.02 | 4890.74 | 4904.46 | 614566.0 |
| 2015-08-21 | YM | Futures | 17374.1 | 17397.7 | 16872.9 | 16912.0 | 392751.0 |
| 2015-08-21 | CL | Futures | 66.92 | 67.52 | 65.01 | 65.97 | 377181.0 |
| 2015-08-21 | GC | Futures | 1488.8 | 1507.6 | 1482.6 | 1496.9 | 196062.0 |
| 2015-08-21 | ZN | Futures | 122.53834 | 122.925837 | 122.41911 | 122.732088 | 1307004.0 |
| 2015-08-21 | A6 | Futures | 0.72573 | 0.72811 | 0.72088 | 0.72494 | 94794.0 |
| 2015-08-21 | AD | Futures | 0.7813 | 0.78303 | 0.77485 | 0.77618 | 78799.0 |
| 2015-08-21 | ALI | Futures | 2113.75 | 2113.75 | 2113.75 | 2113.75 | 0.0 |
| 2015-08-21 | B | Futures | 42.89 | 43.05 | 41.72 | 42.08 | 231795.0 |
| 2015-08-21 | B6 | Futures | 1.6514 | 1.6547 | 1.6478 | 1.652 | 90730.0 |
| 2015-08-21 | BFX | Futures | 4278.2 | 4278.2 | 4155.4 | 4155.4 | 20.0 |
| 2015-08-21 | BR | Futures | 0.1726 | 0.1726 | 0.17059 | 0.17107 | 3145.0 |
| 2015-08-21 | BZ | Futures | 42.65 | 43.0 | 41.69 | 42.04 | 29553.0 |
| 2015-08-21 | C | Futures | 2209.0 | 2215.0 | 2180.0 | 2182.0 | 6891.0 |
| 2015-08-21 | CB | Futures | 193.682 | 193.703 | 189.245 | 189.245 | 26.0 |
| 2015-08-21 | CC | Futures | 2288.0 | 2298.0 | 2251.0 | 2254.0 | 16147.0 |
| 2015-08-21 | CNH | Futures | 7.2751 | 7.2751 | 7.2695 | 7.2703 | 7.0 |
| 2015-08-21 | CSC | Futures | 4.553 | 4.556 | 4.49 | 4.503 | 84.0 |
| 2015-08-21 | CT | Futures | 82.12 | 82.77 | 82.01 | 82.77 | 3.0 |
| 2015-08-21 | DC | Futures | 36.35 | 36.52 | 35.99 | 36.07 | 178.0 |
| 2015-08-21 | DX | Futures | 89.659 | 89.682 | 88.751 | 88.933 | 61646.0 |
| 2015-08-21 | E1 | Futures | 1.3258 | 1.34307 | 1.32427 | 1.34015 | 26393.0 |
| 2015-08-21 | E6 | Futures | 1.32046 | 1.33855 | 1.31963 | 1.33432 | 307585.0 |
| 2015-08-21 | E7 | Futures | 1.3129 | 1.331 | 1.3123 | 1.327 | 7312.0 |
| 2015-08-21 | EBM | Futures | 275.04 | 276.67 | 272.99 | 273.4 | 9752.0 |
| 2015-08-21 | ED | Futures | 95.651 | 95.663 | 95.651 | 95.6558 | 202784.0 |
| 2015-08-21 | ER | Futures | 98.126 | 98.126 | 98.122 | 98.126 | 12034.0 |
| 2015-08-21 | EW | Futures | 1521.2 | 1522.6 | 1487.3 | 1489.7 | 48483.0 |
| 2015-08-21 | FBTP | Futures | 101.06 | 101.19 | 100.64 | 100.85 | 83122.0 |
| 2015-08-21 | FBTS | Futures | 100.079 | 100.079 | 100.044 | 100.062 | 9392.0 |
| 2015-08-21 | FCE | Futures | 3925.9 | 4000.0 | 3833.8 | 3877.7 | 170688.0 |
| 2015-08-21 | FDAX | Futures | 11224.2 | 11538.2 | 11033.0 | 11223.1 | 203149.0 |
| 2015-08-21 | FDIV | Futures | 139.09 | 140.66 | 137.01 | 137.01 | 56.0 |
| 2015-08-21 | FESX | Futures | 2424.5 | 2482.2 | 2374.2 | 2409.7 | 2095624.0 |
| 2015-08-21 | FGBL | Futures | 139.07 | 139.14 | 138.65 | 138.83 | 449231.0 |
| 2015-08-21 | FGBM | Futures | 125.19 | 125.21 | 125.03 | 125.12 | 338744.0 |
| 2015-08-21 | FGBS | Futures | 111.288 | 111.308 | 111.278 | 111.293 | 125988.0 |
| 2015-08-21 | FGBX | Futures | 161.22 | 161.73 | 160.11 | 161.08 | 25767.0 |
| 2015-08-21 | FMWO | Futures | 5575.1 | 5580.0 | 5493.8 | 5511.1 | 919.0 |
| 2015-08-21 | FOAT | Futures | 126.65 | 126.65 | 126.08 | 126.25 | 53605.0 |
| 2015-08-21 | FTDX | Futures | 1567.4 | 1567.9 | 1512.8 | 1536.4 | 504.0 |
| 2015-08-21 | FTI | Futures | 385.77 | 393.08 | 376.48 | 381.12 | 63247.0 |
| 2015-08-21 | FTUK | Futures | 4990.0 | 5038.5 | 4862.4 | 4929.6 | 166755.0 |
| 2015-08-21 | FVSA | Futures | 2032.02 | 2181.43 | 1950.91 | 2143.01 | 14557.0 |
| 2015-08-21 | FXXP | Futures | 281.2 | 285.6 | 274.3 | 277.7 | 33006.0 |
| 2015-08-21 | G | Futures | 104.05 | 104.57 | 103.92 | 104.33 | 164228.0 |
| 2015-08-21 | GF | Futures | 355.692 | 356.08 | 348.838 | 348.838 | 2187.0 |
| 2015-08-21 | GSCI | Futures | 578.08 | 580.72 | 570.74 | 574.54 | 207.0 |
| 2015-08-21 | HE | Futures | 87.858 | 88.849 | 85.636 | 85.909 | 16798.0 |
> showing 50 of 108 rows — these rows as CSV