PREVIEW / futures_daily / 2009-02-04
file: by_date/futures_daily/2009/2009-02-04.parquet size: 8 KB rows: 86
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 |
|---|---|---|---|---|---|---|---|
| 2009-02-04 | ES | Futures | 785.41 | 802.17 | 779.98 | 783.52 | 2212942.0 |
| 2009-02-04 | NQ | Futures | 1351.09 | 1389.38 | 1345.78 | 1357.24 | 310950.0 |
| 2009-02-04 | YM | Futures | 7106.2 | 7232.6 | 7019.0 | 7056.4 | 197927.0 |
| 2009-02-04 | CL | Futures | 135.97 | 139.26 | 132.02 | 133.95 | 254203.0 |
| 2009-02-04 | GC | Futures | 1250.5 | 1264.1 | 1243.7 | 1252.0 | 75619.0 |
| 2009-02-04 | ZN | Futures | 93.471226 | 93.746142 | 92.969207 | 93.411462 | 627179.0 |
| 2009-02-04 | A6 | Futures | 0.51433 | 0.51631 | 0.50243 | 0.5098 | 37093.0 |
| 2009-02-04 | AD | Futures | 0.79711 | 0.8035 | 0.78965 | 0.79741 | 32323.0 |
| 2009-02-04 | B | Futures | 46.12 | 47.08 | 45.56 | 46.21 | 84928.0 |
| 2009-02-04 | B6 | Futures | 1.499 | 1.5139 | 1.4872 | 1.5015 | 77961.0 |
| 2009-02-04 | BFX | Futures | 2072.6 | 2111.4 | 2072.6 | 2097.2 | 288.0 |
| 2009-02-04 | BZ | Futures | 47.49 | 48.3 | 46.88 | 47.5 | 59.0 |
| 2009-02-04 | C | Futures | 1947.0 | 1957.0 | 1933.0 | 1952.0 | 8532.0 |
| 2009-02-04 | CB | Futures | 75.35 | 75.35 | 75.35 | 75.35 | 1.0 |
| 2009-02-04 | CC | Futures | 2403.0 | 2422.0 | 2376.0 | 2408.0 | 5683.0 |
| 2009-02-04 | CT | Futures | 47.99 | 48.77 | 47.72 | 48.35 | 6611.0 |
| 2009-02-04 | DC | Futures | 26.46 | 26.83 | 26.19 | 26.49 | 196.0 |
| 2009-02-04 | DX | Futures | 88.803 | 89.523 | 88.269 | 89.254 | 3665.0 |
| 2009-02-04 | E1 | Futures | 1.16208 | 1.16567 | 1.14294 | 1.14813 | 37658.0 |
| 2009-02-04 | E6 | Futures | 1.54061 | 1.54653 | 1.51587 | 1.52096 | 197629.0 |
| 2009-02-04 | E7 | Futures | 1.5225 | 1.5288 | 1.4988 | 1.5036 | 2778.0 |
| 2009-02-04 | EBM | Futures | 223.95 | 228.94 | 223.95 | 224.34 | 2311.0 |
| 2009-02-04 | ED | Futures | 93.0154 | 93.0483 | 92.973 | 93.0106 | 188798.0 |
| 2009-02-04 | ER | Futures | 96.238 | 96.307 | 96.223 | 96.292 | 109350.0 |
| 2009-02-04 | EW | Futures | 488.5 | 501.2 | 486.8 | 492.1 | 28288.0 |
| 2009-02-04 | FCE | Futures | 1851.8 | 1916.7 | 1848.0 | 1896.3 | 140357.0 |
| 2009-02-04 | FDAX | Futures | 4805.6 | 4972.1 | 4781.0 | 4906.6 | 150189.0 |
| 2009-02-04 | FESX | Futures | 1296.7 | 1338.1 | 1290.4 | 1320.3 | 1247571.0 |
| 2009-02-04 | FEU3 | Futures | 96.815 | 96.859 | 96.81 | 96.859 | 1045.0 |
| 2009-02-04 | FGBL | Futures | 91.12 | 91.26 | 90.8 | 91.07 | 684471.0 |
| 2009-02-04 | FGBM | Futures | 97.04 | 97.18 | 96.86 | 97.11 | 347832.0 |
| 2009-02-04 | FGBS | Futures | 103.498 | 103.556 | 103.402 | 103.512 | 419470.0 |
| 2009-02-04 | FGBX | Futures | 83.64 | 83.64 | 82.83 | 83.2 | 1567.0 |
| 2009-02-04 | FTDX | Futures | 429.6 | 435.8 | 425.1 | 433.1 | 206.0 |
| 2009-02-04 | FTI | Futures | 202.86 | 207.9 | 201.73 | 205.16 | 30057.0 |
| 2009-02-04 | FTUK | Futures | 2722.0 | 2779.7 | 2705.3 | 2750.5 | 119817.0 |
| 2009-02-04 | G | Futures | 73.06 | 73.42 | 72.9 | 73.13 | 77513.0 |
| 2009-02-04 | GF | Futures | 262.59 | 263.502 | 261.889 | 262.099 | 452.0 |
| 2009-02-04 | GSCI | Futures | 776.3 | 785.21 | 766.45 | 771.61 | 234.0 |
| 2009-02-04 | HE | Futures | 120.673 | 121.06 | 116.759 | 117.677 | 6049.0 |
| 2009-02-04 | HG | Futures | 2.1562 | 2.209 | 2.1154 | 2.1548 | 12934.0 |
| 2009-02-04 | HO | Futures | 1.4704 | 1.5139 | 1.4607 | 1.478 | 26158.0 |
| 2009-02-04 | HRC | Futures | 3041.9 | 3041.9 | 3041.9 | 3041.9 | 0.0 |
| 2009-02-04 | J1 | Futures | 0.0141407 | 0.0142329 | 0.0140788 | 0.0141104 | 93304.0 |
| 2009-02-04 | J7 | Futures | 0.013983 | 0.014058 | 0.01391 | 0.013941 | 97.0 |
| 2009-02-04 | JB | Futures | 115.91 | 116.09 | 115.73 | 115.9 | 7.0 |
| 2009-02-04 | KC | Futures | 340.53 | 340.82 | 329.53 | 331.25 | 13296.0 |
| 2009-02-04 | KE | Futures | 2909.21 | 2944.19 | 2848.01 | 2848.01 | 8533.0 |
| 2009-02-04 | L | Futures | 96.807 | 96.817 | 96.718 | 96.782 | 58253.0 |
| 2009-02-04 | LBS | Futures | 917.7 | 974.3 | 917.7 | 974.3 | 450.0 |
> showing 50 of 86 rows — these rows as CSV