PREVIEW / futures_daily / 2010-08-17
file: by_date/futures_daily/2010/2010-08-17.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-08-17 | ES | Futures | 1050.7 | 1071.43 | 1048.02 | 1062.16 | 1779783.0 |
| 2010-08-17 | NQ | Futures | 2059.07 | 2105.76 | 2056.53 | 2081.99 | 271497.0 |
| 2010-08-17 | YM | Futures | 9501.1 | 9667.5 | 9480.7 | 9576.9 | 117443.0 |
| 2010-08-17 | CL | Futures | 159.18 | 162.49 | 159.16 | 160.65 | 239911.0 |
| 2010-08-17 | GC | Futures | 1667.8 | 1673.4 | 1664.1 | 1669.6 | 59875.0 |
| 2010-08-17 | ZN | Futures | 103.42342 | 103.436226 | 102.898363 | 103.000813 | 1022565.0 |
| 2010-08-17 | A6 | Futures | 0.74132 | 0.75027 | 0.73908 | 0.74886 | 90340.0 |
| 2010-08-17 | AD | Futures | 0.94619 | 0.95774 | 0.94579 | 0.95616 | 76597.0 |
| 2010-08-17 | B | Futures | 65.43 | 67.5 | 65.43 | 66.83 | 160743.0 |
| 2010-08-17 | B6 | Futures | 1.6249 | 1.6288 | 1.6137 | 1.6157 | 118872.0 |
| 2010-08-17 | BFX | Futures | 2820.9 | 2876.8 | 2820.7 | 2872.4 | 978.0 |
| 2010-08-17 | BR | Futures | 0.23793 | 0.23793 | 0.2376 | 0.2376 | 164.0 |
| 2010-08-17 | BZ | Futures | 71.77 | 72.63 | 71.48 | 71.92 | 302.0 |
| 2010-08-17 | C | Futures | 2298.0 | 2310.0 | 2260.0 | 2265.0 | 1911.0 |
| 2010-08-17 | CB | Futures | 91.744 | 91.744 | 91.744 | 91.744 | 4.0 |
| 2010-08-17 | CC | Futures | 2415.0 | 2417.0 | 2372.0 | 2399.0 | 7839.0 |
| 2010-08-17 | CSC | Futures | 3.772 | 3.772 | 3.772 | 3.772 | 10.0 |
| 2010-08-17 | CT | Futures | 73.55 | 74.03 | 73.4 | 73.8 | 29.0 |
| 2010-08-17 | DC | Futures | 23.51 | 23.82 | 23.16 | 23.55 | 120.0 |
| 2010-08-17 | DX | Futures | 83.229 | 83.264 | 82.765 | 82.976 | 13812.0 |
| 2010-08-17 | E1 | Futures | 1.26368 | 1.26762 | 1.25725 | 1.25895 | 30247.0 |
| 2010-08-17 | E6 | Futures | 1.51631 | 1.52719 | 1.51395 | 1.52305 | 295886.0 |
| 2010-08-17 | E7 | Futures | 1.5057 | 1.5161 | 1.5032 | 1.5121 | 3446.0 |
| 2010-08-17 | ED | Futures | 94.5511 | 94.5701 | 94.5487 | 94.5677 | 124957.0 |
| 2010-08-17 | ER | Futures | 97.296 | 97.306 | 97.286 | 97.296 | 53505.0 |
| 2010-08-17 | EW | Futures | 720.7 | 737.3 | 718.7 | 729.8 | 23387.0 |
| 2010-08-17 | FBTP | Futures | 66.75 | 66.91 | 66.71 | 66.89 | 1669.0 |
| 2010-08-17 | FCE | Futures | 2387.7 | 2418.1 | 2377.5 | 2413.1 | 90515.0 |
| 2010-08-17 | FDAX | Futures | 6682.9 | 6766.1 | 6663.8 | 6755.8 | 123999.0 |
| 2010-08-17 | FESX | Futures | 1679.8 | 1695.9 | 1673.6 | 1693.4 | 978285.0 |
| 2010-08-17 | FEU3 | Futures | 97.855 | 97.855 | 97.855 | 97.855 | 26.0 |
| 2010-08-17 | FGBL | Futures | 103.13 | 103.23 | 102.81 | 102.85 | 807199.0 |
| 2010-08-17 | FGBM | Futures | 106.31 | 106.37 | 106.1 | 106.15 | 418615.0 |
| 2010-08-17 | FGBS | Futures | 107.736 | 107.76 | 107.667 | 107.677 | 402672.0 |
| 2010-08-17 | FGBX | Futures | 104.54 | 105.78 | 104.54 | 105.03 | 5178.0 |
| 2010-08-17 | FTDX | Futures | 663.7 | 671.7 | 660.2 | 670.8 | 583.0 |
| 2010-08-17 | FTI | Futures | 258.14 | 262.77 | 258.14 | 262.45 | 43913.0 |
| 2010-08-17 | FTUK | Futures | 3626.6 | 3687.9 | 3621.1 | 3674.1 | 86480.0 |
| 2010-08-17 | G | Futures | 83.51 | 83.61 | 83.29 | 83.41 | 94869.0 |
| 2010-08-17 | GF | Futures | 286.151 | 288.174 | 285.52 | 286.594 | 1218.0 |
| 2010-08-17 | GSCI | Futures | 874.99 | 881.1 | 871.94 | 874.14 | 1092.0 |
| 2010-08-17 | HE | Futures | 98.405 | 100.216 | 98.141 | 99.491 | 13507.0 |
| 2010-08-17 | HG | Futures | 4.3935 | 4.4892 | 4.3848 | 4.4712 | 29624.0 |
| 2010-08-17 | HO | Futures | 1.741 | 1.7868 | 1.741 | 1.7754 | 44294.0 |
| 2010-08-17 | HRC | Futures | 2753.7 | 2753.7 | 2753.7 | 2753.7 | 0.0 |
| 2010-08-17 | J1 | Futures | 0.0147425 | 0.0147853 | 0.0146859 | 0.0147073 | 96154.0 |
| 2010-08-17 | J7 | Futures | 0.014628 | 0.014673 | 0.014578 | 0.014597 | 273.0 |
| 2010-08-17 | JB | Futures | 121.58 | 121.69 | 121.43 | 121.44 | 2573.0 |
| 2010-08-17 | KC | Futures | 448.53 | 452.17 | 439.24 | 440.74 | 14950.0 |
| 2010-08-17 | KE | Futures | 2931.82 | 2995.74 | 2884.95 | 2884.95 | 8387.0 |
> showing 50 of 92 rows — these rows as CSV