PREVIEW / futures_daily / 2009-02-23
file: by_date/futures_daily/2009/2009-02-23.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-23 | ES | Futures | 727.1 | 742.68 | 698.54 | 703.49 | 2743651.0 |
| 2009-02-23 | NQ | Futures | 1313.08 | 1337.11 | 1258.29 | 1269.75 | 377881.0 |
| 2009-02-23 | YM | Futures | 6559.5 | 6675.3 | 6309.3 | 6336.0 | 235000.0 |
| 2009-02-23 | CL | Futures | 111.85 | 116.8 | 106.61 | 108.22 | 285905.0 |
| 2009-02-23 | GC | Futures | 1379.8 | 1387.2 | 1354.7 | 1380.8 | 111088.0 |
| 2009-02-23 | ZN | Futures | 94.164491 | 94.403548 | 93.602707 | 94.224255 | 710141.0 |
| 2009-02-23 | A6 | Futures | 0.51036 | 0.51861 | 0.50695 | 0.50846 | 28844.0 |
| 2009-02-23 | AD | Futures | 0.78464 | 0.79525 | 0.78218 | 0.78464 | 30563.0 |
| 2009-02-23 | B | Futures | 42.0 | 43.8 | 40.79 | 41.46 | 52663.0 |
| 2009-02-23 | B6 | Futures | 1.4965 | 1.5232 | 1.4922 | 1.5048 | 59437.0 |
| 2009-02-23 | BFX | Futures | 1923.4 | 1937.9 | 1891.7 | 1902.2 | 135.0 |
| 2009-02-23 | BZ | Futures | 43.17 | 43.25 | 43.17 | 43.25 | 2.0 |
| 2009-02-23 | C | Futures | 1766.0 | 1766.0 | 1706.0 | 1708.0 | 4482.0 |
| 2009-02-23 | CB | Futures | 74.329 | 75.232 | 74.329 | 74.329 | 4.0 |
| 2009-02-23 | CC | Futures | 2138.0 | 2147.0 | 2048.0 | 2073.0 | 10748.0 |
| 2009-02-23 | CT | Futures | 41.88 | 42.69 | 41.23 | 41.42 | 6479.0 |
| 2009-02-23 | DC | Futures | 27.91 | 27.91 | 27.48 | 27.52 | 168.0 |
| 2009-02-23 | DX | Futures | 89.093 | 90.825 | 88.979 | 90.659 | 6028.0 |
| 2009-02-23 | E1 | Futures | 1.14746 | 1.16009 | 1.13656 | 1.13935 | 35021.0 |
| 2009-02-23 | E6 | Futures | 1.51705 | 1.53777 | 1.5019 | 1.50486 | 209751.0 |
| 2009-02-23 | E7 | Futures | 1.4997 | 1.5199 | 1.4848 | 1.4876 | 2138.0 |
| 2009-02-23 | EBM | Futures | 215.9 | 217.82 | 215.52 | 216.28 | 2217.0 |
| 2009-02-23 | ED | Futures | 93.0389 | 93.0577 | 93.013 | 93.0413 | 136427.0 |
| 2009-02-23 | ER | Futures | 96.38 | 96.385 | 96.356 | 96.38 | 56372.0 |
| 2009-02-23 | EW | Futures | 453.3 | 463.4 | 435.9 | 440.0 | 39798.0 |
| 2009-02-23 | FCE | Futures | 1735.9 | 1757.7 | 1665.5 | 1704.1 | 135210.0 |
| 2009-02-23 | FDAX | Futures | 4426.2 | 4494.4 | 4211.1 | 4308.8 | 190910.0 |
| 2009-02-23 | FESX | Futures | 1168.0 | 1187.0 | 1118.0 | 1148.5 | 1458240.0 |
| 2009-02-23 | FEU3 | Futures | 96.943 | 96.948 | 96.933 | 96.948 | 1327.0 |
| 2009-02-23 | FGBL | Futures | 93.42 | 93.84 | 93.22 | 93.68 | 516702.0 |
| 2009-02-23 | FGBM | Futures | 98.19 | 98.35 | 98.01 | 98.27 | 252933.0 |
| 2009-02-23 | FGBS | Futures | 103.81 | 103.858 | 103.719 | 103.834 | 273728.0 |
| 2009-02-23 | FGBX | Futures | 84.95 | 85.51 | 84.32 | 85.5 | 1302.0 |
| 2009-02-23 | FTDX | Futures | 415.2 | 418.8 | 384.8 | 396.5 | 1036.0 |
| 2009-02-23 | FTI | Futures | 188.31 | 190.35 | 181.35 | 182.53 | 37990.0 |
| 2009-02-23 | FTUK | Futures | 2576.8 | 2586.6 | 2462.0 | 2519.4 | 114129.0 |
| 2009-02-23 | G | Futures | 76.48 | 76.77 | 76.35 | 76.63 | 99368.0 |
| 2009-02-23 | GF | Futures | 249.966 | 250.527 | 245.968 | 248.984 | 522.0 |
| 2009-02-23 | GSCI | Futures | 691.23 | 706.32 | 673.95 | 677.01 | 50.0 |
| 2009-02-23 | HE | Futures | 112.361 | 113.376 | 111.636 | 112.554 | 3832.0 |
| 2009-02-23 | HG | Futures | 2.0428 | 2.1119 | 2.0196 | 2.0442 | 10086.0 |
| 2009-02-23 | HO | Futures | 1.3389 | 1.368 | 1.2887 | 1.3026 | 6896.0 |
| 2009-02-23 | HRC | Futures | 2982.9 | 2982.9 | 2982.9 | 2982.9 | 0.0 |
| 2009-02-23 | J1 | Futures | 0.0135142 | 0.0136216 | 0.0133033 | 0.0133551 | 91755.0 |
| 2009-02-23 | J7 | Futures | 0.013353 | 0.013455 | 0.013143 | 0.013194 | 276.0 |
| 2009-02-23 | JB | Futures | 116.91 | 117.14 | 116.76 | 116.77 | 1787.0 |
| 2009-02-23 | KC | Futures | 313.5 | 321.66 | 313.5 | 318.29 | 5913.0 |
| 2009-02-23 | KE | Futures | 2779.31 | 2819.98 | 2741.1 | 2744.8 | 5986.0 |
| 2009-02-23 | L | Futures | 96.541 | 96.571 | 96.414 | 96.463 | 56822.0 |
| 2009-02-23 | LBS | Futures | 821.8 | 822.9 | 802.7 | 803.8 | 95.0 |
> showing 50 of 86 rows — these rows as CSV