PREVIEW / futures_daily / 2009-12-18
file: by_date/futures_daily/2009/2009-12-18.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-12-18 | ES | Futures | 1060.71 | 1068.95 | 1055.13 | 1064.1 | 1732758.0 |
| 2009-12-18 | NQ | Futures | 2018.92 | 2044.37 | 2017.79 | 2043.8 | 287861.0 |
| 2009-12-18 | YM | Futures | 9379.2 | 9452.2 | 9318.0 | 9381.9 | 108377.0 |
| 2009-12-18 | CL | Futures | 174.97 | 179.4 | 174.42 | 176.49 | 278790.0 |
| 2009-12-18 | GC | Futures | 1512.7 | 1539.0 | 1510.5 | 1529.9 | 171595.0 |
| 2009-12-18 | ZN | Futures | 95.209719 | 95.31047 | 94.756339 | 94.781527 | 526565.0 |
| 2009-12-18 | A6 | Futures | 0.71445 | 0.71803 | 0.7095 | 0.71673 | 78574.0 |
| 2009-12-18 | AD | Futures | 0.922 | 0.92881 | 0.92032 | 0.92624 | 74194.0 |
| 2009-12-18 | B | Futures | 67.24 | 68.75 | 66.84 | 67.75 | 148922.0 |
| 2009-12-18 | B6 | Futures | 1.6778 | 1.6869 | 1.6663 | 1.6733 | 108424.0 |
| 2009-12-18 | BFX | Futures | 2785.4 | 2825.1 | 2781.4 | 2785.3 | 155.0 |
| 2009-12-18 | BR | Futures | 0.22184 | 0.22264 | 0.22103 | 0.22248 | 13.0 |
| 2009-12-18 | BZ | Futures | 72.94 | 72.94 | 72.94 | 72.94 | 1.0 |
| 2009-12-18 | C | Futures | 2331.0 | 2331.0 | 2246.0 | 2249.0 | 10308.0 |
| 2009-12-18 | CB | Futures | 71.125 | 71.149 | 71.125 | 71.149 | 17.0 |
| 2009-12-18 | CC | Futures | 2968.0 | 2980.0 | 2791.0 | 2793.0 | 15115.0 |
| 2009-12-18 | CT | Futures | 61.72 | 61.94 | 60.74 | 61.37 | 6625.0 |
| 2009-12-18 | DC | Futures | 24.94 | 24.97 | 24.74 | 24.81 | 77.0 |
| 2009-12-18 | DX | Futures | 79.342 | 79.83 | 79.062 | 79.52 | 20928.0 |
| 2009-12-18 | E1 | Futures | 1.25992 | 1.27007 | 1.25689 | 1.26506 | 51780.0 |
| 2009-12-18 | E6 | Futures | 1.69836 | 1.70582 | 1.68794 | 1.69516 | 245094.0 |
| 2009-12-18 | E7 | Futures | 1.6867 | 1.6937 | 1.6762 | 1.6834 | 3290.0 |
| 2009-12-18 | EBM | Futures | 222.66 | 222.66 | 220.97 | 222.66 | 3759.0 |
| 2009-12-18 | ED | Futures | 94.3063 | 94.3205 | 94.2921 | 94.3063 | 137743.0 |
| 2009-12-18 | ER | Futures | 97.223 | 97.228 | 97.208 | 97.223 | 68409.0 |
| 2009-12-18 | EW | Futures | 692.4 | 697.8 | 685.5 | 694.6 | 31363.0 |
| 2009-12-18 | FBTP | Futures | 63.59 | 63.66 | 63.5 | 63.54 | 2967.0 |
| 2009-12-18 | FCE | Futures | 2507.7 | 2529.9 | 2471.8 | 2478.9 | 126598.0 |
| 2009-12-18 | FDAX | Futures | 6402.3 | 6454.7 | 6361.9 | 6379.4 | 151956.0 |
| 2009-12-18 | FESX | Futures | 1731.7 | 1747.3 | 1710.7 | 1716.7 | 1284757.0 |
| 2009-12-18 | FEU3 | Futures | 97.702 | 97.791 | 97.702 | 97.786 | 3475.0 |
| 2009-12-18 | FGBL | Futures | 95.16 | 95.35 | 95.07 | 95.26 | 357732.0 |
| 2009-12-18 | FGBM | Futures | 100.6 | 100.72 | 100.51 | 100.61 | 251946.0 |
| 2009-12-18 | FGBS | Futures | 105.518 | 105.533 | 105.445 | 105.494 | 280079.0 |
| 2009-12-18 | FGBX | Futures | 89.41 | 89.73 | 89.23 | 89.52 | 3469.0 |
| 2009-12-18 | FTDX | Futures | 723.0 | 724.3 | 710.2 | 720.3 | 1107.0 |
| 2009-12-18 | FTI | Futures | 266.59 | 267.9 | 264.11 | 264.88 | 34087.0 |
| 2009-12-18 | FTUK | Futures | 3475.1 | 3515.3 | 3442.6 | 3454.0 | 221964.0 |
| 2009-12-18 | G | Futures | 75.98 | 76.53 | 75.87 | 76.49 | 59406.0 |
| 2009-12-18 | GF | Futures | 254.288 | 257.611 | 254.288 | 256.933 | 3009.0 |
| 2009-12-18 | GSCI | Futures | 954.27 | 960.24 | 942.42 | 947.92 | 144.0 |
| 2009-12-18 | HE | Futures | 88.215 | 88.215 | 87.078 | 87.145 | 7549.0 |
| 2009-12-18 | HG | Futures | 4.3083 | 4.3511 | 4.2807 | 4.3297 | 17455.0 |
| 2009-12-18 | HO | Futures | 1.8597 | 1.8805 | 1.8429 | 1.8519 | 14698.0 |
| 2009-12-18 | HRC | Futures | 2561.7 | 2561.7 | 2561.7 | 2561.7 | 0.0 |
| 2009-12-18 | J1 | Futures | 0.0140102 | 0.01417 | 0.0138491 | 0.0139233 | 114834.0 |
| 2009-12-18 | J7 | Futures | 0.013853 | 0.013988 | 0.013677 | 0.013749 | 375.0 |
| 2009-12-18 | JB | Futures | 118.13 | 118.46 | 117.99 | 118.35 | 2067.0 |
| 2009-12-18 | KC | Futures | 381.46 | 384.06 | 373.0 | 378.08 | 8413.0 |
| 2009-12-18 | KE | Futures | 2331.31 | 2378.8 | 2309.83 | 2370.88 | 7474.0 |
> showing 50 of 89 rows — these rows as CSV