PREVIEW / futures_daily / 2009-11-24
file: by_date/futures_daily/2009/2009-11-24.parquet size: 9 KB rows: 89
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-11-24 | ES | Futures | 1064.36 | 1067.74 | 1056.16 | 1063.88 | 1584089.0 |
| 2009-11-24 | NQ | Futures | 2020.91 | 2024.86 | 2004.54 | 2016.67 | 220400.0 |
| 2009-11-24 | YM | Futures | 9461.8 | 9479.0 | 9378.3 | 9446.3 | 124573.0 |
| 2009-11-24 | CL | Futures | 188.48 | 189.33 | 183.98 | 185.0 | 413033.0 |
| 2009-11-24 | GC | Futures | 1609.7 | 1619.8 | 1600.4 | 1611.6 | 254522.0 |
| 2009-11-24 | ZN | Futures | 95.385194 | 95.845992 | 95.335378 | 95.721452 | 1090177.0 |
| 2009-11-24 | A6 | Futures | 0.74542 | 0.74663 | 0.73653 | 0.74227 | 87136.0 |
| 2009-11-24 | AD | Futures | 0.93335 | 0.93365 | 0.92626 | 0.93227 | 73310.0 |
| 2009-11-24 | B | Futures | 71.96 | 72.31 | 70.61 | 71.03 | 173886.0 |
| 2009-11-24 | B6 | Futures | 1.7285 | 1.729 | 1.7163 | 1.7261 | 101546.0 |
| 2009-11-24 | BFX | Futures | 2827.7 | 2855.8 | 2827.7 | 2832.8 | 49.0 |
| 2009-11-24 | BR | Futures | 0.22881 | 0.22881 | 0.22881 | 0.22881 | 688.0 |
| 2009-11-24 | BZ | Futures | 75.44 | 75.62 | 75.44 | 75.62 | 2.0 |
| 2009-11-24 | C | Futures | 2226.0 | 2231.0 | 2200.0 | 2204.0 | 2622.0 |
| 2009-11-24 | CB | Futures | 80.686 | 80.686 | 80.686 | 80.686 | 5.0 |
| 2009-11-24 | CC | Futures | 2823.0 | 2827.0 | 2779.0 | 2790.0 | 4967.0 |
| 2009-11-24 | CT | Futures | 60.74 | 61.59 | 60.64 | 61.57 | 8126.0 |
| 2009-11-24 | DC | Futures | 25.1 | 25.19 | 25.01 | 25.19 | 41.0 |
| 2009-11-24 | DX | Futures | 76.868 | 77.108 | 76.633 | 76.699 | 13301.0 |
| 2009-11-24 | E1 | Futures | 1.30782 | 1.31126 | 1.30109 | 1.3102 | 56326.0 |
| 2009-11-24 | E6 | Futures | 1.77286 | 1.77629 | 1.76421 | 1.77475 | 249545.0 |
| 2009-11-24 | E7 | Futures | 1.7556 | 1.7593 | 1.7474 | 1.7577 | 2715.0 |
| 2009-11-24 | ED | Futures | 94.2805 | 94.2852 | 94.2758 | 94.2829 | 112918.0 |
| 2009-11-24 | ER | Futures | 97.154 | 97.169 | 97.13 | 97.154 | 90305.0 |
| 2009-11-24 | EW | Futures | 672.0 | 673.9 | 665.0 | 669.2 | 24880.0 |
| 2009-11-24 | FBTP | Futures | 63.02 | 63.02 | 62.84 | 62.99 | 2642.0 |
| 2009-11-24 | FCE | Futures | 2504.2 | 2532.1 | 2499.2 | 2508.5 | 106927.0 |
| 2009-11-24 | FDAX | Futures | 6265.8 | 6331.1 | 6253.3 | 6284.3 | 133913.0 |
| 2009-11-24 | FESX | Futures | 1712.5 | 1733.4 | 1709.5 | 1719.6 | 1057635.0 |
| 2009-11-24 | FEU3 | Futures | 97.732 | 97.732 | 97.727 | 97.727 | 246.0 |
| 2009-11-24 | FGBL | Futures | 94.54 | 94.65 | 94.38 | 94.57 | 621747.0 |
| 2009-11-24 | FGBM | Futures | 99.64 | 99.73 | 99.58 | 99.71 | 401439.0 |
| 2009-11-24 | FGBS | Futures | 104.977 | 105.011 | 104.939 | 104.992 | 480876.0 |
| 2009-11-24 | FGBX | Futures | 88.24 | 88.4 | 87.87 | 88.08 | 4647.0 |
| 2009-11-24 | FTDX | Futures | 686.5 | 699.4 | 686.5 | 694.5 | 452.0 |
| 2009-11-24 | FTI | Futures | 257.01 | 260.44 | 256.32 | 257.87 | 32026.0 |
| 2009-11-24 | FTUK | Futures | 3523.7 | 3566.1 | 3518.7 | 3534.3 | 91664.0 |
| 2009-11-24 | G | Futures | 76.91 | 76.98 | 76.83 | 76.91 | 61907.0 |
| 2009-11-24 | GF | Futures | 252.254 | 253.61 | 251.237 | 252.864 | 983.0 |
| 2009-11-24 | GSCI | Futures | 985.16 | 985.16 | 967.08 | 973.46 | 575.0 |
| 2009-11-24 | HE | Futures | 87.379 | 88.817 | 87.178 | 88.316 | 8432.0 |
| 2009-11-24 | HG | Futures | 4.3545 | 4.3759 | 4.3028 | 4.3366 | 17365.0 |
| 2009-11-24 | HO | Futures | 1.927 | 1.9363 | 1.8897 | 1.9027 | 6827.0 |
| 2009-11-24 | HRC | Futures | 2637.0 | 2637.0 | 2637.0 | 2637.0 | 0.0 |
| 2009-11-24 | J1 | Futures | 0.0141063 | 0.014213 | 0.0141 | 0.0141816 | 89844.0 |
| 2009-11-24 | J7 | Futures | 0.013925 | 0.014026 | 0.01392 | 0.013997 | 25.0 |
| 2009-11-24 | JB | Futures | 117.38 | 117.75 | 117.37 | 117.75 | 2107.0 |
| 2009-11-24 | KC | Futures | 357.12 | 359.73 | 353.48 | 354.39 | 6879.0 |
| 2009-11-24 | KE | Futures | 2577.79 | 2590.22 | 2460.2 | 2468.12 | 14063.0 |
| 2009-11-24 | L | Futures | 97.779 | 97.789 | 97.71 | 97.73 | 118220.0 |
> showing 50 of 89 rows — these rows as CSV