PREVIEW / futures_daily / 2011-04-06
file: by_date/futures_daily/2011/2011-04-06.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-04-06 | ES | Futures | 1313.74 | 1323.15 | 1312.75 | 1315.72 | 1656416.0 |
| 2011-04-06 | NQ | Futures | 2646.77 | 2676.38 | 2638.51 | 2648.48 | 260050.0 |
| 2011-04-06 | YM | Futures | 11587.7 | 11662.9 | 11583.9 | 11617.8 | 86708.0 |
| 2011-04-06 | CL | Futures | 208.83 | 211.07 | 208.31 | 210.46 | 255598.0 |
| 2011-04-06 | GC | Futures | 1973.7 | 1981.1 | 1966.0 | 1974.1 | 131975.0 |
| 2011-04-06 | ZN | Futures | 100.091643 | 100.170652 | 99.696596 | 99.762437 | 1076993.0 |
| 2011-04-06 | A6 | Futures | 0.878 | 0.88872 | 0.87723 | 0.88761 | 81336.0 |
| 2011-04-06 | AD | Futures | 1.03157 | 1.03894 | 1.03117 | 1.03645 | 59562.0 |
| 2011-04-06 | B | Futures | 102.81 | 104.33 | 102.69 | 103.43 | 117921.0 |
| 2011-04-06 | B6 | Futures | 1.6908 | 1.6985 | 1.6872 | 1.6946 | 123654.0 |
| 2011-04-06 | BFX | Futures | 3107.2 | 3147.6 | 3107.2 | 3124.5 | 88.0 |
| 2011-04-06 | BR | Futures | 0.27181 | 0.27181 | 0.27023 | 0.27082 | 134.0 |
| 2011-04-06 | BZ | Futures | 109.43 | 109.43 | 109.04 | 109.04 | 939.0 |
| 2011-04-06 | C | Futures | 2121.0 | 2151.0 | 2102.0 | 2129.0 | 5046.0 |
| 2011-04-06 | CB | Futures | 114.695 | 114.989 | 114.695 | 114.695 | 13.0 |
| 2011-04-06 | CC | Futures | 2392.0 | 2427.0 | 2371.0 | 2399.0 | 9533.0 |
| 2011-04-06 | CT | Futures | 178.84 | 186.05 | 178.25 | 186.05 | 7245.0 |
| 2011-04-06 | DC | Futures | 28.65 | 28.86 | 28.43 | 28.74 | 256.0 |
| 2011-04-06 | DX | Futures | 75.715 | 75.745 | 75.312 | 75.379 | 21987.0 |
| 2011-04-06 | E1 | Futures | 1.41598 | 1.4347 | 1.40891 | 1.42462 | 48983.0 |
| 2011-04-06 | E6 | Futures | 1.68222 | 1.69726 | 1.68163 | 1.69548 | 312891.0 |
| 2011-04-06 | E7 | Futures | 1.6697 | 1.6847 | 1.6692 | 1.6829 | 4392.0 |
| 2011-04-06 | EBM | Futures | 237.19 | 237.66 | 233.67 | 235.31 | 6450.0 |
| 2011-04-06 | ED | Futures | 94.9026 | 94.9168 | 94.9026 | 94.9073 | 150066.0 |
| 2011-04-06 | ER | Futures | 97.281 | 97.281 | 97.262 | 97.272 | 90908.0 |
| 2011-04-06 | EW | Futures | 991.0 | 1000.8 | 989.0 | 991.6 | 18540.0 |
| 2011-04-06 | FBTP | Futures | 64.08 | 64.52 | 64.08 | 64.39 | 6929.0 |
| 2011-04-06 | FCE | Futures | 2696.8 | 2707.5 | 2673.2 | 2694.5 | 109052.0 |
| 2011-04-06 | FDAX | Futures | 7704.9 | 7755.1 | 7662.2 | 7727.4 | 134508.0 |
| 2011-04-06 | FESX | Futures | 1847.2 | 1864.5 | 1832.4 | 1856.2 | 1230054.0 |
| 2011-04-06 | FEU3 | Futures | 97.81 | 97.815 | 97.81 | 97.815 | 31.0 |
| 2011-04-06 | FGBL | Futures | 96.66 | 96.79 | 96.43 | 96.51 | 873771.0 |
| 2011-04-06 | FGBM | Futures | 102.33 | 102.44 | 102.21 | 102.29 | 433428.0 |
| 2011-04-06 | FGBS | Futures | 106.127 | 106.191 | 106.127 | 106.156 | 502867.0 |
| 2011-04-06 | FGBX | Futures | 92.27 | 92.47 | 91.48 | 91.72 | 4312.0 |
| 2011-04-06 | FTDX | Futures | 847.1 | 856.9 | 838.2 | 843.5 | 225.0 |
| 2011-04-06 | FTI | Futures | 300.68 | 301.95 | 299.74 | 300.68 | 29703.0 |
| 2011-04-06 | FTUK | Futures | 4179.8 | 4211.0 | 4176.0 | 4201.2 | 79917.0 |
| 2011-04-06 | FXXP | Futures | 185.1 | 185.9 | 184.5 | 185.3 | 256.0 |
| 2011-04-06 | G | Futures | 80.83 | 81.1 | 80.74 | 80.9 | 135001.0 |
| 2011-04-06 | GF | Futures | 330.397 | 331.97 | 327.735 | 328.4 | 717.0 |
| 2011-04-06 | GSCI | Futures | 1157.76 | 1168.02 | 1157.06 | 1161.67 | 396.0 |
| 2011-04-06 | HE | Futures | 109.443 | 109.549 | 107.53 | 108.487 | 248.0 |
| 2011-04-06 | HG | Futures | 5.6516 | 5.8328 | 5.649 | 5.8208 | 37703.0 |
| 2011-04-06 | HO | Futures | 2.6434 | 2.685 | 2.6411 | 2.6627 | 27752.0 |
| 2011-04-06 | HRC | Futures | 3024.8 | 3024.8 | 3024.8 | 3024.8 | 0.0 |
| 2011-04-06 | J1 | Futures | 0.0147666 | 0.0148131 | 0.014695 | 0.0147151 | 137457.0 |
| 2011-04-06 | J7 | Futures | 0.01469 | 0.014721 | 0.014606 | 0.014625 | 1162.0 |
| 2011-04-06 | JB | Futures | 121.22 | 121.31 | 120.76 | 121.02 | 51.0 |
| 2011-04-06 | KC | Futures | 649.79 | 652.82 | 640.46 | 642.64 | 11295.0 |
> showing 50 of 93 rows — these rows as CSV