PREVIEW / futures_daily / 2010-11-23
file: by_date/futures_daily/2010/2010-11-23.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-11-23 | ES | Futures | 1173.25 | 1173.99 | 1151.44 | 1154.87 | 2456997.0 |
| 2010-11-23 | NQ | Futures | 2440.99 | 2442.69 | 2386.56 | 2402.72 | 342591.0 |
| 2010-11-23 | YM | Futures | 10387.1 | 10387.1 | 10205.6 | 10248.4 | 137506.0 |
| 2010-11-23 | CL | Futures | 167.58 | 168.59 | 164.85 | 166.84 | 351860.0 |
| 2010-11-23 | GC | Futures | 1856.5 | 1879.7 | 1842.6 | 1872.5 | 249519.0 |
| 2010-11-23 | ZN | Futures | 103.322436 | 103.941828 | 103.296628 | 103.567612 | 1619901.0 |
| 2010-11-23 | A6 | Futures | 0.82704 | 0.82745 | 0.81277 | 0.81352 | 130224.0 |
| 2010-11-23 | AD | Futures | 0.97281 | 0.97449 | 0.96478 | 0.96716 | 101583.0 |
| 2010-11-23 | B | Futures | 71.25 | 71.46 | 70.12 | 70.82 | 176088.0 |
| 2010-11-23 | B6 | Futures | 1.6564 | 1.6568 | 1.6356 | 1.638 | 130800.0 |
| 2010-11-23 | BFX | Futures | 3028.1 | 3028.9 | 2981.9 | 2981.9 | 123.0 |
| 2010-11-23 | BR | Futures | 0.24749 | 0.24749 | 0.24537 | 0.24576 | 2535.0 |
| 2010-11-23 | BZ | Futures | 74.96 | 75.5 | 74.2 | 74.91 | 321.0 |
| 2010-11-23 | C | Futures | 2048.0 | 2066.0 | 2039.0 | 2039.0 | 9682.0 |
| 2010-11-23 | CB | Futures | 93.868 | 94.015 | 93.575 | 94.015 | 20.0 |
| 2010-11-23 | CC | Futures | 2311.0 | 2324.0 | 2274.0 | 2275.0 | 6285.0 |
| 2010-11-23 | CSC | Futures | 3.374 | 3.374 | 3.374 | 3.374 | 7.0 |
| 2010-11-23 | CT | Futures | 102.8 | 102.8 | 93.83 | 95.72 | 770.0 |
| 2010-11-23 | DC | Futures | 23.01 | 23.11 | 22.85 | 23.01 | 99.0 |
| 2010-11-23 | DX | Futures | 79.111 | 80.079 | 79.051 | 80.016 | 31153.0 |
| 2010-11-23 | E1 | Futures | 1.32894 | 1.33341 | 1.31634 | 1.31752 | 51621.0 |
| 2010-11-23 | E6 | Futures | 1.6113 | 1.61213 | 1.58019 | 1.58185 | 452251.0 |
| 2010-11-23 | E7 | Futures | 1.5993 | 1.5997 | 1.5683 | 1.5698 | 7591.0 |
| 2010-11-23 | ED | Futures | 94.753 | 94.753 | 94.7411 | 94.7458 | 206387.0 |
| 2010-11-23 | ER | Futures | 97.247 | 97.262 | 97.242 | 97.252 | 135745.0 |
| 2010-11-23 | EW | Futures | 840.9 | 840.9 | 826.8 | 830.8 | 25555.0 |
| 2010-11-23 | FBTP | Futures | 65.95 | 65.97 | 65.5 | 65.68 | 7767.0 |
| 2010-11-23 | FCE | Futures | 2541.5 | 2546.8 | 2491.6 | 2492.3 | 175811.0 |
| 2010-11-23 | FDAX | Futures | 7316.1 | 7349.5 | 7218.8 | 7228.5 | 188959.0 |
| 2010-11-23 | FESX | Futures | 1742.5 | 1748.1 | 1708.8 | 1712.6 | 1628101.0 |
| 2010-11-23 | FEU3 | Futures | 97.81 | 97.815 | 97.805 | 97.815 | 25.0 |
| 2010-11-23 | FGBL | Futures | 101.4 | 101.96 | 101.28 | 101.92 | 1075755.0 |
| 2010-11-23 | FGBM | Futures | 105.5 | 106.0 | 105.47 | 105.92 | 611130.0 |
| 2010-11-23 | FGBS | Futures | 107.317 | 107.519 | 107.312 | 107.474 | 580593.0 |
| 2010-11-23 | FGBX | Futures | 102.71 | 104.33 | 102.6 | 104.16 | 3875.0 |
| 2010-11-23 | FTDX | Futures | 687.9 | 689.7 | 685.3 | 685.3 | 750.0 |
| 2010-11-23 | FTI | Futures | 273.63 | 275.0 | 269.21 | 269.33 | 44567.0 |
| 2010-11-23 | FTUK | Futures | 3924.2 | 3924.2 | 3853.4 | 3866.1 | 104446.0 |
| 2010-11-23 | G | Futures | 82.52 | 82.83 | 82.33 | 82.79 | 193884.0 |
| 2010-11-23 | GF | Futures | 292.327 | 294.258 | 291.767 | 293.51 | 2361.0 |
| 2010-11-23 | GSCI | Futures | 904.48 | 919.95 | 904.48 | 915.88 | 137.0 |
| 2010-11-23 | HE | Futures | 96.442 | 96.787 | 95.094 | 96.442 | 11096.0 |
| 2010-11-23 | HG | Futures | 5.0384 | 5.051 | 4.8878 | 4.9457 | 16714.0 |
| 2010-11-23 | HO | Futures | 1.9181 | 1.9217 | 1.89 | 1.9053 | 6295.0 |
| 2010-11-23 | HRC | Futures | 2391.9 | 2391.9 | 2391.9 | 2391.9 | 0.0 |
| 2010-11-23 | J1 | Futures | 0.015082 | 0.01518 | 0.0149803 | 0.0151034 | 152712.0 |
| 2010-11-23 | J7 | Futures | 0.014977 | 0.015072 | 0.014879 | 0.015 | 206.0 |
| 2010-11-23 | JB | Futures | 120.53 | 120.64 | 120.53 | 120.63 | 125.0 |
| 2010-11-23 | KC | Futures | 507.62 | 518.9 | 494.01 | 516.33 | 9658.0 |
| 2010-11-23 | KE | Futures | 2980.94 | 3000.76 | 2924.62 | 2968.42 | 14428.0 |
> showing 50 of 92 rows — these rows as CSV