PREVIEW / futures_daily / 2014-09-05
file: by_date/futures_daily/2014/2014-09-05.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-09-05 | ES | Futures | 2076.55 | 2085.64 | 2065.39 | 2083.83 | 1693274.0 |
| 2014-09-05 | NQ | Futures | 4698.48 | 4720.69 | 4675.11 | 4714.92 | 283624.0 |
| 2014-09-05 | YM | Futures | 17240.5 | 17286.9 | 17149.7 | 17270.8 | 158724.0 |
| 2014-09-05 | CL | Futures | 176.15 | 176.94 | 172.97 | 173.77 | 261386.0 |
| 2014-09-05 | GC | Futures | 1654.9 | 1672.1 | 1650.1 | 1662.3 | 106165.0 |
| 2014-09-05 | ZN | Futures | 117.13388 | 117.790378 | 117.00258 | 117.206824 | 66919.0 |
| 2014-09-05 | A6 | Futures | 0.90262 | 0.90833 | 0.90156 | 0.90572 | 85829.0 |
| 2014-09-05 | AD | Futures | 0.93358 | 0.93683 | 0.93134 | 0.93297 | 48702.0 |
| 2014-09-05 | ALI | Futures | 3073.97 | 3073.97 | 3073.97 | 3073.97 | 0.0 |
| 2014-09-05 | B | Futures | 106.89 | 107.43 | 105.45 | 105.92 | 155791.0 |
| 2014-09-05 | B6 | Futures | 1.7155 | 1.7177 | 1.7109 | 1.7166 | 124912.0 |
| 2014-09-05 | BFX | Futures | 3898.8 | 3901.3 | 3898.5 | 3901.3 | 43.0 |
| 2014-09-05 | BR | Futures | 0.23586 | 0.23602 | 0.23478 | 0.23534 | 1020.0 |
| 2014-09-05 | BZ | Futures | 107.66 | 108.17 | 106.17 | 106.67 | 13941.0 |
| 2014-09-05 | C | Futures | 2101.0 | 2108.0 | 2089.0 | 2100.0 | 5121.0 |
| 2014-09-05 | CB | Futures | 157.237 | 157.257 | 156.467 | 156.467 | 6.0 |
| 2014-09-05 | CC | Futures | 2312.0 | 2314.0 | 2284.0 | 2290.0 | 14992.0 |
| 2014-09-05 | CSC | Futures | 5.016 | 5.016 | 4.985 | 4.985 | 12.0 |
| 2014-09-05 | CT | Futures | 84.29 | 84.29 | 82.69 | 83.36 | 11.0 |
| 2014-09-05 | DC | Futures | 40.76 | 40.76 | 40.18 | 40.53 | 234.0 |
| 2014-09-05 | DX | Futures | 79.673 | 79.702 | 79.341 | 79.504 | 39221.0 |
| 2014-09-05 | E1 | Futures | 1.37456 | 1.38058 | 1.37315 | 1.37712 | 53771.0 |
| 2014-09-05 | E6 | Futures | 1.52695 | 1.53297 | 1.52471 | 1.52908 | 263751.0 |
| 2014-09-05 | E7 | Futures | 1.5169 | 1.5229 | 1.5148 | 1.5191 | 3630.0 |
| 2014-09-05 | ED | Futures | 95.4186 | 95.421 | 95.4162 | 95.4186 | 95226.0 |
| 2014-09-05 | ER | Futures | 97.999 | 98.009 | 97.994 | 98.004 | 63965.0 |
| 2014-09-05 | EW | Futures | 1490.1 | 1496.9 | 1482.7 | 1495.0 | 14747.0 |
| 2014-09-05 | FBTP | Futures | 95.24 | 95.84 | 95.13 | 95.76 | 113609.0 |
| 2014-09-05 | FBTS | Futures | 98.917 | 98.979 | 98.801 | 98.89 | 18623.0 |
| 2014-09-05 | FCE | Futures | 3564.3 | 3582.6 | 3558.7 | 3571.8 | 99206.0 |
| 2014-09-05 | FDAX | Futures | 10685.4 | 10781.8 | 10670.0 | 10738.3 | 129680.0 |
| 2014-09-05 | FESX | Futures | 2349.7 | 2365.6 | 2342.5 | 2356.2 | 1224206.0 |
| 2014-09-05 | FEU3 | Futures | 98.626 | 98.631 | 98.626 | 98.631 | 75.0 |
| 2014-09-05 | FGBL | Futures | 131.0 | 131.55 | 130.96 | 131.41 | 1152970.0 |
| 2014-09-05 | FGBM | Futures | 122.73 | 122.92 | 122.72 | 122.8 | 730658.0 |
| 2014-09-05 | FGBS | Futures | 110.968 | 110.998 | 110.928 | 110.953 | 470293.0 |
| 2014-09-05 | FGBX | Futures | 139.36 | 140.91 | 139.12 | 140.61 | 51949.0 |
| 2014-09-05 | FMWO | Futures | 5806.6 | 5811.6 | 5795.3 | 5804.1 | 219.0 |
| 2014-09-05 | FOAT | Futures | 121.28 | 121.78 | 121.28 | 121.67 | 112899.0 |
| 2014-09-05 | FTDX | Futures | 1186.5 | 1187.0 | 1180.9 | 1181.4 | 269.0 |
| 2014-09-05 | FTI | Futures | 362.55 | 363.88 | 361.43 | 362.72 | 28942.0 |
| 2014-09-05 | FTUK | Futures | 5295.0 | 5295.4 | 5252.3 | 5272.3 | 104989.0 |
| 2014-09-05 | FVSA | Futures | 1390.88 | 1408.0 | 1365.21 | 1373.77 | 9731.0 |
| 2014-09-05 | FXXP | Futures | 262.3 | 262.8 | 261.1 | 262.1 | 5519.0 |
| 2014-09-05 | G | Futures | 96.39 | 96.78 | 96.23 | 96.52 | 210596.0 |
| 2014-09-05 | GF | Futures | 347.652 | 351.259 | 347.497 | 350.173 | 1409.0 |
| 2014-09-05 | GSCI | Futures | 1014.85 | 1014.85 | 1002.95 | 1005.8 | 119.0 |
| 2014-09-05 | HE | Futures | 125.429 | 127.726 | 124.703 | 127.696 | 26291.0 |
| 2014-09-05 | HG | Futures | 3.9949 | 4.0247 | 3.986 | 4.0202 | 25612.0 |
| 2014-09-05 | HH | Futures | 46.738 | 46.909 | 46.37 | 46.468 | 1395.0 |
> showing 50 of 105 rows — these rows as CSV