PREVIEW / futures_daily / 2011-02-22
file: by_date/futures_daily/2011/2011-02-22.parquet size: 9 KB rows: 93
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-02-22 | ES | Futures | 1321.21 | 1321.46 | 1289.71 | 1293.89 | 3257861.0 |
| 2011-02-22 | NQ | Futures | 2717.35 | 2717.92 | 2628.8 | 2635.89 | 450245.0 |
| 2011-02-22 | YM | Futures | 11578.4 | 11583.1 | 11378.1 | 11402.4 | 191515.0 |
| 2011-02-22 | CL | Futures | 174.95 | 191.34 | 174.42 | 185.4 | 638193.0 |
| 2011-02-22 | GC | Futures | 1886.5 | 1915.6 | 1886.5 | 1901.5 | 222807.0 |
| 2011-02-22 | ZN | Futures | 99.009711 | 99.958603 | 98.996713 | 99.906609 | 1695487.0 |
| 2011-02-22 | A6 | Futures | 0.85775 | 0.8586 | 0.843 | 0.84368 | 152924.0 |
| 2011-02-22 | AD | Futures | 1.00664 | 1.01001 | 0.99989 | 1.00158 | 133241.0 |
| 2011-02-22 | B | Futures | 91.92 | 92.5 | 89.93 | 90.12 | 241039.0 |
| 2011-02-22 | B6 | Futures | 1.6852 | 1.6861 | 1.6699 | 1.6745 | 173888.0 |
| 2011-02-22 | BFX | Futures | 3109.2 | 3140.2 | 3088.3 | 3131.5 | 64.0 |
| 2011-02-22 | BR | Futures | 0.25887 | 0.25896 | 0.25804 | 0.25815 | 874.0 |
| 2011-02-22 | BZ | Futures | 95.05 | 98.84 | 94.66 | 96.29 | 1617.0 |
| 2011-02-22 | C | Futures | 2533.0 | 2598.0 | 2533.0 | 2581.0 | 3030.0 |
| 2011-02-22 | CB | Futures | 114.695 | 114.695 | 114.695 | 114.695 | 2.0 |
| 2011-02-22 | CC | Futures | 2829.0 | 2900.0 | 2820.0 | 2882.0 | 10988.0 |
| 2011-02-22 | CT | Futures | 168.94 | 169.2 | 168.05 | 168.05 | 4585.0 |
| 2011-02-22 | DC | Futures | 30.36 | 30.6 | 29.69 | 30.03 | 158.0 |
| 2011-02-22 | DX | Futures | 77.74 | 78.249 | 77.495 | 77.683 | 26183.0 |
| 2011-02-22 | E1 | Futures | 1.38518 | 1.3996 | 1.37902 | 1.3975 | 80368.0 |
| 2011-02-22 | E6 | Futures | 1.61923 | 1.62243 | 1.59983 | 1.6158 | 505527.0 |
| 2011-02-22 | E7 | Futures | 1.6072 | 1.6102 | 1.5878 | 1.6038 | 9517.0 |
| 2011-02-22 | EBM | Futures | 236.94 | 238.08 | 223.32 | 224.0 | 9524.0 |
| 2011-02-22 | ED | Futures | 94.8456 | 94.8527 | 94.8384 | 94.848 | 208851.0 |
| 2011-02-22 | ER | Futures | 97.271 | 97.281 | 97.237 | 97.257 | 171626.0 |
| 2011-02-22 | EW | Futures | 966.4 | 968.0 | 942.8 | 944.8 | 28478.0 |
| 2011-02-22 | FBTP | Futures | 63.92 | 64.05 | 63.77 | 63.83 | 8885.0 |
| 2011-02-22 | FCE | Futures | 2716.3 | 2716.3 | 2669.1 | 2695.0 | 167110.0 |
| 2011-02-22 | FDAX | Futures | 7828.5 | 7877.8 | 7765.9 | 7844.6 | 184596.0 |
| 2011-02-22 | FESX | Futures | 1865.7 | 1867.5 | 1836.5 | 1856.4 | 1797852.0 |
| 2011-02-22 | FEU3 | Futures | 97.835 | 97.835 | 97.815 | 97.815 | 16.0 |
| 2011-02-22 | FGBL | Futures | 98.16 | 98.49 | 98.12 | 98.31 | 968016.0 |
| 2011-02-22 | FGBM | Futures | 103.77 | 103.94 | 103.58 | 103.74 | 716692.0 |
| 2011-02-22 | FGBS | Futures | 106.704 | 106.754 | 106.532 | 106.591 | 1048760.0 |
| 2011-02-22 | FGBX | Futures | 95.34 | 95.85 | 95.27 | 95.63 | 2695.0 |
| 2011-02-22 | FTDX | Futures | 787.2 | 793.8 | 775.8 | 790.3 | 1406.0 |
| 2011-02-22 | FTI | Futures | 299.19 | 299.8 | 296.0 | 298.83 | 41777.0 |
| 2011-02-22 | FTUK | Futures | 4151.3 | 4174.2 | 4100.9 | 4153.7 | 131544.0 |
| 2011-02-22 | FXXP | Futures | 183.9 | 185.5 | 183.7 | 185.3 | 656.0 |
| 2011-02-22 | G | Futures | 80.18 | 80.49 | 80.18 | 80.39 | 106819.0 |
| 2011-02-22 | GF | Futures | 320.86 | 322.155 | 318.023 | 318.701 | 3200.0 |
| 2011-02-22 | GSCI | Futures | 1067.95 | 1068.34 | 1046.19 | 1051.85 | 81.0 |
| 2011-02-22 | HE | Futures | 108.193 | 109.623 | 107.26 | 107.668 | 19808.0 |
| 2011-02-22 | HG | Futures | 5.9886 | 6.0286 | 5.7582 | 5.8115 | 26056.0 |
| 2011-02-22 | HO | Futures | 2.2986 | 2.3936 | 2.2986 | 2.3462 | 16591.0 |
| 2011-02-22 | HRC | Futures | 2921.8 | 2921.8 | 2921.8 | 2921.8 | 0.0 |
| 2011-02-22 | J1 | Futures | 0.0151096 | 0.0152101 | 0.0150531 | 0.0151863 | 213434.0 |
| 2011-02-22 | J7 | Futures | 0.015002 | 0.015102 | 0.014949 | 0.015078 | 1388.0 |
| 2011-02-22 | JB | Futures | 120.12 | 120.67 | 120.1 | 120.64 | 2815.0 |
| 2011-02-22 | KC | Futures | 661.67 | 674.76 | 655.25 | 664.94 | 12146.0 |
> showing 50 of 93 rows — these rows as CSV