PREVIEW / futures_daily / 2010-09-09
file: by_date/futures_daily/2010/2010-09-09.parquet size: 9 KB rows: 88
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-09-09 | ES | Futures | 1072.16 | 1084.59 | 1069.72 | 1075.33 | 1612227.0 |
| 2010-09-09 | NQ | Futures | 2125.85 | 2147.92 | 2121.89 | 2134.34 | 235345.0 |
| 2010-09-09 | YM | Futures | 9606.5 | 9693.4 | 9587.1 | 9619.4 | 86316.0 |
| 2010-09-09 | CL | Futures | 158.04 | 160.23 | 155.84 | 156.62 | 372881.0 |
| 2010-09-09 | GC | Futures | 1708.2 | 1713.3 | 1690.2 | 1700.3 | 119779.0 |
| 2010-09-09 | ZN | Futures | 102.741755 | 102.999835 | 102.070746 | 102.096554 | 1322768.0 |
| 2010-09-09 | A6 | Futures | 0.7613 | 0.76876 | 0.75583 | 0.7661 | 88967.0 |
| 2010-09-09 | AD | Futures | 0.95241 | 0.95893 | 0.95014 | 0.95597 | 61852.0 |
| 2010-09-09 | B | Futures | 67.63 | 68.06 | 66.46 | 66.88 | 114331.0 |
| 2010-09-09 | B6 | Futures | 1.6057 | 1.6064 | 1.5956 | 1.6012 | 86483.0 |
| 2010-09-09 | BFX | Futures | 2908.8 | 2948.7 | 2906.5 | 2937.4 | 921.0 |
| 2010-09-09 | BZ | Futures | 71.53 | 72.21 | 70.66 | 70.99 | 383.0 |
| 2010-09-09 | C | Futures | 2066.0 | 2072.0 | 2028.0 | 2041.0 | 2291.0 |
| 2010-09-09 | CC | Futures | 2280.0 | 2287.0 | 2220.0 | 2230.0 | 5847.0 |
| 2010-09-09 | CT | Futures | 76.13 | 76.84 | 75.74 | 76.02 | 58.0 |
| 2010-09-09 | DC | Futures | 24.06 | 24.21 | 24.01 | 24.13 | 92.0 |
| 2010-09-09 | DX | Futures | 83.249 | 83.491 | 82.997 | 83.345 | 16038.0 |
| 2010-09-09 | E1 | Futures | 1.29875 | 1.30032 | 1.29166 | 1.2931 | 36934.0 |
| 2010-09-09 | E6 | Futures | 1.50437 | 1.50957 | 1.49751 | 1.50153 | 224476.0 |
| 2010-09-09 | E7 | Futures | 1.4937 | 1.4986 | 1.4867 | 1.4907 | 2968.0 |
| 2010-09-09 | ED | Futures | 94.6175 | 94.627 | 94.6175 | 94.6223 | 107276.0 |
| 2010-09-09 | ER | Futures | 97.321 | 97.326 | 97.316 | 97.321 | 86779.0 |
| 2010-09-09 | EW | Futures | 743.6 | 753.8 | 742.1 | 744.5 | 50248.0 |
| 2010-09-09 | FBTP | Futures | 67.52 | 67.56 | 67.35 | 67.44 | 2490.0 |
| 2010-09-09 | FCE | Futures | 2413.5 | 2461.9 | 2411.2 | 2454.7 | 114339.0 |
| 2010-09-09 | FDAX | Futures | 6684.0 | 6782.4 | 6671.5 | 6760.1 | 131092.0 |
| 2010-09-09 | FESX | Futures | 1695.9 | 1728.7 | 1692.8 | 1720.7 | 1090032.0 |
| 2010-09-09 | FEU3 | Futures | 97.879 | 97.879 | 97.879 | 97.879 | 29.0 |
| 2010-09-09 | FGBL | Futures | 103.92 | 104.14 | 103.16 | 103.42 | 1029606.0 |
| 2010-09-09 | FGBM | Futures | 106.8 | 106.86 | 106.3 | 106.42 | 487201.0 |
| 2010-09-09 | FGBS | Futures | 107.863 | 107.868 | 107.671 | 107.701 | 550147.0 |
| 2010-09-09 | FGBX | Futures | 108.02 | 108.82 | 106.9 | 107.57 | 5721.0 |
| 2010-09-09 | FTDX | Futures | 668.1 | 675.2 | 666.8 | 673.9 | 459.0 |
| 2010-09-09 | FTI | Futures | 263.57 | 267.88 | 263.49 | 267.48 | 32059.0 |
| 2010-09-09 | FTUK | Futures | 3727.8 | 3789.0 | 3723.6 | 3774.9 | 138113.0 |
| 2010-09-09 | G | Futures | 84.2 | 84.37 | 83.65 | 83.69 | 114983.0 |
| 2010-09-09 | GF | Futures | 284.192 | 284.824 | 281.601 | 281.665 | 564.0 |
| 2010-09-09 | GSCI | Futures | 880.08 | 886.7 | 873.12 | 876.69 | 3192.0 |
| 2010-09-09 | HE | Futures | 100.644 | 102.423 | 100.348 | 101.929 | 24152.0 |
| 2010-09-09 | HG | Futures | 4.6581 | 4.6741 | 4.5286 | 4.596 | 34082.0 |
| 2010-09-09 | HO | Futures | 1.8038 | 1.8161 | 1.7756 | 1.7828 | 15891.0 |
| 2010-09-09 | HRC | Futures | 2707.8 | 2707.8 | 2707.8 | 2707.8 | 0.0 |
| 2010-09-09 | J1 | Futures | 0.0149929 | 0.0150696 | 0.0149727 | 0.0149954 | 129749.0 |
| 2010-09-09 | J7 | Futures | 0.014881 | 0.014955 | 0.014863 | 0.014882 | 351.0 |
| 2010-09-09 | KC | Futures | 474.78 | 481.1 | 469.44 | 472.92 | 9470.0 |
| 2010-09-09 | KE | Futures | 3065.42 | 3189.54 | 3049.78 | 3170.77 | 12259.0 |
| 2010-09-09 | KRW | Futures | 0.0008363 | 0.0008363 | 0.0008363 | 0.0008363 | 84.0 |
| 2010-09-09 | L | Futures | 98.076 | 98.106 | 98.066 | 98.096 | 61937.0 |
| 2010-09-09 | LBS | Futures | 645.3 | 669.8 | 642.4 | 657.4 | 268.0 |
| 2010-09-09 | LE | Futures | 156.637 | 157.281 | 155.792 | 155.993 | 32451.0 |
> showing 50 of 88 rows — these rows as CSV