PREVIEW / futures_daily / 2010-08-31
file: by_date/futures_daily/2010/2010-08-31.parquet size: 9 KB rows: 89
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-31 | ES | Futures | 1019.24 | 1028.27 | 1011.93 | 1022.41 | 2516451.0 |
| 2010-08-31 | NQ | Futures | 2001.63 | 2016.63 | 1985.79 | 1999.37 | 360795.0 |
| 2010-08-31 | YM | Futures | 9230.2 | 9306.9 | 9160.8 | 9251.4 | 162619.0 |
| 2010-08-31 | CL | Futures | 156.24 | 157.64 | 150.89 | 151.71 | 469412.0 |
| 2010-08-31 | GC | Futures | 1683.7 | 1701.5 | 1676.6 | 1699.5 | 109430.0 |
| 2010-08-31 | ZN | Futures | 103.436226 | 103.807608 | 103.359388 | 103.679545 | 485562.0 |
| 2010-08-31 | A6 | Futures | 0.73792 | 0.74115 | 0.73328 | 0.73502 | 105813.0 |
| 2010-08-31 | AD | Futures | 0.93187 | 0.93364 | 0.92505 | 0.92525 | 108254.0 |
| 2010-08-31 | B | Futures | 66.06 | 66.51 | 64.3 | 64.66 | 90252.0 |
| 2010-08-31 | B6 | Futures | 1.6042 | 1.6059 | 1.5904 | 1.591 | 121858.0 |
| 2010-08-31 | BFX | Futures | 2784.4 | 2801.7 | 2768.5 | 2789.0 | 121.0 |
| 2010-08-31 | BR | Futures | 0.2379 | 0.23897 | 0.23773 | 0.23897 | 101.0 |
| 2010-08-31 | BZ | Futures | 69.87 | 69.87 | 68.62 | 68.62 | 305.0 |
| 2010-08-31 | C | Futures | 2159.0 | 2160.0 | 2092.0 | 2127.0 | 6173.0 |
| 2010-08-31 | CC | Futures | 2252.0 | 2301.0 | 2220.0 | 2265.0 | 16317.0 |
| 2010-08-31 | CT | Futures | 75.63 | 76.0 | 74.94 | 74.94 | 51.0 |
| 2010-08-31 | DC | Futures | 24.08 | 24.41 | 24.08 | 24.31 | 112.0 |
| 2010-08-31 | DX | Futures | 83.899 | 84.06 | 83.581 | 83.913 | 21309.0 |
| 2010-08-31 | E1 | Futures | 1.28023 | 1.29586 | 1.2801 | 1.29244 | 41815.0 |
| 2010-08-31 | E6 | Futures | 1.49751 | 1.50685 | 1.49266 | 1.49727 | 294866.0 |
| 2010-08-31 | E7 | Futures | 1.4864 | 1.496 | 1.482 | 1.4865 | 4016.0 |
| 2010-08-31 | ED | Futures | 94.6104 | 94.6175 | 94.608 | 94.6104 | 101342.0 |
| 2010-08-31 | ER | Futures | 97.316 | 97.326 | 97.311 | 97.321 | 67144.0 |
| 2010-08-31 | EW | Futures | 705.5 | 711.8 | 699.3 | 706.2 | 35705.0 |
| 2010-08-31 | FBTP | Futures | 67.33 | 67.48 | 67.31 | 67.45 | 5419.0 |
| 2010-08-31 | FCE | Futures | 2276.3 | 2306.9 | 2259.1 | 2299.0 | 126760.0 |
| 2010-08-31 | FDAX | Futures | 6364.7 | 6457.7 | 6327.1 | 6428.9 | 155008.0 |
| 2010-08-31 | FESX | Futures | 1598.7 | 1629.7 | 1590.1 | 1618.5 | 1412211.0 |
| 2010-08-31 | FGBL | Futures | 105.01 | 105.26 | 104.93 | 104.99 | 847177.0 |
| 2010-08-31 | FGBM | Futures | 106.97 | 107.1 | 106.92 | 107.01 | 470218.0 |
| 2010-08-31 | FGBS | Futures | 107.853 | 107.908 | 107.849 | 107.888 | 460091.0 |
| 2010-08-31 | FGBX | Futures | 112.3 | 112.61 | 111.62 | 112.07 | 5219.0 |
| 2010-08-31 | FTDX | Futures | 646.5 | 655.8 | 644.8 | 651.8 | 298.0 |
| 2010-08-31 | FTI | Futures | 248.27 | 253.46 | 247.95 | 252.54 | 37847.0 |
| 2010-08-31 | FTUK | Futures | 3534.4 | 3603.9 | 3525.8 | 3579.5 | 127665.0 |
| 2010-08-31 | G | Futures | 85.18 | 85.28 | 85.03 | 85.12 | 88784.0 |
| 2010-08-31 | GF | Futures | 291.397 | 292.534 | 288.427 | 288.427 | 1272.0 |
| 2010-08-31 | GSCI | Futures | 860.56 | 866.67 | 844.27 | 846.99 | 550.0 |
| 2010-08-31 | HE | Futures | 99.063 | 100.611 | 98.273 | 98.997 | 24139.0 |
| 2010-08-31 | HG | Futures | 4.5446 | 4.5486 | 4.4792 | 4.4979 | 34749.0 |
| 2010-08-31 | HH | Futures | 35.449 | 35.683 | 35.449 | 35.683 | 4.0 |
| 2010-08-31 | HO | Futures | 1.7505 | 1.7696 | 1.7162 | 1.7217 | 17634.0 |
| 2010-08-31 | HRC | Futures | 2730.7 | 2730.7 | 2730.7 | 2730.7 | 0.0 |
| 2010-08-31 | J1 | Futures | 0.0148784 | 0.0150105 | 0.014862 | 0.0149664 | 146602.0 |
| 2010-08-31 | J7 | Futures | 0.014765 | 0.014896 | 0.014751 | 0.014854 | 484.0 |
| 2010-08-31 | JB | Futures | 121.26 | 121.82 | 121.24 | 121.75 | 4372.0 |
| 2010-08-31 | KC | Futures | 446.38 | 454.32 | 439.44 | 442.54 | 7024.0 |
| 2010-08-31 | KE | Futures | 3009.1 | 3043.52 | 2924.62 | 2930.88 | 15198.0 |
| 2010-08-31 | L | Futures | 98.115 | 98.155 | 98.115 | 98.135 | 44177.0 |
| 2010-08-31 | LBS | Futures | 629.7 | 629.7 | 602.2 | 604.0 | 663.0 |
> showing 50 of 89 rows — these rows as CSV