PREVIEW / futures_daily / 2011-01-03
file: by_date/futures_daily/2011/2011-01-03.parquet size: 8 KB rows: 83
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-01-03 | ES | Futures | 1236.31 | 1252.55 | 1235.57 | 1245.42 | 1591034.0 |
| 2011-01-03 | NQ | Futures | 2520.38 | 2574.59 | 2519.52 | 2555.0 | 276753.0 |
| 2011-01-03 | YM | Futures | 10807.2 | 10904.5 | 10802.5 | 10842.7 | 74573.0 |
| 2011-01-03 | CL | Futures | 187.12 | 189.72 | 186.92 | 187.61 | 225189.0 |
| 2011-01-03 | GC | Futures | 1930.7 | 1936.1 | 1920.8 | 1934.1 | 77199.0 |
| 2011-01-03 | ZN | Futures | 100.07559 | 100.101587 | 99.386668 | 99.971602 | 731629.0 |
| 2011-01-03 | A6 | Futures | 0.85911 | 0.85953 | 0.85334 | 0.85657 | 58655.0 |
| 2011-01-03 | AD | Futures | 0.99741 | 1.00207 | 0.99602 | 0.9991 | 50347.0 |
| 2011-01-03 | B | Futures | 80.62 | 81.8 | 80.42 | 80.73 | 39730.0 |
| 2011-01-03 | B6 | Futures | 1.6116 | 1.6151 | 1.6 | 1.6061 | 69691.0 |
| 2011-01-03 | BFX | Futures | 2991.7 | 3053.7 | 2991.1 | 3036.7 | 314.0 |
| 2011-01-03 | BR | Futures | 0.25799 | 0.25844 | 0.25713 | 0.25821 | 397.0 |
| 2011-01-03 | BZ | Futures | 86.67 | 86.67 | 85.99 | 85.99 | 234.0 |
| 2011-01-03 | CB | Futures | 103.548 | 103.548 | 103.548 | 103.548 | 1.0 |
| 2011-01-03 | CT | Futures | 124.31 | 125.62 | 121.22 | 121.94 | 6823.0 |
| 2011-01-03 | DC | Futures | 23.13 | 23.28 | 22.98 | 23.1 | 269.0 |
| 2011-01-03 | DX | Futures | 79.167 | 79.586 | 79.087 | 79.241 | 18505.0 |
| 2011-01-03 | E1 | Futures | 1.40458 | 1.40746 | 1.39803 | 1.40629 | 32004.0 |
| 2011-01-03 | E6 | Futures | 1.57866 | 1.58457 | 1.5673 | 1.58078 | 232011.0 |
| 2011-01-03 | E7 | Futures | 1.5668 | 1.5728 | 1.5556 | 1.569 | 4004.0 |
| 2011-01-03 | EBM | Futures | 227.18 | 230.81 | 225.59 | 228.54 | 11960.0 |
| 2011-01-03 | ED | Futures | 94.8147 | 94.8242 | 94.8051 | 94.8147 | 97201.0 |
| 2011-01-03 | ER | Futures | 97.409 | 97.409 | 97.385 | 97.394 | 58178.0 |
| 2011-01-03 | EW | Futures | 894.2 | 909.0 | 893.0 | 902.3 | 20378.0 |
| 2011-01-03 | FBTP | Futures | 63.98 | 64.0 | 63.47 | 63.76 | 2045.0 |
| 2011-01-03 | FCE | Futures | 2565.6 | 2608.0 | 2559.3 | 2604.0 | 89433.0 |
| 2011-01-03 | FDAX | Futures | 7497.6 | 7541.5 | 7471.4 | 7493.9 | 94718.0 |
| 2011-01-03 | FESX | Futures | 1748.9 | 1768.8 | 1743.9 | 1760.7 | 657147.0 |
| 2011-01-03 | FEU3 | Futures | 97.953 | 97.958 | 97.953 | 97.953 | 59.0 |
| 2011-01-03 | FGBL | Futures | 99.27 | 99.78 | 99.2 | 99.57 | 327105.0 |
| 2011-01-03 | FGBM | Futures | 105.17 | 105.46 | 105.09 | 105.27 | 207972.0 |
| 2011-01-03 | FGBS | Futures | 107.627 | 107.701 | 107.597 | 107.671 | 225372.0 |
| 2011-01-03 | FGBX | Futures | 98.79 | 99.03 | 98.05 | 98.63 | 3345.0 |
| 2011-01-03 | FTDX | Futures | 753.9 | 758.7 | 753.0 | 755.6 | 264.0 |
| 2011-01-03 | FTI | Futures | 286.48 | 288.68 | 285.68 | 287.92 | 22796.0 |
| 2011-01-03 | FXXP | Futures | 180.8 | 180.8 | 179.8 | 180.0 | 387.0 |
| 2011-01-03 | GF | Futures | 304.72 | 304.72 | 301.606 | 302.042 | 497.0 |
| 2011-01-03 | GSCI | Futures | 1028.57 | 1039.93 | 1026.14 | 1032.22 | 305.0 |
| 2011-01-03 | HE | Futures | 99.828 | 99.985 | 97.665 | 97.79 | 15626.0 |
| 2011-01-03 | HG | Futures | 5.9373 | 5.9946 | 5.8906 | 5.9406 | 18390.0 |
| 2011-01-03 | HO | Futures | 2.1309 | 2.1678 | 2.1309 | 2.1397 | 10871.0 |
| 2011-01-03 | HRC | Futures | 2615.9 | 2615.9 | 2615.9 | 2615.9 | 0.0 |
| 2011-01-03 | J1 | Futures | 0.0155027 | 0.0155027 | 0.0153746 | 0.015396 | 79052.0 |
| 2011-01-03 | J7 | Futures | 0.015353 | 0.015361 | 0.015249 | 0.015286 | 125.0 |
| 2011-01-03 | KE | Futures | 3479.8 | 3591.85 | 3474.71 | 3516.47 | 13215.0 |
| 2011-01-03 | LBS | Futures | 837.8 | 855.7 | 837.8 | 855.7 | 688.0 |
| 2011-01-03 | LE | Futures | 164.258 | 164.523 | 162.135 | 162.173 | 20818.0 |
| 2011-01-03 | MFS | Futures | 1347.8 | 1352.4 | 1345.3 | 1347.7 | 618.0 |
| 2011-01-03 | MGC | Futures | 1906.6 | 1918.5 | 1904.6 | 1916.8 | 410.0 |
| 2011-01-03 | MME | Futures | 976.7 | 981.0 | 975.4 | 977.3 | 609.0 |
> showing 50 of 83 rows — these rows as CSV