PREVIEW / futures_daily / 2015-09-04
file: by_date/futures_daily/2015/2015-09-04.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-09-04 | ES | Futures | 2063.73 | 2065.85 | 2021.87 | 2036.7 | 2138986.0 |
| 2015-09-04 | NQ | Futures | 4940.65 | 4947.36 | 4851.04 | 4896.57 | 354122.0 |
| 2015-09-04 | YM | Futures | 16789.7 | 16809.3 | 16441.6 | 16554.6 | 232179.0 |
| 2015-09-04 | CL | Futures | 76.14 | 77.03 | 74.39 | 75.11 | 385631.0 |
| 2015-09-04 | GC | Futures | 1451.6 | 1462.7 | 1440.2 | 1447.6 | 113525.0 |
| 2015-09-04 | ZN | Futures | 122.091229 | 122.627762 | 122.046517 | 122.374399 | 54582.0 |
| 2015-09-04 | A6 | Futures | 0.69414 | 0.69513 | 0.68394 | 0.68572 | 105099.0 |
| 2015-09-04 | AD | Futures | 0.77567 | 0.7771 | 0.76933 | 0.77148 | 74321.0 |
| 2015-09-04 | ALI | Futures | 2187.1 | 2187.1 | 2187.1 | 2187.1 | 0.0 |
| 2015-09-04 | B | Futures | 46.78 | 46.99 | 45.43 | 45.77 | 145071.0 |
| 2015-09-04 | B6 | Futures | 1.6054 | 1.608 | 1.596 | 1.5981 | 78923.0 |
| 2015-09-04 | BFX | Futures | 4111.3 | 4111.3 | 4107.6 | 4110.7 | 18.0 |
| 2015-09-04 | BR | Futures | 0.15937 | 0.15937 | 0.15558 | 0.15577 | 561.0 |
| 2015-09-04 | BZ | Futures | 46.23 | 46.95 | 45.58 | 45.77 | 15349.0 |
| 2015-09-04 | C | Futures | 2248.0 | 2300.0 | 2248.0 | 2286.0 | 4092.0 |
| 2015-09-04 | CC | Futures | 2292.0 | 2341.0 | 2291.0 | 2323.0 | 27902.0 |
| 2015-09-04 | CSC | Futures | 4.427 | 4.447 | 4.427 | 4.447 | 3.0 |
| 2015-09-04 | CT | Futures | 76.48 | 77.18 | 76.48 | 77.18 | 9.0 |
| 2015-09-04 | DC | Futures | 35.32 | 35.43 | 35.3 | 35.34 | 29.0 |
| 2015-09-04 | DX | Futures | 90.239 | 90.421 | 89.546 | 90.089 | 44761.0 |
| 2015-09-04 | E1 | Futures | 1.30396 | 1.31196 | 1.29989 | 1.30523 | 17183.0 |
| 2015-09-04 | E6 | Futures | 1.30636 | 1.31576 | 1.30283 | 1.30988 | 248477.0 |
| 2015-09-04 | E7 | Futures | 1.2995 | 1.3085 | 1.2956 | 1.3027 | 4691.0 |
| 2015-09-04 | EBM | Futures | 236.1 | 247.57 | 236.1 | 242.24 | 1443.0 |
| 2015-09-04 | ED | Futures | 95.6486 | 95.6654 | 95.639 | 95.651 | 232550.0 |
| 2015-09-04 | ER | Futures | 98.131 | 98.131 | 98.126 | 98.126 | 21167.0 |
| 2015-09-04 | EW | Futures | 1467.0 | 1467.0 | 1443.7 | 1452.1 | 15053.0 |
| 2015-09-04 | FBTP | Futures | 100.82 | 100.97 | 100.46 | 100.85 | 145353.0 |
| 2015-09-04 | FBTS | Futures | 100.168 | 100.284 | 100.133 | 100.257 | 39411.0 |
| 2015-09-04 | FCE | Futures | 3836.3 | 3863.9 | 3756.3 | 3788.6 | 120400.0 |
| 2015-09-04 | FDAX | Futures | 11213.2 | 11295.0 | 11005.3 | 11114.2 | 107884.0 |
| 2015-09-04 | FDIV | Futures | 137.06 | 137.06 | 136.04 | 136.04 | 1.0 |
| 2015-09-04 | FESX | Futures | 2380.8 | 2397.8 | 2332.7 | 2357.1 | 1409186.0 |
| 2015-09-04 | FEU3 | Futures | 98.774 | 98.774 | 98.774 | 98.774 | 56.0 |
| 2015-09-04 | FGBL | Futures | 137.62 | 138.25 | 137.5 | 137.96 | 1034566.0 |
| 2015-09-04 | FGBM | Futures | 124.81 | 124.91 | 124.74 | 124.87 | 843936.0 |
| 2015-09-04 | FGBS | Futures | 111.248 | 111.263 | 111.223 | 111.258 | 367280.0 |
| 2015-09-04 | FGBX | Futures | 156.07 | 158.32 | 155.72 | 157.39 | 58977.0 |
| 2015-09-04 | FMWO | Futures | 5315.4 | 5315.4 | 5284.6 | 5288.3 | 867.0 |
| 2015-09-04 | FOAT | Futures | 125.42 | 125.92 | 125.26 | 125.79 | 124823.0 |
| 2015-09-04 | FTDX | Futures | 1606.1 | 1606.1 | 1583.5 | 1591.9 | 166.0 |
| 2015-09-04 | FTI | Futures | 377.42 | 379.36 | 370.06 | 372.39 | 47130.0 |
| 2015-09-04 | FTUK | Futures | 4851.7 | 4877.6 | 4773.0 | 4807.6 | 118913.0 |
| 2015-09-04 | FVSA | Futures | 2561.37 | 2877.27 | 2557.1 | 2770.55 | 16313.0 |
| 2015-09-04 | FXXP | Futures | 275.0 | 275.7 | 269.9 | 271.5 | 36362.0 |
| 2015-09-04 | G | Futures | 104.24 | 104.8 | 104.24 | 104.64 | 161599.0 |
| 2015-09-04 | GF | Futures | 348.623 | 348.623 | 346.381 | 347.157 | 724.0 |
| 2015-09-04 | GSCI | Futures | 605.38 | 605.38 | 601.59 | 601.59 | 1172.0 |
| 2015-09-04 | HE | Futures | 95.037 | 95.584 | 94.285 | 94.558 | 12742.0 |
| 2015-09-04 | HG | Futures | 2.9768 | 2.9781 | 2.8867 | 2.8942 | 39159.0 |
> showing 50 of 106 rows — these rows as CSV