PREVIEW / futures_daily / 2010-05-12
file: by_date/futures_daily/2010/2010-05-12.parquet size: 9 KB rows: 90
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-05-12 | ES | Futures | 1121.56 | 1140.55 | 1111.09 | 1139.09 | 2109839.0 |
| 2010-05-12 | NQ | Futures | 2194.84 | 2241.92 | 2174.71 | 2237.95 | 323983.0 |
| 2010-05-12 | YM | Futures | 9840.8 | 10003.5 | 9758.0 | 9998.0 | 142717.0 |
| 2010-05-12 | CL | Futures | 175.48 | 178.05 | 172.84 | 174.93 | 475847.0 |
| 2010-05-12 | GC | Futures | 1690.3 | 1713.9 | 1683.8 | 1705.6 | 205851.0 |
| 2010-05-12 | ZN | Futures | 97.246466 | 97.463278 | 96.876611 | 96.965886 | 1009049.0 |
| 2010-05-12 | A6 | Futures | 0.73117 | 0.73404 | 0.72658 | 0.72937 | 100579.0 |
| 2010-05-12 | AD | Futures | 0.96721 | 0.97225 | 0.96327 | 0.968 | 74791.0 |
| 2010-05-12 | B | Futures | 72.02 | 73.35 | 71.79 | 72.94 | 189235.0 |
| 2010-05-12 | B6 | Futures | 1.5501 | 1.5618 | 1.5381 | 1.5385 | 153182.0 |
| 2010-05-12 | BR | Futures | 0.23008 | 0.23008 | 0.23008 | 0.23008 | 114.0 |
| 2010-05-12 | BZ | Futures | 76.76 | 76.76 | 76.76 | 76.76 | 2.0 |
| 2010-05-12 | C | Futures | 2252.0 | 2290.0 | 2237.0 | 2272.0 | 21986.0 |
| 2010-05-12 | CB | Futures | 81.426 | 81.426 | 81.18 | 81.18 | 27.0 |
| 2010-05-12 | CC | Futures | 2479.0 | 2520.0 | 2472.0 | 2497.0 | 8632.0 |
| 2010-05-12 | CT | Futures | 64.18 | 65.56 | 63.82 | 63.88 | 9553.0 |
| 2010-05-12 | DC | Futures | 22.51 | 22.71 | 22.41 | 22.54 | 247.0 |
| 2010-05-12 | DX | Futures | 85.989 | 86.237 | 85.457 | 86.102 | 20387.0 |
| 2010-05-12 | E1 | Futures | 1.18391 | 1.19076 | 1.18247 | 1.18641 | 41169.0 |
| 2010-05-12 | E6 | Futures | 1.49482 | 1.50736 | 1.49139 | 1.49459 | 315250.0 |
| 2010-05-12 | E7 | Futures | 1.4836 | 1.4949 | 1.4794 | 1.4823 | 6166.0 |
| 2010-05-12 | ED | Futures | 94.2286 | 94.2665 | 94.2192 | 94.2571 | 234757.0 |
| 2010-05-12 | ER | Futures | 97.326 | 97.36 | 97.321 | 97.355 | 144420.0 |
| 2010-05-12 | EW | Futures | 774.4 | 795.0 | 767.9 | 792.6 | 32172.0 |
| 2010-05-12 | FBTP | Futures | 64.6 | 64.8 | 64.6 | 64.68 | 4123.0 |
| 2010-05-12 | FCE | Futures | 2369.6 | 2449.1 | 2368.9 | 2432.9 | 3165.0 |
| 2010-05-12 | FDAX | Futures | 6553.5 | 6772.1 | 6533.3 | 6739.5 | 244323.0 |
| 2010-05-12 | FESX | Futures | 1638.2 | 1690.8 | 1627.8 | 1677.4 | 2135663.0 |
| 2010-05-12 | FEU3 | Futures | 97.899 | 97.914 | 97.899 | 97.914 | 757.0 |
| 2010-05-12 | FGBL | Futures | 98.24 | 98.29 | 97.89 | 98.07 | 835463.0 |
| 2010-05-12 | FGBM | Futures | 103.84 | 103.9 | 103.67 | 103.78 | 418882.0 |
| 2010-05-12 | FGBS | Futures | 107.256 | 107.29 | 107.192 | 107.256 | 559576.0 |
| 2010-05-12 | FGBX | Futures | 93.71 | 94.02 | 93.14 | 93.88 | 5098.0 |
| 2010-05-12 | FTDX | Futures | 679.2 | 713.7 | 674.4 | 698.7 | 1012.0 |
| 2010-05-12 | FTI | Futures | 258.26 | 266.08 | 258.18 | 264.86 | 467.0 |
| 2010-05-12 | FTUK | Futures | 3573.1 | 3653.3 | 3560.6 | 3627.9 | 147497.0 |
| 2010-05-12 | G | Futures | 77.82 | 78.14 | 77.69 | 78.02 | 113565.0 |
| 2010-05-12 | GF | Futures | 291.77 | 292.276 | 289.307 | 289.939 | 2346.0 |
| 2010-05-12 | GSCI | Futures | 911.17 | 914.47 | 902.99 | 909.6 | 5045.0 |
| 2010-05-12 | HE | Futures | 107.254 | 108.102 | 106.72 | 107.662 | 20120.0 |
| 2010-05-12 | HG | Futures | 4.3081 | 4.4052 | 4.2571 | 4.3291 | 31237.0 |
| 2010-05-12 | HO | Futures | 1.9426 | 1.9795 | 1.9359 | 1.9678 | 51097.0 |
| 2010-05-12 | HRC | Futures | 3153.1 | 3153.1 | 3153.1 | 3153.1 | 0.0 |
| 2010-05-12 | J1 | Futures | 0.0135701 | 0.0136053 | 0.0134821 | 0.0134934 | 100603.0 |
| 2010-05-12 | J7 | Futures | 0.013478 | 0.013493 | 0.013376 | 0.013386 | 128.0 |
| 2010-05-12 | JB | Futures | 118.82 | 118.91 | 118.69 | 118.85 | 2159.0 |
| 2010-05-12 | KC | Futures | 345.02 | 351.88 | 344.13 | 347.43 | 12634.0 |
| 2010-05-12 | KE | Futures | 2211.77 | 2278.07 | 2197.64 | 2204.16 | 8490.0 |
| 2010-05-12 | KRW | Futures | 0.0008551 | 0.0008551 | 0.0008551 | 0.0008551 | 23.0 |
| 2010-05-12 | L | Futures | 97.76 | 97.809 | 97.75 | 97.799 | 49672.0 |
> showing 50 of 90 rows — these rows as CSV