PREVIEW / futures_daily / 2009-06-25
file: by_date/futures_daily/2009/2009-06-25.parquet size: 8 KB rows: 85
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-25 | ES | Futures | 861.58 | 880.53 | 854.86 | 879.33 | 2278262.0 |
| 2009-06-25 | NQ | Futures | 1628.71 | 1663.06 | 1613.51 | 1658.84 | 313194.0 |
| 2009-06-25 | YM | Futures | 7447.2 | 7607.8 | 7393.0 | 7591.5 | 169849.0 |
| 2009-06-25 | CL | Futures | 179.68 | 186.63 | 179.21 | 184.79 | 254942.0 |
| 2009-06-25 | GC | Futures | 1290.3 | 1302.0 | 1288.0 | 1300.7 | 76944.0 |
| 2009-06-25 | ZN | Futures | 90.756516 | 91.679965 | 90.485638 | 91.569151 | 905455.0 |
| 2009-06-25 | A6 | Futures | 0.63655 | 0.64242 | 0.6339 | 0.64081 | 70356.0 |
| 2009-06-25 | AD | Futures | 0.85477 | 0.85733 | 0.84904 | 0.85358 | 70653.0 |
| 2009-06-25 | B | Futures | 65.36 | 67.68 | 65.35 | 67.03 | 49295.0 |
| 2009-06-25 | B6 | Futures | 1.7092 | 1.7154 | 1.6902 | 1.705 | 109251.0 |
| 2009-06-25 | BFX | Futures | 2298.6 | 2308.2 | 2267.5 | 2298.3 | 546.0 |
| 2009-06-25 | BR | Futures | 0.19738 | 0.19738 | 0.19738 | 0.19738 | 17.0 |
| 2009-06-25 | BZ | Futures | 71.33 | 72.07 | 71.33 | 71.52 | 264.0 |
| 2009-06-25 | C | Futures | 1688.0 | 1759.0 | 1669.0 | 1752.0 | 2530.0 |
| 2009-06-25 | CC | Futures | 2234.0 | 2281.0 | 2158.0 | 2273.0 | 10626.0 |
| 2009-06-25 | CT | Futures | 48.26 | 49.35 | 48.12 | 49.08 | 96.0 |
| 2009-06-25 | DC | Futures | 20.7 | 21.34 | 20.65 | 21.25 | 349.0 |
| 2009-06-25 | DX | Futures | 82.753 | 83.168 | 82.466 | 82.589 | 5522.0 |
| 2009-06-25 | E1 | Futures | 1.2065 | 1.21339 | 1.2024 | 1.21074 | 47399.0 |
| 2009-06-25 | E6 | Futures | 1.65327 | 1.66336 | 1.64841 | 1.66016 | 236598.0 |
| 2009-06-25 | E7 | Futures | 1.6363 | 1.6465 | 1.6316 | 1.6431 | 2679.0 |
| 2009-06-25 | ED | Futures | 93.7536 | 93.8055 | 93.7347 | 93.8008 | 227430.0 |
| 2009-06-25 | ER | Futures | 96.895 | 96.944 | 96.895 | 96.924 | 168819.0 |
| 2009-06-25 | EW | Futures | 541.6 | 555.8 | 537.5 | 554.1 | 31167.0 |
| 2009-06-25 | FCE | Futures | 2075.1 | 2086.8 | 2027.1 | 2064.6 | 129469.0 |
| 2009-06-25 | FDAX | Futures | 5305.9 | 5317.4 | 5179.7 | 5268.6 | 152706.0 |
| 2009-06-25 | FESX | Futures | 1438.6 | 1449.3 | 1406.4 | 1431.4 | 1133621.0 |
| 2009-06-25 | FEU3 | Futures | 97.48 | 97.505 | 97.48 | 97.5 | 670.0 |
| 2009-06-25 | FGBL | Futures | 91.22 | 91.83 | 91.17 | 91.69 | 682725.0 |
| 2009-06-25 | FGBM | Futures | 97.52 | 98.04 | 97.47 | 97.89 | 409437.0 |
| 2009-06-25 | FGBS | Futures | 103.868 | 104.109 | 103.834 | 104.013 | 660462.0 |
| 2009-06-25 | FGBX | Futures | 81.55 | 82.36 | 81.36 | 82.19 | 2367.0 |
| 2009-06-25 | FTDX | Futures | 550.5 | 561.2 | 540.7 | 548.7 | 984.0 |
| 2009-06-25 | FTI | Futures | 206.59 | 208.54 | 202.36 | 206.8 | 31241.0 |
| 2009-06-25 | FTUK | Futures | 2812.3 | 2830.9 | 2773.4 | 2801.3 | 94148.0 |
| 2009-06-25 | G | Futures | 75.5 | 75.84 | 75.48 | 75.73 | 71825.0 |
| 2009-06-25 | GF | Futures | 272.047 | 272.874 | 271.978 | 272.736 | 709.0 |
| 2009-06-25 | GSCI | Futures | 938.8 | 957.57 | 936.71 | 951.32 | 529.0 |
| 2009-06-25 | HE | Futures | 83.451 | 84.658 | 82.757 | 83.451 | 4855.0 |
| 2009-06-25 | HG | Futures | 3.1874 | 3.2948 | 3.1522 | 3.2519 | 12090.0 |
| 2009-06-25 | HO | Futures | 1.847 | 1.911 | 1.8459 | 1.8911 | 8276.0 |
| 2009-06-25 | HRC | Futures | 2328.7 | 2328.7 | 2328.7 | 2328.7 | 0.0 |
| 2009-06-25 | J1 | Futures | 0.0131645 | 0.0131796 | 0.0130449 | 0.0131406 | 79589.0 |
| 2009-06-25 | J7 | Futures | 0.012982 | 0.012982 | 0.012871 | 0.01296 | 113.0 |
| 2009-06-25 | JB | Futures | 115.98 | 116.09 | 115.8 | 115.95 | 1882.0 |
| 2009-06-25 | KC | Futures | 322.9 | 327.78 | 318.96 | 326.29 | 7316.0 |
| 2009-06-25 | KE | Futures | 2916.18 | 2920.98 | 2863.42 | 2889.8 | 7955.0 |
| 2009-06-25 | L | Futures | 97.082 | 97.131 | 97.072 | 97.121 | 45939.0 |
| 2009-06-25 | LBS | Futures | 894.9 | 909.9 | 888.5 | 903.6 | 373.0 |
| 2009-06-25 | LE | Futures | 145.347 | 145.92 | 144.862 | 145.479 | 7923.0 |
> showing 50 of 85 rows — these rows as CSV