PREVIEW / futures_daily / 2010-06-24
file: by_date/futures_daily/2010/2010-06-24.parquet size: 9 KB rows: 89
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-06-24 | ES | Futures | 1059.72 | 1064.11 | 1040.21 | 1044.12 | 2551855.0 |
| 2010-06-24 | NQ | Futures | 2116.51 | 2122.45 | 2079.45 | 2093.31 | 339934.0 |
| 2010-06-24 | YM | Futures | 9464.1 | 9493.7 | 9308.8 | 9337.4 | 170376.0 |
| 2010-06-24 | CL | Futures | 162.32 | 163.54 | 160.87 | 163.41 | 260401.0 |
| 2010-06-24 | GC | Futures | 1688.2 | 1704.4 | 1675.1 | 1699.5 | 130027.0 |
| 2010-06-24 | ZN | Futures | 99.427864 | 99.812052 | 99.299801 | 99.44067 | 1256776.0 |
| 2010-06-24 | A6 | Futures | 0.71762 | 0.72035 | 0.70966 | 0.71339 | 93783.0 |
| 2010-06-24 | AD | Futures | 0.95014 | 0.95142 | 0.94273 | 0.94708 | 83345.0 |
| 2010-06-24 | B | Futures | 66.71 | 67.3 | 66.16 | 67.1 | 135750.0 |
| 2010-06-24 | B6 | Futures | 1.5527 | 1.5579 | 1.5479 | 1.5498 | 110175.0 |
| 2010-06-24 | BFX | Futures | 2857.1 | 2857.1 | 2802.7 | 2802.7 | 107.0 |
| 2010-06-24 | BZ | Futures | 71.87 | 72.43 | 71.38 | 72.37 | 66.0 |
| 2010-06-24 | C | Futures | 2484.0 | 2531.0 | 2477.0 | 2525.0 | 2455.0 |
| 2010-06-24 | CC | Futures | 2552.0 | 2603.0 | 2545.0 | 2597.0 | 8403.0 |
| 2010-06-24 | CSC | Futures | 3.581 | 3.607 | 3.581 | 3.604 | 10.0 |
| 2010-06-24 | CT | Futures | 67.12 | 67.68 | 66.71 | 67.31 | 101.0 |
| 2010-06-24 | DC | Futures | 21.93 | 22.14 | 21.93 | 22.06 | 38.0 |
| 2010-06-24 | DX | Futures | 86.812 | 86.963 | 86.363 | 86.698 | 18669.0 |
| 2010-06-24 | E1 | Futures | 1.18974 | 1.19762 | 1.18869 | 1.19289 | 37186.0 |
| 2010-06-24 | E6 | Futures | 1.45648 | 1.4657 | 1.45068 | 1.45896 | 343129.0 |
| 2010-06-24 | E7 | Futures | 1.446 | 1.4551 | 1.4404 | 1.4485 | 4888.0 |
| 2010-06-24 | ED | Futures | 94.2189 | 94.2474 | 94.2047 | 94.2142 | 180363.0 |
| 2010-06-24 | ER | Futures | 97.281 | 97.311 | 97.281 | 97.296 | 98463.0 |
| 2010-06-24 | EW | Futures | 731.2 | 734.1 | 719.1 | 721.2 | 29333.0 |
| 2010-06-24 | FBTP | Futures | 64.83 | 65.07 | 64.75 | 64.91 | 5904.0 |
| 2010-06-24 | FCE | Futures | 2408.3 | 2415.8 | 2328.6 | 2338.2 | 167667.0 |
| 2010-06-24 | FDAX | Futures | 6783.0 | 6801.5 | 6638.3 | 6661.1 | 158233.0 |
| 2010-06-24 | FESX | Futures | 1679.2 | 1686.0 | 1628.4 | 1634.0 | 1571370.0 |
| 2010-06-24 | FEU3 | Futures | 97.85 | 97.855 | 97.85 | 97.855 | 36.0 |
| 2010-06-24 | FGBL | Futures | 100.3 | 100.88 | 100.28 | 100.86 | 712809.0 |
| 2010-06-24 | FGBM | Futures | 105.0 | 105.42 | 104.99 | 105.41 | 428794.0 |
| 2010-06-24 | FGBS | Futures | 107.598 | 107.736 | 107.593 | 107.721 | 396699.0 |
| 2010-06-24 | FGBX | Futures | 98.99 | 99.85 | 98.95 | 99.71 | 2942.0 |
| 2010-06-24 | FTDX | Futures | 685.3 | 685.3 | 667.2 | 667.7 | 847.0 |
| 2010-06-24 | FTI | Futures | 266.89 | 268.04 | 260.24 | 260.83 | 42790.0 |
| 2010-06-24 | FTUK | Futures | 3559.9 | 3561.2 | 3479.7 | 3486.6 | 108748.0 |
| 2010-06-24 | G | Futures | 80.78 | 81.12 | 80.67 | 81.04 | 83730.0 |
| 2010-06-24 | GF | Futures | 282.487 | 285.139 | 282.424 | 284.634 | 1442.0 |
| 2010-06-24 | GSCI | Futures | 856.01 | 858.06 | 848.84 | 856.35 | 367.0 |
| 2010-06-24 | HE | Futures | 101.478 | 102.104 | 100.102 | 100.196 | 6747.0 |
| 2010-06-24 | HG | Futures | 3.9723 | 4.06 | 3.9642 | 4.05 | 13019.0 |
| 2010-06-24 | HO | Futures | 1.8412 | 1.8531 | 1.8221 | 1.8434 | 11062.0 |
| 2010-06-24 | HRC | Futures | 2994.3 | 2994.3 | 2994.3 | 2994.3 | 0.0 |
| 2010-06-24 | J1 | Futures | 0.014009 | 0.0141197 | 0.0140002 | 0.0140694 | 133882.0 |
| 2010-06-24 | J7 | Futures | 0.013902 | 0.014011 | 0.013902 | 0.013963 | 366.0 |
| 2010-06-24 | JB | Futures | 119.98 | 122.01 | 119.98 | 120.18 | 1853.0 |
| 2010-06-24 | KC | Futures | 403.07 | 443.26 | 403.07 | 423.79 | 19529.0 |
| 2010-06-24 | KE | Futures | 2151.99 | 2173.3 | 2146.67 | 2151.99 | 9798.0 |
| 2010-06-24 | L | Futures | 98.017 | 98.036 | 97.987 | 97.997 | 34077.0 |
| 2010-06-24 | LBS | Futures | 554.0 | 570.1 | 552.8 | 563.3 | 184.0 |
> showing 50 of 89 rows — these rows as CSV