PREVIEW / futures_daily / 2010-04-29
file: by_date/futures_daily/2010/2010-04-29.parquet size: 9 KB rows: 89
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 |
|---|---|---|---|---|---|---|---|
| 2010-04-29 | ES | Futures | 1158.81 | 1174.63 | 1156.86 | 1173.66 | 1980761.0 |
| 2010-04-29 | NQ | Futures | 2275.11 | 2318.78 | 2274.26 | 2315.38 | 294958.0 |
| 2010-04-29 | YM | Futures | 10123.9 | 10248.9 | 10108.3 | 10236.0 | 128671.0 |
| 2010-04-29 | CL | Futures | 192.68 | 198.0 | 191.94 | 196.94 | 393689.0 |
| 2010-04-29 | GC | Futures | 1599.0 | 1607.7 | 1594.6 | 1603.6 | 109655.0 |
| 2010-04-29 | ZN | Futures | 95.550233 | 95.869074 | 95.422696 | 95.85632 | 982373.0 |
| 2010-04-29 | A6 | Futures | 0.75546 | 0.75882 | 0.75308 | 0.75735 | 84044.0 |
| 2010-04-29 | AD | Futures | 0.97778 | 0.98597 | 0.976 | 0.98103 | 74957.0 |
| 2010-04-29 | B | Futures | 77.05 | 78.39 | 76.79 | 77.76 | 102357.0 |
| 2010-04-29 | B6 | Futures | 1.5778 | 1.5927 | 1.572 | 1.5917 | 126637.0 |
| 2010-04-29 | BFX | Futures | 2830.0 | 2888.2 | 2816.2 | 2882.8 | 133.0 |
| 2010-04-29 | BR | Futures | 0.23499 | 0.23499 | 0.23499 | 0.23499 | 68.0 |
| 2010-04-29 | BZ | Futures | 81.83 | 81.83 | 81.83 | 81.83 | 2.0 |
| 2010-04-29 | C | Futures | 2359.0 | 2379.0 | 2357.0 | 2376.0 | 2691.0 |
| 2010-04-29 | CB | Futures | 80.439 | 81.426 | 80.439 | 81.426 | 2.0 |
| 2010-04-29 | CC | Futures | 2688.0 | 2701.0 | 2681.0 | 2697.0 | 6556.0 |
| 2010-04-29 | CT | Futures | 67.42 | 67.96 | 65.97 | 66.21 | 12396.0 |
| 2010-04-29 | DC | Futures | 22.87 | 23.07 | 22.79 | 22.9 | 119.0 |
| 2010-04-29 | DX | Futures | 83.582 | 83.643 | 83.131 | 83.259 | 21280.0 |
| 2010-04-29 | E1 | Futures | 1.2134 | 1.21853 | 1.21155 | 1.21577 | 50288.0 |
| 2010-04-29 | E6 | Futures | 1.56284 | 1.57112 | 1.55989 | 1.56698 | 360330.0 |
| 2010-04-29 | E7 | Futures | 1.5509 | 1.5584 | 1.5473 | 1.5541 | 5467.0 |
| 2010-04-29 | EBM | Futures | 216.71 | 218.35 | 216.3 | 217.12 | 2333.0 |
| 2010-04-29 | ED | Futures | 94.3186 | 94.3471 | 94.3186 | 94.3234 | 285052.0 |
| 2010-04-29 | ER | Futures | 97.272 | 97.316 | 97.272 | 97.306 | 218577.0 |
| 2010-04-29 | EW | Futures | 808.4 | 818.7 | 805.0 | 817.4 | 27515.0 |
| 2010-04-29 | FBTP | Futures | 63.65 | 64.14 | 63.59 | 64.06 | 10220.0 |
| 2010-04-29 | FCE | Futures | 2401.0 | 2452.5 | 2396.8 | 2441.2 | 149321.0 |
| 2010-04-29 | FDAX | Futures | 6617.6 | 6712.8 | 6615.5 | 6693.2 | 171881.0 |
| 2010-04-29 | FESX | Futures | 1659.0 | 1699.4 | 1658.4 | 1691.4 | 1613005.0 |
| 2010-04-29 | FEU3 | Futures | 97.855 | 97.864 | 97.85 | 97.864 | 678.0 |
| 2010-04-29 | FGBL | Futures | 97.36 | 97.36 | 96.95 | 97.11 | 951400.0 |
| 2010-04-29 | FGBM | Futures | 102.74 | 102.76 | 102.53 | 102.61 | 524210.0 |
| 2010-04-29 | FGBS | Futures | 106.811 | 106.84 | 106.742 | 106.777 | 585882.0 |
| 2010-04-29 | FGBX | Futures | 94.2 | 94.38 | 93.3 | 93.66 | 5474.0 |
| 2010-04-29 | FTDX | Futures | 707.5 | 714.6 | 704.9 | 711.5 | 651.0 |
| 2010-04-29 | FTI | Futures | 278.43 | 281.76 | 276.15 | 281.76 | 16717.0 |
| 2010-04-29 | FTUK | Futures | 3765.0 | 3791.7 | 3749.1 | 3786.9 | 115210.0 |
| 2010-04-29 | G | Futures | 76.72 | 76.8 | 76.48 | 76.59 | 80989.0 |
| 2010-04-29 | GF | Futures | 291.207 | 292.954 | 290.689 | 291.271 | 1054.0 |
| 2010-04-29 | GSCI | Futures | 986.53 | 993.07 | 985.62 | 987.26 | 316.0 |
| 2010-04-29 | HE | Futures | 106.672 | 107.709 | 106.214 | 106.916 | 1749.0 |
| 2010-04-29 | HG | Futures | 4.6197 | 4.6346 | 4.5274 | 4.5498 | 30049.0 |
| 2010-04-29 | HO | Futures | 2.0525 | 2.0935 | 2.0482 | 2.0764 | 57352.0 |
| 2010-04-29 | J1 | Futures | 0.0133614 | 0.0134029 | 0.0133438 | 0.0133777 | 72257.0 |
| 2010-04-29 | J7 | Futures | 0.01328 | 0.013293 | 0.013239 | 0.013271 | 111.0 |
| 2010-04-29 | KC | Futures | 339.94 | 342.74 | 338.17 | 341.72 | 9817.0 |
| 2010-04-29 | KE | Futures | 2181.34 | 2259.59 | 2179.16 | 2206.34 | 11595.0 |
| 2010-04-29 | L | Futures | 97.799 | 97.819 | 97.789 | 97.809 | 53604.0 |
| 2010-04-29 | LBS | Futures | 946.0 | 948.2 | 935.6 | 947.3 | 467.0 |
> showing 50 of 89 rows — these rows as CSV