PREVIEW / futures_daily / 2011-09-08
file: by_date/futures_daily/2011/2011-09-08.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-09-08 | ES | Futures | 1191.02 | 1195.49 | 1173.88 | 1177.61 | 2136073.0 |
| 2011-09-08 | NQ | Futures | 2531.46 | 2555.37 | 2511.25 | 2524.34 | 254052.0 |
| 2011-09-08 | YM | Futures | 10791.8 | 10846.6 | 10659.4 | 10676.5 | 105923.0 |
| 2011-09-08 | CL | Futures | 171.65 | 171.87 | 168.39 | 169.63 | 336725.0 |
| 2011-09-08 | GC | Futures | 2456.6 | 2529.2 | 2452.2 | 2507.9 | 218499.0 |
| 2011-09-08 | ZN | Futures | 111.455754 | 111.884791 | 111.428939 | 111.831161 | 930403.0 |
| 2011-09-08 | A6 | Futures | 0.9257 | 0.92631 | 0.91796 | 0.91944 | 108565.0 |
| 2011-09-08 | AD | Futures | 1.01413 | 1.01503 | 1.00814 | 1.00884 | 76616.0 |
| 2011-09-08 | B | Futures | 98.71 | 98.89 | 96.75 | 97.22 | 147672.0 |
| 2011-09-08 | B6 | Futures | 1.6628 | 1.673 | 1.6552 | 1.6608 | 122188.0 |
| 2011-09-08 | BFX | Futures | 2620.0 | 2636.3 | 2620.0 | 2636.3 | 81.0 |
| 2011-09-08 | BR | Futures | 0.26781 | 0.26836 | 0.26686 | 0.26775 | 8.0 |
| 2011-09-08 | BZ | Futures | 101.72 | 102.33 | 100.41 | 100.7 | 1176.0 |
| 2011-09-08 | C | Futures | 1992.0 | 1993.0 | 1965.0 | 1965.0 | 13856.0 |
| 2011-09-08 | CB | Futures | 98.628 | 98.628 | 98.628 | 98.628 | 2.0 |
| 2011-09-08 | CC | Futures | 2305.0 | 2312.0 | 2279.0 | 2283.0 | 12870.0 |
| 2011-09-08 | CSC | Futures | 4.361 | 4.361 | 4.358 | 4.358 | 4.0 |
| 2011-09-08 | CT | Futures | 144.23 | 148.19 | 144.09 | 145.93 | 72.0 |
| 2011-09-08 | DC | Futures | 30.14 | 30.28 | 30.01 | 30.21 | 63.0 |
| 2011-09-08 | DX | Futures | 74.851 | 75.668 | 74.841 | 75.615 | 32198.0 |
| 2011-09-08 | E1 | Futures | 1.52456 | 1.52548 | 1.49134 | 1.49553 | 28354.0 |
| 2011-09-08 | E6 | Futures | 1.67381 | 1.67404 | 1.64744 | 1.64946 | 378127.0 |
| 2011-09-08 | E7 | Futures | 1.6617 | 1.6617 | 1.6353 | 1.6374 | 4894.0 |
| 2011-09-08 | ED | Futures | 94.9406 | 94.9501 | 94.9311 | 94.9477 | 154746.0 |
| 2011-09-08 | ER | Futures | 97.534 | 97.564 | 97.489 | 97.504 | 254231.0 |
| 2011-09-08 | EW | Futures | 849.6 | 854.1 | 835.5 | 841.0 | 41087.0 |
| 2011-09-08 | FBTP | Futures | 63.58 | 64.07 | 63.51 | 63.66 | 8095.0 |
| 2011-09-08 | FBTS | Futures | 82.433 | 82.433 | 82.152 | 82.241 | 1190.0 |
| 2011-09-08 | FCE | Futures | 2157.6 | 2187.4 | 2135.5 | 2164.3 | 103662.0 |
| 2011-09-08 | FDAX | Futures | 5796.1 | 5849.0 | 5671.1 | 5776.4 | 212951.0 |
| 2011-09-08 | FESX | Futures | 1381.6 | 1402.1 | 1365.6 | 1386.7 | 1380535.0 |
| 2011-09-08 | FEU3 | Futures | 98.059 | 98.074 | 98.044 | 98.044 | 6.0 |
| 2011-09-08 | FGBL | Futures | 110.38 | 111.06 | 110.18 | 110.4 | 824738.0 |
| 2011-09-08 | FGBM | Futures | 110.82 | 111.2 | 110.66 | 110.84 | 451709.0 |
| 2011-09-08 | FGBS | Futures | 109.163 | 109.292 | 109.099 | 109.188 | 528473.0 |
| 2011-09-08 | FGBX | Futures | 109.8 | 110.91 | 109.08 | 109.36 | 3825.0 |
| 2011-09-08 | FTDX | Futures | 639.9 | 647.1 | 634.1 | 643.0 | 257.0 |
| 2011-09-08 | FTI | Futures | 230.01 | 232.05 | 227.77 | 231.28 | 39356.0 |
| 2011-09-08 | FTUK | Futures | 3789.7 | 3791.8 | 3716.3 | 3761.1 | 127752.0 |
| 2011-09-08 | FVSA | Futures | 15562.49 | 16222.24 | 15523.68 | 15601.3 | 2105.0 |
| 2011-09-08 | FXXP | Futures | 154.6 | 156.4 | 153.6 | 155.8 | 7793.0 |
| 2011-09-08 | G | Futures | 91.46 | 91.92 | 90.92 | 91.18 | 155230.0 |
| 2011-09-08 | GF | Futures | 307.271 | 308.302 | 304.18 | 306.699 | 1193.0 |
| 2011-09-08 | GSCI | Futures | 1043.18 | 1058.06 | 1043.18 | 1046.31 | 1736.0 |
| 2011-09-08 | HE | Futures | 103.97 | 106.016 | 103.97 | 106.016 | 24969.0 |
| 2011-09-08 | HG | Futures | 5.4678 | 5.5042 | 5.4076 | 5.483 | 28287.0 |
| 2011-09-08 | HO | Futures | 2.4875 | 2.4888 | 2.4512 | 2.4581 | 17055.0 |
| 2011-09-08 | HRC | Futures | 2910.3 | 2910.3 | 2910.3 | 2910.3 | 0.0 |
| 2011-09-08 | J1 | Futures | 0.0162758 | 0.0162946 | 0.0161978 | 0.0162255 | 92989.0 |
| 2011-09-08 | J7 | Futures | 0.016166 | 0.016184 | 0.016091 | 0.016117 | 596.0 |
> showing 50 of 98 rows — these rows as CSV