PREVIEW / futures_daily / 2010-08-24
file: by_date/futures_daily/2010/2010-08-24.parquet size: 9 KB rows: 92
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-24 | ES | Futures | 1039.24 | 1039.48 | 1018.27 | 1023.88 | 2466756.0 |
| 2010-08-24 | NQ | Futures | 2047.75 | 2048.89 | 1998.8 | 2007.57 | 317739.0 |
| 2010-08-24 | YM | Futures | 9384.6 | 9394.7 | 9218.2 | 9267.2 | 161421.0 |
| 2010-08-24 | CL | Futures | 153.88 | 154.09 | 150.44 | 151.1 | 340994.0 |
| 2010-08-24 | GC | Futures | 1668.2 | 1682.1 | 1647.0 | 1676.5 | 136558.0 |
| 2010-08-24 | ZN | Futures | 103.07765 | 103.884445 | 103.039232 | 103.602707 | 1556615.0 |
| 2010-08-24 | A6 | Futures | 0.73651 | 0.73668 | 0.7274 | 0.73063 | 119480.0 |
| 2010-08-24 | AD | Futures | 0.93858 | 0.93888 | 0.92564 | 0.93147 | 125930.0 |
| 2010-08-24 | B | Futures | 63.69 | 63.99 | 62.64 | 62.88 | 183327.0 |
| 2010-08-24 | B6 | Futures | 1.6087 | 1.6096 | 1.595 | 1.6021 | 126371.0 |
| 2010-08-24 | BFX | Futures | 2798.1 | 2798.1 | 2759.3 | 2780.2 | 161.0 |
| 2010-08-24 | BR | Futures | 0.23649 | 0.23649 | 0.23649 | 0.23649 | 663.0 |
| 2010-08-24 | BZ | Futures | 68.06 | 68.37 | 67.43 | 67.66 | 284.0 |
| 2010-08-24 | C | Futures | 2281.0 | 2285.0 | 2259.0 | 2282.0 | 1980.0 |
| 2010-08-24 | CB | Futures | 95.535 | 97.756 | 95.535 | 97.756 | 13.0 |
| 2010-08-24 | CC | Futures | 2342.0 | 2354.0 | 2298.0 | 2328.0 | 7665.0 |
| 2010-08-24 | CSC | Futures | 3.628 | 3.628 | 3.628 | 3.628 | 1.0 |
| 2010-08-24 | CT | Futures | 73.73 | 74.66 | 72.6 | 74.38 | 48.0 |
| 2010-08-24 | DC | Futures | 23.97 | 24.11 | 23.97 | 24.11 | 134.0 |
| 2010-08-24 | DX | Futures | 84.106 | 84.297 | 83.551 | 83.865 | 37583.0 |
| 2010-08-24 | E1 | Futures | 1.26158 | 1.27695 | 1.25672 | 1.27366 | 49169.0 |
| 2010-08-24 | E6 | Futures | 1.49585 | 1.50401 | 1.4884 | 1.49846 | 378965.0 |
| 2010-08-24 | E7 | Futures | 1.4852 | 1.4932 | 1.4778 | 1.4877 | 4103.0 |
| 2010-08-24 | ED | Futures | 94.6128 | 94.6199 | 94.5914 | 94.5962 | 239603.0 |
| 2010-08-24 | ER | Futures | 97.33 | 97.335 | 97.316 | 97.321 | 93209.0 |
| 2010-08-24 | EW | Futures | 713.5 | 714.4 | 696.4 | 701.6 | 39778.0 |
| 2010-08-24 | FBTP | Futures | 67.1 | 67.43 | 67.09 | 67.42 | 3345.0 |
| 2010-08-24 | FCE | Futures | 2325.4 | 2325.7 | 2276.3 | 2299.7 | 136753.0 |
| 2010-08-24 | FDAX | Futures | 6518.1 | 6518.6 | 6386.4 | 6458.8 | 171489.0 |
| 2010-08-24 | FESX | Futures | 1637.7 | 1637.7 | 1599.4 | 1617.9 | 1380240.0 |
| 2010-08-24 | FEU3 | Futures | 97.884 | 97.889 | 97.879 | 97.879 | 34.0 |
| 2010-08-24 | FGBL | Futures | 103.8 | 104.86 | 103.74 | 104.58 | 1024065.0 |
| 2010-08-24 | FGBM | Futures | 106.6 | 107.07 | 106.56 | 106.88 | 460003.0 |
| 2010-08-24 | FGBS | Futures | 107.839 | 107.932 | 107.824 | 107.883 | 460480.0 |
| 2010-08-24 | FGBX | Futures | 107.43 | 109.79 | 107.33 | 109.34 | 4784.0 |
| 2010-08-24 | FTDX | Futures | 650.0 | 650.0 | 634.6 | 639.9 | 472.0 |
| 2010-08-24 | FTI | Futures | 253.22 | 253.22 | 247.71 | 250.23 | 38338.0 |
| 2010-08-24 | FTUK | Futures | 3572.6 | 3576.7 | 3512.0 | 3548.9 | 102440.0 |
| 2010-08-24 | G | Futures | 84.13 | 84.9 | 84.11 | 84.64 | 220827.0 |
| 2010-08-24 | GF | Futures | 295.188 | 295.694 | 293.04 | 293.735 | 947.0 |
| 2010-08-24 | GSCI | Futures | 840.2 | 843.76 | 837.65 | 838.5 | 246.0 |
| 2010-08-24 | HE | Futures | 103.411 | 103.443 | 100.875 | 101.797 | 14099.0 |
| 2010-08-24 | HG | Futures | 4.4125 | 4.4212 | 4.2857 | 4.3538 | 17593.0 |
| 2010-08-24 | HO | Futures | 1.7087 | 1.7106 | 1.6872 | 1.6899 | 11747.0 |
| 2010-08-24 | HRC | Futures | 2753.7 | 2753.7 | 2753.7 | 2753.7 | 0.0 |
| 2010-08-24 | J1 | Futures | 0.0147815 | 0.0150545 | 0.0147689 | 0.0149388 | 212060.0 |
| 2010-08-24 | J7 | Futures | 0.014671 | 0.01495 | 0.01466 | 0.014826 | 681.0 |
| 2010-08-24 | JB | Futures | 121.62 | 121.81 | 121.62 | 121.8 | 1261.0 |
| 2010-08-24 | KC | Futures | 453.2 | 454.19 | 415.88 | 417.74 | 28407.0 |
| 2010-08-24 | KE | Futures | 3046.88 | 3055.4 | 2970.18 | 2986.16 | 11912.0 |
> showing 50 of 92 rows — these rows as CSV