PREVIEW / futures_daily / 2008-07-03
file: by_date/futures_daily/2008/2008-07-03.parquet size: 8 KB rows: 82
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-03 | ES | Futures | 1168.69 | 1178.17 | 1157.82 | 1170.07 | 1847255.0 |
| 2008-07-03 | NQ | Futures | 2032.18 | 2045.81 | 2009.37 | 2026.89 | 326610.0 |
| 2008-07-03 | YM | Futures | 9957.5 | 10056.1 | 9891.8 | 10025.0 | 170223.0 |
| 2008-07-03 | CL | Futures | 627.04 | 634.26 | 622.82 | 631.82 | 193841.0 |
| 2008-07-03 | GC | Futures | 1340.5 | 1345.3 | 1314.2 | 1322.1 | 128419.0 |
| 2008-07-03 | ZN | Futures | 84.135766 | 84.365896 | 83.859609 | 84.216312 | 921215.0 |
| 2008-07-03 | A6 | Futures | 0.7367 | 0.73716 | 0.73322 | 0.734 | 36635.0 |
| 2008-07-03 | AD | Futures | 0.97001 | 0.9706 | 0.96009 | 0.96087 | 37382.0 |
| 2008-07-03 | B | Futures | 174.28 | 176.4 | 173.49 | 175.68 | 50631.0 |
| 2008-07-03 | B6 | Futures | 2.0419 | 2.042 | 2.0276 | 2.0296 | 88289.0 |
| 2008-07-03 | BFX | Futures | 3468.1 | 3512.6 | 3427.6 | 3511.5 | 1225.0 |
| 2008-07-03 | BR | Futures | 0.22291 | 0.22437 | 0.22291 | 0.22437 | 6.0 |
| 2008-07-03 | BZ | Futures | 173.38 | 173.38 | 171.56 | 173.08 | 231.0 |
| 2008-07-03 | C | Futures | 1531.0 | 1541.0 | 1469.0 | 1471.0 | 2523.0 |
| 2008-07-03 | CB | Futures | 95.163 | 95.163 | 95.163 | 95.163 | 3.0 |
| 2008-07-03 | CC | Futures | 2929.0 | 2950.0 | 2775.0 | 2813.0 | 10314.0 |
| 2008-07-03 | CT | Futures | 76.02 | 76.36 | 74.48 | 75.48 | 375.0 |
| 2008-07-03 | DC | Futures | 52.98 | 54.22 | 52.98 | 54.17 | 224.0 |
| 2008-07-03 | DX | Futures | 77.363 | 77.575 | 76.527 | 77.342 | 45.0 |
| 2008-07-03 | E1 | Futures | 1.3155 | 1.3187 | 1.29644 | 1.29884 | 98851.0 |
| 2008-07-03 | E6 | Futures | 1.85377 | 1.85599 | 1.8293 | 1.83094 | 305186.0 |
| 2008-07-03 | E7 | Futures | 1.8348 | 1.8379 | 1.8116 | 1.8132 | 4390.0 |
| 2008-07-03 | ED | Futures | 91.6266 | 91.6691 | 91.6171 | 91.6455 | 183170.0 |
| 2008-07-03 | ER | Futures | 93.497 | 93.581 | 93.457 | 93.566 | 267727.0 |
| 2008-07-03 | EW | Futures | 788.8 | 791.6 | 774.4 | 779.3 | 28782.0 |
| 2008-07-03 | FCE | Futures | 2817.2 | 2874.2 | 2783.3 | 2864.6 | 184613.0 |
| 2008-07-03 | FDAX | Futures | 7095.3 | 7225.7 | 7007.9 | 7183.2 | 231841.0 |
| 2008-07-03 | FESX | Futures | 1933.3 | 1977.3 | 1913.9 | 1970.3 | 2143594.0 |
| 2008-07-03 | FEU3 | Futures | 94.043 | 94.122 | 94.018 | 94.112 | 3525.0 |
| 2008-07-03 | FGBL | Futures | 82.92 | 83.69 | 82.69 | 83.69 | 1184246.0 |
| 2008-07-03 | FGBM | Futures | 89.15 | 89.91 | 88.82 | 89.91 | 869246.0 |
| 2008-07-03 | FGBS | Futures | 98.911 | 99.347 | 98.728 | 99.347 | 1131622.0 |
| 2008-07-03 | FGBX | Futures | 74.09 | 74.67 | 73.78 | 74.27 | 4358.0 |
| 2008-07-03 | FTDX | Futures | 659.7 | 681.4 | 647.9 | 676.0 | 1243.0 |
| 2008-07-03 | FTI | Futures | 305.72 | 309.6 | 302.1 | 308.39 | 55426.0 |
| 2008-07-03 | FTUK | Futures | 3494.3 | 3569.8 | 3482.7 | 3563.3 | 148315.0 |
| 2008-07-03 | G | Futures | 66.44 | 67.07 | 66.3 | 66.83 | 88481.0 |
| 2008-07-03 | GF | Futures | 302.799 | 304.562 | 301.578 | 302.596 | 161.0 |
| 2008-07-03 | GSCI | Futures | 2300.64 | 2316.52 | 2293.74 | 2308.71 | 147.0 |
| 2008-07-03 | HE | Futures | 142.085 | 142.884 | 141.185 | 141.785 | 3319.0 |
| 2008-07-03 | HG | Futures | 5.6075 | 5.6375 | 5.4717 | 5.5037 | 15834.0 |
| 2008-07-03 | HO | Futures | 4.7762 | 4.8467 | 4.7726 | 4.8128 | 8067.0 |
| 2008-07-03 | J1 | Futures | 0.0120665 | 0.0120741 | 0.0119405 | 0.0119685 | 145142.0 |
| 2008-07-03 | J7 | Futures | 0.011846 | 0.011865 | 0.011734 | 0.011763 | 39.0 |
| 2008-07-03 | JB | Futures | 112.54 | 112.87 | 112.34 | 112.67 | 2165.0 |
| 2008-07-03 | KC | Futures | 472.43 | 473.49 | 458.93 | 460.9 | 8734.0 |
| 2008-07-03 | KE | Futures | 4790.11 | 4843.16 | 4719.82 | 4839.18 | 9845.0 |
| 2008-07-03 | L | Futures | 93.224 | 93.289 | 93.22 | 93.279 | 64493.0 |
| 2008-07-03 | LE | Futures | 207.573 | 208.119 | 205.882 | 206.429 | 5427.0 |
| 2008-07-03 | MP | Futures | 0.04593 | 0.04612 | 0.04583 | 0.04601 | 12612.0 |
> showing 50 of 82 rows — these rows as CSV