PREVIEW / futures_daily / 2011-09-14
file: by_date/futures_daily/2011/2011-09-14.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-09-14 | ES | Futures | 1163.46 | 1194.15 | 1145.99 | 1180.18 | 3552069.0 |
| 2011-09-14 | NQ | Futures | 2528.9 | 2594.24 | 2495.22 | 2564.0 | 401860.0 |
| 2011-09-14 | YM | Futures | 10594.2 | 10868.9 | 10440.4 | 10734.4 | 162733.0 |
| 2011-09-14 | CL | Futures | 169.69 | 170.29 | 166.48 | 167.84 | 151690.0 |
| 2011-09-14 | GC | Futures | 2480.6 | 2495.4 | 2445.8 | 2466.1 | 172648.0 |
| 2011-09-14 | ZN | Futures | 111.656865 | 111.99205 | 111.482569 | 111.563013 | 1363210.0 |
| 2011-09-14 | A6 | Futures | 0.89653 | 0.90198 | 0.88527 | 0.8916 | 51623.0 |
| 2011-09-14 | AD | Futures | 1.01296 | 1.01416 | 1.00456 | 1.00876 | 40237.0 |
| 2011-09-14 | B | Futures | 93.99 | 94.49 | 92.73 | 94.09 | 205387.0 |
| 2011-09-14 | B6 | Futures | 1.6451 | 1.6494 | 1.6378 | 1.6443 | 83073.0 |
| 2011-09-14 | BFX | Futures | 2474.2 | 2527.3 | 2474.2 | 2522.5 | 660.0 |
| 2011-09-14 | BR | Futures | 0.25995 | 0.25995 | 0.257 | 0.25837 | 199.0 |
| 2011-09-14 | BZ | Futures | 97.15 | 97.56 | 96.71 | 97.46 | 1466.0 |
| 2011-09-14 | C | Futures | 1956.0 | 1971.0 | 1929.0 | 1930.0 | 11396.0 |
| 2011-09-14 | CB | Futures | 96.025 | 96.025 | 96.025 | 96.025 | 2.0 |
| 2011-09-14 | CC | Futures | 2246.0 | 2265.0 | 2201.0 | 2203.0 | 13194.0 |
| 2011-09-14 | CSC | Futures | 4.3 | 4.3 | 4.3 | 4.3 | 1.0 |
| 2011-09-14 | CT | Futures | 144.52 | 147.29 | 144.31 | 147.15 | 56.0 |
| 2011-09-14 | DC | Futures | 30.21 | 30.26 | 29.88 | 30.06 | 105.0 |
| 2011-09-14 | DX | Futures | 76.176 | 76.633 | 75.798 | 75.966 | 37056.0 |
| 2011-09-14 | E1 | Futures | 1.49558 | 1.50752 | 1.4864 | 1.50201 | 11802.0 |
| 2011-09-14 | E6 | Futures | 1.63385 | 1.6464 | 1.62381 | 1.64234 | 165790.0 |
| 2011-09-14 | E7 | Futures | 1.6199 | 1.6321 | 1.6099 | 1.6283 | 3527.0 |
| 2011-09-14 | ED | Futures | 94.9268 | 94.9364 | 94.8982 | 94.9268 | 256531.0 |
| 2011-09-14 | ER | Futures | 97.371 | 97.396 | 97.273 | 97.297 | 279673.0 |
| 2011-09-14 | EW | Futures | 837.8 | 865.6 | 824.3 | 853.7 | 54439.0 |
| 2011-09-14 | FBTP | Futures | 61.4 | 62.22 | 61.23 | 61.98 | 8434.0 |
| 2011-09-14 | FBTS | Futures | 80.844 | 81.366 | 80.78 | 81.309 | 967.0 |
| 2011-09-14 | FCE | Futures | 2044.9 | 2138.8 | 2019.2 | 2098.8 | 84616.0 |
| 2011-09-14 | FDAX | Futures | 5450.5 | 5823.9 | 5418.4 | 5704.8 | 364046.0 |
| 2011-09-14 | FESX | Futures | 1331.7 | 1402.2 | 1315.7 | 1374.2 | 1769151.0 |
| 2011-09-14 | FEU3 | Futures | 97.9 | 97.9 | 97.856 | 97.856 | 52.0 |
| 2011-09-14 | FGBL | Futures | 111.64 | 111.86 | 110.46 | 110.74 | 1149889.0 |
| 2011-09-14 | FGBM | Futures | 111.32 | 111.41 | 110.54 | 110.78 | 573341.0 |
| 2011-09-14 | FGBS | Futures | 109.168 | 109.198 | 108.925 | 109.034 | 676711.0 |
| 2011-09-14 | FGBX | Futures | 113.31 | 113.86 | 110.99 | 111.45 | 5587.0 |
| 2011-09-14 | FTDX | Futures | 628.4 | 645.8 | 628.4 | 645.8 | 2323.0 |
| 2011-09-14 | FTI | Futures | 222.74 | 231.01 | 220.83 | 227.31 | 33670.0 |
| 2011-09-14 | FTUK | Futures | 3716.9 | 3807.7 | 3652.0 | 3744.5 | 183185.0 |
| 2011-09-14 | FVSA | Futures | 18384.91 | 18469.44 | 17539.63 | 18046.8 | 1822.0 |
| 2011-09-14 | FXXP | Futures | 151.9 | 155.8 | 151.9 | 155.8 | 16687.0 |
| 2011-09-14 | G | Futures | 92.61 | 92.69 | 91.93 | 92.13 | 129088.0 |
| 2011-09-14 | GF | Futures | 309.963 | 315.114 | 309.963 | 314.605 | 4675.0 |
| 2011-09-14 | GSCI | Futures | 1039.21 | 1039.21 | 1031.06 | 1039.21 | 1651.0 |
| 2011-09-14 | HE | Futures | 106.718 | 108.642 | 106.351 | 108.031 | 22686.0 |
| 2011-09-14 | HG | Futures | 5.2561 | 5.3077 | 5.141 | 5.1582 | 49048.0 |
| 2011-09-14 | HO | Futures | 2.3775 | 2.3825 | 2.3472 | 2.3788 | 17617.0 |
| 2011-09-14 | HRC | Futures | 2910.3 | 2910.3 | 2910.3 | 2910.3 | 0.0 |
| 2011-09-14 | J1 | Futures | 0.016365 | 0.0164265 | 0.0163273 | 0.016414 | 65563.0 |
| 2011-09-14 | J7 | Futures | 0.016278 | 0.016327 | 0.016229 | 0.016314 | 159.0 |
> showing 50 of 97 rows — these rows as CSV