PREVIEW / futures_daily / 2011-01-27
file: by_date/futures_daily/2011/2011-01-27.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-01-27 | ES | Futures | 1273.47 | 1277.9 | 1269.04 | 1275.44 | 1554851.0 |
| 2011-01-27 | NQ | Futures | 2631.64 | 2650.37 | 2626.24 | 2637.31 | 242547.0 |
| 2011-01-27 | YM | Futures | 11171.2 | 11204.0 | 11148.8 | 11178.7 | 91171.0 |
| 2011-01-27 | CL | Futures | 178.11 | 178.33 | 173.35 | 174.22 | 369379.0 |
| 2011-01-27 | GC | Futures | 1825.6 | 1830.8 | 1779.2 | 1791.1 | 185772.0 |
| 2011-01-27 | ZN | Futures | 100.114585 | 100.439548 | 99.72463 | 100.387554 | 1328715.0 |
| 2011-01-27 | A6 | Futures | 0.8413 | 0.84342 | 0.83265 | 0.83715 | 110286.0 |
| 2011-01-27 | AD | Futures | 0.99652 | 0.999 | 0.99274 | 0.99751 | 77082.0 |
| 2011-01-27 | B | Futures | 83.63 | 84.38 | 82.88 | 83.07 | 109289.0 |
| 2011-01-27 | B6 | Futures | 1.6498 | 1.6583 | 1.6467 | 1.6525 | 131180.0 |
| 2011-01-27 | BFX | Futures | 3071.4 | 3106.5 | 3057.2 | 3095.7 | 62.0 |
| 2011-01-27 | BR | Futures | 0.25679 | 0.25679 | 0.25476 | 0.25515 | 79.0 |
| 2011-01-27 | BZ | Futures | 88.8 | 89.79 | 88.76 | 88.76 | 841.0 |
| 2011-01-27 | C | Futures | 2431.0 | 2457.0 | 2398.0 | 2404.0 | 5595.0 |
| 2011-01-27 | CB | Futures | 118.509 | 118.509 | 116.749 | 117.335 | 22.0 |
| 2011-01-27 | CC | Futures | 2720.0 | 2775.0 | 2705.0 | 2725.0 | 11292.0 |
| 2011-01-27 | CT | Futures | 144.06 | 148.2 | 142.56 | 145.25 | 19099.0 |
| 2011-01-27 | DC | Futures | 28.16 | 28.82 | 28.16 | 28.69 | 495.0 |
| 2011-01-27 | DX | Futures | 77.715 | 78.139 | 77.57 | 77.714 | 22051.0 |
| 2011-01-27 | E1 | Futures | 1.39095 | 1.39659 | 1.38282 | 1.38636 | 38962.0 |
| 2011-01-27 | E6 | Futures | 1.61983 | 1.62704 | 1.61237 | 1.62337 | 384226.0 |
| 2011-01-27 | E7 | Futures | 1.6078 | 1.6148 | 1.6005 | 1.6113 | 6252.0 |
| 2011-01-27 | EBM | Futures | 241.25 | 243.07 | 239.89 | 240.34 | 3329.0 |
| 2011-01-27 | ED | Futures | 94.8289 | 94.8432 | 94.8147 | 94.8384 | 213087.0 |
| 2011-01-27 | ER | Futures | 97.257 | 97.271 | 97.242 | 97.252 | 160932.0 |
| 2011-01-27 | EW | Futures | 915.1 | 921.8 | 912.1 | 919.6 | 15943.0 |
| 2011-01-27 | FBTP | Futures | 63.66 | 63.72 | 63.51 | 63.6 | 7345.0 |
| 2011-01-27 | FCE | Futures | 2710.1 | 2723.8 | 2692.5 | 2710.8 | 123868.0 |
| 2011-01-27 | FDAX | Futures | 7656.6 | 7698.4 | 7627.2 | 7670.6 | 137213.0 |
| 2011-01-27 | FESX | Futures | 1847.0 | 1868.8 | 1834.6 | 1859.5 | 1267103.0 |
| 2011-01-27 | FEU3 | Futures | 97.825 | 97.825 | 97.81 | 97.81 | 5.0 |
| 2011-01-27 | FGBL | Futures | 97.86 | 98.04 | 97.59 | 97.68 | 1005308.0 |
| 2011-01-27 | FGBM | Futures | 103.39 | 103.45 | 103.1 | 103.18 | 724731.0 |
| 2011-01-27 | FGBS | Futures | 106.724 | 106.769 | 106.621 | 106.635 | 757150.0 |
| 2011-01-27 | FGBX | Futures | 95.08 | 95.65 | 94.78 | 94.87 | 4392.0 |
| 2011-01-27 | FTDX | Futures | 771.9 | 778.9 | 770.1 | 772.3 | 454.0 |
| 2011-01-27 | FTI | Futures | 292.05 | 293.83 | 290.6 | 292.74 | 31035.0 |
| 2011-01-27 | FTUK | Futures | 4126.3 | 4141.6 | 4106.1 | 4120.4 | 87196.0 |
| 2011-01-27 | FXXP | Futures | 182.7 | 183.9 | 182.7 | 183.1 | 884.0 |
| 2011-01-27 | G | Futures | 80.36 | 80.48 | 80.17 | 80.38 | 167562.0 |
| 2011-01-27 | GF | Futures | 311.054 | 312.473 | 308.958 | 309.821 | 3078.0 |
| 2011-01-27 | GSCI | Futures | 1014.36 | 1015.63 | 1002.65 | 1003.21 | 92.0 |
| 2011-01-27 | HE | Futures | 105.597 | 107.464 | 104.839 | 105.043 | 32127.0 |
| 2011-01-27 | HG | Futures | 5.7174 | 5.8047 | 5.6981 | 5.782 | 38268.0 |
| 2011-01-27 | HO | Futures | 2.2386 | 2.2547 | 2.2179 | 2.2205 | 52884.0 |
| 2011-01-27 | HRC | Futures | 2709.3 | 2709.3 | 2709.3 | 2709.3 | 28.0 |
| 2011-01-27 | J1 | Futures | 0.0152716 | 0.0153181 | 0.0150933 | 0.0151674 | 176572.0 |
| 2011-01-27 | J7 | Futures | 0.015162 | 0.015205 | 0.014991 | 0.01506 | 367.0 |
| 2011-01-27 | JB | Futures | 120.54 | 120.83 | 120.43 | 120.61 | 2485.0 |
| 2011-01-27 | KC | Futures | 584.13 | 592.22 | 575.55 | 581.07 | 8365.0 |
> showing 50 of 93 rows — these rows as CSV