PREVIEW / futures_daily / 2008-07-24
file: by_date/futures_daily/2008/2008-07-24.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-24 | ES | Futures | 1185.1 | 1188.57 | 1157.12 | 1159.67 | 1988950.0 |
| 2008-07-24 | NQ | Futures | 2053.87 | 2073.06 | 2015.21 | 2024.11 | 412530.0 |
| 2008-07-24 | YM | Futures | 10311.0 | 10328.7 | 10062.3 | 10081.0 | 177336.0 |
| 2008-07-24 | CL | Futures | 540.23 | 548.83 | 536.07 | 544.7 | 267709.0 |
| 2008-07-24 | GC | Futures | 1304.0 | 1319.0 | 1297.0 | 1306.1 | 174083.0 |
| 2008-07-24 | ZN | Futures | 83.387841 | 84.170285 | 83.307295 | 84.066727 | 995122.0 |
| 2008-07-24 | A6 | Futures | 0.73724 | 0.73948 | 0.73183 | 0.73454 | 41630.0 |
| 2008-07-24 | AD | Futures | 0.9705 | 0.97394 | 0.96353 | 0.96883 | 30695.0 |
| 2008-07-24 | B | Futures | 150.07 | 152.49 | 148.72 | 151.52 | 105799.0 |
| 2008-07-24 | B6 | Futures | 2.0492 | 2.0509 | 2.0325 | 2.0351 | 111030.0 |
| 2008-07-24 | BFX | Futures | 3594.9 | 3597.7 | 3516.3 | 3518.7 | 298.0 |
| 2008-07-24 | BZ | Futures | 147.65 | 149.38 | 147.15 | 149.28 | 1099.0 |
| 2008-07-24 | C | Futures | 1282.0 | 1315.0 | 1280.0 | 1296.0 | 3773.0 |
| 2008-07-24 | CB | Futures | 95.163 | 95.163 | 94.611 | 94.611 | 6.0 |
| 2008-07-24 | CC | Futures | 2481.0 | 2495.0 | 2453.0 | 2461.0 | 6511.0 |
| 2008-07-24 | CT | Futures | 73.48 | 74.47 | 73.12 | 74.26 | 466.0 |
| 2008-07-24 | DC | Futures | 50.77 | 51.81 | 50.69 | 51.59 | 153.0 |
| 2008-07-24 | DX | Futures | 77.268 | 77.506 | 77.172 | 77.395 | 6322.0 |
| 2008-07-24 | E1 | Futures | 1.28458 | 1.28805 | 1.27992 | 1.28552 | 52598.0 |
| 2008-07-24 | E6 | Futures | 1.83117 | 1.8348 | 1.82462 | 1.82824 | 197725.0 |
| 2008-07-24 | E7 | Futures | 1.8139 | 1.817 | 1.807 | 1.8106 | 2757.0 |
| 2008-07-24 | ED | Futures | 91.6219 | 91.6832 | 91.6219 | 91.6738 | 255900.0 |
| 2008-07-24 | ER | Futures | 93.571 | 93.6 | 93.566 | 93.585 | 81698.0 |
| 2008-07-24 | EW | Futures | 810.1 | 811.0 | 782.1 | 785.8 | 32042.0 |
| 2008-07-24 | FCE | Futures | 2878.5 | 2901.0 | 2815.0 | 2838.8 | 131152.0 |
| 2008-07-24 | FDAX | Futures | 7386.5 | 7410.5 | 7193.3 | 7193.3 | 162095.0 |
| 2008-07-24 | FESX | Futures | 2002.6 | 2014.3 | 1958.0 | 1958.0 | 1348999.0 |
| 2008-07-24 | FEU3 | Futures | 94.122 | 94.137 | 94.122 | 94.132 | 2643.0 |
| 2008-07-24 | FGBL | Futures | 82.91 | 83.56 | 82.86 | 83.55 | 824155.0 |
| 2008-07-24 | FGBM | Futures | 89.38 | 89.99 | 89.32 | 89.99 | 606947.0 |
| 2008-07-24 | FGBS | Futures | 99.12 | 99.444 | 99.095 | 99.444 | 628867.0 |
| 2008-07-24 | FGBX | Futures | 73.9 | 74.39 | 73.59 | 74.05 | 3383.0 |
| 2008-07-24 | FTDX | Futures | 681.4 | 684.1 | 652.4 | 652.4 | 606.0 |
| 2008-07-24 | FTI | Futures | 310.59 | 313.21 | 303.0 | 303.92 | 29753.0 |
| 2008-07-24 | FTUK | Futures | 3544.2 | 3547.4 | 3446.7 | 3472.6 | 99435.0 |
| 2008-07-24 | G | Futures | 67.08 | 67.42 | 67.08 | 67.38 | 86436.0 |
| 2008-07-24 | GF | Futures | 306.189 | 307.003 | 304.63 | 304.765 | 253.0 |
| 2008-07-24 | GSCI | Futures | 1958.81 | 1978.91 | 1939.6 | 1963.93 | 793.0 |
| 2008-07-24 | HE | Futures | 157.322 | 159.67 | 156.773 | 159.321 | 4449.0 |
| 2008-07-24 | HG | Futures | 5.0577 | 5.1009 | 4.9546 | 4.9853 | 13257.0 |
| 2008-07-24 | HO | Futures | 4.1577 | 4.2149 | 4.1395 | 4.1758 | 28313.0 |
| 2008-07-24 | J1 | Futures | 0.011821 | 0.0119011 | 0.0118121 | 0.0118833 | 102325.0 |
| 2008-07-24 | J7 | Futures | 0.011616 | 0.011695 | 0.011614 | 0.011679 | 63.0 |
| 2008-07-24 | JB | Futures | 112.98 | 113.24 | 112.82 | 113.17 | 1815.0 |
| 2008-07-24 | KC | Futures | 410.23 | 411.9 | 406.44 | 410.23 | 7108.0 |
| 2008-07-24 | KE | Futures | 4307.39 | 4363.08 | 4296.78 | 4331.26 | 8211.0 |
| 2008-07-24 | L | Futures | 93.334 | 93.393 | 93.324 | 93.378 | 60236.0 |
| 2008-07-24 | LE | Futures | 195.418 | 196.345 | 194.307 | 196.252 | 6112.0 |
| 2008-07-24 | MP | Futures | 0.04777 | 0.04781 | 0.04761 | 0.04771 | 18028.0 |
| 2008-07-24 | N6 | Futures | 0.56946 | 0.57 | 0.56507 | 0.56692 | 3844.0 |
> showing 50 of 82 rows — these rows as CSV