PREVIEW / futures_daily / 2011-02-16
file: by_date/futures_daily/2011/2011-02-16.parquet size: 9 KB rows: 94
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-16 | ES | Futures | 1305.46 | 1315.06 | 1304.97 | 1312.1 | 1801087.0 |
| 2011-02-16 | NQ | Futures | 2703.44 | 2728.14 | 2701.74 | 2715.65 | 230670.0 |
| 2011-02-16 | YM | Futures | 11421.1 | 11496.0 | 11412.7 | 11467.0 | 122021.0 |
| 2011-02-16 | CL | Futures | 170.5 | 172.48 | 169.21 | 170.67 | 254054.0 |
| 2011-02-16 | GC | Futures | 1865.1 | 1876.5 | 1856.9 | 1866.2 | 133587.0 |
| 2011-02-16 | ZN | Futures | 98.736742 | 98.944719 | 98.450775 | 98.658751 | 1442480.0 |
| 2011-02-16 | A6 | Futures | 0.843 | 0.85004 | 0.84198 | 0.84893 | 100961.0 |
| 2011-02-16 | AD | Futures | 1.00227 | 1.00743 | 1.00197 | 1.00654 | 61050.0 |
| 2011-02-16 | B | Futures | 86.68 | 89.04 | 86.67 | 88.41 | 202729.0 |
| 2011-02-16 | B6 | Futures | 1.6722 | 1.6786 | 1.658 | 1.6693 | 199390.0 |
| 2011-02-16 | BFX | Futures | 3160.7 | 3190.7 | 3160.7 | 3173.7 | 880.0 |
| 2011-02-16 | BR | Futures | 0.25756 | 0.25756 | 0.25679 | 0.2573 | 40.0 |
| 2011-02-16 | BZ | Futures | 92.51 | 95.11 | 92.51 | 94.47 | 940.0 |
| 2011-02-16 | C | Futures | 2424.0 | 2465.0 | 2405.0 | 2462.0 | 2934.0 |
| 2011-02-16 | CB | Futures | 114.402 | 114.989 | 114.402 | 114.695 | 59.0 |
| 2011-02-16 | CC | Futures | 2736.0 | 2758.0 | 2692.0 | 2750.0 | 5934.0 |
| 2011-02-16 | CSC | Futures | 4.379 | 4.379 | 4.379 | 4.379 | 1.0 |
| 2011-02-16 | CT | Futures | 165.35 | 168.94 | 164.11 | 168.94 | 6054.0 |
| 2011-02-16 | DC | Futures | 30.8 | 31.12 | 30.77 | 31.07 | 426.0 |
| 2011-02-16 | DX | Futures | 78.449 | 78.728 | 78.079 | 78.136 | 25399.0 |
| 2011-02-16 | E1 | Futures | 1.35582 | 1.37247 | 1.34612 | 1.36775 | 92165.0 |
| 2011-02-16 | E6 | Futures | 1.59534 | 1.60728 | 1.59214 | 1.60468 | 418100.0 |
| 2011-02-16 | E7 | Futures | 1.5833 | 1.5952 | 1.5803 | 1.5927 | 7585.0 |
| 2011-02-16 | EBM | Futures | 241.93 | 242.84 | 235.58 | 237.39 | 9790.0 |
| 2011-02-16 | ED | Futures | 94.848 | 94.8527 | 94.8456 | 94.848 | 159996.0 |
| 2011-02-16 | ER | Futures | 97.286 | 97.306 | 97.286 | 97.291 | 60036.0 |
| 2011-02-16 | EW | Futures | 955.5 | 963.9 | 955.2 | 960.7 | 15780.0 |
| 2011-02-16 | FBTP | Futures | 63.77 | 64.12 | 63.76 | 64.1 | 5350.0 |
| 2011-02-16 | FCE | Futures | 2741.2 | 2772.1 | 2738.2 | 2760.1 | 163992.0 |
| 2011-02-16 | FDAX | Futures | 7956.5 | 7970.9 | 7930.8 | 7954.9 | 119895.0 |
| 2011-02-16 | FESX | Futures | 1891.8 | 1911.7 | 1886.2 | 1906.1 | 1263993.0 |
| 2011-02-16 | FEU3 | Futures | 97.855 | 97.855 | 97.85 | 97.85 | 24.0 |
| 2011-02-16 | FGBL | Futures | 97.14 | 97.76 | 97.13 | 97.47 | 1078066.0 |
| 2011-02-16 | FGBM | Futures | 103.18 | 103.6 | 103.17 | 103.36 | 675198.0 |
| 2011-02-16 | FGBS | Futures | 106.611 | 106.709 | 106.596 | 106.635 | 710328.0 |
| 2011-02-16 | FGBX | Futures | 93.18 | 94.32 | 93.16 | 93.76 | 2853.0 |
| 2011-02-16 | FTDX | Futures | 797.3 | 804.4 | 797.3 | 801.3 | 489.0 |
| 2011-02-16 | FTI | Futures | 300.77 | 301.34 | 299.72 | 300.61 | 40462.0 |
| 2011-02-16 | FTUK | Futures | 4178.7 | 4220.8 | 4178.7 | 4216.6 | 82741.0 |
| 2011-02-16 | FXXP | Futures | 187.7 | 188.9 | 187.7 | 188.6 | 1905.0 |
| 2011-02-16 | G | Futures | 79.52 | 80.0 | 79.5 | 79.62 | 148304.0 |
| 2011-02-16 | GF | Futures | 318.146 | 322.216 | 317.899 | 321.846 | 2441.0 |
| 2011-02-16 | GSCI | Futures | 1021.21 | 1033.54 | 1021.21 | 1028.28 | 204.0 |
| 2011-02-16 | HE | Futures | 107.989 | 110.848 | 106.822 | 107.231 | 22297.0 |
| 2011-02-16 | HG | Futures | 6.0452 | 6.0719 | 5.9606 | 5.9706 | 17658.0 |
| 2011-02-16 | HO | Futures | 2.2884 | 2.3376 | 2.2884 | 2.3257 | 16424.0 |
| 2011-02-16 | HRC | Futures | 2868.7 | 2868.7 | 2868.7 | 2868.7 | 0.0 |
| 2011-02-16 | J1 | Futures | 0.0149979 | 0.0150431 | 0.0149552 | 0.0150318 | 145812.0 |
| 2011-02-16 | J7 | Futures | 0.014891 | 0.014935 | 0.01485 | 0.014925 | 716.0 |
| 2011-02-16 | JB | Futures | 119.99 | 120.12 | 119.7 | 119.7 | 2397.0 |
> showing 50 of 94 rows — these rows as CSV