PREVIEW / futures_daily / 2010-06-29
file: by_date/futures_daily/2010/2010-06-29.parquet size: 9 KB rows: 90
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 |
|---|---|---|---|---|---|---|---|
| 2010-06-29 | ES | Futures | 1044.12 | 1048.26 | 1004.86 | 1009.73 | 3109449.0 |
| 2010-06-29 | NQ | Futures | 2077.46 | 2081.99 | 1978.43 | 1995.97 | 477966.0 |
| 2010-06-29 | YM | Futures | 9319.9 | 9355.0 | 9013.8 | 9058.2 | 201186.0 |
| 2010-06-29 | CL | Futures | 166.91 | 167.28 | 160.63 | 162.19 | 323267.0 |
| 2010-06-29 | GC | Futures | 1690.1 | 1699.6 | 1674.5 | 1694.7 | 148822.0 |
| 2010-06-29 | ZN | Futures | 100.183434 | 100.567622 | 100.080984 | 100.426753 | 1358633.0 |
| 2010-06-29 | A6 | Futures | 0.71612 | 0.71637 | 0.69565 | 0.69913 | 133817.0 |
| 2010-06-29 | AD | Futures | 0.9532 | 0.95448 | 0.93335 | 0.93592 | 110180.0 |
| 2010-06-29 | B | Futures | 68.11 | 68.28 | 65.71 | 66.25 | 83386.0 |
| 2010-06-29 | B6 | Futures | 1.5669 | 1.5691 | 1.5579 | 1.565 | 111405.0 |
| 2010-06-29 | BFX | Futures | 2772.5 | 2772.5 | 2720.4 | 2723.7 | 112.0 |
| 2010-06-29 | BZ | Futures | 71.4 | 71.4 | 70.27 | 70.8 | 31.0 |
| 2010-06-29 | C | Futures | 2547.0 | 2573.0 | 2513.0 | 2524.0 | 2557.0 |
| 2010-06-29 | CB | Futures | 82.57 | 82.57 | 82.57 | 82.57 | 8.0 |
| 2010-06-29 | CC | Futures | 2596.0 | 2615.0 | 2439.0 | 2485.0 | 16762.0 |
| 2010-06-29 | CSC | Futures | 3.652 | 3.652 | 3.652 | 3.652 | 6.0 |
| 2010-06-29 | CT | Futures | 66.88 | 67.2 | 66.17 | 66.71 | 103.0 |
| 2010-06-29 | DC | Futures | 22.26 | 22.45 | 22.22 | 22.45 | 107.0 |
| 2010-06-29 | DX | Futures | 86.59 | 87.286 | 86.59 | 87.024 | 19946.0 |
| 2010-06-29 | E1 | Futures | 1.21023 | 1.21758 | 1.20642 | 1.2168 | 36781.0 |
| 2010-06-29 | E6 | Futures | 1.45281 | 1.45399 | 1.43756 | 1.4443 | 330210.0 |
| 2010-06-29 | E7 | Futures | 1.4427 | 1.4435 | 1.4269 | 1.4339 | 4604.0 |
| 2010-06-29 | ED | Futures | 94.2854 | 94.2996 | 94.2569 | 94.2759 | 188296.0 |
| 2010-06-29 | ER | Futures | 97.306 | 97.321 | 97.296 | 97.316 | 142821.0 |
| 2010-06-29 | EW | Futures | 727.2 | 729.3 | 696.9 | 698.9 | 45537.0 |
| 2010-06-29 | FBTP | Futures | 64.69 | 64.88 | 64.56 | 64.67 | 3725.0 |
| 2010-06-29 | FCE | Futures | 2318.4 | 2318.4 | 2238.8 | 2257.2 | 173823.0 |
| 2010-06-29 | FDAX | Futures | 6624.1 | 6624.1 | 6453.9 | 6496.3 | 176257.0 |
| 2010-06-29 | FESX | Futures | 1623.5 | 1624.7 | 1567.8 | 1583.9 | 1790175.0 |
| 2010-06-29 | FEU3 | Futures | 97.869 | 97.874 | 97.869 | 97.874 | 94.0 |
| 2010-06-29 | FGBL | Futures | 101.19 | 101.42 | 101.03 | 101.09 | 831872.0 |
| 2010-06-29 | FGBM | Futures | 105.59 | 105.7 | 105.51 | 105.55 | 370593.0 |
| 2010-06-29 | FGBS | Futures | 107.691 | 107.745 | 107.672 | 107.696 | 323686.0 |
| 2010-06-29 | FGBX | Futures | 100.66 | 101.23 | 100.41 | 100.53 | 4565.0 |
| 2010-06-29 | FTDX | Futures | 659.8 | 661.1 | 639.5 | 648.7 | 422.0 |
| 2010-06-29 | FTI | Futures | 258.61 | 258.69 | 250.73 | 252.75 | 41683.0 |
| 2010-06-29 | FTUK | Futures | 3423.3 | 3428.8 | 3330.7 | 3370.3 | 124793.0 |
| 2010-06-29 | G | Futures | 81.39 | 81.55 | 80.93 | 81.04 | 159550.0 |
| 2010-06-29 | GF | Futures | 288.044 | 288.802 | 284.192 | 285.139 | 2416.0 |
| 2010-06-29 | GSCI | Futures | 848.84 | 849.52 | 839.11 | 842.35 | 724.0 |
| 2010-06-29 | HE | Futures | 99.382 | 99.382 | 97.975 | 98.538 | 5984.0 |
| 2010-06-29 | HG | Futures | 4.1404 | 4.1491 | 3.9154 | 3.9247 | 36810.0 |
| 2010-06-29 | HO | Futures | 1.877 | 1.8771 | 1.8044 | 1.8204 | 13682.0 |
| 2010-06-29 | HRC | Futures | 2923.0 | 2923.0 | 2923.0 | 2923.0 | 0.0 |
| 2010-06-29 | J1 | Futures | 0.014092 | 0.0142682 | 0.0140858 | 0.014233 | 156408.0 |
| 2010-06-29 | J7 | Futures | 0.013995 | 0.01416 | 0.013983 | 0.014126 | 203.0 |
| 2010-06-29 | JB | Futures | 120.08 | 120.63 | 120.08 | 120.56 | 1828.0 |
| 2010-06-29 | KC | Futures | 420.65 | 421.91 | 402.07 | 409.73 | 12636.0 |
| 2010-06-29 | KE | Futures | 2087.01 | 2087.01 | 2041.2 | 2041.2 | 14348.0 |
| 2010-06-29 | L | Futures | 98.026 | 98.036 | 98.007 | 98.017 | 16805.0 |
> showing 50 of 90 rows — these rows as CSV