PREVIEW / futures_daily / 2014-01-15
file: by_date/futures_daily/2014/2014-01-15.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-01-15 | ES | Futures | 1889.56 | 1902.7 | 1888.01 | 1898.32 | 1260095.0 |
| 2014-01-15 | NQ | Futures | 4108.41 | 4150.37 | 4104.96 | 4136.57 | 234221.0 |
| 2014-01-15 | YM | Futures | 16276.3 | 16418.1 | 16264.3 | 16382.1 | 114957.0 |
| 2014-01-15 | CL | Futures | 163.95 | 167.45 | 163.58 | 166.62 | 163430.0 |
| 2014-01-15 | GC | Futures | 1647.5 | 1647.9 | 1633.2 | 1639.6 | 105108.0 |
| 2014-01-15 | ZN | Futures | 113.661524 | 113.790294 | 113.318135 | 113.518445 | 1028370.0 |
| 2014-01-15 | A6 | Futures | 0.85006 | 0.85149 | 0.84348 | 0.84558 | 90320.0 |
| 2014-01-15 | AD | Futures | 0.92321 | 0.92595 | 0.91987 | 0.92301 | 68930.0 |
| 2014-01-15 | B | Futures | 107.19 | 108.67 | 106.98 | 108.21 | 245760.0 |
| 2014-01-15 | B6 | Futures | 1.7261 | 1.7262 | 1.7137 | 1.7187 | 115941.0 |
| 2014-01-15 | BFX | Futures | 3564.0 | 3577.2 | 3564.0 | 3577.2 | 588.0 |
| 2014-01-15 | BR | Futures | 0.21681 | 0.21881 | 0.21681 | 0.21803 | 274.0 |
| 2014-01-15 | BZ | Futures | 109.31 | 110.83 | 109.12 | 110.37 | 8973.0 |
| 2014-01-15 | C | Futures | 1873.0 | 1873.0 | 1852.0 | 1863.0 | 11102.0 |
| 2014-01-15 | CB | Futures | 87.34 | 89.18 | 87.34 | 88.959 | 12.0 |
| 2014-01-15 | CC | Futures | 2050.0 | 2057.0 | 2020.0 | 2040.0 | 11771.0 |
| 2014-01-15 | CSC | Futures | 3.998 | 4.019 | 3.99 | 4.006 | 40.0 |
| 2014-01-15 | CT | Futures | 95.44 | 96.79 | 95.36 | 96.68 | 13282.0 |
| 2014-01-15 | DC | Futures | 30.96 | 31.24 | 30.76 | 31.01 | 349.0 |
| 2014-01-15 | DX | Futures | 76.795 | 77.27 | 76.79 | 77.164 | 23119.0 |
| 2014-01-15 | E1 | Futures | 1.42261 | 1.42261 | 1.41003 | 1.41311 | 30015.0 |
| 2014-01-15 | E6 | Futures | 1.61427 | 1.61427 | 1.60294 | 1.6053 | 204483.0 |
| 2014-01-15 | E7 | Futures | 1.6039 | 1.6039 | 1.5926 | 1.5948 | 4626.0 |
| 2014-01-15 | EBM | Futures | 271.82 | 272.52 | 268.34 | 268.69 | 18007.0 |
| 2014-01-15 | ED | Futures | 95.3662 | 95.371 | 95.3662 | 95.371 | 70629.0 |
| 2014-01-15 | ER | Futures | 97.827 | 97.832 | 97.808 | 97.817 | 135747.0 |
| 2014-01-15 | EW | Futures | 1371.5 | 1381.8 | 1371.1 | 1380.9 | 10871.0 |
| 2014-01-15 | FBTP | Futures | 83.37 | 83.58 | 83.3 | 83.49 | 36706.0 |
| 2014-01-15 | FBTS | Futures | 96.1 | 96.135 | 96.091 | 96.108 | 7518.0 |
| 2014-01-15 | FCE | Futures | 3332.8 | 3380.6 | 3330.4 | 3368.2 | 180014.0 |
| 2014-01-15 | FDAX | Futures | 10627.6 | 10847.2 | 10617.1 | 10787.9 | 121597.0 |
| 2014-01-15 | FESX | Futures | 2197.8 | 2235.8 | 2195.0 | 2225.2 | 997646.0 |
| 2014-01-15 | FGBL | Futures | 119.6 | 119.82 | 119.46 | 119.59 | 649325.0 |
| 2014-01-15 | FGBM | Futures | 117.74 | 117.87 | 117.68 | 117.75 | 550801.0 |
| 2014-01-15 | FGBS | Futures | 110.358 | 110.388 | 110.348 | 110.363 | 333694.0 |
| 2014-01-15 | FGBX | Futures | 120.06 | 120.26 | 119.65 | 119.9 | 12253.0 |
| 2014-01-15 | FMWO | Futures | 5447.2 | 5447.2 | 5447.2 | 5447.2 | 0.0 |
| 2014-01-15 | FOAT | Futures | 108.4 | 108.61 | 108.3 | 108.37 | 46104.0 |
| 2014-01-15 | FTDX | Futures | 1162.0 | 1173.7 | 1162.0 | 1168.5 | 427.0 |
| 2014-01-15 | FTI | Futures | 348.22 | 349.8 | 347.62 | 349.25 | 49109.0 |
| 2014-01-15 | FTUK | Futures | 5092.6 | 5131.2 | 5089.2 | 5118.7 | 87034.0 |
| 2014-01-15 | FVSA | Futures | 1805.72 | 1815.92 | 1780.21 | 1790.41 | 3469.0 |
| 2014-01-15 | FXXP | Futures | 243.1 | 245.3 | 243.1 | 244.8 | 6961.0 |
| 2014-01-15 | G | Futures | 91.89 | 91.94 | 91.57 | 91.67 | 133970.0 |
| 2014-01-15 | GF | Futures | 269.37 | 271.466 | 269.37 | 270.901 | 3495.0 |
| 2014-01-15 | GSCI | Futures | 1001.3 | 1010.31 | 1000.23 | 1007.69 | 481.0 |
| 2014-01-15 | HE | Futures | 104.015 | 105.071 | 104.015 | 104.588 | 16799.0 |
| 2014-01-15 | HG | Futures | 4.209 | 4.2481 | 4.1781 | 4.2412 | 47715.0 |
| 2014-01-15 | HH | Futures | 43.968 | 44.369 | 43.267 | 43.327 | 2717.0 |
| 2014-01-15 | HO | Futures | 2.3238 | 2.3623 | 2.3216 | 2.3514 | 63090.0 |
> showing 50 of 103 rows — these rows as CSV