PREVIEW / futures_daily / 2009-11-05
file: by_date/futures_daily/2009/2009-11-05.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-11-05 | ES | Futures | 1009.63 | 1026.26 | 1002.15 | 1025.54 | 1949016.0 |
| 2009-11-05 | NQ | Futures | 1904.07 | 1943.86 | 1886.86 | 1940.76 | 334091.0 |
| 2009-11-05 | YM | Futures | 8883.5 | 9051.4 | 8826.3 | 9036.9 | 158709.0 |
| 2009-11-05 | CL | Futures | 196.74 | 197.3 | 194.41 | 195.1 | 257603.0 |
| 2009-11-05 | GC | Futures | 1512.5 | 1514.0 | 1499.0 | 1505.9 | 111073.0 |
| 2009-11-05 | ZN | Futures | 93.965438 | 94.226972 | 93.865806 | 94.114886 | 762209.0 |
| 2009-11-05 | A6 | Futures | 0.73265 | 0.73484 | 0.72675 | 0.73306 | 79637.0 |
| 2009-11-05 | AD | Futures | 0.92833 | 0.92971 | 0.9231 | 0.92606 | 64103.0 |
| 2009-11-05 | B | Futures | 73.76 | 74.07 | 73.0 | 73.17 | 78968.0 |
| 2009-11-05 | B6 | Futures | 1.7226 | 1.7305 | 1.713 | 1.7253 | 139848.0 |
| 2009-11-05 | BFX | Futures | 2696.5 | 2743.4 | 2696.5 | 2737.1 | 72.0 |
| 2009-11-05 | BR | Futures | 0.23044 | 0.23044 | 0.23044 | 0.23044 | 166.0 |
| 2009-11-05 | C | Futures | 2223.0 | 2229.0 | 2188.0 | 2191.0 | 4006.0 |
| 2009-11-05 | CB | Futures | 80.148 | 80.148 | 77.997 | 77.997 | 2.0 |
| 2009-11-05 | CC | Futures | 2855.0 | 2862.0 | 2788.0 | 2815.0 | 7516.0 |
| 2009-11-05 | CT | Futures | 58.51 | 59.04 | 58.0 | 58.17 | 7479.0 |
| 2009-11-05 | DC | Futures | 25.24 | 25.4 | 25.04 | 25.1 | 193.0 |
| 2009-11-05 | DX | Futures | 77.603 | 77.761 | 77.23 | 77.455 | 15221.0 |
| 2009-11-05 | E1 | Futures | 1.30135 | 1.30386 | 1.2962 | 1.29963 | 44868.0 |
| 2009-11-05 | E6 | Futures | 1.76278 | 1.76776 | 1.7552 | 1.76195 | 207097.0 |
| 2009-11-05 | E7 | Futures | 1.745 | 1.7508 | 1.7384 | 1.7451 | 2086.0 |
| 2009-11-05 | ED | Futures | 94.238 | 94.2569 | 94.238 | 94.2474 | 110487.0 |
| 2009-11-05 | ER | Futures | 97.139 | 97.169 | 97.125 | 97.159 | 159186.0 |
| 2009-11-05 | EW | Futures | 646.8 | 661.0 | 642.8 | 659.8 | 41823.0 |
| 2009-11-05 | FBTP | Futures | 62.5 | 62.59 | 62.3 | 62.48 | 2514.0 |
| 2009-11-05 | FCE | Futures | 2386.6 | 2454.3 | 2379.6 | 2441.1 | 161413.0 |
| 2009-11-05 | FDAX | Futures | 5856.7 | 6001.9 | 5829.5 | 5973.7 | 167985.0 |
| 2009-11-05 | FESX | Futures | 1624.7 | 1671.3 | 1616.3 | 1662.9 | 1375090.0 |
| 2009-11-05 | FEU3 | Futures | 97.727 | 97.732 | 97.727 | 97.732 | 203.0 |
| 2009-11-05 | FGBL | Futures | 93.34 | 93.59 | 92.98 | 93.25 | 993456.0 |
| 2009-11-05 | FGBM | Futures | 99.0 | 99.17 | 98.69 | 98.93 | 655525.0 |
| 2009-11-05 | FGBS | Futures | 104.745 | 104.794 | 104.6 | 104.716 | 740600.0 |
| 2009-11-05 | FGBX | Futures | 86.05 | 86.27 | 85.63 | 86.05 | 2779.0 |
| 2009-11-05 | FTDX | Futures | 648.2 | 670.5 | 646.0 | 668.7 | 361.0 |
| 2009-11-05 | FTI | Futures | 246.21 | 252.47 | 244.7 | 251.33 | 35699.0 |
| 2009-11-05 | FTUK | Futures | 3342.9 | 3407.2 | 3327.3 | 3396.0 | 96693.0 |
| 2009-11-05 | G | Futures | 75.94 | 76.22 | 75.1 | 75.65 | 136811.0 |
| 2009-11-05 | GF | Futures | 263.089 | 264.258 | 262.47 | 263.02 | 894.0 |
| 2009-11-05 | GSCI | Futures | 1006.88 | 1010.91 | 999.6 | 1001.86 | 351.0 |
| 2009-11-05 | HE | Futures | 88.416 | 89.025 | 86.243 | 86.281 | 13061.0 |
| 2009-11-05 | HG | Futures | 4.1771 | 4.1771 | 4.1011 | 4.1206 | 18766.0 |
| 2009-11-05 | HO | Futures | 2.0174 | 2.0266 | 1.986 | 1.9932 | 44087.0 |
| 2009-11-05 | HRC | Futures | 2713.1 | 2713.1 | 2713.1 | 2713.1 | 0.0 |
| 2009-11-05 | J1 | Futures | 0.0138262 | 0.0139556 | 0.0138225 | 0.013835 | 74951.0 |
| 2009-11-05 | J7 | Futures | 0.013657 | 0.013771 | 0.013655 | 0.013655 | 31.0 |
| 2009-11-05 | JB | Futures | 116.36 | 116.37 | 116.01 | 116.15 | 1255.0 |
| 2009-11-05 | KC | Futures | 371.01 | 380.12 | 368.9 | 375.1 | 16610.0 |
| 2009-11-05 | KE | Futures | 2441.68 | 2447.5 | 2398.64 | 2407.95 | 7338.0 |
| 2009-11-05 | L | Futures | 97.76 | 97.789 | 97.72 | 97.73 | 112728.0 |
| 2009-11-05 | LBS | Futures | 765.8 | 776.4 | 764.2 | 768.3 | 129.0 |
> showing 50 of 88 rows — these rows as CSV