PREVIEW / futures_daily / 2011-08-30
file: by_date/futures_daily/2011/2011-08-30.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-08-30 | ES | Futures | 1199.71 | 1210.38 | 1185.31 | 1196.48 | 2576230.0 |
| 2011-08-30 | NQ | Futures | 2527.47 | 2561.64 | 2506.69 | 2536.01 | 254838.0 |
| 2011-08-30 | YM | Futures | 10883.5 | 10983.7 | 10791.8 | 10864.6 | 125901.0 |
| 2011-08-30 | CL | Futures | 166.69 | 169.93 | 164.69 | 169.34 | 315383.0 |
| 2011-08-30 | GC | Futures | 2418.5 | 2491.2 | 2411.6 | 2470.5 | 176635.0 |
| 2011-08-30 | ZN | Futures | 110.511101 | 111.202959 | 110.497796 | 111.029995 | 1277202.0 |
| 2011-08-30 | A6 | Futures | 0.92535 | 0.93022 | 0.92161 | 0.92944 | 83948.0 |
| 2011-08-30 | AD | Futures | 1.02111 | 1.02221 | 1.01592 | 1.01972 | 62133.0 |
| 2011-08-30 | B | Futures | 95.93 | 97.52 | 94.93 | 97.28 | 90912.0 |
| 2011-08-30 | B6 | Futures | 1.7067 | 1.7077 | 1.6907 | 1.6962 | 90066.0 |
| 2011-08-30 | BFX | Futures | 2670.4 | 2670.4 | 2651.3 | 2664.6 | 51.0 |
| 2011-08-30 | BR | Futures | 0.27825 | 0.28033 | 0.27825 | 0.28033 | 718.0 |
| 2011-08-30 | BZ | Futures | 98.44 | 100.96 | 98.44 | 100.77 | 770.0 |
| 2011-08-30 | C | Futures | 2101.0 | 2104.0 | 2062.0 | 2087.0 | 2369.0 |
| 2011-08-30 | CB | Futures | 101.779 | 102.053 | 101.779 | 101.916 | 12.0 |
| 2011-08-30 | CC | Futures | 2455.0 | 2466.0 | 2392.0 | 2432.0 | 7012.0 |
| 2011-08-30 | CT | Futures | 135.55 | 137.01 | 134.45 | 136.15 | 28.0 |
| 2011-08-30 | DC | Futures | 30.28 | 30.41 | 30.28 | 30.28 | 28.0 |
| 2011-08-30 | DX | Futures | 73.038 | 73.534 | 72.969 | 73.282 | 25972.0 |
| 2011-08-30 | E1 | Futures | 1.6033 | 1.6118 | 1.5893 | 1.59597 | 20240.0 |
| 2011-08-30 | E6 | Futures | 1.72333 | 1.72571 | 1.70789 | 1.71585 | 243875.0 |
| 2011-08-30 | E7 | Futures | 1.7105 | 1.713 | 1.6957 | 1.7033 | 3922.0 |
| 2011-08-30 | ED | Futures | 94.9382 | 94.9406 | 94.9287 | 94.9311 | 133027.0 |
| 2011-08-30 | ER | Futures | 97.479 | 97.499 | 97.479 | 97.489 | 75114.0 |
| 2011-08-30 | EW | Futures | 858.6 | 869.4 | 849.6 | 858.7 | 24749.0 |
| 2011-08-30 | FBTP | Futures | 64.33 | 64.38 | 64.06 | 64.22 | 10939.0 |
| 2011-08-30 | FCE | Futures | 2229.9 | 2238.0 | 2191.6 | 2214.8 | 76913.0 |
| 2011-08-30 | FDAX | Futures | 6101.7 | 6124.2 | 5953.7 | 6032.8 | 165477.0 |
| 2011-08-30 | FESX | Futures | 1446.4 | 1452.1 | 1419.4 | 1434.8 | 1092812.0 |
| 2011-08-30 | FEU3 | Futures | 98.024 | 98.029 | 98.024 | 98.029 | 6.0 |
| 2011-08-30 | FGBL | Futures | 107.91 | 108.79 | 107.74 | 108.52 | 697965.0 |
| 2011-08-30 | FGBM | Futures | 109.63 | 110.16 | 109.54 | 110.0 | 448041.0 |
| 2011-08-30 | FGBS | Futures | 108.76 | 108.925 | 108.745 | 108.87 | 445567.0 |
| 2011-08-30 | FGBX | Futures | 105.56 | 107.13 | 105.26 | 106.74 | 5839.0 |
| 2011-08-30 | FTDX | Futures | 660.0 | 660.0 | 649.7 | 656.0 | 203.0 |
| 2011-08-30 | FTI | Futures | 231.6 | 233.24 | 228.75 | 231.52 | 37353.0 |
| 2011-08-30 | FTUK | Futures | 3711.4 | 3738.9 | 3667.6 | 3707.8 | 113632.0 |
| 2011-08-30 | FVSA | Futures | 14010.12 | 14378.81 | 13971.31 | 14029.52 | 1942.0 |
| 2011-08-30 | FXXP | Futures | 156.1 | 156.9 | 154.7 | 156.1 | 3675.0 |
| 2011-08-30 | G | Futures | 89.92 | 90.34 | 89.66 | 90.27 | 148638.0 |
| 2011-08-30 | GF | Futures | 303.264 | 304.524 | 302.463 | 303.665 | 644.0 |
| 2011-08-30 | GSCI | Futures | 1036.13 | 1054.3 | 1034.33 | 1050.22 | 145.0 |
| 2011-08-30 | HE | Futures | 105.283 | 105.68 | 104.306 | 104.672 | 16727.0 |
| 2011-08-30 | HG | Futures | 5.4486 | 5.5472 | 5.4466 | 5.4804 | 39251.0 |
| 2011-08-30 | HO | Futures | 2.4423 | 2.4869 | 2.4267 | 2.481 | 14068.0 |
| 2011-08-30 | HRC | Futures | 2910.3 | 2910.3 | 2910.3 | 2910.3 | 0.0 |
| 2011-08-30 | J1 | Futures | 0.0163587 | 0.0164153 | 0.0163286 | 0.0163964 | 68853.0 |
| 2011-08-30 | J7 | Futures | 0.016249 | 0.016306 | 0.016217 | 0.016287 | 294.0 |
| 2011-08-30 | JB | Futures | 124.18 | 124.18 | 123.99 | 124.09 | 1815.0 |
| 2011-08-30 | KC | Futures | 670.29 | 676.3 | 656.04 | 675.6 | 12375.0 |
> showing 50 of 95 rows — these rows as CSV