PREVIEW / futures_daily / 2008-09-29
file: by_date/futures_daily/2008/2008-09-29.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-09-29 | ES | Futures | 1148.78 | 1149.96 | 1048.5 | 1053.44 | 3948082.0 |
| 2008-09-29 | NQ | Futures | 1879.83 | 1887.94 | 1670.96 | 1691.09 | 602280.0 |
| 2008-09-29 | YM | Futures | 9932.6 | 9948.6 | 9245.9 | 9304.6 | 347094.0 |
| 2008-09-29 | CL | Futures | 461.63 | 461.72 | 410.45 | 416.2 | 248522.0 |
| 2008-09-29 | GC | Futures | 1227.9 | 1303.4 | 1219.8 | 1250.8 | 181991.0 |
| 2008-09-29 | ZN | Futures | 85.651237 | 88.269397 | 85.487602 | 87.205769 | 957117.0 |
| 2008-09-29 | A6 | Futures | 0.65151 | 0.65206 | 0.626 | 0.62891 | 36148.0 |
| 2008-09-29 | AD | Futures | 0.95662 | 0.95682 | 0.94518 | 0.95021 | 36090.0 |
| 2008-09-29 | B | Futures | 120.85 | 120.85 | 109.56 | 111.06 | 75505.0 |
| 2008-09-29 | B6 | Futures | 1.909 | 1.909 | 1.8613 | 1.8831 | 84156.0 |
| 2008-09-29 | BFX | Futures | 3104.0 | 3104.0 | 2911.8 | 2919.1 | 1139.0 |
| 2008-09-29 | BR | Futures | 0.19405 | 0.19409 | 0.18997 | 0.18997 | 11.0 |
| 2008-09-29 | BZ | Futures | 106.48 | 106.48 | 106.48 | 106.48 | 198.0 |
| 2008-09-29 | C | Futures | 1337.0 | 1344.0 | 1301.0 | 1302.0 | 5361.0 |
| 2008-09-29 | CB | Futures | 94.357 | 94.357 | 93.116 | 93.116 | 2.0 |
| 2008-09-29 | CC | Futures | 2398.0 | 2398.0 | 2235.0 | 2272.0 | 10179.0 |
| 2008-09-29 | CT | Futures | 59.89 | 60.04 | 57.13 | 57.13 | 5822.0 |
| 2008-09-29 | DC | Futures | 41.7 | 41.7 | 40.13 | 40.23 | 187.0 |
| 2008-09-29 | DX | Futures | 80.871 | 82.196 | 80.782 | 81.217 | 7807.0 |
| 2008-09-29 | E1 | Futures | 1.23043 | 1.24191 | 1.2092 | 1.23417 | 66656.0 |
| 2008-09-29 | E6 | Futures | 1.7289 | 1.72937 | 1.69098 | 1.71165 | 231510.0 |
| 2008-09-29 | E7 | Futures | 1.7116 | 1.7126 | 1.6749 | 1.6952 | 3908.0 |
| 2008-09-29 | ED | Futures | 91.3455 | 91.5202 | 91.2416 | 91.4022 | 341230.0 |
| 2008-09-29 | ER | Futures | 93.561 | 93.738 | 93.531 | 93.728 | 246245.0 |
| 2008-09-29 | EW | Futures | 746.3 | 746.4 | 680.7 | 688.1 | 54832.0 |
| 2008-09-29 | FCE | Futures | 2663.2 | 2668.6 | 2400.3 | 2550.2 | 208513.0 |
| 2008-09-29 | FDAX | Futures | 6795.0 | 6813.5 | 6233.0 | 6570.8 | 275525.0 |
| 2008-09-29 | FESX | Futures | 1825.0 | 1827.4 | 1652.1 | 1756.2 | 2309093.0 |
| 2008-09-29 | FEU3 | Futures | 94.147 | 94.285 | 94.132 | 94.285 | 358.0 |
| 2008-09-29 | FGBL | Futures | 85.7 | 87.33 | 85.64 | 87.33 | 1090437.0 |
| 2008-09-29 | FGBM | Futures | 91.9 | 93.12 | 91.81 | 93.12 | 640670.0 |
| 2008-09-29 | FGBS | Futures | 100.303 | 100.973 | 100.274 | 100.973 | 785842.0 |
| 2008-09-29 | FGBX | Futures | 74.69 | 77.65 | 74.69 | 77.12 | 2794.0 |
| 2008-09-29 | FTDX | Futures | 663.6 | 663.6 | 589.4 | 589.4 | 2565.0 |
| 2008-09-29 | FTI | Futures | 274.71 | 274.86 | 249.34 | 249.95 | 57510.0 |
| 2008-09-29 | FTUK | Futures | 3283.9 | 3298.2 | 2958.1 | 3167.8 | 206724.0 |
| 2008-09-29 | G | Futures | 69.21 | 70.03 | 69.1 | 69.98 | 63621.0 |
| 2008-09-29 | GF | Futures | 283.017 | 283.017 | 276.297 | 276.297 | 180.0 |
| 2008-09-29 | GSCI | Futures | 1579.05 | 1579.3 | 1500.59 | 1507.84 | 192.0 |
| 2008-09-29 | HE | Futures | 141.797 | 142.232 | 140.547 | 141.417 | 5136.0 |
| 2008-09-29 | HG | Futures | 4.3079 | 4.3079 | 3.9895 | 4.0686 | 11562.0 |
| 2008-09-29 | HO | Futures | 3.4311 | 3.4311 | 3.1663 | 3.2009 | 15395.0 |
| 2008-09-29 | J1 | Futures | 0.0120286 | 0.0122434 | 0.0118998 | 0.0122042 | 147645.0 |
| 2008-09-29 | J7 | Futures | 0.011871 | 0.012042 | 0.011737 | 0.012019 | 57.0 |
| 2008-09-29 | JB | Futures | 114.24 | 114.3 | 113.64 | 114.2 | 1799.0 |
| 2008-09-29 | KC | Futures | 395.27 | 395.27 | 381.4 | 384.21 | 12320.0 |
| 2008-09-29 | KE | Futures | 3826.83 | 3841.01 | 3632.2 | 3634.78 | 11159.0 |
| 2008-09-29 | L | Futures | 93.289 | 93.368 | 93.175 | 93.289 | 59534.0 |
| 2008-09-29 | LE | Futures | 187.426 | 187.426 | 182.979 | 183.117 | 6742.0 |
| 2008-09-29 | MP | Futures | 0.04489 | 0.04497 | 0.04377 | 0.0438 | 18758.0 |
> showing 50 of 84 rows — these rows as CSV