PREVIEW / futures_daily / 2014-09-10
file: by_date/futures_daily/2014/2014-09-10.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-09-10 | ES | Futures | 2066.69 | 2073.7 | 2058.38 | 2072.4 | 1590462.0 |
| 2014-09-10 | NQ | Futures | 4690.69 | 4726.17 | 4678.28 | 4722.42 | 257236.0 |
| 2014-09-10 | YM | Futures | 17187.0 | 17239.8 | 17128.2 | 17221.5 | 9330.0 |
| 2014-09-10 | CL | Futures | 172.84 | 173.28 | 169.91 | 170.75 | 295306.0 |
| 2014-09-10 | GC | Futures | 1647.7 | 1650.7 | 1632.4 | 1633.4 | 140721.0 |
| 2014-09-10 | ZN | Futures | 116.796805 | 116.884666 | 116.562509 | 116.665013 | 1255400.0 |
| 2014-09-10 | A6 | Futures | 0.88842 | 0.88968 | 0.87948 | 0.88385 | 68437.0 |
| 2014-09-10 | AD | Futures | 0.92291 | 0.92698 | 0.92017 | 0.92586 | 28715.0 |
| 2014-09-10 | ALI | Futures | 3028.24 | 3028.24 | 3028.24 | 3028.24 | 12.0 |
| 2014-09-10 | B | Futures | 104.57 | 104.72 | 102.8 | 103.19 | 215317.0 |
| 2014-09-10 | B6 | Futures | 1.6914 | 1.7046 | 1.6859 | 1.7015 | 85631.0 |
| 2014-09-10 | BR | Futures | 0.23156 | 0.23156 | 0.2294 | 0.23021 | 4772.0 |
| 2014-09-10 | BZ | Futures | 105.36 | 105.41 | 103.54 | 103.92 | 15250.0 |
| 2014-09-10 | C | Futures | 2125.0 | 2131.0 | 2106.0 | 2117.0 | 6462.0 |
| 2014-09-10 | CB | Futures | 157.237 | 157.237 | 156.563 | 156.563 | 24.0 |
| 2014-09-10 | CC | Futures | 2274.0 | 2277.0 | 2254.0 | 2261.0 | 11910.0 |
| 2014-09-10 | CSC | Futures | 5.129 | 5.129 | 4.954 | 4.977 | 7.0 |
| 2014-09-10 | CT | Futures | 85.51 | 88.91 | 85.51 | 88.48 | 41.0 |
| 2014-09-10 | DC | Futures | 41.3 | 41.53 | 40.01 | 40.18 | 187.0 |
| 2014-09-10 | DX | Futures | 80.005 | 80.289 | 79.929 | 80.159 | 33473.0 |
| 2014-09-10 | E1 | Futures | 1.37251 | 1.3734 | 1.36228 | 1.36548 | 40440.0 |
| 2014-09-10 | E6 | Futures | 1.52436 | 1.52706 | 1.51776 | 1.52024 | 188283.0 |
| 2014-09-10 | E7 | Futures | 1.5144 | 1.5173 | 1.5083 | 1.5107 | 3972.0 |
| 2014-09-10 | ED | Futures | 95.4183 | 95.423 | 95.4135 | 95.4183 | 121123.0 |
| 2014-09-10 | ER | Futures | 98.014 | 98.014 | 98.004 | 98.014 | 106705.0 |
| 2014-09-10 | EW | Futures | 1483.8 | 1487.3 | 1475.9 | 1484.6 | 9614.0 |
| 2014-09-10 | FBTP | Futures | 94.94 | 95.02 | 94.41 | 94.64 | 90587.0 |
| 2014-09-10 | FBTS | Futures | 98.792 | 98.792 | 98.668 | 98.721 | 15473.0 |
| 2014-09-10 | FCE | Futures | 3535.2 | 3561.1 | 3530.8 | 3545.6 | 103361.0 |
| 2014-09-10 | FDAX | Futures | 10655.7 | 10734.5 | 10612.2 | 10688.7 | 104810.0 |
| 2014-09-10 | FESX | Futures | 2333.2 | 2349.9 | 2325.2 | 2339.7 | 80476.0 |
| 2014-09-10 | FEU3 | Futures | 98.631 | 98.636 | 98.631 | 98.636 | 750.0 |
| 2014-09-10 | FGBL | Futures | 130.68 | 130.78 | 130.4 | 130.72 | 836408.0 |
| 2014-09-10 | FGBM | Futures | 122.58 | 122.69 | 122.5 | 122.63 | 435434.0 |
| 2014-09-10 | FGBS | Futures | 110.943 | 110.953 | 110.918 | 110.938 | 250847.0 |
| 2014-09-10 | FGBX | Futures | 139.28 | 139.46 | 138.66 | 139.3 | 26649.0 |
| 2014-09-10 | FMWO | Futures | 5768.9 | 5775.1 | 5761.3 | 5767.6 | 701.0 |
| 2014-09-10 | FOAT | Futures | 120.89 | 120.95 | 120.46 | 120.79 | 79916.0 |
| 2014-09-10 | FTDX | Futures | 1178.6 | 1181.9 | 1178.6 | 1181.9 | 2.0 |
| 2014-09-10 | FTI | Futures | 360.39 | 362.25 | 360.0 | 361.95 | 258.0 |
| 2014-09-10 | FTUK | Futures | 5251.5 | 5282.5 | 5238.4 | 5265.5 | 12356.0 |
| 2014-09-10 | FVSA | Futures | 1408.0 | 1429.4 | 1395.16 | 1412.28 | 12488.0 |
| 2014-09-10 | FXXP | Futures | 259.9 | 261.2 | 259.7 | 260.9 | 3227.0 |
| 2014-09-10 | G | Futures | 96.35 | 96.4 | 96.09 | 96.26 | 200997.0 |
| 2014-09-10 | GF | Futures | 354.672 | 357.55 | 349.927 | 353.35 | 5200.0 |
| 2014-09-10 | GSCI | Futures | 997.41 | 997.41 | 990.09 | 991.02 | 1644.0 |
| 2014-09-10 | HE | Futures | 128.753 | 129.811 | 127.182 | 129.479 | 31200.0 |
| 2014-09-10 | HG | Futures | 3.9422 | 3.9574 | 3.9226 | 3.9454 | 39562.0 |
| 2014-09-10 | HH | Futures | 48.404 | 48.441 | 48.404 | 48.441 | 889.0 |
| 2014-09-10 | HO | Futures | 2.2355 | 2.2379 | 2.1993 | 2.2062 | 35564.0 |
> showing 50 of 103 rows — these rows as CSV