PREVIEW / futures_daily / 2011-11-30
file: by_date/futures_daily/2011/2011-11-30.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-11-30 | ES | Futures | 1192.9 | 1244.56 | 1180.93 | 1243.82 | 3298494.0 |
| 2011-11-30 | NQ | Futures | 2524.9 | 2621.35 | 2506.92 | 2619.64 | 296698.0 |
| 2011-11-30 | YM | Futures | 11100.4 | 11562.5 | 11000.5 | 11560.6 | 157013.0 |
| 2011-11-30 | CL | Futures | 186.49 | 190.75 | 185.45 | 188.14 | 302863.0 |
| 2011-11-30 | GC | Futures | 2325.9 | 2369.1 | 2301.1 | 2363.2 | 187239.0 |
| 2011-11-30 | ZN | Futures | 112.059087 | 112.152939 | 111.281458 | 111.68368 | 448830.0 |
| 2011-11-30 | A6 | Futures | 0.88061 | 0.90717 | 0.87252 | 0.90049 | 199709.0 |
| 2011-11-30 | AD | Futures | 0.97054 | 0.98795 | 0.96503 | 0.98064 | 118420.0 |
| 2011-11-30 | B | Futures | 97.88 | 99.22 | 97.05 | 98.01 | 138059.0 |
| 2011-11-30 | B6 | Futures | 1.6289 | 1.6469 | 1.6201 | 1.6383 | 142802.0 |
| 2011-11-30 | BFX | Futures | 2364.2 | 2473.2 | 2364.2 | 2465.9 | 65.0 |
| 2011-11-30 | BR | Futures | 0.25347 | 0.2552 | 0.25277 | 0.25373 | 46.0 |
| 2011-11-30 | BZ | Futures | 104.51 | 105.2 | 104.02 | 104.02 | 849.0 |
| 2011-11-30 | C | Futures | 1548.0 | 1551.0 | 1503.0 | 1524.0 | 5534.0 |
| 2011-11-30 | CB | Futures | 89.481 | 89.481 | 88.404 | 89.346 | 48.0 |
| 2011-11-30 | CC | Futures | 1799.0 | 1828.0 | 1751.0 | 1787.0 | 11489.0 |
| 2011-11-30 | CSC | Futures | 3.973 | 3.976 | 3.966 | 3.969 | 31.0 |
| 2011-11-30 | CT | Futures | 119.46 | 120.64 | 116.82 | 117.09 | 11105.0 |
| 2011-11-30 | DC | Futures | 28.33 | 28.46 | 28.16 | 28.41 | 132.0 |
| 2011-11-30 | DX | Futures | 77.737 | 78.061 | 76.584 | 77.056 | 30359.0 |
| 2011-11-30 | E1 | Futures | 1.42656 | 1.44795 | 1.41882 | 1.43759 | 39075.0 |
| 2011-11-30 | E6 | Futures | 1.59346 | 1.61772 | 1.58485 | 1.60589 | 441324.0 |
| 2011-11-30 | E7 | Futures | 1.5802 | 1.6039 | 1.5713 | 1.5922 | 7665.0 |
| 2011-11-30 | ED | Futures | 94.8862 | 95.0462 | 94.8862 | 94.9626 | 457303.0 |
| 2011-11-30 | ER | Futures | 97.278 | 97.425 | 97.273 | 97.351 | 269020.0 |
| 2011-11-30 | EW | Futures | 844.2 | 887.7 | 835.9 | 886.3 | 30408.0 |
| 2011-11-30 | FBTP | Futures | 55.26 | 56.55 | 54.98 | 56.42 | 14849.0 |
| 2011-11-30 | FBTS | Futures | 76.654 | 77.16 | 76.213 | 76.847 | 1958.0 |
| 2011-11-30 | FCE | Futures | 2136.7 | 2266.7 | 2125.3 | 2251.0 | 143990.0 |
| 2011-11-30 | FDAX | Futures | 6231.5 | 6660.9 | 6194.0 | 6604.5 | 261312.0 |
| 2011-11-30 | FESX | Futures | 1468.0 | 1560.4 | 1460.7 | 1546.4 | 2035122.0 |
| 2011-11-30 | FEU3 | Futures | 97.841 | 97.93 | 97.841 | 97.91 | 1607.0 |
| 2011-11-30 | FGBL | Futures | 108.33 | 108.82 | 107.9 | 108.27 | 1001653.0 |
| 2011-11-30 | FGBM | Futures | 110.67 | 111.33 | 110.52 | 111.12 | 673005.0 |
| 2011-11-30 | FGBS | Futures | 109.407 | 109.67 | 109.367 | 109.556 | 884170.0 |
| 2011-11-30 | FGBX | Futures | 108.18 | 108.7 | 106.9 | 107.56 | 7936.0 |
| 2011-11-30 | FTDX | Futures | 627.0 | 652.3 | 621.9 | 647.7 | 399.0 |
| 2011-11-30 | FTI | Futures | 238.92 | 253.62 | 238.63 | 252.07 | 52572.0 |
| 2011-11-30 | FTUK | Futures | 3814.9 | 3977.4 | 3785.8 | 3942.3 | 204250.0 |
| 2011-11-30 | FVSA | Futures | 16451.88 | 16451.88 | 15337.95 | 15552.17 | 2118.0 |
| 2011-11-30 | FXXP | Futures | 160.0 | 168.0 | 160.0 | 166.8 | 6646.0 |
| 2011-11-30 | G | Futures | 92.86 | 93.4 | 92.0 | 92.11 | 172146.0 |
| 2011-11-30 | GF | Futures | 312.772 | 316.164 | 311.425 | 314.549 | 2210.0 |
| 2011-11-30 | GSCI | Futures | 1025.88 | 1030.06 | 1018.59 | 1021.77 | 557.0 |
| 2011-11-30 | HE | Futures | 112.338 | 113.879 | 112.061 | 112.893 | 18563.0 |
| 2011-11-30 | HG | Futures | 4.4701 | 4.7945 | 4.3593 | 4.7161 | 64580.0 |
| 2011-11-30 | HO | Futures | 2.444 | 2.482 | 2.4362 | 2.4499 | 20099.0 |
| 2011-11-30 | HRC | Futures | 2664.5 | 2664.5 | 2664.5 | 2664.5 | 0.0 |
| 2011-11-30 | J1 | Futures | 0.0161237 | 0.0162607 | 0.016081 | 0.0162067 | 110291.0 |
| 2011-11-30 | J7 | Futures | 0.016026 | 0.016161 | 0.015982 | 0.016108 | 526.0 |
> showing 50 of 97 rows — these rows as CSV