PREVIEW / futures_daily / 2012-06-04
file: by_date/futures_daily/2012/2012-06-04.parquet size: 9 KB rows: 95
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-06-04 | ES | Futures | 1284.84 | 1291.39 | 1271.74 | 1282.82 | 2338973.0 |
| 2012-06-04 | NQ | Futures | 2818.47 | 2841.67 | 2788.4 | 2828.78 | 283657.0 |
| 2012-06-04 | YM | Futures | 11771.0 | 11798.2 | 11655.3 | 11731.1 | 150519.0 |
| 2012-06-04 | CL | Futures | 152.04 | 154.64 | 148.83 | 153.91 | 309777.0 |
| 2012-06-04 | GC | Futures | 2174.7 | 2178.6 | 2152.2 | 2157.5 | 135236.0 |
| 2012-06-04 | ZN | Futures | 117.536747 | 117.699202 | 116.954613 | 116.968151 | 55905.0 |
| 2012-06-04 | A6 | Futures | 0.87184 | 0.87571 | 0.86509 | 0.87373 | 130078.0 |
| 2012-06-04 | AD | Futures | 0.96748 | 0.96999 | 0.96265 | 0.96728 | 107601.0 |
| 2012-06-04 | B | Futures | 88.9 | 89.62 | 86.45 | 89.32 | 72342.0 |
| 2012-06-04 | B6 | Futures | 1.613 | 1.6179 | 1.6102 | 1.6145 | 65087.0 |
| 2012-06-04 | BFX | Futures | 2495.1 | 2510.0 | 2495.1 | 2503.4 | 129.0 |
| 2012-06-04 | BR | Futures | 0.23086 | 0.23086 | 0.22914 | 0.22937 | 145.0 |
| 2012-06-04 | BZ | Futures | 93.01 | 95.19 | 92.96 | 94.96 | 1907.0 |
| 2012-06-04 | CB | Futures | 80.734 | 80.734 | 80.734 | 80.734 | 1.0 |
| 2012-06-04 | CC | Futures | 1555.0 | 1585.0 | 1530.0 | 1581.0 | 14235.0 |
| 2012-06-04 | CSC | Futures | 3.547 | 3.554 | 3.547 | 3.547 | 21.0 |
| 2012-06-04 | CT | Futures | 83.91 | 84.48 | 80.86 | 83.84 | 15999.0 |
| 2012-06-04 | DC | Futures | 25.36 | 25.66 | 25.05 | 25.26 | 66.0 |
| 2012-06-04 | DX | Futures | 80.306 | 80.563 | 79.977 | 80.089 | 26976.0 |
| 2012-06-04 | E1 | Futures | 1.35482 | 1.36438 | 1.3505 | 1.36202 | 38134.0 |
| 2012-06-04 | E6 | Futures | 1.48443 | 1.4935 | 1.47858 | 1.49136 | 238948.0 |
| 2012-06-04 | E7 | Futures | 1.4698 | 1.4793 | 1.4645 | 1.4771 | 2426.0 |
| 2012-06-04 | ED | Futures | 95.0621 | 95.0669 | 95.0621 | 95.0645 | 48414.0 |
| 2012-06-04 | ER | Futures | 97.577 | 97.587 | 97.562 | 97.567 | 39068.0 |
| 2012-06-04 | EW | Futures | 905.5 | 909.9 | 890.7 | 897.1 | 26595.0 |
| 2012-06-04 | FBTP | Futures | 65.8 | 66.94 | 65.64 | 66.9 | 17247.0 |
| 2012-06-04 | FBTS | Futures | 83.744 | 84.037 | 83.72 | 84.013 | 2581.0 |
| 2012-06-04 | FCE | Futures | 2139.2 | 2193.4 | 2138.1 | 2169.5 | 93835.0 |
| 2012-06-04 | FDAX | Futures | 6610.6 | 6668.0 | 6568.6 | 6610.0 | 162518.0 |
| 2012-06-04 | FESX | Futures | 1406.6 | 1445.3 | 1404.6 | 1432.9 | 930699.0 |
| 2012-06-04 | FEU3 | Futures | 98.147 | 98.147 | 98.137 | 98.142 | 207.0 |
| 2012-06-04 | FGBL | Futures | 119.97 | 119.99 | 119.41 | 119.53 | 755352.0 |
| 2012-06-04 | FGBM | Futures | 116.43 | 116.48 | 116.26 | 116.31 | 529985.0 |
| 2012-06-04 | FGBS | Futures | 110.392 | 110.417 | 110.382 | 110.387 | 479607.0 |
| 2012-06-04 | FGBX | Futures | 135.65 | 135.67 | 134.18 | 134.32 | 16765.0 |
| 2012-06-04 | FOAT | Futures | 100.92 | 100.96 | 100.33 | 100.61 | 10170.0 |
| 2012-06-04 | FTDX | Futures | 674.1 | 674.1 | 660.0 | 667.5 | 2666.0 |
| 2012-06-04 | FTI | Futures | 243.18 | 247.73 | 242.83 | 245.43 | 25829.0 |
| 2012-06-04 | FVSA | Futures | 11727.85 | 11727.85 | 11321.28 | 11430.74 | 849.0 |
| 2012-06-04 | FXXP | Futures | 168.9 | 170.4 | 168.9 | 169.4 | 2713.0 |
| 2012-06-04 | GF | Futures | 310.841 | 313.752 | 309.657 | 312.765 | 3069.0 |
| 2012-06-04 | GSCI | Futures | 917.04 | 929.18 | 914.18 | 927.67 | 710.0 |
| 2012-06-04 | HE | Futures | 96.424 | 97.003 | 95.319 | 95.845 | 21112.0 |
| 2012-06-04 | HG | Futures | 4.3394 | 4.3911 | 4.2405 | 4.3309 | 65442.0 |
| 2012-06-04 | HO | Futures | 2.1703 | 2.1712 | 2.1186 | 2.1649 | 11211.0 |
| 2012-06-04 | HRC | Futures | 2510.2 | 2510.2 | 2510.2 | 2510.2 | 0.0 |
| 2012-06-04 | J1 | Futures | 0.0160598 | 0.0160811 | 0.0159821 | 0.0160084 | 75541.0 |
| 2012-06-04 | J7 | Futures | 0.015998 | 0.016005 | 0.015908 | 0.015933 | 328.0 |
| 2012-06-04 | JB | Futures | 126.33 | 126.56 | 126.12 | 126.14 | 3964.0 |
| 2012-06-04 | KC | Futures | 355.95 | 358.32 | 348.63 | 357.19 | 12422.0 |
> showing 50 of 95 rows — these rows as CSV