PREVIEW / futures_daily / 2010-10-28
file: by_date/futures_daily/2010/2010-10-28.parquet size: 9 KB rows: 92
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-10-28 | ES | Futures | 1155.12 | 1163.94 | 1150.22 | 1155.85 | 2014979.0 |
| 2010-10-28 | NQ | Futures | 2407.82 | 2422.84 | 2391.66 | 2410.37 | 306514.0 |
| 2010-10-28 | YM | Futures | 10300.5 | 10362.9 | 10237.3 | 10281.0 | 125275.0 |
| 2010-10-28 | CL | Futures | 169.04 | 170.38 | 168.03 | 169.43 | 296748.0 |
| 2010-10-28 | GC | Futures | 1801.4 | 1829.8 | 1798.2 | 1824.8 | 148655.0 |
| 2010-10-28 | ZN | Futures | 103.322436 | 104.057964 | 103.283724 | 103.941828 | 1220406.0 |
| 2010-10-28 | A6 | Futures | 0.81159 | 0.8199 | 0.81151 | 0.81654 | 87885.0 |
| 2010-10-28 | AD | Futures | 0.9633 | 0.97212 | 0.96201 | 0.96934 | 109231.0 |
| 2010-10-28 | B | Futures | 71.2 | 71.62 | 70.87 | 71.39 | 75035.0 |
| 2010-10-28 | B6 | Futures | 1.6371 | 1.6582 | 1.6357 | 1.6532 | 116387.0 |
| 2010-10-28 | BFX | Futures | 3055.1 | 3061.7 | 3047.9 | 3055.9 | 57.0 |
| 2010-10-28 | BR | Futures | 0.24794 | 0.2486 | 0.24781 | 0.24836 | 268.0 |
| 2010-10-28 | BZ | Futures | 75.41 | 75.52 | 75.41 | 75.52 | 129.0 |
| 2010-10-28 | C | Futures | 2091.0 | 2101.0 | 2043.0 | 2043.0 | 4103.0 |
| 2010-10-28 | CB | Futures | 104.422 | 104.422 | 103.866 | 103.866 | 8.0 |
| 2010-10-28 | CC | Futures | 2383.0 | 2408.0 | 2324.0 | 2355.0 | 8996.0 |
| 2010-10-28 | CSC | Futures | 3.61 | 3.61 | 3.61 | 3.61 | 4.0 |
| 2010-10-28 | CT | Futures | 104.61 | 107.84 | 102.97 | 102.99 | 28750.0 |
| 2010-10-28 | DC | Futures | 24.62 | 24.66 | 24.36 | 24.37 | 237.0 |
| 2010-10-28 | DX | Futures | 78.454 | 78.514 | 77.606 | 77.75 | 23909.0 |
| 2010-10-28 | E1 | Futures | 1.32605 | 1.33971 | 1.32553 | 1.3359 | 40256.0 |
| 2010-10-28 | E6 | Futures | 1.62869 | 1.6488 | 1.62774 | 1.64643 | 368490.0 |
| 2010-10-28 | E7 | Futures | 1.6162 | 1.6363 | 1.6154 | 1.6339 | 5433.0 |
| 2010-10-28 | ED | Futures | 94.7268 | 94.7411 | 94.7268 | 94.7363 | 124940.0 |
| 2010-10-28 | ER | Futures | 97.149 | 97.173 | 97.144 | 97.149 | 115804.0 |
| 2010-10-28 | EW | Futures | 811.7 | 819.3 | 806.5 | 809.3 | 25116.0 |
| 2010-10-28 | FBTP | Futures | 67.06 | 67.15 | 66.95 | 67.08 | 5628.0 |
| 2010-10-28 | FCE | Futures | 2545.9 | 2560.2 | 2528.0 | 2540.9 | 118465.0 |
| 2010-10-28 | FDAX | Futures | 7110.7 | 7160.7 | 7082.7 | 7111.2 | 133748.0 |
| 2010-10-28 | FESX | Futures | 1773.1 | 1783.7 | 1762.5 | 1771.9 | 1009576.0 |
| 2010-10-28 | FEU3 | Futures | 97.721 | 97.731 | 97.711 | 97.711 | 78.0 |
| 2010-10-28 | FGBL | Futures | 101.91 | 102.12 | 101.69 | 101.84 | 860607.0 |
| 2010-10-28 | FGBM | Futures | 105.48 | 105.59 | 105.32 | 105.4 | 476938.0 |
| 2010-10-28 | FGBS | Futures | 107.154 | 107.204 | 107.095 | 107.115 | 447732.0 |
| 2010-10-28 | FGBX | Futures | 104.56 | 104.98 | 104.29 | 104.78 | 4062.0 |
| 2010-10-28 | FTDX | Futures | 721.8 | 727.5 | 719.6 | 724.0 | 305.0 |
| 2010-10-28 | FTI | Futures | 271.57 | 272.53 | 269.01 | 269.93 | 28628.0 |
| 2010-10-28 | FTUK | Futures | 3910.7 | 3937.7 | 3895.9 | 3915.6 | 106344.0 |
| 2010-10-28 | G | Futures | 83.41 | 83.58 | 83.14 | 83.35 | 132488.0 |
| 2010-10-28 | GF | Futures | 281.236 | 282.055 | 279.348 | 279.348 | 2183.0 |
| 2010-10-28 | GSCI | Futures | 932.98 | 938.92 | 930.58 | 934.55 | 234.0 |
| 2010-10-28 | HE | Futures | 91.31 | 91.75 | 90.126 | 90.735 | 16605.0 |
| 2010-10-28 | HG | Futures | 5.0425 | 5.1112 | 5.0264 | 5.0551 | 32196.0 |
| 2010-10-28 | HO | Futures | 1.9025 | 1.9176 | 1.8927 | 1.9061 | 46271.0 |
| 2010-10-28 | HRC | Futures | 2504.7 | 2504.7 | 2504.7 | 2504.7 | 0.0 |
| 2010-10-28 | J1 | Futures | 0.0153735 | 0.0155393 | 0.0153697 | 0.0154978 | 106959.0 |
| 2010-10-28 | J7 | Futures | 0.015279 | 0.015431 | 0.015274 | 0.015391 | 222.0 |
| 2010-10-28 | JB | Futures | 121.93 | 122.34 | 121.82 | 122.32 | 3128.0 |
| 2010-10-28 | KC | Futures | 495.98 | 500.82 | 486.8 | 487.55 | 13266.0 |
| 2010-10-28 | KE | Futures | 3143.65 | 3220.83 | 3131.13 | 3217.7 | 9519.0 |
> showing 50 of 92 rows — these rows as CSV