PREVIEW / futures_daily / 2014-07-07
file: by_date/futures_daily/2014/2014-07-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-07-07 | ES | Futures | 2053.7 | 2054.22 | 2043.57 | 2047.47 | 1151705.0 |
| 2014-07-07 | NQ | Futures | 4517.91 | 4519.06 | 4495.12 | 4504.64 | 175431.0 |
| 2014-07-07 | YM | Futures | 17131.6 | 17146.7 | 17059.9 | 17098.3 | 96811.0 |
| 2014-07-07 | CL | Futures | 190.08 | 190.21 | 188.49 | 189.12 | 189250.0 |
| 2014-07-07 | GC | Futures | 1740.7 | 1744.6 | 1728.8 | 1735.3 | 113065.0 |
| 2014-07-07 | ZN | Futures | 116.010538 | 116.171016 | 115.835472 | 116.141838 | 637578.0 |
| 2014-07-07 | A6 | Futures | 0.89866 | 0.90185 | 0.89847 | 0.90137 | 70064.0 |
| 2014-07-07 | AD | Futures | 0.95298 | 0.95379 | 0.94891 | 0.94983 | 53818.0 |
| 2014-07-07 | ALI | Futures | 2850.29 | 2850.29 | 2830.3 | 2830.3 | 36.0 |
| 2014-07-07 | B | Futures | 116.49 | 116.58 | 115.51 | 115.89 | 147613.0 |
| 2014-07-07 | B6 | Futures | 1.8021 | 1.805 | 1.7976 | 1.8 | 76692.0 |
| 2014-07-07 | BR | Futures | 0.23439 | 0.23445 | 0.23321 | 0.23363 | 429.0 |
| 2014-07-07 | BZ | Futures | 117.38 | 117.64 | 116.31 | 116.62 | 13840.0 |
| 2014-07-07 | C | Futures | 2020.0 | 2026.0 | 2013.0 | 2021.0 | 6173.0 |
| 2014-07-07 | CB | Futures | 120.594 | 120.915 | 120.035 | 120.915 | 3.0 |
| 2014-07-07 | CC | Futures | 2278.0 | 2280.0 | 2267.0 | 2277.0 | 6485.0 |
| 2014-07-07 | CSC | Futures | 4.377 | 4.421 | 4.377 | 4.417 | 18.0 |
| 2014-07-07 | CT | Futures | 90.37 | 90.37 | 88.31 | 88.6 | 45.0 |
| 2014-07-07 | DC | Futures | 35.37 | 35.37 | 34.92 | 35.27 | 127.0 |
| 2014-07-07 | DX | Futures | 76.251 | 76.323 | 76.166 | 76.192 | 11005.0 |
| 2014-07-07 | E1 | Futures | 1.43558 | 1.43635 | 1.43173 | 1.43596 | 30262.0 |
| 2014-07-07 | E6 | Futures | 1.60601 | 1.60648 | 1.60223 | 1.60613 | 126211.0 |
| 2014-07-07 | E7 | Futures | 1.5955 | 1.5959 | 1.5918 | 1.5957 | 1797.0 |
| 2014-07-07 | ED | Futures | 95.4162 | 95.4162 | 95.4067 | 95.4115 | 77281.0 |
| 2014-07-07 | ER | Futures | 97.92 | 97.925 | 97.916 | 97.92 | 12243.0 |
| 2014-07-07 | EW | Futures | 1498.3 | 1498.3 | 1481.0 | 1484.0 | 13929.0 |
| 2014-07-07 | FBTP | Futures | 91.7 | 91.83 | 91.63 | 91.8 | 25086.0 |
| 2014-07-07 | FBTS | Futures | 98.339 | 98.365 | 98.303 | 98.356 | 7908.0 |
| 2014-07-07 | FCE | Futures | 3566.9 | 3568.1 | 3515.4 | 3517.0 | 89602.0 |
| 2014-07-07 | FDAX | Futures | 11028.5 | 11035.7 | 10906.3 | 10923.3 | 73681.0 |
| 2014-07-07 | FDIV | Futures | 151.73 | 151.73 | 151.09 | 151.09 | 5.0 |
| 2014-07-07 | FESX | Futures | 2351.2 | 2351.9 | 2321.0 | 2323.1 | 628674.0 |
| 2014-07-07 | FGBL | Futures | 127.65 | 127.81 | 127.57 | 127.79 | 310149.0 |
| 2014-07-07 | FGBM | Futures | 121.46 | 121.55 | 121.44 | 121.51 | 261465.0 |
| 2014-07-07 | FGBS | Futures | 110.773 | 110.788 | 110.768 | 110.783 | 119462.0 |
| 2014-07-07 | FGBX | Futures | 132.38 | 132.51 | 132.1 | 132.43 | 9752.0 |
| 2014-07-07 | FMWO | Futures | 5840.6 | 5843.1 | 5819.2 | 5823.0 | 81.0 |
| 2014-07-07 | FOAT | Futures | 117.57 | 117.72 | 117.52 | 117.66 | 47945.0 |
| 2014-07-07 | FTDX | Futures | 1247.3 | 1247.3 | 1234.7 | 1235.6 | 76.0 |
| 2014-07-07 | FTI | Futures | 361.77 | 362.03 | 357.53 | 357.83 | 24305.0 |
| 2014-07-07 | FTUK | Futures | 5248.5 | 5250.4 | 5208.1 | 5215.0 | 63173.0 |
| 2014-07-07 | FVSA | Futures | 1216.3 | 1242.08 | 1199.1 | 1237.79 | 6765.0 |
| 2014-07-07 | FXXP | Futures | 260.9 | 261.4 | 258.9 | 259.2 | 4945.0 |
| 2014-07-07 | G | Futures | 93.08 | 93.39 | 92.98 | 93.34 | 83737.0 |
| 2014-07-07 | GF | Futures | 334.872 | 336.635 | 333.454 | 334.106 | 4544.0 |
| 2014-07-07 | GSCI | Futures | 1085.99 | 1087.66 | 1078.99 | 1079.49 | 568.0 |
| 2014-07-07 | HE | Futures | 138.575 | 139.651 | 138.155 | 138.339 | 14598.0 |
| 2014-07-07 | HG | Futures | 4.1867 | 4.2002 | 4.1375 | 4.1682 | 48965.0 |
| 2014-07-07 | HH | Futures | 55.132 | 55.196 | 53.198 | 53.425 | 678.0 |
| 2014-07-07 | HO | Futures | 2.3496 | 2.3536 | 2.3287 | 2.3378 | 19706.0 |
> showing 50 of 103 rows — these rows as CSV