PREVIEW / futures_daily / 2011-08-31
file: by_date/futures_daily/2011/2011-08-31.parquet size: 9 KB rows: 97
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-31 | ES | Futures | 1195.98 | 1221.31 | 1193.0 | 1209.39 | 3159833.0 |
| 2011-08-31 | NQ | Futures | 2534.88 | 2583.27 | 2529.47 | 2551.67 | 285780.0 |
| 2011-08-31 | YM | Futures | 10864.6 | 11061.2 | 10842.9 | 10969.5 | 133279.0 |
| 2011-08-31 | CL | Futures | 169.13 | 170.56 | 167.0 | 169.17 | 317696.0 |
| 2011-08-31 | GC | Futures | 2481.0 | 2487.9 | 2448.6 | 2473.1 | 165623.0 |
| 2011-08-31 | ZN | Futures | 111.003385 | 111.282789 | 110.604236 | 110.72398 | 432206.0 |
| 2011-08-31 | A6 | Futures | 0.92657 | 0.93031 | 0.92431 | 0.92779 | 81860.0 |
| 2011-08-31 | AD | Futures | 1.01932 | 1.0258 | 1.01772 | 1.01882 | 80278.0 |
| 2011-08-31 | B | Futures | 97.34 | 98.13 | 96.78 | 97.89 | 124726.0 |
| 2011-08-31 | B6 | Futures | 1.6957 | 1.6991 | 1.6878 | 1.6892 | 68717.0 |
| 2011-08-31 | BFX | Futures | 2703.7 | 2727.6 | 2703.7 | 2722.9 | 31.0 |
| 2011-08-31 | BR | Futures | 0.28033 | 0.28096 | 0.27893 | 0.27978 | 189.0 |
| 2011-08-31 | BZ | Futures | 100.35 | 101.6 | 100.3 | 101.4 | 922.0 |
| 2011-08-31 | C | Futures | 2084.0 | 2100.0 | 2081.0 | 2096.0 | 1921.0 |
| 2011-08-31 | CC | Futures | 2431.0 | 2466.0 | 2430.0 | 2441.0 | 6810.0 |
| 2011-08-31 | CSC | Futures | 4.397 | 4.434 | 4.397 | 4.434 | 35.0 |
| 2011-08-31 | CT | Futures | 136.26 | 137.56 | 135.87 | 137.4 | 28.0 |
| 2011-08-31 | DC | Futures | 30.28 | 30.38 | 30.21 | 30.31 | 112.0 |
| 2011-08-31 | DX | Futures | 73.34 | 73.529 | 73.177 | 73.457 | 18444.0 |
| 2011-08-31 | E1 | Futures | 1.59427 | 1.63665 | 1.59388 | 1.62566 | 31617.0 |
| 2011-08-31 | E6 | Futures | 1.71454 | 1.71811 | 1.70492 | 1.70754 | 246224.0 |
| 2011-08-31 | E7 | Futures | 1.702 | 1.7054 | 1.6926 | 1.6951 | 3211.0 |
| 2011-08-31 | ED | Futures | 94.9334 | 94.9454 | 94.9311 | 94.9358 | 139520.0 |
| 2011-08-31 | ER | Futures | 97.484 | 97.489 | 97.47 | 97.479 | 91671.0 |
| 2011-08-31 | EW | Futures | 858.6 | 881.2 | 855.2 | 866.5 | 37223.0 |
| 2011-08-31 | FBTP | Futures | 64.38 | 64.38 | 64.08 | 64.16 | 5990.0 |
| 2011-08-31 | FCE | Futures | 2224.6 | 2294.5 | 2215.9 | 2282.2 | 115975.0 |
| 2011-08-31 | FDAX | Futures | 6049.9 | 6274.8 | 6035.5 | 6189.3 | 195706.0 |
| 2011-08-31 | FESX | Futures | 1440.0 | 1484.9 | 1434.8 | 1472.7 | 1421683.0 |
| 2011-08-31 | FEU3 | Futures | 98.019 | 98.019 | 98.014 | 98.019 | 6.0 |
| 2011-08-31 | FGBL | Futures | 108.41 | 108.53 | 107.74 | 107.94 | 876156.0 |
| 2011-08-31 | FGBM | Futures | 109.9 | 110.05 | 109.44 | 109.54 | 632694.0 |
| 2011-08-31 | FGBS | Futures | 108.82 | 108.905 | 108.736 | 108.75 | 594769.0 |
| 2011-08-31 | FGBX | Futures | 106.74 | 106.74 | 105.32 | 105.45 | 9497.0 |
| 2011-08-31 | FTDX | Futures | 660.9 | 673.8 | 659.6 | 670.3 | 282.0 |
| 2011-08-31 | FTI | Futures | 232.42 | 240.7 | 231.77 | 239.23 | 46232.0 |
| 2011-08-31 | FTUK | Futures | 3706.4 | 3815.1 | 3701.5 | 3799.6 | 149155.0 |
| 2011-08-31 | FVSA | Futures | 13874.29 | 13971.31 | 13020.49 | 13233.94 | 3743.0 |
| 2011-08-31 | FXXP | Futures | 157.2 | 161.2 | 156.6 | 160.3 | 3211.0 |
| 2011-08-31 | G | Futures | 90.15 | 90.38 | 89.4 | 89.53 | 138509.0 |
| 2011-08-31 | GF | Futures | 303.322 | 303.722 | 301.891 | 303.264 | 595.0 |
| 2011-08-31 | GSCI | Futures | 1051.79 | 1058.76 | 1049.75 | 1058.21 | 325.0 |
| 2011-08-31 | HE | Futures | 104.397 | 104.947 | 103.848 | 104.428 | 19057.0 |
| 2011-08-31 | HG | Futures | 5.491 | 5.5882 | 5.4724 | 5.5637 | 28238.0 |
| 2011-08-31 | HO | Futures | 2.4773 | 2.4947 | 2.4675 | 2.4871 | 16434.0 |
| 2011-08-31 | HRC | Futures | 2910.3 | 2910.3 | 2910.3 | 2910.3 | 0.0 |
| 2011-08-31 | J1 | Futures | 0.0163826 | 0.0164505 | 0.0163587 | 0.0164153 | 78911.0 |
| 2011-08-31 | J7 | Futures | 0.016272 | 0.016338 | 0.016249 | 0.016306 | 350.0 |
| 2011-08-31 | JB | Futures | 124.07 | 124.15 | 123.95 | 123.99 | 1404.0 |
| 2011-08-31 | KC | Futures | 675.36 | 679.84 | 670.88 | 679.25 | 8764.0 |
> showing 50 of 97 rows — these rows as CSV