PREVIEW / futures_daily / 2014-01-17
file: by_date/futures_daily/2014/2014-01-17.parquet size: 9 KB rows: 106
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-01-17 | ES | Futures | 1894.71 | 1899.61 | 1885.69 | 1890.85 | 1182782.0 |
| 2014-01-17 | NQ | Futures | 4135.43 | 4148.93 | 4108.98 | 4121.06 | 256190.0 |
| 2014-01-17 | YM | Futures | 16317.2 | 16409.1 | 16295.2 | 16371.1 | 114276.0 |
| 2014-01-17 | CL | Futures | 166.51 | 167.89 | 166.11 | 167.04 | 199526.0 |
| 2014-01-17 | GC | Futures | 1644.1 | 1661.1 | 1638.2 | 1657.6 | 112715.0 |
| 2014-01-17 | ZN | Futures | 113.81891 | 114.004912 | 113.690139 | 113.933373 | 703983.0 |
| 2014-01-17 | A6 | Futures | 0.83691 | 0.83805 | 0.83195 | 0.83262 | 70544.0 |
| 2014-01-17 | AD | Futures | 0.92504 | 0.92544 | 0.92058 | 0.92169 | 50516.0 |
| 2014-01-17 | B | Futures | 107.48 | 108.91 | 107.37 | 108.43 | 198417.0 |
| 2014-01-17 | B6 | Futures | 1.7171 | 1.7283 | 1.7124 | 1.7242 | 111280.0 |
| 2014-01-17 | BFX | Futures | 3583.3 | 3591.0 | 3583.3 | 3589.5 | 3.0 |
| 2014-01-17 | BR | Futures | 0.21777 | 0.2185 | 0.21668 | 0.21793 | 88.0 |
| 2014-01-17 | BZ | Futures | 109.59 | 111.07 | 109.54 | 110.59 | 5360.0 |
| 2014-01-17 | C | Futures | 1861.0 | 1862.0 | 1810.0 | 1826.0 | 15641.0 |
| 2014-01-17 | CB | Futures | 90.517 | 92.247 | 90.517 | 91.756 | 22.0 |
| 2014-01-17 | CC | Futures | 2024.0 | 2035.0 | 1993.0 | 2004.0 | 13185.0 |
| 2014-01-17 | CNH | Futures | 6.9478 | 6.9494 | 6.9466 | 6.9494 | 32.0 |
| 2014-01-17 | CSC | Futures | 4.143 | 4.143 | 4.081 | 4.114 | 29.0 |
| 2014-01-17 | CT | Futures | 98.07 | 99.36 | 97.93 | 98.97 | 15112.0 |
| 2014-01-17 | DC | Futures | 31.89 | 32.34 | 31.87 | 32.07 | 311.0 |
| 2014-01-17 | DX | Futures | 77.07 | 77.436 | 77.042 | 77.372 | 21142.0 |
| 2014-01-17 | E1 | Futures | 1.4194 | 1.42004 | 1.40785 | 1.40939 | 25633.0 |
| 2014-01-17 | E6 | Futures | 1.60719 | 1.60778 | 1.59539 | 1.59704 | 210477.0 |
| 2014-01-17 | E7 | Futures | 1.5968 | 1.5973 | 1.5851 | 1.5866 | 5693.0 |
| 2014-01-17 | EBM | Futures | 269.04 | 269.39 | 266.6 | 266.95 | 9663.0 |
| 2014-01-17 | ED | Futures | 95.371 | 95.3758 | 95.3662 | 95.371 | 143944.0 |
| 2014-01-17 | ER | Futures | 97.817 | 97.847 | 97.817 | 97.842 | 112954.0 |
| 2014-01-17 | EW | Futures | 1375.9 | 1381.0 | 1372.9 | 1375.4 | 9694.0 |
| 2014-01-17 | FBTP | Futures | 83.6 | 83.95 | 83.6 | 83.79 | 53542.0 |
| 2014-01-17 | FBTS | Futures | 96.152 | 96.17 | 96.108 | 96.135 | 10726.0 |
| 2014-01-17 | FCE | Futures | 3366.2 | 3377.5 | 3354.2 | 3366.6 | 111949.0 |
| 2014-01-17 | FDAX | Futures | 10800.6 | 10867.2 | 10760.7 | 10812.8 | 107570.0 |
| 2014-01-17 | FDIV | Futures | 148.79 | 148.79 | 148.01 | 148.01 | 1.0 |
| 2014-01-17 | FESX | Futures | 2219.6 | 2227.3 | 2208.3 | 2216.8 | 902841.0 |
| 2014-01-17 | FEU3 | Futures | 98.448 | 98.458 | 98.448 | 98.458 | 250.0 |
| 2014-01-17 | FGBL | Futures | 120.12 | 120.47 | 120.11 | 120.33 | 561438.0 |
| 2014-01-17 | FGBM | Futures | 118.04 | 118.24 | 118.04 | 118.19 | 393572.0 |
| 2014-01-17 | FGBS | Futures | 110.438 | 110.468 | 110.428 | 110.448 | 323938.0 |
| 2014-01-17 | FGBX | Futures | 120.72 | 121.35 | 120.63 | 121.04 | 15752.0 |
| 2014-01-17 | FMWO | Futures | 5452.2 | 5452.2 | 5452.2 | 5452.2 | 0.0 |
| 2014-01-17 | FOAT | Futures | 108.74 | 109.14 | 108.74 | 109.07 | 44036.0 |
| 2014-01-17 | FTDX | Futures | 1165.3 | 1177.9 | 1163.4 | 1177.0 | 140.0 |
| 2014-01-17 | FTI | Futures | 348.6 | 349.29 | 346.21 | 349.03 | 28795.0 |
| 2014-01-17 | FTUK | Futures | 5130.1 | 5140.7 | 5113.4 | 5128.6 | 97611.0 |
| 2014-01-17 | FVSA | Futures | 1810.82 | 1826.12 | 1785.31 | 1790.41 | 4596.0 |
| 2014-01-17 | FXXP | Futures | 245.0 | 246.2 | 244.7 | 245.8 | 3904.0 |
| 2014-01-17 | G | Futures | 92.2 | 92.31 | 91.88 | 92.02 | 159742.0 |
| 2014-01-17 | GF | Futures | 270.619 | 271.304 | 269.733 | 270.74 | 2146.0 |
| 2014-01-17 | GSCI | Futures | 1003.59 | 1010.31 | 1003.59 | 1008.18 | 49.0 |
| 2014-01-17 | HE | Futures | 104.8 | 105.071 | 103.23 | 104.075 | 10455.0 |
> showing 50 of 106 rows — these rows as CSV