PREVIEW / futures_daily / 2010-06-16
file: by_date/futures_daily/2010/2010-06-16.parquet size: 9 KB rows: 89
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-16 | ES | Futures | 1081.91 | 1087.27 | 1072.89 | 1082.15 | 2522048.0 |
| 2010-06-16 | NQ | Futures | 2143.11 | 2164.9 | 2126.7 | 2157.26 | 357551.0 |
| 2010-06-16 | YM | Futures | 9554.7 | 9588.0 | 9488.1 | 9563.9 | 147867.0 |
| 2010-06-16 | CL | Futures | 166.42 | 169.09 | 164.82 | 168.13 | 178723.0 |
| 2010-06-16 | GC | Futures | 1686.1 | 1690.8 | 1675.5 | 1678.5 | 83665.0 |
| 2010-06-16 | ZN | Futures | 98.2753 | 98.723519 | 98.198462 | 98.403363 | 865182.0 |
| 2010-06-16 | A6 | Futures | 0.70941 | 0.71165 | 0.70377 | 0.70966 | 77672.0 |
| 2010-06-16 | AD | Futures | 0.96258 | 0.96545 | 0.95606 | 0.96377 | 64863.0 |
| 2010-06-16 | B | Futures | 67.73 | 68.93 | 67.21 | 68.57 | 156444.0 |
| 2010-06-16 | B6 | Futures | 1.5367 | 1.5419 | 1.5284 | 1.5354 | 102249.0 |
| 2010-06-16 | BFX | Futures | 2885.0 | 2885.0 | 2850.9 | 2870.4 | 902.0 |
| 2010-06-16 | BZ | Futures | 72.83 | 74.32 | 72.5 | 73.95 | 239.0 |
| 2010-06-16 | C | Futures | 2444.0 | 2448.0 | 2403.0 | 2414.0 | 3895.0 |
| 2010-06-16 | CB | Futures | 81.604 | 81.604 | 81.604 | 81.604 | 8.0 |
| 2010-06-16 | CC | Futures | 2476.0 | 2487.0 | 2463.0 | 2465.0 | 5744.0 |
| 2010-06-16 | CT | Futures | 65.07 | 65.53 | 64.86 | 64.99 | 4240.0 |
| 2010-06-16 | DC | Futures | 22.49 | 22.54 | 22.39 | 22.46 | 53.0 |
| 2010-06-16 | DX | Futures | 87.049 | 87.391 | 86.893 | 87.07 | 15333.0 |
| 2010-06-16 | E1 | Futures | 1.16098 | 1.16978 | 1.16059 | 1.16558 | 28825.0 |
| 2010-06-16 | E6 | Futures | 1.45801 | 1.46192 | 1.45009 | 1.45707 | 256776.0 |
| 2010-06-16 | E7 | Futures | 1.448 | 1.4513 | 1.4399 | 1.4466 | 3927.0 |
| 2010-06-16 | ED | Futures | 94.2332 | 94.2427 | 94.2142 | 94.2332 | 147733.0 |
| 2010-06-16 | ER | Futures | 97.33 | 97.345 | 97.316 | 97.326 | 93848.0 |
| 2010-06-16 | EW | Futures | 760.0 | 763.8 | 753.4 | 759.5 | 26906.0 |
| 2010-06-16 | FBTP | Futures | 64.42 | 64.54 | 64.3 | 64.44 | 3588.0 |
| 2010-06-16 | FCE | Futures | 2425.0 | 2432.9 | 2391.8 | 2415.8 | 150752.0 |
| 2010-06-16 | FDAX | Futures | 6743.8 | 6763.9 | 6681.8 | 6735.1 | 193412.0 |
| 2010-06-16 | FESX | Futures | 1689.1 | 1695.3 | 1661.9 | 1679.8 | 1363070.0 |
| 2010-06-16 | FEU3 | Futures | 97.894 | 97.904 | 97.879 | 97.884 | 737.0 |
| 2010-06-16 | FGBL | Futures | 100.09 | 100.52 | 99.91 | 100.23 | 812507.0 |
| 2010-06-16 | FGBM | Futures | 105.07 | 105.34 | 104.98 | 105.19 | 405245.0 |
| 2010-06-16 | FGBS | Futures | 107.682 | 107.785 | 107.667 | 107.745 | 320528.0 |
| 2010-06-16 | FGBX | Futures | 99.1 | 99.26 | 98.25 | 98.65 | 2237.0 |
| 2010-06-16 | FTDX | Futures | 689.3 | 691.5 | 680.5 | 683.6 | 2884.0 |
| 2010-06-16 | FTI | Futures | 266.1 | 266.93 | 263.41 | 265.27 | 40433.0 |
| 2010-06-16 | FTUK | Futures | 3598.4 | 3612.9 | 3562.6 | 3584.0 | 221525.0 |
| 2010-06-16 | G | Futures | 79.81 | 80.3 | 79.76 | 79.96 | 77024.0 |
| 2010-06-16 | GF | Futures | 280.466 | 281.54 | 278.887 | 280.15 | 1936.0 |
| 2010-06-16 | GSCI | Futures | 861.99 | 877.18 | 861.99 | 875.13 | 433.0 |
| 2010-06-16 | HE | Futures | 100.133 | 101.416 | 100.039 | 101.228 | 10727.0 |
| 2010-06-16 | HG | Futures | 4.1132 | 4.1404 | 4.0114 | 4.0677 | 25976.0 |
| 2010-06-16 | HO | Futures | 1.85 | 1.8928 | 1.8418 | 1.884 | 13065.0 |
| 2010-06-16 | HRC | Futures | 2994.3 | 2994.3 | 2994.3 | 2994.3 | 0.0 |
| 2010-06-16 | J1 | Futures | 0.01377 | 0.0138304 | 0.0137209 | 0.0137775 | 112696.0 |
| 2010-06-16 | J7 | Futures | 0.013661 | 0.013725 | 0.013619 | 0.013674 | 76.0 |
| 2010-06-16 | JB | Futures | 119.52 | 119.54 | 119.4 | 119.51 | 1138.0 |
| 2010-06-16 | KC | Futures | 402.53 | 411.92 | 397.7 | 403.03 | 5200.0 |
| 2010-06-16 | KE | Futures | 2075.91 | 2166.12 | 2075.91 | 2132.43 | 18943.0 |
| 2010-06-16 | L | Futures | 97.977 | 98.007 | 97.977 | 97.997 | 70212.0 |
| 2010-06-16 | LBS | Futures | 631.4 | 635.1 | 598.3 | 602.0 | 420.0 |
> showing 50 of 89 rows — these rows as CSV