PREVIEW / futures_daily / 2010-12-14
file: by_date/futures_daily/2010/2010-12-14.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-12-14 | ES | Futures | 1216.62 | 1222.78 | 1213.43 | 1217.36 | 2008662.0 |
| 2010-12-14 | NQ | Futures | 2507.89 | 2520.09 | 2502.49 | 2513.56 | 255796.0 |
| 2010-12-14 | YM | Futures | 10635.9 | 10720.1 | 10621.9 | 10689.2 | 104040.0 |
| 2010-12-14 | CL | Futures | 181.96 | 183.41 | 181.03 | 182.06 | 139482.0 |
| 2010-12-14 | GC | Futures | 1896.4 | 1915.1 | 1892.6 | 1908.8 | 134945.0 |
| 2010-12-14 | ZN | Futures | 100.400553 | 100.452547 | 98.996713 | 99.230686 | 1303210.0 |
| 2010-12-14 | A6 | Futures | 0.83418 | 0.84088 | 0.83359 | 0.83825 | 85059.0 |
| 2010-12-14 | AD | Futures | 0.98272 | 0.98768 | 0.97964 | 0.9854 | 69709.0 |
| 2010-12-14 | B | Futures | 77.48 | 78.07 | 77.16 | 77.61 | 134096.0 |
| 2010-12-14 | B6 | Futures | 1.6438 | 1.6494 | 1.6314 | 1.6356 | 105340.0 |
| 2010-12-14 | BFX | Futures | 3042.5 | 3042.8 | 3030.9 | 3039.3 | 1265.0 |
| 2010-12-14 | BR | Futures | 0.24981 | 0.24981 | 0.24966 | 0.24966 | 98.0 |
| 2010-12-14 | BZ | Futures | 82.12 | 82.49 | 82.02 | 82.25 | 297.0 |
| 2010-12-14 | C | Futures | 2084.0 | 2136.0 | 2067.0 | 2124.0 | 15336.0 |
| 2010-12-14 | CC | Futures | 2345.0 | 2396.0 | 2325.0 | 2386.0 | 7403.0 |
| 2010-12-14 | CT | Futures | 122.63 | 125.17 | 122.58 | 123.9 | 14386.0 |
| 2010-12-14 | DC | Futures | 22.52 | 22.65 | 22.47 | 22.5 | 96.0 |
| 2010-12-14 | DX | Futures | 79.596 | 79.716 | 79.003 | 79.547 | 21127.0 |
| 2010-12-14 | E1 | Futures | 1.35517 | 1.3726 | 1.35372 | 1.36867 | 48251.0 |
| 2010-12-14 | E6 | Futures | 1.5828 | 1.59628 | 1.58031 | 1.58327 | 373433.0 |
| 2010-12-14 | E7 | Futures | 1.5711 | 1.5844 | 1.5687 | 1.5715 | 4957.0 |
| 2010-12-14 | EBM | Futures | 217.88 | 217.88 | 212.2 | 212.43 | 7069.0 |
| 2010-12-14 | ED | Futures | 94.7718 | 94.7766 | 94.7576 | 94.7671 | 202417.0 |
| 2010-12-14 | ER | Futures | 97.296 | 97.316 | 97.281 | 97.306 | 145384.0 |
| 2010-12-14 | EW | Futures | 881.0 | 885.0 | 878.0 | 880.1 | 28823.0 |
| 2010-12-14 | FBTP | Futures | 64.41 | 64.49 | 64.23 | 64.24 | 2956.0 |
| 2010-12-14 | FCE | Futures | 2601.7 | 2609.3 | 2592.3 | 2606.0 | 106348.0 |
| 2010-12-14 | FDAX | Futures | 7553.3 | 7570.0 | 7542.0 | 7557.1 | 188436.0 |
| 2010-12-14 | FESX | Futures | 1775.0 | 1782.4 | 1765.7 | 1776.2 | 989278.0 |
| 2010-12-14 | FEU3 | Futures | 97.859 | 97.869 | 97.845 | 97.864 | 4879.0 |
| 2010-12-14 | FGBL | Futures | 98.97 | 98.98 | 98.01 | 98.3 | 664738.0 |
| 2010-12-14 | FGBM | Futures | 104.4 | 104.48 | 103.8 | 104.05 | 368129.0 |
| 2010-12-14 | FGBS | Futures | 107.119 | 107.237 | 107.06 | 107.104 | 381446.0 |
| 2010-12-14 | FGBX | Futures | 98.1 | 98.18 | 96.47 | 96.7 | 4295.0 |
| 2010-12-14 | FTDX | Futures | 737.2 | 738.9 | 733.7 | 735.9 | 1080.0 |
| 2010-12-14 | FTI | Futures | 281.52 | 282.2 | 280.48 | 281.76 | 30380.0 |
| 2010-12-14 | FTUK | Futures | 4039.4 | 4074.2 | 4037.0 | 4061.7 | 148427.0 |
| 2010-12-14 | FXXP | Futures | 178.8 | 179.7 | 178.8 | 179.7 | 13293.0 |
| 2010-12-14 | G | Futures | 81.24 | 81.27 | 80.68 | 80.7 | 81532.0 |
| 2010-12-14 | GF | Futures | 296.936 | 297.06 | 293.386 | 293.822 | 3412.0 |
| 2010-12-14 | GSCI | Futures | 991.5 | 996.53 | 989.23 | 992.07 | 254.0 |
| 2010-12-14 | HE | Futures | 95.658 | 95.815 | 94.529 | 95.47 | 12538.0 |
| 2010-12-14 | HG | Futures | 5.6014 | 5.6361 | 5.5774 | 5.6094 | 24346.0 |
| 2010-12-14 | HO | Futures | 2.076 | 2.0878 | 2.067 | 2.0778 | 10599.0 |
| 2010-12-14 | HRC | Futures | 2497.7 | 2497.7 | 2497.7 | 2497.7 | 0.0 |
| 2010-12-14 | J1 | Futures | 0.0150632 | 0.0151749 | 0.0150017 | 0.0150255 | 115949.0 |
| 2010-12-14 | J7 | Futures | 0.014959 | 0.015066 | 0.014897 | 0.014919 | 385.0 |
| 2010-12-14 | JB | Futures | 120.17 | 120.53 | 120.08 | 120.27 | 1792.0 |
| 2010-12-14 | KC | Futures | 533.37 | 539.26 | 527.85 | 531.41 | 7150.0 |
| 2010-12-14 | KE | Futures | 3403.4 | 3406.45 | 3291.34 | 3320.89 | 15854.0 |
> showing 50 of 92 rows — these rows as CSV