PREVIEW / futures_daily / 2015-07-22
file: by_date/futures_daily/2015/2015-07-22.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-07-22 | ES | Futures | 2233.83 | 2238.33 | 2228.0 | 2234.1 | 1224393.0 |
| 2015-07-22 | NQ | Futures | 5391.6 | 5413.2 | 5357.45 | 5390.44 | 235343.0 |
| 2015-07-22 | YM | Futures | 18297.4 | 18319.0 | 18207.0 | 18265.6 | 103142.0 |
| 2015-07-22 | CL | Futures | 84.2 | 84.2 | 81.42 | 81.67 | 347986.0 |
| 2015-07-22 | GC | Futures | 1436.7 | 1439.6 | 1417.8 | 1425.5 | 182184.0 |
| 2015-07-22 | ZN | Futures | 120.436916 | 120.645568 | 120.33259 | 120.481627 | 847959.0 |
| 2015-07-22 | A6 | Futures | 0.73297 | 0.73465 | 0.72682 | 0.72801 | 89123.0 |
| 2015-07-22 | AD | Futures | 0.78927 | 0.78999 | 0.78293 | 0.78447 | 57334.0 |
| 2015-07-22 | ALI | Futures | 2212.95 | 2212.95 | 2212.95 | 2212.95 | 0.0 |
| 2015-07-22 | B | Futures | 52.93 | 52.95 | 52.04 | 52.23 | 221457.0 |
| 2015-07-22 | B6 | Futures | 1.6367 | 1.6463 | 1.6361 | 1.6412 | 85169.0 |
| 2015-07-22 | BFX | Futures | 4603.5 | 4614.4 | 4599.9 | 4601.1 | 26.0 |
| 2015-07-22 | BR | Futures | 0.18503 | 0.18542 | 0.18288 | 0.1833 | 1359.0 |
| 2015-07-22 | BZ | Futures | 52.86 | 52.91 | 52.01 | 52.2 | 25241.0 |
| 2015-07-22 | C | Futures | 2378.0 | 2386.0 | 2318.0 | 2337.0 | 10542.0 |
| 2015-07-22 | CB | Futures | 157.069 | 158.082 | 157.069 | 158.082 | 10.0 |
| 2015-07-22 | CC | Futures | 2463.0 | 2465.0 | 2379.0 | 2410.0 | 26118.0 |
| 2015-07-22 | CNH | Futures | 7.0033 | 7.0043 | 7.0027 | 7.0033 | 44.0 |
| 2015-07-22 | CSC | Futures | 4.353 | 4.394 | 4.348 | 4.381 | 151.0 |
| 2015-07-22 | CT | Futures | 79.96 | 80.42 | 79.59 | 80.32 | 10.0 |
| 2015-07-22 | DC | Futures | 35.04 | 35.58 | 34.93 | 35.32 | 326.0 |
| 2015-07-22 | DX | Futures | 91.222 | 91.68 | 91.002 | 91.476 | 35540.0 |
| 2015-07-22 | E1 | Futures | 1.32681 | 1.33024 | 1.32046 | 1.323 | 11943.0 |
| 2015-07-22 | E6 | Futures | 1.28592 | 1.28932 | 1.27781 | 1.28192 | 176952.0 |
| 2015-07-22 | E7 | Futures | 1.2788 | 1.2823 | 1.2708 | 1.2748 | 3130.0 |
| 2015-07-22 | EBM | Futures | 306.6 | 309.47 | 305.37 | 305.78 | 12504.0 |
| 2015-07-22 | ED | Futures | 95.627 | 95.6318 | 95.6222 | 95.627 | 128900.0 |
| 2015-07-22 | ER | Futures | 98.107 | 98.112 | 98.107 | 98.107 | 19389.0 |
| 2015-07-22 | EW | Futures | 1562.9 | 1571.9 | 1557.8 | 1570.1 | 10647.0 |
| 2015-07-22 | FBTP | Futures | 99.87 | 100.13 | 99.53 | 100.06 | 58820.0 |
| 2015-07-22 | FBTS | Futures | 99.964 | 99.999 | 99.901 | 99.999 | 14069.0 |
| 2015-07-22 | FCE | Futures | 4248.3 | 4255.4 | 4225.0 | 4238.7 | 60240.0 |
| 2015-07-22 | FDAX | Futures | 12787.4 | 12818.9 | 12691.2 | 12737.1 | 78458.0 |
| 2015-07-22 | FESX | Futures | 2690.9 | 2699.8 | 2674.6 | 2688.7 | 711300.0 |
| 2015-07-22 | FEU3 | Futures | 98.754 | 98.754 | 98.749 | 98.749 | 4.0 |
| 2015-07-22 | FGBL | Futures | 136.51 | 136.77 | 136.21 | 136.69 | 397214.0 |
| 2015-07-22 | FGBM | Futures | 124.31 | 124.43 | 124.25 | 124.38 | 312107.0 |
| 2015-07-22 | FGBS | Futures | 111.193 | 111.218 | 111.188 | 111.213 | 109032.0 |
| 2015-07-22 | FGBX | Futures | 154.04 | 154.61 | 153.21 | 154.38 | 13935.0 |
| 2015-07-22 | FMWO | Futures | 5855.7 | 5855.7 | 5843.3 | 5843.3 | 170.0 |
| 2015-07-22 | FOAT | Futures | 124.95 | 125.1 | 124.6 | 125.03 | 38637.0 |
| 2015-07-22 | FTDX | Futures | 1691.8 | 1703.1 | 1688.0 | 1699.3 | 329.0 |
| 2015-07-22 | FTI | Futures | 426.77 | 427.81 | 424.48 | 426.16 | 20838.0 |
| 2015-07-22 | FTUK | Futures | 5319.1 | 5319.5 | 5244.8 | 5257.1 | 84927.0 |
| 2015-07-22 | FVSA | Futures | 1741.38 | 1758.92 | 1706.29 | 1736.99 | 6536.0 |
| 2015-07-22 | FXXP | Futures | 307.0 | 308.2 | 306.2 | 306.3 | 17567.0 |
| 2015-07-22 | G | Futures | 101.14 | 101.56 | 101.02 | 101.45 | 146226.0 |
| 2015-07-22 | GF | Futures | 362.269 | 365.371 | 360.441 | 361.078 | 3849.0 |
| 2015-07-22 | GSCI | Futures | 662.24 | 662.24 | 657.66 | 658.99 | 20.0 |
| 2015-07-22 | HE | Futures | 85.453 | 87.994 | 85.453 | 87.715 | 22335.0 |
> showing 50 of 107 rows — these rows as CSV