PREVIEW / futures_daily / 2010-06-15
file: by_date/futures_daily/2010/2010-06-15.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-15 | ES | Futures | 1058.99 | 1084.1 | 1057.53 | 1081.91 | 2694530.0 |
| 2010-06-15 | NQ | Futures | 2088.78 | 2148.49 | 2087.93 | 2142.83 | 349007.0 |
| 2010-06-15 | YM | Futures | 9371.6 | 9569.5 | 9367.9 | 9552.9 | 152375.0 |
| 2010-06-15 | CL | Futures | 162.04 | 166.74 | 161.7 | 166.4 | 149234.0 |
| 2010-06-15 | GC | Futures | 1668.2 | 1689.4 | 1665.7 | 1683.8 | 104401.0 |
| 2010-06-15 | ZN | Futures | 98.608263 | 98.825969 | 98.185656 | 98.262494 | 969306.0 |
| 2010-06-15 | A6 | Futures | 0.70402 | 0.71032 | 0.69756 | 0.70866 | 84352.0 |
| 2010-06-15 | AD | Futures | 0.95478 | 0.96367 | 0.95261 | 0.96189 | 69948.0 |
| 2010-06-15 | B | Futures | 66.01 | 67.87 | 65.86 | 67.65 | 177069.0 |
| 2010-06-15 | B6 | Futures | 1.5297 | 1.5401 | 1.524 | 1.5376 | 112463.0 |
| 2010-06-15 | BFX | Futures | 2833.5 | 2865.9 | 2830.8 | 2864.6 | 1924.0 |
| 2010-06-15 | BR | Futures | 0.22945 | 0.22945 | 0.22945 | 0.22945 | 1.0 |
| 2010-06-15 | BZ | Futures | 72.18 | 73.14 | 71.76 | 72.96 | 244.0 |
| 2010-06-15 | C | Futures | 2476.0 | 2477.0 | 2444.0 | 2448.0 | 2058.0 |
| 2010-06-15 | CB | Futures | 81.604 | 81.604 | 81.604 | 81.604 | 2.0 |
| 2010-06-15 | CC | Futures | 2480.0 | 2498.0 | 2456.0 | 2476.0 | 9056.0 |
| 2010-06-15 | CT | Futures | 65.76 | 65.84 | 64.93 | 65.15 | 4881.0 |
| 2010-06-15 | DC | Futures | 22.14 | 22.6 | 22.14 | 22.49 | 73.0 |
| 2010-06-15 | DX | Futures | 87.689 | 87.865 | 86.872 | 86.973 | 15943.0 |
| 2010-06-15 | E1 | Futures | 1.15139 | 1.16531 | 1.14614 | 1.16111 | 49590.0 |
| 2010-06-15 | E6 | Futures | 1.44513 | 1.46156 | 1.43992 | 1.45955 | 330596.0 |
| 2010-06-15 | E7 | Futures | 1.4353 | 1.451 | 1.4297 | 1.449 | 4991.0 |
| 2010-06-15 | ED | Futures | 94.2474 | 94.2521 | 94.1905 | 94.2332 | 223226.0 |
| 2010-06-15 | ER | Futures | 97.345 | 97.355 | 97.33 | 97.33 | 127419.0 |
| 2010-06-15 | EW | Futures | 744.2 | 762.7 | 744.0 | 760.6 | 32542.0 |
| 2010-06-15 | FBTP | Futures | 64.34 | 64.57 | 64.23 | 64.45 | 4036.0 |
| 2010-06-15 | FCE | Futures | 2373.4 | 2434.9 | 2356.9 | 2404.6 | 127105.0 |
| 2010-06-15 | FDAX | Futures | 6638.3 | 6769.9 | 6611.1 | 6716.6 | 200807.0 |
| 2010-06-15 | FESX | Futures | 1650.1 | 1697.8 | 1640.2 | 1676.7 | 1047160.0 |
| 2010-06-15 | FEU3 | Futures | 97.914 | 97.914 | 97.889 | 97.889 | 235.0 |
| 2010-06-15 | FGBL | Futures | 100.68 | 100.86 | 99.99 | 100.2 | 1008703.0 |
| 2010-06-15 | FGBM | Futures | 105.35 | 105.47 | 104.98 | 105.13 | 451163.0 |
| 2010-06-15 | FGBS | Futures | 107.75 | 107.795 | 107.642 | 107.711 | 446391.0 |
| 2010-06-15 | FGBX | Futures | 99.17 | 100.08 | 98.36 | 98.65 | 2432.0 |
| 2010-06-15 | FTDX | Futures | 676.1 | 686.2 | 675.6 | 684.9 | 3277.0 |
| 2010-06-15 | FTI | Futures | 261.7 | 267.09 | 260.59 | 264.63 | 25827.0 |
| 2010-06-15 | FTUK | Futures | 3526.5 | 3609.1 | 3518.9 | 3565.4 | 198100.0 |
| 2010-06-15 | G | Futures | 80.16 | 80.18 | 79.57 | 79.8 | 80863.0 |
| 2010-06-15 | GF | Futures | 279.771 | 281.287 | 278.824 | 280.34 | 2411.0 |
| 2010-06-15 | GSCI | Futures | 856.35 | 870.52 | 855.5 | 866.6 | 117.0 |
| 2010-06-15 | HE | Futures | 99.539 | 100.508 | 98.85 | 100.258 | 12098.0 |
| 2010-06-15 | HG | Futures | 4.0331 | 4.1146 | 4.0052 | 4.0799 | 29010.0 |
| 2010-06-15 | HO | Futures | 1.8116 | 1.8569 | 1.8009 | 1.8494 | 9404.0 |
| 2010-06-15 | HRC | Futures | 3017.0 | 3017.0 | 3017.0 | 3017.0 | 0.0 |
| 2010-06-15 | J1 | Futures | 0.0137498 | 0.0138341 | 0.013741 | 0.0137926 | 116232.0 |
| 2010-06-15 | J7 | Futures | 0.013655 | 0.013729 | 0.013641 | 0.013689 | 95.0 |
| 2010-06-15 | JB | Futures | 119.47 | 119.64 | 119.42 | 119.59 | 1923.0 |
| 2010-06-15 | KC | Futures | 382.22 | 407.98 | 375.74 | 404.56 | 10090.0 |
| 2010-06-15 | KE | Futures | 2075.91 | 2099.82 | 2055.26 | 2079.17 | 12329.0 |
| 2010-06-15 | L | Futures | 97.967 | 98.007 | 97.937 | 97.977 | 57299.0 |
> showing 50 of 90 rows — these rows as CSV