PREVIEW / futures_daily / 2011-12-22
file: by_date/futures_daily/2011/2011-12-22.parquet size: 9 KB rows: 99
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-12-22 | ES | Futures | 1240.41 | 1255.46 | 1236.64 | 1253.45 | 1333614.0 |
| 2011-12-22 | NQ | Futures | 2562.8 | 2589.39 | 2555.37 | 2585.39 | 128977.0 |
| 2011-12-22 | YM | Futures | 11632.0 | 11720.0 | 11599.1 | 11704.5 | 69749.0 |
| 2011-12-22 | CL | Futures | 185.08 | 186.98 | 184.11 | 186.01 | 151560.0 |
| 2011-12-22 | GC | Futures | 2183.3 | 2185.4 | 2159.0 | 2174.6 | 96547.0 |
| 2011-12-22 | ZN | Futures | 112.719667 | 112.962714 | 112.625149 | 112.73317 | 443305.0 |
| 2011-12-22 | A6 | Futures | 0.88957 | 0.89482 | 0.88699 | 0.89349 | 61262.0 |
| 2011-12-22 | AD | Futures | 0.97542 | 0.98194 | 0.97441 | 0.98094 | 45094.0 |
| 2011-12-22 | B | Futures | 96.18 | 96.69 | 95.62 | 96.15 | 104374.0 |
| 2011-12-22 | B6 | Futures | 1.6375 | 1.6429 | 1.6346 | 1.6379 | 49103.0 |
| 2011-12-22 | BFX | Futures | 2459.0 | 2461.8 | 2436.4 | 2452.6 | 116.0 |
| 2011-12-22 | BR | Futures | 0.24984 | 0.24984 | 0.24984 | 0.24984 | 229.0 |
| 2011-12-22 | BZ | Futures | 102.18 | 102.37 | 101.89 | 102.04 | 235.0 |
| 2011-12-22 | C | Futures | 1462.0 | 1468.0 | 1424.0 | 1442.0 | 7276.0 |
| 2011-12-22 | CB | Futures | 89.75 | 89.777 | 89.75 | 89.75 | 29.0 |
| 2011-12-22 | CC | Futures | 1733.0 | 1747.0 | 1699.0 | 1722.0 | 9111.0 |
| 2011-12-22 | CSC | Futures | 3.973 | 3.976 | 3.942 | 3.947 | 12.0 |
| 2011-12-22 | CT | Futures | 111.54 | 112.62 | 111.54 | 112.36 | 3406.0 |
| 2011-12-22 | DC | Futures | 28.83 | 29.01 | 28.83 | 28.93 | 92.0 |
| 2011-12-22 | DX | Futures | 78.216 | 78.357 | 77.821 | 78.163 | 13229.0 |
| 2011-12-22 | E1 | Futures | 1.40504 | 1.41331 | 1.39926 | 1.40478 | 13067.0 |
| 2011-12-22 | E6 | Futures | 1.56082 | 1.56979 | 1.55736 | 1.56082 | 147047.0 |
| 2011-12-22 | E7 | Futures | 1.5466 | 1.5554 | 1.5432 | 1.5466 | 2932.0 |
| 2011-12-22 | EBM | Futures | 241.43 | 243.73 | 240.78 | 243.73 | 5598.0 |
| 2011-12-22 | ED | Futures | 94.9005 | 94.9053 | 94.8814 | 94.8909 | 97344.0 |
| 2011-12-22 | ER | Futures | 97.199 | 97.199 | 97.164 | 97.174 | 86465.0 |
| 2011-12-22 | EW | Futures | 874.5 | 886.5 | 872.3 | 883.0 | 16452.0 |
| 2011-12-22 | FBTP | Futures | 58.87 | 59.35 | 58.45 | 58.67 | 3313.0 |
| 2011-12-22 | FBTS | Futures | 80.202 | 80.274 | 79.728 | 79.801 | 818.0 |
| 2011-12-22 | FCE | Futures | 2177.6 | 2213.7 | 2177.6 | 2199.4 | 45771.0 |
| 2011-12-22 | FDAX | Futures | 6411.1 | 6509.9 | 6409.4 | 6471.3 | 95240.0 |
| 2011-12-22 | FESX | Futures | 1496.2 | 1525.0 | 1496.2 | 1514.3 | 557733.0 |
| 2011-12-22 | FEU3 | Futures | 97.737 | 97.742 | 97.727 | 97.727 | 201.0 |
| 2011-12-22 | FGBL | Futures | 111.49 | 111.6 | 110.99 | 111.54 | 255289.0 |
| 2011-12-22 | FGBM | Futures | 112.59 | 112.62 | 112.39 | 112.58 | 139510.0 |
| 2011-12-22 | FGBS | Futures | 109.72 | 109.735 | 109.655 | 109.73 | 157133.0 |
| 2011-12-22 | FGBX | Futures | 116.64 | 116.99 | 115.71 | 116.79 | 3386.0 |
| 2011-12-22 | FTDX | Futures | 627.9 | 630.7 | 622.4 | 625.6 | 125.0 |
| 2011-12-22 | FTI | Futures | 253.12 | 257.4 | 253.12 | 256.06 | 25955.0 |
| 2011-12-22 | FTUK | Futures | 3872.9 | 3927.3 | 3855.9 | 3907.8 | 58203.0 |
| 2011-12-22 | FVSA | Futures | 12540.58 | 12540.58 | 12201.65 | 12221.59 | 5471.0 |
| 2011-12-22 | FXXP | Futures | 168.5 | 169.1 | 168.3 | 168.9 | 1332.0 |
| 2011-12-22 | G | Futures | 94.22 | 94.46 | 94.1 | 94.36 | 36942.0 |
| 2011-12-22 | GF | Futures | 311.156 | 317.241 | 311.156 | 316.38 | 1302.0 |
| 2011-12-22 | GSCI | Futures | 1004.83 | 1015.18 | 1004.59 | 1009.77 | 744.0 |
| 2011-12-22 | HE | Futures | 102.938 | 104.417 | 102.784 | 104.233 | 14068.0 |
| 2011-12-22 | HG | Futures | 4.4707 | 4.5242 | 4.4318 | 4.505 | 22443.0 |
| 2011-12-22 | HO | Futures | 2.3561 | 2.372 | 2.3471 | 2.3577 | 18047.0 |
| 2011-12-22 | HRC | Futures | 2825.8 | 2825.8 | 2825.8 | 2825.8 | 10.0 |
| 2011-12-22 | J1 | Futures | 0.016115 | 0.0161288 | 0.0160849 | 0.0160911 | 38762.0 |
> showing 50 of 99 rows — these rows as CSV