PREVIEW / futures_daily / 2010-08-16
file: by_date/futures_daily/2010/2010-08-16.parquet size: 9 KB rows: 91
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-08-16 | ES | Futures | 1050.94 | 1054.84 | 1039.97 | 1050.46 | 1612131.0 |
| 2010-08-16 | NQ | Futures | 2057.37 | 2074.92 | 2037.28 | 2059.92 | 286982.0 |
| 2010-08-16 | YM | Futures | 9497.4 | 9534.4 | 9413.2 | 9498.3 | 108316.0 |
| 2010-08-16 | CL | Futures | 160.06 | 161.03 | 158.69 | 159.47 | 108987.0 |
| 2010-08-16 | GC | Futures | 1653.5 | 1671.2 | 1653.1 | 1666.7 | 79250.0 |
| 2010-08-16 | ZN | Futures | 102.923975 | 103.474645 | 102.898363 | 103.436226 | 1008381.0 |
| 2010-08-16 | A6 | Futures | 0.73776 | 0.74314 | 0.73187 | 0.74049 | 99165.0 |
| 2010-08-16 | AD | Futures | 0.94767 | 0.95192 | 0.94332 | 0.945 | 63486.0 |
| 2010-08-16 | B | Futures | 65.78 | 66.16 | 65.16 | 65.71 | 131305.0 |
| 2010-08-16 | B6 | Futures | 1.6179 | 1.6294 | 1.6118 | 1.6235 | 97936.0 |
| 2010-08-16 | BFX | Futures | 2810.4 | 2819.6 | 2809.9 | 2815.4 | 100.0 |
| 2010-08-16 | BR | Futures | 0.23672 | 0.23672 | 0.23672 | 0.23672 | 23.0 |
| 2010-08-16 | BZ | Futures | 70.49 | 70.88 | 70.49 | 70.7 | 119.0 |
| 2010-08-16 | C | Futures | 2296.0 | 2304.0 | 2260.0 | 2294.0 | 1724.0 |
| 2010-08-16 | CB | Futures | 91.744 | 91.744 | 91.261 | 91.261 | 5.0 |
| 2010-08-16 | CC | Futures | 2389.0 | 2414.0 | 2362.0 | 2392.0 | 13908.0 |
| 2010-08-16 | CT | Futures | 73.48 | 73.74 | 73.25 | 73.55 | 80.0 |
| 2010-08-16 | DC | Futures | 23.68 | 23.68 | 23.45 | 23.55 | 138.0 |
| 2010-08-16 | DX | Futures | 83.687 | 83.798 | 83.002 | 83.289 | 11124.0 |
| 2010-08-16 | E1 | Futures | 1.25396 | 1.2692 | 1.24713 | 1.26329 | 48722.0 |
| 2010-08-16 | E6 | Futures | 1.50922 | 1.52199 | 1.50555 | 1.51442 | 237735.0 |
| 2010-08-16 | E7 | Futures | 1.4986 | 1.5109 | 1.4948 | 1.5035 | 3060.0 |
| 2010-08-16 | ED | Futures | 94.5274 | 94.5511 | 94.5274 | 94.5487 | 134398.0 |
| 2010-08-16 | ER | Futures | 97.291 | 97.301 | 97.276 | 97.296 | 81209.0 |
| 2010-08-16 | EW | Futures | 715.9 | 723.1 | 710.4 | 720.0 | 21445.0 |
| 2010-08-16 | FBTP | Futures | 66.46 | 66.8 | 66.46 | 66.73 | 2092.0 |
| 2010-08-16 | FCE | Futures | 2382.5 | 2388.4 | 2346.8 | 2369.9 | 33656.0 |
| 2010-08-16 | FDAX | Futures | 6665.5 | 6700.3 | 6596.4 | 6643.7 | 110517.0 |
| 2010-08-16 | FESX | Futures | 1678.6 | 1684.8 | 1653.2 | 1667.4 | 841590.0 |
| 2010-08-16 | FEU3 | Futures | 97.835 | 97.855 | 97.835 | 97.855 | 21.0 |
| 2010-08-16 | FGBL | Futures | 102.73 | 103.33 | 102.61 | 103.13 | 724230.0 |
| 2010-08-16 | FGBM | Futures | 106.23 | 106.4 | 106.12 | 106.31 | 311612.0 |
| 2010-08-16 | FGBS | Futures | 107.745 | 107.78 | 107.711 | 107.731 | 342991.0 |
| 2010-08-16 | FGBX | Futures | 103.01 | 105.04 | 103.01 | 104.88 | 3959.0 |
| 2010-08-16 | FTDX | Futures | 700.3 | 700.3 | 639.5 | 658.4 | 109.0 |
| 2010-08-16 | FTI | Futures | 258.98 | 259.81 | 256.02 | 257.86 | 2129.0 |
| 2010-08-16 | FTUK | Futures | 3632.8 | 3643.1 | 3588.8 | 3614.9 | 73402.0 |
| 2010-08-16 | G | Futures | 83.0 | 83.65 | 83.0 | 83.54 | 73592.0 |
| 2010-08-16 | GF | Futures | 282.17 | 286.72 | 281.538 | 285.583 | 1050.0 |
| 2010-08-16 | GSCI | Futures | 873.46 | 873.97 | 864.81 | 864.81 | 294.0 |
| 2010-08-16 | HE | Futures | 98.734 | 99.426 | 97.911 | 98.602 | 11538.0 |
| 2010-08-16 | HG | Futures | 4.3573 | 4.4229 | 4.3493 | 4.3921 | 22269.0 |
| 2010-08-16 | HO | Futures | 1.7532 | 1.7644 | 1.737 | 1.7429 | 40057.0 |
| 2010-08-16 | HRC | Futures | 2753.7 | 2753.7 | 2753.7 | 2753.7 | 0.0 |
| 2010-08-16 | J1 | Futures | 0.0145965 | 0.0147689 | 0.0145903 | 0.0147513 | 90989.0 |
| 2010-08-16 | J7 | Futures | 0.014483 | 0.014658 | 0.014483 | 0.01464 | 243.0 |
| 2010-08-16 | JB | Futures | 121.32 | 121.55 | 121.29 | 121.55 | 2541.0 |
| 2010-08-16 | KC | Futures | 439.49 | 453.55 | 435.6 | 448.78 | 12176.0 |
| 2010-08-16 | KE | Futures | 3076.71 | 3096.95 | 2899.86 | 2931.82 | 9172.0 |
| 2010-08-16 | KRW | Futures | 0.0008237 | 0.0008237 | 0.0008237 | 0.0008237 | 4.0 |
> showing 50 of 91 rows — these rows as CSV