PREVIEW / futures_daily / 2008-07-18
file: by_date/futures_daily/2008/2008-07-18.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-18 | ES | Futures | 1156.43 | 1168.22 | 1147.87 | 1165.91 | 1921007.0 |
| 2008-07-18 | NQ | Futures | 2038.57 | 2056.37 | 2023.83 | 2034.4 | 430280.0 |
| 2008-07-18 | YM | Futures | 10103.2 | 10222.2 | 10039.2 | 10214.2 | 171112.0 |
| 2008-07-18 | CL | Futures | 565.37 | 576.7 | 559.72 | 561.98 | 179837.0 |
| 2008-07-18 | GC | Futures | 1357.2 | 1366.6 | 1345.6 | 1356.7 | 124015.0 |
| 2008-07-18 | ZN | Futures | 84.124259 | 84.285351 | 83.537426 | 83.663998 | 1086041.0 |
| 2008-07-18 | A6 | Futures | 0.74605 | 0.74659 | 0.74358 | 0.74404 | 25747.0 |
| 2008-07-18 | AD | Futures | 0.97659 | 0.97934 | 0.97364 | 0.97531 | 29753.0 |
| 2008-07-18 | B | Futures | 157.69 | 160.21 | 155.38 | 156.01 | 102937.0 |
| 2008-07-18 | B6 | Futures | 2.0494 | 2.0502 | 2.0408 | 2.0485 | 71649.0 |
| 2008-07-18 | BFX | Futures | 3407.4 | 3490.2 | 3354.5 | 3484.9 | 740.0 |
| 2008-07-18 | BZ | Futures | 156.85 | 157.19 | 153.63 | 153.71 | 573.0 |
| 2008-07-18 | C | Futures | 1332.0 | 1332.0 | 1278.0 | 1280.0 | 13176.0 |
| 2008-07-18 | CB | Futures | 94.09 | 94.09 | 93.477 | 93.937 | 30.0 |
| 2008-07-18 | CC | Futures | 2601.0 | 2601.0 | 2505.0 | 2510.0 | 10757.0 |
| 2008-07-18 | CT | Futures | 73.41 | 74.41 | 72.87 | 73.54 | 192.0 |
| 2008-07-18 | DC | Futures | 53.13 | 53.21 | 52.2 | 52.87 | 118.0 |
| 2008-07-18 | DX | Futures | 76.606 | 76.781 | 76.437 | 76.654 | 1454.0 |
| 2008-07-18 | E1 | Futures | 1.30737 | 1.3107 | 1.30071 | 1.30457 | 50149.0 |
| 2008-07-18 | E6 | Futures | 1.85107 | 1.85459 | 1.8451 | 1.84932 | 150947.0 |
| 2008-07-18 | E7 | Futures | 1.8327 | 1.8368 | 1.8274 | 1.8314 | 1880.0 |
| 2008-07-18 | ED | Futures | 91.7021 | 91.7068 | 91.6219 | 91.6407 | 234790.0 |
| 2008-07-18 | ER | Futures | 93.595 | 93.61 | 93.531 | 93.561 | 100799.0 |
| 2008-07-18 | EW | Futures | 787.2 | 798.3 | 783.7 | 790.3 | 24685.0 |
| 2008-07-18 | FCE | Futures | 2757.4 | 2810.5 | 2728.7 | 2810.1 | 152339.0 |
| 2008-07-18 | FDAX | Futures | 7065.0 | 7211.7 | 7034.2 | 7211.7 | 189512.0 |
| 2008-07-18 | FESX | Futures | 1922.2 | 1965.6 | 1908.1 | 1965.6 | 1867148.0 |
| 2008-07-18 | FEU3 | Futures | 94.142 | 94.157 | 94.102 | 94.107 | 1868.0 |
| 2008-07-18 | FGBL | Futures | 84.15 | 84.23 | 83.24 | 83.43 | 1079246.0 |
| 2008-07-18 | FGBM | Futures | 90.11 | 90.16 | 89.41 | 89.41 | 699347.0 |
| 2008-07-18 | FGBS | Futures | 99.41 | 99.449 | 99.076 | 99.076 | 639836.0 |
| 2008-07-18 | FGBX | Futures | 75.45 | 75.45 | 73.64 | 73.64 | 1801.0 |
| 2008-07-18 | FTDX | Futures | 656.9 | 666.0 | 650.6 | 660.6 | 720.0 |
| 2008-07-18 | FTI | Futures | 301.07 | 304.46 | 295.79 | 304.19 | 43592.0 |
| 2008-07-18 | FTUK | Futures | 3402.0 | 3490.4 | 3382.6 | 3479.1 | 158265.0 |
| 2008-07-18 | G | Futures | 67.45 | 67.51 | 66.92 | 67.01 | 112045.0 |
| 2008-07-18 | GF | Futures | 302.257 | 309.443 | 302.121 | 308.833 | 495.0 |
| 2008-07-18 | GSCI | Futures | 2059.31 | 2076.59 | 2032.93 | 2036.9 | 117.0 |
| 2008-07-18 | HE | Futures | 153.975 | 155.973 | 153.475 | 153.675 | 4102.0 |
| 2008-07-18 | HG | Futures | 5.1497 | 5.1567 | 5.0877 | 5.1135 | 11159.0 |
| 2008-07-18 | HO | Futures | 4.3957 | 4.4533 | 4.3217 | 4.3243 | 16942.0 |
| 2008-07-18 | J1 | Futures | 0.0120169 | 0.0120423 | 0.0119265 | 0.0119367 | 114733.0 |
| 2008-07-18 | J7 | Futures | 0.011801 | 0.011833 | 0.011723 | 0.011731 | 62.0 |
| 2008-07-18 | JB | Futures | 113.88 | 114.08 | 113.57 | 114.0 | 2221.0 |
| 2008-07-18 | KC | Futures | 417.06 | 421.0 | 414.48 | 417.97 | 10155.0 |
| 2008-07-18 | KE | Futures | 4445.31 | 4514.27 | 4418.78 | 4443.98 | 7600.0 |
| 2008-07-18 | L | Futures | 93.363 | 93.368 | 93.319 | 93.344 | 41585.0 |
| 2008-07-18 | LE | Futures | 194.955 | 196.252 | 194.4 | 194.678 | 4119.0 |
| 2008-07-18 | MP | Futures | 0.0467 | 0.047 | 0.04669 | 0.04694 | 15345.0 |
| 2008-07-18 | N6 | Futures | 0.58334 | 0.58566 | 0.57872 | 0.5818 | 1056.0 |
> showing 50 of 82 rows — these rows as CSV