PREVIEW / futures_daily / 2012-10-08
file: by_date/futures_daily/2012/2012-10-08.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-10-08 | ES | Futures | 1483.17 | 1483.17 | 1473.24 | 1475.53 | 961596.0 |
| 2012-10-08 | NQ | Futures | 3228.9 | 3230.92 | 3192.37 | 3195.82 | 191473.0 |
| 2012-10-08 | YM | Futures | 13231.5 | 13231.5 | 13158.2 | 13183.6 | 68415.0 |
| 2012-10-08 | CL | Futures | 162.16 | 162.24 | 159.2 | 161.22 | 202688.0 |
| 2012-10-08 | GC | Futures | 2379.2 | 2379.9 | 2360.8 | 2370.8 | 95898.0 |
| 2012-10-08 | ZN | Futures | 116.807556 | 117.150906 | 116.807556 | 117.137172 | 165798.0 |
| 2012-10-08 | A6 | Futures | 0.91845 | 0.92335 | 0.91681 | 0.92317 | 92978.0 |
| 2012-10-08 | AD | Futures | 1.02396 | 1.02767 | 1.02245 | 1.02717 | 48421.0 |
| 2012-10-08 | B | Futures | 101.87 | 102.13 | 100.57 | 101.65 | 160411.0 |
| 2012-10-08 | B6 | Futures | 1.6856 | 1.6856 | 1.6727 | 1.6738 | 92006.0 |
| 2012-10-08 | BFX | Futures | 2890.9 | 2890.9 | 2878.9 | 2886.0 | 70.0 |
| 2012-10-08 | BR | Futures | 0.23755 | 0.2377 | 0.23716 | 0.2375 | 58.0 |
| 2012-10-08 | BZ | Futures | 104.61 | 105.84 | 104.51 | 105.48 | 2143.0 |
| 2012-10-08 | C | Futures | 1536.0 | 1563.0 | 1536.0 | 1559.0 | 4587.0 |
| 2012-10-08 | CC | Futures | 1796.0 | 1803.0 | 1782.0 | 1796.0 | 6279.0 |
| 2012-10-08 | CSC | Futures | 4.204 | 4.204 | 4.204 | 4.204 | 5.0 |
| 2012-10-08 | CT | Futures | 92.9 | 92.96 | 91.89 | 92.63 | 8885.0 |
| 2012-10-08 | DC | Futures | 30.88 | 31.58 | 30.88 | 31.5 | 254.0 |
| 2012-10-08 | DX | Futures | 76.971 | 77.3 | 76.937 | 77.123 | 8990.0 |
| 2012-10-08 | E1 | Futures | 1.38574 | 1.38677 | 1.37698 | 1.3811 | 24370.0 |
| 2012-10-08 | E6 | Futures | 1.53474 | 1.53486 | 1.52438 | 1.52897 | 162322.0 |
| 2012-10-08 | E7 | Futures | 1.5263 | 1.5263 | 1.5151 | 1.5198 | 2924.0 |
| 2012-10-08 | ED | Futures | 95.2205 | 95.2205 | 95.2062 | 95.211 | 45107.0 |
| 2012-10-08 | ER | Futures | 97.866 | 97.876 | 97.862 | 97.876 | 51226.0 |
| 2012-10-08 | EW | Futures | 1012.9 | 1013.2 | 1006.3 | 1009.5 | 13957.0 |
| 2012-10-08 | FBTP | Futures | 71.43 | 71.63 | 71.3 | 71.44 | 9160.0 |
| 2012-10-08 | FBTS | Futures | 89.5 | 89.592 | 89.433 | 89.466 | 1284.0 |
| 2012-10-08 | FCE | Futures | 2565.5 | 2570.0 | 2544.2 | 2546.0 | 72459.0 |
| 2012-10-08 | FDAX | Futures | 8055.0 | 8062.2 | 7983.3 | 7997.5 | 90802.0 |
| 2012-10-08 | FESX | Futures | 1706.2 | 1709.7 | 1692.6 | 1696.7 | 690305.0 |
| 2012-10-08 | FEU3 | Futures | 98.487 | 98.497 | 98.487 | 98.497 | 4.0 |
| 2012-10-08 | FGBL | Futures | 117.9 | 118.22 | 117.89 | 118.17 | 438373.0 |
| 2012-10-08 | FGBM | Futures | 116.11 | 116.24 | 116.05 | 116.19 | 270004.0 |
| 2012-10-08 | FGBS | Futures | 110.318 | 110.348 | 110.313 | 110.338 | 156463.0 |
| 2012-10-08 | FGBX | Futures | 124.33 | 125.06 | 124.28 | 124.98 | 3549.0 |
| 2012-10-08 | FOAT | Futures | 102.97 | 103.19 | 102.97 | 103.15 | 15391.0 |
| 2012-10-08 | FTDX | Futures | 774.9 | 777.3 | 772.6 | 775.9 | 51.0 |
| 2012-10-08 | FTI | Futures | 281.91 | 282.46 | 280.84 | 281.14 | 20010.0 |
| 2012-10-08 | FTUK | Futures | 4257.0 | 4262.2 | 4237.3 | 4255.2 | 57230.0 |
| 2012-10-08 | FVSA | Futures | 5413.52 | 5499.06 | 5376.86 | 5413.52 | 3935.0 |
| 2012-10-08 | FXXP | Futures | 195.6 | 195.9 | 195.1 | 195.4 | 1180.0 |
| 2012-10-08 | G | Futures | 99.22 | 99.44 | 99.16 | 99.41 | 57969.0 |
| 2012-10-08 | GF | Futures | 282.429 | 282.819 | 281.456 | 281.943 | 900.0 |
| 2012-10-08 | GSCI | Futures | 1055.59 | 1063.49 | 1054.54 | 1060.58 | 1632.0 |
| 2012-10-08 | HE | Futures | 95.275 | 96.549 | 94.902 | 95.555 | 16846.0 |
| 2012-10-08 | HG | Futures | 4.8448 | 4.8448 | 4.7574 | 4.778 | 37278.0 |
| 2012-10-08 | HH | Futures | 43.392 | 43.392 | 43.392 | 43.392 | 445.0 |
| 2012-10-08 | HO | Futures | 2.54 | 2.5515 | 2.5134 | 2.534 | 32881.0 |
| 2012-10-08 | HRC | Futures | 2439.0 | 2439.0 | 2439.0 | 2439.0 | 150.0 |
| 2012-10-08 | J1 | Futures | 0.0159281 | 0.0160446 | 0.0159056 | 0.016022 | 59431.0 |
> showing 50 of 98 rows — these rows as CSV