PREVIEW / futures_daily / 2014-01-07
file: by_date/futures_daily/2014/2014-01-07.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-07 | ES | Futures | 1875.9 | 1891.36 | 1875.64 | 1887.24 | 1162443.0 |
| 2014-01-07 | NQ | Futures | 4042.31 | 4089.44 | 4042.02 | 4079.67 | 191716.0 |
| 2014-01-07 | YM | Futures | 16329.2 | 16470.0 | 16329.2 | 16428.0 | 110394.0 |
| 2014-01-07 | CL | Futures | 165.24 | 166.33 | 164.8 | 165.36 | 177182.0 |
| 2014-01-07 | GC | Futures | 1637.8 | 1648.0 | 1620.9 | 1628.0 | 128637.0 |
| 2014-01-07 | ZN | Futures | 113.074902 | 113.260904 | 113.003363 | 113.260904 | 721163.0 |
| 2014-01-07 | A6 | Futures | 0.85053 | 0.85101 | 0.84367 | 0.84625 | 80976.0 |
| 2014-01-07 | AD | Futures | 0.94843 | 0.94843 | 0.93759 | 0.93901 | 92592.0 |
| 2014-01-07 | B | Futures | 108.68 | 109.29 | 108.51 | 108.95 | 154533.0 |
| 2014-01-07 | B6 | Futures | 1.7235 | 1.7261 | 1.7192 | 1.7227 | 63774.0 |
| 2014-01-07 | BFX | Futures | 3498.2 | 3527.7 | 3498.2 | 3527.1 | 40.0 |
| 2014-01-07 | BR | Futures | 0.21616 | 0.21684 | 0.21549 | 0.21549 | 288.0 |
| 2014-01-07 | BZ | Futures | 111.02 | 111.45 | 110.68 | 111.12 | 7071.0 |
| 2014-01-07 | C | Futures | 1807.0 | 1820.0 | 1799.0 | 1807.0 | 7837.0 |
| 2014-01-07 | CB | Futures | 80.225 | 81.243 | 80.225 | 81.207 | 34.0 |
| 2014-01-07 | CC | Futures | 1981.0 | 2002.0 | 1976.0 | 1985.0 | 11925.0 |
| 2014-01-07 | CSC | Futures | 3.894 | 3.944 | 3.88 | 3.93 | 9.0 |
| 2014-01-07 | CT | Futures | 95.32 | 96.95 | 95.15 | 96.54 | 9582.0 |
| 2014-01-07 | DC | Futures | 30.04 | 30.49 | 29.74 | 30.31 | 330.0 |
| 2014-01-07 | DX | Futures | 76.894 | 77.127 | 76.795 | 77.008 | 24795.0 |
| 2014-01-07 | E1 | Futures | 1.42107 | 1.4212 | 1.41144 | 1.41362 | 27910.0 |
| 2014-01-07 | E6 | Futures | 1.60943 | 1.61203 | 1.60495 | 1.60743 | 165968.0 |
| 2014-01-07 | E7 | Futures | 1.5988 | 1.6015 | 1.5945 | 1.5969 | 4335.0 |
| 2014-01-07 | EBM | Futures | 281.57 | 281.92 | 280.18 | 280.87 | 13186.0 |
| 2014-01-07 | ED | Futures | 95.3566 | 95.3614 | 95.3566 | 95.3566 | 78184.0 |
| 2014-01-07 | ER | Futures | 97.867 | 97.871 | 97.847 | 97.857 | 102117.0 |
| 2014-01-07 | EW | Futures | 1351.4 | 1366.2 | 1350.8 | 1360.8 | 15082.0 |
| 2014-01-07 | FBTP | Futures | 83.03 | 83.51 | 82.98 | 83.44 | 48345.0 |
| 2014-01-07 | FBTS | Futures | 95.933 | 96.1 | 95.933 | 96.073 | 8972.0 |
| 2014-01-07 | FCE | Futures | 3293.8 | 3325.8 | 3284.5 | 3320.7 | 85603.0 |
| 2014-01-07 | FDAX | Futures | 10476.8 | 10565.5 | 10451.3 | 10546.1 | 77796.0 |
| 2014-01-07 | FESX | Futures | 2154.2 | 2187.2 | 2151.3 | 2184.4 | 801640.0 |
| 2014-01-07 | FEU3 | Futures | 98.473 | 98.473 | 98.473 | 98.473 | 98.0 |
| 2014-01-07 | FGBL | Futures | 118.83 | 119.01 | 118.71 | 118.93 | 498434.0 |
| 2014-01-07 | FGBM | Futures | 117.37 | 117.46 | 117.31 | 117.41 | 366893.0 |
| 2014-01-07 | FGBS | Futures | 110.343 | 110.353 | 110.318 | 110.333 | 239997.0 |
| 2014-01-07 | FGBX | Futures | 119.09 | 119.42 | 118.87 | 119.22 | 11330.0 |
| 2014-01-07 | FMWO | Futures | 5414.5 | 5414.5 | 5413.2 | 5413.2 | 50.0 |
| 2014-01-07 | FOAT | Futures | 107.89 | 108.16 | 107.8 | 108.07 | 42722.0 |
| 2014-01-07 | FTDX | Futures | 1112.2 | 1122.5 | 1111.7 | 1122.5 | 78.0 |
| 2014-01-07 | FTI | Futures | 344.15 | 346.59 | 342.99 | 346.16 | 18838.0 |
| 2014-01-07 | FTUK | Futures | 5052.5 | 5083.5 | 5043.8 | 5071.0 | 71002.0 |
| 2014-01-07 | FVSA | Futures | 1902.16 | 1912.91 | 1832.31 | 1843.06 | 4265.0 |
| 2014-01-07 | FXXP | Futures | 239.7 | 241.5 | 239.2 | 241.2 | 5966.0 |
| 2014-01-07 | G | Futures | 90.71 | 90.93 | 90.63 | 90.88 | 114136.0 |
| 2014-01-07 | GF | Futures | 270.863 | 271.427 | 270.219 | 270.541 | 1409.0 |
| 2014-01-07 | GSCI | Futures | 1017.24 | 1020.21 | 1015.42 | 1015.42 | 598.0 |
| 2014-01-07 | HE | Futures | 104.407 | 104.468 | 102.898 | 103.29 | 21837.0 |
| 2014-01-07 | HG | Futures | 4.2431 | 4.2513 | 4.221 | 4.2431 | 36077.0 |
| 2014-01-07 | HH | Futures | 43.447 | 44.299 | 42.696 | 43.066 | 457.0 |
> showing 50 of 103 rows — these rows as CSV