PREVIEW / futures_daily / 2014-06-10
file: by_date/futures_daily/2014/2014-06-10.parquet size: 9 KB rows: 99
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-10 | ES | Futures | 2016.77 | 2019.35 | 2010.3 | 2018.06 | 1038073.0 |
| 2014-06-10 | NQ | Futures | 4365.57 | 4377.65 | 4356.64 | 4374.77 | 154780.0 |
| 2014-06-10 | YM | Futures | 17005.4 | 17031.7 | 16968.1 | 17022.6 | 4537.0 |
| 2014-06-10 | CL | Futures | 190.01 | 191.1 | 189.14 | 189.81 | 255599.0 |
| 2014-06-10 | GC | Futures | 1650.5 | 1665.2 | 1647.1 | 1660.3 | 107080.0 |
| 2014-06-10 | ZN | Futures | 116.010538 | 116.11266 | 115.704172 | 115.791706 | 1040230.0 |
| 2014-06-10 | A6 | Futures | 0.89779 | 0.90098 | 0.89682 | 0.89963 | 22515.0 |
| 2014-06-10 | AD | Futures | 0.92901 | 0.93053 | 0.92769 | 0.9288 | 24276.0 |
| 2014-06-10 | ALI | Futures | 2841.06 | 2841.06 | 2841.06 | 2841.06 | 22.0 |
| 2014-06-10 | B | Futures | 114.27 | 114.61 | 113.49 | 113.94 | 248636.0 |
| 2014-06-10 | B6 | Futures | 1.7651 | 1.7668 | 1.7588 | 1.76 | 80841.0 |
| 2014-06-10 | BR | Futures | 0.23141 | 0.23168 | 0.23062 | 0.23144 | 144.0 |
| 2014-06-10 | BZ | Futures | 115.23 | 115.6 | 114.5 | 114.93 | 17147.0 |
| 2014-06-10 | C | Futures | 2032.0 | 2038.0 | 2027.0 | 2035.0 | 2724.0 |
| 2014-06-10 | CC | Futures | 2272.0 | 2273.0 | 2258.0 | 2267.0 | 24320.0 |
| 2014-06-10 | CSC | Futures | 4.488 | 4.491 | 4.484 | 4.488 | 11.0 |
| 2014-06-10 | CT | Futures | 95.2 | 97.58 | 95.09 | 97.18 | 27257.0 |
| 2014-06-10 | DC | Futures | 35.43 | 35.51 | 35.36 | 35.43 | 125.0 |
| 2014-06-10 | DX | Futures | 76.65 | 76.873 | 76.579 | 76.83 | 11759.0 |
| 2014-06-10 | E1 | Futures | 1.43006 | 1.43109 | 1.4243 | 1.4266 | 17147.0 |
| 2014-06-10 | E6 | Futures | 1.60412 | 1.60506 | 1.59704 | 1.59822 | 99323.0 |
| 2014-06-10 | E7 | Futures | 1.5934 | 1.5946 | 1.5867 | 1.5878 | 1591.0 |
| 2014-06-10 | ED | Futures | 95.4115 | 95.4162 | 95.4067 | 95.4115 | 99365.0 |
| 2014-06-10 | ER | Futures | 97.881 | 97.886 | 97.876 | 97.881 | 67783.0 |
| 2014-06-10 | EW | Futures | 1460.2 | 1462.6 | 1456.8 | 1462.5 | 575.0 |
| 2014-06-10 | FBTP | Futures | 91.56 | 91.63 | 90.87 | 91.08 | 68289.0 |
| 2014-06-10 | FBTS | Futures | 98.152 | 98.152 | 97.93 | 97.965 | 17345.0 |
| 2014-06-10 | FCE | Futures | 3661.5 | 3670.6 | 3653.5 | 3665.5 | 61004.0 |
| 2014-06-10 | FDAX | Futures | 11042.6 | 11085.1 | 11029.3 | 11068.0 | 64625.0 |
| 2014-06-10 | FESX | Futures | 2374.2 | 2382.1 | 2368.4 | 2376.3 | 117107.0 |
| 2014-06-10 | FEU3 | Futures | 98.502 | 98.502 | 98.502 | 98.502 | 1.0 |
| 2014-06-10 | FGBL | Futures | 126.57 | 126.58 | 126.03 | 126.09 | 543497.0 |
| 2014-06-10 | FGBM | Futures | 121.09 | 121.1 | 120.85 | 120.88 | 425975.0 |
| 2014-06-10 | FGBS | Futures | 110.713 | 110.718 | 110.688 | 110.693 | 221711.0 |
| 2014-06-10 | FGBX | Futures | 130.2 | 130.28 | 129.33 | 129.47 | 19719.0 |
| 2014-06-10 | FMWO | Futures | 5758.8 | 5765.1 | 5758.8 | 5765.1 | 27.0 |
| 2014-06-10 | FOAT | Futures | 116.63 | 116.66 | 115.96 | 116.02 | 61921.0 |
| 2014-06-10 | FTDX | Futures | 1243.1 | 1243.1 | 1242.7 | 1242.7 | 1.0 |
| 2014-06-10 | FTI | Futures | 358.66 | 359.22 | 358.66 | 359.22 | 36.0 |
| 2014-06-10 | FTUK | Futures | 5235.4 | 5249.2 | 5213.8 | 5238.8 | 6743.0 |
| 2014-06-10 | FVSA | Futures | 1349.53 | 1363.54 | 1316.84 | 1321.51 | 3924.0 |
| 2014-06-10 | FXXP | Futures | 261.4 | 262.6 | 261.4 | 262.6 | 3455.0 |
| 2014-06-10 | G | Futures | 93.44 | 93.54 | 93.15 | 93.19 | 148343.0 |
| 2014-06-10 | GF | Futures | 312.113 | 315.102 | 310.159 | 314.45 | 5576.0 |
| 2014-06-10 | GSCI | Futures | 1081.57 | 1082.41 | 1074.91 | 1077.82 | 2353.0 |
| 2014-06-10 | HE | Futures | 133.312 | 133.496 | 131.365 | 131.681 | 20206.0 |
| 2014-06-10 | HG | Futures | 3.8985 | 3.91 | 3.8608 | 3.9011 | 47654.0 |
| 2014-06-10 | HH | Futures | 58.463 | 58.539 | 57.335 | 57.424 | 2812.0 |
| 2014-06-10 | HO | Futures | 2.3175 | 2.3239 | 2.3025 | 2.314 | 13925.0 |
| 2014-06-10 | HRC | Futures | 2380.5 | 2380.5 | 2380.5 | 2380.5 | 0.0 |
> showing 50 of 99 rows — these rows as CSV