PREVIEW / futures_daily / 2011-08-03
file: by_date/futures_daily/2011/2011-08-03.parquet size: 9 KB rows: 94
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-03 | ES | Futures | 1239.68 | 1249.36 | 1221.8 | 1245.89 | 3815275.0 |
| 2011-08-03 | NQ | Futures | 2607.76 | 2635.66 | 2565.62 | 2621.99 | 448373.0 |
| 2011-08-03 | YM | Futures | 11164.3 | 11235.2 | 11012.1 | 11172.8 | 200905.0 |
| 2011-08-03 | CL | Futures | 178.52 | 179.67 | 174.82 | 176.18 | 350221.0 |
| 2011-08-03 | GC | Futures | 2244.6 | 2262.7 | 2233.7 | 2249.8 | 204437.0 |
| 2011-08-03 | ZN | Futures | 108.209341 | 108.44883 | 107.929936 | 108.182731 | 1824198.0 |
| 2011-08-03 | A6 | Futures | 0.9324 | 0.93283 | 0.92344 | 0.92848 | 179053.0 |
| 2011-08-03 | AD | Futures | 1.03748 | 1.04217 | 1.03359 | 1.03569 | 121687.0 |
| 2011-08-03 | B | Futures | 99.16 | 99.21 | 96.37 | 96.72 | 109225.0 |
| 2011-08-03 | B6 | Futures | 1.6935 | 1.7086 | 1.6899 | 1.7074 | 104161.0 |
| 2011-08-03 | BFX | Futures | 2782.6 | 2811.5 | 2758.5 | 2759.6 | 172.0 |
| 2011-08-03 | BR | Futures | 0.28241 | 0.28513 | 0.28241 | 0.28441 | 2550.0 |
| 2011-08-03 | BZ | Futures | 100.13 | 100.13 | 99.9 | 99.9 | 710.0 |
| 2011-08-03 | C | Futures | 2006.0 | 2012.0 | 1986.0 | 1987.0 | 5495.0 |
| 2011-08-03 | CC | Futures | 2324.0 | 2349.0 | 2308.0 | 2312.0 | 16934.0 |
| 2011-08-03 | CT | Futures | 138.23 | 138.25 | 134.35 | 135.51 | 85.0 |
| 2011-08-03 | DC | Futures | 33.89 | 33.96 | 33.31 | 33.74 | 497.0 |
| 2011-08-03 | DX | Futures | 73.999 | 74.133 | 73.37 | 73.483 | 25216.0 |
| 2011-08-03 | E1 | Futures | 1.71159 | 1.71577 | 1.68059 | 1.70361 | 82663.0 |
| 2011-08-03 | E6 | Futures | 1.68402 | 1.70219 | 1.67832 | 1.69815 | 420381.0 |
| 2011-08-03 | E7 | Futures | 1.672 | 1.6898 | 1.6662 | 1.6857 | 5467.0 |
| 2011-08-03 | ED | Futures | 94.8906 | 94.9239 | 94.8715 | 94.9144 | 326709.0 |
| 2011-08-03 | ER | Futures | 97.415 | 97.435 | 97.4 | 97.42 | 117846.0 |
| 2011-08-03 | EW | Futures | 899.4 | 904.2 | 877.5 | 900.1 | 38706.0 |
| 2011-08-03 | FBTP | Futures | 58.67 | 59.48 | 58.34 | 59.18 | 13255.0 |
| 2011-08-03 | FCE | Futures | 2455.4 | 2482.2 | 2419.4 | 2436.7 | 257560.0 |
| 2011-08-03 | FDAX | Futures | 7171.8 | 7263.2 | 7000.3 | 7100.2 | 252287.0 |
| 2011-08-03 | FESX | Futures | 1609.9 | 1637.5 | 1589.4 | 1601.6 | 2473561.0 |
| 2011-08-03 | FEU3 | Futures | 97.959 | 97.959 | 97.959 | 97.959 | 1.0 |
| 2011-08-03 | FGBL | Futures | 106.04 | 106.4 | 105.43 | 105.74 | 1048951.0 |
| 2011-08-03 | FGBM | Futures | 108.51 | 108.67 | 107.98 | 108.19 | 674196.0 |
| 2011-08-03 | FGBS | Futures | 108.179 | 108.248 | 107.99 | 108.079 | 614162.0 |
| 2011-08-03 | FGBX | Futures | 103.64 | 104.42 | 103.24 | 103.66 | 7496.0 |
| 2011-08-03 | FTDX | Futures | 693.9 | 697.5 | 674.3 | 678.8 | 1518.0 |
| 2011-08-03 | FTI | Futures | 260.23 | 261.89 | 255.88 | 257.29 | 64369.0 |
| 2011-08-03 | FTUK | Futures | 3961.8 | 3993.2 | 3896.9 | 3929.0 | 196688.0 |
| 2011-08-03 | FXXP | Futures | 171.3 | 173.0 | 169.5 | 170.3 | 3691.0 |
| 2011-08-03 | G | Futures | 88.49 | 88.5 | 88.13 | 88.2 | 147785.0 |
| 2011-08-03 | GF | Futures | 313.918 | 314.557 | 309.328 | 312.233 | 2371.0 |
| 2011-08-03 | GSCI | Futures | 1087.72 | 1090.92 | 1072.75 | 1074.75 | 152.0 |
| 2011-08-03 | HE | Futures | 113.374 | 113.71 | 109.985 | 112.672 | 20064.0 |
| 2011-08-03 | HG | Futures | 5.7842 | 5.8212 | 5.7115 | 5.7188 | 39082.0 |
| 2011-08-03 | HO | Futures | 2.4903 | 2.5011 | 2.439 | 2.4441 | 58247.0 |
| 2011-08-03 | HRC | Futures | 2890.0 | 2890.0 | 2890.0 | 2890.0 | 50.0 |
| 2011-08-03 | J1 | Futures | 0.0162645 | 0.0163788 | 0.0162469 | 0.0163537 | 118218.0 |
| 2011-08-03 | J7 | Futures | 0.016156 | 0.016268 | 0.01614 | 0.016244 | 559.0 |
| 2011-08-03 | JB | Futures | 123.77 | 123.92 | 123.7 | 123.78 | 2907.0 |
| 2011-08-03 | KC | Futures | 574.52 | 581.27 | 568.61 | 572.28 | 11909.0 |
| 2011-08-03 | KE | Futures | 3095.85 | 3106.42 | 3030.56 | 3065.12 | 11237.0 |
| 2011-08-03 | L | Futures | 98.443 | 98.463 | 98.423 | 98.453 | 53791.0 |
> showing 50 of 94 rows — these rows as CSV