PREVIEW / futures_daily / 2009-06-09
file: by_date/futures_daily/2009/2009-06-09.parquet size: 8 KB rows: 84
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-06-09 | ES | Futures | 894.72 | 902.58 | 890.43 | 895.43 | 1928047.0 |
| 2009-06-09 | NQ | Futures | 1674.31 | 1695.94 | 1670.1 | 1686.11 | 241128.0 |
| 2009-06-09 | YM | Futures | 7855.8 | 7896.2 | 7819.0 | 7841.5 | 115403.0 |
| 2009-06-09 | CL | Futures | 182.87 | 188.19 | 182.17 | 186.38 | 316884.0 |
| 2009-06-09 | GC | Futures | 1317.7 | 1335.3 | 1312.9 | 1321.8 | 88840.0 |
| 2009-06-09 | ZN | Futures | 89.242061 | 89.734567 | 89.242061 | 89.586815 | 581536.0 |
| 2009-06-09 | A6 | Futures | 0.629 | 0.64144 | 0.62613 | 0.63945 | 66846.0 |
| 2009-06-09 | AD | Futures | 0.88197 | 0.89654 | 0.87921 | 0.89507 | 70095.0 |
| 2009-06-09 | B | Futures | 66.4 | 67.68 | 66.06 | 67.25 | 80607.0 |
| 2009-06-09 | B6 | Futures | 1.6691 | 1.7023 | 1.663 | 1.6995 | 108742.0 |
| 2009-06-09 | BFX | Futures | 2349.1 | 2360.0 | 2333.6 | 2337.8 | 175.0 |
| 2009-06-09 | BR | Futures | 0.19675 | 0.19749 | 0.19675 | 0.19749 | 2.0 |
| 2009-06-09 | C | Futures | 1909.0 | 1934.0 | 1902.0 | 1923.0 | 1501.0 |
| 2009-06-09 | CB | Futures | 74.463 | 74.463 | 74.463 | 74.463 | 4.0 |
| 2009-06-09 | CC | Futures | 2423.0 | 2492.0 | 2417.0 | 2480.0 | 10921.0 |
| 2009-06-09 | CT | Futures | 51.12 | 52.06 | 50.67 | 50.76 | 11656.0 |
| 2009-06-09 | DC | Futures | 22.75 | 23.02 | 22.7 | 22.98 | 106.0 |
| 2009-06-09 | DX | Futures | 83.143 | 83.498 | 82.072 | 82.2 | 8410.0 |
| 2009-06-09 | E1 | Futures | 1.21442 | 1.23206 | 1.21071 | 1.2298 | 45236.0 |
| 2009-06-09 | E6 | Futures | 1.64749 | 1.67191 | 1.64191 | 1.66883 | 231826.0 |
| 2009-06-09 | E7 | Futures | 1.6291 | 1.6525 | 1.6231 | 1.6495 | 2709.0 |
| 2009-06-09 | ED | Futures | 93.629 | 93.662 | 93.6195 | 93.6549 | 163722.0 |
| 2009-06-09 | ER | Futures | 96.66 | 96.674 | 96.645 | 96.669 | 82261.0 |
| 2009-06-09 | EW | Futures | 572.1 | 581.5 | 570.0 | 576.7 | 31469.0 |
| 2009-06-09 | FCE | Futures | 2148.9 | 2168.4 | 2134.3 | 2144.0 | 97190.0 |
| 2009-06-09 | FDAX | Futures | 5483.7 | 5519.1 | 5422.7 | 5444.5 | 138872.0 |
| 2009-06-09 | FESX | Futures | 1488.7 | 1500.1 | 1480.9 | 1486.9 | 963067.0 |
| 2009-06-09 | FEU3 | Futures | 97.229 | 97.249 | 97.229 | 97.249 | 1745.0 |
| 2009-06-09 | FGBL | Futures | 89.84 | 90.21 | 89.73 | 90.14 | 600590.0 |
| 2009-06-09 | FGBM | Futures | 96.16 | 96.49 | 96.14 | 96.39 | 375811.0 |
| 2009-06-09 | FGBS | Futures | 103.203 | 103.401 | 103.175 | 103.338 | 545771.0 |
| 2009-06-09 | FGBX | Futures | 81.47 | 82.05 | 80.94 | 81.77 | 2299.0 |
| 2009-06-09 | FTDX | Futures | 578.3 | 580.1 | 566.6 | 569.3 | 437.0 |
| 2009-06-09 | FTI | Futures | 217.38 | 219.31 | 215.4 | 216.55 | 28202.0 |
| 2009-06-09 | FTUK | Futures | 2944.4 | 2961.4 | 2918.8 | 2927.1 | 97621.0 |
| 2009-06-09 | G | Futures | 74.55 | 74.78 | 74.47 | 74.69 | 66294.0 |
| 2009-06-09 | GF | Futures | 264.743 | 266.397 | 263.227 | 265.501 | 1431.0 |
| 2009-06-09 | GSCI | Futures | 973.84 | 983.66 | 971.28 | 983.44 | 736.0 |
| 2009-06-09 | HE | Futures | 86.705 | 87.728 | 85.864 | 85.901 | 8560.0 |
| 2009-06-09 | HG | Futures | 3.212 | 3.3379 | 3.1796 | 3.3281 | 25997.0 |
| 2009-06-09 | HO | Futures | 1.8913 | 1.9054 | 1.8711 | 1.8999 | 11672.0 |
| 2009-06-09 | HRC | Futures | 2310.2 | 2310.2 | 2310.2 | 2310.2 | 0.0 |
| 2009-06-09 | J1 | Futures | 0.012798 | 0.0129606 | 0.0127854 | 0.0129354 | 86149.0 |
| 2009-06-09 | J7 | Futures | 0.012618 | 0.012781 | 0.012608 | 0.01276 | 46.0 |
| 2009-06-09 | JB | Futures | 114.32 | 114.5 | 114.28 | 114.46 | 310.0 |
| 2009-06-09 | KC | Futures | 362.84 | 366.44 | 361.46 | 363.4 | 11872.0 |
| 2009-06-09 | KE | Futures | 3191.19 | 3260.67 | 3187.53 | 3244.82 | 12719.0 |
| 2009-06-09 | L | Futures | 96.895 | 97.003 | 96.885 | 96.964 | 71760.0 |
| 2009-06-09 | LBS | Futures | 920.0 | 928.2 | 902.6 | 902.6 | 381.0 |
| 2009-06-09 | LE | Futures | 142.307 | 144.554 | 142.131 | 144.025 | 6870.0 |
> showing 50 of 84 rows — these rows as CSV