PREVIEW / futures_daily / 2012-04-10
file: by_date/futures_daily/2012/2012-04-10.parquet size: 9 KB rows: 97
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-04-10 | ES | Futures | 1384.85 | 1391.4 | 1362.94 | 1367.47 | 2522310.0 |
| 2012-04-10 | NQ | Futures | 3126.38 | 3146.15 | 3075.4 | 3090.01 | 383510.0 |
| 2012-04-10 | YM | Futures | 12496.5 | 12544.1 | 12300.1 | 12331.2 | 164144.0 |
| 2012-04-10 | CL | Futures | 188.64 | 189.8 | 185.6 | 186.22 | 312927.0 |
| 2012-04-10 | GC | Futures | 2196.4 | 2225.5 | 2182.3 | 2220.0 | 177501.0 |
| 2012-04-10 | ZN | Futures | 113.55658 | 114.138713 | 113.434738 | 114.016872 | 1431352.0 |
| 2012-04-10 | A6 | Futures | 0.92069 | 0.92465 | 0.91493 | 0.91556 | 136456.0 |
| 2012-04-10 | AD | Futures | 1.00752 | 1.00964 | 0.99957 | 1.00078 | 102799.0 |
| 2012-04-10 | B | Futures | 110.34 | 110.56 | 107.73 | 108.08 | 193555.0 |
| 2012-04-10 | B6 | Futures | 1.668 | 1.6715 | 1.6586 | 1.6639 | 109182.0 |
| 2012-04-10 | BR | Futures | 0.25948 | 0.25948 | 0.25757 | 0.25876 | 47.0 |
| 2012-04-10 | BZ | Futures | 115.8 | 116.49 | 114.17 | 114.32 | 993.0 |
| 2012-04-10 | C | Futures | 1417.0 | 1423.0 | 1376.0 | 1379.0 | 6616.0 |
| 2012-04-10 | CB | Futures | 78.312 | 78.716 | 78.312 | 78.716 | 14.0 |
| 2012-04-10 | CC | Futures | 1602.0 | 1608.0 | 1551.0 | 1561.0 | 21992.0 |
| 2012-04-10 | CSC | Futures | 3.604 | 3.611 | 3.6 | 3.611 | 8.0 |
| 2012-04-10 | CT | Futures | 112.05 | 113.76 | 111.81 | 112.3 | 26208.0 |
| 2012-04-10 | DC | Futures | 25.0 | 25.23 | 24.96 | 25.1 | 72.0 |
| 2012-04-10 | DX | Futures | 77.467 | 77.748 | 77.293 | 77.606 | 26103.0 |
| 2012-04-10 | E1 | Futures | 1.42958 | 1.43311 | 1.42316 | 1.4267 | 49354.0 |
| 2012-04-10 | E6 | Futures | 1.56561 | 1.56978 | 1.55892 | 1.56167 | 291464.0 |
| 2012-04-10 | E7 | Futures | 1.5506 | 1.5547 | 1.544 | 1.5467 | 4277.0 |
| 2012-04-10 | EBM | Futures | 285.7 | 286.37 | 280.31 | 280.98 | 9745.0 |
| 2012-04-10 | ED | Futures | 95.0358 | 95.0454 | 95.0263 | 95.0311 | 222659.0 |
| 2012-04-10 | ER | Futures | 97.499 | 97.513 | 97.464 | 97.484 | 160309.0 |
| 2012-04-10 | EW | Futures | 978.9 | 982.7 | 955.4 | 959.5 | 37015.0 |
| 2012-04-10 | FBTP | Futures | 66.58 | 66.58 | 65.18 | 65.25 | 13966.0 |
| 2012-04-10 | FBTS | Futures | 84.826 | 84.826 | 84.183 | 84.192 | 3409.0 |
| 2012-04-10 | FCE | Futures | 2315.7 | 2334.1 | 2244.4 | 2280.6 | 136202.0 |
| 2012-04-10 | FDAX | Futures | 7393.2 | 7460.1 | 7260.6 | 7339.0 | 173159.0 |
| 2012-04-10 | FESX | Futures | 1576.4 | 1595.0 | 1539.8 | 1558.5 | 1504802.0 |
| 2012-04-10 | FGBL | Futures | 114.71 | 115.16 | 114.34 | 115.06 | 792738.0 |
| 2012-04-10 | FGBM | Futures | 114.53 | 114.8 | 114.3 | 114.76 | 534515.0 |
| 2012-04-10 | FGBS | Futures | 110.138 | 110.188 | 110.064 | 110.183 | 524934.0 |
| 2012-04-10 | FGBX | Futures | 119.63 | 120.19 | 118.77 | 120.11 | 5901.0 |
| 2012-04-10 | FTDX | Futures | 725.6 | 725.6 | 713.4 | 714.3 | 182.0 |
| 2012-04-10 | FTI | Futures | 265.16 | 265.29 | 256.96 | 259.86 | 4669.0 |
| 2012-04-10 | FTUK | Futures | 4098.8 | 4115.2 | 4005.4 | 4057.5 | 133858.0 |
| 2012-04-10 | FVSA | Futures | 8703.38 | 9774.56 | 8703.38 | 9724.35 | 4139.0 |
| 2012-04-10 | FXXP | Futures | 182.9 | 183.0 | 179.4 | 180.1 | 4999.0 |
| 2012-04-10 | G | Futures | 94.68 | 95.7 | 94.63 | 95.62 | 131230.0 |
| 2012-04-10 | GF | Futures | 310.104 | 311.198 | 306.407 | 307.448 | 5687.0 |
| 2012-04-10 | GSCI | Futures | 1082.91 | 1086.25 | 1067.75 | 1068.54 | 1548.0 |
| 2012-04-10 | HE | Futures | 103.311 | 103.311 | 101.523 | 102.458 | 481.0 |
| 2012-04-10 | HG | Futures | 4.8758 | 4.959 | 4.7787 | 4.7853 | 95389.0 |
| 2012-04-10 | HO | Futures | 2.5955 | 2.5981 | 2.5456 | 2.5518 | 27387.0 |
| 2012-04-10 | HRC | Futures | 2680.3 | 2680.3 | 2680.3 | 2680.3 | 0.0 |
| 2012-04-10 | J1 | Futures | 0.0153902 | 0.0155595 | 0.0153288 | 0.0155344 | 108849.0 |
| 2012-04-10 | J7 | Futures | 0.01531 | 0.015486 | 0.015258 | 0.015461 | 797.0 |
| 2012-04-10 | JB | Futures | 124.94 | 125.0 | 124.78 | 124.93 | 4719.0 |
> showing 50 of 97 rows — these rows as CSV