PREVIEW / futures_daily / 2010-07-01
file: by_date/futures_daily/2010/2010-07-01.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 |
|---|---|---|---|---|---|---|---|
| 2010-07-01 | ES | Futures | 999.25 | 1004.37 | 981.21 | 996.57 | 3354900.0 |
| 2010-07-01 | NQ | Futures | 1965.13 | 1975.88 | 1921.84 | 1955.79 | 505855.0 |
| 2010-07-01 | YM | Futures | 8970.4 | 9003.6 | 8840.0 | 8933.4 | 220123.0 |
| 2010-07-01 | CL | Futures | 160.97 | 161.04 | 153.88 | 155.81 | 405081.0 |
| 2010-07-01 | GC | Futures | 1695.5 | 1698.0 | 1631.4 | 1646.0 | 257842.0 |
| 2010-07-01 | ZN | Futures | 100.554816 | 100.836553 | 100.337109 | 100.490784 | 1316706.0 |
| 2010-07-01 | A6 | Futures | 0.69118 | 0.69457 | 0.68355 | 0.69076 | 167227.0 |
| 2010-07-01 | AD | Futures | 0.92851 | 0.93335 | 0.92456 | 0.93137 | 131906.0 |
| 2010-07-01 | B | Futures | 65.48 | 65.48 | 62.72 | 63.47 | 117317.0 |
| 2010-07-01 | B6 | Futures | 1.5508 | 1.5771 | 1.5435 | 1.5718 | 181152.0 |
| 2010-07-01 | BFX | Futures | 2688.4 | 2699.4 | 2658.2 | 2668.2 | 185.0 |
| 2010-07-01 | BZ | Futures | 68.94 | 68.94 | 67.07 | 67.83 | 85.0 |
| 2010-07-01 | C | Futures | 2487.0 | 2608.0 | 2479.0 | 2580.0 | 3124.0 |
| 2010-07-01 | CB | Futures | 83.053 | 83.053 | 83.053 | 83.053 | 8.0 |
| 2010-07-01 | CC | Futures | 2456.0 | 2550.0 | 2451.0 | 2536.0 | 7884.0 |
| 2010-07-01 | CSC | Futures | 3.68 | 3.689 | 3.68 | 3.689 | 5.0 |
| 2010-07-01 | CT | Futures | 66.46 | 66.67 | 65.62 | 66.54 | 325.0 |
| 2010-07-01 | DC | Futures | 22.76 | 22.92 | 22.72 | 22.86 | 215.0 |
| 2010-07-01 | DX | Futures | 87.134 | 87.23 | 85.345 | 85.657 | 35976.0 |
| 2010-07-01 | E1 | Futures | 1.22034 | 1.24346 | 1.2189 | 1.23768 | 57127.0 |
| 2010-07-01 | E6 | Futures | 1.44725 | 1.48344 | 1.44229 | 1.47587 | 480784.0 |
| 2010-07-01 | E7 | Futures | 1.4372 | 1.4726 | 1.4321 | 1.4652 | 7192.0 |
| 2010-07-01 | ED | Futures | 94.2948 | 94.3043 | 94.2759 | 94.2948 | 139149.0 |
| 2010-07-01 | ER | Futures | 97.276 | 97.281 | 97.227 | 97.242 | 288402.0 |
| 2010-07-01 | EW | Futures | 692.9 | 697.1 | 675.8 | 691.2 | 46326.0 |
| 2010-07-01 | FBTP | Futures | 64.86 | 64.91 | 64.66 | 64.83 | 3674.0 |
| 2010-07-01 | FCE | Futures | 2217.4 | 2239.1 | 2183.9 | 2197.4 | 211735.0 |
| 2010-07-01 | FDAX | Futures | 6400.0 | 6486.0 | 6345.6 | 6384.3 | 198842.0 |
| 2010-07-01 | FESX | Futures | 1559.7 | 1583.3 | 1545.5 | 1557.3 | 1811583.0 |
| 2010-07-01 | FEU3 | Futures | 97.825 | 97.825 | 97.8 | 97.8 | 981.0 |
| 2010-07-01 | FGBL | Futures | 101.17 | 101.26 | 100.73 | 101.19 | 957472.0 |
| 2010-07-01 | FGBM | Futures | 105.55 | 105.59 | 105.17 | 105.46 | 602488.0 |
| 2010-07-01 | FGBS | Futures | 107.618 | 107.618 | 107.362 | 107.47 | 815021.0 |
| 2010-07-01 | FGBX | Futures | 100.89 | 101.34 | 100.3 | 101.2 | 6722.0 |
| 2010-07-01 | FTDX | Futures | 637.7 | 646.1 | 633.7 | 637.3 | 521.0 |
| 2010-07-01 | FTI | Futures | 246.49 | 249.46 | 242.69 | 243.8 | 53593.0 |
| 2010-07-01 | FTUK | Futures | 3316.9 | 3343.1 | 3273.6 | 3281.8 | 150153.0 |
| 2010-07-01 | G | Futures | 81.26 | 81.59 | 81.1 | 81.54 | 125074.0 |
| 2010-07-01 | GF | Futures | 286.023 | 286.023 | 283.813 | 284.445 | 2393.0 |
| 2010-07-01 | GSCI | Futures | 837.91 | 838.76 | 818.02 | 824.76 | 219.0 |
| 2010-07-01 | HE | Futures | 99.132 | 100.285 | 97.979 | 99.375 | 15340.0 |
| 2010-07-01 | HG | Futures | 3.8973 | 3.9321 | 3.8243 | 3.8531 | 36666.0 |
| 2010-07-01 | HO | Futures | 1.7853 | 1.7904 | 1.7107 | 1.7246 | 22476.0 |
| 2010-07-01 | HRC | Futures | 2923.0 | 2923.0 | 2923.0 | 2923.0 | 0.0 |
| 2010-07-01 | J1 | Futures | 0.0142518 | 0.0144833 | 0.0142229 | 0.0143978 | 207851.0 |
| 2010-07-01 | J7 | Futures | 0.01413 | 0.014372 | 0.014117 | 0.014289 | 646.0 |
| 2010-07-01 | JB | Futures | 120.56 | 120.88 | 120.49 | 120.74 | 2141.0 |
| 2010-07-01 | KC | Futures | 415.51 | 425.05 | 412.37 | 422.54 | 14812.0 |
| 2010-07-01 | KE | Futures | 2109.38 | 2191.41 | 2092.33 | 2173.3 | 17742.0 |
| 2010-07-01 | L | Futures | 98.017 | 98.026 | 98.007 | 98.017 | 33237.0 |
> showing 50 of 88 rows — these rows as CSV