PREVIEW / futures_daily / 2010-08-04
file: by_date/futures_daily/2010/2010-08-04.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-08-04 | ES | Futures | 1090.44 | 1098.25 | 1084.84 | 1096.78 | 1591800.0 |
| 2010-08-04 | NQ | Futures | 2141.98 | 2161.79 | 2131.51 | 2156.41 | 276207.0 |
| 2010-08-04 | YM | Futures | 9792.3 | 9856.1 | 9755.3 | 9833.0 | 105667.0 |
| 2010-08-04 | CL | Futures | 174.99 | 176.16 | 173.29 | 175.09 | 293321.0 |
| 2010-08-04 | GC | Futures | 1614.9 | 1638.6 | 1613.4 | 1625.5 | 119101.0 |
| 2010-08-04 | ZN | Futures | 101.643348 | 101.835442 | 101.271967 | 101.323192 | 1024263.0 |
| 2010-08-04 | A6 | Futures | 0.75292 | 0.75773 | 0.75027 | 0.75707 | 86706.0 |
| 2010-08-04 | AD | Futures | 0.96416 | 0.97147 | 0.9611 | 0.97108 | 82011.0 |
| 2010-08-04 | B | Futures | 71.75 | 72.19 | 71.07 | 71.66 | 119095.0 |
| 2010-08-04 | B6 | Futures | 1.6547 | 1.6564 | 1.6452 | 1.6493 | 97029.0 |
| 2010-08-04 | BFX | Futures | 2949.8 | 2959.8 | 2931.4 | 2958.6 | 121.0 |
| 2010-08-04 | BR | Futures | 0.2363 | 0.2363 | 0.23614 | 0.23614 | 16.0 |
| 2010-08-04 | BZ | Futures | 76.99 | 77.29 | 76.99 | 77.1 | 145.0 |
| 2010-08-04 | C | Futures | 2475.0 | 2535.0 | 2475.0 | 2501.0 | 3716.0 |
| 2010-08-04 | CB | Futures | 88.847 | 88.847 | 88.364 | 88.847 | 44.0 |
| 2010-08-04 | CC | Futures | 2563.0 | 2643.0 | 2557.0 | 2601.0 | 15674.0 |
| 2010-08-04 | CT | Futures | 71.51 | 71.51 | 70.61 | 70.66 | 77.0 |
| 2010-08-04 | DC | Futures | 23.2 | 23.32 | 23.19 | 23.28 | 125.0 |
| 2010-08-04 | DX | Futures | 81.359 | 81.863 | 81.238 | 81.633 | 17993.0 |
| 2010-08-04 | E1 | Futures | 1.26394 | 1.26591 | 1.24464 | 1.24871 | 48400.0 |
| 2010-08-04 | E6 | Futures | 1.56408 | 1.5655 | 1.5525 | 1.55758 | 263048.0 |
| 2010-08-04 | E7 | Futures | 1.5528 | 1.5542 | 1.5413 | 1.5464 | 3305.0 |
| 2010-08-04 | ED | Futures | 94.5416 | 94.5464 | 94.5179 | 94.5321 | 142640.0 |
| 2010-08-04 | ER | Futures | 97.252 | 97.257 | 97.242 | 97.252 | 78271.0 |
| 2010-08-04 | EW | Futures | 753.1 | 760.5 | 748.8 | 760.1 | 22039.0 |
| 2010-08-04 | FBTP | Futures | 66.51 | 66.71 | 66.5 | 66.61 | 1421.0 |
| 2010-08-04 | FCE | Futures | 2450.0 | 2480.5 | 2436.6 | 2467.4 | 97399.0 |
| 2010-08-04 | FDAX | Futures | 6841.7 | 6936.9 | 6818.3 | 6899.9 | 121221.0 |
| 2010-08-04 | FESX | Futures | 1738.6 | 1757.8 | 1725.6 | 1749.8 | 994053.0 |
| 2010-08-04 | FEU3 | Futures | 97.805 | 97.81 | 97.805 | 97.81 | 6.0 |
| 2010-08-04 | FGBL | Futures | 100.94 | 101.12 | 100.81 | 100.91 | 654906.0 |
| 2010-08-04 | FGBM | Futures | 105.17 | 105.29 | 105.11 | 105.18 | 401374.0 |
| 2010-08-04 | FGBS | Futures | 107.441 | 107.49 | 107.392 | 107.421 | 297068.0 |
| 2010-08-04 | FGBX | Futures | 100.41 | 100.77 | 100.16 | 100.66 | 3050.0 |
| 2010-08-04 | FTDX | Futures | 685.3 | 690.2 | 683.6 | 690.2 | 190.0 |
| 2010-08-04 | FTI | Futures | 267.28 | 270.82 | 266.01 | 269.47 | 23891.0 |
| 2010-08-04 | FTUK | Futures | 3688.2 | 3710.6 | 3648.6 | 3699.9 | 85977.0 |
| 2010-08-04 | G | Futures | 81.96 | 82.02 | 81.76 | 81.85 | 63160.0 |
| 2010-08-04 | GF | Futures | 284.824 | 287.729 | 284.824 | 286.971 | 1182.0 |
| 2010-08-04 | GSCI | Futures | 919.97 | 925.57 | 916.92 | 921.67 | 138.0 |
| 2010-08-04 | HE | Futures | 104.497 | 104.728 | 103.443 | 104.003 | 15739.0 |
| 2010-08-04 | HG | Futures | 4.4899 | 4.5676 | 4.4638 | 4.5595 | 32448.0 |
| 2010-08-04 | HO | Futures | 1.9257 | 1.9357 | 1.9104 | 1.9299 | 55998.0 |
| 2010-08-04 | HRC | Futures | 2753.7 | 2753.7 | 2729.3 | 2729.3 | 10.0 |
| 2010-08-04 | J1 | Futures | 0.014667 | 0.0147488 | 0.0145676 | 0.014589 | 114747.0 |
| 2010-08-04 | J7 | Futures | 0.014567 | 0.014638 | 0.01446 | 0.014479 | 360.0 |
| 2010-08-04 | JB | Futures | 120.95 | 121.19 | 120.95 | 121.08 | 2346.0 |
| 2010-08-04 | KC | Futures | 420.91 | 431.2 | 420.91 | 426.3 | 10361.0 |
| 2010-08-04 | KE | Futures | 2919.04 | 3122.52 | 2914.78 | 3095.89 | 15879.0 |
| 2010-08-04 | KRW | Futures | 0.0008371 | 0.0008371 | 0.0008371 | 0.0008371 | 7.0 |
> showing 50 of 91 rows — these rows as CSV