PREVIEW / futures_daily / 2009-06-11
file: by_date/futures_daily/2009/2009-06-11.parquet size: 8 KB rows: 83
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-11 | ES | Futures | 895.67 | 911.63 | 892.81 | 897.81 | 1574555.0 |
| 2009-06-11 | NQ | Futures | 1679.09 | 1698.75 | 1672.06 | 1676.28 | 191213.0 |
| 2009-06-11 | YM | Futures | 7847.8 | 7965.1 | 7827.0 | 7848.7 | 81497.0 |
| 2009-06-11 | CL | Futures | 190.24 | 194.95 | 189.87 | 193.49 | 314790.0 |
| 2009-06-11 | GC | Futures | 1323.0 | 1333.5 | 1304.9 | 1331.9 | 111280.0 |
| 2009-06-11 | ZN | Futures | 89.278999 | 90.103946 | 88.884994 | 89.857693 | 872250.0 |
| 2009-06-11 | A6 | Futures | 0.64001 | 0.65753 | 0.63985 | 0.65624 | 59554.0 |
| 2009-06-11 | AD | Futures | 0.89141 | 0.90277 | 0.89102 | 0.9004 | 69582.0 |
| 2009-06-11 | B | Futures | 68.49 | 69.83 | 68.2 | 69.4 | 91042.0 |
| 2009-06-11 | B6 | Futures | 1.7022 | 1.7311 | 1.7013 | 1.7274 | 82243.0 |
| 2009-06-11 | BFX | Futures | 2345.7 | 2346.2 | 2345.7 | 2346.2 | 664.0 |
| 2009-06-11 | C | Futures | 1921.0 | 1929.0 | 1900.0 | 1917.0 | 4423.0 |
| 2009-06-11 | CB | Futures | 74.463 | 74.463 | 73.61 | 74.463 | 12.0 |
| 2009-06-11 | CC | Futures | 2480.0 | 2542.0 | 2473.0 | 2529.0 | 13049.0 |
| 2009-06-11 | CT | Futures | 50.59 | 52.31 | 50.47 | 52.09 | 10191.0 |
| 2009-06-11 | DC | Futures | 22.41 | 22.55 | 22.23 | 22.32 | 238.0 |
| 2009-06-11 | DX | Futures | 82.553 | 82.738 | 81.494 | 81.709 | 14121.0 |
| 2009-06-11 | E1 | Futures | 1.22504 | 1.24463 | 1.22146 | 1.23947 | 35031.0 |
| 2009-06-11 | E6 | Futures | 1.65672 | 1.68165 | 1.65351 | 1.67559 | 129925.0 |
| 2009-06-11 | E7 | Futures | 1.6396 | 1.6649 | 1.6364 | 1.6584 | 1035.0 |
| 2009-06-11 | ED | Futures | 93.6639 | 93.7205 | 93.6403 | 93.7064 | 263833.0 |
| 2009-06-11 | ER | Futures | 96.694 | 96.718 | 96.684 | 96.699 | 146369.0 |
| 2009-06-11 | EW | Futures | 573.9 | 583.0 | 572.6 | 575.0 | 52022.0 |
| 2009-06-11 | FCE | Futures | 2158.3 | 2179.5 | 2142.4 | 2169.7 | 113323.0 |
| 2009-06-11 | FDAX | Futures | 5512.5 | 5586.6 | 5487.5 | 5565.4 | 122895.0 |
| 2009-06-11 | FESX | Futures | 1491.7 | 1509.6 | 1484.5 | 1503.0 | 70543.0 |
| 2009-06-11 | FEU3 | Futures | 97.273 | 97.283 | 97.268 | 97.273 | 998.0 |
| 2009-06-11 | FGBL | Futures | 89.7 | 89.98 | 89.32 | 89.64 | 585138.0 |
| 2009-06-11 | FGBM | Futures | 96.25 | 96.37 | 95.93 | 96.15 | 344598.0 |
| 2009-06-11 | FGBS | Futures | 103.285 | 103.305 | 103.136 | 103.223 | 514963.0 |
| 2009-06-11 | FGBX | Futures | 80.94 | 81.12 | 80.33 | 80.63 | 1292.0 |
| 2009-06-11 | FTDX | Futures | 576.4 | 590.7 | 576.4 | 588.9 | 25.0 |
| 2009-06-11 | FTI | Futures | 218.26 | 218.3 | 216.63 | 217.98 | 1008.0 |
| 2009-06-11 | FTUK | Futures | 2917.5 | 2953.6 | 2901.2 | 2941.4 | 20408.0 |
| 2009-06-11 | G | Futures | 74.19 | 74.23 | 73.3 | 73.67 | 101751.0 |
| 2009-06-11 | GF | Futures | 263.778 | 265.914 | 260.746 | 265.639 | 1261.0 |
| 2009-06-11 | GSCI | Futures | 988.24 | 1002.01 | 983.23 | 997.21 | 538.0 |
| 2009-06-11 | HE | Futures | 85.754 | 88.569 | 85.389 | 87.728 | 11242.0 |
| 2009-06-11 | HG | Futures | 3.3323 | 3.4575 | 3.3027 | 3.4399 | 23894.0 |
| 2009-06-11 | HO | Futures | 1.9338 | 1.9653 | 1.9338 | 1.9521 | 11550.0 |
| 2009-06-11 | HRC | Futures | 2291.7 | 2291.7 | 2291.7 | 2291.7 | 0.0 |
| 2009-06-11 | J1 | Futures | 0.0128283 | 0.0129542 | 0.012778 | 0.012919 | 50188.0 |
| 2009-06-11 | J7 | Futures | 0.012662 | 0.012773 | 0.012616 | 0.012741 | 61.0 |
| 2009-06-11 | JB | Futures | 114.2 | 114.3 | 114.08 | 114.24 | 1501.0 |
| 2009-06-11 | KC | Futures | 362.43 | 365.47 | 357.86 | 364.64 | 10741.0 |
| 2009-06-11 | KE | Futures | 3166.81 | 3208.25 | 3121.71 | 3142.43 | 9251.0 |
| 2009-06-11 | L | Futures | 96.984 | 97.023 | 96.964 | 97.003 | 58952.0 |
| 2009-06-11 | LBS | Futures | 901.3 | 921.4 | 895.8 | 895.8 | 236.0 |
| 2009-06-11 | LE | Futures | 142.439 | 144.642 | 142.087 | 143.54 | 4440.0 |
| 2009-06-11 | MP | Futures | 0.03799 | 0.03879 | 0.03799 | 0.03873 | 13060.0 |
> showing 50 of 83 rows — these rows as CSV