PREVIEW / futures_daily / 2012-03-22
file: by_date/futures_daily/2012/2012-03-22.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-03-22 | ES | Futures | 1408.54 | 1411.56 | 1393.17 | 1399.72 | 1682418.0 |
| 2012-03-22 | NQ | Futures | 3133.26 | 3140.13 | 3111.2 | 3129.25 | 233139.0 |
| 2012-03-22 | YM | Futures | 12710.4 | 12730.9 | 12591.8 | 12643.3 | 117678.0 |
| 2012-03-22 | CL | Futures | 196.9 | 197.47 | 192.64 | 194.2 | 295474.0 |
| 2012-03-22 | GC | Futures | 2209.0 | 2218.4 | 2179.4 | 2199.5 | 175716.0 |
| 2012-03-22 | ZN | Futures | 111.363427 | 111.742491 | 111.255124 | 111.539421 | 1151317.0 |
| 2012-03-22 | A6 | Futures | 0.93104 | 0.9341 | 0.92087 | 0.92447 | 152527.0 |
| 2012-03-22 | AD | Futures | 1.01215 | 1.01306 | 1.0033 | 1.0038 | 98863.0 |
| 2012-03-22 | B | Futures | 111.44 | 111.63 | 109.88 | 110.63 | 182752.0 |
| 2012-03-22 | B6 | Futures | 1.6645 | 1.6671 | 1.6542 | 1.6593 | 81533.0 |
| 2012-03-22 | BFX | Futures | 2838.1 | 2838.1 | 2832.2 | 2832.2 | 6.0 |
| 2012-03-22 | BR | Futures | 0.25788 | 0.25788 | 0.25788 | 0.25788 | 1.0 |
| 2012-03-22 | BZ | Futures | 118.57 | 118.72 | 116.89 | 117.68 | 567.0 |
| 2012-03-22 | C | Futures | 1506.0 | 1520.0 | 1477.0 | 1481.0 | 4806.0 |
| 2012-03-22 | CB | Futures | 82.618 | 82.618 | 82.349 | 82.618 | 11.0 |
| 2012-03-22 | CC | Futures | 1781.0 | 1791.0 | 1734.0 | 1739.0 | 12009.0 |
| 2012-03-22 | CSC | Futures | 3.655 | 3.655 | 3.611 | 3.616 | 19.0 |
| 2012-03-22 | CT | Futures | 110.76 | 112.31 | 110.19 | 112.11 | 11156.0 |
| 2012-03-22 | DC | Futures | 26.04 | 26.17 | 25.32 | 25.5 | 208.0 |
| 2012-03-22 | DX | Futures | 77.288 | 77.7 | 77.172 | 77.509 | 21839.0 |
| 2012-03-22 | E1 | Futures | 1.43639 | 1.44123 | 1.42774 | 1.43311 | 35314.0 |
| 2012-03-22 | E6 | Futures | 1.57814 | 1.58304 | 1.56859 | 1.57432 | 243903.0 |
| 2012-03-22 | E7 | Futures | 1.5625 | 1.5679 | 1.5535 | 1.5592 | 3856.0 |
| 2012-03-22 | EBM | Futures | 280.64 | 284.01 | 279.29 | 283.34 | 8976.0 |
| 2012-03-22 | ED | Futures | 95.0597 | 95.0597 | 95.0406 | 95.0549 | 125492.0 |
| 2012-03-22 | ER | Futures | 97.557 | 97.567 | 97.538 | 97.543 | 130104.0 |
| 2012-03-22 | EW | Futures | 1002.1 | 1006.2 | 985.4 | 993.4 | 25650.0 |
| 2012-03-22 | FBTP | Futures | 68.71 | 68.84 | 68.05 | 68.21 | 15597.0 |
| 2012-03-22 | FBTS | Futures | 86.332 | 86.332 | 86.088 | 86.104 | 614.0 |
| 2012-03-22 | FCE | Futures | 2496.2 | 2501.9 | 2451.2 | 2462.5 | 104543.0 |
| 2012-03-22 | FDAX | Futures | 7811.6 | 7839.3 | 7683.9 | 7734.2 | 154537.0 |
| 2012-03-22 | FESX | Futures | 1720.7 | 1726.2 | 1689.6 | 1700.6 | 1245565.0 |
| 2012-03-22 | FGBL | Futures | 111.87 | 112.55 | 111.78 | 112.41 | 899253.0 |
| 2012-03-22 | FGBM | Futures | 112.89 | 113.26 | 112.82 | 113.17 | 526486.0 |
| 2012-03-22 | FGBS | Futures | 109.76 | 109.849 | 109.735 | 109.81 | 503763.0 |
| 2012-03-22 | FGBX | Futures | 115.07 | 116.33 | 114.92 | 116.17 | 7169.0 |
| 2012-03-22 | FTDX | Futures | 727.4 | 734.0 | 725.1 | 728.4 | 88.0 |
| 2012-03-22 | FTI | Futures | 277.76 | 278.4 | 274.25 | 275.52 | 27227.0 |
| 2012-03-22 | FTUK | Futures | 4267.3 | 4271.3 | 4214.8 | 4226.8 | 108230.0 |
| 2012-03-22 | FVSA | Futures | 7866.52 | 8284.95 | 7866.52 | 8084.1 | 8452.0 |
| 2012-03-22 | FXXP | Futures | 190.7 | 190.9 | 188.5 | 189.2 | 3460.0 |
| 2012-03-22 | G | Futures | 92.3 | 92.88 | 92.29 | 92.63 | 146069.0 |
| 2012-03-22 | GF | Futures | 320.832 | 323.605 | 320.465 | 321.512 | 1797.0 |
| 2012-03-22 | GSCI | Futures | 1108.08 | 1108.08 | 1095.42 | 1100.56 | 22.0 |
| 2012-03-22 | HE | Futures | 102.871 | 103.559 | 102.844 | 103.559 | 150.0 |
| 2012-03-22 | HG | Futures | 5.0292 | 5.0567 | 4.9197 | 4.9367 | 54481.0 |
| 2012-03-22 | HO | Futures | 2.6655 | 2.6677 | 2.6192 | 2.6344 | 27072.0 |
| 2012-03-22 | HRC | Futures | 2680.3 | 2680.3 | 2680.3 | 2680.3 | 50.0 |
| 2012-03-22 | J1 | Futures | 0.0150429 | 0.0152435 | 0.0150341 | 0.0151959 | 136454.0 |
| 2012-03-22 | J7 | Futures | 0.014973 | 0.01518 | 0.014962 | 0.015124 | 952.0 |
> showing 50 of 98 rows — these rows as CSV