PREVIEW / futures_daily / 2011-06-30
file: by_date/futures_daily/2011/2011-06-30.parquet size: 9 KB rows: 96
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-06-30 | ES | Futures | 1295.05 | 1308.45 | 1293.31 | 1306.47 | 1875270.0 |
| 2011-06-30 | NQ | Futures | 2611.46 | 2645.9 | 2604.91 | 2643.06 | 201935.0 |
| 2011-06-30 | YM | Futures | 11545.3 | 11688.0 | 11532.1 | 11671.0 | 107760.0 |
| 2011-06-30 | CL | Futures | 182.44 | 183.86 | 180.14 | 183.09 | 276580.0 |
| 2011-06-30 | GC | Futures | 2046.8 | 2050.2 | 2028.9 | 2033.9 | 134201.0 |
| 2011-06-30 | ZN | Futures | 104.616998 | 104.803268 | 103.778785 | 104.164629 | 1801212.0 |
| 2011-06-30 | A6 | Futures | 0.91891 | 0.92605 | 0.91883 | 0.92431 | 99354.0 |
| 2011-06-30 | AD | Futures | 1.0266 | 1.03499 | 1.0266 | 1.03379 | 89580.0 |
| 2011-06-30 | B | Futures | 96.08 | 96.45 | 94.38 | 95.84 | 92501.0 |
| 2011-06-30 | B6 | Futures | 1.6694 | 1.675 | 1.66 | 1.6697 | 128622.0 |
| 2011-06-30 | BFX | Futures | 3039.7 | 3054.2 | 3031.8 | 3052.9 | 60.0 |
| 2011-06-30 | BR | Futures | 0.27907 | 0.28214 | 0.27907 | 0.2815 | 573.0 |
| 2011-06-30 | BZ | Futures | 99.53 | 99.53 | 99.53 | 99.53 | 568.0 |
| 2011-06-30 | C | Futures | 2111.0 | 2131.0 | 2104.0 | 2125.0 | 8349.0 |
| 2011-06-30 | CB | Futures | 112.326 | 112.874 | 112.326 | 112.874 | 9.0 |
| 2011-06-30 | CC | Futures | 2473.0 | 2506.0 | 2461.0 | 2498.0 | 10658.0 |
| 2011-06-30 | CSC | Futures | 4.548 | 4.558 | 4.536 | 4.536 | 8.0 |
| 2011-06-30 | CT | Futures | 166.11 | 167.89 | 158.64 | 160.52 | 64.0 |
| 2011-06-30 | DC | Futures | 31.13 | 31.13 | 30.4 | 30.64 | 204.0 |
| 2011-06-30 | DX | Futures | 74.192 | 74.192 | 73.821 | 73.915 | 32698.0 |
| 2011-06-30 | E1 | Futures | 1.56785 | 1.57557 | 1.54575 | 1.55726 | 58955.0 |
| 2011-06-30 | E6 | Futures | 1.71039 | 1.72298 | 1.70967 | 1.72072 | 290440.0 |
| 2011-06-30 | E7 | Futures | 1.6972 | 1.711 | 1.6972 | 1.7082 | 5276.0 |
| 2011-06-30 | ED | Futures | 94.943 | 94.9668 | 94.9382 | 94.9573 | 266285.0 |
| 2011-06-30 | ER | Futures | 97.296 | 97.306 | 97.272 | 97.281 | 133880.0 |
| 2011-06-30 | EW | Futures | 961.6 | 972.1 | 960.8 | 967.7 | 26177.0 |
| 2011-06-30 | FBTP | Futures | 64.33 | 64.85 | 64.33 | 64.79 | 6516.0 |
| 2011-06-30 | FCE | Futures | 2738.9 | 2773.6 | 2726.0 | 2765.6 | 126753.0 |
| 2011-06-30 | FDAX | Futures | 7847.1 | 7923.5 | 7809.7 | 7897.9 | 117482.0 |
| 2011-06-30 | FESX | Futures | 1808.8 | 1834.4 | 1797.9 | 1826.7 | 1484028.0 |
| 2011-06-30 | FEU3 | Futures | 97.83 | 97.83 | 97.815 | 97.82 | 71.0 |
| 2011-06-30 | FGBL | Futures | 100.93 | 101.14 | 100.48 | 100.66 | 1149718.0 |
| 2011-06-30 | FGBM | Futures | 105.17 | 105.3 | 104.73 | 104.89 | 724617.0 |
| 2011-06-30 | FGBS | Futures | 107.089 | 107.129 | 106.9 | 106.975 | 770294.0 |
| 2011-06-30 | FGBX | Futures | 94.44 | 94.61 | 93.46 | 93.97 | 9473.0 |
| 2011-06-30 | FTDX | Futures | 790.0 | 802.5 | 789.1 | 798.4 | 202.0 |
| 2011-06-30 | FTI | Futures | 276.23 | 279.51 | 275.41 | 278.86 | 33403.0 |
| 2011-06-30 | FTUK | Futures | 4110.3 | 4179.8 | 4109.6 | 4163.9 | 122821.0 |
| 2011-06-30 | FXXP | Futures | 182.8 | 184.6 | 182.4 | 184.1 | 3403.0 |
| 2011-06-30 | G | Futures | 84.31 | 84.54 | 83.81 | 83.92 | 175777.0 |
| 2011-06-30 | GF | Futures | 319.96 | 324.608 | 319.495 | 320.89 | 3916.0 |
| 2011-06-30 | GSCI | Futures | 1056.48 | 1056.48 | 1043.47 | 1050.41 | 287.0 |
| 2011-06-30 | HE | Futures | 101.492 | 102.452 | 100.265 | 100.718 | 8330.0 |
| 2011-06-30 | HG | Futures | 5.5866 | 5.6679 | 5.5601 | 5.6612 | 36405.0 |
| 2011-06-30 | HO | Futures | 2.3884 | 2.4136 | 2.3675 | 2.3977 | 21885.0 |
| 2011-06-30 | HRC | Futures | 3018.5 | 3018.5 | 3018.5 | 3018.5 | 10.0 |
| 2011-06-30 | J1 | Futures | 0.0155581 | 0.0156662 | 0.0155493 | 0.0156272 | 126482.0 |
| 2011-06-30 | J7 | Futures | 0.015454 | 0.01556 | 0.01545 | 0.015523 | 269.0 |
| 2011-06-30 | JB | Futures | 122.98 | 123.07 | 122.77 | 122.87 | 3487.0 |
| 2011-06-30 | KC | Futures | 621.84 | 631.18 | 618.05 | 628.34 | 10535.0 |
> showing 50 of 96 rows — these rows as CSV