PREVIEW / futures_daily / 2012-02-15
file: by_date/futures_daily/2012/2012-02-15.parquet size: 9 KB rows: 98
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 |
|---|---|---|---|---|---|---|---|
| 2012-02-15 | ES | Futures | 1352.31 | 1362.84 | 1342.77 | 1347.04 | 2282387.0 |
| 2012-02-15 | NQ | Futures | 2946.48 | 2973.92 | 2919.03 | 2924.75 | 393394.0 |
| 2012-02-15 | YM | Futures | 12416.3 | 12505.2 | 12309.9 | 12342.8 | 146648.0 |
| 2012-02-15 | CL | Futures | 187.55 | 190.63 | 187.04 | 189.22 | 157860.0 |
| 2012-02-15 | GC | Futures | 2307.3 | 2329.0 | 2303.7 | 2314.1 | 140860.0 |
| 2012-02-15 | ZN | Futures | 113.543325 | 113.867388 | 113.381294 | 113.705357 | 1007304.0 |
| 2012-02-15 | A6 | Futures | 0.94795 | 0.95552 | 0.94591 | 0.94742 | 152582.0 |
| 2012-02-15 | AD | Futures | 1.00422 | 1.00924 | 1.00252 | 1.00372 | 92410.0 |
| 2012-02-15 | B | Futures | 104.6 | 106.87 | 104.56 | 105.92 | 216543.0 |
| 2012-02-15 | B6 | Futures | 1.6403 | 1.6446 | 1.6378 | 1.6399 | 100608.0 |
| 2012-02-15 | BFX | Futures | 2751.7 | 2763.1 | 2727.0 | 2732.7 | 429.0 |
| 2012-02-15 | BR | Futures | 0.27156 | 0.27156 | 0.27004 | 0.271 | 22.0 |
| 2012-02-15 | BZ | Futures | 111.9 | 113.76 | 111.9 | 112.88 | 756.0 |
| 2012-02-15 | C | Futures | 1520.0 | 1586.0 | 1509.0 | 1582.0 | 5520.0 |
| 2012-02-15 | CB | Futures | 79.389 | 79.389 | 79.254 | 79.389 | 9.0 |
| 2012-02-15 | CC | Futures | 1764.0 | 1834.0 | 1732.0 | 1819.0 | 18562.0 |
| 2012-02-15 | CSC | Futures | 3.732 | 3.839 | 3.717 | 3.756 | 48.0 |
| 2012-02-15 | CT | Futures | 118.81 | 121.54 | 118.68 | 119.14 | 11698.0 |
| 2012-02-15 | DC | Futures | 26.08 | 27.1 | 26.08 | 26.46 | 754.0 |
| 2012-02-15 | DX | Futures | 77.437 | 77.729 | 77.087 | 77.654 | 33368.0 |
| 2012-02-15 | E1 | Futures | 1.42748 | 1.43418 | 1.41935 | 1.42118 | 44592.0 |
| 2012-02-15 | E6 | Futures | 1.56991 | 1.57684 | 1.55927 | 1.56142 | 321141.0 |
| 2012-02-15 | E7 | Futures | 1.5552 | 1.5625 | 1.5449 | 1.5472 | 5633.0 |
| 2012-02-15 | EBM | Futures | 275.5 | 276.49 | 273.54 | 273.87 | 8875.0 |
| 2012-02-15 | ED | Futures | 95.1035 | 95.1131 | 95.0939 | 95.0987 | 140706.0 |
| 2012-02-15 | ER | Futures | 97.444 | 97.444 | 97.43 | 97.43 | 46326.0 |
| 2012-02-15 | EW | Futures | 979.9 | 989.8 | 972.9 | 977.5 | 32998.0 |
| 2012-02-15 | FBTP | Futures | 65.07 | 65.21 | 63.85 | 64.22 | 14003.0 |
| 2012-02-15 | FBTS | Futures | 84.416 | 84.465 | 84.168 | 84.232 | 1975.0 |
| 2012-02-15 | FCE | Futures | 2408.5 | 2414.9 | 2381.3 | 2395.4 | 156444.0 |
| 2012-02-15 | FDAX | Futures | 7509.3 | 7546.9 | 7415.5 | 7472.9 | 157588.0 |
| 2012-02-15 | FESX | Futures | 1678.1 | 1686.1 | 1656.0 | 1668.0 | 1152666.0 |
| 2012-02-15 | FGBL | Futures | 111.93 | 112.73 | 111.8 | 112.56 | 733830.0 |
| 2012-02-15 | FGBM | Futures | 113.05 | 113.47 | 112.99 | 113.39 | 423010.0 |
| 2012-02-15 | FGBS | Futures | 109.8 | 109.874 | 109.775 | 109.859 | 411435.0 |
| 2012-02-15 | FGBX | Futures | 116.29 | 117.73 | 115.84 | 117.36 | 5505.0 |
| 2012-02-15 | FTDX | Futures | 719.9 | 725.9 | 719.9 | 725.0 | 279.0 |
| 2012-02-15 | FTI | Futures | 271.69 | 272.91 | 269.75 | 271.39 | 38347.0 |
| 2012-02-15 | FTUK | Futures | 4227.0 | 4256.6 | 4205.8 | 4238.6 | 97451.0 |
| 2012-02-15 | FVSA | Futures | 10661.12 | 10927.17 | 10281.04 | 10775.14 | 2810.0 |
| 2012-02-15 | FXXP | Futures | 186.5 | 187.2 | 186.0 | 186.5 | 852.0 |
| 2012-02-15 | G | Futures | 94.13 | 94.42 | 93.96 | 94.28 | 158181.0 |
| 2012-02-15 | GF | Futures | 331.627 | 333.694 | 330.089 | 332.157 | 3245.0 |
| 2012-02-15 | GSCI | Futures | 1077.94 | 1077.94 | 1071.95 | 1074.08 | 142.0 |
| 2012-02-15 | HE | Futures | 108.311 | 108.522 | 107.404 | 107.435 | 15282.0 |
| 2012-02-15 | HG | Futures | 5.055 | 5.1078 | 4.999 | 5.0142 | 46949.0 |
| 2012-02-15 | HO | Futures | 2.5755 | 2.6039 | 2.5662 | 2.5829 | 55258.0 |
| 2012-02-15 | HRC | Futures | 2868.9 | 2868.9 | 2868.9 | 2868.9 | 0.0 |
| 2012-02-15 | J1 | Futures | 0.0160196 | 0.0160648 | 0.0159668 | 0.0160032 | 93474.0 |
| 2012-02-15 | J7 | Futures | 0.01595 | 0.015997 | 0.015899 | 0.015937 | 275.0 |
> showing 50 of 98 rows — these rows as CSV