PREVIEW / futures_daily / 2009-10-06
file: by_date/futures_daily/2009/2009-10-06.parquet size: 8 KB rows: 87
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-10-06 | ES | Futures | 999.98 | 1019.27 | 998.77 | 1011.31 | 2160838.0 |
| 2009-10-06 | NQ | Futures | 1889.68 | 1931.73 | 1889.68 | 1919.88 | 348109.0 |
| 2009-10-06 | YM | Futures | 8666.5 | 8821.7 | 8651.1 | 8764.5 | 149343.0 |
| 2009-10-06 | CL | Futures | 174.0 | 178.23 | 173.5 | 175.53 | 346922.0 |
| 2009-10-06 | GC | Futures | 1407.0 | 1444.6 | 1405.4 | 1437.3 | 103249.0 |
| 2009-10-06 | ZN | Futures | 95.086298 | 95.086298 | 94.774948 | 94.949304 | 761970.0 |
| 2009-10-06 | A6 | Futures | 0.70558 | 0.71657 | 0.70332 | 0.71439 | 79691.0 |
| 2009-10-06 | AD | Futures | 0.92162 | 0.93513 | 0.92004 | 0.9304 | 81699.0 |
| 2009-10-06 | B | Futures | 64.26 | 65.8 | 63.84 | 64.7 | 87837.0 |
| 2009-10-06 | B6 | Futures | 1.6579 | 1.6697 | 1.6514 | 1.6552 | 111832.0 |
| 2009-10-06 | BFX | Futures | 2798.0 | 2867.4 | 2792.3 | 2860.5 | 411.0 |
| 2009-10-06 | BR | Futures | 0.22484 | 0.22589 | 0.22394 | 0.22412 | 810.0 |
| 2009-10-06 | C | Futures | 2210.0 | 2218.0 | 2169.0 | 2203.0 | 7743.0 |
| 2009-10-06 | CB | Futures | 71.273 | 71.542 | 71.273 | 71.273 | 2.0 |
| 2009-10-06 | CC | Futures | 2845.0 | 2850.0 | 2775.0 | 2818.0 | 9420.0 |
| 2009-10-06 | CT | Futures | 53.25 | 55.12 | 52.71 | 54.35 | 11721.0 |
| 2009-10-06 | DC | Futures | 24.75 | 25.16 | 24.68 | 25.02 | 271.0 |
| 2009-10-06 | DX | Futures | 78.46 | 78.491 | 77.878 | 78.098 | 9231.0 |
| 2009-10-06 | E1 | Futures | 1.28022 | 1.29092 | 1.27982 | 1.28616 | 38551.0 |
| 2009-10-06 | E6 | Futures | 1.73612 | 1.74939 | 1.73553 | 1.74323 | 207435.0 |
| 2009-10-06 | E7 | Futures | 1.7192 | 1.7327 | 1.719 | 1.7265 | 3575.0 |
| 2009-10-06 | ED | Futures | 94.2001 | 94.2001 | 94.1718 | 94.186 | 118357.0 |
| 2009-10-06 | ER | Futures | 97.169 | 97.169 | 97.154 | 97.159 | 58715.0 |
| 2009-10-06 | EW | Futures | 656.1 | 669.2 | 655.1 | 662.9 | 40020.0 |
| 2009-10-06 | FCE | Futures | 2435.2 | 2490.0 | 2427.0 | 2489.0 | 146420.0 |
| 2009-10-06 | FDAX | Futures | 6005.8 | 6163.5 | 6004.7 | 6148.8 | 162809.0 |
| 2009-10-06 | FESX | Futures | 1664.7 | 1704.7 | 1662.9 | 1701.7 | 1248474.0 |
| 2009-10-06 | FEU3 | Futures | 97.736 | 97.736 | 97.727 | 97.732 | 19.0 |
| 2009-10-06 | FGBL | Futures | 94.43 | 94.47 | 94.28 | 94.35 | 595246.0 |
| 2009-10-06 | FGBM | Futures | 99.42 | 99.47 | 99.37 | 99.44 | 279162.0 |
| 2009-10-06 | FGBS | Futures | 104.779 | 104.808 | 104.75 | 104.784 | 287325.0 |
| 2009-10-06 | FGBX | Futures | 88.95 | 88.95 | 88.6 | 88.7 | 1442.0 |
| 2009-10-06 | FTDX | Futures | 657.1 | 669.2 | 654.0 | 666.1 | 567.0 |
| 2009-10-06 | FTI | Futures | 249.06 | 255.06 | 248.56 | 254.61 | 35912.0 |
| 2009-10-06 | FTUK | Futures | 3328.0 | 3397.3 | 3317.4 | 3384.7 | 111316.0 |
| 2009-10-06 | G | Futures | 78.04 | 78.19 | 77.96 | 78.08 | 90580.0 |
| 2009-10-06 | GF | Futures | 256.897 | 256.897 | 254.488 | 255.658 | 1048.0 |
| 2009-10-06 | GSCI | Futures | 927.56 | 938.77 | 922.56 | 927.56 | 735.0 |
| 2009-10-06 | HE | Futures | 72.485 | 76.258 | 72.257 | 74.886 | 15211.0 |
| 2009-10-06 | HG | Futures | 3.805 | 3.9228 | 3.8001 | 3.8803 | 16426.0 |
| 2009-10-06 | HO | Futures | 1.7589 | 1.8118 | 1.7582 | 1.7857 | 20664.0 |
| 2009-10-06 | HRC | Futures | 2713.5 | 2713.5 | 2713.5 | 2713.5 | 0.0 |
| 2009-10-06 | J1 | Futures | 0.0140297 | 0.0141753 | 0.0140108 | 0.0141452 | 87266.0 |
| 2009-10-06 | J7 | Futures | 0.013839 | 0.013989 | 0.013828 | 0.013961 | 58.0 |
| 2009-10-06 | JB | Futures | 117.8 | 117.81 | 117.64 | 117.8 | 1793.0 |
| 2009-10-06 | KC | Futures | 343.16 | 357.28 | 342.37 | 352.66 | 11054.0 |
| 2009-10-06 | KE | Futures | 2149.71 | 2271.85 | 2147.38 | 2212.52 | 11248.0 |
| 2009-10-06 | L | Futures | 97.789 | 97.799 | 97.779 | 97.789 | 54862.0 |
| 2009-10-06 | LBS | Futures | 700.6 | 720.2 | 694.9 | 698.2 | 790.0 |
| 2009-10-06 | LE | Futures | 140.787 | 140.829 | 139.615 | 139.866 | 15375.0 |
> showing 50 of 87 rows — these rows as CSV