PREVIEW / futures_daily / 2010-08-19
file: by_date/futures_daily/2010/2010-08-19.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-19 | ES | Futures | 1060.21 | 1068.01 | 1042.16 | 1044.85 | 2433838.0 |
| 2010-08-19 | NQ | Futures | 2081.14 | 2094.44 | 2048.89 | 2059.92 | 346596.0 |
| 2010-08-19 | YM | Futures | 9577.8 | 9638.8 | 9427.1 | 9463.2 | 149666.0 |
| 2010-08-19 | CL | Futures | 159.6 | 161.31 | 156.77 | 157.72 | 288023.0 |
| 2010-08-19 | GC | Futures | 1673.2 | 1684.8 | 1671.2 | 1679.2 | 86559.0 |
| 2010-08-19 | ZN | Futures | 103.013619 | 103.397807 | 102.616625 | 103.231326 | 1468059.0 |
| 2010-08-19 | A6 | Futures | 0.7424 | 0.74546 | 0.73602 | 0.73701 | 106630.0 |
| 2010-08-19 | AD | Futures | 0.95952 | 0.96337 | 0.94777 | 0.94974 | 90597.0 |
| 2010-08-19 | B | Futures | 66.29 | 67.04 | 65.16 | 65.42 | 141497.0 |
| 2010-08-19 | B6 | Futures | 1.6187 | 1.6263 | 1.6092 | 1.6182 | 143218.0 |
| 2010-08-19 | BFX | Futures | 2880.3 | 2880.3 | 2823.3 | 2828.6 | 322.0 |
| 2010-08-19 | BR | Futures | 0.23766 | 0.23766 | 0.23655 | 0.23655 | 582.0 |
| 2010-08-19 | BZ | Futures | 71.74 | 71.74 | 70.12 | 70.39 | 260.0 |
| 2010-08-19 | C | Futures | 2262.0 | 2273.0 | 2249.0 | 2253.0 | 1940.0 |
| 2010-08-19 | CB | Futures | 93.193 | 94.159 | 93.193 | 94.159 | 16.0 |
| 2010-08-19 | CC | Futures | 2401.0 | 2410.0 | 2377.0 | 2394.0 | 4238.0 |
| 2010-08-19 | CSC | Futures | 3.772 | 3.772 | 3.772 | 3.772 | 39.0 |
| 2010-08-19 | CT | Futures | 73.99 | 74.31 | 73.81 | 74.01 | 40.0 |
| 2010-08-19 | DC | Futures | 23.62 | 23.71 | 23.51 | 23.65 | 156.0 |
| 2010-08-19 | DX | Futures | 83.279 | 83.491 | 82.745 | 83.193 | 20378.0 |
| 2010-08-19 | E1 | Futures | 1.25895 | 1.28075 | 1.25528 | 1.27156 | 52939.0 |
| 2010-08-19 | E6 | Futures | 1.51998 | 1.52577 | 1.51004 | 1.51619 | 375279.0 |
| 2010-08-19 | E7 | Futures | 1.5088 | 1.5144 | 1.4993 | 1.5053 | 4421.0 |
| 2010-08-19 | ED | Futures | 94.5772 | 94.5843 | 94.5748 | 94.5796 | 142889.0 |
| 2010-08-19 | ER | Futures | 97.296 | 97.306 | 97.286 | 97.301 | 86436.0 |
| 2010-08-19 | EW | Futures | 728.1 | 734.3 | 718.4 | 720.6 | 31792.0 |
| 2010-08-19 | FBTP | Futures | 67.2 | 67.29 | 67.08 | 67.2 | 2665.0 |
| 2010-08-19 | FCE | Futures | 2404.2 | 2424.0 | 2339.6 | 2354.1 | 119129.0 |
| 2010-08-19 | FDAX | Futures | 6745.4 | 6781.3 | 6585.5 | 6618.2 | 206317.0 |
| 2010-08-19 | FESX | Futures | 1692.2 | 1703.3 | 1642.7 | 1656.9 | 1868613.0 |
| 2010-08-19 | FEU3 | Futures | 97.85 | 97.859 | 97.85 | 97.859 | 27.0 |
| 2010-08-19 | FGBL | Futures | 103.15 | 103.58 | 102.92 | 103.45 | 899575.0 |
| 2010-08-19 | FGBM | Futures | 106.35 | 106.51 | 106.18 | 106.42 | 359738.0 |
| 2010-08-19 | FGBS | Futures | 107.716 | 107.755 | 107.647 | 107.716 | 365519.0 |
| 2010-08-19 | FGBX | Futures | 105.56 | 106.18 | 104.92 | 105.92 | 4269.0 |
| 2010-08-19 | FTDX | Futures | 669.9 | 675.2 | 658.9 | 661.5 | 583.0 |
| 2010-08-19 | FTI | Futures | 262.69 | 263.81 | 256.02 | 257.42 | 29026.0 |
| 2010-08-19 | FTUK | Futures | 3668.9 | 3671.7 | 3561.2 | 3586.7 | 142679.0 |
| 2010-08-19 | G | Futures | 83.52 | 83.9 | 83.41 | 83.76 | 91800.0 |
| 2010-08-19 | GF | Futures | 288.932 | 294.304 | 288.932 | 292.345 | 2177.0 |
| 2010-08-19 | GSCI | Futures | 875.84 | 875.84 | 862.26 | 865.66 | 102.0 |
| 2010-08-19 | HE | Futures | 103.74 | 104.53 | 102.093 | 102.554 | 18940.0 |
| 2010-08-19 | HG | Futures | 4.4859 | 4.5513 | 4.4245 | 4.4572 | 8812.0 |
| 2010-08-19 | HO | Futures | 1.7762 | 1.786 | 1.7442 | 1.7498 | 8391.0 |
| 2010-08-19 | HRC | Futures | 2753.7 | 2753.7 | 2753.7 | 2753.7 | 0.0 |
| 2010-08-19 | J1 | Futures | 0.0147337 | 0.014823 | 0.0146444 | 0.0147488 | 161646.0 |
| 2010-08-19 | J7 | Futures | 0.014613 | 0.014711 | 0.014537 | 0.014638 | 332.0 |
| 2010-08-19 | JB | Futures | 121.77 | 121.82 | 121.5 | 121.59 | 1705.0 |
| 2010-08-19 | KC | Futures | 439.74 | 447.53 | 439.24 | 445.27 | 5202.0 |
| 2010-08-19 | KE | Futures | 2916.91 | 3086.3 | 2916.91 | 3005.33 | 5413.0 |
> showing 50 of 92 rows — these rows as CSV