PREVIEW / futures_daily / 2010-10-25
file: by_date/futures_daily/2010/2010-10-25.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-25 | ES | Futures | 1157.33 | 1169.33 | 1157.08 | 1159.29 | 1752840.0 |
| 2010-10-25 | NQ | Futures | 2385.71 | 2410.09 | 2383.44 | 2390.81 | 241766.0 |
| 2010-10-25 | YM | Futures | 10321.9 | 10421.5 | 10315.4 | 10342.4 | 110830.0 |
| 2010-10-25 | CL | Futures | 169.08 | 171.7 | 167.92 | 170.13 | 339395.0 |
| 2010-10-25 | GC | Futures | 1806.9 | 1834.3 | 1806.9 | 1819.9 | 149218.0 |
| 2010-10-25 | ZN | Futures | 104.419277 | 104.845109 | 104.290237 | 104.406373 | 958638.0 |
| 2010-10-25 | A6 | Futures | 0.82192 | 0.83224 | 0.81965 | 0.82796 | 83037.0 |
| 2010-10-25 | AD | Futures | 0.96459 | 0.97439 | 0.9635 | 0.97162 | 63102.0 |
| 2010-10-25 | B | Futures | 71.2 | 71.96 | 70.66 | 71.38 | 60019.0 |
| 2010-10-25 | B6 | Futures | 1.6257 | 1.6368 | 1.6256 | 1.634 | 98994.0 |
| 2010-10-25 | BFX | Futures | 3087.1 | 3099.5 | 3075.7 | 3075.7 | 146.0 |
| 2010-10-25 | BR | Futures | 0.24935 | 0.25003 | 0.24824 | 0.2496 | 86.0 |
| 2010-10-25 | BZ | Futures | 75.71 | 75.71 | 75.0 | 75.51 | 141.0 |
| 2010-10-25 | C | Futures | 2110.0 | 2144.0 | 2108.0 | 2143.0 | 8074.0 |
| 2010-10-25 | CB | Futures | 102.755 | 103.866 | 102.755 | 103.866 | 2.0 |
| 2010-10-25 | CC | Futures | 2373.0 | 2432.0 | 2369.0 | 2426.0 | 10114.0 |
| 2010-10-25 | CT | Futures | 102.39 | 105.56 | 101.99 | 105.56 | 7729.0 |
| 2010-10-25 | DC | Futures | 24.71 | 24.89 | 24.56 | 24.71 | 201.0 |
| 2010-10-25 | DX | Futures | 77.797 | 77.897 | 77.12 | 77.549 | 16198.0 |
| 2010-10-25 | E1 | Futures | 1.34417 | 1.35967 | 1.34233 | 1.35323 | 35247.0 |
| 2010-10-25 | E6 | Futures | 1.64915 | 1.66453 | 1.64726 | 1.65211 | 284655.0 |
| 2010-10-25 | E7 | Futures | 1.6365 | 1.6519 | 1.6349 | 1.6396 | 4309.0 |
| 2010-10-25 | ED | Futures | 94.7268 | 94.7411 | 94.7221 | 94.7316 | 96878.0 |
| 2010-10-25 | ER | Futures | 97.158 | 97.178 | 97.158 | 97.173 | 111577.0 |
| 2010-10-25 | EW | Futures | 810.3 | 821.2 | 809.8 | 814.0 | 23165.0 |
| 2010-10-25 | FBTP | Futures | 67.51 | 67.83 | 67.5 | 67.77 | 2819.0 |
| 2010-10-25 | FCE | Futures | 2578.9 | 2582.9 | 2552.3 | 2563.9 | 102112.0 |
| 2010-10-25 | FDAX | Futures | 7171.5 | 7189.2 | 7136.5 | 7152.1 | 105245.0 |
| 2010-10-25 | FESX | Futures | 1801.8 | 1804.3 | 1778.7 | 1787.5 | 848633.0 |
| 2010-10-25 | FEU3 | Futures | 97.736 | 97.736 | 97.731 | 97.736 | 980.0 |
| 2010-10-25 | FGBL | Futures | 102.58 | 102.79 | 102.45 | 102.67 | 573219.0 |
| 2010-10-25 | FGBM | Futures | 105.73 | 105.93 | 105.68 | 105.85 | 345951.0 |
| 2010-10-25 | FGBS | Futures | 107.174 | 107.292 | 107.169 | 107.253 | 422278.0 |
| 2010-10-25 | FGBX | Futures | 106.12 | 106.48 | 105.74 | 106.21 | 2699.0 |
| 2010-10-25 | FTDX | Futures | 717.8 | 721.4 | 716.5 | 717.4 | 326.0 |
| 2010-10-25 | FTI | Futures | 274.78 | 275.42 | 272.65 | 273.53 | 21068.0 |
| 2010-10-25 | FTUK | Futures | 3964.3 | 3990.9 | 3947.0 | 3966.7 | 74499.0 |
| 2010-10-25 | G | Futures | 84.57 | 84.94 | 84.57 | 84.81 | 76236.0 |
| 2010-10-25 | GF | Futures | 283.125 | 283.125 | 280.544 | 281.677 | 1285.0 |
| 2010-10-25 | GSCI | Futures | 937.02 | 941.31 | 926.62 | 931.24 | 166.0 |
| 2010-10-25 | HE | Futures | 95.234 | 95.268 | 92.494 | 92.629 | 16820.0 |
| 2010-10-25 | HG | Futures | 5.0892 | 5.1913 | 5.0852 | 5.1559 | 31795.0 |
| 2010-10-25 | HO | Futures | 1.9218 | 1.9411 | 1.8986 | 1.9185 | 49171.0 |
| 2010-10-25 | HRC | Futures | 2504.7 | 2504.7 | 2504.7 | 2504.7 | 0.0 |
| 2010-10-25 | J1 | Futures | 0.0154413 | 0.0156284 | 0.0154337 | 0.015538 | 101210.0 |
| 2010-10-25 | J7 | Futures | 0.015339 | 0.015519 | 0.015333 | 0.015431 | 341.0 |
| 2010-10-25 | JB | Futures | 122.25 | 122.27 | 122.13 | 122.22 | 1171.0 |
| 2010-10-25 | KC | Futures | 496.23 | 503.17 | 493.25 | 497.22 | 9513.0 |
| 2010-10-25 | KE | Futures | 2998.67 | 3053.95 | 2992.41 | 3011.19 | 6592.0 |
| 2010-10-25 | L | Futures | 98.155 | 98.175 | 98.155 | 98.175 | 39995.0 |
> showing 50 of 91 rows — these rows as CSV