PREVIEW / futures_daily / 2010-05-20
file: by_date/futures_daily/2010/2010-05-20.parquet size: 9 KB rows: 90
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-05-20 | ES | Futures | 1080.9 | 1087.23 | 1039.27 | 1041.95 | 4378875.0 |
| 2010-05-20 | NQ | Futures | 2118.84 | 2127.06 | 2035.17 | 2042.55 | 575943.0 |
| 2010-05-20 | YM | Futures | 9565.0 | 9611.9 | 9223.9 | 9244.2 | 294103.0 |
| 2010-05-20 | CL | Futures | 159.19 | 160.35 | 150.66 | 154.92 | 553741.0 |
| 2010-05-20 | GC | Futures | 1634.1 | 1644.0 | 1612.1 | 1630.8 | 217743.0 |
| 2010-05-20 | ZN | Futures | 98.037191 | 99.172265 | 98.037191 | 98.725888 | 2065437.0 |
| 2010-05-20 | A6 | Futures | 0.69532 | 0.69532 | 0.66693 | 0.67735 | 248064.0 |
| 2010-05-20 | AD | Futures | 0.94639 | 0.94717 | 0.92082 | 0.92694 | 176298.0 |
| 2010-05-20 | B | Futures | 65.29 | 65.71 | 62.14 | 63.6 | 237621.0 |
| 2010-05-20 | B6 | Futures | 1.5002 | 1.5013 | 1.4771 | 1.4968 | 169648.0 |
| 2010-05-20 | BFX | Futures | 2774.0 | 2786.2 | 2672.4 | 2712.2 | 352.0 |
| 2010-05-20 | BR | Futures | 0.21715 | 0.21932 | 0.21657 | 0.21932 | 761.0 |
| 2010-05-20 | BZ | Futures | 67.32 | 67.5 | 65.42 | 66.92 | 45.0 |
| 2010-05-20 | C | Futures | 2250.0 | 2277.0 | 2243.0 | 2264.0 | 4667.0 |
| 2010-05-20 | CB | Futures | 78.959 | 78.959 | 78.959 | 78.959 | 22.0 |
| 2010-05-20 | CC | Futures | 2377.0 | 2396.0 | 2344.0 | 2385.0 | 6836.0 |
| 2010-05-20 | CT | Futures | 66.19 | 66.29 | 64.74 | 65.25 | 9887.0 |
| 2010-05-20 | DC | Futures | 22.56 | 22.8 | 22.51 | 22.71 | 154.0 |
| 2010-05-20 | DX | Futures | 87.63 | 88.147 | 86.698 | 86.851 | 49397.0 |
| 2010-05-20 | E1 | Futures | 1.14416 | 1.14982 | 1.13772 | 1.14785 | 75809.0 |
| 2010-05-20 | E6 | Futures | 1.46974 | 1.49056 | 1.45472 | 1.48678 | 605424.0 |
| 2010-05-20 | E7 | Futures | 1.4573 | 1.4788 | 1.4428 | 1.4746 | 9913.0 |
| 2010-05-20 | ED | Futures | 94.1647 | 94.1813 | 94.1244 | 94.1599 | 336095.0 |
| 2010-05-20 | ER | Futures | 97.321 | 97.34 | 97.296 | 97.316 | 196618.0 |
| 2010-05-20 | EW | Futures | 749.4 | 752.7 | 716.5 | 719.5 | 50195.0 |
| 2010-05-20 | FBTP | Futures | 64.85 | 64.87 | 64.46 | 64.63 | 6372.0 |
| 2010-05-20 | FCE | Futures | 2306.9 | 2336.1 | 2206.4 | 2254.2 | 177012.0 |
| 2010-05-20 | FDAX | Futures | 6525.2 | 6577.9 | 6289.1 | 6363.1 | 286732.0 |
| 2010-05-20 | FESX | Futures | 1594.7 | 1616.1 | 1528.5 | 1560.4 | 2953270.0 |
| 2010-05-20 | FEU3 | Futures | 97.889 | 97.894 | 97.874 | 97.874 | 19.0 |
| 2010-05-20 | FGBL | Futures | 99.54 | 100.34 | 99.26 | 100.13 | 1171780.0 |
| 2010-05-20 | FGBM | Futures | 104.49 | 105.11 | 104.37 | 104.94 | 680396.0 |
| 2010-05-20 | FGBS | Futures | 107.447 | 107.633 | 107.408 | 107.55 | 747387.0 |
| 2010-05-20 | FGBX | Futures | 96.55 | 98.23 | 96.22 | 97.94 | 6135.0 |
| 2010-05-20 | FTDX | Futures | 662.4 | 665.5 | 632.3 | 639.0 | 702.0 |
| 2010-05-20 | FTI | Futures | 252.98 | 255.46 | 242.8 | 247.59 | 47399.0 |
| 2010-05-20 | FTUK | Futures | 3493.2 | 3530.1 | 3370.4 | 3426.3 | 226810.0 |
| 2010-05-20 | G | Futures | 79.08 | 79.97 | 78.86 | 79.74 | 153801.0 |
| 2010-05-20 | GF | Futures | 284.318 | 285.329 | 277.056 | 278.95 | 6134.0 |
| 2010-05-20 | GSCI | Futures | 821.95 | 827.86 | 809.42 | 825.25 | 594.0 |
| 2010-05-20 | HE | Futures | 103.043 | 103.2 | 100.529 | 100.875 | 20869.0 |
| 2010-05-20 | HG | Futures | 4.0643 | 4.1356 | 3.9387 | 3.9985 | 49105.0 |
| 2010-05-20 | HO | Futures | 1.7623 | 1.7637 | 1.6829 | 1.7164 | 7151.0 |
| 2010-05-20 | J1 | Futures | 0.0137021 | 0.0141396 | 0.0136883 | 0.0139636 | 296914.0 |
| 2010-05-20 | J7 | Futures | 0.013608 | 0.014023 | 0.013582 | 0.013852 | 480.0 |
| 2010-05-20 | JB | Futures | 119.09 | 119.25 | 118.99 | 119.18 | 2256.0 |
| 2010-05-20 | KC | Futures | 337.15 | 338.17 | 330.68 | 334.23 | 18427.0 |
| 2010-05-20 | KE | Futures | 2138.95 | 2149.82 | 2104.17 | 2141.12 | 6931.0 |
| 2010-05-20 | KRW | Futures | 0.0008031 | 0.0008031 | 0.0007933 | 0.0007933 | 105.0 |
| 2010-05-20 | L | Futures | 97.829 | 97.838 | 97.809 | 97.819 | 45626.0 |
> showing 50 of 90 rows — these rows as CSV