PREVIEW / futures_daily / 2011-11-11
file: by_date/futures_daily/2011/2011-11-11.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-11-11 | ES | Futures | 1235.33 | 1262.53 | 1231.59 | 1259.29 | 1603127.0 |
| 2011-11-11 | NQ | Futures | 2635.05 | 2694.12 | 2627.06 | 2682.71 | 187760.0 |
| 2011-11-11 | YM | Futures | 11388.6 | 11664.3 | 11357.9 | 11635.5 | 104052.0 |
| 2011-11-11 | CL | Futures | 182.93 | 186.48 | 182.63 | 185.71 | 282786.0 |
| 2011-11-11 | GC | Futures | 2375.7 | 2418.3 | 2356.0 | 2414.2 | 106879.0 |
| 2011-11-11 | ZN | Futures | 111.871383 | 111.871383 | 111.281458 | 111.361902 | 158529.0 |
| 2011-11-11 | A6 | Futures | 0.88914 | 0.90242 | 0.88492 | 0.90093 | 84060.0 |
| 2011-11-11 | AD | Futures | 0.98334 | 0.99005 | 0.97714 | 0.98745 | 51463.0 |
| 2011-11-11 | B | Futures | 99.05 | 100.5 | 99.04 | 99.96 | 136664.0 |
| 2011-11-11 | B6 | Futures | 1.6626 | 1.6791 | 1.6584 | 1.6758 | 80812.0 |
| 2011-11-11 | BR | Futures | 0.25756 | 0.25756 | 0.25756 | 0.25756 | 83.0 |
| 2011-11-11 | BZ | Futures | 105.64 | 106.07 | 105.17 | 105.55 | 511.0 |
| 2011-11-11 | C | Futures | 1678.0 | 1687.0 | 1657.0 | 1667.0 | 5717.0 |
| 2011-11-11 | CB | Futures | 90.957 | 90.957 | 90.409 | 90.957 | 6.0 |
| 2011-11-11 | CC | Futures | 1984.0 | 2006.0 | 1972.0 | 1984.0 | 14394.0 |
| 2011-11-11 | CSC | Futures | 4.422 | 4.422 | 4.422 | 4.422 | 6.0 |
| 2011-11-11 | CT | Futures | 127.98 | 128.91 | 126.89 | 127.94 | 11767.0 |
| 2011-11-11 | DC | Futures | 30.89 | 31.58 | 30.87 | 31.56 | 477.0 |
| 2011-11-11 | DX | Futures | 76.461 | 76.535 | 75.514 | 75.721 | 16896.0 |
| 2011-11-11 | E1 | Futures | 1.44926 | 1.46632 | 1.44506 | 1.45674 | 16589.0 |
| 2011-11-11 | E6 | Futures | 1.62644 | 1.64879 | 1.62286 | 1.64318 | 236711.0 |
| 2011-11-11 | E7 | Futures | 1.6115 | 1.6346 | 1.6091 | 1.6291 | 5207.0 |
| 2011-11-11 | ED | Futures | 94.9173 | 94.9316 | 94.8982 | 94.9173 | 84705.0 |
| 2011-11-11 | ER | Futures | 97.268 | 97.307 | 97.253 | 97.278 | 78595.0 |
| 2011-11-11 | EW | Futures | 871.6 | 898.2 | 870.2 | 892.7 | 21455.0 |
| 2011-11-11 | FBTP | Futures | 57.09 | 58.5 | 56.68 | 58.2 | 15269.0 |
| 2011-11-11 | FBTS | Futures | 77.858 | 79.849 | 77.858 | 79.503 | 1836.0 |
| 2011-11-11 | FCE | Futures | 2214.7 | 2266.0 | 2193.5 | 2258.9 | 76073.0 |
| 2011-11-11 | FDAX | Futures | 6429.7 | 6591.5 | 6359.1 | 6567.6 | 150396.0 |
| 2011-11-11 | FESX | Futures | 1511.2 | 1548.4 | 1496.6 | 1542.4 | 959574.0 |
| 2011-11-11 | FGBL | Futures | 111.94 | 112.0 | 110.78 | 111.05 | 548663.0 |
| 2011-11-11 | FGBM | Futures | 112.05 | 112.07 | 111.45 | 111.62 | 288443.0 |
| 2011-11-11 | FGBS | Futures | 109.417 | 109.427 | 109.312 | 109.342 | 266183.0 |
| 2011-11-11 | FGBX | Futures | 115.51 | 115.53 | 114.1 | 114.38 | 3841.0 |
| 2011-11-11 | FTDX | Futures | 630.2 | 650.9 | 630.2 | 649.1 | 142.0 |
| 2011-11-11 | FTI | Futures | 248.54 | 253.33 | 247.15 | 252.95 | 102.0 |
| 2011-11-11 | FTUK | Futures | 3910.7 | 3978.5 | 3895.3 | 3971.0 | 93832.0 |
| 2011-11-11 | FVSA | Futures | 17084.87 | 17084.87 | 15793.09 | 15980.6 | 5021.0 |
| 2011-11-11 | FXXP | Futures | 163.7 | 168.0 | 163.7 | 167.6 | 3368.0 |
| 2011-11-11 | G | Futures | 92.46 | 92.54 | 91.94 | 91.98 | 67827.0 |
| 2011-11-11 | GF | Futures | 313.472 | 315.249 | 312.556 | 313.795 | 1917.0 |
| 2011-11-11 | GSCI | Futures | 1027.19 | 1034.71 | 1026.42 | 1033.01 | 1774.0 |
| 2011-11-11 | HE | Futures | 110.479 | 111.508 | 109.837 | 111.122 | 19671.0 |
| 2011-11-11 | HG | Futures | 4.4674 | 4.613 | 4.4237 | 4.5832 | 41296.0 |
| 2011-11-11 | HO | Futures | 2.5234 | 2.57 | 2.5171 | 2.5475 | 49930.0 |
| 2011-11-11 | HRC | Futures | 2664.5 | 2664.5 | 2664.5 | 2664.5 | 0.0 |
| 2011-11-11 | J1 | Futures | 0.0161891 | 0.0163185 | 0.0161815 | 0.0162883 | 55635.0 |
| 2011-11-11 | J7 | Futures | 0.016091 | 0.016217 | 0.016087 | 0.016189 | 344.0 |
| 2011-11-11 | JB | Futures | 124.68 | 124.81 | 124.65 | 124.71 | 1173.0 |
| 2011-11-11 | KC | Futures | 543.63 | 553.88 | 540.22 | 551.29 | 13449.0 |
> showing 50 of 95 rows — these rows as CSV