PREVIEW / futures_daily / 2014-10-28
file: by_date/futures_daily/2014/2014-10-28.parquet size: 9 KB rows: 106
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-10-28 | ES | Futures | 2045.04 | 2069.06 | 2043.99 | 2068.28 | 1571000.0 |
| 2014-10-28 | NQ | Futures | 4683.42 | 4751.51 | 4679.66 | 4744.85 | 258879.0 |
| 2014-10-28 | YM | Futures | 17009.5 | 17186.0 | 16997.3 | 17182.0 | 131306.0 |
| 2014-10-28 | CL | Futures | 154.83 | 156.79 | 154.29 | 156.33 | 226066.0 |
| 2014-10-28 | GC | Futures | 1607.8 | 1620.5 | 1603.1 | 1612.5 | 124196.0 |
| 2014-10-28 | ZN | Futures | 119.110483 | 119.227631 | 118.8469 | 118.978691 | 1170647.0 |
| 2014-10-28 | A6 | Futures | 0.85236 | 0.86023 | 0.85178 | 0.85771 | 76657.0 |
| 2014-10-28 | AD | Futures | 0.90178 | 0.90879 | 0.90158 | 0.90686 | 55756.0 |
| 2014-10-28 | ALI | Futures | 3051.41 | 3051.41 | 3051.41 | 3051.41 | 0.0 |
| 2014-10-28 | B | Futures | 88.64 | 89.74 | 88.45 | 89.42 | 101642.0 |
| 2014-10-28 | B6 | Futures | 1.6936 | 1.7004 | 1.6904 | 1.6948 | 71929.0 |
| 2014-10-28 | BFX | Futures | 3758.3 | 3766.7 | 3749.6 | 3766.7 | 33.0 |
| 2014-10-28 | BR | Futures | 0.21121 | 0.21798 | 0.21121 | 0.21542 | 1383.0 |
| 2014-10-28 | BZ | Futures | 89.48 | 90.63 | 89.36 | 90.33 | 13184.0 |
| 2014-10-28 | C | Futures | 2052.0 | 2059.0 | 2018.0 | 2022.0 | 13577.0 |
| 2014-10-28 | CB | Futures | 132.765 | 132.765 | 130.877 | 131.609 | 34.0 |
| 2014-10-28 | CC | Futures | 2178.0 | 2184.0 | 2151.0 | 2158.0 | 24244.0 |
| 2014-10-28 | CNH | Futures | 7.0356 | 7.0358 | 7.0293 | 7.0293 | 46.0 |
| 2014-10-28 | CSC | Futures | 4.88 | 4.883 | 4.88 | 4.883 | 10.0 |
| 2014-10-28 | CT | Futures | 80.5 | 81.73 | 80.1 | 81.69 | 8899.0 |
| 2014-10-28 | DC | Futures | 39.68 | 40.07 | 39.37 | 39.8 | 217.0 |
| 2014-10-28 | DX | Futures | 81.272 | 81.4 | 80.963 | 81.137 | 28263.0 |
| 2014-10-28 | E1 | Futures | 1.34681 | 1.35422 | 1.34476 | 1.3509 | 32809.0 |
| 2014-10-28 | E6 | Futures | 1.49516 | 1.50305 | 1.49352 | 1.49952 | 177732.0 |
| 2014-10-28 | E7 | Futures | 1.4858 | 1.4936 | 1.4841 | 1.4901 | 3339.0 |
| 2014-10-28 | ED | Futures | 95.4374 | 95.447 | 95.4374 | 95.4374 | 84012.0 |
| 2014-10-28 | ER | Futures | 97.974 | 97.984 | 97.974 | 97.984 | 31028.0 |
| 2014-10-28 | EW | Futures | 1434.2 | 1458.2 | 1433.4 | 1457.2 | 20208.0 |
| 2014-10-28 | FBTP | Futures | 94.05 | 94.23 | 93.88 | 94.09 | 61442.0 |
| 2014-10-28 | FBTS | Futures | 98.153 | 98.171 | 98.108 | 98.144 | 10755.0 |
| 2014-10-28 | FCE | Futures | 3325.1 | 3336.4 | 3305.3 | 3317.8 | 98526.0 |
| 2014-10-28 | FDAX | Futures | 9807.6 | 9989.4 | 9804.3 | 9937.4 | 109653.0 |
| 2014-10-28 | FDIV | Futures | 128.96 | 129.51 | 128.96 | 129.51 | 5.0 |
| 2014-10-28 | FESX | Futures | 2178.2 | 2205.0 | 2174.6 | 2194.8 | 928905.0 |
| 2014-10-28 | FGBL | Futures | 132.63 | 132.77 | 132.35 | 132.61 | 568719.0 |
| 2014-10-28 | FGBM | Futures | 122.9 | 122.93 | 122.8 | 122.88 | 291426.0 |
| 2014-10-28 | FGBS | Futures | 110.903 | 110.918 | 110.893 | 110.908 | 148375.0 |
| 2014-10-28 | FGBX | Futures | 144.4 | 145.0 | 144.0 | 144.56 | 21084.0 |
| 2014-10-28 | FMWO | Futures | 5569.6 | 5577.1 | 5565.8 | 5577.1 | 525.0 |
| 2014-10-28 | FOAT | Futures | 121.67 | 121.86 | 121.46 | 121.75 | 54735.0 |
| 2014-10-28 | FTDX | Futures | 1134.6 | 1140.7 | 1134.6 | 1138.8 | 67.0 |
| 2014-10-28 | FTI | Futures | 346.78 | 352.33 | 346.43 | 350.1 | 24971.0 |
| 2014-10-28 | FTUK | Futures | 4917.5 | 4960.0 | 4913.7 | 4936.1 | 79062.0 |
| 2014-10-28 | FVSA | Futures | 1733.32 | 1733.32 | 1658.32 | 1662.49 | 5488.0 |
| 2014-10-28 | FXXP | Futures | 247.7 | 249.2 | 247.2 | 248.6 | 9158.0 |
| 2014-10-28 | G | Futures | 98.92 | 99.04 | 98.6 | 98.8 | 230297.0 |
| 2014-10-28 | GF | Futures | 366.673 | 367.142 | 365.186 | 365.733 | 2868.0 |
| 2014-10-28 | GSCI | Futures | 915.38 | 918.52 | 910.62 | 917.5 | 265.0 |
| 2014-10-28 | HE | Futures | 120.458 | 121.939 | 120.357 | 121.4 | 15674.0 |
| 2014-10-28 | HG | Futures | 3.8801 | 3.927 | 3.8756 | 3.9232 | 41660.0 |
> showing 50 of 106 rows — these rows as CSV