PREVIEW / futures_daily / 2011-05-23
file: by_date/futures_daily/2011/2011-05-23.parquet size: 9 KB rows: 94
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 |
|---|---|---|---|---|---|---|---|
| 2011-05-23 | ES | Futures | 1312.75 | 1313.74 | 1297.66 | 1302.11 | 2050172.0 |
| 2011-05-23 | NQ | Futures | 2666.7 | 2668.13 | 2624.28 | 2637.09 | 247592.0 |
| 2011-05-23 | YM | Futures | 11703.3 | 11709.9 | 11574.5 | 11622.5 | 116413.0 |
| 2011-05-23 | CL | Futures | 191.5 | 192.19 | 185.14 | 187.69 | 296828.0 |
| 2011-05-23 | GC | Futures | 2047.6 | 2056.0 | 2035.3 | 2051.1 | 191248.0 |
| 2011-05-23 | ZN | Futures | 103.554885 | 104.002604 | 103.554885 | 103.660231 | 1258662.0 |
| 2011-05-23 | A6 | Futures | 0.91102 | 0.91111 | 0.89627 | 0.9003 | 141207.0 |
| 2011-05-23 | AD | Futures | 1.02161 | 1.02201 | 1.01445 | 1.01893 | 71257.0 |
| 2011-05-23 | B | Futures | 95.15 | 95.24 | 92.15 | 93.44 | 185962.0 |
| 2011-05-23 | B6 | Futures | 1.6854 | 1.6861 | 1.6706 | 1.6739 | 114345.0 |
| 2011-05-23 | BFX | Futures | 3200.9 | 3200.9 | 3147.1 | 3155.0 | 164.0 |
| 2011-05-23 | BR | Futures | 0.26875 | 0.26875 | 0.26875 | 0.26875 | 137.0 |
| 2011-05-23 | BZ | Futures | 97.92 | 98.71 | 97.92 | 98.46 | 423.0 |
| 2011-05-23 | C | Futures | 1968.0 | 1974.0 | 1947.0 | 1949.0 | 7679.0 |
| 2011-05-23 | CB | Futures | 116.162 | 117.532 | 116.162 | 117.532 | 4.0 |
| 2011-05-23 | CC | Futures | 2299.0 | 2313.0 | 2278.0 | 2281.0 | 8314.0 |
| 2011-05-23 | CSC | Futures | 4.536 | 4.536 | 4.536 | 4.536 | 2.0 |
| 2011-05-23 | CT | Futures | 154.25 | 155.86 | 151.64 | 152.31 | 3965.0 |
| 2011-05-23 | DC | Futures | 31.16 | 31.5 | 30.72 | 30.79 | 7.0 |
| 2011-05-23 | DX | Futures | 75.466 | 76.158 | 75.447 | 75.854 | 38456.0 |
| 2011-05-23 | E1 | Futures | 1.49061 | 1.49559 | 1.47975 | 1.48354 | 33857.0 |
| 2011-05-23 | E6 | Futures | 1.67369 | 1.67475 | 1.65391 | 1.66469 | 407144.0 |
| 2011-05-23 | E7 | Futures | 1.6619 | 1.6679 | 1.6416 | 1.6523 | 8636.0 |
| 2011-05-23 | ED | Futures | 94.9502 | 94.9525 | 94.943 | 94.9478 | 113.0 |
| 2011-05-23 | ER | Futures | 97.272 | 97.296 | 97.262 | 97.286 | 106758.0 |
| 2011-05-23 | EW | Futures | 975.7 | 976.7 | 962.2 | 964.8 | 25571.0 |
| 2011-05-23 | FBTP | Futures | 64.8 | 64.89 | 64.41 | 64.78 | 9884.0 |
| 2011-05-23 | FCE | Futures | 2716.6 | 2719.0 | 2687.1 | 2695.4 | 141021.0 |
| 2011-05-23 | FDAX | Futures | 7688.4 | 7690.5 | 7589.1 | 7623.3 | 143635.0 |
| 2011-05-23 | FESX | Futures | 1800.4 | 1800.4 | 1779.9 | 1788.9 | 1517599.0 |
| 2011-05-23 | FEU3 | Futures | 97.825 | 97.835 | 97.825 | 97.83 | 35.0 |
| 2011-05-23 | FGBL | Futures | 99.96 | 100.28 | 99.92 | 100.16 | 939449.0 |
| 2011-05-23 | FGBM | Futures | 104.23 | 104.47 | 104.15 | 104.36 | 589013.0 |
| 2011-05-23 | FGBS | Futures | 106.622 | 106.751 | 106.598 | 106.717 | 783437.0 |
| 2011-05-23 | FGBX | Futures | 96.96 | 97.65 | 96.96 | 97.47 | 4026.0 |
| 2011-05-23 | FTDX | Futures | 797.5 | 812.7 | 796.7 | 802.0 | 615.0 |
| 2011-05-23 | FTI | Futures | 283.49 | 283.49 | 280.41 | 281.07 | 37696.0 |
| 2011-05-23 | FTUK | Futures | 4143.8 | 4147.6 | 4062.6 | 4079.8 | 114556.0 |
| 2011-05-23 | FXXP | Futures | 184.0 | 185.1 | 182.6 | 183.7 | 7753.0 |
| 2011-05-23 | G | Futures | 84.14 | 84.28 | 84.06 | 84.12 | 156701.0 |
| 2011-05-23 | GF | Futures | 290.736 | 290.736 | 285.274 | 285.274 | 11.0 |
| 2011-05-23 | GSCI | Futures | 1054.33 | 1062.94 | 1051.28 | 1059.03 | 181.0 |
| 2011-05-23 | HE | Futures | 96.893 | 96.893 | 94.219 | 94.511 | 250.0 |
| 2011-05-23 | HG | Futures | 5.4497 | 5.461 | 5.2485 | 5.3029 | 43087.0 |
| 2011-05-23 | HO | Futures | 2.3766 | 2.3766 | 2.3296 | 2.3422 | 6132.0 |
| 2011-05-23 | HRC | Futures | 3077.0 | 3077.0 | 3077.0 | 3077.0 | 0.0 |
| 2011-05-23 | J1 | Futures | 0.0153672 | 0.0154501 | 0.0153094 | 0.0153345 | 103233.0 |
| 2011-05-23 | J7 | Futures | 0.015283 | 0.015353 | 0.015221 | 0.015241 | 15.0 |
| 2011-05-23 | JB | Futures | 122.69 | 122.74 | 122.56 | 122.68 | 1762.0 |
| 2011-05-23 | KC | Futures | 621.44 | 634.63 | 620.84 | 629.59 | 8577.0 |
> showing 50 of 94 rows — these rows as CSV