PREVIEW / futures_daily / 2010-05-25
file: by_date/futures_daily/2010/2010-05-25.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-05-25 | ES | Futures | 1041.46 | 1046.58 | 1009.57 | 1044.87 | 3433912.0 |
| 2010-05-25 | NQ | Futures | 2053.04 | 2064.1 | 1990.08 | 2059.56 | 425513.0 |
| 2010-05-25 | YM | Futures | 9224.8 | 9229.4 | 8969.3 | 9215.7 | 199829.0 |
| 2010-05-25 | CL | Futures | 152.95 | 153.26 | 146.94 | 150.44 | 395399.0 |
| 2010-05-25 | GC | Futures | 1636.0 | 1652.6 | 1626.1 | 1643.7 | 218485.0 |
| 2010-05-25 | ZN | Futures | 99.108497 | 99.950237 | 99.082989 | 99.312555 | 2139365.0 |
| 2010-05-25 | A6 | Futures | 0.67538 | 0.678 | 0.66044 | 0.6707 | 146968.0 |
| 2010-05-25 | AD | Futures | 0.92842 | 0.92901 | 0.90947 | 0.91766 | 126564.0 |
| 2010-05-25 | B | Futures | 63.0 | 63.0 | 60.57 | 61.76 | 77613.0 |
| 2010-05-25 | B6 | Futures | 1.4962 | 1.4965 | 1.4805 | 1.4914 | 105256.0 |
| 2010-05-25 | BFX | Futures | 2651.7 | 2664.4 | 2637.2 | 2648.9 | 70.0 |
| 2010-05-25 | BR | Futures | 0.21968 | 0.21968 | 0.21831 | 0.21831 | 437.0 |
| 2010-05-25 | BZ | Futures | 66.3 | 66.97 | 66.3 | 66.6 | 7.0 |
| 2010-05-25 | C | Futures | 2324.0 | 2385.0 | 2315.0 | 2382.0 | 5462.0 |
| 2010-05-25 | CB | Futures | 77.258 | 77.258 | 76.775 | 77.258 | 22.0 |
| 2010-05-25 | CC | Futures | 2424.0 | 2468.0 | 2414.0 | 2455.0 | 6151.0 |
| 2010-05-25 | CT | Futures | 65.37 | 65.39 | 64.5 | 65.23 | 10991.0 |
| 2010-05-25 | DC | Futures | 22.76 | 22.76 | 22.08 | 22.13 | 251.0 |
| 2010-05-25 | DX | Futures | 87.757 | 88.72 | 87.58 | 88.049 | 37321.0 |
| 2010-05-25 | E1 | Futures | 1.13535 | 1.13969 | 1.12692 | 1.13732 | 68960.0 |
| 2010-05-25 | E6 | Futures | 1.46134 | 1.46194 | 1.441 | 1.4572 | 400948.0 |
| 2010-05-25 | E7 | Futures | 1.4494 | 1.4498 | 1.4292 | 1.4453 | 8603.0 |
| 2010-05-25 | ED | Futures | 94.0557 | 94.0676 | 93.9823 | 94.051 | 370183.0 |
| 2010-05-25 | ER | Futures | 97.286 | 97.33 | 97.262 | 97.316 | 251175.0 |
| 2010-05-25 | EW | Futures | 720.7 | 722.6 | 694.4 | 719.8 | 41458.0 |
| 2010-05-25 | FBTP | Futures | 64.91 | 65.0 | 64.6 | 64.72 | 4636.0 |
| 2010-05-25 | FCE | Futures | 2186.2 | 2233.0 | 2159.0 | 2188.9 | 201394.0 |
| 2010-05-25 | FDAX | Futures | 6154.8 | 6253.2 | 6099.9 | 6180.9 | 232558.0 |
| 2010-05-25 | FESX | Futures | 1508.3 | 1546.3 | 1490.0 | 1519.4 | 2340698.0 |
| 2010-05-25 | FEU3 | Futures | 97.855 | 97.879 | 97.825 | 97.874 | 313.0 |
| 2010-05-25 | FGBL | Futures | 100.56 | 101.1 | 100.53 | 100.97 | 1015407.0 |
| 2010-05-25 | FGBM | Futures | 105.05 | 105.43 | 105.01 | 105.35 | 570907.0 |
| 2010-05-25 | FGBS | Futures | 107.569 | 107.638 | 107.515 | 107.574 | 607939.0 |
| 2010-05-25 | FGBX | Futures | 99.04 | 100.55 | 99.04 | 100.16 | 5299.0 |
| 2010-05-25 | FTDX | Futures | 630.1 | 630.1 | 608.0 | 612.9 | 1069.0 |
| 2010-05-25 | FTI | Futures | 240.51 | 244.21 | 237.13 | 239.85 | 53016.0 |
| 2010-05-25 | FTUK | Futures | 3329.5 | 3389.0 | 3304.8 | 3340.3 | 179009.0 |
| 2010-05-25 | G | Futures | 79.86 | 80.31 | 79.85 | 80.18 | 228638.0 |
| 2010-05-25 | GF | Futures | 274.845 | 274.908 | 270.803 | 270.993 | 3487.0 |
| 2010-05-25 | GSCI | Futures | 802.64 | 813.95 | 797.6 | 810.47 | 300.0 |
| 2010-05-25 | HE | Futures | 102.666 | 102.792 | 101.283 | 102.006 | 6470.0 |
| 2010-05-25 | HG | Futures | 4.2354 | 4.2361 | 4.084 | 4.1309 | 37344.0 |
| 2010-05-25 | HO | Futures | 1.6975 | 1.6977 | 1.6584 | 1.6883 | 8615.0 |
| 2010-05-25 | HRC | Futures | 2971.6 | 2971.6 | 2971.6 | 2971.6 | 0.0 |
| 2010-05-25 | J1 | Futures | 0.0139297 | 0.0140931 | 0.0139259 | 0.0139548 | 172240.0 |
| 2010-05-25 | J7 | Futures | 0.013821 | 0.013977 | 0.013821 | 0.013843 | 449.0 |
| 2010-05-25 | JB | Futures | 119.36 | 119.8 | 119.3 | 119.77 | 1931.0 |
| 2010-05-25 | KC | Futures | 334.87 | 338.42 | 331.57 | 337.02 | 12739.0 |
| 2010-05-25 | KE | Futures | 2122.65 | 2134.6 | 2088.95 | 2107.43 | 9173.0 |
| 2010-05-25 | KRW | Futures | 0.0007824 | 0.0007824 | 0.0007824 | 0.0007824 | 4.0 |
> showing 50 of 91 rows — these rows as CSV