PREVIEW / futures_daily / 2010-08-18
file: by_date/futures_daily/2010/2010-08-18.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-18 | ES | Futures | 1062.16 | 1071.43 | 1057.04 | 1059.96 | 1814778.0 |
| 2010-08-18 | NQ | Futures | 2082.56 | 2107.74 | 2072.37 | 2078.88 | 298743.0 |
| 2010-08-18 | YM | Futures | 9579.7 | 9666.6 | 9531.6 | 9571.3 | 132935.0 |
| 2010-08-18 | CL | Futures | 159.89 | 160.61 | 156.5 | 159.85 | 274746.0 |
| 2010-08-18 | GC | Futures | 1667.5 | 1677.9 | 1656.8 | 1673.8 | 100667.0 |
| 2010-08-18 | ZN | Futures | 102.988006 | 103.308163 | 102.885556 | 102.949588 | 993995.0 |
| 2010-08-18 | A6 | Futures | 0.74812 | 0.7487 | 0.7414 | 0.74298 | 96639.0 |
| 2010-08-18 | AD | Futures | 0.95567 | 0.9613 | 0.95458 | 0.961 | 71326.0 |
| 2010-08-18 | B | Futures | 66.7 | 66.77 | 65.42 | 66.44 | 164724.0 |
| 2010-08-18 | B6 | Futures | 1.6166 | 1.6281 | 1.6081 | 1.6194 | 121377.0 |
| 2010-08-18 | BFX | Futures | 2868.9 | 2886.5 | 2853.2 | 2886.5 | 1617.0 |
| 2010-08-18 | BR | Futures | 0.23802 | 0.23802 | 0.2376 | 0.2376 | 274.0 |
| 2010-08-18 | BZ | Futures | 71.01 | 71.69 | 70.41 | 71.49 | 247.0 |
| 2010-08-18 | C | Futures | 2268.0 | 2283.0 | 2255.0 | 2259.0 | 2286.0 |
| 2010-08-18 | CB | Futures | 92.106 | 92.589 | 92.106 | 92.589 | 16.0 |
| 2010-08-18 | CC | Futures | 2397.0 | 2417.0 | 2376.0 | 2394.0 | 6484.0 |
| 2010-08-18 | CSC | Futures | 3.816 | 3.816 | 3.795 | 3.795 | 5.0 |
| 2010-08-18 | CT | Futures | 73.8 | 73.94 | 73.19 | 73.54 | 64.0 |
| 2010-08-18 | DC | Futures | 23.55 | 23.82 | 23.52 | 23.63 | 127.0 |
| 2010-08-18 | DX | Futures | 83.022 | 83.259 | 82.644 | 82.962 | 14055.0 |
| 2010-08-18 | E1 | Futures | 1.25895 | 1.26513 | 1.25672 | 1.26079 | 24398.0 |
| 2010-08-18 | E6 | Futures | 1.52282 | 1.52802 | 1.51619 | 1.52104 | 258924.0 |
| 2010-08-18 | E7 | Futures | 1.512 | 1.5169 | 1.5055 | 1.5101 | 3106.0 |
| 2010-08-18 | ED | Futures | 94.5677 | 94.5796 | 94.563 | 94.5748 | 126380.0 |
| 2010-08-18 | ER | Futures | 97.296 | 97.301 | 97.286 | 97.296 | 68714.0 |
| 2010-08-18 | EW | Futures | 729.9 | 738.6 | 725.0 | 727.7 | 23623.0 |
| 2010-08-18 | FBTP | Futures | 66.95 | 67.43 | 66.87 | 67.3 | 3816.0 |
| 2010-08-18 | FCE | Futures | 2399.0 | 2419.7 | 2387.1 | 2401.9 | 191143.0 |
| 2010-08-18 | FDAX | Futures | 6718.2 | 6766.7 | 6698.1 | 6737.8 | 124706.0 |
| 2010-08-18 | FESX | Futures | 1683.5 | 1700.9 | 1675.5 | 1689.7 | 989294.0 |
| 2010-08-18 | FEU3 | Futures | 97.85 | 97.855 | 97.85 | 97.855 | 7.0 |
| 2010-08-18 | FGBL | Futures | 102.85 | 103.34 | 102.84 | 103.22 | 756833.0 |
| 2010-08-18 | FGBM | Futures | 106.24 | 106.43 | 106.2 | 106.37 | 327951.0 |
| 2010-08-18 | FGBS | Futures | 107.731 | 107.74 | 107.701 | 107.731 | 353636.0 |
| 2010-08-18 | FGBX | Futures | 104.97 | 106.0 | 104.97 | 105.76 | 6180.0 |
| 2010-08-18 | FTDX | Futures | 669.5 | 670.3 | 665.9 | 667.2 | 375.0 |
| 2010-08-18 | FTI | Futures | 260.97 | 263.25 | 259.65 | 261.61 | 44577.0 |
| 2010-08-18 | FTUK | Futures | 3665.2 | 3671.3 | 3642.1 | 3651.0 | 93391.0 |
| 2010-08-18 | G | Futures | 83.42 | 83.74 | 83.38 | 83.66 | 75164.0 |
| 2010-08-18 | GF | Futures | 287.163 | 290.006 | 286.91 | 289.627 | 1305.0 |
| 2010-08-18 | GSCI | Futures | 868.54 | 874.48 | 860.06 | 870.75 | 188.0 |
| 2010-08-18 | HE | Futures | 100.084 | 103.443 | 99.755 | 102.851 | 27970.0 |
| 2010-08-18 | HG | Futures | 4.4624 | 4.4933 | 4.4263 | 4.4859 | 33332.0 |
| 2010-08-18 | HO | Futures | 1.7754 | 1.7787 | 1.7433 | 1.772 | 11986.0 |
| 2010-08-18 | HRC | Futures | 2753.7 | 2753.7 | 2753.7 | 2753.7 | 0.0 |
| 2010-08-18 | J1 | Futures | 0.0147022 | 0.0147714 | 0.0146859 | 0.0147236 | 79434.0 |
| 2010-08-18 | J7 | Futures | 0.014595 | 0.014659 | 0.014577 | 0.014613 | 158.0 |
| 2010-08-18 | JB | Futures | 121.48 | 121.84 | 121.37 | 121.81 | 971.0 |
| 2010-08-18 | KC | Futures | 441.37 | 444.51 | 437.98 | 439.87 | 7754.0 |
| 2010-08-18 | KE | Futures | 2886.01 | 2948.87 | 2865.77 | 2919.04 | 6963.0 |
> showing 50 of 91 rows — these rows as CSV