PREVIEW / futures_daily / 2010-07-21
file: by_date/futures_daily/2010/2010-07-21.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-07-21 | ES | Futures | 1052.89 | 1060.94 | 1034.85 | 1037.78 | 2440958.0 |
| 2010-07-21 | NQ | Futures | 2082.27 | 2105.19 | 2049.73 | 2054.83 | 401877.0 |
| 2010-07-21 | YM | Futures | 9408.6 | 9459.5 | 9257.9 | 9299.5 | 171959.0 |
| 2010-07-21 | CL | Futures | 165.29 | 166.81 | 161.78 | 162.55 | 322410.0 |
| 2010-07-21 | GC | Futures | 1625.7 | 1634.1 | 1613.7 | 1625.7 | 146975.0 |
| 2010-07-21 | ZN | Futures | 100.887779 | 101.425642 | 100.810941 | 101.220741 | 1171157.0 |
| 2010-07-21 | A6 | Futures | 0.72764 | 0.72972 | 0.72168 | 0.72226 | 95207.0 |
| 2010-07-21 | AD | Futures | 0.94609 | 0.9536 | 0.93977 | 0.94036 | 91045.0 |
| 2010-07-21 | B | Futures | 66.73 | 67.49 | 65.62 | 65.89 | 144298.0 |
| 2010-07-21 | B6 | Futures | 1.5848 | 1.5914 | 1.5693 | 1.5714 | 117746.0 |
| 2010-07-21 | BFX | Futures | 2744.5 | 2817.5 | 2744.5 | 2797.3 | 702.0 |
| 2010-07-21 | BR | Futures | 0.23342 | 0.23342 | 0.23217 | 0.23217 | 40.0 |
| 2010-07-21 | BZ | Futures | 71.88 | 72.14 | 70.15 | 70.42 | 576.0 |
| 2010-07-21 | C | Futures | 2530.0 | 2546.0 | 2486.0 | 2492.0 | 5764.0 |
| 2010-07-21 | CC | Futures | 2498.0 | 2508.0 | 2439.0 | 2448.0 | 5877.0 |
| 2010-07-21 | CT | Futures | 65.99 | 66.68 | 65.99 | 66.26 | 74.0 |
| 2010-07-21 | DC | Futures | 23.02 | 23.2 | 23.0 | 23.17 | 128.0 |
| 2010-07-21 | DX | Futures | 83.536 | 84.302 | 83.415 | 84.255 | 18836.0 |
| 2010-07-21 | E1 | Futures | 1.24884 | 1.25344 | 1.24635 | 1.25042 | 32571.0 |
| 2010-07-21 | E6 | Futures | 1.52423 | 1.52684 | 1.50543 | 1.50685 | 273136.0 |
| 2010-07-21 | E7 | Futures | 1.5131 | 1.5158 | 1.4947 | 1.496 | 3486.0 |
| 2010-07-21 | ED | Futures | 94.4562 | 94.4752 | 94.442 | 94.4562 | 235987.0 |
| 2010-07-21 | ER | Futures | 97.178 | 97.213 | 97.173 | 97.203 | 126890.0 |
| 2010-07-21 | EW | Futures | 725.0 | 730.9 | 712.2 | 714.0 | 34714.0 |
| 2010-07-21 | FBTP | Futures | 65.45 | 65.55 | 65.36 | 65.53 | 3072.0 |
| 2010-07-21 | FCE | Futures | 2298.2 | 2324.1 | 2260.5 | 2290.3 | 129338.0 |
| 2010-07-21 | FDAX | Futures | 6537.7 | 6600.7 | 6466.9 | 6521.9 | 145662.0 |
| 2010-07-21 | FESX | Futures | 1639.6 | 1653.8 | 1609.9 | 1631.5 | 1276196.0 |
| 2010-07-21 | FEU3 | Futures | 97.746 | 97.761 | 97.746 | 97.761 | 277.0 |
| 2010-07-21 | FGBL | Futures | 100.58 | 100.98 | 100.43 | 100.68 | 635986.0 |
| 2010-07-21 | FGBM | Futures | 104.78 | 105.13 | 104.71 | 104.93 | 344622.0 |
| 2010-07-21 | FGBS | Futures | 107.328 | 107.48 | 107.308 | 107.421 | 362319.0 |
| 2010-07-21 | FGBX | Futures | 100.14 | 100.95 | 99.81 | 100.16 | 3129.0 |
| 2010-07-21 | FTDX | Futures | 677.0 | 681.4 | 673.4 | 678.3 | 363.0 |
| 2010-07-21 | FTI | Futures | 255.88 | 260.05 | 255.32 | 258.1 | 36388.0 |
| 2010-07-21 | FTUK | Futures | 3545.1 | 3588.1 | 3530.6 | 3565.7 | 92859.0 |
| 2010-07-21 | G | Futures | 81.32 | 81.55 | 81.24 | 81.43 | 55959.0 |
| 2010-07-21 | GF | Futures | 289.371 | 290.002 | 287.729 | 289.623 | 1281.0 |
| 2010-07-21 | GSCI | Futures | 869.05 | 869.05 | 853.1 | 853.77 | 76.0 |
| 2010-07-21 | HE | Futures | 97.675 | 99.314 | 97.129 | 98.95 | 14186.0 |
| 2010-07-21 | HG | Futures | 4.0493 | 4.1604 | 4.0151 | 4.1424 | 41513.0 |
| 2010-07-21 | HO | Futures | 1.8023 | 1.8195 | 1.7627 | 1.767 | 38342.0 |
| 2010-07-21 | HRC | Futures | 2802.4 | 2851.1 | 2802.4 | 2851.1 | 10.0 |
| 2010-07-21 | J1 | Futures | 0.0143978 | 0.0144921 | 0.014394 | 0.0144733 | 121293.0 |
| 2010-07-21 | J7 | Futures | 0.014319 | 0.014381 | 0.014307 | 0.014364 | 79.0 |
| 2010-07-21 | JB | Futures | 120.66 | 120.78 | 120.07 | 120.67 | 1215.0 |
| 2010-07-21 | KC | Futures | 399.56 | 403.7 | 391.27 | 395.04 | 12501.0 |
| 2010-07-21 | KE | Futures | 2509.95 | 2589.85 | 2504.62 | 2563.21 | 13772.0 |
| 2010-07-21 | L | Futures | 98.066 | 98.096 | 98.056 | 98.086 | 20840.0 |
| 2010-07-21 | LBS | Futures | 590.7 | 598.1 | 586.3 | 594.5 | 272.0 |
> showing 50 of 89 rows — these rows as CSV