PREVIEW / futures_daily / 2010-06-01
file: by_date/futures_daily/2010/2010-06-01.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-01 | ES | Futures | 1059.97 | 1067.27 | 1040.49 | 1041.46 | 2593945.0 |
| 2010-06-01 | NQ | Futures | 2100.97 | 2130.47 | 2069.49 | 2077.15 | 368555.0 |
| 2010-06-01 | YM | Futures | 9308.5 | 9386.6 | 9166.9 | 9210.1 | 163785.0 |
| 2010-06-01 | CL | Futures | 161.86 | 164.84 | 156.76 | 158.82 | 438588.0 |
| 2010-06-01 | GC | Futures | 1659.7 | 1678.6 | 1652.7 | 1673.6 | 107409.0 |
| 2010-06-01 | ZN | Futures | 98.4198 | 99.019221 | 98.254003 | 98.496322 | 220220.0 |
| 2010-06-01 | A6 | Futures | 0.69285 | 0.69761 | 0.67849 | 0.68662 | 159465.0 |
| 2010-06-01 | AD | Futures | 0.93849 | 0.94777 | 0.93444 | 0.93987 | 123809.0 |
| 2010-06-01 | B | Futures | 66.35 | 66.86 | 63.49 | 64.54 | 87728.0 |
| 2010-06-01 | B6 | Futures | 1.4994 | 1.5287 | 1.4976 | 1.5223 | 175719.0 |
| 2010-06-01 | BFX | Futures | 2779.7 | 2813.4 | 2755.9 | 2808.3 | 264.0 |
| 2010-06-01 | BR | Futures | 0.22424 | 0.22465 | 0.22382 | 0.22382 | 10.0 |
| 2010-06-01 | BZ | Futures | 69.6 | 69.6 | 69.6 | 69.6 | 3.0 |
| 2010-06-01 | C | Futures | 2393.0 | 2430.0 | 2375.0 | 2428.0 | 3756.0 |
| 2010-06-01 | CB | Futures | 78.224 | 79.31 | 78.224 | 78.948 | 7.0 |
| 2010-06-01 | CC | Futures | 2486.0 | 2520.0 | 2427.0 | 2512.0 | 7694.0 |
| 2010-06-01 | CT | Futures | 63.85 | 63.85 | 62.8 | 62.85 | 19284.0 |
| 2010-06-01 | DC | Futures | 22.28 | 22.28 | 21.91 | 22.22 | 125.0 |
| 2010-06-01 | DX | Futures | 87.884 | 88.75 | 87.372 | 87.884 | 27903.0 |
| 2010-06-01 | E1 | Futures | 1.13798 | 1.14798 | 1.12232 | 1.13956 | 74871.0 |
| 2010-06-01 | E6 | Futures | 1.45306 | 1.46182 | 1.43283 | 1.45011 | 530192.0 |
| 2010-06-01 | E7 | Futures | 1.441 | 1.4498 | 1.4212 | 1.4382 | 10348.0 |
| 2010-06-01 | ED | Futures | 94.1765 | 94.2073 | 94.1576 | 94.2002 | 177890.0 |
| 2010-06-01 | ER | Futures | 97.365 | 97.37 | 97.345 | 97.36 | 116338.0 |
| 2010-06-01 | EW | Futures | 743.0 | 749.9 | 721.6 | 721.9 | 39870.0 |
| 2010-06-01 | FBTP | Futures | 64.02 | 64.12 | 63.89 | 63.94 | 5594.0 |
| 2010-06-01 | FCE | Futures | 2300.9 | 2328.8 | 2255.8 | 2314.5 | 167259.0 |
| 2010-06-01 | FDAX | Futures | 6454.5 | 6540.4 | 6343.5 | 6498.0 | 193918.0 |
| 2010-06-01 | FESX | Futures | 1583.0 | 1602.0 | 1551.2 | 1590.4 | 1692665.0 |
| 2010-06-01 | FEU3 | Futures | 97.919 | 97.924 | 97.904 | 97.919 | 75.0 |
| 2010-06-01 | FGBL | Futures | 100.4 | 101.01 | 100.16 | 100.41 | 1051001.0 |
| 2010-06-01 | FGBM | Futures | 104.86 | 105.28 | 104.77 | 104.94 | 574806.0 |
| 2010-06-01 | FGBS | Futures | 107.554 | 107.687 | 107.554 | 107.633 | 789544.0 |
| 2010-06-01 | FGBX | Futures | 99.44 | 100.5 | 99.09 | 99.53 | 8002.0 |
| 2010-06-01 | FTDX | Futures | 658.9 | 663.7 | 643.8 | 657.6 | 1113.0 |
| 2010-06-01 | FTI | Futures | 250.7 | 254.24 | 247.2 | 252.75 | 40977.0 |
| 2010-06-01 | FTUK | Futures | 3487.2 | 3497.3 | 3416.8 | 3483.4 | 162294.0 |
| 2010-06-01 | G | Futures | 79.72 | 79.93 | 79.39 | 79.58 | 115860.0 |
| 2010-06-01 | GF | Futures | 273.393 | 276.55 | 271.877 | 276.55 | 2277.0 |
| 2010-06-01 | GSCI | Futures | 836.56 | 857.77 | 833.43 | 837.86 | 582.0 |
| 2010-06-01 | HE | Futures | 102.886 | 104.168 | 102.073 | 103.543 | 11136.0 |
| 2010-06-01 | HG | Futures | 4.2259 | 4.2666 | 4.0989 | 4.1594 | 27853.0 |
| 2010-06-01 | HO | Futures | 1.8088 | 1.8252 | 1.7555 | 1.768 | 8041.0 |
| 2010-06-01 | J1 | Futures | 0.0138291 | 0.0138894 | 0.0137247 | 0.0137838 | 171285.0 |
| 2010-06-01 | J7 | Futures | 0.013716 | 0.013776 | 0.013618 | 0.013674 | 1045.0 |
| 2010-06-01 | JB | Futures | 119.32 | 119.52 | 119.32 | 119.52 | 1305.0 |
| 2010-06-01 | KC | Futures | 340.2 | 349.34 | 338.04 | 346.67 | 20732.0 |
| 2010-06-01 | KE | Futures | 2093.3 | 2124.82 | 2060.7 | 2078.09 | 11008.0 |
| 2010-06-01 | L | Futures | 97.957 | 97.967 | 97.908 | 97.947 | 78944.0 |
| 2010-06-01 | LBS | Futures | 711.9 | 720.2 | 681.5 | 708.5 | 1739.0 |
> showing 50 of 89 rows — these rows as CSV