PREVIEW / futures_daily / 2010-06-07
file: by_date/futures_daily/2010/2010-06-07.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-06-07 | ES | Futures | 1036.11 | 1042.68 | 1019.55 | 1020.53 | 2390986.0 |
| 2010-06-07 | NQ | Futures | 2078.0 | 2093.6 | 2034.89 | 2037.16 | 334305.0 |
| 2010-06-07 | YM | Futures | 9122.8 | 9169.7 | 8997.8 | 9003.3 | 160858.0 |
| 2010-06-07 | CL | Futures | 153.94 | 158.62 | 152.1 | 156.32 | 417308.0 |
| 2010-06-07 | GC | Futures | 1665.7 | 1700.6 | 1653.4 | 1692.5 | 154985.0 |
| 2010-06-07 | ZN | Futures | 99.389077 | 99.605889 | 98.968207 | 99.299801 | 60642.0 |
| 2010-06-07 | A6 | Futures | 0.67505 | 0.67505 | 0.66373 | 0.66742 | 130463.0 |
| 2010-06-07 | AD | Futures | 0.93108 | 0.93878 | 0.92408 | 0.93375 | 108473.0 |
| 2010-06-07 | B | Futures | 63.18 | 64.68 | 62.53 | 63.95 | 71869.0 |
| 2010-06-07 | B6 | Futures | 1.4976 | 1.5121 | 1.4937 | 1.5023 | 133300.0 |
| 2010-06-07 | BFX | Futures | 2733.5 | 2788.2 | 2726.4 | 2748.2 | 326.0 |
| 2010-06-07 | BR | Futures | 0.21841 | 0.21841 | 0.21841 | 0.21841 | 3.0 |
| 2010-06-07 | BZ | Futures | 68.97 | 68.97 | 68.97 | 68.97 | 3.0 |
| 2010-06-07 | C | Futures | 2538.0 | 2581.0 | 2512.0 | 2518.0 | 4227.0 |
| 2010-06-07 | CC | Futures | 2437.0 | 2480.0 | 2437.0 | 2455.0 | 7321.0 |
| 2010-06-07 | CT | Futures | 61.25 | 61.59 | 60.25 | 61.38 | 14706.0 |
| 2010-06-07 | DC | Futures | 22.31 | 22.31 | 22.14 | 22.17 | 84.0 |
| 2010-06-07 | DX | Futures | 89.581 | 89.986 | 89.409 | 89.645 | 19602.0 |
| 2010-06-07 | E1 | Futures | 1.1314 | 1.1364 | 1.12771 | 1.13324 | 48950.0 |
| 2010-06-07 | E6 | Futures | 1.41391 | 1.41864 | 1.40468 | 1.41201 | 373148.0 |
| 2010-06-07 | E7 | Futures | 1.4022 | 1.4069 | 1.3934 | 1.4004 | 6866.0 |
| 2010-06-07 | ED | Futures | 94.2026 | 94.2168 | 94.1931 | 94.2121 | 113080.0 |
| 2010-06-07 | ER | Futures | 97.365 | 97.375 | 97.36 | 97.365 | 76003.0 |
| 2010-06-07 | EW | Futures | 717.0 | 723.3 | 700.3 | 700.7 | 32820.0 |
| 2010-06-07 | FBTP | Futures | 63.49 | 63.5 | 63.09 | 63.15 | 8876.0 |
| 2010-06-07 | FCE | Futures | 2245.2 | 2285.4 | 2230.7 | 2255.5 | 151817.0 |
| 2010-06-07 | FDAX | Futures | 6375.6 | 6478.4 | 6342.4 | 6407.2 | 160446.0 |
| 2010-06-07 | FESX | Futures | 1531.6 | 1564.1 | 1522.4 | 1541.4 | 1696473.0 |
| 2010-06-07 | FEU3 | Futures | 97.929 | 97.929 | 97.919 | 97.924 | 996.0 |
| 2010-06-07 | FGBL | Futures | 100.98 | 101.13 | 100.78 | 100.99 | 863310.0 |
| 2010-06-07 | FGBM | Futures | 105.42 | 105.56 | 105.3 | 105.41 | 604922.0 |
| 2010-06-07 | FGBS | Futures | 107.711 | 107.765 | 107.662 | 107.701 | 669863.0 |
| 2010-06-07 | FGBX | Futures | 99.89 | 100.53 | 99.89 | 100.3 | 10814.0 |
| 2010-06-07 | FTDX | Futures | 646.9 | 653.6 | 641.6 | 645.2 | 508.0 |
| 2010-06-07 | FTI | Futures | 248.11 | 252.28 | 247.36 | 249.99 | 36029.0 |
| 2010-06-07 | FTUK | Futures | 3410.7 | 3466.9 | 3394.4 | 3427.6 | 123659.0 |
| 2010-06-07 | G | Futures | 80.18 | 80.34 | 80.0 | 80.19 | 61427.0 |
| 2010-06-07 | GF | Futures | 276.045 | 276.361 | 272.887 | 273.835 | 2570.0 |
| 2010-06-07 | GSCI | Futures | 822.64 | 832.38 | 818.82 | 826.12 | 3781.0 |
| 2010-06-07 | HE | Futures | 99.758 | 99.758 | 97.036 | 97.63 | 26318.0 |
| 2010-06-07 | HG | Futures | 3.809 | 3.8151 | 3.6936 | 3.7561 | 36917.0 |
| 2010-06-07 | HO | Futures | 1.7417 | 1.7779 | 1.7346 | 1.7643 | 10940.0 |
| 2010-06-07 | J1 | Futures | 0.0136782 | 0.0138215 | 0.0136543 | 0.0137109 | 169681.0 |
| 2010-06-07 | J7 | Futures | 0.01361 | 0.01371 | 0.013547 | 0.013601 | 663.0 |
| 2010-06-07 | JB | Futures | 119.65 | 119.87 | 119.6 | 119.82 | 7005.0 |
| 2010-06-07 | KC | Futures | 338.67 | 339.31 | 336.52 | 337.91 | 11931.0 |
| 2010-06-07 | KE | Futures | 2021.57 | 2030.26 | 2007.44 | 2008.53 | 10180.0 |
| 2010-06-07 | L | Futures | 97.898 | 97.928 | 97.888 | 97.918 | 41689.0 |
| 2010-06-07 | LBS | Futures | 713.1 | 713.1 | 674.7 | 674.7 | 732.0 |
| 2010-06-07 | LE | Futures | 144.258 | 144.461 | 142.549 | 142.753 | 25096.0 |
> showing 50 of 88 rows — these rows as CSV