PREVIEW / futures_daily / 2011-10-24
file: by_date/futures_daily/2011/2011-10-24.parquet size: 9 KB rows: 95
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-10-24 | ES | Futures | 1227.59 | 1250.3 | 1224.6 | 1244.81 | 2006311.0 |
| 2011-10-24 | NQ | Futures | 2655.88 | 2723.23 | 2648.46 | 2710.67 | 241760.0 |
| 2011-10-24 | YM | Futures | 11256.0 | 11414.6 | 11227.2 | 11359.8 | 102758.0 |
| 2011-10-24 | CL | Futures | 163.31 | 172.37 | 163.21 | 171.22 | 484139.0 |
| 2011-10-24 | GC | Futures | 2218.3 | 2245.7 | 2209.7 | 2230.9 | 110137.0 |
| 2011-10-24 | ZN | Futures | 110.450198 | 110.584273 | 110.074791 | 110.128421 | 736393.0 |
| 2011-10-24 | A6 | Futures | 0.90233 | 0.9172 | 0.89961 | 0.91597 | 115644.0 |
| 2011-10-24 | AD | Futures | 0.98985 | 0.99705 | 0.98925 | 0.99425 | 67976.0 |
| 2011-10-24 | B | Futures | 95.58 | 97.57 | 95.58 | 97.44 | 182869.0 |
| 2011-10-24 | B6 | Futures | 1.6629 | 1.6697 | 1.6584 | 1.6689 | 84629.0 |
| 2011-10-24 | BFX | Futures | 2594.8 | 2599.1 | 2588.0 | 2599.1 | 50.0 |
| 2011-10-24 | BR | Futures | 0.25575 | 0.25575 | 0.25575 | 0.25575 | 162.0 |
| 2011-10-24 | BZ | Futures | 101.89 | 103.06 | 101.73 | 102.98 | 1467.0 |
| 2011-10-24 | C | Futures | 1754.0 | 1773.0 | 1741.0 | 1766.0 | 5589.0 |
| 2011-10-24 | CC | Futures | 2012.0 | 2064.0 | 2006.0 | 2060.0 | 11680.0 |
| 2011-10-24 | CSC | Futures | 4.051 | 4.093 | 4.051 | 4.093 | 9.0 |
| 2011-10-24 | CT | Futures | 125.18 | 126.85 | 125.0 | 126.27 | 7886.0 |
| 2011-10-24 | DC | Futures | 28.61 | 29.1 | 28.6 | 29.03 | 172.0 |
| 2011-10-24 | DX | Futures | 75.199 | 75.371 | 74.802 | 74.868 | 31196.0 |
| 2011-10-24 | E1 | Futures | 1.486 | 1.49388 | 1.47931 | 1.49217 | 19736.0 |
| 2011-10-24 | E6 | Futures | 1.65668 | 1.6672 | 1.65118 | 1.66612 | 279707.0 |
| 2011-10-24 | E7 | Futures | 1.6418 | 1.6531 | 1.6372 | 1.6519 | 4499.0 |
| 2011-10-24 | ED | Futures | 94.9555 | 94.9698 | 94.9555 | 94.965 | 78905.0 |
| 2011-10-24 | ER | Futures | 97.169 | 97.213 | 97.164 | 97.189 | 98295.0 |
| 2011-10-24 | EW | Futures | 861.0 | 888.8 | 860.7 | 883.3 | 23702.0 |
| 2011-10-24 | FBTP | Futures | 61.39 | 61.39 | 61.02 | 61.07 | 3726.0 |
| 2011-10-24 | FBTS | Futures | 81.655 | 81.703 | 81.606 | 81.687 | 345.0 |
| 2011-10-24 | FCE | Futures | 2288.3 | 2313.8 | 2261.7 | 2309.5 | 80535.0 |
| 2011-10-24 | FDAX | Futures | 6556.2 | 6599.6 | 6454.1 | 6586.6 | 142762.0 |
| 2011-10-24 | FESX | Futures | 1563.0 | 1573.7 | 1539.1 | 1571.7 | 1012394.0 |
| 2011-10-24 | FGBL | Futures | 108.77 | 109.65 | 108.76 | 109.04 | 682640.0 |
| 2011-10-24 | FGBM | Futures | 109.97 | 110.47 | 109.93 | 110.15 | 356784.0 |
| 2011-10-24 | FGBS | Futures | 108.761 | 108.94 | 108.746 | 108.86 | 324639.0 |
| 2011-10-24 | FGBX | Futures | 110.02 | 111.1 | 109.41 | 109.91 | 6409.0 |
| 2011-10-24 | FTDX | Futures | 636.6 | 653.2 | 636.6 | 651.8 | 236.0 |
| 2011-10-24 | FTI | Futures | 253.67 | 254.62 | 250.28 | 254.33 | 32071.0 |
| 2011-10-24 | FTUK | Futures | 3924.3 | 3973.1 | 3911.4 | 3965.2 | 89114.0 |
| 2011-10-24 | FVSA | Futures | 15418.05 | 15605.57 | 14980.51 | 14980.51 | 2657.0 |
| 2011-10-24 | FXXP | Futures | 167.2 | 168.5 | 166.2 | 168.3 | 7560.0 |
| 2011-10-24 | G | Futures | 90.34 | 90.61 | 90.13 | 90.25 | 89425.0 |
| 2011-10-24 | GF | Futures | 315.58 | 316.908 | 314.75 | 316.023 | 1231.0 |
| 2011-10-24 | GSCI | Futures | 995.99 | 1014.79 | 995.52 | 1014.79 | 159.0 |
| 2011-10-24 | HE | Futures | 115.074 | 115.428 | 113.693 | 114.175 | 14316.0 |
| 2011-10-24 | HG | Futures | 4.2947 | 4.5918 | 4.2649 | 4.564 | 56766.0 |
| 2011-10-24 | HO | Futures | 2.4225 | 2.4571 | 2.4218 | 2.4532 | 47617.0 |
| 2011-10-24 | HRC | Futures | 2685.6 | 2685.6 | 2685.6 | 2685.6 | 0.0 |
| 2011-10-24 | J1 | Futures | 0.0164919 | 0.0165471 | 0.0164378 | 0.0165321 | 65598.0 |
| 2011-10-24 | J7 | Futures | 0.016396 | 0.016447 | 0.016339 | 0.016432 | 369.0 |
| 2011-10-24 | JB | Futures | 124.29 | 124.3 | 124.12 | 124.17 | 976.0 |
| 2011-10-24 | KC | Futures | 578.39 | 592.65 | 572.85 | 591.0 | 11783.0 |
> showing 50 of 95 rows — these rows as CSV