PREVIEW / futures_daily / 2011-03-03
file: by_date/futures_daily/2011/2011-03-03.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-03-03 | ES | Futures | 1285.77 | 1311.12 | 1284.54 | 1308.91 | 2361733.0 |
| 2011-03-03 | NQ | Futures | 2636.18 | 2697.48 | 2635.32 | 2692.66 | 288788.0 |
| 2011-03-03 | YM | Futures | 11274.2 | 11485.7 | 11267.6 | 11454.8 | 112325.0 |
| 2011-03-03 | CL | Futures | 198.94 | 200.01 | 194.59 | 198.01 | 382555.0 |
| 2011-03-03 | GC | Futures | 1949.5 | 1950.0 | 1914.3 | 1922.2 | 202801.0 |
| 2011-03-03 | ZN | Futures | 99.815619 | 99.906609 | 99.178692 | 99.191691 | 85959.0 |
| 2011-03-03 | A6 | Futures | 0.86106 | 0.8631 | 0.85767 | 0.85979 | 90041.0 |
| 2011-03-03 | AD | Futures | 1.01984 | 1.02143 | 1.01736 | 1.02093 | 68804.0 |
| 2011-03-03 | B | Futures | 98.74 | 98.98 | 95.84 | 97.4 | 126539.0 |
| 2011-03-03 | B6 | Futures | 1.6934 | 1.6943 | 1.6858 | 1.6881 | 136190.0 |
| 2011-03-03 | BFX | Futures | 3111.1 | 3129.6 | 3094.4 | 3109.4 | 56.0 |
| 2011-03-03 | BR | Futures | 0.26178 | 0.26182 | 0.26127 | 0.26149 | 445.0 |
| 2011-03-03 | BZ | Futures | 102.32 | 102.66 | 101.68 | 102.6 | 1579.0 |
| 2011-03-03 | C | Futures | 2582.0 | 2636.0 | 2582.0 | 2628.0 | 7009.0 |
| 2011-03-03 | CB | Futures | 118.802 | 122.469 | 118.802 | 121.882 | 14.0 |
| 2011-03-03 | CC | Futures | 2945.0 | 3022.0 | 2944.0 | 3000.0 | 6958.0 |
| 2011-03-03 | CT | Futures | 182.42 | 185.64 | 179.38 | 183.94 | 12699.0 |
| 2011-03-03 | DC | Futures | 29.17 | 29.45 | 29.15 | 29.4 | 92.0 |
| 2011-03-03 | DX | Futures | 76.572 | 76.737 | 76.237 | 76.357 | 29953.0 |
| 2011-03-03 | E1 | Futures | 1.41913 | 1.41979 | 1.40511 | 1.40655 | 66387.0 |
| 2011-03-03 | E6 | Futures | 1.64006 | 1.65331 | 1.63627 | 1.65106 | 432965.0 |
| 2011-03-03 | E7 | Futures | 1.628 | 1.641 | 1.6242 | 1.6388 | 5896.0 |
| 2011-03-03 | EBM | Futures | 233.08 | 233.08 | 230.36 | 231.04 | 1619.0 |
| 2011-03-03 | ED | Futures | 94.8646 | 94.867 | 94.8622 | 94.8622 | 126935.0 |
| 2011-03-03 | ER | Futures | 97.291 | 97.291 | 97.173 | 97.203 | 412823.0 |
| 2011-03-03 | EW | Futures | 939.0 | 962.3 | 938.6 | 960.5 | 24045.0 |
| 2011-03-03 | FBTP | Futures | 63.63 | 63.71 | 63.09 | 63.25 | 15300.0 |
| 2011-03-03 | FCE | Futures | 2693.3 | 2724.2 | 2684.4 | 2699.0 | 186442.0 |
| 2011-03-03 | FDAX | Futures | 7731.6 | 7814.6 | 7701.6 | 7734.3 | 176198.0 |
| 2011-03-03 | FESX | Futures | 1849.5 | 1868.8 | 1835.2 | 1842.7 | 1635645.0 |
| 2011-03-03 | FEU3 | Futures | 97.845 | 97.845 | 97.741 | 97.761 | 21.0 |
| 2011-03-03 | FGBL | Futures | 97.92 | 97.94 | 97.14 | 97.31 | 1586235.0 |
| 2011-03-03 | FGBM | Futures | 103.32 | 103.37 | 102.56 | 102.7 | 1271782.0 |
| 2011-03-03 | FGBS | Futures | 106.547 | 106.586 | 106.162 | 106.216 | 1635532.0 |
| 2011-03-03 | FGBX | Futures | 94.7 | 94.85 | 93.59 | 93.9 | 26267.0 |
| 2011-03-03 | FTDX | Futures | 774.1 | 796.5 | 774.1 | 793.4 | 1285.0 |
| 2011-03-03 | FTI | Futures | 296.6 | 299.03 | 295.47 | 297.53 | 45414.0 |
| 2011-03-03 | FTUK | Futures | 4091.9 | 4183.2 | 4091.5 | 4157.5 | 124440.0 |
| 2011-03-03 | FXXP | Futures | 183.6 | 185.1 | 183.2 | 183.8 | 4030.0 |
| 2011-03-03 | G | Futures | 80.59 | 80.72 | 80.27 | 80.34 | 161896.0 |
| 2011-03-03 | GF | Futures | 320.058 | 322.525 | 318.578 | 320.613 | 2545.0 |
| 2011-03-03 | GSCI | Futures | 1112.33 | 1118.62 | 1107.15 | 1118.62 | 678.0 |
| 2011-03-03 | HE | Futures | 103.176 | 104.022 | 102.709 | 103.614 | 18590.0 |
| 2011-03-03 | HG | Futures | 5.986 | 6.0586 | 5.9547 | 5.9806 | 29124.0 |
| 2011-03-03 | HO | Futures | 2.5634 | 2.5634 | 2.5237 | 2.5494 | 17332.0 |
| 2011-03-03 | HRC | Futures | 3081.2 | 3081.2 | 3081.2 | 3081.2 | 0.0 |
| 2011-03-03 | J1 | Futures | 0.0153457 | 0.0153671 | 0.0152176 | 0.0152453 | 185556.0 |
| 2011-03-03 | J7 | Futures | 0.01524 | 0.015257 | 0.015109 | 0.015137 | 1003.0 |
| 2011-03-03 | JB | Futures | 120.79 | 120.79 | 120.57 | 120.67 | 2454.0 |
| 2011-03-03 | KC | Futures | 651.73 | 670.76 | 651.13 | 665.91 | 11221.0 |
> showing 50 of 93 rows — these rows as CSV