PREVIEW / futures_daily / 2009-08-10
file: by_date/futures_daily/2009/2009-08-10.parquet size: 8 KB rows: 85
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 |
|---|---|---|---|---|---|---|---|
| 2009-08-10 | ES | Futures | 964.96 | 966.88 | 957.76 | 966.64 | 1189129.0 |
| 2009-08-10 | NQ | Futures | 1823.26 | 1824.1 | 1799.33 | 1815.94 | 216984.0 |
| 2009-08-10 | YM | Futures | 8409.9 | 8427.0 | 8348.5 | 8409.0 | 88423.0 |
| 2009-08-10 | CL | Futures | 181.95 | 184.27 | 180.46 | 181.77 | 304092.0 |
| 2009-08-10 | GC | Futures | 1322.4 | 1326.2 | 1305.3 | 1309.0 | 78339.0 |
| 2009-08-10 | ZN | Futures | 90.547201 | 91.175146 | 90.374824 | 91.125896 | 504867.0 |
| 2009-08-10 | A6 | Futures | 0.66886 | 0.67585 | 0.66765 | 0.66966 | 61453.0 |
| 2009-08-10 | AD | Futures | 0.91284 | 0.91492 | 0.90376 | 0.90642 | 52939.0 |
| 2009-08-10 | B | Futures | 69.7 | 70.76 | 69.63 | 70.11 | 70567.0 |
| 2009-08-10 | B6 | Futures | 1.7366 | 1.7415 | 1.7112 | 1.7144 | 114780.0 |
| 2009-08-10 | BFX | Futures | 2565.5 | 2614.5 | 2565.5 | 2614.5 | 5.0 |
| 2009-08-10 | BR | Futures | 0.21 | 0.21 | 0.21 | 0.21 | 15.0 |
| 2009-08-10 | C | Futures | 1880.0 | 1928.0 | 1856.0 | 1925.0 | 4717.0 |
| 2009-08-10 | CB | Futures | 71.621 | 71.621 | 71.621 | 71.621 | 1.0 |
| 2009-08-10 | CC | Futures | 2520.0 | 2632.0 | 2518.0 | 2578.0 | 6909.0 |
| 2009-08-10 | CT | Futures | 53.43 | 54.93 | 53.43 | 54.8 | 63.0 |
| 2009-08-10 | DC | Futures | 22.48 | 22.66 | 22.06 | 22.66 | 87.0 |
| 2009-08-10 | DX | Futures | 80.68 | 81.387 | 80.68 | 81.254 | 7461.0 |
| 2009-08-10 | E1 | Futures | 1.22371 | 1.22636 | 1.21656 | 1.21948 | 35374.0 |
| 2009-08-10 | E6 | Futures | 1.68271 | 1.68806 | 1.6744 | 1.67761 | 175885.0 |
| 2009-08-10 | E7 | Futures | 1.6652 | 1.6705 | 1.6575 | 1.6604 | 1707.0 |
| 2009-08-10 | ED | Futures | 93.9519 | 93.9755 | 93.9424 | 93.9708 | 94436.0 |
| 2009-08-10 | ER | Futures | 97.071 | 97.086 | 97.061 | 97.076 | 52452.0 |
| 2009-08-10 | EW | Futures | 629.7 | 631.9 | 623.6 | 629.0 | 23680.0 |
| 2009-08-10 | FCE | Futures | 2299.8 | 2301.1 | 2281.8 | 2297.2 | 74264.0 |
| 2009-08-10 | FDAX | Futures | 5957.6 | 5975.2 | 5915.4 | 5949.4 | 83208.0 |
| 2009-08-10 | FESX | Futures | 1605.6 | 1609.2 | 1596.1 | 1605.0 | 556807.0 |
| 2009-08-10 | FEU3 | Futures | 97.643 | 97.653 | 97.643 | 97.653 | 38.0 |
| 2009-08-10 | FGBL | Futures | 91.21 | 91.66 | 91.18 | 91.48 | 392960.0 |
| 2009-08-10 | FGBM | Futures | 96.97 | 97.34 | 96.94 | 97.24 | 232246.0 |
| 2009-08-10 | FGBS | Futures | 103.521 | 103.724 | 103.497 | 103.685 | 342599.0 |
| 2009-08-10 | FGBX | Futures | 84.01 | 84.94 | 84.01 | 84.67 | 1220.0 |
| 2009-08-10 | FTDX | Futures | 603.6 | 609.4 | 603.6 | 605.8 | 196.0 |
| 2009-08-10 | FTI | Futures | 238.57 | 239.14 | 236.87 | 238.03 | 316.0 |
| 2009-08-10 | FTUK | Futures | 3113.6 | 3124.6 | 3097.7 | 3119.2 | 69758.0 |
| 2009-08-10 | G | Futures | 75.45 | 75.67 | 75.34 | 75.43 | 63040.0 |
| 2009-08-10 | GF | Futures | 279.351 | 279.351 | 276.656 | 277.278 | 2268.0 |
| 2009-08-10 | GSCI | Futures | 974.25 | 974.25 | 961.92 | 967.93 | 3308.0 |
| 2009-08-10 | HE | Futures | 67.454 | 69.065 | 67.042 | 67.454 | 9816.0 |
| 2009-08-10 | HG | Futures | 3.9112 | 3.9968 | 3.8676 | 3.8901 | 23202.0 |
| 2009-08-10 | HO | Futures | 1.934 | 1.9654 | 1.9271 | 1.9508 | 29061.0 |
| 2009-08-10 | HRC | Futures | 2586.5 | 2586.5 | 2586.5 | 2586.5 | 0.0 |
| 2009-08-10 | J1 | Futures | 0.0128888 | 0.0129945 | 0.0128863 | 0.0129769 | 76029.0 |
| 2009-08-10 | J7 | Futures | 0.01272 | 0.012811 | 0.012719 | 0.012798 | 91.0 |
| 2009-08-10 | JB | Futures | 115.89 | 115.93 | 115.5 | 115.57 | 3502.0 |
| 2009-08-10 | KC | Futures | 372.69 | 376.08 | 366.04 | 368.62 | 9753.0 |
| 2009-08-10 | KE | Futures | 2518.09 | 2556.46 | 2503.7 | 2519.29 | 7719.0 |
| 2009-08-10 | L | Futures | 97.445 | 97.494 | 97.426 | 97.455 | 26179.0 |
| 2009-08-10 | LBS | Futures | 801.7 | 802.5 | 768.9 | 775.3 | 1039.0 |
| 2009-08-10 | LE | Futures | 147.928 | 148.178 | 146.93 | 147.054 | 13610.0 |
> showing 50 of 85 rows — these rows as CSV