PREVIEW / futures_daily / 2008-07-28
file: by_date/futures_daily/2008/2008-07-28.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-28 | ES | Futures | 1161.06 | 1165.45 | 1140.48 | 1142.33 | 1619650.0 |
| 2008-07-28 | NQ | Futures | 2052.76 | 2063.05 | 2002.42 | 2017.72 | 351219.0 |
| 2008-07-28 | YM | Futures | 10064.1 | 10077.4 | 9863.4 | 9890.0 | 160912.0 |
| 2008-07-28 | CL | Futures | 535.68 | 543.53 | 532.29 | 541.41 | 197074.0 |
| 2008-07-28 | GC | Futures | 1312.5 | 1318.9 | 1304.2 | 1311.5 | 80820.0 |
| 2008-07-28 | ZN | Futures | 83.52592 | 84.296857 | 83.502907 | 84.147272 | 797229.0 |
| 2008-07-28 | A6 | Futures | 0.73392 | 0.73639 | 0.73122 | 0.73446 | 26549.0 |
| 2008-07-28 | AD | Futures | 0.96303 | 0.9647 | 0.95802 | 0.9593 | 39480.0 |
| 2008-07-28 | B | Futures | 149.22 | 151.06 | 148.22 | 150.3 | 33455.0 |
| 2008-07-28 | B6 | Futures | 2.0414 | 2.0483 | 2.0354 | 2.0465 | 71124.0 |
| 2008-07-28 | BFX | Futures | 3452.5 | 3452.5 | 3399.1 | 3402.5 | 278.0 |
| 2008-07-28 | BZ | Futures | 147.02 | 147.02 | 146.53 | 146.97 | 579.0 |
| 2008-07-28 | C | Futures | 1327.0 | 1354.0 | 1311.0 | 1318.0 | 4098.0 |
| 2008-07-28 | CB | Futures | 95.316 | 95.316 | 95.025 | 95.163 | 9.0 |
| 2008-07-28 | CC | Futures | 2523.0 | 2565.0 | 2500.0 | 2507.0 | 5429.0 |
| 2008-07-28 | CT | Futures | 75.07 | 75.36 | 74.22 | 74.31 | 156.0 |
| 2008-07-28 | DC | Futures | 51.81 | 52.07 | 51.14 | 51.41 | 206.0 |
| 2008-07-28 | DX | Futures | 77.331 | 77.395 | 77.056 | 77.114 | 3108.0 |
| 2008-07-28 | E1 | Futures | 1.28538 | 1.29138 | 1.28352 | 1.29071 | 43211.0 |
| 2008-07-28 | E6 | Futures | 1.83398 | 1.84147 | 1.83152 | 1.83972 | 138898.0 |
| 2008-07-28 | E7 | Futures | 1.8151 | 1.8235 | 1.8139 | 1.8219 | 2190.0 |
| 2008-07-28 | ED | Futures | 91.6502 | 91.6927 | 91.6407 | 91.6785 | 132307.0 |
| 2008-07-28 | ER | Futures | 93.585 | 93.605 | 93.576 | 93.595 | 68965.0 |
| 2008-07-28 | EW | Futures | 785.6 | 790.9 | 776.5 | 777.8 | 18085.0 |
| 2008-07-28 | FCE | Futures | 2846.6 | 2859.3 | 2797.1 | 2823.5 | 86847.0 |
| 2008-07-28 | FDAX | Futures | 7237.5 | 7249.8 | 7089.7 | 7093.0 | 133417.0 |
| 2008-07-28 | FESX | Futures | 1969.1 | 1974.4 | 1935.1 | 1935.1 | 936994.0 |
| 2008-07-28 | FEU3 | Futures | 94.137 | 94.147 | 94.137 | 94.142 | 544.0 |
| 2008-07-28 | FGBL | Futures | 83.19 | 83.72 | 83.1 | 83.71 | 630671.0 |
| 2008-07-28 | FGBM | Futures | 89.8 | 90.13 | 89.73 | 90.13 | 441181.0 |
| 2008-07-28 | FGBS | Futures | 99.366 | 99.473 | 99.318 | 99.473 | 327568.0 |
| 2008-07-28 | FGBX | Futures | 73.61 | 74.5 | 73.61 | 74.5 | 2106.0 |
| 2008-07-28 | FTDX | Futures | 657.9 | 666.0 | 634.3 | 634.3 | 287.0 |
| 2008-07-28 | FTI | Futures | 302.53 | 304.38 | 299.76 | 300.99 | 21117.0 |
| 2008-07-28 | FTUK | Futures | 3471.0 | 3475.2 | 3404.9 | 3441.5 | 69619.0 |
| 2008-07-28 | G | Futures | 67.37 | 67.59 | 67.35 | 67.54 | 50145.0 |
| 2008-07-28 | GF | Futures | 301.036 | 302.596 | 300.29 | 301.443 | 166.0 |
| 2008-07-28 | GSCI | Futures | 1962.65 | 1962.65 | 1938.58 | 1957.01 | 390.0 |
| 2008-07-28 | HE | Futures | 158.022 | 158.022 | 155.474 | 156.973 | 2926.0 |
| 2008-07-28 | HG | Futures | 5.0285 | 5.0654 | 5.0006 | 5.034 | 6481.0 |
| 2008-07-28 | HO | Futures | 4.1311 | 4.1977 | 4.1215 | 4.1675 | 26103.0 |
| 2008-07-28 | J1 | Futures | 0.0118248 | 0.0118833 | 0.0118019 | 0.0118668 | 70112.0 |
| 2008-07-28 | J7 | Futures | 0.01162 | 0.011676 | 0.011601 | 0.011663 | 61.0 |
| 2008-07-28 | JB | Futures | 113.46 | 113.59 | 113.25 | 113.53 | 1731.0 |
| 2008-07-28 | KC | Futures | 416.6 | 417.36 | 408.86 | 410.53 | 6498.0 |
| 2008-07-28 | KE | Futures | 4432.04 | 4535.49 | 4363.08 | 4373.69 | 8733.0 |
| 2008-07-28 | L | Futures | 93.388 | 93.388 | 93.363 | 93.383 | 18870.0 |
| 2008-07-28 | LE | Futures | 193.659 | 194.492 | 193.288 | 194.122 | 4362.0 |
| 2008-07-28 | MP | Futures | 0.0474 | 0.04761 | 0.04723 | 0.04753 | 18873.0 |
| 2008-07-28 | N6 | Futures | 0.57155 | 0.57155 | 0.56676 | 0.56962 | 780.0 |
> showing 50 of 82 rows — these rows as CSV