PREVIEW / futures_daily / 2015-08-26
file: by_date/futures_daily/2015/2015-08-26.parquet size: 9 KB rows: 106
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-08-26 | ES | Futures | 1988.22 | 2059.23 | 1961.19 | 2053.93 | 3527300.0 |
| 2015-08-26 | NQ | Futures | 4712.98 | 4938.02 | 4621.92 | 4920.51 | 637925.0 |
| 2015-08-26 | YM | Futures | 16197.2 | 16737.4 | 15960.9 | 16688.1 | 432478.0 |
| 2015-08-26 | CL | Futures | 64.73 | 65.01 | 62.83 | 62.96 | 368722.0 |
| 2015-08-26 | GC | Futures | 1471.5 | 1479.4 | 1441.8 | 1451.7 | 207120.0 |
| 2015-08-26 | ZN | Futures | 122.627762 | 122.866222 | 121.882577 | 122.031614 | 2825932.0 |
| 2015-08-26 | A6 | Futures | 0.70662 | 0.70791 | 0.69959 | 0.70226 | 114914.0 |
| 2015-08-26 | AD | Futures | 0.76719 | 0.77158 | 0.76596 | 0.76647 | 72995.0 |
| 2015-08-26 | ALI | Futures | 2087.37 | 2087.37 | 2087.37 | 2087.37 | 0.0 |
| 2015-08-26 | B | Futures | 40.1 | 40.4 | 39.54 | 39.81 | 126114.0 |
| 2015-08-26 | B6 | Futures | 1.6511 | 1.6543 | 1.6262 | 1.6278 | 158785.0 |
| 2015-08-26 | BFX | Futures | 4056.8 | 4084.6 | 4021.8 | 4045.3 | 17.0 |
| 2015-08-26 | BR | Futures | 0.16512 | 0.16512 | 0.16337 | 0.165 | 3332.0 |
| 2015-08-26 | BZ | Futures | 39.99 | 40.34 | 39.57 | 39.81 | 18428.0 |
| 2015-08-26 | C | Futures | 2195.0 | 2218.0 | 2192.0 | 2216.0 | 3174.0 |
| 2015-08-26 | CB | Futures | 186.982 | 187.966 | 186.982 | 187.966 | 7.0 |
| 2015-08-26 | CC | Futures | 2274.0 | 2290.0 | 2256.0 | 2272.0 | 14040.0 |
| 2015-08-26 | CNH | Futures | 7.3245 | 7.3245 | 7.302 | 7.3074 | 22.0 |
| 2015-08-26 | CSC | Futures | 4.419 | 4.452 | 4.419 | 4.445 | 22.0 |
| 2015-08-26 | CT | Futures | 77.35 | 77.35 | 76.25 | 76.56 | 13.0 |
| 2015-08-26 | DC | Futures | 35.54 | 35.83 | 35.41 | 35.54 | 66.0 |
| 2015-08-26 | DX | Futures | 87.786 | 89.373 | 87.74 | 89.051 | 81424.0 |
| 2015-08-26 | E1 | Futures | 1.35234 | 1.35399 | 1.32999 | 1.33443 | 24824.0 |
| 2015-08-26 | E6 | Futures | 1.35335 | 1.35852 | 1.3268 | 1.33361 | 350694.0 |
| 2015-08-26 | E7 | Futures | 1.3459 | 1.351 | 1.3195 | 1.3263 | 6362.0 |
| 2015-08-26 | EBM | Futures | 270.94 | 271.76 | 266.02 | 266.84 | 4608.0 |
| 2015-08-26 | ED | Futures | 95.6678 | 95.6702 | 95.651 | 95.6606 | 265011.0 |
| 2015-08-26 | ER | Futures | 98.122 | 98.126 | 98.122 | 98.122 | 13486.0 |
| 2015-08-26 | EW | Futures | 1421.8 | 1454.5 | 1406.2 | 1448.4 | 35848.0 |
| 2015-08-26 | FBTP | Futures | 99.75 | 100.3 | 99.73 | 100.02 | 77435.0 |
| 2015-08-26 | FBTS | Futures | 99.964 | 99.999 | 99.955 | 99.964 | 18187.0 |
| 2015-08-26 | FCE | Futures | 3776.8 | 3843.0 | 3707.3 | 3768.9 | 185509.0 |
| 2015-08-26 | FDAX | Futures | 11047.4 | 11280.6 | 10888.2 | 11091.6 | 148765.0 |
| 2015-08-26 | FESX | Futures | 2353.4 | 2394.1 | 2310.5 | 2354.9 | 2134326.0 |
| 2015-08-26 | FGBL | Futures | 137.07 | 137.86 | 136.97 | 137.58 | 906045.0 |
| 2015-08-26 | FGBM | Futures | 124.58 | 124.79 | 124.58 | 124.74 | 463705.0 |
| 2015-08-26 | FGBS | Futures | 111.243 | 111.258 | 111.233 | 111.248 | 295761.0 |
| 2015-08-26 | FGBX | Futures | 156.33 | 158.69 | 155.56 | 157.43 | 40448.0 |
| 2015-08-26 | FMWO | Futures | 5290.8 | 5356.0 | 5263.7 | 5277.2 | 940.0 |
| 2015-08-26 | FOAT | Futures | 124.52 | 125.29 | 124.47 | 125.14 | 90674.0 |
| 2015-08-26 | FTDX | Futures | 1544.4 | 1574.5 | 1526.9 | 1550.0 | 787.0 |
| 2015-08-26 | FTI | Futures | 370.67 | 377.55 | 363.31 | 368.82 | 64550.0 |
| 2015-08-26 | FTUK | Futures | 4796.5 | 4840.2 | 4716.2 | 4765.5 | 176493.0 |
| 2015-08-26 | FVSA | Futures | 2390.61 | 2493.07 | 2275.35 | 2399.15 | 14486.0 |
| 2015-08-26 | FXXP | Futures | 270.0 | 274.4 | 265.8 | 269.7 | 35047.0 |
| 2015-08-26 | G | Futures | 104.0 | 104.46 | 103.49 | 103.67 | 192083.0 |
| 2015-08-26 | GF | Futures | 342.502 | 344.7 | 339.01 | 341.554 | 2254.0 |
| 2015-08-26 | GSCI | Futures | 559.78 | 559.78 | 553.43 | 555.16 | 231.0 |
| 2015-08-26 | HE | Futures | 92.336 | 92.747 | 91.003 | 91.618 | 14983.0 |
| 2015-08-26 | HG | Futures | 2.8729 | 2.8823 | 2.7847 | 2.7978 | 41920.0 |
> showing 50 of 106 rows — these rows as CSV