PREVIEW / futures_daily / 2012-09-25
file: by_date/futures_daily/2012/2012-09-25.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-09-25 | ES | Futures | 1477.57 | 1482.91 | 1460.52 | 1462.81 | 1813743.0 |
| 2012-09-25 | NQ | Futures | 3268.31 | 3282.7 | 3219.7 | 3225.45 | 235185.0 |
| 2012-09-25 | YM | Futures | 13173.8 | 13229.5 | 13071.3 | 13089.9 | 127444.0 |
| 2012-09-25 | CL | Futures | 166.24 | 168.21 | 163.46 | 164.91 | 239024.0 |
| 2012-09-25 | GC | Futures | 2358.1 | 2373.7 | 2351.2 | 2358.4 | 157676.0 |
| 2012-09-25 | ZN | Futures | 116.88996 | 117.123438 | 116.670216 | 117.054768 | 896614.0 |
| 2012-09-25 | A6 | Futures | 0.94071 | 0.94398 | 0.93644 | 0.93862 | 111465.0 |
| 2012-09-25 | AD | Futures | 1.02396 | 1.02687 | 1.02115 | 1.02245 | 74846.0 |
| 2012-09-25 | B | Futures | 100.13 | 101.55 | 99.72 | 100.5 | 145142.0 |
| 2012-09-25 | B6 | Futures | 1.6939 | 1.6985 | 1.6896 | 1.6926 | 97700.0 |
| 2012-09-25 | BR | Futures | 0.23733 | 0.23733 | 0.23733 | 0.23733 | 64.0 |
| 2012-09-25 | BZ | Futures | 104.94 | 105.3 | 104.29 | 104.29 | 3098.0 |
| 2012-09-25 | C | Futures | 1604.0 | 1620.0 | 1591.0 | 1620.0 | 8341.0 |
| 2012-09-25 | CC | Futures | 1856.0 | 1894.0 | 1839.0 | 1873.0 | 11044.0 |
| 2012-09-25 | CSC | Futures | 4.082 | 4.084 | 4.082 | 4.084 | 3.0 |
| 2012-09-25 | CT | Futures | 93.97 | 94.96 | 93.26 | 93.34 | 13948.0 |
| 2012-09-25 | DC | Futures | 30.05 | 30.95 | 29.93 | 30.82 | 211.0 |
| 2012-09-25 | DX | Futures | 77.058 | 77.252 | 76.884 | 77.109 | 16292.0 |
| 2012-09-25 | E1 | Futures | 1.3775 | 1.38162 | 1.37325 | 1.37673 | 29496.0 |
| 2012-09-25 | E6 | Futures | 1.52426 | 1.52885 | 1.51884 | 1.52355 | 256749.0 |
| 2012-09-25 | E7 | Futures | 1.517 | 1.5197 | 1.5098 | 1.5144 | 5193.0 |
| 2012-09-25 | ED | Futures | 95.211 | 95.2157 | 95.1966 | 95.211 | 197824.0 |
| 2012-09-25 | ER | Futures | 97.891 | 97.896 | 97.862 | 97.866 | 137973.0 |
| 2012-09-25 | EW | Futures | 1021.4 | 1026.3 | 1004.1 | 1007.2 | 26005.0 |
| 2012-09-25 | FBTP | Futures | 70.96 | 70.98 | 70.6 | 70.79 | 15917.0 |
| 2012-09-25 | FBTS | Futures | 89.198 | 89.206 | 89.039 | 89.114 | 1624.0 |
| 2012-09-25 | FCE | Futures | 2619.0 | 2633.9 | 2597.3 | 2627.9 | 88578.0 |
| 2012-09-25 | FDAX | Futures | 8144.9 | 8154.7 | 8053.9 | 8135.6 | 105304.0 |
| 2012-09-25 | FESX | Futures | 1740.3 | 1747.8 | 1721.9 | 1743.0 | 907438.0 |
| 2012-09-25 | FEU3 | Futures | 98.502 | 98.502 | 98.487 | 98.487 | 105.0 |
| 2012-09-25 | FGBL | Futures | 117.35 | 117.8 | 116.97 | 117.06 | 828934.0 |
| 2012-09-25 | FGBM | Futures | 115.93 | 116.15 | 115.66 | 115.7 | 493095.0 |
| 2012-09-25 | FGBS | Futures | 110.333 | 110.358 | 110.258 | 110.263 | 363731.0 |
| 2012-09-25 | FGBX | Futures | 122.86 | 124.03 | 122.38 | 122.55 | 9823.0 |
| 2012-09-25 | FOAT | Futures | 102.3 | 102.5 | 102.13 | 102.16 | 20277.0 |
| 2012-09-25 | FTDX | Futures | 767.9 | 767.9 | 764.6 | 767.4 | 43.0 |
| 2012-09-25 | FTI | Futures | 283.78 | 285.96 | 282.38 | 285.53 | 21783.0 |
| 2012-09-25 | FTUK | Futures | 4256.7 | 4275.0 | 4229.2 | 4270.2 | 57340.0 |
| 2012-09-25 | FVSA | Futures | 5376.86 | 5376.86 | 5242.44 | 5242.44 | 2679.0 |
| 2012-09-25 | FXXP | Futures | 197.5 | 198.7 | 197.3 | 198.4 | 2370.0 |
| 2012-09-25 | G | Futures | 98.81 | 99.06 | 98.55 | 98.61 | 163343.0 |
| 2012-09-25 | GF | Futures | 287.15 | 287.199 | 282.429 | 282.624 | 4119.0 |
| 2012-09-25 | GSCI | Futures | 1071.31 | 1071.31 | 1059.21 | 1060.5 | 137.0 |
| 2012-09-25 | HE | Futures | 93.877 | 94.312 | 92.727 | 92.789 | 16317.0 |
| 2012-09-25 | HG | Futures | 4.8049 | 4.8628 | 4.7889 | 4.83 | 45500.0 |
| 2012-09-25 | HH | Futures | 39.593 | 39.593 | 39.593 | 39.593 | 1.0 |
| 2012-09-25 | HO | Futures | 2.4968 | 2.5267 | 2.4938 | 2.507 | 33502.0 |
| 2012-09-25 | HRC | Futures | 2475.7 | 2475.7 | 2475.7 | 2475.7 | 0.0 |
| 2012-09-25 | J1 | Futures | 0.0160897 | 0.0161335 | 0.0160709 | 0.0161109 | 72596.0 |
| 2012-09-25 | J7 | Futures | 0.016027 | 0.016065 | 0.016002 | 0.016043 | 418.0 |
> showing 50 of 98 rows — these rows as CSV