PREVIEW / futures_daily / 2008-10-23
file: by_date/futures_daily/2008/2008-10-23.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-23 | ES | Futures | 851.7 | 869.35 | 806.03 | 861.82 | 4058789.0 |
| 2008-10-23 | NQ | Futures | 1393.59 | 1415.4 | 1315.01 | 1401.97 | 585868.0 |
| 2008-10-23 | YM | Futures | 7613.2 | 7803.3 | 7296.0 | 7794.4 | 378311.0 |
| 2008-10-23 | CL | Futures | 285.65 | 295.05 | 280.09 | 288.33 | 256890.0 |
| 2008-10-23 | GC | Futures | 1020.9 | 1028.2 | 972.2 | 999.5 | 148938.0 |
| 2008-10-23 | ZN | Futures | 86.165518 | 86.749929 | 85.791495 | 86.656423 | 667760.0 |
| 2008-10-23 | A6 | Futures | 0.52719 | 0.52884 | 0.51239 | 0.51318 | 35096.0 |
| 2008-10-23 | AD | Futures | 0.78692 | 0.79353 | 0.77578 | 0.78456 | 31868.0 |
| 2008-10-23 | B | Futures | 75.93 | 78.83 | 74.53 | 76.76 | 124710.0 |
| 2008-10-23 | B6 | Futures | 1.6822 | 1.6947 | 1.6624 | 1.6708 | 75990.0 |
| 2008-10-23 | BFX | Futures | 2213.1 | 2224.3 | 2158.9 | 2224.3 | 116.0 |
| 2008-10-23 | BR | Futures | 0.16089 | 0.16318 | 0.16089 | 0.16318 | 1.0 |
| 2008-10-23 | BZ | Futures | 71.99 | 75.15 | 71.99 | 73.6 | 461.0 |
| 2008-10-23 | C | Futures | 1141.0 | 1142.0 | 1119.0 | 1136.0 | 1960.0 |
| 2008-10-23 | CB | Futures | 93.287 | 93.287 | 93.271 | 93.287 | 7.0 |
| 2008-10-23 | CC | Futures | 1786.0 | 1796.0 | 1744.0 | 1768.0 | 8824.0 |
| 2008-10-23 | CT | Futures | 50.28 | 50.53 | 48.6 | 48.87 | 8179.0 |
| 2008-10-23 | DC | Futures | 37.29 | 37.34 | 36.96 | 37.11 | 104.0 |
| 2008-10-23 | DX | Futures | 90.357 | 90.666 | 89.315 | 89.87 | 10293.0 |
| 2008-10-23 | E1 | Futures | 1.14858 | 1.15472 | 1.1431 | 1.15299 | 39287.0 |
| 2008-10-23 | E6 | Futures | 1.51435 | 1.52759 | 1.50242 | 1.51613 | 226146.0 |
| 2008-10-23 | E7 | Futures | 1.5007 | 1.5161 | 1.4883 | 1.5016 | 5210.0 |
| 2008-10-23 | ED | Futures | 92.1767 | 92.1814 | 91.9217 | 92.035 | 257196.0 |
| 2008-10-23 | ER | Futures | 94.749 | 94.764 | 94.665 | 94.7 | 120605.0 |
| 2008-10-23 | EW | Futures | 529.1 | 537.9 | 483.7 | 507.6 | 39367.0 |
| 2008-10-23 | FCE | Futures | 2031.1 | 2053.5 | 1922.9 | 2033.9 | 204290.0 |
| 2008-10-23 | FDAX | Futures | 5104.4 | 5159.2 | 4829.2 | 5062.5 | 264409.0 |
| 2008-10-23 | FESX | Futures | 1416.7 | 1431.7 | 1342.6 | 1413.8 | 2350705.0 |
| 2008-10-23 | FEU3 | Futures | 95.273 | 95.297 | 95.238 | 95.263 | 1887.0 |
| 2008-10-23 | FGBL | Futures | 87.85 | 88.28 | 87.57 | 87.76 | 935672.0 |
| 2008-10-23 | FGBM | Futures | 93.82 | 94.2 | 93.66 | 93.87 | 525381.0 |
| 2008-10-23 | FGBS | Futures | 101.613 | 101.811 | 101.531 | 101.637 | 489307.0 |
| 2008-10-23 | FGBX | Futures | 79.51 | 81.5 | 79.34 | 80.7 | 2063.0 |
| 2008-10-23 | FTDX | Futures | 470.6 | 473.3 | 438.5 | 453.7 | 695.0 |
| 2008-10-23 | FTI | Futures | 210.07 | 215.26 | 204.75 | 213.68 | 53840.0 |
| 2008-10-23 | FTUK | Futures | 2624.1 | 2670.8 | 2502.9 | 2641.0 | 172817.0 |
| 2008-10-23 | G | Futures | 69.38 | 69.72 | 69.31 | 69.47 | 101665.0 |
| 2008-10-23 | GF | Futures | 275.62 | 276.589 | 267.1 | 268.139 | 251.0 |
| 2008-10-23 | GSCI | Futures | 1160.21 | 1189.72 | 1158.78 | 1166.09 | 207.0 |
| 2008-10-23 | HE | Futures | 125.873 | 127.612 | 125.057 | 125.927 | 5237.0 |
| 2008-10-23 | HG | Futures | 2.5638 | 2.6205 | 2.4049 | 2.526 | 16945.0 |
| 2008-10-23 | HO | Futures | 2.3311 | 2.3993 | 2.322 | 2.3375 | 28910.0 |
| 2008-10-23 | J1 | Futures | 0.0129483 | 0.0132211 | 0.0128952 | 0.0131959 | 163652.0 |
| 2008-10-23 | J7 | Futures | 0.01282 | 0.01302 | 0.012723 | 0.012995 | 141.0 |
| 2008-10-23 | JB | Futures | 113.9 | 114.69 | 113.81 | 114.04 | 1972.0 |
| 2008-10-23 | KC | Futures | 330.67 | 332.88 | 323.74 | 324.77 | 9094.0 |
| 2008-10-23 | KE | Futures | 2847.25 | 2924.58 | 2835.65 | 2851.11 | 4745.0 |
| 2008-10-23 | L | Futures | 94.454 | 94.474 | 94.37 | 94.385 | 37585.0 |
| 2008-10-23 | LBS | Futures | 1198.4 | 1244.4 | 1170.2 | 1174.8 | 67.0 |
| 2008-10-23 | LE | Futures | 167.533 | 170.145 | 164.461 | 164.782 | 8075.0 |
> showing 50 of 85 rows — these rows as CSV