PREVIEW / futures_daily / 2014-05-23
file: by_date/futures_daily/2014/2014-05-23.parquet size: 9 KB rows: 105
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-05-23 | ES | Futures | 1955.72 | 1965.04 | 1954.95 | 1962.71 | 761557.0 |
| 2014-05-23 | NQ | Futures | 4199.52 | 4232.61 | 4196.07 | 4230.31 | 167143.0 |
| 2014-05-23 | YM | Futures | 16592.7 | 16661.0 | 16589.7 | 16654.0 | 73944.0 |
| 2014-05-23 | CL | Futures | 188.64 | 190.08 | 188.52 | 189.81 | 160563.0 |
| 2014-05-23 | GC | Futures | 1705.4 | 1707.2 | 1695.2 | 1701.9 | 146979.0 |
| 2014-05-23 | ZN | Futures | 116.503807 | 116.735598 | 116.460346 | 116.634189 | 808374.0 |
| 2014-05-23 | A6 | Futures | 0.88501 | 0.88722 | 0.88386 | 0.88617 | 42803.0 |
| 2014-05-23 | AD | Futures | 0.93022 | 0.93296 | 0.92901 | 0.93246 | 38433.0 |
| 2014-05-23 | ALI | Futures | 2721.68 | 2721.68 | 2721.68 | 2721.68 | 4.0 |
| 2014-05-23 | B | Futures | 114.26 | 114.6 | 114.13 | 114.43 | 143657.0 |
| 2014-05-23 | B6 | Futures | 1.7726 | 1.7734 | 1.7667 | 1.7674 | 55260.0 |
| 2014-05-23 | BFX | Futures | 3782.6 | 3782.6 | 3770.4 | 3777.7 | 8.0 |
| 2014-05-23 | BR | Futures | 0.23086 | 0.23086 | 0.23086 | 0.23086 | 706.0 |
| 2014-05-23 | BZ | Futures | 115.69 | 116.08 | 115.59 | 115.93 | 7070.0 |
| 2014-05-23 | C | Futures | 1949.0 | 1976.0 | 1947.0 | 1974.0 | 10140.0 |
| 2014-05-23 | CB | Futures | 109.988 | 111.651 | 109.988 | 111.651 | 23.0 |
| 2014-05-23 | CC | Futures | 2205.0 | 2232.0 | 2204.0 | 2228.0 | 10680.0 |
| 2014-05-23 | CNH | Futures | 7.1563 | 7.1569 | 7.1518 | 7.1518 | 1.0 |
| 2014-05-23 | CSC | Futures | 4.426 | 4.426 | 4.426 | 4.426 | 1.0 |
| 2014-05-23 | CT | Futures | 98.98 | 99.28 | 96.0 | 97.19 | 24826.0 |
| 2014-05-23 | DC | Futures | 35.25 | 35.25 | 35.03 | 35.18 | 55.0 |
| 2014-05-23 | DX | Futures | 76.282 | 76.468 | 76.273 | 76.43 | 10912.0 |
| 2014-05-23 | E1 | Futures | 1.43545 | 1.43558 | 1.43058 | 1.4325 | 17900.0 |
| 2014-05-23 | E6 | Futures | 1.61203 | 1.61215 | 1.60719 | 1.60861 | 121505.0 |
| 2014-05-23 | E7 | Futures | 1.6012 | 1.6014 | 1.5965 | 1.5979 | 1556.0 |
| 2014-05-23 | ED | Futures | 95.4162 | 95.4162 | 95.4114 | 95.4138 | 62329.0 |
| 2014-05-23 | ER | Futures | 97.871 | 97.906 | 97.842 | 97.876 | 51655.0 |
| 2014-05-23 | EW | Futures | 1401.4 | 1412.7 | 1400.6 | 1411.0 | 8921.0 |
| 2014-05-23 | FBTP | Futures | 87.94 | 88.54 | 87.83 | 88.46 | 78750.0 |
| 2014-05-23 | FBTS | Futures | 97.161 | 97.381 | 97.152 | 97.346 | 17418.0 |
| 2014-05-23 | FCE | Futures | 3557.7 | 3570.1 | 3547.3 | 3566.5 | 55054.0 |
| 2014-05-23 | FDAX | Futures | 10749.4 | 10803.5 | 10720.1 | 10782.5 | 59560.0 |
| 2014-05-23 | FESX | Futures | 2283.7 | 2298.0 | 2277.2 | 2293.7 | 542689.0 |
| 2014-05-23 | FGBL | Futures | 125.98 | 126.16 | 125.95 | 126.07 | 384035.0 |
| 2014-05-23 | FGBM | Futures | 120.74 | 120.83 | 120.73 | 120.78 | 262198.0 |
| 2014-05-23 | FGBS | Futures | 110.738 | 110.748 | 110.728 | 110.733 | 211719.0 |
| 2014-05-23 | FGBX | Futures | 130.95 | 131.34 | 130.69 | 130.93 | 13508.0 |
| 2014-05-23 | FMWO | Futures | 5628.9 | 5640.2 | 5626.3 | 5640.2 | 140.0 |
| 2014-05-23 | FOAT | Futures | 115.41 | 115.62 | 115.39 | 115.49 | 38403.0 |
| 2014-05-23 | FTDX | Futures | 1173.3 | 1180.8 | 1172.8 | 1178.4 | 34.0 |
| 2014-05-23 | FTI | Futures | 348.86 | 350.37 | 348.34 | 349.72 | 15818.0 |
| 2014-05-23 | FTUK | Futures | 5192.3 | 5195.7 | 5171.3 | 5183.9 | 50135.0 |
| 2014-05-23 | FVSA | Futures | 1587.68 | 1620.37 | 1587.68 | 1606.36 | 4195.0 |
| 2014-05-23 | FXXP | Futures | 255.1 | 255.8 | 254.6 | 255.5 | 15693.0 |
| 2014-05-23 | G | Futures | 93.67 | 93.81 | 93.5 | 93.76 | 86801.0 |
| 2014-05-23 | GF | Futures | 299.737 | 299.737 | 295.484 | 295.561 | 3200.0 |
| 2014-05-23 | GSCI | Futures | 1091.51 | 1091.84 | 1089.19 | 1090.93 | 7.0 |
| 2014-05-23 | HE | Futures | 130.795 | 131.018 | 129.456 | 130.405 | 9871.0 |
| 2014-05-23 | HG | Futures | 4.0084 | 4.0576 | 4.0071 | 4.0474 | 28679.0 |
| 2014-05-23 | HH | Futures | 55.611 | 55.852 | 55.611 | 55.839 | 672.0 |
> showing 50 of 105 rows — these rows as CSV