PREVIEW / futures_daily / 2009-08-14
file: by_date/futures_daily/2009/2009-08-14.parquet size: 8 KB rows: 86
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 |
|---|---|---|---|---|---|---|---|
| 2009-08-14 | ES | Futures | 971.91 | 974.55 | 952.0 | 964.96 | 1836479.0 |
| 2009-08-14 | NQ | Futures | 1836.21 | 1840.15 | 1796.23 | 1818.75 | 300515.0 |
| 2009-08-14 | YM | Futures | 8468.5 | 8487.5 | 8302.5 | 8409.9 | 130010.0 |
| 2009-08-14 | CL | Futures | 181.56 | 183.56 | 172.78 | 173.65 | 148353.0 |
| 2009-08-14 | GC | Futures | 1322.6 | 1329.1 | 1304.6 | 1311.5 | 78114.0 |
| 2009-08-14 | ZN | Futures | 92.110907 | 92.837354 | 92.024719 | 92.406411 | 765358.0 |
| 2009-08-14 | A6 | Futures | 0.67513 | 0.67987 | 0.66347 | 0.6642 | 79019.0 |
| 2009-08-14 | AD | Futures | 0.9082 | 0.91354 | 0.89605 | 0.89665 | 64088.0 |
| 2009-08-14 | B | Futures | 70.7 | 71.03 | 67.42 | 67.66 | 132352.0 |
| 2009-08-14 | B6 | Futures | 1.726 | 1.7299 | 1.7167 | 1.7188 | 81861.0 |
| 2009-08-14 | BFX | Futures | 2599.3 | 2599.3 | 2580.0 | 2589.4 | 41.0 |
| 2009-08-14 | BR | Futures | 0.213 | 0.213 | 0.20963 | 0.20963 | 11.0 |
| 2009-08-14 | BZ | Futures | 73.37 | 73.37 | 70.58 | 70.58 | 8.0 |
| 2009-08-14 | C | Futures | 1925.0 | 1938.0 | 1882.0 | 1885.0 | 2087.0 |
| 2009-08-14 | CB | Futures | 70.484 | 70.484 | 70.2 | 70.2 | 11.0 |
| 2009-08-14 | CC | Futures | 2564.0 | 2579.0 | 2492.0 | 2495.0 | 13034.0 |
| 2009-08-14 | CT | Futures | 55.03 | 55.03 | 52.37 | 52.37 | 204.0 |
| 2009-08-14 | DC | Futures | 22.46 | 22.57 | 22.32 | 22.46 | 115.0 |
| 2009-08-14 | DX | Futures | 80.404 | 80.89 | 80.148 | 80.865 | 5570.0 |
| 2009-08-14 | E1 | Futures | 1.23655 | 1.24092 | 1.23139 | 1.23205 | 27431.0 |
| 2009-08-14 | E6 | Futures | 1.69554 | 1.6985 | 1.68093 | 1.68212 | 166529.0 |
| 2009-08-14 | E7 | Futures | 1.6783 | 1.681 | 1.6639 | 1.6649 | 1622.0 |
| 2009-08-14 | ED | Futures | 94.0038 | 94.0227 | 94.0038 | 94.0085 | 108235.0 |
| 2009-08-14 | ER | Futures | 97.13 | 97.135 | 97.115 | 97.13 | 76912.0 |
| 2009-08-14 | EW | Futures | 633.8 | 635.6 | 618.1 | 629.2 | 43266.0 |
| 2009-08-14 | FCE | Futures | 2305.7 | 2322.0 | 2274.6 | 2283.1 | 11033.0 |
| 2009-08-14 | FDAX | Futures | 5924.7 | 5976.8 | 5806.2 | 5827.1 | 127689.0 |
| 2009-08-14 | FESX | Futures | 1616.4 | 1625.3 | 1584.8 | 1590.1 | 907329.0 |
| 2009-08-14 | FEU3 | Futures | 97.702 | 97.712 | 97.702 | 97.707 | 243.0 |
| 2009-08-14 | FGBL | Futures | 91.97 | 92.68 | 91.97 | 92.65 | 588550.0 |
| 2009-08-14 | FGBM | Futures | 97.84 | 98.27 | 97.84 | 98.23 | 301760.0 |
| 2009-08-14 | FGBS | Futures | 104.027 | 104.147 | 104.003 | 104.123 | 364596.0 |
| 2009-08-14 | FGBX | Futures | 85.39 | 86.16 | 85.16 | 86.0 | 893.0 |
| 2009-08-14 | FTDX | Futures | 629.0 | 634.8 | 621.0 | 624.6 | 829.0 |
| 2009-08-14 | FTI | Futures | 240.01 | 241.17 | 237.04 | 237.74 | 981.0 |
| 2009-08-14 | FTUK | Futures | 3155.8 | 3170.0 | 3108.6 | 3115.3 | 100710.0 |
| 2009-08-14 | G | Futures | 75.7 | 76.21 | 75.61 | 76.15 | 65223.0 |
| 2009-08-14 | GF | Futures | 276.449 | 278.245 | 274.652 | 277.001 | 914.0 |
| 2009-08-14 | GSCI | Futures | 965.49 | 965.49 | 931.86 | 934.51 | 2139.0 |
| 2009-08-14 | HE | Futures | 67.304 | 68.053 | 66.704 | 66.929 | 8466.0 |
| 2009-08-14 | HG | Futures | 4.1014 | 4.1407 | 3.961 | 3.9821 | 25173.0 |
| 2009-08-14 | HO | Futures | 1.9401 | 1.9555 | 1.8536 | 1.8632 | 44368.0 |
| 2009-08-14 | HRC | Futures | 2586.5 | 2586.5 | 2586.5 | 2586.5 | 0.0 |
| 2009-08-14 | J1 | Futures | 0.0132048 | 0.0133357 | 0.0131884 | 0.0132727 | 78023.0 |
| 2009-08-14 | J7 | Futures | 0.013023 | 0.013152 | 0.013015 | 0.01309 | 79.0 |
| 2009-08-14 | JB | Futures | 115.8 | 116.24 | 115.77 | 116.24 | 2695.0 |
| 2009-08-14 | KC | Futures | 359.8 | 362.1 | 347.86 | 349.89 | 12673.0 |
| 2009-08-14 | KE | Futures | 2440.15 | 2465.33 | 2402.97 | 2438.95 | 5427.0 |
| 2009-08-14 | L | Futures | 97.573 | 97.612 | 97.563 | 97.592 | 38841.0 |
| 2009-08-14 | LBS | Futures | 797.7 | 817.6 | 768.4 | 769.3 | 703.0 |
> showing 50 of 86 rows — these rows as CSV