PREVIEW / futures_daily / 2014-06-13
file: by_date/futures_daily/2014/2014-06-13.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-06-13 | ES | Futures | 1997.63 | 2004.09 | 1993.23 | 2002.8 | 945294.0 |
| 2014-06-13 | NQ | Futures | 4343.12 | 4357.8 | 4328.15 | 4346.28 | 158900.0 |
| 2014-06-13 | YM | Futures | 16832.9 | 16869.2 | 16789.5 | 16847.0 | 100759.0 |
| 2014-06-13 | CL | Futures | 193.77 | 195.16 | 192.97 | 193.94 | 144257.0 |
| 2014-06-13 | GC | Futures | 1677.8 | 1684.0 | 1674.5 | 1678.7 | 83626.0 |
| 2014-06-13 | ZN | Futures | 116.11266 | 116.171016 | 115.73335 | 116.054305 | 1222815.0 |
| 2014-06-13 | A6 | Futures | 0.90485 | 0.90533 | 0.9003 | 0.90253 | 76686.0 |
| 2014-06-13 | AD | Futures | 0.93348 | 0.93409 | 0.93226 | 0.93358 | 42415.0 |
| 2014-06-13 | ALI | Futures | 2769.37 | 2769.37 | 2769.37 | 2769.37 | 0.0 |
| 2014-06-13 | B | Futures | 118.06 | 119.39 | 117.22 | 117.71 | 292966.0 |
| 2014-06-13 | B6 | Futures | 1.778 | 1.7849 | 1.7778 | 1.7824 | 152093.0 |
| 2014-06-13 | BR | Futures | 0.23054 | 0.23131 | 0.23025 | 0.23131 | 194.0 |
| 2014-06-13 | BZ | Futures | 119.41 | 120.41 | 118.26 | 118.74 | 10961.0 |
| 2014-06-13 | C | Futures | 2030.0 | 2059.0 | 2021.0 | 2047.0 | 6546.0 |
| 2014-06-13 | CB | Futures | 111.79 | 112.908 | 111.231 | 112.908 | 23.0 |
| 2014-06-13 | CC | Futures | 2246.0 | 2296.0 | 2245.0 | 2280.0 | 18523.0 |
| 2014-06-13 | CNH | Futures | 7.1496 | 7.1622 | 7.1496 | 7.1576 | 11.0 |
| 2014-06-13 | CSC | Futures | 4.544 | 4.544 | 4.522 | 4.522 | 6.0 |
| 2014-06-13 | CT | Futures | 96.84 | 98.08 | 96.18 | 97.94 | 15041.0 |
| 2014-06-13 | DC | Futures | 35.81 | 35.89 | 35.6 | 35.74 | 61.0 |
| 2014-06-13 | DX | Futures | 76.56 | 76.712 | 76.46 | 76.651 | 22178.0 |
| 2014-06-13 | E1 | Futures | 1.42801 | 1.43186 | 1.42353 | 1.42455 | 32771.0 |
| 2014-06-13 | E6 | Futures | 1.5994 | 1.6027 | 1.59586 | 1.59739 | 155653.0 |
| 2014-06-13 | E7 | Futures | 1.589 | 1.5923 | 1.5856 | 1.587 | 1946.0 |
| 2014-06-13 | ED | Futures | 95.4115 | 95.4115 | 95.3971 | 95.4067 | 122275.0 |
| 2014-06-13 | ER | Futures | 97.911 | 97.925 | 97.906 | 97.92 | 85899.0 |
| 2014-06-13 | EW | Futures | 1450.3 | 1456.3 | 1444.2 | 1452.3 | 30204.0 |
| 2014-06-13 | FBTP | Futures | 90.89 | 91.18 | 90.69 | 91.13 | 48867.0 |
| 2014-06-13 | FBTS | Futures | 97.992 | 98.108 | 97.974 | 98.072 | 12665.0 |
| 2014-06-13 | FCE | Futures | 3629.9 | 3632.7 | 3593.2 | 3622.3 | 46264.0 |
| 2014-06-13 | FDAX | Futures | 10979.1 | 10985.1 | 10853.2 | 10955.9 | 108849.0 |
| 2014-06-13 | FESX | Futures | 2355.5 | 2364.1 | 2336.1 | 2358.4 | 384884.0 |
| 2014-06-13 | FEU3 | Futures | 98.542 | 98.547 | 98.542 | 98.542 | 1013.0 |
| 2014-06-13 | FGBL | Futures | 126.39 | 126.65 | 126.01 | 126.48 | 626311.0 |
| 2014-06-13 | FGBM | Futures | 121.08 | 121.18 | 120.91 | 121.09 | 460841.0 |
| 2014-06-13 | FGBS | Futures | 110.738 | 110.773 | 110.718 | 110.758 | 351937.0 |
| 2014-06-13 | FGBX | Futures | 129.37 | 130.24 | 128.93 | 129.78 | 17668.0 |
| 2014-06-13 | FMWO | Futures | 5742.4 | 5743.7 | 5721.0 | 5743.7 | 1684.0 |
| 2014-06-13 | FOAT | Futures | 116.0 | 116.41 | 115.75 | 116.12 | 52454.0 |
| 2014-06-13 | FTDX | Futures | 1242.7 | 1242.7 | 1221.1 | 1221.6 | 203.0 |
| 2014-06-13 | FTI | Futures | 358.74 | 358.74 | 356.45 | 357.92 | 380.0 |
| 2014-06-13 | FTUK | Futures | 5207.3 | 5213.5 | 5160.4 | 5183.8 | 36721.0 |
| 2014-06-13 | FVSA | Futures | 1353.83 | 1444.08 | 1353.83 | 1396.81 | 8997.0 |
| 2014-06-13 | FXXP | Futures | 260.5 | 260.5 | 258.9 | 260.5 | 17838.0 |
| 2014-06-13 | G | Futures | 92.72 | 93.16 | 92.68 | 93.06 | 207984.0 |
| 2014-06-13 | GF | Futures | 316.481 | 319.431 | 314.603 | 319.01 | 3937.0 |
| 2014-06-13 | GSCI | Futures | 1104.41 | 1104.41 | 1099.25 | 1099.5 | 732.0 |
| 2014-06-13 | HE | Futures | 132.996 | 134.495 | 132.733 | 133.627 | 14870.0 |
| 2014-06-13 | HG | Futures | 3.8525 | 3.8883 | 3.8512 | 3.871 | 41771.0 |
| 2014-06-13 | HH | Futures | 60.339 | 60.352 | 59.832 | 60.073 | 228.0 |
> showing 50 of 103 rows — these rows as CSV