PREVIEW / futures_daily / 2011-10-13
file: by_date/futures_daily/2011/2011-10-13.parquet size: 9 KB rows: 96
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-10-13 | ES | Futures | 1196.4 | 1202.14 | 1183.17 | 1195.9 | 2316227.0 |
| 2011-10-13 | NQ | Futures | 2625.06 | 2666.73 | 2612.79 | 2655.03 | 315723.0 |
| 2011-10-13 | YM | Futures | 10972.7 | 11024.5 | 10867.0 | 10943.8 | 125916.0 |
| 2011-10-13 | CL | Futures | 160.14 | 161.01 | 156.83 | 158.82 | 360268.0 |
| 2011-10-13 | GC | Futures | 2264.6 | 2276.5 | 2233.6 | 2252.7 | 115586.0 |
| 2011-10-13 | ZN | Futures | 109.860273 | 110.54405 | 109.779828 | 110.208865 | 1286748.0 |
| 2011-10-13 | A6 | Futures | 0.8843 | 0.8931 | 0.88131 | 0.89002 | 151685.0 |
| 2011-10-13 | AD | Futures | 0.98074 | 0.98284 | 0.97244 | 0.98074 | 82896.0 |
| 2011-10-13 | B | Futures | 94.73 | 95.82 | 93.69 | 95.47 | 233602.0 |
| 2011-10-13 | B6 | Futures | 1.6414 | 1.6463 | 1.6339 | 1.6448 | 96830.0 |
| 2011-10-13 | BFX | Futures | 2623.0 | 2623.0 | 2615.3 | 2615.3 | 5.0 |
| 2011-10-13 | BR | Futures | 0.25413 | 0.25413 | 0.25413 | 0.25413 | 173.0 |
| 2011-10-13 | BZ | Futures | 100.81 | 101.27 | 99.06 | 100.9 | 1705.0 |
| 2011-10-13 | C | Futures | 1810.0 | 1826.0 | 1785.0 | 1786.0 | 6453.0 |
| 2011-10-13 | CC | Futures | 2070.0 | 2109.0 | 2055.0 | 2062.0 | 7911.0 |
| 2011-10-13 | CSC | Futures | 3.993 | 4.005 | 3.971 | 4.005 | 61.0 |
| 2011-10-13 | CT | Futures | 129.44 | 132.12 | 129.06 | 130.93 | 7741.0 |
| 2011-10-13 | DC | Futures | 27.62 | 28.44 | 27.62 | 28.34 | 346.0 |
| 2011-10-13 | DX | Futures | 75.896 | 76.319 | 75.685 | 75.871 | 22252.0 |
| 2011-10-13 | E1 | Futures | 1.46645 | 1.47131 | 1.45294 | 1.46343 | 21277.0 |
| 2011-10-13 | E6 | Futures | 1.64593 | 1.65142 | 1.63457 | 1.6464 | 304876.0 |
| 2011-10-13 | E7 | Futures | 1.632 | 1.6373 | 1.6206 | 1.6323 | 4530.0 |
| 2011-10-13 | ED | Futures | 94.965 | 94.9698 | 94.9364 | 94.9507 | 199613.0 |
| 2011-10-13 | ER | Futures | 97.199 | 97.228 | 97.189 | 97.218 | 110799.0 |
| 2011-10-13 | EW | Futures | 835.7 | 844.5 | 825.3 | 838.8 | 26681.0 |
| 2011-10-13 | FBTP | Futures | 62.19 | 62.19 | 61.59 | 61.72 | 12414.0 |
| 2011-10-13 | FBTS | Futures | 82.152 | 82.192 | 81.976 | 82.024 | 949.0 |
| 2011-10-13 | FCE | Futures | 2308.8 | 2324.6 | 2272.5 | 2285.1 | 2334.0 |
| 2011-10-13 | FDAX | Futures | 6492.6 | 6564.8 | 6390.0 | 6418.8 | 177463.0 |
| 2011-10-13 | FESX | Futures | 1563.7 | 1580.3 | 1535.8 | 1541.8 | 1526168.0 |
| 2011-10-13 | FEU3 | Futures | 97.757 | 97.776 | 97.757 | 97.776 | 1301.0 |
| 2011-10-13 | FGBL | Futures | 108.07 | 109.02 | 107.78 | 108.73 | 987602.0 |
| 2011-10-13 | FGBM | Futures | 109.57 | 110.13 | 109.38 | 109.97 | 463543.0 |
| 2011-10-13 | FGBS | Futures | 108.726 | 108.9 | 108.646 | 108.855 | 473563.0 |
| 2011-10-13 | FGBX | Futures | 107.97 | 109.76 | 107.36 | 109.3 | 3772.0 |
| 2011-10-13 | FTDX | Futures | 624.7 | 630.2 | 615.5 | 620.1 | 236.0 |
| 2011-10-13 | FTI | Futures | 246.06 | 247.84 | 244.36 | 244.9 | 2813.0 |
| 2011-10-13 | FTUK | Futures | 3870.5 | 3899.2 | 3835.0 | 3854.3 | 116829.0 |
| 2011-10-13 | FVSA | Futures | 15334.71 | 15980.6 | 15334.71 | 15688.91 | 10882.0 |
| 2011-10-13 | FXXP | Futures | 165.5 | 167.0 | 163.9 | 164.2 | 1015.0 |
| 2011-10-13 | G | Futures | 89.86 | 90.62 | 89.68 | 90.47 | 140409.0 |
| 2011-10-13 | GF | Futures | 316.687 | 318.734 | 313.146 | 317.461 | 4116.0 |
| 2011-10-13 | GSCI | Futures | 978.98 | 980.32 | 964.72 | 978.04 | 2117.0 |
| 2011-10-13 | HE | Futures | 112.697 | 114.432 | 112.15 | 113.146 | 16908.0 |
| 2011-10-13 | HG | Futures | 4.4429 | 4.4654 | 4.3483 | 4.3761 | 51695.0 |
| 2011-10-13 | HO | Futures | 2.3475 | 2.3887 | 2.3372 | 2.38 | 45654.0 |
| 2011-10-13 | HRC | Futures | 2723.1 | 2723.1 | 2723.1 | 2723.1 | 51.0 |
| 2011-10-13 | J1 | Futures | 0.016272 | 0.0164014 | 0.0162682 | 0.0163612 | 83646.0 |
| 2011-10-13 | J7 | Futures | 0.016172 | 0.016301 | 0.016172 | 0.016262 | 410.0 |
| 2011-10-13 | JB | Futures | 124.31 | 124.34 | 124.06 | 124.18 | 4603.0 |
> showing 50 of 96 rows — these rows as CSV