PREVIEW / futures_daily / 2011-08-16
file: by_date/futures_daily/2011/2011-08-16.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-08-16 | ES | Futures | 1188.28 | 1193.25 | 1169.42 | 1184.06 | 2556621.0 |
| 2011-08-16 | NQ | Futures | 2510.39 | 2518.08 | 2463.7 | 2504.13 | 294934.0 |
| 2011-08-16 | YM | Futures | 10780.5 | 10824.9 | 10641.5 | 10765.3 | 142354.0 |
| 2011-08-16 | CL | Futures | 167.51 | 167.85 | 163.55 | 165.44 | 152593.0 |
| 2011-08-16 | GC | Futures | 2387.8 | 2416.8 | 2381.1 | 2410.0 | 168060.0 |
| 2011-08-16 | ZN | Futures | 110.178476 | 110.91025 | 110.151867 | 110.763895 | 1199361.0 |
| 2011-08-16 | A6 | Futures | 0.91022 | 0.9103 | 0.90126 | 0.9063 | 112288.0 |
| 2011-08-16 | AD | Futures | 1.01762 | 1.01762 | 1.01013 | 1.01453 | 78135.0 |
| 2011-08-16 | B | Futures | 93.74 | 94.01 | 92.41 | 93.35 | 174375.0 |
| 2011-08-16 | B6 | Futures | 1.7037 | 1.7137 | 1.6974 | 1.7114 | 87695.0 |
| 2011-08-16 | BFX | Futures | 2723.9 | 2723.9 | 2685.7 | 2711.8 | 1160.0 |
| 2011-08-16 | BR | Futures | 0.27862 | 0.27933 | 0.27844 | 0.27844 | 85.0 |
| 2011-08-16 | BZ | Futures | 95.83 | 97.06 | 95.64 | 96.42 | 964.0 |
| 2011-08-16 | C | Futures | 1981.0 | 2042.0 | 1981.0 | 2035.0 | 2855.0 |
| 2011-08-16 | CB | Futures | 112.326 | 112.326 | 112.326 | 112.326 | 2.0 |
| 2011-08-16 | CC | Futures | 2301.0 | 2355.0 | 2284.0 | 2344.0 | 14310.0 |
| 2011-08-16 | CT | Futures | 135.61 | 135.77 | 134.43 | 135.77 | 31.0 |
| 2011-08-16 | DC | Futures | 32.73 | 32.81 | 32.36 | 32.63 | 437.0 |
| 2011-08-16 | DX | Futures | 73.286 | 73.548 | 73.132 | 73.378 | 18942.0 |
| 2011-08-16 | E1 | Futures | 1.67235 | 1.68504 | 1.64488 | 1.64985 | 36658.0 |
| 2011-08-16 | E6 | Futures | 1.71514 | 1.71822 | 1.70409 | 1.70896 | 317023.0 |
| 2011-08-16 | E7 | Futures | 1.703 | 1.7056 | 1.6916 | 1.6965 | 4205.0 |
| 2011-08-16 | ED | Futures | 94.912 | 94.943 | 94.9025 | 94.9287 | 263383.0 |
| 2011-08-16 | ER | Futures | 97.514 | 97.549 | 97.514 | 97.534 | 134908.0 |
| 2011-08-16 | EW | Futures | 853.2 | 855.0 | 836.5 | 848.2 | 31118.0 |
| 2011-08-16 | FBTP | Futures | 64.04 | 64.56 | 63.93 | 64.29 | 6673.0 |
| 2011-08-16 | FCE | Futures | 2275.9 | 2283.9 | 2215.9 | 2263.2 | 66408.0 |
| 2011-08-16 | FDAX | Futures | 6451.1 | 6464.5 | 6252.4 | 6410.0 | 176666.0 |
| 2011-08-16 | FESX | Futures | 1493.2 | 1508.0 | 1454.7 | 1488.7 | 1538093.0 |
| 2011-08-16 | FEU3 | Futures | 98.059 | 98.074 | 98.059 | 98.074 | 2.0 |
| 2011-08-16 | FGBL | Futures | 106.59 | 107.33 | 106.31 | 106.78 | 655883.0 |
| 2011-08-16 | FGBM | Futures | 109.08 | 109.58 | 108.84 | 109.21 | 446853.0 |
| 2011-08-16 | FGBS | Futures | 108.765 | 108.89 | 108.606 | 108.755 | 465920.0 |
| 2011-08-16 | FGBX | Futures | 103.37 | 104.31 | 103.07 | 103.29 | 5804.0 |
| 2011-08-16 | FTDX | Futures | 669.8 | 669.8 | 649.7 | 659.6 | 628.0 |
| 2011-08-16 | FTI | Futures | 239.93 | 239.93 | 234.7 | 237.85 | 9149.0 |
| 2011-08-16 | FTUK | Futures | 3789.7 | 3795.3 | 3704.0 | 3773.4 | 113777.0 |
| 2011-08-16 | FVSA | Futures | 13156.32 | 13292.15 | 12787.63 | 12904.06 | 1346.0 |
| 2011-08-16 | FXXP | Futures | 159.7 | 160.7 | 158.2 | 160.7 | 2898.0 |
| 2011-08-16 | G | Futures | 89.7 | 89.79 | 89.14 | 89.44 | 93129.0 |
| 2011-08-16 | GF | Futures | 314.026 | 315.514 | 313.511 | 314.541 | 919.0 |
| 2011-08-16 | GSCI | Futures | 1013.42 | 1025.01 | 1008.87 | 1016.55 | 462.0 |
| 2011-08-16 | HE | Futures | 110.199 | 110.779 | 108.458 | 109.191 | 14276.0 |
| 2011-08-16 | HG | Futures | 5.3248 | 5.3479 | 5.2237 | 5.2799 | 27826.0 |
| 2011-08-16 | HO | Futures | 2.3823 | 2.3938 | 2.3537 | 2.3743 | 42510.0 |
| 2011-08-16 | HRC | Futures | 2868.4 | 2868.4 | 2868.4 | 2868.4 | 0.0 |
| 2011-08-16 | J1 | Futures | 0.016365 | 0.0164065 | 0.0163436 | 0.0163826 | 67367.0 |
| 2011-08-16 | J7 | Futures | 0.016259 | 0.016291 | 0.016234 | 0.016273 | 331.0 |
| 2011-08-16 | JB | Futures | 123.67 | 123.9 | 123.65 | 123.9 | 973.0 |
| 2011-08-16 | KC | Futures | 580.32 | 596.17 | 572.51 | 595.1 | 5278.0 |
> showing 50 of 97 rows — these rows as CSV