PREVIEW / futures_daily / 2009-06-24
file: by_date/futures_daily/2009/2009-06-24.parquet size: 8 KB rows: 86
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-24 | ES | Futures | 854.38 | 869.73 | 852.22 | 861.58 | 1749833.0 |
| 2009-06-24 | NQ | Futures | 1603.94 | 1640.82 | 1599.15 | 1629.84 | 261782.0 |
| 2009-06-24 | YM | Futures | 7450.8 | 7551.8 | 7399.4 | 7449.0 | 135229.0 |
| 2009-06-24 | CL | Futures | 180.37 | 183.81 | 179.08 | 180.68 | 242855.0 |
| 2009-06-24 | GC | Futures | 1282.6 | 1307.5 | 1277.6 | 1293.6 | 116253.0 |
| 2009-06-24 | ZN | Futures | 91.027395 | 91.482962 | 90.608765 | 90.768829 | 831128.0 |
| 2009-06-24 | A6 | Futures | 0.63422 | 0.64354 | 0.63245 | 0.63575 | 71098.0 |
| 2009-06-24 | AD | Futures | 0.85911 | 0.86543 | 0.85319 | 0.85773 | 65959.0 |
| 2009-06-24 | B | Futures | 65.44 | 66.3 | 64.64 | 65.36 | 115110.0 |
| 2009-06-24 | B6 | Futures | 1.7139 | 1.729 | 1.7046 | 1.7092 | 107103.0 |
| 2009-06-24 | BFX | Futures | 2255.7 | 2304.5 | 2237.2 | 2297.2 | 120.0 |
| 2009-06-24 | BR | Futures | 0.19424 | 0.19424 | 0.19424 | 0.19424 | 6.0 |
| 2009-06-24 | BZ | Futures | 71.19 | 72.36 | 71.19 | 71.33 | 143.0 |
| 2009-06-24 | C | Futures | 1702.0 | 1729.0 | 1687.0 | 1688.0 | 3465.0 |
| 2009-06-24 | CB | Futures | 72.331 | 72.331 | 72.331 | 72.331 | 10.0 |
| 2009-06-24 | CC | Futures | 2214.0 | 2307.0 | 2214.0 | 2227.0 | 7302.0 |
| 2009-06-24 | CT | Futures | 47.28 | 48.91 | 46.99 | 48.52 | 132.0 |
| 2009-06-24 | DC | Futures | 20.63 | 20.77 | 20.56 | 20.7 | 117.0 |
| 2009-06-24 | DX | Futures | 82.072 | 82.994 | 81.781 | 82.784 | 6049.0 |
| 2009-06-24 | E1 | Futures | 1.24198 | 1.24648 | 1.20134 | 1.20544 | 87660.0 |
| 2009-06-24 | E6 | Futures | 1.67025 | 1.67773 | 1.64817 | 1.65232 | 266058.0 |
| 2009-06-24 | E7 | Futures | 1.6533 | 1.6603 | 1.6314 | 1.6354 | 2974.0 |
| 2009-06-24 | ED | Futures | 93.7394 | 93.763 | 93.7111 | 93.7441 | 220161.0 |
| 2009-06-24 | ER | Futures | 96.836 | 96.929 | 96.826 | 96.9 | 216893.0 |
| 2009-06-24 | EW | Futures | 533.6 | 546.4 | 532.0 | 542.2 | 23326.0 |
| 2009-06-24 | FCE | Futures | 2036.6 | 2084.6 | 2023.2 | 2077.0 | 120211.0 |
| 2009-06-24 | FDAX | Futures | 5183.0 | 5314.7 | 5156.7 | 5305.9 | 143511.0 |
| 2009-06-24 | FESX | Futures | 1404.6 | 1443.9 | 1398.0 | 1441.0 | 1124042.0 |
| 2009-06-24 | FEU3 | Futures | 97.426 | 97.475 | 97.426 | 97.475 | 2576.0 |
| 2009-06-24 | FGBL | Futures | 91.32 | 91.57 | 91.26 | 91.46 | 629543.0 |
| 2009-06-24 | FGBM | Futures | 97.4 | 97.73 | 97.4 | 97.64 | 427658.0 |
| 2009-06-24 | FGBS | Futures | 103.752 | 103.926 | 103.748 | 103.887 | 551094.0 |
| 2009-06-24 | FGBX | Futures | 81.54 | 82.19 | 81.54 | 81.82 | 1178.0 |
| 2009-06-24 | FTDX | Futures | 530.0 | 553.2 | 530.0 | 549.6 | 836.0 |
| 2009-06-24 | FTI | Futures | 202.81 | 207.41 | 201.59 | 206.96 | 30080.0 |
| 2009-06-24 | FTUK | Futures | 2800.0 | 2827.2 | 2776.8 | 2820.2 | 87028.0 |
| 2009-06-24 | G | Futures | 75.46 | 75.76 | 75.46 | 75.7 | 71915.0 |
| 2009-06-24 | GF | Futures | 275.492 | 275.63 | 271.565 | 272.736 | 1799.0 |
| 2009-06-24 | GSCI | Futures | 940.88 | 945.68 | 933.27 | 934.63 | 116.0 |
| 2009-06-24 | HE | Futures | 87.216 | 87.545 | 83.525 | 83.78 | 6988.0 |
| 2009-06-24 | HG | Futures | 3.094 | 3.2323 | 3.0526 | 3.2028 | 8803.0 |
| 2009-06-24 | HO | Futures | 1.8549 | 1.8857 | 1.842 | 1.8483 | 10534.0 |
| 2009-06-24 | HRC | Futures | 2328.7 | 2328.7 | 2328.7 | 2328.7 | 0.0 |
| 2009-06-24 | J1 | Futures | 0.0132337 | 0.0132602 | 0.0131166 | 0.0131657 | 71983.0 |
| 2009-06-24 | J7 | Futures | 0.013044 | 0.013068 | 0.01294 | 0.012984 | 89.0 |
| 2009-06-24 | JB | Futures | 115.64 | 116.08 | 115.55 | 116.06 | 2760.0 |
| 2009-06-24 | KC | Futures | 321.27 | 330.36 | 321.0 | 323.3 | 5884.0 |
| 2009-06-24 | KE | Futures | 2944.96 | 2971.34 | 2897.0 | 2914.98 | 6248.0 |
| 2009-06-24 | L | Futures | 97.043 | 97.092 | 97.033 | 97.082 | 38767.0 |
| 2009-06-24 | LBS | Futures | 913.1 | 915.9 | 893.5 | 899.0 | 221.0 |
> showing 50 of 86 rows — these rows as CSV