PREVIEW / futures_daily / 2012-05-29
file: by_date/futures_daily/2012/2012-05-29.parquet size: 9 KB rows: 100
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-05-29 | ES | Futures | 1332.2 | 1344.55 | 1327.67 | 1343.79 | 2236090.0 |
| 2012-05-29 | NQ | Futures | 2902.4 | 2944.5 | 2900.39 | 2932.47 | 289944.0 |
| 2012-05-29 | YM | Futures | 12123.1 | 12252.4 | 12101.7 | 12236.8 | 167970.0 |
| 2012-05-29 | CL | Futures | 166.77 | 168.99 | 165.4 | 166.33 | 262562.0 |
| 2012-05-29 | GC | Futures | 2106.1 | 2119.8 | 2069.4 | 2073.4 | 192847.0 |
| 2012-05-29 | ZN | Futures | 115.885113 | 116.155873 | 115.654967 | 115.952803 | 2441823.0 |
| 2012-05-29 | A6 | Futures | 0.8803 | 0.88875 | 0.87949 | 0.88399 | 204593.0 |
| 2012-05-29 | AD | Futures | 0.97895 | 0.98519 | 0.97855 | 0.98197 | 130436.0 |
| 2012-05-29 | B | Futures | 97.03 | 97.68 | 95.93 | 96.48 | 110377.0 |
| 2012-05-29 | B6 | Futures | 1.6459 | 1.6494 | 1.638 | 1.6408 | 129385.0 |
| 2012-05-29 | BFX | Futures | 2592.6 | 2601.2 | 2580.3 | 2597.0 | 58.0 |
| 2012-05-29 | BR | Futures | 0.23582 | 0.23635 | 0.23563 | 0.23635 | 3902.0 |
| 2012-05-29 | BZ | Futures | 103.78 | 103.78 | 102.36 | 102.57 | 581.0 |
| 2012-05-29 | C | Futures | 1477.0 | 1502.0 | 1471.0 | 1474.0 | 5676.0 |
| 2012-05-29 | CB | Futures | 80.075 | 80.142 | 80.062 | 80.062 | 4.0 |
| 2012-05-29 | CC | Futures | 1587.0 | 1625.0 | 1580.0 | 1591.0 | 12216.0 |
| 2012-05-29 | CSC | Futures | 3.606 | 3.606 | 3.597 | 3.597 | 30.0 |
| 2012-05-29 | CT | Futures | 90.1 | 92.15 | 88.63 | 89.06 | 13331.0 |
| 2012-05-29 | DC | Futures | 25.74 | 25.77 | 25.5 | 25.5 | 30.0 |
| 2012-05-29 | DX | Futures | 79.851 | 80.137 | 79.575 | 80.012 | 25316.0 |
| 2012-05-29 | E1 | Futures | 1.37066 | 1.37433 | 1.35888 | 1.36202 | 61631.0 |
| 2012-05-29 | E6 | Futures | 1.50055 | 1.50711 | 1.48765 | 1.49088 | 408604.0 |
| 2012-05-29 | E7 | Futures | 1.4857 | 1.4928 | 1.4735 | 1.4766 | 5253.0 |
| 2012-05-29 | ED | Futures | 95.0573 | 95.0669 | 95.0549 | 95.0621 | 112557.0 |
| 2012-05-29 | ER | Futures | 97.548 | 97.553 | 97.533 | 97.543 | 66173.0 |
| 2012-05-29 | EW | Futures | 946.9 | 958.7 | 944.9 | 957.5 | 30414.0 |
| 2012-05-29 | FBTP | Futures | 65.63 | 66.06 | 65.5 | 65.67 | 17752.0 |
| 2012-05-29 | FBTS | Futures | 84.143 | 84.265 | 83.817 | 83.98 | 4085.0 |
| 2012-05-29 | FCE | Futures | 2236.5 | 2268.6 | 2221.1 | 2256.1 | 128600.0 |
| 2012-05-29 | FDAX | Futures | 7044.4 | 7122.9 | 7002.4 | 7075.9 | 185340.0 |
| 2012-05-29 | FESX | Futures | 1488.1 | 1496.4 | 1470.8 | 1487.4 | 1201242.0 |
| 2012-05-29 | FEU3 | Futures | 98.117 | 98.117 | 98.117 | 98.117 | 125.0 |
| 2012-05-29 | FGBL | Futures | 118.26 | 118.55 | 118.09 | 118.32 | 743941.0 |
| 2012-05-29 | FGBM | Futures | 115.9 | 116.0 | 115.69 | 115.9 | 417164.0 |
| 2012-05-29 | FGBS | Futures | 110.353 | 110.378 | 110.318 | 110.333 | 288638.0 |
| 2012-05-29 | FGBX | Futures | 128.42 | 129.69 | 128.27 | 129.41 | 7611.0 |
| 2012-05-29 | FOAT | Futures | 98.55 | 98.83 | 98.52 | 98.68 | 10212.0 |
| 2012-05-29 | FTDX | Futures | 713.9 | 718.1 | 711.5 | 715.7 | 81.0 |
| 2012-05-29 | FTI | Futures | 255.31 | 257.31 | 253.62 | 255.92 | 35079.0 |
| 2012-05-29 | FTUK | Futures | 3887.5 | 3931.7 | 3884.3 | 3924.0 | 102750.0 |
| 2012-05-29 | FVSA | Futures | 10101.59 | 10304.87 | 10054.68 | 10164.14 | 1591.0 |
| 2012-05-29 | FXXP | Futures | 176.6 | 177.2 | 175.7 | 176.7 | 8090.0 |
| 2012-05-29 | G | Futures | 97.88 | 98.13 | 97.72 | 97.88 | 168570.0 |
| 2012-05-29 | GF | Futures | 313.357 | 315.183 | 310.89 | 310.989 | 4132.0 |
| 2012-05-29 | GSCI | Futures | 986.87 | 992.35 | 978.06 | 978.06 | 238.0 |
| 2012-05-29 | HE | Futures | 91.206 | 92.299 | 91.126 | 92.113 | 8897.0 |
| 2012-05-29 | HG | Futures | 4.5168 | 4.5947 | 4.5162 | 4.5339 | 90076.0 |
| 2012-05-29 | HO | Futures | 2.3261 | 2.3482 | 2.3103 | 2.3146 | 9106.0 |
| 2012-05-29 | HRC | Futures | 2550.0 | 2550.0 | 2550.0 | 2550.0 | 0.0 |
| 2012-05-29 | J1 | Futures | 0.0157413 | 0.0158203 | 0.0157363 | 0.0157727 | 86581.0 |
> showing 50 of 100 rows — these rows as CSV