PREVIEW / futures_daily / 2008-10-27
file: by_date/futures_daily/2008/2008-10-27.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-27 | ES | Futures | 813.8 | 841.81 | 776.84 | 786.02 | 2926986.0 |
| 2008-10-27 | NQ | Futures | 1331.79 | 1374.01 | 1271.4 | 1299.64 | 394574.0 |
| 2008-10-27 | YM | Futures | 7332.4 | 7622.0 | 7061.5 | 7116.6 | 295869.0 |
| 2008-10-27 | CL | Futures | 275.32 | 279.53 | 260.53 | 268.69 | 234150.0 |
| 2008-10-27 | GC | Futures | 1028.0 | 1045.8 | 988.7 | 1038.9 | 106840.0 |
| 2008-10-27 | ZN | Futures | 86.2824 | 86.738241 | 85.82656 | 86.118765 | 453146.0 |
| 2008-10-27 | A6 | Futures | 0.48688 | 0.49019 | 0.47043 | 0.47602 | 27052.0 |
| 2008-10-27 | AD | Futures | 0.77489 | 0.77745 | 0.76117 | 0.76611 | 25584.0 |
| 2008-10-27 | B | Futures | 72.26 | 74.22 | 69.02 | 71.82 | 47558.0 |
| 2008-10-27 | B6 | Futures | 1.6434 | 1.6465 | 1.5836 | 1.6213 | 61041.0 |
| 2008-10-27 | BFX | Futures | 2067.4 | 2089.9 | 2058.4 | 2078.4 | 219.0 |
| 2008-10-27 | BR | Futures | 0.16098 | 0.16699 | 0.16098 | 0.16699 | 5.0 |
| 2008-10-27 | BZ | Futures | 69.28 | 69.58 | 68.36 | 69.58 | 28.0 |
| 2008-10-27 | C | Futures | 1134.0 | 1173.0 | 1127.0 | 1155.0 | 2144.0 |
| 2008-10-27 | CB | Futures | 92.03 | 92.03 | 89.702 | 89.702 | 13.0 |
| 2008-10-27 | CC | Futures | 1733.0 | 1754.0 | 1671.0 | 1738.0 | 4474.0 |
| 2008-10-27 | CT | Futures | 45.89 | 47.68 | 45.16 | 46.9 | 13729.0 |
| 2008-10-27 | DC | Futures | 36.27 | 36.57 | 36.19 | 36.27 | 176.0 |
| 2008-10-27 | DX | Futures | 91.038 | 92.515 | 90.76 | 91.776 | 5005.0 |
| 2008-10-27 | E1 | Futures | 1.14591 | 1.1622 | 1.14164 | 1.15606 | 37701.0 |
| 2008-10-27 | E6 | Futures | 1.48754 | 1.49805 | 1.45635 | 1.47927 | 189523.0 |
| 2008-10-27 | E7 | Futures | 1.471 | 1.4834 | 1.4427 | 1.4651 | 3596.0 |
| 2008-10-27 | ED | Futures | 92.0067 | 92.1342 | 91.9831 | 92.0586 | 139943.0 |
| 2008-10-27 | ER | Futures | 94.798 | 94.907 | 94.789 | 94.882 | 105660.0 |
| 2008-10-27 | EW | Futures | 481.1 | 497.5 | 461.1 | 461.9 | 28915.0 |
| 2008-10-27 | FCE | Futures | 1916.2 | 1941.7 | 1825.8 | 1885.4 | 209391.0 |
| 2008-10-27 | FDAX | Futures | 4695.0 | 5037.3 | 4563.6 | 4811.9 | 256299.0 |
| 2008-10-27 | FESX | Futures | 1311.4 | 1350.1 | 1262.2 | 1316.0 | 2148664.0 |
| 2008-10-27 | FEU3 | Futures | 95.402 | 95.446 | 95.382 | 95.446 | 1038.0 |
| 2008-10-27 | FGBL | Futures | 88.2 | 88.43 | 87.9 | 88.12 | 543182.0 |
| 2008-10-27 | FGBM | Futures | 94.34 | 94.56 | 94.27 | 94.5 | 396972.0 |
| 2008-10-27 | FGBS | Futures | 101.969 | 102.075 | 101.897 | 102.051 | 361216.0 |
| 2008-10-27 | FGBX | Futures | 81.18 | 81.33 | 80.34 | 80.58 | 1939.0 |
| 2008-10-27 | FTDX | Futures | 409.0 | 428.7 | 401.0 | 408.1 | 391.0 |
| 2008-10-27 | FTI | Futures | 196.82 | 200.77 | 191.68 | 196.78 | 42708.0 |
| 2008-10-27 | FTUK | Futures | 2395.2 | 2558.0 | 2368.3 | 2486.3 | 191952.0 |
| 2008-10-27 | G | Futures | 70.08 | 70.19 | 69.75 | 69.91 | 48444.0 |
| 2008-10-27 | GF | Futures | 263.221 | 266.268 | 263.221 | 264.744 | 259.0 |
| 2008-10-27 | GSCI | Futures | 1095.84 | 1142.85 | 1094.27 | 1111.25 | 177.0 |
| 2008-10-27 | HE | Futures | 127.068 | 128.645 | 125.492 | 127.286 | 4865.0 |
| 2008-10-27 | HG | Futures | 2.3657 | 2.5708 | 2.2768 | 2.5267 | 15608.0 |
| 2008-10-27 | HO | Futures | 2.2492 | 2.29 | 2.175 | 2.204 | 27819.0 |
| 2008-10-27 | J1 | Futures | 0.0135294 | 0.0137946 | 0.0134043 | 0.0135041 | 133094.0 |
| 2008-10-27 | J7 | Futures | 0.01329 | 0.01356 | 0.013223 | 0.013299 | 124.0 |
| 2008-10-27 | JB | Futures | 115.1 | 115.39 | 114.21 | 115.01 | 1532.0 |
| 2008-10-27 | KC | Futures | 318.72 | 320.05 | 309.87 | 317.84 | 9690.0 |
| 2008-10-27 | KE | Futures | 2840.8 | 2918.14 | 2758.31 | 2910.4 | 6360.0 |
| 2008-10-27 | L | Futures | 94.588 | 94.642 | 94.548 | 94.608 | 43330.0 |
| 2008-10-27 | LBS | Futures | 1164.9 | 1195.8 | 1162.9 | 1164.2 | 32.0 |
| 2008-10-27 | LE | Futures | 161.665 | 164.553 | 160.565 | 162.766 | 6462.0 |
> showing 50 of 85 rows — these rows as CSV