PREVIEW / futures_daily / 2009-12-21
file: by_date/futures_daily/2009/2009-12-21.parquet size: 9 KB rows: 88
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-21 | ES | Futures | 1065.07 | 1079.12 | 1062.89 | 1074.28 | 1163792.0 |
| 2009-12-21 | NQ | Futures | 2042.67 | 2074.06 | 2039.28 | 2064.73 | 220689.0 |
| 2009-12-21 | YM | Futures | 9386.5 | 9497.9 | 9372.8 | 9446.8 | 83639.0 |
| 2009-12-21 | CL | Futures | 176.41 | 178.43 | 173.52 | 174.83 | 189118.0 |
| 2009-12-21 | GC | Futures | 1530.4 | 1542.7 | 1501.4 | 1508.6 | 137627.0 |
| 2009-12-21 | ZN | Futures | 94.819308 | 94.894872 | 93.925143 | 94.0133 | 560228.0 |
| 2009-12-21 | A6 | Futures | 0.71608 | 0.71738 | 0.70925 | 0.7095 | 47083.0 |
| 2009-12-21 | AD | Futures | 0.92476 | 0.937 | 0.92259 | 0.93029 | 69075.0 |
| 2009-12-21 | B | Futures | 67.63 | 68.57 | 66.58 | 67.05 | 80463.0 |
| 2009-12-21 | B6 | Futures | 1.6739 | 1.678 | 1.6639 | 1.6665 | 60964.0 |
| 2009-12-21 | BFX | Futures | 2781.2 | 2810.6 | 2777.8 | 2806.3 | 195.0 |
| 2009-12-21 | BR | Futures | 0.22321 | 0.22321 | 0.22321 | 0.22321 | 96.0 |
| 2009-12-21 | C | Futures | 2256.0 | 2288.0 | 2244.0 | 2245.0 | 6331.0 |
| 2009-12-21 | CC | Futures | 2805.0 | 2844.0 | 2790.0 | 2793.0 | 7117.0 |
| 2009-12-21 | CT | Futures | 61.15 | 61.79 | 61.06 | 61.11 | 4094.0 |
| 2009-12-21 | DC | Futures | 24.79 | 24.97 | 24.76 | 24.82 | 154.0 |
| 2009-12-21 | DX | Futures | 79.489 | 79.83 | 79.286 | 79.749 | 18220.0 |
| 2009-12-21 | E1 | Futures | 1.26757 | 1.26941 | 1.25873 | 1.2619 | 37149.0 |
| 2009-12-21 | E6 | Futures | 1.69398 | 1.7012 | 1.68877 | 1.69138 | 139737.0 |
| 2009-12-21 | E7 | Futures | 1.6822 | 1.6894 | 1.6771 | 1.6796 | 1998.0 |
| 2009-12-21 | EBM | Futures | 223.08 | 223.51 | 221.81 | 223.08 | 2160.0 |
| 2009-12-21 | ED | Futures | 94.3063 | 94.311 | 94.2921 | 94.3015 | 81026.0 |
| 2009-12-21 | ER | Futures | 97.218 | 97.228 | 97.208 | 97.223 | 59195.0 |
| 2009-12-21 | EW | Futures | 694.5 | 702.5 | 693.3 | 700.7 | 18277.0 |
| 2009-12-21 | FBTP | Futures | 63.52 | 63.58 | 63.22 | 63.29 | 1634.0 |
| 2009-12-21 | FCE | Futures | 2486.8 | 2536.1 | 2483.8 | 2531.9 | 88251.0 |
| 2009-12-21 | FDAX | Futures | 6407.8 | 6497.3 | 6393.0 | 6475.5 | 126077.0 |
| 2009-12-21 | FESX | Futures | 1722.1 | 1755.6 | 1718.5 | 1747.3 | 704380.0 |
| 2009-12-21 | FEU3 | Futures | 97.776 | 97.786 | 97.776 | 97.786 | 20.0 |
| 2009-12-21 | FGBL | Futures | 95.17 | 95.25 | 94.72 | 94.87 | 328861.0 |
| 2009-12-21 | FGBM | Futures | 100.58 | 100.62 | 100.38 | 100.44 | 195399.0 |
| 2009-12-21 | FGBS | Futures | 105.503 | 105.508 | 105.45 | 105.474 | 217212.0 |
| 2009-12-21 | FGBX | Futures | 89.53 | 89.57 | 88.55 | 88.76 | 2193.0 |
| 2009-12-21 | FTDX | Futures | 722.6 | 726.1 | 719.9 | 721.2 | 233.0 |
| 2009-12-21 | FTI | Futures | 265.98 | 270.14 | 265.58 | 269.82 | 21516.0 |
| 2009-12-21 | FTUK | Futures | 3463.7 | 3536.4 | 3459.7 | 3515.3 | 80646.0 |
| 2009-12-21 | G | Futures | 76.16 | 76.37 | 75.8 | 75.9 | 39647.0 |
| 2009-12-21 | GF | Futures | 257.407 | 258.56 | 256.051 | 256.458 | 2042.0 |
| 2009-12-21 | GSCI | Futures | 949.81 | 958.34 | 939.2 | 940.33 | 407.0 |
| 2009-12-21 | HE | Futures | 87.212 | 87.647 | 85.539 | 85.941 | 10031.0 |
| 2009-12-21 | HG | Futures | 4.3366 | 4.3787 | 4.3269 | 4.3573 | 12004.0 |
| 2009-12-21 | HO | Futures | 1.855 | 1.8801 | 1.8327 | 1.8426 | 9012.0 |
| 2009-12-21 | HRC | Futures | 2561.7 | 2561.7 | 2561.7 | 2561.7 | 0.0 |
| 2009-12-21 | J1 | Futures | 0.0139082 | 0.013951 | 0.0137987 | 0.0138063 | 52261.0 |
| 2009-12-21 | J7 | Futures | 0.013732 | 0.013773 | 0.013625 | 0.013633 | 293.0 |
| 2009-12-21 | JB | Futures | 118.35 | 118.51 | 118.29 | 118.48 | 1017.0 |
| 2009-12-21 | KC | Futures | 381.07 | 383.28 | 377.82 | 378.99 | 5611.0 |
| 2009-12-21 | KE | Futures | 2366.36 | 2375.41 | 2331.31 | 2334.7 | 3860.0 |
| 2009-12-21 | L | Futures | 97.779 | 97.779 | 97.74 | 97.779 | 33810.0 |
| 2009-12-21 | LBS | Futures | 787.3 | 803.4 | 781.4 | 781.4 | 471.0 |
> showing 50 of 88 rows — these rows as CSV