PREVIEW / futures_daily / 2015-09-21
file: by_date/futures_daily/2015/2015-09-21.parquet size: 9 KB rows: 107
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 |
|---|---|---|---|---|---|---|---|
| 2015-09-21 | ES | Futures | 2073.52 | 2094.53 | 2062.08 | 2088.14 | 1513503.0 |
| 2015-09-21 | NQ | Futures | 5056.53 | 5099.5 | 5011.81 | 5075.83 | 254496.0 |
| 2015-09-21 | YM | Futures | 16833.4 | 16999.6 | 16742.7 | 16978.9 | 171597.0 |
| 2015-09-21 | CL | Futures | 72.78 | 75.52 | 72.33 | 75.43 | 344190.0 |
| 2015-09-21 | GC | Futures | 1469.9 | 1470.8 | 1457.0 | 1462.3 | 87119.0 |
| 2015-09-21 | ZN | Futures | 122.524074 | 122.524074 | 121.970276 | 122.015179 | 762809.0 |
| 2015-09-21 | A6 | Futures | 0.71513 | 0.71663 | 0.70903 | 0.71053 | 60711.0 |
| 2015-09-21 | AD | Futures | 0.77445 | 0.77732 | 0.77189 | 0.77404 | 55963.0 |
| 2015-09-21 | ALI | Futures | 2198.06 | 2198.06 | 2198.06 | 2198.06 | 0.0 |
| 2015-09-21 | B | Futures | 43.18 | 44.4 | 43.03 | 44.34 | 179898.0 |
| 2015-09-21 | B6 | Futures | 1.6343 | 1.6388 | 1.6296 | 1.6321 | 61212.0 |
| 2015-09-21 | BFX | Futures | 4162.1 | 4162.1 | 4153.6 | 4153.6 | 16.0 |
| 2015-09-21 | BR | Futures | 0.15207 | 0.15207 | 0.15072 | 0.15179 | 42.0 |
| 2015-09-21 | BZ | Futures | 43.13 | 44.39 | 43.09 | 44.33 | 18265.0 |
| 2015-09-21 | C | Futures | 2352.0 | 2364.0 | 2347.0 | 2362.0 | 7583.0 |
| 2015-09-21 | CB | Futures | 193.87 | 193.87 | 193.378 | 193.378 | 10.0 |
| 2015-09-21 | CC | Futures | 2432.0 | 2438.0 | 2420.0 | 2428.0 | 8170.0 |
| 2015-09-21 | CNH | Futures | 7.1685 | 7.1758 | 7.1662 | 7.1662 | 67.0 |
| 2015-09-21 | CSC | Futures | 4.345 | 4.345 | 4.296 | 4.307 | 68.0 |
| 2015-09-21 | CT | Futures | 72.52 | 73.92 | 72.4 | 73.12 | 19.0 |
| 2015-09-21 | DC | Futures | 34.81 | 34.81 | 34.3 | 34.37 | 126.0 |
| 2015-09-21 | DX | Futures | 89.261 | 89.911 | 89.018 | 89.817 | 36501.0 |
| 2015-09-21 | E1 | Futures | 1.31169 | 1.31943 | 1.30624 | 1.3103 | 15403.0 |
| 2015-09-21 | E6 | Futures | 1.32419 | 1.32923 | 1.31166 | 1.31271 | 200427.0 |
| 2015-09-21 | E7 | Futures | 1.3173 | 1.3219 | 1.3044 | 1.3055 | 4074.0 |
| 2015-09-21 | EBM | Futures | 243.34 | 249.19 | 242.97 | 248.82 | 22051.0 |
| 2015-09-21 | ED | Futures | 95.7159 | 95.7159 | 95.6967 | 95.7015 | 205525.0 |
| 2015-09-21 | ER | Futures | 98.126 | 98.126 | 98.122 | 98.126 | 21526.0 |
| 2015-09-21 | EW | Futures | 1485.0 | 1507.6 | 1479.3 | 1494.4 | 18358.0 |
| 2015-09-21 | FBTP | Futures | 102.19 | 102.19 | 101.72 | 101.81 | 61765.0 |
| 2015-09-21 | FBTS | Futures | 100.275 | 100.284 | 100.213 | 100.222 | 11326.0 |
| 2015-09-21 | FCE | Futures | 3769.1 | 3828.6 | 3754.5 | 3810.7 | 88117.0 |
| 2015-09-21 | FDAX | Futures | 10887.0 | 11014.2 | 10773.6 | 10980.1 | 106925.0 |
| 2015-09-21 | FESX | Futures | 2354.8 | 2390.0 | 2345.8 | 2381.8 | 888407.0 |
| 2015-09-21 | FEU3 | Futures | 98.769 | 98.774 | 98.769 | 98.774 | 18.0 |
| 2015-09-21 | FGBL | Futures | 138.16 | 138.21 | 137.7 | 137.79 | 419835.0 |
| 2015-09-21 | FGBM | Futures | 125.0 | 125.0 | 124.89 | 124.94 | 299348.0 |
| 2015-09-21 | FGBS | Futures | 111.263 | 111.268 | 111.233 | 111.253 | 217730.0 |
| 2015-09-21 | FGBX | Futures | 157.45 | 157.45 | 155.59 | 155.82 | 18805.0 |
| 2015-09-21 | FMWO | Futures | 5425.8 | 5448.1 | 5425.8 | 5445.6 | 446.0 |
| 2015-09-21 | FOAT | Futures | 126.47 | 126.53 | 126.05 | 126.16 | 53291.0 |
| 2015-09-21 | FTDX | Futures | 1665.2 | 1665.2 | 1631.5 | 1658.5 | 279.0 |
| 2015-09-21 | FTI | Futures | 369.47 | 377.86 | 369.47 | 375.77 | 33030.0 |
| 2015-09-21 | FTUK | Futures | 4859.6 | 4933.9 | 4853.1 | 4893.7 | 85823.0 |
| 2015-09-21 | FVSA | Futures | 2413.43 | 2427.3 | 2339.46 | 2348.71 | 9041.0 |
| 2015-09-21 | FXXP | Futures | 274.6 | 279.4 | 274.5 | 278.4 | 17462.0 |
| 2015-09-21 | G | Futures | 104.63 | 104.64 | 104.16 | 104.25 | 133365.0 |
| 2015-09-21 | GF | Futures | 332.382 | 335.489 | 331.583 | 333.225 | 3178.0 |
| 2015-09-21 | GSCI | Futures | 589.16 | 595.85 | 589.16 | 594.22 | 41.0 |
| 2015-09-21 | HE | Futures | 95.982 | 97.515 | 95.982 | 97.179 | 12190.0 |
> showing 50 of 107 rows — these rows as CSV