PREVIEW / futures_daily / 2010-10-27
file: by_date/futures_daily/2010/2010-10-27.parquet size: 9 KB rows: 91
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 |
|---|---|---|---|---|---|---|---|
| 2010-10-27 | ES | Futures | 1159.78 | 1162.72 | 1144.58 | 1155.36 | 2246880.0 |
| 2010-10-27 | NQ | Futures | 2400.73 | 2409.52 | 2383.73 | 2408.1 | 267310.0 |
| 2010-10-27 | YM | Futures | 10353.6 | 10375.0 | 10207.5 | 10302.4 | 138869.0 |
| 2010-10-27 | CL | Futures | 170.05 | 170.48 | 166.01 | 168.93 | 375249.0 |
| 2010-10-27 | GC | Futures | 1821.9 | 1826.4 | 1792.3 | 1797.8 | 160010.0 |
| 2010-10-27 | ZN | Futures | 103.78698 | 103.864404 | 103.27082 | 103.412764 | 1376068.0 |
| 2010-10-27 | A6 | Futures | 0.82326 | 0.82326 | 0.8053 | 0.80958 | 127242.0 |
| 2010-10-27 | AD | Futures | 0.96667 | 0.96766 | 0.95706 | 0.96102 | 84326.0 |
| 2010-10-27 | B | Futures | 71.36 | 71.48 | 69.95 | 71.1 | 60726.0 |
| 2010-10-27 | B6 | Futures | 1.6444 | 1.6465 | 1.6323 | 1.635 | 119327.0 |
| 2010-10-27 | BFX | Futures | 3072.8 | 3072.8 | 3047.1 | 3050.6 | 106.0 |
| 2010-10-27 | BR | Futures | 0.24687 | 0.24768 | 0.24651 | 0.24691 | 34.0 |
| 2010-10-27 | BZ | Futures | 74.54 | 75.21 | 74.54 | 75.21 | 203.0 |
| 2010-10-27 | C | Futures | 2099.0 | 2138.0 | 2088.0 | 2092.0 | 5412.0 |
| 2010-10-27 | CB | Futures | 104.422 | 104.824 | 104.422 | 104.422 | 2.0 |
| 2010-10-27 | CC | Futures | 2392.0 | 2442.0 | 2360.0 | 2387.0 | 9154.0 |
| 2010-10-27 | CT | Futures | 109.17 | 109.23 | 104.61 | 104.61 | 8542.0 |
| 2010-10-27 | DC | Futures | 24.72 | 24.72 | 24.59 | 24.71 | 142.0 |
| 2010-10-27 | DX | Futures | 78.153 | 78.76 | 78.008 | 78.627 | 30128.0 |
| 2010-10-27 | E1 | Futures | 1.33485 | 1.33485 | 1.32264 | 1.32461 | 38810.0 |
| 2010-10-27 | E6 | Futures | 1.63839 | 1.64075 | 1.6236 | 1.62668 | 359292.0 |
| 2010-10-27 | E7 | Futures | 1.6257 | 1.6282 | 1.6113 | 1.6143 | 6905.0 |
| 2010-10-27 | ED | Futures | 94.7268 | 94.7316 | 94.7221 | 94.7268 | 151878.0 |
| 2010-10-27 | ER | Futures | 97.154 | 97.178 | 97.134 | 97.154 | 177839.0 |
| 2010-10-27 | EW | Futures | 812.9 | 814.7 | 803.5 | 812.1 | 24897.0 |
| 2010-10-27 | FBTP | Futures | 67.61 | 67.63 | 67.04 | 67.05 | 5588.0 |
| 2010-10-27 | FCE | Futures | 2543.9 | 2561.2 | 2520.7 | 2525.3 | 137001.0 |
| 2010-10-27 | FDAX | Futures | 7112.8 | 7140.8 | 7058.5 | 7077.3 | 145073.0 |
| 2010-10-27 | FESX | Futures | 1771.9 | 1783.1 | 1755.0 | 1761.9 | 1249363.0 |
| 2010-10-27 | FEU3 | Futures | 97.701 | 97.726 | 97.701 | 97.716 | 309.0 |
| 2010-10-27 | FGBL | Futures | 102.19 | 102.27 | 101.63 | 101.85 | 1183010.0 |
| 2010-10-27 | FGBM | Futures | 105.56 | 105.59 | 105.27 | 105.44 | 576770.0 |
| 2010-10-27 | FGBS | Futures | 107.159 | 107.174 | 107.061 | 107.144 | 638118.0 |
| 2010-10-27 | FGBX | Futures | 105.54 | 105.65 | 104.22 | 104.43 | 6120.0 |
| 2010-10-27 | FTDX | Futures | 713.5 | 720.5 | 705.5 | 715.2 | 409.0 |
| 2010-10-27 | FTI | Futures | 271.73 | 272.29 | 269.57 | 269.93 | 27861.0 |
| 2010-10-27 | FTUK | Futures | 3938.7 | 3939.1 | 3878.9 | 3894.1 | 105649.0 |
| 2010-10-27 | G | Futures | 83.79 | 83.79 | 83.05 | 83.31 | 212336.0 |
| 2010-10-27 | GF | Futures | 281.614 | 282.684 | 280.67 | 280.859 | 1821.0 |
| 2010-10-27 | GSCI | Futures | 927.94 | 931.9 | 919.11 | 931.24 | 467.0 |
| 2010-10-27 | HE | Futures | 92.9 | 92.934 | 91.174 | 91.817 | 19254.0 |
| 2010-10-27 | HG | Futures | 5.1799 | 5.2053 | 5.0191 | 5.0391 | 39983.0 |
| 2010-10-27 | HO | Futures | 1.9091 | 1.9118 | 1.8718 | 1.9034 | 48994.0 |
| 2010-10-27 | HRC | Futures | 2504.7 | 2504.7 | 2504.7 | 2504.7 | 0.0 |
| 2010-10-27 | J1 | Futures | 0.0154413 | 0.0154513 | 0.015327 | 0.0153785 | 108610.0 |
| 2010-10-27 | J7 | Futures | 0.015333 | 0.015343 | 0.015223 | 0.015273 | 251.0 |
| 2010-10-27 | JB | Futures | 122.12 | 122.12 | 121.88 | 121.95 | 3026.0 |
| 2010-10-27 | KC | Futures | 499.58 | 504.78 | 494.12 | 496.72 | 11554.0 |
| 2010-10-27 | KE | Futures | 3086.28 | 3147.82 | 3066.47 | 3145.74 | 11690.0 |
| 2010-10-27 | L | Futures | 98.155 | 98.185 | 98.125 | 98.165 | 31410.0 |
> showing 50 of 91 rows — these rows as CSV