PREVIEW / futures_daily / 2014-06-30
file: by_date/futures_daily/2014/2014-06-30.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-30 | ES | Futures | 2027.47 | 2032.67 | 2023.58 | 2028.25 | 1155861.0 |
| 2014-06-30 | NQ | Futures | 4420.7 | 4443.49 | 4416.38 | 4431.09 | 154827.0 |
| 2014-06-30 | YM | Futures | 16903.5 | 16937.8 | 16867.2 | 16890.4 | 101190.0 |
| 2014-06-30 | CL | Futures | 193.06 | 193.19 | 191.18 | 192.48 | 215334.0 |
| 2014-06-30 | GC | Futures | 1735.0 | 1752.9 | 1727.4 | 1741.9 | 127612.0 |
| 2014-06-30 | ZN | Futures | 116.798336 | 116.929636 | 116.667037 | 116.87128 | 825135.0 |
| 2014-06-30 | A6 | Futures | 0.90591 | 0.90736 | 0.90233 | 0.9062 | 61727.0 |
| 2014-06-30 | AD | Futures | 0.95064 | 0.95216 | 0.9477 | 0.95054 | 55414.0 |
| 2014-06-30 | ALI | Futures | 2788.11 | 2802.17 | 2776.87 | 2802.17 | 14.0 |
| 2014-06-30 | B | Futures | 118.51 | 118.54 | 117.65 | 117.87 | 171010.0 |
| 2014-06-30 | B6 | Futures | 1.7898 | 1.7982 | 1.7869 | 1.7971 | 96352.0 |
| 2014-06-30 | BFX | Futures | 3793.7 | 3797.6 | 3792.9 | 3793.2 | 12.0 |
| 2014-06-30 | BR | Futures | 0.23545 | 0.23579 | 0.23387 | 0.23429 | 2256.0 |
| 2014-06-30 | BZ | Futures | 119.11 | 119.15 | 118.4 | 118.62 | 13793.0 |
| 2014-06-30 | C | Futures | 2058.0 | 2067.0 | 2043.0 | 2053.0 | 9909.0 |
| 2014-06-30 | CB | Futures | 124.926 | 126.323 | 124.926 | 126.323 | 11.0 |
| 2014-06-30 | CC | Futures | 2299.0 | 2309.0 | 2292.0 | 2298.0 | 14106.0 |
| 2014-06-30 | CSC | Futures | 4.622 | 4.622 | 4.578 | 4.589 | 42.0 |
| 2014-06-30 | CT | Futures | 92.76 | 94.17 | 92.09 | 92.57 | 35.0 |
| 2014-06-30 | DC | Futures | 36.9 | 36.98 | 36.38 | 36.59 | 161.0 |
| 2014-06-30 | DX | Futures | 76.009 | 76.057 | 75.748 | 75.759 | 24939.0 |
| 2014-06-30 | E1 | Futures | 1.43981 | 1.4475 | 1.43878 | 1.44686 | 38948.0 |
| 2014-06-30 | E6 | Futures | 1.61049 | 1.61674 | 1.6099 | 1.61627 | 145256.0 |
| 2014-06-30 | E7 | Futures | 1.5999 | 1.6062 | 1.5994 | 1.6057 | 1911.0 |
| 2014-06-30 | ED | Futures | 95.4162 | 95.4162 | 95.4115 | 95.4115 | 49840.0 |
| 2014-06-30 | ER | Futures | 97.916 | 97.92 | 97.916 | 97.92 | 29147.0 |
| 2014-06-30 | EW | Futures | 1477.5 | 1488.4 | 1473.4 | 1484.4 | 18919.0 |
| 2014-06-30 | FBTP | Futures | 91.56 | 91.73 | 91.41 | 91.51 | 37555.0 |
| 2014-06-30 | FBTS | Futures | 97.974 | 98.188 | 97.974 | 98.134 | 9631.0 |
| 2014-06-30 | FCE | Futures | 3551.3 | 3558.9 | 3517.4 | 3530.5 | 87174.0 |
| 2014-06-30 | FDAX | Futures | 10845.7 | 10900.7 | 10798.9 | 10858.3 | 85272.0 |
| 2014-06-30 | FESX | Futures | 2326.0 | 2333.2 | 2305.9 | 2323.8 | 734167.0 |
| 2014-06-30 | FGBL | Futures | 127.74 | 127.94 | 127.63 | 127.83 | 484605.0 |
| 2014-06-30 | FGBM | Futures | 121.35 | 121.5 | 121.25 | 121.46 | 356997.0 |
| 2014-06-30 | FGBS | Futures | 110.743 | 110.768 | 110.733 | 110.758 | 211894.0 |
| 2014-06-30 | FGBX | Futures | 132.75 | 133.46 | 132.75 | 133.15 | 20300.0 |
| 2014-06-30 | FMWO | Futures | 5780.2 | 5794.0 | 5777.7 | 5794.0 | 517.0 |
| 2014-06-30 | FOAT | Futures | 117.56 | 117.69 | 117.44 | 117.6 | 54109.0 |
| 2014-06-30 | FTDX | Futures | 1231.9 | 1239.4 | 1224.4 | 1227.7 | 123.0 |
| 2014-06-30 | FTI | Futures | 355.93 | 357.96 | 355.33 | 357.1 | 24789.0 |
| 2014-06-30 | FTUK | Futures | 5172.3 | 5177.3 | 5139.6 | 5161.9 | 82071.0 |
| 2014-06-30 | FVSA | Futures | 1323.74 | 1345.23 | 1310.85 | 1319.44 | 3304.0 |
| 2014-06-30 | FXXP | Futures | 257.2 | 257.9 | 256.0 | 257.1 | 4183.0 |
| 2014-06-30 | G | Futures | 94.02 | 94.1 | 93.73 | 93.79 | 118574.0 |
| 2014-06-30 | GF | Futures | 330.466 | 331.232 | 325.14 | 326.098 | 5326.0 |
| 2014-06-30 | GSCI | Futures | 1104.5 | 1104.5 | 1096.66 | 1099.91 | 493.0 |
| 2014-06-30 | HE | Futures | 140.545 | 140.572 | 138.888 | 139.572 | 11120.0 |
| 2014-06-30 | HG | Futures | 4.0455 | 4.1037 | 4.0417 | 4.0947 | 43907.0 |
| 2014-06-30 | HH | Futures | 55.866 | 56.688 | 55.448 | 56.41 | 1041.0 |
| 2014-06-30 | HO | Futures | 2.4049 | 2.4049 | 2.3819 | 2.3838 | 19685.0 |
> showing 50 of 103 rows — these rows as CSV