PREVIEW / futures_daily / 2009-12-08
file: by_date/futures_daily/2009/2009-12-08.parquet size: 9 KB rows: 90
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-12-08 | ES | Futures | 1065.57 | 1068.22 | 1049.17 | 1051.34 | 2251962.0 |
| 2009-12-08 | NQ | Futures | 2015.26 | 2020.34 | 1986.76 | 1996.36 | 350189.0 |
| 2009-12-08 | YM | Futures | 9433.6 | 9460.9 | 9296.6 | 9324.7 | 150310.0 |
| 2009-12-08 | CL | Futures | 180.09 | 181.03 | 176.26 | 176.73 | 424771.0 |
| 2009-12-08 | GC | Futures | 1596.4 | 1610.7 | 1548.9 | 1573.8 | 239293.0 |
| 2009-12-08 | ZN | Futures | 95.31047 | 95.914976 | 95.2475 | 95.738662 | 834707.0 |
| 2009-12-08 | A6 | Futures | 0.73847 | 0.74025 | 0.72845 | 0.72877 | 131692.0 |
| 2009-12-08 | AD | Futures | 0.9375 | 0.94026 | 0.92389 | 0.92399 | 106790.0 |
| 2009-12-08 | B | Futures | 71.33 | 71.54 | 69.73 | 69.84 | 75760.0 |
| 2009-12-08 | B6 | Futures | 1.7118 | 1.7144 | 1.6913 | 1.6917 | 147945.0 |
| 2009-12-08 | BFX | Futures | 2871.7 | 2872.7 | 2822.8 | 2824.3 | 63.0 |
| 2009-12-08 | BR | Futures | 0.22803 | 0.22803 | 0.22643 | 0.22643 | 500.0 |
| 2009-12-08 | C | Futures | 2276.0 | 2276.0 | 2261.0 | 2276.0 | 3106.0 |
| 2009-12-08 | CB | Futures | 72.79 | 73.037 | 71.31 | 71.877 | 36.0 |
| 2009-12-08 | CC | Futures | 2905.0 | 2905.0 | 2870.0 | 2888.0 | 4342.0 |
| 2009-12-08 | CT | Futures | 60.89 | 61.22 | 60.43 | 60.5 | 6753.0 |
| 2009-12-08 | DC | Futures | 24.79 | 24.96 | 24.69 | 24.79 | 179.0 |
| 2009-12-08 | DX | Futures | 77.24 | 77.955 | 77.128 | 77.93 | 22850.0 |
| 2009-12-08 | E1 | Futures | 1.29554 | 1.2995 | 1.28418 | 1.28431 | 68027.0 |
| 2009-12-08 | E6 | Futures | 1.75721 | 1.76195 | 1.73979 | 1.74003 | 330763.0 |
| 2009-12-08 | E7 | Futures | 1.7406 | 1.745 | 1.7232 | 1.7234 | 3321.0 |
| 2009-12-08 | EBM | Futures | 223.51 | 223.93 | 221.81 | 222.66 | 2362.0 |
| 2009-12-08 | ED | Futures | 94.2852 | 94.2876 | 94.2805 | 94.2829 | 139804.0 |
| 2009-12-08 | ER | Futures | 97.179 | 97.188 | 97.179 | 97.184 | 68385.0 |
| 2009-12-08 | EW | Futures | 679.4 | 682.1 | 667.9 | 671.9 | 40485.0 |
| 2009-12-08 | FBTP | Futures | 63.66 | 63.9 | 63.42 | 63.52 | 7222.0 |
| 2009-12-08 | FCE | Futures | 2551.6 | 2555.6 | 2492.5 | 2510.8 | 128536.0 |
| 2009-12-08 | FDAX | Futures | 6305.0 | 6323.5 | 6155.4 | 6196.2 | 189277.0 |
| 2009-12-08 | FESX | Futures | 1733.4 | 1735.8 | 1691.6 | 1702.9 | 1411967.0 |
| 2009-12-08 | FEU3 | Futures | 97.751 | 97.756 | 97.751 | 97.756 | 359.0 |
| 2009-12-08 | FGBL | Futures | 94.85 | 95.39 | 94.77 | 95.15 | 685948.0 |
| 2009-12-08 | FGBM | Futures | 100.01 | 100.44 | 99.95 | 100.34 | 475192.0 |
| 2009-12-08 | FGBS | Futures | 105.114 | 105.348 | 105.09 | 105.313 | 689696.0 |
| 2009-12-08 | FGBX | Futures | 88.76 | 89.17 | 88.19 | 88.89 | 6435.0 |
| 2009-12-08 | FTDX | Futures | 725.7 | 732.4 | 719.9 | 723.9 | 768.0 |
| 2009-12-08 | FTI | Futures | 261.3 | 262.69 | 255.79 | 257.75 | 41343.0 |
| 2009-12-08 | FTUK | Futures | 3505.4 | 3531.9 | 3452.4 | 3469.6 | 120079.0 |
| 2009-12-08 | G | Futures | 76.75 | 77.15 | 76.66 | 76.8 | 117200.0 |
| 2009-12-08 | GF | Futures | 252.05 | 252.39 | 249.338 | 249.677 | 2882.0 |
| 2009-12-08 | GSCI | Futures | 953.16 | 958.96 | 950.26 | 950.26 | 3408.0 |
| 2009-12-08 | HE | Futures | 88.817 | 89.052 | 86.61 | 87.145 | 13604.0 |
| 2009-12-08 | HG | Futures | 4.4159 | 4.4766 | 4.3325 | 4.3663 | 25247.0 |
| 2009-12-08 | HO | Futures | 1.9233 | 1.9307 | 1.8874 | 1.8943 | 17314.0 |
| 2009-12-08 | HRC | Futures | 2511.4 | 2511.4 | 2511.4 | 2511.4 | 0.0 |
| 2009-12-08 | J1 | Futures | 0.0140447 | 0.0142419 | 0.0140384 | 0.0142155 | 126118.0 |
| 2009-12-08 | J7 | Futures | 0.013911 | 0.014052 | 0.013906 | 0.01403 | 69.0 |
| 2009-12-08 | JB | Futures | 118.06 | 118.33 | 118.0 | 118.06 | 8045.0 |
| 2009-12-08 | KC | Futures | 380.03 | 381.33 | 373.78 | 374.56 | 9155.0 |
| 2009-12-08 | KE | Futures | 2428.55 | 2461.33 | 2399.15 | 2410.46 | 7382.0 |
| 2009-12-08 | KRW | Futures | 0.0008499 | 0.0008505 | 0.0008499 | 0.0008505 | 60.0 |
> showing 50 of 90 rows — these rows as CSV