PREVIEW / futures_daily / 2011-12-28
file: by_date/futures_daily/2011/2011-12-28.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 |
|---|---|---|---|---|---|---|---|
| 2011-12-28 | ES | Futures | 1264.49 | 1269.01 | 1247.43 | 1248.94 | 1013536.0 |
| 2011-12-28 | NQ | Futures | 2612.55 | 2621.41 | 2577.38 | 2583.96 | 128306.0 |
| 2011-12-28 | YM | Futures | 11814.8 | 11850.5 | 11670.7 | 11683.2 | 64680.0 |
| 2011-12-28 | CL | Futures | 189.23 | 190.09 | 185.23 | 185.7 | 164655.0 |
| 2011-12-28 | GC | Futures | 2152.0 | 2153.5 | 2094.0 | 2111.8 | 114256.0 |
| 2011-12-28 | ZN | Futures | 112.328092 | 112.962714 | 112.287584 | 112.949211 | 325851.0 |
| 2011-12-28 | A6 | Futures | 0.89411 | 0.89999 | 0.88815 | 0.89011 | 67132.0 |
| 2011-12-28 | AD | Futures | 0.98375 | 0.98947 | 0.97743 | 0.97863 | 47600.0 |
| 2011-12-28 | B | Futures | 96.63 | 96.92 | 94.65 | 95.38 | 56939.0 |
| 2011-12-28 | B6 | Futures | 1.6359 | 1.6392 | 1.6127 | 1.614 | 87651.0 |
| 2011-12-28 | BFX | Futures | 2469.8 | 2469.8 | 2463.4 | 2463.4 | 76.0 |
| 2011-12-28 | BR | Futures | 0.24949 | 0.24949 | 0.24364 | 0.24659 | 592.0 |
| 2011-12-28 | BZ | Futures | 101.86 | 101.91 | 101.07 | 101.23 | 439.0 |
| 2011-12-28 | C | Futures | 1454.0 | 1455.0 | 1414.0 | 1417.0 | 4075.0 |
| 2011-12-28 | CB | Futures | 89.077 | 89.077 | 88.942 | 89.077 | 40.0 |
| 2011-12-28 | CC | Futures | 1716.0 | 1730.0 | 1642.0 | 1654.0 | 6668.0 |
| 2011-12-28 | CSC | Futures | 3.976 | 3.981 | 3.976 | 3.976 | 10.0 |
| 2011-12-28 | CT | Futures | 113.18 | 118.38 | 113.02 | 116.79 | 18724.0 |
| 2011-12-28 | DC | Futures | 28.76 | 29.03 | 28.76 | 28.91 | 171.0 |
| 2011-12-28 | DX | Futures | 78.002 | 78.863 | 77.919 | 78.725 | 21017.0 |
| 2011-12-28 | E1 | Futures | 1.40858 | 1.41108 | 1.39231 | 1.39519 | 20230.0 |
| 2011-12-28 | E6 | Futures | 1.56369 | 1.56525 | 1.54481 | 1.54827 | 177098.0 |
| 2011-12-28 | E7 | Futures | 1.5506 | 1.5507 | 1.5307 | 1.5341 | 3397.0 |
| 2011-12-28 | EBM | Futures | 251.59 | 253.88 | 250.28 | 253.23 | 5799.0 |
| 2011-12-28 | ED | Futures | 94.8766 | 94.8957 | 94.8766 | 94.8814 | 83001.0 |
| 2011-12-28 | ER | Futures | 97.243 | 97.243 | 97.213 | 97.233 | 58735.0 |
| 2011-12-28 | EW | Futures | 889.7 | 892.5 | 874.1 | 875.6 | 20111.0 |
| 2011-12-28 | FBTP | Futures | 58.3 | 59.05 | 57.77 | 57.86 | 4971.0 |
| 2011-12-28 | FBTS | Futures | 79.873 | 80.322 | 79.825 | 79.889 | 436.0 |
| 2011-12-28 | FCE | Futures | 2215.9 | 2243.1 | 2193.3 | 2198.3 | 36253.0 |
| 2011-12-28 | FDAX | Futures | 6477.3 | 6526.5 | 6376.3 | 6394.5 | 76826.0 |
| 2011-12-28 | FESX | Futures | 1522.3 | 1538.3 | 1498.9 | 1507.6 | 419923.0 |
| 2011-12-28 | FGBL | Futures | 111.83 | 112.08 | 111.47 | 111.85 | 132562.0 |
| 2011-12-28 | FGBM | Futures | 112.82 | 112.86 | 112.59 | 112.77 | 95532.0 |
| 2011-12-28 | FGBS | Futures | 109.914 | 109.914 | 109.82 | 109.864 | 86821.0 |
| 2011-12-28 | FGBX | Futures | 117.83 | 118.07 | 116.97 | 117.68 | 2697.0 |
| 2011-12-28 | FTDX | Futures | 626.1 | 627.0 | 620.1 | 624.2 | 36.0 |
| 2011-12-28 | FTI | Futures | 259.04 | 260.97 | 257.19 | 257.61 | 9924.0 |
| 2011-12-28 | FTUK | Futures | 3951.5 | 3989.0 | 3930.9 | 3950.4 | 44223.0 |
| 2011-12-28 | FVSA | Futures | 12500.71 | 13019.08 | 12361.15 | 12979.2 | 2068.0 |
| 2011-12-28 | FXXP | Futures | 169.8 | 171.4 | 168.8 | 169.3 | 2440.0 |
| 2011-12-28 | G | Futures | 94.45 | 94.75 | 94.35 | 94.56 | 25741.0 |
| 2011-12-28 | GF | Futures | 316.595 | 318.211 | 315.626 | 317.08 | 1567.0 |
| 2011-12-28 | GSCI | Futures | 1024.28 | 1027.49 | 1009.14 | 1013.92 | 147.0 |
| 2011-12-28 | HE | Futures | 105.866 | 106.667 | 104.88 | 105.465 | 12003.0 |
| 2011-12-28 | HG | Futures | 4.4965 | 4.5492 | 4.418 | 4.4391 | 23745.0 |
| 2011-12-28 | HO | Futures | 2.3595 | 2.3744 | 2.3404 | 2.3486 | 13143.0 |
| 2011-12-28 | HRC | Futures | 2825.8 | 2825.8 | 2825.8 | 2825.8 | 0.0 |
| 2011-12-28 | J1 | Futures | 0.0161476 | 0.0162205 | 0.0161137 | 0.0161388 | 70613.0 |
| 2011-12-28 | J7 | Futures | 0.016086 | 0.016151 | 0.016048 | 0.016072 | 244.0 |
> showing 50 of 98 rows — these rows as CSV