PREVIEW / futures_daily / 2011-08-19
file: by_date/futures_daily/2011/2011-08-19.parquet size: 9 KB rows: 97
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-08-19 | ES | Futures | 1135.9 | 1145.33 | 1109.83 | 1116.28 | 3583223.0 |
| 2011-08-19 | NQ | Futures | 2374.03 | 2393.67 | 2315.95 | 2324.2 | 374568.0 |
| 2011-08-19 | YM | Futures | 10422.1 | 10460.9 | 10189.6 | 10229.3 | 165735.0 |
| 2011-08-19 | CL | Futures | 155.15 | 159.59 | 151.21 | 156.98 | 392953.0 |
| 2011-08-19 | GC | Futures | 2466.9 | 2540.2 | 2463.4 | 2500.8 | 281310.0 |
| 2011-08-19 | ZN | Futures | 111.349314 | 111.721853 | 110.976775 | 111.375924 | 1285522.0 |
| 2011-08-19 | A6 | Futures | 0.89969 | 0.90839 | 0.89386 | 0.90047 | 133930.0 |
| 2011-08-19 | AD | Futures | 1.00684 | 1.01513 | 1.00475 | 1.00784 | 97511.0 |
| 2011-08-19 | B | Futures | 90.9 | 93.58 | 89.87 | 92.91 | 246737.0 |
| 2011-08-19 | B6 | Futures | 1.7165 | 1.7284 | 1.7102 | 1.7141 | 105227.0 |
| 2011-08-19 | BFX | Futures | 2507.6 | 2592.0 | 2506.5 | 2555.8 | 196.0 |
| 2011-08-19 | BR | Futures | 0.2776 | 0.2776 | 0.2776 | 0.2776 | 74.0 |
| 2011-08-19 | BZ | Futures | 94.12 | 96.57 | 94.12 | 95.96 | 1062.0 |
| 2011-08-19 | C | Futures | 2037.0 | 2038.0 | 2017.0 | 2025.0 | 2116.0 |
| 2011-08-19 | CC | Futures | 2336.0 | 2363.0 | 2313.0 | 2355.0 | 10639.0 |
| 2011-08-19 | CSC | Futures | 4.511 | 4.511 | 4.509 | 4.509 | 2.0 |
| 2011-08-19 | CT | Futures | 138.69 | 140.16 | 137.43 | 138.55 | 22.0 |
| 2011-08-19 | DC | Futures | 31.57 | 31.67 | 30.73 | 30.98 | 618.0 |
| 2011-08-19 | DX | Futures | 73.756 | 73.85 | 72.974 | 73.391 | 25732.0 |
| 2011-08-19 | E1 | Futures | 1.64881 | 1.6781 | 1.64528 | 1.66267 | 24131.0 |
| 2011-08-19 | E6 | Futures | 1.70112 | 1.71609 | 1.69281 | 1.70813 | 313366.0 |
| 2011-08-19 | E7 | Futures | 1.6889 | 1.7034 | 1.6807 | 1.6957 | 4560.0 |
| 2011-08-19 | ED | Futures | 94.9144 | 94.9168 | 94.8763 | 94.8977 | 209284.0 |
| 2011-08-19 | ER | Futures | 97.593 | 97.638 | 97.569 | 97.578 | 112971.0 |
| 2011-08-19 | EW | Futures | 799.3 | 806.1 | 778.7 | 784.9 | 35540.0 |
| 2011-08-19 | FBTP | Futures | 64.71 | 64.83 | 64.44 | 64.77 | 6751.0 |
| 2011-08-19 | FCE | Futures | 2132.3 | 2158.0 | 2063.9 | 2114.1 | 139330.0 |
| 2011-08-19 | FDAX | Futures | 5917.4 | 5981.5 | 5712.2 | 5875.7 | 255492.0 |
| 2011-08-19 | FESX | Futures | 1397.6 | 1411.7 | 1355.3 | 1385.4 | 2248182.0 |
| 2011-08-19 | FEU3 | Futures | 98.124 | 98.134 | 98.119 | 98.119 | 4.0 |
| 2011-08-19 | FGBL | Futures | 109.0 | 109.24 | 108.31 | 108.55 | 868797.0 |
| 2011-08-19 | FGBM | Futures | 110.42 | 110.46 | 109.75 | 109.97 | 552525.0 |
| 2011-08-19 | FGBS | Futures | 109.128 | 109.158 | 108.895 | 108.954 | 656419.0 |
| 2011-08-19 | FGBX | Futures | 107.16 | 108.07 | 106.91 | 107.62 | 11128.0 |
| 2011-08-19 | FTDX | Futures | 606.0 | 624.7 | 592.1 | 616.7 | 785.0 |
| 2011-08-19 | FTI | Futures | 225.69 | 227.56 | 219.2 | 223.81 | 64368.0 |
| 2011-08-19 | FTUK | Futures | 3563.9 | 3601.0 | 3471.9 | 3552.6 | 206290.0 |
| 2011-08-19 | FVSA | Futures | 14165.36 | 15717.72 | 14165.36 | 15174.4 | 3548.0 |
| 2011-08-19 | FXXP | Futures | 152.0 | 153.0 | 147.9 | 151.1 | 1704.0 |
| 2011-08-19 | G | Futures | 90.97 | 91.27 | 90.24 | 90.48 | 120473.0 |
| 2011-08-19 | GF | Futures | 305.898 | 307.271 | 304.18 | 306.355 | 1228.0 |
| 2011-08-19 | GSCI | Futures | 996.5 | 1010.6 | 991.8 | 1005.98 | 44.0 |
| 2011-08-19 | HE | Futures | 105.954 | 108.336 | 105.222 | 107.939 | 13475.0 |
| 2011-08-19 | HG | Futures | 5.2429 | 5.3355 | 5.2204 | 5.2964 | 9101.0 |
| 2011-08-19 | HO | Futures | 2.3133 | 2.3763 | 2.2969 | 2.3562 | 10301.0 |
| 2011-08-19 | HRC | Futures | 2868.4 | 2868.4 | 2868.4 | 2868.4 | 0.0 |
| 2011-08-19 | J1 | Futures | 0.0164266 | 0.0165573 | 0.0163361 | 0.0164354 | 117883.0 |
| 2011-08-19 | J7 | Futures | 0.016314 | 0.016443 | 0.016229 | 0.016326 | 718.0 |
| 2011-08-19 | JB | Futures | 124.32 | 124.49 | 124.18 | 124.3 | 1891.0 |
| 2011-08-19 | KC | Futures | 621.48 | 630.71 | 619.0 | 629.64 | 4707.0 |
> showing 50 of 97 rows — these rows as CSV