PREVIEW / futures_daily / 2009-10-22
file: by_date/futures_daily/2009/2009-10-22.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-10-22 | ES | Futures | 1038.32 | 1053.51 | 1032.29 | 1052.07 | 2184400.0 |
| 2009-10-22 | NQ | Futures | 1974.91 | 1993.82 | 1961.36 | 1989.58 | 344422.0 |
| 2009-10-22 | YM | Futures | 8977.9 | 9129.5 | 8952.5 | 9113.2 | 179443.0 |
| 2009-10-22 | CL | Futures | 198.58 | 199.7 | 195.69 | 198.94 | 295407.0 |
| 2009-10-22 | GC | Futures | 1464.7 | 1469.1 | 1454.3 | 1463.4 | 110645.0 |
| 2009-10-22 | ZN | Futures | 94.214518 | 94.276788 | 93.81599 | 94.027708 | 847646.0 |
| 2009-10-22 | A6 | Futures | 0.74502 | 0.74785 | 0.73863 | 0.74518 | 81735.0 |
| 2009-10-22 | AD | Futures | 0.94489 | 0.94657 | 0.93503 | 0.94055 | 76502.0 |
| 2009-10-22 | B | Futures | 74.08 | 74.56 | 73.04 | 74.17 | 127501.0 |
| 2009-10-22 | B6 | Futures | 1.7262 | 1.7307 | 1.7149 | 1.7291 | 120956.0 |
| 2009-10-22 | BFX | Futures | 2874.4 | 2898.3 | 2866.2 | 2898.3 | 116.0 |
| 2009-10-22 | BR | Futures | 0.22818 | 0.22873 | 0.22778 | 0.22873 | 205.0 |
| 2009-10-22 | BZ | Futures | 77.76 | 77.99 | 76.95 | 77.79 | 8.0 |
| 2009-10-22 | C | Futures | 2214.0 | 2246.0 | 2210.0 | 2244.0 | 4143.0 |
| 2009-10-22 | CB | Futures | 72.349 | 72.618 | 72.349 | 72.618 | 4.0 |
| 2009-10-22 | CC | Futures | 2959.0 | 2978.0 | 2919.0 | 2977.0 | 6209.0 |
| 2009-10-22 | CT | Futures | 58.68 | 59.21 | 58.05 | 59.16 | 8123.0 |
| 2009-10-22 | DC | Futures | 24.99 | 25.26 | 24.83 | 24.9 | 164.0 |
| 2009-10-22 | DX | Futures | 76.827 | 77.256 | 76.75 | 76.817 | 12554.0 |
| 2009-10-22 | E1 | Futures | 1.31231 | 1.31601 | 1.30531 | 1.31509 | 40759.0 |
| 2009-10-22 | E6 | Futures | 1.77819 | 1.78222 | 1.77084 | 1.78056 | 222875.0 |
| 2009-10-22 | E7 | Futures | 1.7609 | 1.765 | 1.754 | 1.7635 | 3735.0 |
| 2009-10-22 | ED | Futures | 94.1954 | 94.2096 | 94.1907 | 94.2001 | 127200.0 |
| 2009-10-22 | ER | Futures | 97.076 | 97.105 | 97.076 | 97.095 | 111969.0 |
| 2009-10-22 | EW | Futures | 678.3 | 690.0 | 672.0 | 688.0 | 48442.0 |
| 2009-10-22 | FBTP | Futures | 62.24 | 62.34 | 62.18 | 62.23 | 5351.0 |
| 2009-10-22 | FCE | Futures | 2517.4 | 2541.2 | 2495.9 | 2515.4 | 123106.0 |
| 2009-10-22 | FDAX | Futures | 6280.5 | 6336.0 | 6216.8 | 6282.7 | 185302.0 |
| 2009-10-22 | FESX | Futures | 1728.0 | 1744.7 | 1711.9 | 1728.6 | 1191747.0 |
| 2009-10-22 | FEU3 | Futures | 97.663 | 97.668 | 97.658 | 97.668 | 1078.0 |
| 2009-10-22 | FGBL | Futures | 93.37 | 93.58 | 93.25 | 93.39 | 745111.0 |
| 2009-10-22 | FGBM | Futures | 98.86 | 99.02 | 98.79 | 98.92 | 432016.0 |
| 2009-10-22 | FGBS | Futures | 104.493 | 104.571 | 104.469 | 104.542 | 387394.0 |
| 2009-10-22 | FGBX | Futures | 86.04 | 86.5 | 85.89 | 86.21 | 2506.0 |
| 2009-10-22 | FTDX | Futures | 681.2 | 682.5 | 673.2 | 678.1 | 765.0 |
| 2009-10-22 | FTI | Futures | 261.97 | 264.67 | 259.84 | 261.72 | 36600.0 |
| 2009-10-22 | FTUK | Futures | 3422.8 | 3465.9 | 3406.9 | 3438.1 | 112079.0 |
| 2009-10-22 | G | Futures | 76.33 | 76.59 | 76.09 | 76.35 | 133901.0 |
| 2009-10-22 | GF | Futures | 264.671 | 265.496 | 263.639 | 265.221 | 2057.0 |
| 2009-10-22 | GSCI | Futures | 1035.02 | 1035.02 | 1017.7 | 1028.33 | 382.0 |
| 2009-10-22 | HE | Futures | 81.822 | 82.394 | 81.213 | 81.899 | 7689.0 |
| 2009-10-22 | HG | Futures | 4.198 | 4.2238 | 4.1485 | 4.1778 | 22900.0 |
| 2009-10-22 | HO | Futures | 2.0608 | 2.072 | 2.0279 | 2.0578 | 36699.0 |
| 2009-10-22 | HRC | Futures | 2763.8 | 2763.8 | 2763.8 | 2763.8 | 0.0 |
| 2009-10-22 | J1 | Futures | 0.0138061 | 0.0138375 | 0.0136944 | 0.0137584 | 95106.0 |
| 2009-10-22 | J7 | Futures | 0.013585 | 0.013637 | 0.013518 | 0.013579 | 217.0 |
| 2009-10-22 | JB | Futures | 116.91 | 116.95 | 116.65 | 116.8 | 3153.0 |
| 2009-10-22 | KC | Futures | 378.93 | 379.59 | 370.35 | 379.19 | 11113.0 |
| 2009-10-22 | KE | Futures | 2525.44 | 2587.09 | 2505.66 | 2573.13 | 11358.0 |
| 2009-10-22 | L | Futures | 97.701 | 97.74 | 97.681 | 97.71 | 46415.0 |
> showing 50 of 89 rows — these rows as CSV