PREVIEW / futures_daily / 2008-07-04
file: by_date/futures_daily/2008/2008-07-04.parquet size: 7 KB rows: 57
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-04 | ES | Futures | 1170.54 | 1174.01 | 1162.21 | 1170.07 | 2324603.0 |
| 2008-07-04 | NQ | Futures | 2026.89 | 2034.12 | 2017.72 | 2026.89 | 391725.0 |
| 2008-07-04 | YM | Futures | 10026.8 | 10038.3 | 9977.9 | 10025.0 | 219349.0 |
| 2008-07-04 | CL | Futures | 631.87 | 633.52 | 624.91 | 631.82 | 231565.0 |
| 2008-07-04 | GC | Futures | 1325.4 | 1328.8 | 1318.1 | 1322.1 | 121786.0 |
| 2008-07-04 | ZN | Futures | 84.170285 | 84.65356 | 84.135766 | 84.216312 | 879881.0 |
| 2008-07-04 | A6 | Futures | 0.73461 | 0.73778 | 0.734 | 0.734 | 36029.0 |
| 2008-07-04 | AD | Futures | 0.96323 | 0.96775 | 0.96087 | 0.96087 | 7121.0 |
| 2008-07-04 | B | Futures | 175.94 | 176.34 | 173.63 | 173.89 | 16808.0 |
| 2008-07-04 | B6 | Futures | 2.0313 | 2.033 | 2.0263 | 2.0296 | 18419.0 |
| 2008-07-04 | BFX | Futures | 3478.3 | 3484.3 | 3418.9 | 3430.3 | 175.0 |
| 2008-07-04 | BZ | Futures | 171.79 | 173.08 | 171.73 | 173.08 | 11.0 |
| 2008-07-04 | C | Futures | 1466.0 | 1470.0 | 1426.0 | 1428.0 | 1141.0 |
| 2008-07-04 | DX | Futures | 77.194 | 77.374 | 77.188 | 77.252 | 474.0 |
| 2008-07-04 | E1 | Futures | 1.29911 | 1.30324 | 1.29724 | 1.29884 | 12597.0 |
| 2008-07-04 | E6 | Futures | 1.83129 | 1.83468 | 1.82614 | 1.83094 | 45021.0 |
| 2008-07-04 | E7 | Futures | 1.8137 | 1.8167 | 1.8029 | 1.8132 | 744.0 |
| 2008-07-04 | ED | Futures | 91.6502 | 91.6549 | 91.6313 | 91.6455 | 212746.0 |
| 2008-07-04 | ER | Futures | 93.571 | 93.595 | 93.566 | 93.571 | 70886.0 |
| 2008-07-04 | EW | Futures | 779.7 | 782.1 | 775.1 | 779.3 | 33870.0 |
| 2008-07-04 | FCE | Futures | 2856.7 | 2879.1 | 2807.4 | 2813.0 | 63256.0 |
| 2008-07-04 | FDAX | Futures | 7179.8 | 7214.0 | 7068.9 | 7086.9 | 80114.0 |
| 2008-07-04 | FESX | Futures | 1966.8 | 1982.6 | 1931.0 | 1936.2 | 690785.0 |
| 2008-07-04 | FEU3 | Futures | 94.122 | 94.132 | 94.117 | 94.117 | 1207.0 |
| 2008-07-04 | FGBL | Futures | 83.68 | 84.53 | 83.47 | 83.85 | 380057.0 |
| 2008-07-04 | FGBM | Futures | 89.81 | 90.11 | 89.78 | 89.99 | 307088.0 |
| 2008-07-04 | FGBS | Futures | 99.294 | 99.381 | 99.27 | 99.318 | 319939.0 |
| 2008-07-04 | FGBX | Futures | 74.39 | 74.79 | 73.71 | 74.46 | 1735.0 |
| 2008-07-04 | FTDX | Futures | 677.8 | 679.6 | 672.4 | 673.3 | 333.0 |
| 2008-07-04 | FTI | Futures | 307.49 | 310.43 | 303.91 | 304.06 | 16376.0 |
| 2008-07-04 | FTUK | Futures | 3557.2 | 3559.4 | 3501.5 | 3516.0 | 42692.0 |
| 2008-07-04 | G | Futures | 66.95 | 67.43 | 66.88 | 67.16 | 34312.0 |
| 2008-07-04 | HG | Futures | 5.4912 | 5.5079 | 5.3769 | 5.5037 | 16348.0 |
| 2008-07-04 | HO | Futures | 4.8093 | 4.8172 | 4.744 | 4.8128 | 9656.0 |
| 2008-07-04 | J1 | Futures | 0.0119634 | 0.01198 | 0.0119469 | 0.0119685 | 154532.0 |
| 2008-07-04 | JB | Futures | 112.73 | 113.07 | 112.65 | 112.92 | 816.0 |
| 2008-07-04 | L | Futures | 93.289 | 93.299 | 93.274 | 93.294 | 16045.0 |
| 2008-07-04 | MP | Futures | 0.0461 | 0.04618 | 0.04601 | 0.04601 | 13900.0 |
| 2008-07-04 | N6 | Futures | 0.57633 | 0.57957 | 0.57502 | 0.57571 | 2116.0 |
| 2008-07-04 | NG | Futures | 953.392 | 958.036 | 951.773 | 955.432 | 80710.0 |
| 2008-07-04 | NIY | Futures | 10429.0 | 10480.1 | 10346.4 | 10480.1 | 2752.0 |
| 2008-07-04 | NKD | Futures | 13200.5 | 13225.2 | 13071.9 | 13225.2 | 1697.0 |
| 2008-07-04 | NOK | Futures | 0.191511 | 0.191511 | 0.191511 | 0.191511 | 0.0 |
| 2008-07-04 | PA | Futures | 546.74 | 549.1 | 536.08 | 547.86 | 204.0 |
| 2008-07-04 | PJY | Futures | 171.53 | 171.53 | 171.53 | 171.53 | 0.0 |
| 2008-07-04 | PL | Futures | 2399.1 | 2407.4 | 2373.2 | 2394.9 | 364.0 |
| 2008-07-04 | PSI | Futures | 6834.4 | 6834.4 | 6681.9 | 6805.3 | 35.0 |
| 2008-07-04 | QG | Futures | 978.732 | 986.668 | 976.207 | 979.598 | 3831.0 |
| 2008-07-04 | RB | Futures | 1.8917 | 1.8918 | 1.8718 | 1.8881 | 15076.0 |
| 2008-07-04 | RP | Futures | 0.90209 | 0.90306 | 0.90021 | 0.90203 | 2.0 |
> showing 50 of 57 rows — these rows as CSV