PREVIEW / futures_daily / 2011-04-07
file: by_date/futures_daily/2011/2011-04-07.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-04-07 | ES | Futures | 1315.72 | 1321.91 | 1309.04 | 1315.23 | 2180272.0 |
| 2011-04-07 | NQ | Futures | 2648.48 | 2669.83 | 2632.82 | 2652.75 | 299965.0 |
| 2011-04-07 | YM | Futures | 11620.6 | 11646.9 | 11538.8 | 11612.1 | 109012.0 |
| 2011-04-07 | CL | Futures | 210.15 | 213.57 | 209.29 | 213.3 | 334906.0 |
| 2011-04-07 | GC | Futures | 1976.3 | 1984.9 | 1967.6 | 1975.2 | 109290.0 |
| 2011-04-07 | ZN | Futures | 99.749269 | 100.03897 | 99.551746 | 99.841447 | 1265802.0 |
| 2011-04-07 | A6 | Futures | 0.88744 | 0.89387 | 0.88572 | 0.88907 | 101128.0 |
| 2011-04-07 | AD | Futures | 1.03496 | 1.03894 | 1.03317 | 1.03675 | 63767.0 |
| 2011-04-07 | B | Futures | 103.21 | 103.91 | 102.65 | 103.71 | 127552.0 |
| 2011-04-07 | B6 | Futures | 1.6949 | 1.7001 | 1.6878 | 1.6935 | 105417.0 |
| 2011-04-07 | BFX | Futures | 3134.9 | 3144.5 | 3119.9 | 3119.9 | 163.0 |
| 2011-04-07 | BR | Futures | 0.27124 | 0.27553 | 0.27124 | 0.27553 | 112.0 |
| 2011-04-07 | BZ | Futures | 108.7 | 109.55 | 108.7 | 109.34 | 1435.0 |
| 2011-04-07 | C | Futures | 2131.0 | 2147.0 | 2110.0 | 2121.0 | 3270.0 |
| 2011-04-07 | CB | Futures | 114.402 | 114.695 | 114.402 | 114.695 | 4.0 |
| 2011-04-07 | CC | Futures | 2399.0 | 2418.0 | 2383.0 | 2390.0 | 11035.0 |
| 2011-04-07 | CSC | Futures | 4.399 | 4.399 | 4.376 | 4.397 | 6.0 |
| 2011-04-07 | CT | Futures | 187.83 | 192.31 | 185.23 | 186.19 | 22452.0 |
| 2011-04-07 | DC | Futures | 28.79 | 29.34 | 28.79 | 29.14 | 188.0 |
| 2011-04-07 | DX | Futures | 75.402 | 75.675 | 75.357 | 75.432 | 22268.0 |
| 2011-04-07 | E1 | Futures | 1.42567 | 1.43117 | 1.42357 | 1.4296 | 37403.0 |
| 2011-04-07 | E6 | Futures | 1.69489 | 1.69572 | 1.68459 | 1.69122 | 337531.0 |
| 2011-04-07 | E7 | Futures | 1.6825 | 1.683 | 1.6719 | 1.6786 | 5699.0 |
| 2011-04-07 | EBM | Futures | 236.72 | 236.96 | 233.2 | 234.61 | 5288.0 |
| 2011-04-07 | ED | Futures | 94.9121 | 94.9264 | 94.9073 | 94.9216 | 164334.0 |
| 2011-04-07 | ER | Futures | 97.272 | 97.281 | 97.232 | 97.247 | 316996.0 |
| 2011-04-07 | EW | Futures | 991.2 | 996.3 | 984.6 | 987.0 | 20981.0 |
| 2011-04-07 | FBTP | Futures | 64.38 | 64.43 | 64.19 | 64.35 | 4617.0 |
| 2011-04-07 | FCE | Futures | 2692.5 | 2710.1 | 2676.8 | 2680.2 | 123771.0 |
| 2011-04-07 | FDAX | Futures | 7714.0 | 7753.5 | 7680.4 | 7688.9 | 134223.0 |
| 2011-04-07 | FESX | Futures | 1854.2 | 1869.6 | 1847.2 | 1851.0 | 1248170.0 |
| 2011-04-07 | FEU3 | Futures | 97.82 | 97.825 | 97.79 | 97.79 | 16.0 |
| 2011-04-07 | FGBL | Futures | 96.46 | 96.67 | 96.26 | 96.59 | 1065630.0 |
| 2011-04-07 | FGBM | Futures | 102.24 | 102.39 | 102.09 | 102.31 | 564348.0 |
| 2011-04-07 | FGBS | Futures | 106.137 | 106.211 | 106.067 | 106.171 | 846743.0 |
| 2011-04-07 | FGBX | Futures | 91.61 | 91.85 | 91.1 | 91.65 | 5441.0 |
| 2011-04-07 | FTDX | Futures | 846.2 | 846.2 | 833.3 | 835.5 | 1089.0 |
| 2011-04-07 | FTI | Futures | 300.72 | 301.78 | 298.64 | 298.89 | 30735.0 |
| 2011-04-07 | FTUK | Futures | 4196.3 | 4208.9 | 4171.4 | 4183.7 | 86599.0 |
| 2011-04-07 | FXXP | Futures | 185.9 | 186.3 | 184.9 | 185.1 | 632.0 |
| 2011-04-07 | G | Futures | 80.73 | 81.02 | 80.63 | 80.92 | 147692.0 |
| 2011-04-07 | GF | Futures | 328.279 | 328.884 | 325.496 | 327.009 | 715.0 |
| 2011-04-07 | GSCI | Futures | 1163.32 | 1168.33 | 1155.57 | 1165.9 | 1995.0 |
| 2011-04-07 | HE | Futures | 107.318 | 108.088 | 105.937 | 106.734 | 329.0 |
| 2011-04-07 | HG | Futures | 5.8248 | 5.91 | 5.7942 | 5.8827 | 42586.0 |
| 2011-04-07 | HO | Futures | 2.6615 | 2.6773 | 2.6458 | 2.6739 | 22135.0 |
| 2011-04-07 | HRC | Futures | 3024.8 | 3024.8 | 3024.8 | 3024.8 | 0.0 |
| 2011-04-07 | J1 | Futures | 0.0147126 | 0.0148558 | 0.0146975 | 0.0147981 | 158916.0 |
| 2011-04-07 | J7 | Futures | 0.014625 | 0.014765 | 0.014609 | 0.014707 | 1380.0 |
| 2011-04-07 | JB | Futures | 120.77 | 120.89 | 120.67 | 120.73 | 143.0 |
> showing 50 of 94 rows — these rows as CSV