PREVIEW / futures_daily / 2012-01-24
file: by_date/futures_daily/2012/2012-01-24.parquet size: 9 KB rows: 98
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 |
|---|---|---|---|---|---|---|---|
| 2012-01-24 | ES | Futures | 1315.93 | 1316.43 | 1306.14 | 1316.18 | 1478167.0 |
| 2012-01-24 | NQ | Futures | 2785.23 | 2790.09 | 2766.93 | 2787.52 | 146667.0 |
| 2012-01-24 | YM | Futures | 12233.5 | 12236.4 | 12147.4 | 12210.3 | 79411.0 |
| 2012-01-24 | CL | Futures | 186.67 | 187.23 | 183.62 | 184.93 | 242477.0 |
| 2012-01-24 | GC | Futures | 2264.3 | 2268.3 | 2242.6 | 2247.3 | 137344.0 |
| 2012-01-24 | ZN | Futures | 112.382102 | 112.530631 | 112.220071 | 112.42261 | 980204.0 |
| 2012-01-24 | A6 | Futures | 0.93087 | 0.93158 | 0.92241 | 0.9274 | 119109.0 |
| 2012-01-24 | AD | Futures | 0.99419 | 0.99539 | 0.98847 | 0.99258 | 71314.0 |
| 2012-01-24 | B | Futures | 98.55 | 98.87 | 97.64 | 97.97 | 93359.0 |
| 2012-01-24 | B6 | Futures | 1.6263 | 1.6333 | 1.6229 | 1.6305 | 81310.0 |
| 2012-01-24 | BR | Futures | 0.26447 | 0.26447 | 0.26447 | 0.26447 | 85.0 |
| 2012-01-24 | BZ | Futures | 104.59 | 104.59 | 104.41 | 104.41 | 305.0 |
| 2012-01-24 | C | Futures | 1522.0 | 1618.0 | 1506.0 | 1615.0 | 11872.0 |
| 2012-01-24 | CB | Futures | 85.094 | 85.094 | 84.502 | 85.04 | 10.0 |
| 2012-01-24 | CC | Futures | 1759.0 | 1880.0 | 1750.0 | 1871.0 | 20960.0 |
| 2012-01-24 | CSC | Futures | 3.805 | 3.854 | 3.805 | 3.854 | 27.0 |
| 2012-01-24 | CT | Futures | 127.51 | 128.11 | 125.1 | 126.45 | 10203.0 |
| 2012-01-24 | DC | Futures | 27.74 | 28.44 | 27.67 | 28.23 | 293.0 |
| 2012-01-24 | DX | Futures | 77.792 | 78.201 | 77.656 | 77.891 | 24846.0 |
| 2012-01-24 | E1 | Futures | 1.41646 | 1.42237 | 1.41068 | 1.41462 | 25340.0 |
| 2012-01-24 | E6 | Futures | 1.55592 | 1.56178 | 1.54863 | 1.55688 | 308386.0 |
| 2012-01-24 | E7 | Futures | 1.5419 | 1.5475 | 1.5345 | 1.5427 | 4407.0 |
| 2012-01-24 | EBM | Futures | 263.05 | 269.93 | 263.05 | 269.61 | 11792.0 |
| 2012-01-24 | ED | Futures | 95.0486 | 95.0581 | 95.0438 | 95.0533 | 171656.0 |
| 2012-01-24 | ER | Futures | 97.469 | 97.499 | 97.43 | 97.444 | 187538.0 |
| 2012-01-24 | EW | Futures | 935.6 | 940.3 | 926.7 | 939.8 | 15259.0 |
| 2012-01-24 | FBTP | Futures | 62.05 | 62.51 | 61.51 | 61.94 | 12175.0 |
| 2012-01-24 | FBTS | Futures | 83.068 | 83.26 | 82.731 | 82.963 | 1848.0 |
| 2012-01-24 | FCE | Futures | 2370.8 | 2372.3 | 2343.8 | 2364.8 | 73788.0 |
| 2012-01-24 | FDAX | Futures | 7080.9 | 7100.2 | 6999.1 | 7085.3 | 142306.0 |
| 2012-01-24 | FESX | Futures | 1622.6 | 1625.9 | 1605.9 | 1622.6 | 972712.0 |
| 2012-01-24 | FEU3 | Futures | 98.004 | 98.004 | 97.999 | 97.999 | 115.0 |
| 2012-01-24 | FGBL | Futures | 111.29 | 111.6 | 111.01 | 111.11 | 793107.0 |
| 2012-01-24 | FGBM | Futures | 112.73 | 112.9 | 112.58 | 112.63 | 364911.0 |
| 2012-01-24 | FGBS | Futures | 109.859 | 109.894 | 109.81 | 109.825 | 385072.0 |
| 2012-01-24 | FGBX | Futures | 115.09 | 115.14 | 114.08 | 114.23 | 7310.0 |
| 2012-01-24 | FTDX | Futures | 691.6 | 691.6 | 681.8 | 682.3 | 221.0 |
| 2012-01-24 | FTI | Futures | 268.5 | 268.92 | 265.66 | 267.75 | 33427.0 |
| 2012-01-24 | FTUK | Futures | 4140.5 | 4144.4 | 4093.9 | 4114.1 | 91287.0 |
| 2012-01-24 | FVSA | Futures | 10947.59 | 11120.45 | 10755.53 | 10793.94 | 3190.0 |
| 2012-01-24 | FXXP | Futures | 180.3 | 180.4 | 179.0 | 180.4 | 1649.0 |
| 2012-01-24 | G | Futures | 93.55 | 93.84 | 93.3 | 93.39 | 203627.0 |
| 2012-01-24 | GF | Futures | 325.954 | 328.923 | 325.795 | 328.446 | 2402.0 |
| 2012-01-24 | GSCI | Futures | 1027.84 | 1032.77 | 1024.63 | 1031.75 | 60.0 |
| 2012-01-24 | HE | Futures | 106.951 | 107.858 | 106.136 | 106.166 | 17657.0 |
| 2012-01-24 | HG | Futures | 5.032 | 5.0465 | 4.9456 | 5.0221 | 48689.0 |
| 2012-01-24 | HO | Futures | 2.4391 | 2.4525 | 2.4316 | 2.4401 | 68515.0 |
| 2012-01-24 | HRC | Futures | 2876.8 | 2876.8 | 2876.8 | 2876.8 | 5.0 |
| 2012-01-24 | J1 | Futures | 0.0163159 | 0.0163234 | 0.0161351 | 0.0161615 | 112406.0 |
| 2012-01-24 | J7 | Futures | 0.016255 | 0.016256 | 0.016066 | 0.016095 | 383.0 |
> showing 50 of 98 rows — these rows as CSV