PREVIEW / futures_daily / 2008-11-21
file: by_date/futures_daily/2008/2008-11-21.parquet size: 8 KB rows: 84
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 |
|---|---|---|---|---|---|---|---|
| 2008-11-21 | ES | Futures | 705.98 | 755.42 | 695.86 | 745.77 | 4278847.0 |
| 2008-11-21 | NQ | Futures | 1167.1 | 1222.46 | 1138.3 | 1220.23 | 511389.0 |
| 2008-11-21 | YM | Futures | 6681.3 | 7173.4 | 6605.8 | 7138.8 | 405390.0 |
| 2008-11-21 | CL | Futures | 205.37 | 216.15 | 204.02 | 211.12 | 213647.0 |
| 2008-11-21 | GC | Futures | 1043.0 | 1122.7 | 1038.4 | 1107.3 | 178814.0 |
| 2008-11-21 | ZN | Futures | 90.805739 | 90.875869 | 89.695359 | 90.127823 | 676678.0 |
| 2008-11-21 | A6 | Futures | 0.48066 | 0.49767 | 0.47743 | 0.48562 | 26656.0 |
| 2008-11-21 | AD | Futures | 0.76078 | 0.77814 | 0.7592 | 0.7665 | 30917.0 |
| 2008-11-21 | B | Futures | 54.33 | 56.99 | 53.88 | 55.91 | 95634.0 |
| 2008-11-21 | B6 | Futures | 1.5297 | 1.5639 | 1.5262 | 1.5345 | 65603.0 |
| 2008-11-21 | BFX | Futures | 2097.3 | 2120.2 | 1994.6 | 2013.7 | 683.0 |
| 2008-11-21 | BR | Futures | 0.15305 | 0.15305 | 0.15191 | 0.15191 | 2.0 |
| 2008-11-21 | BZ | Futures | 54.91 | 54.96 | 52.36 | 54.16 | 605.0 |
| 2008-11-21 | C | Futures | 1299.0 | 1350.0 | 1299.0 | 1339.0 | 22408.0 |
| 2008-11-21 | CB | Futures | 91.874 | 92.04 | 91.874 | 92.04 | 9.0 |
| 2008-11-21 | CC | Futures | 1772.0 | 1829.0 | 1771.0 | 1804.0 | 5422.0 |
| 2008-11-21 | CT | Futures | 39.18 | 41.77 | 39.18 | 40.81 | 3719.0 |
| 2008-11-21 | DC | Futures | 37.59 | 38.02 | 37.26 | 37.97 | 77.0 |
| 2008-11-21 | DX | Futures | 92.908 | 92.955 | 91.185 | 92.62 | 4535.0 |
| 2008-11-21 | E1 | Futures | 1.09103 | 1.09731 | 1.08609 | 1.09156 | 27375.0 |
| 2008-11-21 | E6 | Futures | 1.46993 | 1.49214 | 1.46674 | 1.47631 | 219717.0 |
| 2008-11-21 | E7 | Futures | 1.4555 | 1.4778 | 1.453 | 1.4621 | 2550.0 |
| 2008-11-21 | ED | Futures | 92.6419 | 92.6489 | 92.4459 | 92.5616 | 158005.0 |
| 2008-11-21 | ER | Futures | 95.331 | 95.351 | 95.252 | 95.331 | 105339.0 |
| 2008-11-21 | EW | Futures | 411.4 | 435.7 | 398.7 | 427.0 | 71349.0 |
| 2008-11-21 | FCE | Futures | 1755.0 | 1820.3 | 1684.3 | 1725.6 | 213357.0 |
| 2008-11-21 | FDAX | Futures | 4685.5 | 4818.1 | 4512.1 | 4573.7 | 249435.0 |
| 2008-11-21 | FESX | Futures | 1271.5 | 1312.5 | 1217.7 | 1246.6 | 2277543.0 |
| 2008-11-21 | FEU3 | Futures | 95.903 | 95.903 | 95.823 | 95.898 | 145.0 |
| 2008-11-21 | FGBL | Futures | 91.05 | 91.4 | 90.52 | 90.82 | 921902.0 |
| 2008-11-21 | FGBM | Futures | 96.63 | 96.65 | 96.12 | 96.41 | 536451.0 |
| 2008-11-21 | FGBS | Futures | 102.875 | 102.889 | 102.663 | 102.807 | 470947.0 |
| 2008-11-21 | FGBX | Futures | 83.99 | 84.96 | 83.04 | 83.6 | 3205.0 |
| 2008-11-21 | FTDX | Futures | 396.5 | 403.7 | 378.7 | 384.9 | 390.0 |
| 2008-11-21 | FTI | Futures | 181.25 | 187.18 | 176.6 | 179.56 | 49187.0 |
| 2008-11-21 | FTUK | Futures | 2512.6 | 2567.1 | 2401.1 | 2450.7 | 193087.0 |
| 2008-11-21 | G | Futures | 72.52 | 72.9 | 72.23 | 72.54 | 100630.0 |
| 2008-11-21 | GF | Futures | 245.76 | 250.045 | 242.581 | 247.142 | 460.0 |
| 2008-11-21 | GSCI | Futures | 932.28 | 932.28 | 910.98 | 922.26 | 234.0 |
| 2008-11-21 | HE | Futures | 124.153 | 125.989 | 123.718 | 123.911 | 4463.0 |
| 2008-11-21 | HG | Futures | 2.1738 | 2.3181 | 2.1464 | 2.2224 | 8780.0 |
| 2008-11-21 | HO | Futures | 1.9138 | 1.9571 | 1.9037 | 1.9319 | 4024.0 |
| 2008-11-21 | HRC | Futures | 3762.7 | 3762.7 | 3762.7 | 3762.7 | 0.0 |
| 2008-11-21 | J1 | Futures | 0.0134283 | 0.0134978 | 0.013163 | 0.0132666 | 127676.0 |
| 2008-11-21 | J7 | Futures | 0.013218 | 0.013246 | 0.01297 | 0.013065 | 68.0 |
| 2008-11-21 | JB | Futures | 115.66 | 116.93 | 115.6 | 115.86 | 18.0 |
| 2008-11-21 | KC | Futures | 317.24 | 323.24 | 316.24 | 316.53 | 5352.0 |
| 2008-11-21 | KE | Futures | 2799.56 | 2836.93 | 2737.69 | 2750.58 | 6879.0 |
| 2008-11-21 | L | Futures | 95.842 | 95.882 | 95.788 | 95.877 | 18703.0 |
| 2008-11-21 | LBS | Futures | 1195.9 | 1208.8 | 1195.9 | 1196.5 | 4.0 |
> showing 50 of 84 rows — these rows as CSV