PREVIEW / futures_daily / 2008-10-20
file: by_date/futures_daily/2008/2008-10-20.parquet size: 8 KB rows: 83
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-10-20 | ES | Futures | 882.77 | 934.8 | 871.47 | 932.68 | 2435954.0 |
| 2008-10-20 | NQ | Futures | 1469.64 | 1524.72 | 1443.92 | 1521.09 | 382889.0 |
| 2008-10-20 | YM | Futures | 7818.4 | 8283.0 | 7728.6 | 8276.7 | 236491.0 |
| 2008-10-20 | CL | Futures | 308.99 | 324.03 | 305.84 | 316.17 | 237629.0 |
| 2008-10-20 | GC | Futures | 1097.2 | 1135.3 | 1094.7 | 1104.8 | 76838.0 |
| 2008-10-20 | ZN | Futures | 83.839563 | 84.762932 | 83.477229 | 84.540856 | 472568.0 |
| 2008-10-20 | A6 | Futures | 0.54601 | 0.55341 | 0.53979 | 0.55026 | 22062.0 |
| 2008-10-20 | AD | Futures | 0.83477 | 0.84109 | 0.82422 | 0.82836 | 24898.0 |
| 2008-10-20 | B | Futures | 82.27 | 85.72 | 80.83 | 83.88 | 117592.0 |
| 2008-10-20 | B6 | Futures | 1.7898 | 1.8146 | 1.7702 | 1.774 | 53336.0 |
| 2008-10-20 | BFX | Futures | 2292.2 | 2365.7 | 2289.5 | 2365.7 | 75.0 |
| 2008-10-20 | BZ | Futures | 79.51 | 81.64 | 77.74 | 80.42 | 897.0 |
| 2008-10-20 | C | Futures | 1129.0 | 1148.0 | 1117.0 | 1125.0 | 3540.0 |
| 2008-10-20 | CC | Futures | 1903.0 | 1919.0 | 1833.0 | 1853.0 | 5995.0 |
| 2008-10-20 | CT | Futures | 53.34 | 54.53 | 48.54 | 48.85 | 13082.0 |
| 2008-10-20 | DC | Futures | 38.2 | 38.35 | 37.36 | 37.36 | 234.0 |
| 2008-10-20 | DX | Futures | 86.832 | 87.618 | 85.9 | 87.445 | 6300.0 |
| 2008-10-20 | E1 | Futures | 1.17769 | 1.18143 | 1.15993 | 1.16193 | 40995.0 |
| 2008-10-20 | E6 | Futures | 1.58276 | 1.59611 | 1.56775 | 1.57189 | 163043.0 |
| 2008-10-20 | E7 | Futures | 1.5679 | 1.5805 | 1.5529 | 1.5568 | 3075.0 |
| 2008-10-20 | ED | Futures | 92.1106 | 92.2145 | 92.0633 | 92.0728 | 178164.0 |
| 2008-10-20 | ER | Futures | 94.833 | 94.892 | 94.759 | 94.813 | 106821.0 |
| 2008-10-20 | EW | Futures | 542.5 | 572.5 | 538.5 | 570.9 | 22526.0 |
| 2008-10-20 | FCE | Futures | 2076.9 | 2160.4 | 2060.6 | 2117.4 | 147787.0 |
| 2008-10-20 | FDAX | Futures | 5497.6 | 5569.1 | 5349.9 | 5441.6 | 171371.0 |
| 2008-10-20 | FESX | Futures | 1493.0 | 1544.5 | 1484.9 | 1509.8 | 1563358.0 |
| 2008-10-20 | FEU3 | Futures | 95.352 | 95.382 | 95.337 | 95.377 | 1380.0 |
| 2008-10-20 | FGBL | Futures | 86.15 | 86.5 | 85.96 | 86.36 | 532083.0 |
| 2008-10-20 | FGBM | Futures | 92.78 | 93.16 | 92.57 | 93.12 | 368163.0 |
| 2008-10-20 | FGBS | Futures | 101.266 | 101.411 | 101.103 | 101.406 | 385537.0 |
| 2008-10-20 | FGBX | Futures | 77.06 | 77.93 | 76.89 | 77.53 | 1127.0 |
| 2008-10-20 | FTDX | Futures | 499.2 | 510.8 | 491.2 | 493.0 | 436.0 |
| 2008-10-20 | FTI | Futures | 214.51 | 226.22 | 213.39 | 223.56 | 35883.0 |
| 2008-10-20 | FTUK | Futures | 2697.7 | 2838.8 | 2640.0 | 2765.5 | 162145.0 |
| 2008-10-20 | G | Futures | 68.3 | 68.8 | 68.16 | 68.75 | 62528.0 |
| 2008-10-20 | GF | Futures | 273.057 | 275.412 | 271.81 | 273.195 | 384.0 |
| 2008-10-20 | GSCI | Futures | 1259.06 | 1285.57 | 1239.74 | 1264.03 | 160.0 |
| 2008-10-20 | HE | Futures | 123.373 | 125.003 | 122.177 | 122.286 | 3383.0 |
| 2008-10-20 | HG | Futures | 3.0096 | 3.1699 | 2.9354 | 2.9627 | 11256.0 |
| 2008-10-20 | HO | Futures | 2.4666 | 2.6045 | 2.4618 | 2.5356 | 17789.0 |
| 2008-10-20 | J1 | Futures | 0.012491 | 0.0125112 | 0.0123798 | 0.0124505 | 103416.0 |
| 2008-10-20 | J7 | Futures | 0.012277 | 0.012316 | 0.01221 | 0.012261 | 37.0 |
| 2008-10-20 | JB | Futures | 113.05 | 113.51 | 112.73 | 112.73 | 1713.0 |
| 2008-10-20 | KC | Futures | 345.12 | 346.16 | 337.16 | 337.75 | 6553.0 |
| 2008-10-20 | KE | Futures | 3067.65 | 3134.68 | 3022.54 | 3071.52 | 3706.0 |
| 2008-10-20 | L | Futures | 94.489 | 94.638 | 94.474 | 94.578 | 46972.0 |
| 2008-10-20 | LBS | Futures | 1312.7 | 1328.5 | 1308.1 | 1310.8 | 7.0 |
| 2008-10-20 | LE | Futures | 169.916 | 171.062 | 168.312 | 168.816 | 6501.0 |
| 2008-10-20 | MP | Futures | 0.03809 | 0.03839 | 0.03706 | 0.03731 | 2755.0 |
| 2008-10-20 | N6 | Futures | 0.47449 | 0.48726 | 0.47238 | 0.48585 | 745.0 |
> showing 50 of 83 rows — these rows as CSV