PREVIEW / futures_daily / 2011-08-25
file: by_date/futures_daily/2011/2011-08-25.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-08-25 | ES | Futures | 1163.46 | 1180.34 | 1145.08 | 1149.55 | 3198280.0 |
| 2011-08-25 | NQ | Futures | 2435.52 | 2450.61 | 2392.53 | 2403.92 | 308466.0 |
| 2011-08-25 | YM | Futures | 10652.8 | 10758.7 | 10477.9 | 10523.3 | 148025.0 |
| 2011-08-25 | CL | Futures | 162.24 | 164.88 | 158.12 | 162.48 | 357816.0 |
| 2011-08-25 | GC | Futures | 2366.8 | 2399.9 | 2302.6 | 2380.6 | 384694.0 |
| 2011-08-25 | ZN | Futures | 110.165171 | 110.817115 | 110.098647 | 110.684065 | 1951338.0 |
| 2011-08-25 | A6 | Futures | 0.90761 | 0.91187 | 0.90404 | 0.90465 | 114502.0 |
| 2011-08-25 | AD | Futures | 1.00984 | 1.01872 | 1.00874 | 1.00964 | 94840.0 |
| 2011-08-25 | B | Futures | 94.22 | 95.23 | 93.11 | 94.46 | 87334.0 |
| 2011-08-25 | B6 | Futures | 1.7021 | 1.7055 | 1.6895 | 1.6936 | 90536.0 |
| 2011-08-25 | BFX | Futures | 2686.3 | 2686.3 | 2628.2 | 2628.2 | 10.0 |
| 2011-08-25 | BR | Futures | 0.27633 | 0.27633 | 0.27633 | 0.27633 | 160.0 |
| 2011-08-25 | BZ | Futures | 97.32 | 98.4 | 96.49 | 97.85 | 3251.0 |
| 2011-08-25 | C | Futures | 2075.0 | 2087.0 | 2038.0 | 2047.0 | 1408.0 |
| 2011-08-25 | CB | Futures | 101.368 | 101.368 | 101.368 | 101.368 | 1.0 |
| 2011-08-25 | CC | Futures | 2415.0 | 2426.0 | 2358.0 | 2374.0 | 9989.0 |
| 2011-08-25 | CSC | Futures | 4.312 | 4.312 | 4.312 | 4.312 | 3.0 |
| 2011-08-25 | CT | Futures | 136.38 | 136.38 | 131.05 | 133.13 | 17.0 |
| 2011-08-25 | DC | Futures | 29.54 | 30.26 | 29.45 | 30.2 | 226.0 |
| 2011-08-25 | DX | Futures | 73.4 | 73.786 | 73.177 | 73.644 | 22377.0 |
| 2011-08-25 | E1 | Futures | 1.64502 | 1.65509 | 1.63756 | 1.64802 | 24708.0 |
| 2011-08-25 | E6 | Futures | 1.71086 | 1.71882 | 1.701 | 1.70599 | 321648.0 |
| 2011-08-25 | E7 | Futures | 1.6984 | 1.7061 | 1.6883 | 1.6935 | 4351.0 |
| 2011-08-25 | ED | Futures | 94.9287 | 94.943 | 94.9191 | 94.9287 | 243440.0 |
| 2011-08-25 | ER | Futures | 97.499 | 97.524 | 97.484 | 97.504 | 86839.0 |
| 2011-08-25 | EW | Futures | 821.7 | 834.3 | 802.8 | 806.8 | 29094.0 |
| 2011-08-25 | FBTP | Futures | 64.59 | 64.59 | 64.23 | 64.26 | 8383.0 |
| 2011-08-25 | FCE | Futures | 2202.2 | 2235.9 | 2163.6 | 2184.6 | 99722.0 |
| 2011-08-25 | FDAX | Futures | 6079.3 | 6175.4 | 5790.2 | 5971.4 | 242263.0 |
| 2011-08-25 | FESX | Futures | 1436.8 | 1457.9 | 1402.8 | 1419.4 | 1604401.0 |
| 2011-08-25 | FGBL | Futures | 107.86 | 108.31 | 107.4 | 108.17 | 889223.0 |
| 2011-08-25 | FGBM | Futures | 109.57 | 109.98 | 109.23 | 109.9 | 495273.0 |
| 2011-08-25 | FGBS | Futures | 108.795 | 108.959 | 108.671 | 108.92 | 502073.0 |
| 2011-08-25 | FGBX | Futures | 106.25 | 106.63 | 105.21 | 106.23 | 4830.0 |
| 2011-08-25 | FTDX | Futures | 648.4 | 654.2 | 630.1 | 637.2 | 403.0 |
| 2011-08-25 | FTI | Futures | 230.17 | 232.38 | 225.24 | 227.2 | 45960.0 |
| 2011-08-25 | FTUK | Futures | 3689.5 | 3701.8 | 3587.6 | 3619.3 | 146251.0 |
| 2011-08-25 | FVSA | Futures | 14747.49 | 15310.23 | 14592.26 | 15174.4 | 3158.0 |
| 2011-08-25 | FXXP | Futures | 156.7 | 156.8 | 152.7 | 153.3 | 2047.0 |
| 2011-08-25 | G | Futures | 89.83 | 90.53 | 89.65 | 90.38 | 174451.0 |
| 2011-08-25 | GF | Futures | 300.689 | 302.349 | 298.284 | 301.375 | 1620.0 |
| 2011-08-25 | GSCI | Futures | 1014.67 | 1027.04 | 1008.17 | 1021.64 | 179.0 |
| 2011-08-25 | HE | Futures | 106.474 | 107.359 | 106.077 | 106.535 | 19748.0 |
| 2011-08-25 | HG | Futures | 5.3342 | 5.4533 | 5.3156 | 5.4228 | 16808.0 |
| 2011-08-25 | HO | Futures | 2.4006 | 2.4251 | 2.3764 | 2.4136 | 28926.0 |
| 2011-08-25 | HRC | Futures | 2868.4 | 2868.4 | 2868.4 | 2868.4 | 0.0 |
| 2011-08-25 | J1 | Futures | 0.0163361 | 0.0163587 | 0.0161777 | 0.0162092 | 113200.0 |
| 2011-08-25 | J7 | Futures | 0.016228 | 0.016252 | 0.01607 | 0.016101 | 509.0 |
| 2011-08-25 | JB | Futures | 124.03 | 124.11 | 123.9 | 123.92 | 2228.0 |
| 2011-08-25 | KC | Futures | 643.67 | 654.86 | 643.67 | 649.2 | 10223.0 |
> showing 50 of 96 rows — these rows as CSV