PREVIEW / futures_daily / 2010-08-30
file: by_date/futures_daily/2010/2010-08-30.parquet size: 8 KB rows: 86
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-30 | ES | Futures | 1038.26 | 1046.31 | 1018.76 | 1019.24 | 1506592.0 |
| 2010-08-30 | NQ | Futures | 2026.82 | 2043.51 | 2001.35 | 2001.92 | 255852.0 |
| 2010-08-30 | YM | Futures | 9372.6 | 9441.9 | 9222.8 | 9226.5 | 114020.0 |
| 2010-08-30 | CL | Futures | 159.26 | 159.43 | 156.12 | 157.57 | 260666.0 |
| 2010-08-30 | GC | Futures | 1684.0 | 1686.0 | 1678.7 | 1684.4 | 38820.0 |
| 2010-08-30 | ZN | Futures | 102.539787 | 103.487451 | 102.386112 | 103.346582 | 1339427.0 |
| 2010-08-30 | A6 | Futures | 0.74604 | 0.74754 | 0.73784 | 0.73966 | 61362.0 |
| 2010-08-30 | AD | Futures | 0.94026 | 0.94283 | 0.93108 | 0.93266 | 63478.0 |
| 2010-08-30 | B | Futures | 66.6 | 66.75 | 65.83 | 66.39 | 35719.0 |
| 2010-08-30 | B6 | Futures | 1.6117 | 1.6166 | 1.6032 | 1.6048 | 61259.0 |
| 2010-08-30 | BFX | Futures | 2812.7 | 2816.0 | 2783.3 | 2806.1 | 340.0 |
| 2010-08-30 | BR | Futures | 0.23833 | 0.23833 | 0.23833 | 0.23833 | 745.0 |
| 2010-08-30 | BZ | Futures | 70.17 | 70.46 | 70.1 | 70.46 | 142.0 |
| 2010-08-30 | CB | Futures | 96.507 | 96.507 | 96.507 | 96.507 | 5.0 |
| 2010-08-30 | CC | Futures | 2253.0 | 2273.0 | 2240.0 | 2247.0 | 4557.0 |
| 2010-08-30 | CT | Futures | 74.94 | 75.7 | 74.78 | 75.18 | 31.0 |
| 2010-08-30 | DC | Futures | 24.16 | 24.24 | 24.08 | 24.11 | 62.0 |
| 2010-08-30 | DX | Futures | 83.506 | 84.065 | 83.445 | 83.885 | 14616.0 |
| 2010-08-30 | E1 | Futures | 1.27773 | 1.28299 | 1.27406 | 1.27997 | 25152.0 |
| 2010-08-30 | E6 | Futures | 1.50945 | 1.50957 | 1.4968 | 1.49775 | 184358.0 |
| 2010-08-30 | E7 | Futures | 1.4985 | 1.4988 | 1.4857 | 1.487 | 2820.0 |
| 2010-08-30 | ED | Futures | 94.6057 | 94.6128 | 94.6033 | 94.608 | 87407.0 |
| 2010-08-30 | ER | Futures | 97.316 | 97.321 | 97.311 | 97.316 | 46582.0 |
| 2010-08-30 | EW | Futures | 718.9 | 725.8 | 705.1 | 705.5 | 23798.0 |
| 2010-08-30 | FBTP | Futures | 67.29 | 67.34 | 67.2 | 67.26 | 4115.0 |
| 2010-08-30 | FCE | Futures | 2330.4 | 2330.4 | 2282.9 | 2299.4 | 76465.0 |
| 2010-08-30 | FDAX | Futures | 6502.3 | 6513.7 | 6396.8 | 6437.6 | 99568.0 |
| 2010-08-30 | FESX | Futures | 1639.0 | 1641.4 | 1608.0 | 1621.0 | 600759.0 |
| 2010-08-30 | FEU3 | Futures | 97.874 | 97.879 | 97.874 | 97.874 | 19.0 |
| 2010-08-30 | FGBL | Futures | 104.25 | 105.0 | 104.25 | 104.8 | 472918.0 |
| 2010-08-30 | FGBM | Futures | 106.68 | 107.02 | 106.61 | 106.93 | 232923.0 |
| 2010-08-30 | FGBS | Futures | 107.868 | 107.898 | 107.819 | 107.873 | 244444.0 |
| 2010-08-30 | FGBX | Futures | 111.24 | 112.14 | 110.92 | 111.69 | 2136.0 |
| 2010-08-30 | FTDX | Futures | 652.3 | 656.2 | 651.8 | 654.0 | 256.0 |
| 2010-08-30 | FTI | Futures | 255.22 | 255.5 | 250.67 | 252.18 | 22735.0 |
| 2010-08-30 | GF | Futures | 293.988 | 293.988 | 290.449 | 290.954 | 700.0 |
| 2010-08-30 | GSCI | Futures | 867.18 | 869.05 | 863.45 | 865.23 | 357.0 |
| 2010-08-30 | HE | Futures | 98.8 | 99.689 | 98.536 | 98.635 | 9289.0 |
| 2010-08-30 | HG | Futures | 4.6047 | 4.618 | 4.5366 | 4.5773 | 22064.0 |
| 2010-08-30 | HH | Futures | 35.786 | 35.786 | 35.646 | 35.646 | 4.0 |
| 2010-08-30 | HO | Futures | 1.7803 | 1.7827 | 1.7503 | 1.7589 | 16266.0 |
| 2010-08-30 | HRC | Futures | 2730.7 | 2730.7 | 2730.7 | 2730.7 | 0.0 |
| 2010-08-30 | J1 | Futures | 0.0147362 | 0.0148909 | 0.0146456 | 0.014857 | 121878.0 |
| 2010-08-30 | J7 | Futures | 0.014624 | 0.014776 | 0.014538 | 0.014745 | 372.0 |
| 2010-08-30 | JB | Futures | 121.41 | 121.41 | 120.57 | 121.32 | 3207.0 |
| 2010-08-30 | KC | Futures | 445.64 | 457.04 | 438.45 | 449.85 | 7914.0 |
| 2010-08-30 | KE | Futures | 2994.5 | 3107.15 | 2994.5 | 3020.57 | 18664.0 |
| 2010-08-30 | LBS | Futures | 631.5 | 631.7 | 623.2 | 631.7 | 75.0 |
| 2010-08-30 | LE | Futures | 158.126 | 158.81 | 157.482 | 157.844 | 14167.0 |
| 2010-08-30 | MFS | Futures | 1143.2 | 1147.1 | 1132.2 | 1132.6 | 779.0 |
> showing 50 of 86 rows — these rows as CSV