PREVIEW / futures_daily / 2011-01-31
file: by_date/futures_daily/2011/2011-01-31.parquet size: 9 KB rows: 93
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-01-31 | ES | Futures | 1249.6 | 1263.63 | 1242.46 | 1262.4 | 2314420.0 |
| 2011-01-31 | NQ | Futures | 2572.03 | 2595.31 | 2552.73 | 2588.49 | 316720.0 |
| 2011-01-31 | YM | Futures | 10998.1 | 11091.7 | 10941.0 | 11081.4 | 113876.0 |
| 2011-01-31 | CL | Futures | 183.03 | 188.87 | 179.84 | 187.55 | 436801.0 |
| 2011-01-31 | GC | Futures | 1816.9 | 1828.3 | 1796.3 | 1811.1 | 156126.0 |
| 2011-01-31 | ZN | Futures | 100.920494 | 101.03748 | 100.33556 | 100.491542 | 985293.0 |
| 2011-01-31 | A6 | Futures | 0.83444 | 0.84266 | 0.83198 | 0.8413 | 90814.0 |
| 2011-01-31 | AD | Futures | 0.99225 | 0.99532 | 0.9857 | 0.99026 | 87319.0 |
| 2011-01-31 | B | Futures | 85.12 | 86.74 | 84.04 | 86.15 | 98537.0 |
| 2011-01-31 | B6 | Futures | 1.6433 | 1.6644 | 1.6409 | 1.6618 | 138822.0 |
| 2011-01-31 | BFX | Futures | 3050.7 | 3068.5 | 3040.0 | 3047.1 | 148.0 |
| 2011-01-31 | BR | Futures | 0.25446 | 0.25601 | 0.25446 | 0.25582 | 202.0 |
| 2011-01-31 | BZ | Futures | 90.57 | 92.05 | 89.83 | 92.05 | 860.0 |
| 2011-01-31 | C | Futures | 2360.0 | 2393.0 | 2356.0 | 2387.0 | 3756.0 |
| 2011-01-31 | CB | Futures | 115.781 | 115.781 | 115.575 | 115.781 | 11.0 |
| 2011-01-31 | CC | Futures | 2651.0 | 2731.0 | 2616.0 | 2720.0 | 12207.0 |
| 2011-01-31 | CT | Futures | 142.25 | 144.7 | 141.88 | 144.44 | 10847.0 |
| 2011-01-31 | DC | Futures | 28.61 | 29.84 | 28.61 | 29.84 | 640.0 |
| 2011-01-31 | DX | Futures | 78.249 | 78.329 | 77.525 | 77.725 | 23182.0 |
| 2011-01-31 | E1 | Futures | 1.39187 | 1.3996 | 1.38754 | 1.3899 | 39377.0 |
| 2011-01-31 | E6 | Futures | 1.60598 | 1.62479 | 1.60468 | 1.61935 | 332910.0 |
| 2011-01-31 | E7 | Futures | 1.5943 | 1.6127 | 1.5927 | 1.6073 | 5834.0 |
| 2011-01-31 | EBM | Futures | 241.71 | 244.66 | 239.66 | 244.2 | 6243.0 |
| 2011-01-31 | ED | Futures | 94.8337 | 94.8384 | 94.8194 | 94.8337 | 162864.0 |
| 2011-01-31 | ER | Futures | 97.242 | 97.252 | 97.217 | 97.237 | 137799.0 |
| 2011-01-31 | EW | Futures | 901.4 | 915.3 | 895.4 | 909.4 | 23871.0 |
| 2011-01-31 | FBTP | Futures | 63.66 | 64.07 | 63.66 | 64.01 | 4439.0 |
| 2011-01-31 | FCE | Futures | 2664.1 | 2689.1 | 2639.1 | 2674.1 | 160462.0 |
| 2011-01-31 | FDAX | Futures | 7603.1 | 7620.2 | 7539.9 | 7598.8 | 140060.0 |
| 2011-01-31 | FESX | Futures | 1829.6 | 1847.7 | 1813.5 | 1839.0 | 1290328.0 |
| 2011-01-31 | FEU3 | Futures | 97.79 | 97.795 | 97.79 | 97.795 | 5.0 |
| 2011-01-31 | FGBL | Futures | 97.97 | 98.16 | 97.77 | 98.0 | 723716.0 |
| 2011-01-31 | FGBM | Futures | 103.35 | 103.39 | 103.18 | 103.33 | 512535.0 |
| 2011-01-31 | FGBS | Futures | 106.675 | 106.68 | 106.566 | 106.64 | 515155.0 |
| 2011-01-31 | FGBX | Futures | 95.65 | 96.14 | 95.14 | 95.7 | 5148.0 |
| 2011-01-31 | FTDX | Futures | 759.6 | 768.4 | 750.4 | 763.1 | 781.0 |
| 2011-01-31 | FTI | Futures | 289.11 | 291.41 | 287.17 | 290.08 | 37755.0 |
| 2011-01-31 | FTUK | Futures | 4026.6 | 4063.1 | 4013.7 | 4052.6 | 121612.0 |
| 2011-01-31 | FXXP | Futures | 179.8 | 181.7 | 179.8 | 181.6 | 777.0 |
| 2011-01-31 | G | Futures | 80.55 | 80.69 | 80.4 | 80.61 | 83465.0 |
| 2011-01-31 | GF | Futures | 312.288 | 317.159 | 312.288 | 315.741 | 3112.0 |
| 2011-01-31 | GSCI | Futures | 1026.94 | 1048.27 | 1021.44 | 1043.82 | 428.0 |
| 2011-01-31 | HE | Futures | 107.464 | 110.323 | 107.377 | 109.681 | 30251.0 |
| 2011-01-31 | HG | Futures | 5.798 | 5.9466 | 5.7787 | 5.9419 | 32083.0 |
| 2011-01-31 | HO | Futures | 2.2618 | 2.3079 | 2.2353 | 2.2917 | 53091.0 |
| 2011-01-31 | HRC | Futures | 2709.3 | 2709.3 | 2709.3 | 2709.3 | 0.0 |
| 2011-01-31 | J1 | Futures | 0.0152955 | 0.015342 | 0.0152716 | 0.0153156 | 100739.0 |
| 2011-01-31 | J7 | Futures | 0.015183 | 0.01523 | 0.015164 | 0.015207 | 345.0 |
| 2011-01-31 | JB | Futures | 120.89 | 121.15 | 120.83 | 121.0 | 1934.0 |
| 2011-01-31 | KC | Futures | 602.03 | 614.91 | 596.52 | 600.32 | 14259.0 |
> showing 50 of 93 rows — these rows as CSV