PREVIEW / futures_daily / 2011-04-27
file: by_date/futures_daily/2011/2011-04-27.parquet size: 9 KB rows: 95
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-04-27 | ES | Futures | 1327.6 | 1340.72 | 1326.86 | 1337.5 | 1386295.0 |
| 2011-04-27 | NQ | Futures | 2719.66 | 2747.85 | 2718.81 | 2743.58 | 213497.0 |
| 2011-04-27 | YM | Futures | 11774.8 | 11900.7 | 11765.4 | 11884.8 | 85098.0 |
| 2011-04-27 | CL | Futures | 215.62 | 218.53 | 213.35 | 217.3 | 338697.0 |
| 2011-04-27 | GC | Futures | 2039.6 | 2071.8 | 2034.7 | 2053.4 | 170035.0 |
| 2011-04-27 | ZN | Futures | 101.737671 | 101.750839 | 101.250446 | 101.487474 | 934592.0 |
| 2011-04-27 | A6 | Futures | 0.91968 | 0.92749 | 0.91771 | 0.92474 | 85357.0 |
| 2011-04-27 | AD | Futures | 1.04541 | 1.0483 | 1.03844 | 1.04462 | 75558.0 |
| 2011-04-27 | B | Futures | 104.85 | 106.51 | 104.32 | 105.96 | 80555.0 |
| 2011-04-27 | B6 | Futures | 1.7114 | 1.7274 | 1.7064 | 1.7212 | 127699.0 |
| 2011-04-27 | BFX | Futures | 3202.1 | 3219.9 | 3194.3 | 3219.9 | 42.0 |
| 2011-04-27 | BR | Futures | 0.28116 | 0.28116 | 0.27916 | 0.27951 | 31.0 |
| 2011-04-27 | BZ | Futures | 111.65 | 111.65 | 111.65 | 111.65 | 401.0 |
| 2011-04-27 | C | Futures | 2104.0 | 2126.0 | 2078.0 | 2116.0 | 1345.0 |
| 2011-04-27 | CB | Futures | 118.509 | 119.389 | 118.509 | 119.095 | 28.0 |
| 2011-04-27 | CC | Futures | 2462.0 | 2547.0 | 2446.0 | 2522.0 | 11384.0 |
| 2011-04-27 | CSC | Futures | 4.456 | 4.477 | 4.456 | 4.477 | 4.0 |
| 2011-04-27 | CT | Futures | 158.36 | 158.75 | 151.82 | 151.82 | 11449.0 |
| 2011-04-27 | DC | Futures | 29.69 | 30.02 | 29.6 | 30.02 | 146.0 |
| 2011-04-27 | DX | Futures | 73.362 | 73.835 | 73.068 | 73.323 | 31589.0 |
| 2011-04-27 | E1 | Futures | 1.49926 | 1.51091 | 1.4825 | 1.49415 | 51763.0 |
| 2011-04-27 | E6 | Futures | 1.7328 | 1.75044 | 1.73102 | 1.74369 | 313572.0 |
| 2011-04-27 | E7 | Futures | 1.7201 | 1.7374 | 1.7183 | 1.7307 | 5743.0 |
| 2011-04-27 | EBM | Futures | 236.25 | 236.25 | 227.8 | 230.85 | 7621.0 |
| 2011-04-27 | ED | Futures | 94.9264 | 94.9359 | 94.9121 | 94.9216 | 175593.0 |
| 2011-04-27 | ER | Futures | 97.281 | 97.286 | 97.237 | 97.247 | 143298.0 |
| 2011-04-27 | EW | Futures | 995.0 | 1004.6 | 993.7 | 1003.3 | 20462.0 |
| 2011-04-27 | FBTP | Futures | 64.16 | 64.16 | 63.97 | 64.09 | 9095.0 |
| 2011-04-27 | FCE | Futures | 2708.2 | 2747.1 | 2700.8 | 2723.9 | 112821.0 |
| 2011-04-27 | FDAX | Futures | 7886.5 | 7986.3 | 7873.7 | 7921.2 | 109498.0 |
| 2011-04-27 | FESX | Futures | 1852.9 | 1882.4 | 1847.2 | 1865.8 | 916722.0 |
| 2011-04-27 | FEU3 | Futures | 97.8 | 97.8 | 97.79 | 97.79 | 2.0 |
| 2011-04-27 | FGBL | Futures | 98.04 | 98.06 | 97.53 | 97.61 | 785495.0 |
| 2011-04-27 | FGBM | Futures | 103.14 | 103.17 | 102.73 | 102.79 | 421132.0 |
| 2011-04-27 | FGBS | Futures | 106.439 | 106.454 | 106.186 | 106.285 | 518018.0 |
| 2011-04-27 | FGBX | Futures | 93.77 | 93.99 | 93.22 | 93.41 | 3204.0 |
| 2011-04-27 | FTDX | Futures | 827.0 | 827.0 | 821.7 | 824.3 | 837.0 |
| 2011-04-27 | FTI | Futures | 293.37 | 295.18 | 291.56 | 293.78 | 27822.0 |
| 2011-04-27 | FTUK | Futures | 4226.7 | 4255.1 | 4208.5 | 4227.1 | 75661.0 |
| 2011-04-27 | FXXP | Futures | 185.9 | 186.7 | 185.7 | 186.5 | 880.0 |
| 2011-04-27 | G | Futures | 82.74 | 82.75 | 82.07 | 82.13 | 128757.0 |
| 2011-04-27 | GF | Futures | 310.637 | 314.908 | 310.637 | 313.825 | 1589.0 |
| 2011-04-27 | GSCI | Futures | 1173.53 | 1180.24 | 1163.76 | 1175.48 | 76.0 |
| 2011-04-27 | HE | Futures | 104.662 | 105.166 | 102.536 | 103.865 | 1203.0 |
| 2011-04-27 | HG | Futures | 5.7726 | 5.8058 | 5.6171 | 5.6417 | 30117.0 |
| 2011-04-27 | HO | Futures | 2.6733 | 2.7176 | 2.6647 | 2.6989 | 55111.0 |
| 2011-04-27 | HRC | Futures | 3000.1 | 3000.1 | 3000.1 | 3000.1 | 0.0 |
| 2011-04-27 | J1 | Futures | 0.0154011 | 0.0154639 | 0.0151687 | 0.015283 | 130835.0 |
| 2011-04-27 | J7 | Futures | 0.015309 | 0.015364 | 0.015083 | 0.015189 | 933.0 |
| 2011-04-27 | JB | Futures | 121.87 | 121.89 | 121.67 | 121.82 | 23.0 |
> showing 50 of 95 rows — these rows as CSV