PREVIEW / futures_daily / 2011-11-04
file: by_date/futures_daily/2011/2011-11-04.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-11-04 | ES | Futures | 1253.55 | 1256.54 | 1232.34 | 1248.81 | 2243027.0 |
| 2011-11-04 | NQ | Futures | 2696.12 | 2698.97 | 2656.17 | 2683.56 | 235043.0 |
| 2011-11-04 | YM | Futures | 11509.7 | 11535.6 | 11326.2 | 11471.2 | 114787.0 |
| 2011-11-04 | CL | Futures | 176.8 | 178.09 | 174.23 | 176.83 | 295457.0 |
| 2011-11-04 | GC | Futures | 2385.1 | 2385.1 | 2362.5 | 2371.0 | 88468.0 |
| 2011-11-04 | ZN | Futures | 111.522791 | 111.93842 | 111.214421 | 111.764124 | 1146045.0 |
| 2011-11-04 | A6 | Futures | 0.91025 | 0.9135 | 0.90251 | 0.90963 | 110289.0 |
| 2011-11-04 | AD | Futures | 0.99135 | 0.99255 | 0.97714 | 0.98264 | 80710.0 |
| 2011-11-04 | B | Futures | 96.97 | 98.38 | 96.62 | 98.02 | 110187.0 |
| 2011-11-04 | B6 | Futures | 1.6733 | 1.676 | 1.6634 | 1.6733 | 94382.0 |
| 2011-11-04 | BFX | Futures | 2554.4 | 2555.0 | 2499.5 | 2499.5 | 99.0 |
| 2011-11-04 | BR | Futures | 0.25914 | 0.25914 | 0.25526 | 0.25799 | 166.0 |
| 2011-11-04 | BZ | Futures | 103.47 | 103.5 | 103.47 | 103.5 | 589.0 |
| 2011-11-04 | C | Futures | 1784.0 | 1795.0 | 1774.0 | 1775.0 | 6394.0 |
| 2011-11-04 | CC | Futures | 2133.0 | 2142.0 | 2102.0 | 2117.0 | 14478.0 |
| 2011-11-04 | CT | Futures | 126.5 | 128.69 | 126.41 | 127.3 | 6646.0 |
| 2011-11-04 | DC | Futures | 30.8 | 31.14 | 30.58 | 30.67 | 524.0 |
| 2011-11-04 | DX | Futures | 75.484 | 76.088 | 75.371 | 75.751 | 33439.0 |
| 2011-11-04 | E1 | Futures | 1.49414 | 1.49729 | 1.47419 | 1.48246 | 21130.0 |
| 2011-11-04 | E6 | Futures | 1.65083 | 1.65883 | 1.6384 | 1.64616 | 321864.0 |
| 2011-11-04 | E7 | Futures | 1.6371 | 1.6469 | 1.6244 | 1.6321 | 5011.0 |
| 2011-11-04 | ED | Futures | 94.9746 | 94.9793 | 94.9602 | 94.9698 | 168798.0 |
| 2011-11-04 | ER | Futures | 97.371 | 97.386 | 97.263 | 97.297 | 256148.0 |
| 2011-11-04 | EW | Futures | 895.9 | 903.9 | 882.6 | 902.3 | 27191.0 |
| 2011-11-04 | FBTP | Futures | 60.09 | 60.18 | 58.99 | 59.16 | 9696.0 |
| 2011-11-04 | FBTS | Futures | 80.587 | 80.619 | 79.503 | 79.841 | 1596.0 |
| 2011-11-04 | FCE | Futures | 2306.3 | 2314.9 | 2230.5 | 2238.4 | 111572.0 |
| 2011-11-04 | FDAX | Futures | 6710.3 | 6725.5 | 6441.1 | 6500.2 | 186410.0 |
| 2011-11-04 | FESX | Futures | 1568.4 | 1574.3 | 1509.2 | 1519.8 | 1523772.0 |
| 2011-11-04 | FEU3 | Futures | 97.915 | 97.915 | 97.856 | 97.856 | 92.0 |
| 2011-11-04 | FGBL | Futures | 110.45 | 111.62 | 110.32 | 111.33 | 741451.0 |
| 2011-11-04 | FGBM | Futures | 111.53 | 111.98 | 111.42 | 111.83 | 404529.0 |
| 2011-11-04 | FGBS | Futures | 109.367 | 109.392 | 109.287 | 109.312 | 411583.0 |
| 2011-11-04 | FGBX | Futures | 111.21 | 113.31 | 111.04 | 112.8 | 5477.0 |
| 2011-11-04 | FTDX | Futures | 646.3 | 650.9 | 640.3 | 650.4 | 308.0 |
| 2011-11-04 | FTI | Futures | 252.93 | 253.59 | 248.05 | 249.7 | 50298.0 |
| 2011-11-04 | FTUK | Futures | 3983.9 | 4013.7 | 3934.4 | 3969.9 | 119366.0 |
| 2011-11-04 | FVSA | Futures | 15605.57 | 16709.83 | 15459.72 | 16376.47 | 1429.0 |
| 2011-11-04 | FXXP | Futures | 169.5 | 169.5 | 166.1 | 167.1 | 4750.0 |
| 2011-11-04 | G | Futures | 91.28 | 92.03 | 91.12 | 91.81 | 106463.0 |
| 2011-11-04 | GF | Futures | 313.533 | 317.461 | 313.533 | 315.525 | 1259.0 |
| 2011-11-04 | GSCI | Futures | 1024.82 | 1025.92 | 1014.16 | 1023.25 | 157.0 |
| 2011-11-04 | HE | Futures | 111.572 | 111.99 | 110.576 | 111.636 | 15789.0 |
| 2011-11-04 | HG | Futures | 4.7526 | 4.8346 | 4.6904 | 4.7168 | 37025.0 |
| 2011-11-04 | HO | Futures | 2.4555 | 2.4765 | 2.4357 | 2.4665 | 37951.0 |
| 2011-11-04 | HRC | Futures | 2685.6 | 2685.6 | 2685.6 | 2685.6 | 0.0 |
| 2011-11-04 | J1 | Futures | 0.0161112 | 0.016125 | 0.0160622 | 0.0160848 | 48715.0 |
| 2011-11-04 | J7 | Futures | 0.016011 | 0.016026 | 0.015967 | 0.015987 | 165.0 |
| 2011-11-04 | JB | Futures | 124.45 | 124.63 | 124.38 | 124.63 | 3048.0 |
| 2011-11-04 | KC | Futures | 536.09 | 545.28 | 528.44 | 542.46 | 11631.0 |
> showing 50 of 96 rows — these rows as CSV