PREVIEW / futures_daily / 2010-06-30
file: by_date/futures_daily/2010/2010-06-30.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-06-30 | ES | Futures | 1009.73 | 1018.76 | 997.79 | 1001.2 | 2622061.0 |
| 2010-06-30 | NQ | Futures | 1996.54 | 2011.82 | 1961.45 | 1967.11 | 370543.0 |
| 2010-06-30 | YM | Futures | 9061.9 | 9124.8 | 8960.2 | 8983.3 | 166321.0 |
| 2010-06-30 | CL | Futures | 161.17 | 164.09 | 158.88 | 161.53 | 357752.0 |
| 2010-06-30 | GC | Futures | 1693.6 | 1703.4 | 1684.8 | 1699.5 | 110717.0 |
| 2010-06-30 | ZN | Futures | 100.529203 | 100.682878 | 100.19624 | 100.439559 | 1143229.0 |
| 2010-06-30 | A6 | Futures | 0.69789 | 0.70394 | 0.69043 | 0.69408 | 124917.0 |
| 2010-06-30 | AD | Futures | 0.93582 | 0.94313 | 0.92693 | 0.92861 | 109972.0 |
| 2010-06-30 | B | Futures | 65.82 | 66.93 | 64.93 | 65.82 | 103986.0 |
| 2010-06-30 | B6 | Futures | 1.5633 | 1.5645 | 1.5499 | 1.5521 | 136142.0 |
| 2010-06-30 | BFX | Futures | 2718.1 | 2739.7 | 2708.8 | 2720.1 | 60.0 |
| 2010-06-30 | BZ | Futures | 70.68 | 70.68 | 69.43 | 70.34 | 94.0 |
| 2010-06-30 | C | Futures | 2524.0 | 2542.0 | 2479.0 | 2487.0 | 26326.0 |
| 2010-06-30 | CB | Futures | 82.57 | 82.811 | 82.57 | 82.811 | 5.0 |
| 2010-06-30 | CC | Futures | 2497.0 | 2510.0 | 2450.0 | 2455.0 | 12652.0 |
| 2010-06-30 | CSC | Futures | 3.68 | 3.68 | 3.68 | 3.68 | 1.0 |
| 2010-06-30 | CT | Futures | 66.67 | 66.67 | 65.7 | 66.3 | 167.0 |
| 2010-06-30 | DC | Futures | 22.45 | 22.82 | 22.42 | 22.69 | 202.0 |
| 2010-06-30 | DX | Futures | 87.165 | 87.255 | 86.555 | 86.964 | 17891.0 |
| 2010-06-30 | E1 | Futures | 1.21588 | 1.22336 | 1.21167 | 1.22074 | 40010.0 |
| 2010-06-30 | E6 | Futures | 1.44241 | 1.45577 | 1.43933 | 1.44832 | 345791.0 |
| 2010-06-30 | E7 | Futures | 1.4318 | 1.4451 | 1.4291 | 1.4379 | 4415.0 |
| 2010-06-30 | ED | Futures | 94.2759 | 94.2996 | 94.2664 | 94.2854 | 167484.0 |
| 2010-06-30 | ER | Futures | 97.316 | 97.33 | 97.272 | 97.276 | 288181.0 |
| 2010-06-30 | EW | Futures | 699.1 | 710.1 | 692.2 | 695.3 | 40474.0 |
| 2010-06-30 | FBTP | Futures | 64.71 | 64.87 | 64.62 | 64.81 | 3881.0 |
| 2010-06-30 | FCE | Futures | 2259.9 | 2281.9 | 2227.0 | 2264.8 | 169869.0 |
| 2010-06-30 | FDAX | Futures | 6491.4 | 6537.1 | 6421.2 | 6485.4 | 147551.0 |
| 2010-06-30 | FESX | Futures | 1579.5 | 1605.5 | 1564.1 | 1589.5 | 1592228.0 |
| 2010-06-30 | FEU3 | Futures | 97.869 | 97.869 | 97.835 | 97.835 | 73.0 |
| 2010-06-30 | FGBL | Futures | 101.23 | 101.28 | 100.92 | 101.06 | 795326.0 |
| 2010-06-30 | FGBM | Futures | 105.65 | 105.68 | 105.42 | 105.53 | 441192.0 |
| 2010-06-30 | FGBS | Futures | 107.726 | 107.745 | 107.583 | 107.618 | 613554.0 |
| 2010-06-30 | FGBX | Futures | 100.6 | 101.22 | 100.32 | 100.71 | 4089.0 |
| 2010-06-30 | FTDX | Futures | 650.5 | 656.2 | 643.0 | 648.3 | 774.0 |
| 2010-06-30 | FTI | Futures | 253.19 | 253.9 | 247.44 | 250.73 | 46098.0 |
| 2010-06-30 | FTUK | Futures | 3372.0 | 3392.3 | 3310.8 | 3358.6 | 148578.0 |
| 2010-06-30 | G | Futures | 81.05 | 81.43 | 81.04 | 81.28 | 97267.0 |
| 2010-06-30 | GF | Futures | 285.266 | 287.476 | 282.992 | 285.581 | 3295.0 |
| 2010-06-30 | GSCI | Futures | 843.89 | 851.23 | 835.95 | 843.54 | 792.0 |
| 2010-06-30 | HE | Futures | 98.475 | 100.07 | 98.287 | 99.132 | 4924.0 |
| 2010-06-30 | HG | Futures | 3.9294 | 3.9837 | 3.8444 | 3.9515 | 35863.0 |
| 2010-06-30 | HO | Futures | 1.8094 | 1.833 | 1.7715 | 1.7913 | 24002.0 |
| 2010-06-30 | HRC | Futures | 2923.0 | 2923.0 | 2923.0 | 2923.0 | 0.0 |
| 2010-06-30 | J1 | Futures | 0.0142216 | 0.0142556 | 0.0141902 | 0.0142355 | 132460.0 |
| 2010-06-30 | J7 | Futures | 0.014107 | 0.01415 | 0.014085 | 0.014128 | 120.0 |
| 2010-06-30 | JB | Futures | 120.61 | 120.73 | 120.54 | 120.6 | 1561.0 |
| 2010-06-30 | KC | Futures | 409.73 | 418.39 | 403.2 | 416.51 | 14113.0 |
| 2010-06-30 | KE | Futures | 2040.13 | 2164.78 | 2040.13 | 2113.64 | 20152.0 |
| 2010-06-30 | L | Futures | 98.026 | 98.036 | 98.007 | 98.026 | 23295.0 |
> showing 50 of 90 rows — these rows as CSV