PREVIEW / futures_daily / 2008-11-24
file: by_date/futures_daily/2008/2008-11-24.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-11-24 | ES | Futures | 754.24 | 815.68 | 737.53 | 798.5 | 3413399.0 |
| 2008-11-24 | NQ | Futures | 1228.33 | 1301.87 | 1199.26 | 1282.86 | 415253.0 |
| 2008-11-24 | YM | Futures | 7173.4 | 7628.3 | 7023.3 | 7448.8 | 307827.0 |
| 2008-11-24 | CL | Futures | 215.52 | 233.83 | 206.34 | 230.44 | 233065.0 |
| 2008-11-24 | GC | Futures | 1121.6 | 1160.9 | 1099.5 | 1146.1 | 153806.0 |
| 2008-11-24 | ZN | Futures | 89.800553 | 90.046005 | 89.192766 | 89.309648 | 605288.0 |
| 2008-11-24 | A6 | Futures | 0.4983 | 0.51444 | 0.48987 | 0.50916 | 31307.0 |
| 2008-11-24 | AD | Futures | 0.77943 | 0.80616 | 0.77153 | 0.79738 | 39146.0 |
| 2008-11-24 | B | Futures | 56.83 | 61.95 | 54.56 | 61.3 | 107373.0 |
| 2008-11-24 | B6 | Futures | 1.5485 | 1.5773 | 1.5413 | 1.5699 | 62943.0 |
| 2008-11-24 | BFX | Futures | 2032.7 | 2093.2 | 2026.8 | 2093.2 | 140.0 |
| 2008-11-24 | BZ | Futures | 55.23 | 60.0 | 54.55 | 59.38 | 318.0 |
| 2008-11-24 | C | Futures | 1345.0 | 1363.0 | 1334.0 | 1354.0 | 14029.0 |
| 2008-11-24 | CB | Futures | 92.04 | 92.04 | 91.874 | 91.874 | 9.0 |
| 2008-11-24 | CC | Futures | 1809.0 | 1855.0 | 1809.0 | 1840.0 | 3046.0 |
| 2008-11-24 | CT | Futures | 40.81 | 43.61 | 40.81 | 43.61 | 14024.0 |
| 2008-11-24 | DC | Futures | 37.97 | 38.72 | 37.92 | 38.05 | 94.0 |
| 2008-11-24 | DX | Futures | 91.808 | 92.106 | 89.042 | 90.383 | 8931.0 |
| 2008-11-24 | E1 | Futures | 1.09423 | 1.12294 | 1.0925 | 1.11493 | 33450.0 |
| 2008-11-24 | E6 | Futures | 1.48694 | 1.53219 | 1.48364 | 1.5205 | 205100.0 |
| 2008-11-24 | E7 | Futures | 1.4728 | 1.5168 | 1.4695 | 1.5059 | 3110.0 |
| 2008-11-24 | ED | Futures | 92.5946 | 92.6301 | 92.3939 | 92.5002 | 157400.0 |
| 2008-11-24 | ER | Futures | 95.321 | 95.331 | 95.218 | 95.262 | 69353.0 |
| 2008-11-24 | EW | Futures | 432.9 | 472.6 | 424.6 | 463.6 | 43233.0 |
| 2008-11-24 | FCE | Futures | 1776.6 | 1926.6 | 1754.4 | 1896.6 | 172669.0 |
| 2008-11-24 | FDAX | Futures | 4767.2 | 5193.9 | 4658.1 | 5121.2 | 215560.0 |
| 2008-11-24 | FESX | Futures | 1295.2 | 1392.4 | 1268.6 | 1373.8 | 1818088.0 |
| 2008-11-24 | FEU3 | Futures | 95.883 | 95.893 | 95.813 | 95.828 | 331.0 |
| 2008-11-24 | FGBL | Futures | 90.82 | 91.01 | 90.12 | 90.49 | 625741.0 |
| 2008-11-24 | FGBM | Futures | 96.4 | 96.45 | 95.9 | 96.16 | 328284.0 |
| 2008-11-24 | FGBS | Futures | 102.817 | 102.822 | 102.485 | 102.644 | 416344.0 |
| 2008-11-24 | FGBX | Futures | 83.51 | 83.79 | 82.97 | 83.41 | 1376.0 |
| 2008-11-24 | FTDX | Futures | 388.5 | 418.8 | 388.5 | 415.3 | 542.0 |
| 2008-11-24 | FTI | Futures | 186.06 | 197.81 | 181.61 | 197.25 | 38442.0 |
| 2008-11-24 | FTUK | Futures | 2518.8 | 2745.4 | 2485.4 | 2697.1 | 198191.0 |
| 2008-11-24 | G | Futures | 72.54 | 72.62 | 72.06 | 72.29 | 87627.0 |
| 2008-11-24 | GF | Futures | 248.801 | 253.777 | 248.801 | 252.671 | 422.0 |
| 2008-11-24 | GSCI | Futures | 943.56 | 991.43 | 936.8 | 986.17 | 188.0 |
| 2008-11-24 | HE | Futures | 125.264 | 126.424 | 124.878 | 125.168 | 2812.0 |
| 2008-11-24 | HG | Futures | 2.266 | 2.4208 | 2.1893 | 2.3526 | 9096.0 |
| 2008-11-24 | HO | Futures | 1.9255 | 2.0731 | 1.9051 | 2.0322 | 3525.0 |
| 2008-11-24 | HRC | Futures | 3762.7 | 3762.7 | 3762.7 | 3762.7 | 0.0 |
| 2008-11-24 | J1 | Futures | 0.0131946 | 0.0133159 | 0.0129887 | 0.0130518 | 97140.0 |
| 2008-11-24 | J7 | Futures | 0.012988 | 0.013085 | 0.012821 | 0.012853 | 43.0 |
| 2008-11-24 | KC | Futures | 317.38 | 329.39 | 316.96 | 325.96 | 9490.0 |
| 2008-11-24 | KE | Futures | 2750.58 | 3035.38 | 2750.58 | 2917.96 | 7036.0 |
| 2008-11-24 | L | Futures | 95.877 | 95.916 | 95.788 | 95.833 | 42143.0 |
| 2008-11-24 | LBS | Futures | 1194.8 | 1200.4 | 1190.3 | 1197.0 | 13.0 |
| 2008-11-24 | LE | Futures | 155.107 | 157.343 | 155.107 | 156.717 | 4565.0 |
| 2008-11-24 | MP | Futures | 0.03526 | 0.03696 | 0.03516 | 0.03605 | 3755.0 |
> showing 50 of 83 rows — these rows as CSV