PREVIEW / futures_daily / 2011-11-03
file: by_date/futures_daily/2011/2011-11-03.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-03 | ES | Futures | 1232.09 | 1257.54 | 1211.37 | 1253.55 | 2822923.0 |
| 2011-11-03 | NQ | Futures | 2644.75 | 2701.26 | 2601.38 | 2694.98 | 322415.0 |
| 2011-11-03 | YM | Futures | 11303.1 | 11536.6 | 11136.0 | 11504.9 | 137718.0 |
| 2011-11-03 | CL | Futures | 174.45 | 177.49 | 170.47 | 176.48 | 299987.0 |
| 2011-11-03 | GC | Futures | 2347.8 | 2389.1 | 2327.7 | 2383.2 | 162545.0 |
| 2011-11-03 | ZN | Futures | 111.898198 | 112.327235 | 111.388717 | 111.589828 | 1177711.0 |
| 2011-11-03 | A6 | Futures | 0.90409 | 0.91403 | 0.89266 | 0.9113 | 196381.0 |
| 2011-11-03 | AD | Futures | 0.98685 | 0.99405 | 0.97824 | 0.99165 | 93262.0 |
| 2011-11-03 | B | Futures | 95.61 | 97.36 | 94.4 | 97.06 | 131600.0 |
| 2011-11-03 | B6 | Futures | 1.6629 | 1.6757 | 1.656 | 1.6731 | 137801.0 |
| 2011-11-03 | BFX | Futures | 2448.2 | 2561.9 | 2448.2 | 2561.9 | 23.0 |
| 2011-11-03 | BR | Futures | 0.2581 | 0.25914 | 0.2581 | 0.25815 | 125.0 |
| 2011-11-03 | BZ | Futures | 102.49 | 102.49 | 102.49 | 102.49 | 647.0 |
| 2011-11-03 | C | Futures | 1749.0 | 1787.0 | 1741.0 | 1780.0 | 9266.0 |
| 2011-11-03 | CB | Futures | 92.327 | 92.601 | 92.327 | 92.601 | 3.0 |
| 2011-11-03 | CC | Futures | 2065.0 | 2145.0 | 2065.0 | 2133.0 | 18497.0 |
| 2011-11-03 | CT | Futures | 127.13 | 128.2 | 125.44 | 126.5 | 10694.0 |
| 2011-11-03 | DC | Futures | 29.82 | 31.09 | 29.82 | 30.89 | 1029.0 |
| 2011-11-03 | DX | Futures | 76.088 | 76.26 | 75.347 | 75.451 | 42717.0 |
| 2011-11-03 | E1 | Futures | 1.48548 | 1.49899 | 1.47616 | 1.49571 | 24638.0 |
| 2011-11-03 | E6 | Futures | 1.64234 | 1.65585 | 1.6317 | 1.65298 | 446224.0 |
| 2011-11-03 | E7 | Futures | 1.6289 | 1.6425 | 1.6178 | 1.6389 | 7264.0 |
| 2011-11-03 | ED | Futures | 94.9746 | 94.9889 | 94.9555 | 94.9698 | 199356.0 |
| 2011-11-03 | ER | Futures | 97.287 | 97.485 | 97.268 | 97.371 | 423069.0 |
| 2011-11-03 | EW | Futures | 877.1 | 902.0 | 862.2 | 896.2 | 38493.0 |
| 2011-11-03 | FBTP | Futures | 59.96 | 60.3 | 59.01 | 59.99 | 9568.0 |
| 2011-11-03 | FBTS | Futures | 80.146 | 80.724 | 79.849 | 80.394 | 2624.0 |
| 2011-11-03 | FCE | Futures | 2186.4 | 2312.4 | 2159.8 | 2289.4 | 160691.0 |
| 2011-11-03 | FDAX | Futures | 6308.6 | 6734.2 | 6291.8 | 6686.5 | 252557.0 |
| 2011-11-03 | FESX | Futures | 1479.3 | 1573.7 | 1471.3 | 1561.1 | 2053551.0 |
| 2011-11-03 | FEU3 | Futures | 97.846 | 97.93 | 97.846 | 97.93 | 1.0 |
| 2011-11-03 | FGBL | Futures | 111.73 | 111.94 | 110.39 | 110.74 | 1005227.0 |
| 2011-11-03 | FGBM | Futures | 111.89 | 111.99 | 111.36 | 111.57 | 542426.0 |
| 2011-11-03 | FGBS | Futures | 109.322 | 109.427 | 109.188 | 109.327 | 639114.0 |
| 2011-11-03 | FGBX | Futures | 113.53 | 113.94 | 110.86 | 111.65 | 10354.0 |
| 2011-11-03 | FTDX | Futures | 616.4 | 647.7 | 616.4 | 644.0 | 373.0 |
| 2011-11-03 | FTI | Futures | 241.97 | 253.42 | 241.26 | 251.65 | 60047.0 |
| 2011-11-03 | FTUK | Futures | 3899.6 | 4007.2 | 3855.8 | 3979.9 | 140568.0 |
| 2011-11-03 | FVSA | Futures | 16980.69 | 17293.22 | 15938.93 | 15959.77 | 4493.0 |
| 2011-11-03 | FXXP | Futures | 163.5 | 169.2 | 163.5 | 168.8 | 2894.0 |
| 2011-11-03 | G | Futures | 92.38 | 92.39 | 91.14 | 91.48 | 127367.0 |
| 2011-11-03 | GF | Futures | 314.75 | 315.525 | 313.81 | 314.363 | 1387.0 |
| 2011-11-03 | GSCI | Futures | 1013.38 | 1023.25 | 1006.88 | 1020.12 | 96.0 |
| 2011-11-03 | HE | Futures | 111.54 | 112.214 | 110.254 | 111.315 | 17150.0 |
| 2011-11-03 | HG | Futures | 4.742 | 4.7757 | 4.5971 | 4.7486 | 50409.0 |
| 2011-11-03 | HO | Futures | 2.4208 | 2.4528 | 2.3896 | 2.4403 | 57869.0 |
| 2011-11-03 | HRC | Futures | 2685.6 | 2685.6 | 2685.6 | 2685.6 | 0.0 |
| 2011-11-03 | J1 | Futures | 0.0161036 | 0.0161438 | 0.0160873 | 0.0161061 | 44484.0 |
| 2011-11-03 | J7 | Futures | 0.015997 | 0.016043 | 0.01599 | 0.016008 | 124.0 |
| 2011-11-03 | JB | Futures | 124.45 | 124.7 | 124.34 | 124.49 | 1234.0 |
> showing 50 of 97 rows — these rows as CSV