PREVIEW / futures_daily / 2011-11-28
file: by_date/futures_daily/2011/2011-11-28.parquet size: 9 KB rows: 98
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-28 | ES | Futures | 1169.95 | 1194.15 | 1167.2 | 1188.91 | 2362657.0 |
| 2011-11-28 | NQ | Futures | 2491.8 | 2543.16 | 2486.38 | 2535.17 | 288245.0 |
| 2011-11-28 | YM | Futures | 10909.2 | 11087.9 | 10866.0 | 11045.7 | 127043.0 |
| 2011-11-28 | CL | Futures | 182.78 | 188.86 | 182.09 | 184.11 | 311735.0 |
| 2011-11-28 | GC | Futures | 2278.1 | 2328.9 | 2277.3 | 2314.8 | 145559.0 |
| 2011-11-28 | ZN | Futures | 111.777532 | 112.206568 | 111.361902 | 112.166346 | 1853668.0 |
| 2011-11-28 | A6 | Futures | 0.85994 | 0.87516 | 0.85968 | 0.86733 | 117295.0 |
| 2011-11-28 | AD | Futures | 0.95713 | 0.97044 | 0.95713 | 0.96483 | 66221.0 |
| 2011-11-28 | B | Futures | 94.45 | 96.78 | 94.45 | 96.27 | 126858.0 |
| 2011-11-28 | B6 | Futures | 1.6166 | 1.6273 | 1.6131 | 1.6167 | 79246.0 |
| 2011-11-28 | BFX | Futures | 2370.1 | 2391.8 | 2360.8 | 2391.8 | 23.0 |
| 2011-11-28 | BR | Futures | 0.24434 | 0.24795 | 0.24434 | 0.24696 | 1481.0 |
| 2011-11-28 | BZ | Futures | 102.16 | 102.16 | 102.16 | 102.16 | 583.0 |
| 2011-11-28 | C | Futures | 1606.0 | 1610.0 | 1572.0 | 1575.0 | 1917.0 |
| 2011-11-28 | CB | Futures | 90.288 | 90.423 | 89.615 | 90.423 | 10.0 |
| 2011-11-28 | CC | Futures | 1849.0 | 1883.0 | 1823.0 | 1833.0 | 7071.0 |
| 2011-11-28 | CSC | Futures | 3.978 | 3.995 | 3.978 | 3.978 | 6.0 |
| 2011-11-28 | CT | Futures | 117.33 | 119.53 | 117.01 | 117.65 | 6792.0 |
| 2011-11-28 | DC | Futures | 28.23 | 28.36 | 28.23 | 28.23 | 33.0 |
| 2011-11-28 | DX | Futures | 77.997 | 78.125 | 77.506 | 77.984 | 24456.0 |
| 2011-11-28 | E1 | Futures | 1.41305 | 1.43089 | 1.41029 | 1.42131 | 20505.0 |
| 2011-11-28 | E6 | Futures | 1.59142 | 1.6017 | 1.5864 | 1.58999 | 246194.0 |
| 2011-11-28 | E7 | Futures | 1.5764 | 1.588 | 1.5727 | 1.5764 | 4850.0 |
| 2011-11-28 | ED | Futures | 94.8719 | 94.8886 | 94.8671 | 94.8839 | 139423.0 |
| 2011-11-28 | ER | Futures | 97.199 | 97.233 | 97.184 | 97.213 | 102311.0 |
| 2011-11-28 | EW | Futures | 822.0 | 848.3 | 822.0 | 844.2 | 29832.0 |
| 2011-11-28 | FBTP | Futures | 57.13 | 57.17 | 55.46 | 55.56 | 6199.0 |
| 2011-11-28 | FBTS | Futures | 77.055 | 77.376 | 76.734 | 76.975 | 1212.0 |
| 2011-11-28 | FCE | Futures | 2066.7 | 2150.6 | 2062.1 | 2149.6 | 97742.0 |
| 2011-11-28 | FDAX | Futures | 6075.7 | 6251.6 | 6044.7 | 6231.0 | 168712.0 |
| 2011-11-28 | FESX | Futures | 1426.1 | 1478.6 | 1420.1 | 1474.6 | 1464617.0 |
| 2011-11-28 | FEU3 | Futures | 97.747 | 97.771 | 97.747 | 97.771 | 300.0 |
| 2011-11-28 | FGBL | Futures | 108.44 | 108.84 | 107.9 | 108.32 | 642884.0 |
| 2011-11-28 | FGBM | Futures | 110.6 | 110.92 | 110.37 | 110.55 | 431483.0 |
| 2011-11-28 | FGBS | Futures | 109.233 | 109.352 | 109.228 | 109.302 | 346690.0 |
| 2011-11-28 | FGBX | Futures | 109.16 | 109.45 | 107.53 | 108.35 | 6535.0 |
| 2011-11-28 | FTDX | Futures | 603.1 | 621.0 | 603.1 | 619.6 | 134.0 |
| 2011-11-28 | FTI | Futures | 233.54 | 239.68 | 232.45 | 239.59 | 36322.0 |
| 2011-11-28 | FTUK | Futures | 3735.2 | 3823.1 | 3727.3 | 3812.7 | 107134.0 |
| 2011-11-28 | FVSA | Futures | 16880.31 | 16901.74 | 16323.35 | 16323.35 | 2394.0 |
| 2011-11-28 | FXXP | Futures | 156.3 | 160.2 | 156.2 | 160.0 | 2055.0 |
| 2011-11-28 | G | Futures | 92.22 | 92.54 | 91.58 | 92.41 | 143898.0 |
| 2011-11-28 | GF | Futures | 312.772 | 313.849 | 311.587 | 311.749 | 3214.0 |
| 2011-11-28 | GSCI | Futures | 1007.89 | 1009.05 | 995.87 | 997.35 | 79.0 |
| 2011-11-28 | HE | Futures | 113.417 | 113.663 | 111.599 | 111.66 | 15688.0 |
| 2011-11-28 | HG | Futures | 4.3599 | 4.505 | 4.3599 | 4.447 | 25761.0 |
| 2011-11-28 | HO | Futures | 2.3973 | 2.4312 | 2.3923 | 2.4088 | 11120.0 |
| 2011-11-28 | HRC | Futures | 2664.5 | 2664.5 | 2664.5 | 2664.5 | 0.0 |
| 2011-11-28 | J1 | Futures | 0.0162192 | 0.0162268 | 0.0160634 | 0.0161162 | 74477.0 |
| 2011-11-28 | J7 | Futures | 0.016127 | 0.016127 | 0.015967 | 0.016018 | 355.0 |
> showing 50 of 98 rows — these rows as CSV