PREVIEW / futures_daily / 2009-11-19
file: by_date/futures_daily/2009/2009-11-19.parquet size: 9 KB rows: 88
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-11-19 | ES | Futures | 1069.19 | 1070.15 | 1047.97 | 1055.44 | 2047058.0 |
| 2009-11-19 | NQ | Futures | 2032.48 | 2034.17 | 1986.48 | 1998.33 | 356418.0 |
| 2009-11-19 | YM | Futures | 9445.4 | 9452.7 | 9290.2 | 9375.5 | 133529.0 |
| 2009-11-19 | CL | Futures | 195.08 | 195.66 | 188.87 | 189.94 | 310746.0 |
| 2009-11-19 | GC | Futures | 1581.5 | 1585.0 | 1562.2 | 1578.6 | 194975.0 |
| 2009-11-19 | ZN | Futures | 95.210838 | 95.572004 | 95.148568 | 95.37274 | 798621.0 |
| 2009-11-19 | A6 | Futures | 0.74914 | 0.7497 | 0.73629 | 0.74098 | 111382.0 |
| 2009-11-19 | AD | Futures | 0.93473 | 0.93503 | 0.92221 | 0.92803 | 91057.0 |
| 2009-11-19 | B | Futures | 73.76 | 74.12 | 71.72 | 72.12 | 147852.0 |
| 2009-11-19 | B6 | Futures | 1.742 | 1.7424 | 1.7275 | 1.7318 | 93949.0 |
| 2009-11-19 | BFX | Futures | 2857.1 | 2860.7 | 2801.1 | 2812.7 | 513.0 |
| 2009-11-19 | BR | Futures | 0.22975 | 0.22975 | 0.22975 | 0.22975 | 12.0 |
| 2009-11-19 | BZ | Futures | 77.08 | 77.08 | 76.79 | 76.79 | 6.0 |
| 2009-11-19 | C | Futures | 2158.0 | 2161.0 | 2136.0 | 2142.0 | 3111.0 |
| 2009-11-19 | CC | Futures | 2791.0 | 2804.0 | 2742.0 | 2747.0 | 4799.0 |
| 2009-11-19 | CT | Futures | 59.15 | 59.58 | 58.71 | 59.39 | 8136.0 |
| 2009-11-19 | DC | Futures | 24.47 | 24.59 | 24.18 | 24.25 | 184.0 |
| 2009-11-19 | DX | Futures | 76.776 | 77.23 | 76.776 | 76.949 | 13469.0 |
| 2009-11-19 | E1 | Futures | 1.30809 | 1.30809 | 1.29567 | 1.30373 | 65381.0 |
| 2009-11-19 | E6 | Futures | 1.77309 | 1.77333 | 1.75899 | 1.76788 | 285426.0 |
| 2009-11-19 | E7 | Futures | 1.7557 | 1.7562 | 1.7423 | 1.7509 | 3937.0 |
| 2009-11-19 | ED | Futures | 94.271 | 94.2852 | 94.271 | 94.2805 | 113999.0 |
| 2009-11-19 | ER | Futures | 97.169 | 97.174 | 97.164 | 97.169 | 76377.0 |
| 2009-11-19 | EW | Futures | 683.1 | 683.7 | 665.6 | 671.1 | 31941.0 |
| 2009-11-19 | FBTP | Futures | 62.99 | 63.01 | 62.73 | 62.9 | 4553.0 |
| 2009-11-19 | FCE | Futures | 2541.4 | 2542.3 | 2486.6 | 2494.2 | 94825.0 |
| 2009-11-19 | FDAX | Futures | 6310.4 | 6310.4 | 6190.7 | 6216.3 | 151177.0 |
| 2009-11-19 | FESX | Futures | 1738.2 | 1738.2 | 1702.3 | 1709.5 | 1267995.0 |
| 2009-11-19 | FEU3 | Futures | 97.741 | 97.741 | 97.741 | 97.741 | 93.0 |
| 2009-11-19 | FGBL | Futures | 94.2 | 94.4 | 94.06 | 94.38 | 706532.0 |
| 2009-11-19 | FGBM | Futures | 99.64 | 99.74 | 99.52 | 99.73 | 377211.0 |
| 2009-11-19 | FGBS | Futures | 105.04 | 105.074 | 104.977 | 105.06 | 466701.0 |
| 2009-11-19 | FGBX | Futures | 87.96 | 88.45 | 87.6 | 88.33 | 4174.0 |
| 2009-11-19 | FTDX | Futures | 694.5 | 696.3 | 668.3 | 677.2 | 881.0 |
| 2009-11-19 | FTI | Futures | 262.12 | 262.12 | 255.18 | 255.83 | 25402.0 |
| 2009-11-19 | FTUK | Futures | 3535.3 | 3543.2 | 3482.9 | 3492.1 | 100631.0 |
| 2009-11-19 | G | Futures | 76.76 | 77.01 | 76.56 | 77.0 | 90450.0 |
| 2009-11-19 | GF | Futures | 249.135 | 249.881 | 248.592 | 249.067 | 1337.0 |
| 2009-11-19 | GSCI | Futures | 1000.53 | 1003.62 | 981.78 | 990.86 | 483.0 |
| 2009-11-19 | HE | Futures | 85.539 | 85.573 | 84.201 | 84.669 | 6820.0 |
| 2009-11-19 | HG | Futures | 4.3566 | 4.3656 | 4.2621 | 4.2849 | 9207.0 |
| 2009-11-19 | HO | Futures | 1.988 | 1.9882 | 1.9284 | 1.9406 | 5638.0 |
| 2009-11-19 | HRC | Futures | 2637.0 | 2637.0 | 2637.0 | 2637.0 | 0.0 |
| 2009-11-19 | J1 | Futures | 0.0140636 | 0.0141678 | 0.0140384 | 0.01411 | 97353.0 |
| 2009-11-19 | J7 | Futures | 0.013879 | 0.013988 | 0.013879 | 0.013926 | 47.0 |
| 2009-11-19 | JB | Futures | 117.59 | 117.67 | 117.43 | 117.48 | 1784.0 |
| 2009-11-19 | KC | Futures | 364.41 | 364.54 | 352.18 | 356.73 | 10471.0 |
| 2009-11-19 | KE | Futures | 2618.5 | 2647.58 | 2556.85 | 2610.36 | 6107.0 |
| 2009-11-19 | L | Futures | 97.789 | 97.789 | 97.77 | 97.779 | 20114.0 |
| 2009-11-19 | LBS | Futures | 817.3 | 828.1 | 810.0 | 820.2 | 173.0 |
> showing 50 of 88 rows — these rows as CSV