PREVIEW / futures_daily / 2012-10-02
file: by_date/futures_daily/2012/2012-10-02.parquet size: 9 KB rows: 97
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-02 | ES | Futures | 1462.05 | 1471.72 | 1457.72 | 1466.63 | 1610265.0 |
| 2012-10-02 | NQ | Futures | 3206.75 | 3230.63 | 3190.07 | 3216.25 | 222226.0 |
| 2012-10-02 | YM | Futures | 13118.2 | 13181.7 | 13033.2 | 13095.7 | 135663.0 |
| 2012-10-02 | CL | Futures | 166.78 | 167.74 | 165.36 | 165.84 | 177728.0 |
| 2012-10-02 | GC | Futures | 2376.5 | 2385.4 | 2366.3 | 2370.7 | 119797.0 |
| 2012-10-02 | ZN | Futures | 117.398117 | 117.507989 | 117.247044 | 117.466787 | 645787.0 |
| 2012-10-02 | A6 | Futures | 0.93517 | 0.93671 | 0.92562 | 0.92581 | 161196.0 |
| 2012-10-02 | AD | Futures | 1.02015 | 1.02105 | 1.01764 | 1.01804 | 70209.0 |
| 2012-10-02 | B | Futures | 102.36 | 102.36 | 101.31 | 101.57 | 132768.0 |
| 2012-10-02 | B6 | Futures | 1.6843 | 1.6904 | 1.6838 | 1.6854 | 88267.0 |
| 2012-10-02 | BFX | Futures | 2885.1 | 2892.9 | 2883.7 | 2884.3 | 14.0 |
| 2012-10-02 | BR | Futures | 0.2383 | 0.2383 | 0.2375 | 0.23774 | 66.0 |
| 2012-10-02 | BZ | Futures | 105.72 | 106.17 | 105.38 | 105.4 | 324.0 |
| 2012-10-02 | C | Futures | 1602.0 | 1625.0 | 1581.0 | 1621.0 | 6946.0 |
| 2012-10-02 | CB | Futures | 96.342 | 96.342 | 95.806 | 96.074 | 2.0 |
| 2012-10-02 | CC | Futures | 1839.0 | 1871.0 | 1819.0 | 1866.0 | 10182.0 |
| 2012-10-02 | CT | Futures | 91.88 | 92.81 | 91.19 | 92.72 | 12232.0 |
| 2012-10-02 | DC | Futures | 30.57 | 30.74 | 30.25 | 30.48 | 81.0 |
| 2012-10-02 | DX | Futures | 77.382 | 77.431 | 77.058 | 77.324 | 15254.0 |
| 2012-10-02 | E1 | Futures | 1.37364 | 1.38084 | 1.37274 | 1.37621 | 29199.0 |
| 2012-10-02 | E6 | Futures | 1.51873 | 1.52838 | 1.5179 | 1.52202 | 234486.0 |
| 2012-10-02 | E7 | Futures | 1.5095 | 1.5191 | 1.5089 | 1.5129 | 4854.0 |
| 2012-10-02 | ED | Futures | 95.2301 | 95.2396 | 95.2205 | 95.2253 | 71801.0 |
| 2012-10-02 | ER | Futures | 97.862 | 97.871 | 97.862 | 97.866 | 51569.0 |
| 2012-10-02 | EW | Futures | 999.4 | 1006.7 | 998.2 | 1005.5 | 21838.0 |
| 2012-10-02 | FBTP | Futures | 70.88 | 71.52 | 70.88 | 71.34 | 16385.0 |
| 2012-10-02 | FBTS | Futures | 89.307 | 89.541 | 89.29 | 89.449 | 3187.0 |
| 2012-10-02 | FCE | Futures | 2554.3 | 2581.6 | 2537.1 | 2553.5 | 103187.0 |
| 2012-10-02 | FDAX | Futures | 7982.2 | 8083.0 | 7963.6 | 8011.2 | 134781.0 |
| 2012-10-02 | FESX | Futures | 1685.8 | 1712.4 | 1679.7 | 1694.0 | 980989.0 |
| 2012-10-02 | FGBL | Futures | 118.39 | 118.42 | 117.93 | 118.2 | 611437.0 |
| 2012-10-02 | FGBM | Futures | 116.19 | 116.23 | 116.03 | 116.16 | 297405.0 |
| 2012-10-02 | FGBS | Futures | 110.338 | 110.353 | 110.313 | 110.333 | 212569.0 |
| 2012-10-02 | FGBX | Futures | 125.83 | 126.0 | 124.54 | 125.07 | 5759.0 |
| 2012-10-02 | FOAT | Futures | 102.98 | 103.05 | 102.81 | 102.92 | 18472.0 |
| 2012-10-02 | FTDX | Futures | 768.4 | 773.5 | 766.9 | 772.1 | 46.0 |
| 2012-10-02 | FTI | Futures | 277.6 | 280.93 | 276.75 | 279.14 | 30334.0 |
| 2012-10-02 | FTUK | Futures | 4214.2 | 4254.1 | 4209.5 | 4226.7 | 81657.0 |
| 2012-10-02 | FVSA | Futures | 5731.25 | 5804.57 | 5523.5 | 5596.82 | 2142.0 |
| 2012-10-02 | FXXP | Futures | 194.6 | 196.7 | 194.6 | 195.2 | 1240.0 |
| 2012-10-02 | G | Futures | 99.38 | 99.57 | 99.06 | 99.47 | 162038.0 |
| 2012-10-02 | GF | Futures | 281.797 | 284.084 | 281.359 | 283.013 | 1997.0 |
| 2012-10-02 | GSCI | Futures | 1073.72 | 1073.72 | 1069.29 | 1070.5 | 269.0 |
| 2012-10-02 | HE | Futures | 93.535 | 95.896 | 93.441 | 95.523 | 25967.0 |
| 2012-10-02 | HG | Futures | 4.8525 | 4.9122 | 4.8422 | 4.8846 | 39914.0 |
| 2012-10-02 | HH | Futures | 45.025 | 45.025 | 45.025 | 45.025 | 1528.0 |
| 2012-10-02 | HO | Futures | 2.5331 | 2.5428 | 2.52 | 2.5211 | 26756.0 |
| 2012-10-02 | HRC | Futures | 2443.1 | 2443.1 | 2443.1 | 2443.1 | 0.0 |
| 2012-10-02 | J1 | Futures | 0.0160634 | 0.0160684 | 0.016017 | 0.0160371 | 49623.0 |
| 2012-10-02 | J7 | Futures | 0.015989 | 0.016 | 0.01595 | 0.015969 | 309.0 |
> showing 50 of 97 rows — these rows as CSV