PREVIEW / futures_daily / 2008-11-20
file: by_date/futures_daily/2008/2008-11-20.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-20 | ES | Futures | 763.19 | 772.84 | 701.51 | 704.57 | 4471459.0 |
| 2008-11-20 | NQ | Futures | 1218.55 | 1247.07 | 1153.4 | 1162.63 | 584821.0 |
| 2008-11-20 | YM | Futures | 7129.0 | 7261.4 | 6634.2 | 6651.1 | 441818.0 |
| 2008-11-20 | CL | Futures | 226.05 | 227.48 | 205.16 | 208.96 | 274669.0 |
| 2008-11-20 | GC | Futures | 1028.2 | 1053.6 | 1024.5 | 1047.0 | 118163.0 |
| 2008-11-20 | ZN | Futures | 89.42653 | 91.109633 | 89.251207 | 90.303146 | 985951.0 |
| 2008-11-20 | A6 | Futures | 0.50003 | 0.5042 | 0.47672 | 0.48129 | 34386.0 |
| 2008-11-20 | AD | Futures | 0.78594 | 0.78761 | 0.7589 | 0.76778 | 38372.0 |
| 2008-11-20 | B | Futures | 57.97 | 59.33 | 53.94 | 54.65 | 126424.0 |
| 2008-11-20 | B6 | Futures | 1.5524 | 1.5571 | 1.5272 | 1.5382 | 70909.0 |
| 2008-11-20 | BFX | Futures | 2134.0 | 2134.0 | 2086.3 | 2095.0 | 874.0 |
| 2008-11-20 | BZ | Futures | 53.92 | 55.26 | 52.25 | 52.94 | 624.0 |
| 2008-11-20 | C | Futures | 1317.0 | 1318.0 | 1284.0 | 1304.0 | 2890.0 |
| 2008-11-20 | CB | Futures | 91.254 | 91.874 | 91.254 | 91.874 | 10.0 |
| 2008-11-20 | CC | Futures | 1809.0 | 1814.0 | 1757.0 | 1772.0 | 6169.0 |
| 2008-11-20 | CT | Futures | 40.33 | 40.59 | 38.84 | 39.47 | 4424.0 |
| 2008-11-20 | DC | Futures | 37.67 | 37.67 | 36.83 | 37.34 | 81.0 |
| 2008-11-20 | DX | Futures | 92.227 | 92.84 | 91.886 | 92.494 | 3310.0 |
| 2008-11-20 | E1 | Futures | 1.10118 | 1.10345 | 1.08769 | 1.09237 | 28048.0 |
| 2008-11-20 | E6 | Futures | 1.47513 | 1.48683 | 1.46698 | 1.47678 | 192049.0 |
| 2008-11-20 | E7 | Futures | 1.4603 | 1.4723 | 1.4537 | 1.4626 | 2711.0 |
| 2008-11-20 | ED | Futures | 92.5521 | 92.7056 | 92.5167 | 92.6277 | 185654.0 |
| 2008-11-20 | ER | Futures | 95.247 | 95.385 | 95.237 | 95.346 | 153859.0 |
| 2008-11-20 | EW | Futures | 446.1 | 448.1 | 405.6 | 409.5 | 60602.0 |
| 2008-11-20 | FCE | Futures | 1807.1 | 1835.2 | 1700.2 | 1784.9 | 102890.0 |
| 2008-11-20 | FDAX | Futures | 4742.6 | 4860.6 | 4522.2 | 4740.3 | 256828.0 |
| 2008-11-20 | FESX | Futures | 1293.4 | 1329.9 | 1227.5 | 1291.1 | 2622935.0 |
| 2008-11-20 | FEU3 | Futures | 95.818 | 95.942 | 95.808 | 95.912 | 910.0 |
| 2008-11-20 | FGBL | Futures | 90.38 | 91.38 | 90.34 | 90.91 | 962930.0 |
| 2008-11-20 | FGBM | Futures | 96.28 | 96.78 | 96.22 | 96.55 | 602303.0 |
| 2008-11-20 | FGBS | Futures | 102.769 | 103.0 | 102.721 | 102.865 | 623808.0 |
| 2008-11-20 | FGBX | Futures | 82.25 | 84.06 | 82.2 | 83.56 | 3552.0 |
| 2008-11-20 | FTDX | Futures | 401.9 | 401.9 | 373.3 | 386.7 | 1005.0 |
| 2008-11-20 | FTI | Futures | 186.98 | 187.18 | 179.72 | 182.85 | 18029.0 |
| 2008-11-20 | FTUK | Futures | 2516.5 | 2582.0 | 2393.3 | 2505.8 | 209046.0 |
| 2008-11-20 | G | Futures | 71.81 | 72.67 | 71.79 | 72.37 | 124414.0 |
| 2008-11-20 | GF | Futures | 247.834 | 251.289 | 242.166 | 248.11 | 902.0 |
| 2008-11-20 | GSCI | Futures | 977.27 | 977.27 | 915.37 | 915.37 | 142.0 |
| 2008-11-20 | HE | Futures | 121.93 | 125.603 | 119.127 | 125.023 | 10077.0 |
| 2008-11-20 | HG | Futures | 2.2372 | 2.2843 | 2.1717 | 2.2238 | 9781.0 |
| 2008-11-20 | HO | Futures | 2.0052 | 2.01 | 1.9079 | 1.9079 | 2618.0 |
| 2008-11-20 | HRC | Futures | 3762.7 | 3762.7 | 3762.7 | 3762.7 | 0.0 |
| 2008-11-20 | J1 | Futures | 0.0132047 | 0.0135117 | 0.0131302 | 0.0133411 | 161247.0 |
| 2008-11-20 | J7 | Futures | 0.012964 | 0.013305 | 0.01294 | 0.013138 | 56.0 |
| 2008-11-20 | JB | Futures | 115.87 | 115.98 | 115.52 | 115.9 | 19.0 |
| 2008-11-20 | KC | Futures | 324.39 | 324.39 | 317.53 | 318.24 | 9276.0 |
| 2008-11-20 | KE | Futures | 2874.31 | 2878.18 | 2772.49 | 2826.62 | 7933.0 |
| 2008-11-20 | L | Futures | 95.773 | 95.867 | 95.753 | 95.832 | 42891.0 |
| 2008-11-20 | LBS | Futures | 1207.7 | 1207.7 | 1198.7 | 1203.2 | 28.0 |
| 2008-11-20 | LE | Futures | 152.155 | 155.196 | 150.008 | 154.794 | 7571.0 |
> showing 50 of 85 rows — these rows as CSV