PREVIEW / futures_daily / 2008-11-05
file: by_date/futures_daily/2008/2008-11-05.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-11-05 | ES | Futures | 943.98 | 949.63 | 891.72 | 902.08 | 2738398.0 |
| 2008-11-05 | NQ | Futures | 1543.18 | 1553.52 | 1449.79 | 1460.97 | 372652.0 |
| 2008-11-05 | YM | Futures | 8510.4 | 8559.2 | 8067.1 | 8150.6 | 219842.0 |
| 2008-11-05 | CL | Futures | 297.51 | 299.47 | 276.26 | 277.53 | 272470.0 |
| 2008-11-05 | GC | Futures | 1076.8 | 1076.8 | 1028.9 | 1038.2 | 112651.0 |
| 2008-11-05 | ZN | Futures | 86.200583 | 86.586294 | 85.814872 | 86.364218 | 534388.0 |
| 2008-11-05 | A6 | Futures | 0.54719 | 0.55034 | 0.5338 | 0.5431 | 19969.0 |
| 2008-11-05 | AD | Futures | 0.85835 | 0.86072 | 0.84277 | 0.8479 | 32806.0 |
| 2008-11-05 | B | Futures | 77.06 | 77.28 | 71.85 | 72.55 | 88336.0 |
| 2008-11-05 | B6 | Futures | 1.653 | 1.6789 | 1.6319 | 1.6545 | 74535.0 |
| 2008-11-05 | BFX | Futures | 2482.6 | 2513.5 | 2449.3 | 2473.4 | 124.0 |
| 2008-11-05 | BR | Futures | 0.17678 | 0.17723 | 0.17572 | 0.17618 | 12.0 |
| 2008-11-05 | BZ | Futures | 73.45 | 74.28 | 69.92 | 70.28 | 492.0 |
| 2008-11-05 | C | Futures | 1150.0 | 1170.0 | 1117.0 | 1122.0 | 3413.0 |
| 2008-11-05 | CB | Futures | 87.684 | 87.684 | 87.684 | 87.684 | 5.0 |
| 2008-11-05 | CC | Futures | 1783.0 | 1830.0 | 1745.0 | 1755.0 | 6049.0 |
| 2008-11-05 | CT | Futures | 45.8 | 46.37 | 44.01 | 44.12 | 8405.0 |
| 2008-11-05 | DC | Futures | 35.84 | 35.84 | 35.38 | 35.56 | 125.0 |
| 2008-11-05 | DX | Futures | 89.398 | 90.236 | 88.471 | 89.178 | 3356.0 |
| 2008-11-05 | E1 | Futures | 1.14818 | 1.15646 | 1.1367 | 1.15098 | 31329.0 |
| 2008-11-05 | E6 | Futures | 1.53267 | 1.5472 | 1.5088 | 1.53255 | 225565.0 |
| 2008-11-05 | E7 | Futures | 1.5181 | 1.5321 | 1.4944 | 1.5178 | 4332.0 |
| 2008-11-05 | ED | Futures | 92.5167 | 92.5592 | 92.4789 | 92.5309 | 147796.0 |
| 2008-11-05 | ER | Futures | 94.956 | 94.966 | 94.897 | 94.937 | 84367.0 |
| 2008-11-05 | EW | Futures | 569.7 | 575.4 | 541.4 | 546.3 | 25667.0 |
| 2008-11-05 | FCE | Futures | 2267.7 | 2272.3 | 2148.2 | 2216.7 | 141469.0 |
| 2008-11-05 | FDAX | Futures | 5972.9 | 5977.4 | 5615.6 | 5813.5 | 168175.0 |
| 2008-11-05 | FESX | Futures | 1608.1 | 1609.9 | 1516.7 | 1570.5 | 1680922.0 |
| 2008-11-05 | FEU3 | Futures | 95.526 | 95.526 | 95.466 | 95.501 | 550.0 |
| 2008-11-05 | FGBL | Futures | 87.91 | 88.12 | 87.29 | 88.09 | 775253.0 |
| 2008-11-05 | FGBM | Futures | 94.76 | 94.99 | 94.25 | 94.85 | 438610.0 |
| 2008-11-05 | FGBS | Futures | 102.104 | 102.22 | 101.902 | 102.104 | 449806.0 |
| 2008-11-05 | FGBX | Futures | 80.45 | 80.45 | 78.81 | 79.51 | 1153.0 |
| 2008-11-05 | FTDX | Futures | 545.7 | 548.3 | 492.1 | 513.5 | 780.0 |
| 2008-11-05 | FTI | Futures | 242.41 | 243.2 | 230.2 | 232.48 | 38043.0 |
| 2008-11-05 | FTUK | Futures | 3005.7 | 3006.7 | 2855.6 | 2940.9 | 150591.0 |
| 2008-11-05 | G | Futures | 69.55 | 69.67 | 68.95 | 69.62 | 80029.0 |
| 2008-11-05 | GF | Futures | 277.767 | 279.706 | 275.62 | 278.875 | 154.0 |
| 2008-11-05 | GSCI | Futures | 1195.6 | 1208.66 | 1152.51 | 1162.3 | 197.0 |
| 2008-11-05 | HE | Futures | 117.286 | 119.514 | 116.959 | 118.427 | 7197.0 |
| 2008-11-05 | HG | Futures | 2.7436 | 2.7492 | 2.5267 | 2.5463 | 19528.0 |
| 2008-11-05 | HO | Futures | 2.4389 | 2.4448 | 2.3045 | 2.3364 | 30060.0 |
| 2008-11-05 | J1 | Futures | 0.0126691 | 0.0129142 | 0.0126514 | 0.0127815 | 104110.0 |
| 2008-11-05 | J7 | Futures | 0.012521 | 0.012709 | 0.012473 | 0.012587 | 74.0 |
| 2008-11-05 | JB | Futures | 114.19 | 115.28 | 114.15 | 114.18 | 53.0 |
| 2008-11-05 | KC | Futures | 343.65 | 349.55 | 339.22 | 343.35 | 10092.0 |
| 2008-11-05 | KE | Futures | 3133.39 | 3172.06 | 2956.8 | 2973.56 | 7175.0 |
| 2008-11-05 | L | Futures | 95.034 | 95.099 | 95.024 | 95.069 | 45998.0 |
| 2008-11-05 | LBS | Futures | 1266.7 | 1284.5 | 1256.9 | 1284.5 | 12.0 |
| 2008-11-05 | LE | Futures | 171.887 | 173.033 | 171.154 | 172.85 | 8341.0 |
> showing 50 of 85 rows — these rows as CSV