PREVIEW / futures_daily / 2010-11-05
file: by_date/futures_daily/2010/2010-11-05.parquet size: 9 KB rows: 92
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-11-05 | ES | Futures | 1194.08 | 1200.21 | 1188.45 | 1197.76 | 2301698.0 |
| 2010-11-05 | NQ | Futures | 2476.42 | 2484.36 | 2467.92 | 2477.27 | 324318.0 |
| 2010-11-05 | YM | Futures | 10589.0 | 10636.5 | 10557.4 | 10585.3 | 127295.0 |
| 2010-11-05 | CL | Futures | 178.54 | 180.25 | 177.22 | 179.06 | 317997.0 |
| 2010-11-05 | GC | Futures | 1892.8 | 1901.2 | 1864.8 | 1899.8 | 241404.0 |
| 2010-11-05 | ZN | Futures | 105.503214 | 105.61935 | 104.935437 | 105.23223 | 1676657.0 |
| 2010-11-05 | A6 | Futures | 0.84802 | 0.85079 | 0.84265 | 0.84768 | 85253.0 |
| 2010-11-05 | AD | Futures | 0.98767 | 0.99084 | 0.98163 | 0.98955 | 94523.0 |
| 2010-11-05 | B | Futures | 75.29 | 75.68 | 74.47 | 75.15 | 84693.0 |
| 2010-11-05 | B6 | Futures | 1.6887 | 1.6912 | 1.6778 | 1.6802 | 144779.0 |
| 2010-11-05 | BFX | Futures | 3095.1 | 3095.1 | 3054.5 | 3054.5 | 155.0 |
| 2010-11-05 | BR | Futures | 0.25328 | 0.25355 | 0.25264 | 0.25313 | 25.0 |
| 2010-11-05 | BZ | Futures | 79.5 | 79.5 | 79.5 | 79.5 | 213.0 |
| 2010-11-05 | C | Futures | 1981.0 | 1984.0 | 1937.0 | 1949.0 | 3875.0 |
| 2010-11-05 | CB | Futures | 98.312 | 98.867 | 97.201 | 97.201 | 12.0 |
| 2010-11-05 | CC | Futures | 2271.0 | 2271.0 | 2228.0 | 2251.0 | 9613.0 |
| 2010-11-05 | CSC | Futures | 3.341 | 3.341 | 3.341 | 3.341 | 1.0 |
| 2010-11-05 | CT | Futures | 118.42 | 122.39 | 117.27 | 120.39 | 24019.0 |
| 2010-11-05 | DC | Futures | 23.69 | 23.76 | 22.47 | 22.5 | 950.0 |
| 2010-11-05 | DX | Futures | 76.177 | 77.03 | 76.177 | 76.935 | 24043.0 |
| 2010-11-05 | E1 | Futures | 1.37017 | 1.37542 | 1.3619 | 1.36662 | 48388.0 |
| 2010-11-05 | E6 | Futures | 1.6805 | 1.68499 | 1.65802 | 1.66051 | 410020.0 |
| 2010-11-05 | E7 | Futures | 1.6677 | 1.672 | 1.6454 | 1.6479 | 6365.0 |
| 2010-11-05 | ED | Futures | 94.7506 | 94.7601 | 94.7268 | 94.7363 | 149117.0 |
| 2010-11-05 | ER | Futures | 97.188 | 97.193 | 97.168 | 97.178 | 102237.0 |
| 2010-11-05 | EW | Futures | 838.7 | 846.4 | 835.0 | 844.5 | 21383.0 |
| 2010-11-05 | FBTP | Futures | 66.92 | 67.01 | 66.77 | 66.94 | 5736.0 |
| 2010-11-05 | FCE | Futures | 2597.5 | 2607.1 | 2577.5 | 2592.8 | 115195.0 |
| 2010-11-05 | FDAX | Futures | 7254.8 | 7298.9 | 7227.9 | 7266.6 | 135592.0 |
| 2010-11-05 | FESX | Futures | 1796.2 | 1801.8 | 1776.9 | 1786.2 | 1356081.0 |
| 2010-11-05 | FEU3 | Futures | 97.746 | 97.746 | 97.741 | 97.741 | 26.0 |
| 2010-11-05 | FGBL | Futures | 103.27 | 103.49 | 102.76 | 103.0 | 1187780.0 |
| 2010-11-05 | FGBM | Futures | 106.37 | 106.57 | 106.21 | 106.33 | 696458.0 |
| 2010-11-05 | FGBS | Futures | 107.302 | 107.415 | 107.287 | 107.346 | 693268.0 |
| 2010-11-05 | FGBX | Futures | 106.88 | 107.44 | 105.58 | 106.7 | 3670.0 |
| 2010-11-05 | FTDX | Futures | 725.3 | 728.0 | 717.8 | 719.6 | 806.0 |
| 2010-11-05 | FTI | Futures | 276.78 | 278.82 | 276.14 | 277.46 | 33630.0 |
| 2010-11-05 | FTUK | Futures | 4057.9 | 4069.3 | 4023.7 | 4043.4 | 106147.0 |
| 2010-11-05 | G | Futures | 84.7 | 84.8 | 84.19 | 84.52 | 130797.0 |
| 2010-11-05 | GF | Futures | 277.837 | 278.907 | 277.019 | 278.467 | 690.0 |
| 2010-11-05 | GSCI | Futures | 974.34 | 981.85 | 972.19 | 978.3 | 488.0 |
| 2010-11-05 | HE | Futures | 91.851 | 92.257 | 90.396 | 90.599 | 18842.0 |
| 2010-11-05 | HG | Futures | 5.218 | 5.3327 | 5.218 | 5.27 | 40469.0 |
| 2010-11-05 | HO | Futures | 2.0038 | 2.0205 | 1.9923 | 2.0119 | 41649.0 |
| 2010-11-05 | HRC | Futures | 2459.6 | 2459.6 | 2459.6 | 2459.6 | 0.0 |
| 2010-11-05 | J1 | Futures | 0.0155644 | 0.0155845 | 0.0154187 | 0.0154463 | 118730.0 |
| 2010-11-05 | J7 | Futures | 0.015463 | 0.015525 | 0.015317 | 0.01534 | 250.0 |
| 2010-11-05 | JB | Futures | 122.03 | 122.23 | 121.86 | 121.94 | 3495.0 |
| 2010-11-05 | KC | Futures | 508.38 | 512.97 | 504.16 | 508.75 | 9894.0 |
| 2010-11-05 | KE | Futures | 3212.49 | 3282.37 | 3171.81 | 3279.24 | 14962.0 |
> showing 50 of 92 rows — these rows as CSV