PREVIEW / futures_daily / 2009-11-16
file: by_date/futures_daily/2009/2009-11-16.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-16 | ES | Futures | 1053.27 | 1072.8 | 1052.31 | 1067.02 | 1992105.0 |
| 2009-11-16 | NQ | Futures | 2020.06 | 2047.44 | 2017.52 | 2035.87 | 294545.0 |
| 2009-11-16 | YM | Futures | 9299.3 | 9445.4 | 9296.6 | 9412.8 | 130932.0 |
| 2009-11-16 | CL | Futures | 187.87 | 194.78 | 187.48 | 193.54 | 158557.0 |
| 2009-11-16 | GC | Futures | 1547.8 | 1581.8 | 1547.6 | 1574.9 | 188594.0 |
| 2009-11-16 | ZN | Futures | 94.837218 | 95.422556 | 94.787402 | 95.397648 | 849933.0 |
| 2009-11-16 | A6 | Futures | 0.75286 | 0.75819 | 0.75084 | 0.75593 | 77509.0 |
| 2009-11-16 | AD | Futures | 0.93631 | 0.94568 | 0.93592 | 0.94203 | 69187.0 |
| 2009-11-16 | B | Futures | 71.33 | 73.64 | 71.13 | 73.16 | 135428.0 |
| 2009-11-16 | B6 | Futures | 1.7379 | 1.7559 | 1.7342 | 1.7516 | 113314.0 |
| 2009-11-16 | BFX | Futures | 2861.0 | 2875.9 | 2855.3 | 2865.3 | 213.0 |
| 2009-11-16 | BR | Futures | 0.23136 | 0.23176 | 0.23136 | 0.23176 | 15.0 |
| 2009-11-16 | BZ | Futures | 77.02 | 77.9 | 77.02 | 77.9 | 5.0 |
| 2009-11-16 | C | Futures | 2115.0 | 2115.0 | 2091.0 | 2097.0 | 1314.0 |
| 2009-11-16 | CB | Futures | 80.686 | 80.686 | 80.686 | 80.686 | 3.0 |
| 2009-11-16 | CC | Futures | 2710.0 | 2741.0 | 2699.0 | 2711.0 | 3781.0 |
| 2009-11-16 | CT | Futures | 58.21 | 59.16 | 57.65 | 59.06 | 13188.0 |
| 2009-11-16 | DC | Futures | 24.76 | 24.81 | 24.42 | 24.81 | 78.0 |
| 2009-11-16 | DX | Futures | 76.939 | 76.985 | 76.316 | 76.49 | 18318.0 |
| 2009-11-16 | E1 | Futures | 1.30531 | 1.31496 | 1.30214 | 1.31218 | 57904.0 |
| 2009-11-16 | E6 | Futures | 1.76835 | 1.77949 | 1.76326 | 1.7757 | 279006.0 |
| 2009-11-16 | E7 | Futures | 1.7488 | 1.7634 | 1.7466 | 1.7587 | 3257.0 |
| 2009-11-16 | ED | Futures | 94.2663 | 94.271 | 94.2616 | 94.2663 | 112128.0 |
| 2009-11-16 | ER | Futures | 97.184 | 97.184 | 97.169 | 97.179 | 78907.0 |
| 2009-11-16 | EW | Futures | 676.5 | 691.4 | 676.5 | 686.3 | 31427.0 |
| 2009-11-16 | FBTP | Futures | 62.55 | 62.87 | 62.55 | 62.82 | 5059.0 |
| 2009-11-16 | FCE | Futures | 2538.0 | 2563.6 | 2537.4 | 2561.6 | 34890.0 |
| 2009-11-16 | FDAX | Futures | 6239.7 | 6328.3 | 6235.9 | 6313.1 | 137114.0 |
| 2009-11-16 | FESX | Futures | 1732.2 | 1750.1 | 1731.6 | 1745.3 | 1117532.0 |
| 2009-11-16 | FEU3 | Futures | 97.751 | 97.751 | 97.746 | 97.751 | 400.0 |
| 2009-11-16 | FGBL | Futures | 93.54 | 94.11 | 93.5 | 93.87 | 638192.0 |
| 2009-11-16 | FGBM | Futures | 99.38 | 99.64 | 99.3 | 99.51 | 360381.0 |
| 2009-11-16 | FGBS | Futures | 104.982 | 105.036 | 104.948 | 104.992 | 410591.0 |
| 2009-11-16 | FGBX | Futures | 86.46 | 87.33 | 86.34 | 87.03 | 3349.0 |
| 2009-11-16 | FTDX | Futures | 684.8 | 697.7 | 683.4 | 695.9 | 540.0 |
| 2009-11-16 | FTI | Futures | 261.06 | 263.22 | 260.73 | 262.73 | 4498.0 |
| 2009-11-16 | FTUK | Futures | 3528.3 | 3572.4 | 3525.6 | 3557.8 | 90491.0 |
| 2009-11-16 | G | Futures | 76.18 | 76.53 | 76.06 | 76.35 | 59288.0 |
| 2009-11-16 | GF | Futures | 251.44 | 251.983 | 249.406 | 250.559 | 1376.0 |
| 2009-11-16 | GSCI | Futures | 968.63 | 1006.33 | 968.63 | 1004.4 | 808.0 |
| 2009-11-16 | HE | Futures | 83.423 | 84.605 | 83.423 | 83.766 | 11364.0 |
| 2009-11-16 | HG | Futures | 4.1422 | 4.3582 | 4.1422 | 4.3248 | 42111.0 |
| 2009-11-16 | HO | Futures | 1.9017 | 1.9823 | 1.9017 | 1.9684 | 43254.0 |
| 2009-11-16 | HRC | Futures | 2637.0 | 2637.0 | 2637.0 | 2637.0 | 0.0 |
| 2009-11-16 | J1 | Futures | 0.0140133 | 0.0141502 | 0.0139983 | 0.0141163 | 93879.0 |
| 2009-11-16 | J7 | Futures | 0.013845 | 0.013961 | 0.013819 | 0.013932 | 102.0 |
| 2009-11-16 | JB | Futures | 117.1 | 117.25 | 117.01 | 117.21 | 3240.0 |
| 2009-11-16 | KC | Futures | 350.02 | 362.3 | 348.7 | 359.92 | 13717.0 |
| 2009-11-16 | KE | Futures | 2533.58 | 2615.01 | 2527.77 | 2606.87 | 9723.0 |
| 2009-11-16 | L | Futures | 97.74 | 97.74 | 97.73 | 97.73 | 15310.0 |
> showing 50 of 89 rows — these rows as CSV