PREVIEW / futures_daily / 2014-08-11
file: by_date/futures_daily/2014/2014-08-11.parquet size: 9 KB rows: 103
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-08-11 | ES | Futures | 1998.13 | 2016.3 | 1997.87 | 2007.47 | 1178957.0 |
| 2014-08-11 | NQ | Futures | 4469.74 | 4520.22 | 4469.45 | 4505.51 | 178453.0 |
| 2014-08-11 | YM | Futures | 16627.1 | 16730.0 | 16622.0 | 16663.4 | 123128.0 |
| 2014-08-11 | CL | Futures | 179.56 | 181.48 | 179.25 | 180.56 | 241493.0 |
| 2014-08-11 | GC | Futures | 1718.8 | 1722.1 | 1713.5 | 1718.9 | 63069.0 |
| 2014-08-11 | ZN | Futures | 117.484012 | 117.64449 | 117.396479 | 117.571545 | 811021.0 |
| 2014-08-11 | A6 | Futures | 0.89431 | 0.89537 | 0.89267 | 0.89296 | 43493.0 |
| 2014-08-11 | AD | Futures | 0.92484 | 0.92941 | 0.92434 | 0.9286 | 48202.0 |
| 2014-08-11 | ALI | Futures | 2961.21 | 2961.21 | 2961.21 | 2961.21 | 0.0 |
| 2014-08-11 | B | Futures | 110.8 | 111.46 | 110.36 | 110.68 | 165902.0 |
| 2014-08-11 | B6 | Futures | 1.7627 | 1.7652 | 1.7626 | 1.7641 | 56113.0 |
| 2014-08-11 | BR | Futures | 0.22962 | 0.23068 | 0.22954 | 0.23015 | 807.0 |
| 2014-08-11 | BZ | Futures | 111.83 | 112.32 | 111.37 | 111.55 | 9092.0 |
| 2014-08-11 | C | Futures | 2135.0 | 2138.0 | 2125.0 | 2131.0 | 3416.0 |
| 2014-08-11 | CB | Futures | 134.162 | 134.162 | 133.03 | 133.03 | 13.0 |
| 2014-08-11 | CC | Futures | 2373.0 | 2389.0 | 2366.0 | 2378.0 | 18875.0 |
| 2014-08-11 | CNH | Futures | 7.071 | 7.0732 | 7.07 | 7.0701 | 13.0 |
| 2014-08-11 | CSC | Futures | 4.591 | 4.634 | 4.591 | 4.629 | 16.0 |
| 2014-08-11 | CT | Futures | 80.64 | 81.81 | 80.64 | 80.9 | 19.0 |
| 2014-08-11 | DC | Futures | 37.42 | 37.9 | 37.42 | 37.76 | 244.0 |
| 2014-08-11 | DX | Futures | 77.334 | 77.409 | 77.329 | 77.395 | 8320.0 |
| 2014-08-11 | E1 | Futures | 1.41596 | 1.41609 | 1.41391 | 1.4143 | 20747.0 |
| 2014-08-11 | E6 | Futures | 1.58217 | 1.58229 | 1.57899 | 1.57922 | 90749.0 |
| 2014-08-11 | E7 | Futures | 1.5717 | 1.5719 | 1.5687 | 1.5689 | 840.0 |
| 2014-08-11 | ED | Futures | 95.4162 | 95.4162 | 95.4115 | 95.4162 | 53975.0 |
| 2014-08-11 | ER | Futures | 97.891 | 97.901 | 97.891 | 97.901 | 14521.0 |
| 2014-08-11 | EW | Futures | 1427.3 | 1444.5 | 1425.0 | 1434.7 | 15009.0 |
| 2014-08-11 | FBTP | Futures | 91.9 | 92.09 | 91.83 | 92.02 | 47347.0 |
| 2014-08-11 | FBTS | Futures | 98.481 | 98.57 | 98.472 | 98.552 | 6277.0 |
| 2014-08-11 | FCE | Futures | 3320.3 | 3344.9 | 3310.3 | 3336.6 | 139396.0 |
| 2014-08-11 | FDAX | Futures | 10024.1 | 10133.1 | 10007.6 | 10117.2 | 100284.0 |
| 2014-08-11 | FESX | Futures | 2182.2 | 2195.9 | 2175.7 | 2193.0 | 913167.0 |
| 2014-08-11 | FGBL | Futures | 129.76 | 130.01 | 129.7 | 129.86 | 429655.0 |
| 2014-08-11 | FGBM | Futures | 121.95 | 122.07 | 121.94 | 122.03 | 251549.0 |
| 2014-08-11 | FGBS | Futures | 110.783 | 110.828 | 110.783 | 110.823 | 167033.0 |
| 2014-08-11 | FGBX | Futures | 138.94 | 139.26 | 138.74 | 138.9 | 22899.0 |
| 2014-08-11 | FMWO | Futures | 5645.5 | 5668.2 | 5641.8 | 5668.2 | 697.0 |
| 2014-08-11 | FOAT | Futures | 119.64 | 119.78 | 119.56 | 119.69 | 35652.0 |
| 2014-08-11 | FTDX | Futures | 1096.2 | 1110.7 | 1095.3 | 1109.8 | 151.0 |
| 2014-08-11 | FTI | Futures | 337.39 | 341.4 | 337.39 | 340.8 | 4704.0 |
| 2014-08-11 | FTUK | Futures | 5046.9 | 5085.8 | 5043.9 | 5076.9 | 75406.0 |
| 2014-08-11 | FVSA | Futures | 1630.13 | 1659.85 | 1562.21 | 1579.19 | 11667.0 |
| 2014-08-11 | FXXP | Futures | 246.2 | 248.1 | 246.0 | 247.8 | 16554.0 |
| 2014-08-11 | G | Futures | 95.71 | 95.71 | 95.48 | 95.53 | 113015.0 |
| 2014-08-11 | GF | Futures | 330.006 | 337.763 | 329.735 | 337.297 | 5855.0 |
| 2014-08-11 | GSCI | Futures | 1033.04 | 1039.15 | 1033.04 | 1035.97 | 1733.0 |
| 2014-08-11 | HE | Futures | 119.686 | 121.197 | 118.84 | 121.107 | 20856.0 |
| 2014-08-11 | HG | Futures | 4.0672 | 4.1503 | 4.0525 | 4.0576 | 42708.0 |
| 2014-08-11 | HH | Futures | 49.953 | 50.359 | 49.953 | 50.334 | 792.0 |
| 2014-08-11 | HO | Futures | 2.2912 | 2.318 | 2.2879 | 2.299 | 53022.0 |
> showing 50 of 103 rows — these rows as CSV