PREVIEW / futures_daily / 2008-10-31
file: by_date/futures_daily/2008/2008-10-31.parquet size: 8 KB rows: 85
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-31 | ES | Futures | 903.72 | 926.56 | 885.13 | 910.79 | 2756518.0 |
| 2008-10-31 | NQ | Futures | 1498.72 | 1522.49 | 1459.85 | 1495.36 | 351846.0 |
| 2008-10-31 | YM | Futures | 8187.0 | 8375.4 | 8026.2 | 8259.9 | 255900.0 |
| 2008-10-31 | CL | Futures | 278.73 | 291.56 | 268.27 | 288.2 | 256881.0 |
| 2008-10-31 | GC | Futures | 1031.2 | 1038.4 | 1002.8 | 1004.4 | 96727.0 |
| 2008-10-31 | ZN | Futures | 84.809685 | 85.791495 | 84.552545 | 84.587609 | 603764.0 |
| 2008-10-31 | A6 | Futures | 0.52987 | 0.53105 | 0.51333 | 0.52404 | 25821.0 |
| 2008-10-31 | AD | Futures | 0.82155 | 0.8258 | 0.79738 | 0.82136 | 40401.0 |
| 2008-10-31 | B | Futures | 73.03 | 77.5 | 70.91 | 76.32 | 67499.0 |
| 2008-10-31 | B6 | Futures | 1.6968 | 1.7099 | 1.6582 | 1.6727 | 80069.0 |
| 2008-10-31 | BFX | Futures | 2298.7 | 2379.5 | 2298.7 | 2378.7 | 619.0 |
| 2008-10-31 | BR | Futures | 0.17761 | 0.17893 | 0.17451 | 0.17451 | 3.0 |
| 2008-10-31 | BZ | Futures | 73.94 | 73.94 | 73.94 | 73.94 | 115.0 |
| 2008-10-31 | C | Futures | 1169.0 | 1195.0 | 1164.0 | 1173.0 | 2229.0 |
| 2008-10-31 | CB | Futures | 88.305 | 88.305 | 87.529 | 87.529 | 13.0 |
| 2008-10-31 | CC | Futures | 1830.0 | 1857.0 | 1810.0 | 1824.0 | 6471.0 |
| 2008-10-31 | CT | Futures | 44.9 | 45.54 | 43.45 | 44.1 | 13032.0 |
| 2008-10-31 | DC | Futures | 36.83 | 37.03 | 36.57 | 36.75 | 175.0 |
| 2008-10-31 | DX | Futures | 89.749 | 91.09 | 89.571 | 90.451 | 5821.0 |
| 2008-10-31 | E1 | Futures | 1.16914 | 1.17702 | 1.14297 | 1.15686 | 48699.0 |
| 2008-10-31 | E6 | Futures | 1.51884 | 1.52215 | 1.49486 | 1.50526 | 240588.0 |
| 2008-10-31 | E7 | Futures | 1.5045 | 1.5073 | 1.4791 | 1.4908 | 4270.0 |
| 2008-10-31 | ED | Futures | 92.257 | 92.4412 | 92.257 | 92.3325 | 152882.0 |
| 2008-10-31 | ER | Futures | 94.996 | 95.055 | 94.996 | 95.006 | 91335.0 |
| 2008-10-31 | EW | Futures | 550.8 | 565.7 | 534.5 | 560.1 | 31661.0 |
| 2008-10-31 | FCE | Futures | 2068.6 | 2160.4 | 2031.7 | 2132.2 | 168910.0 |
| 2008-10-31 | FDAX | Futures | 5466.2 | 5719.0 | 5356.1 | 5665.3 | 172810.0 |
| 2008-10-31 | FESX | Futures | 1453.1 | 1527.7 | 1430.5 | 1499.4 | 1630251.0 |
| 2008-10-31 | FEU3 | Futures | 95.57 | 95.605 | 95.56 | 95.58 | 794.0 |
| 2008-10-31 | FGBL | Futures | 88.27 | 88.38 | 87.19 | 87.23 | 866652.0 |
| 2008-10-31 | FGBM | Futures | 95.0 | 95.15 | 94.36 | 94.42 | 499861.0 |
| 2008-10-31 | FGBS | Futures | 102.273 | 102.379 | 102.003 | 102.109 | 466871.0 |
| 2008-10-31 | FGBX | Futures | 81.37 | 81.37 | 77.77 | 78.16 | 2031.0 |
| 2008-10-31 | FTDX | Futures | 452.8 | 475.1 | 451.0 | 472.4 | 379.0 |
| 2008-10-31 | FTI | Futures | 213.26 | 222.15 | 209.4 | 221.28 | 40056.0 |
| 2008-10-31 | FTUK | Futures | 2777.8 | 2874.7 | 2717.5 | 2839.1 | 178848.0 |
| 2008-10-31 | G | Futures | 69.61 | 69.82 | 69.08 | 69.1 | 99468.0 |
| 2008-10-31 | GF | Futures | 271.117 | 275.55 | 270.979 | 273.264 | 224.0 |
| 2008-10-31 | GSCI | Futures | 1133.44 | 1191.68 | 1120.91 | 1175.88 | 1302.0 |
| 2008-10-31 | HE | Futures | 121.797 | 122.829 | 119.133 | 119.133 | 8756.0 |
| 2008-10-31 | HG | Futures | 2.6583 | 2.6737 | 2.4259 | 2.5603 | 17085.0 |
| 2008-10-31 | HO | Futures | 2.2677 | 2.3963 | 2.2055 | 2.3699 | 39913.0 |
| 2008-10-31 | J1 | Futures | 0.0128434 | 0.0131327 | 0.0127588 | 0.0128093 | 116701.0 |
| 2008-10-31 | J7 | Futures | 0.012617 | 0.012923 | 0.012568 | 0.012614 | 117.0 |
| 2008-10-31 | JB | Futures | 114.72 | 115.22 | 113.95 | 114.63 | 1903.0 |
| 2008-10-31 | KC | Futures | 327.42 | 336.42 | 321.97 | 333.32 | 11316.0 |
| 2008-10-31 | KE | Futures | 2956.8 | 2998.05 | 2902.67 | 2954.23 | 6735.0 |
| 2008-10-31 | L | Futures | 94.781 | 94.999 | 94.776 | 94.98 | 42472.0 |
| 2008-10-31 | LBS | Futures | 1261.5 | 1261.5 | 1239.1 | 1239.1 | 33.0 |
| 2008-10-31 | LE | Futures | 168.037 | 170.787 | 167.074 | 169.962 | 9153.0 |
> showing 50 of 85 rows — these rows as CSV