PREVIEW / futures_daily / 2011-07-06
file: by_date/futures_daily/2011/2011-07-06.parquet size: 9 KB rows: 95
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 |
|---|---|---|---|---|---|---|---|
| 2011-07-06 | ES | Futures | 1326.83 | 1331.54 | 1317.39 | 1326.58 | 1819425.0 |
| 2011-07-06 | NQ | Futures | 2698.86 | 2711.1 | 2685.76 | 2704.83 | 257899.0 |
| 2011-07-06 | YM | Futures | 11844.0 | 11898.9 | 11796.8 | 11882.8 | 97687.0 |
| 2011-07-06 | CL | Futures | 186.12 | 187.64 | 184.01 | 185.45 | 288321.0 |
| 2011-07-06 | GC | Futures | 2052.1 | 2076.8 | 2044.1 | 2069.7 | 142652.0 |
| 2011-07-06 | ZN | Futures | 104.497253 | 104.936317 | 104.271069 | 104.723438 | 1334171.0 |
| 2011-07-06 | A6 | Futures | 0.92118 | 0.92492 | 0.91796 | 0.92057 | 93695.0 |
| 2011-07-06 | AD | Futures | 1.03449 | 1.03638 | 1.0277 | 1.03149 | 68779.0 |
| 2011-07-06 | B | Futures | 96.55 | 97.08 | 95.1 | 96.54 | 105815.0 |
| 2011-07-06 | B6 | Futures | 1.67 | 1.6724 | 1.6574 | 1.6609 | 115189.0 |
| 2011-07-06 | BFX | Futures | 3036.2 | 3036.2 | 3016.1 | 3023.3 | 44.0 |
| 2011-07-06 | BR | Futures | 0.28163 | 0.28163 | 0.28018 | 0.28085 | 116.0 |
| 2011-07-06 | BZ | Futures | 100.13 | 100.43 | 99.93 | 100.26 | 597.0 |
| 2011-07-06 | C | Futures | 2175.0 | 2194.0 | 2149.0 | 2154.0 | 1096.0 |
| 2011-07-06 | CB | Futures | 112.874 | 112.874 | 112.326 | 112.874 | 3.0 |
| 2011-07-06 | CC | Futures | 2557.0 | 2575.0 | 2515.0 | 2527.0 | 9558.0 |
| 2011-07-06 | CSC | Futures | 4.484 | 4.484 | 4.447 | 4.447 | 32.0 |
| 2011-07-06 | CT | Futures | 153.65 | 156.83 | 150.63 | 151.81 | 25.0 |
| 2011-07-06 | DC | Futures | 30.52 | 30.82 | 30.27 | 30.44 | 104.0 |
| 2011-07-06 | DX | Futures | 74.202 | 74.806 | 74.049 | 74.712 | 19793.0 |
| 2011-07-06 | E1 | Futures | 1.55621 | 1.56445 | 1.5498 | 1.55726 | 45200.0 |
| 2011-07-06 | E6 | Futures | 1.70991 | 1.71466 | 1.69316 | 1.69435 | 299631.0 |
| 2011-07-06 | E7 | Futures | 1.6977 | 1.702 | 1.6808 | 1.682 | 5344.0 |
| 2011-07-06 | ED | Futures | 94.943 | 94.9573 | 94.9191 | 94.9334 | 279497.0 |
| 2011-07-06 | ER | Futures | 97.262 | 97.267 | 97.247 | 97.252 | 84098.0 |
| 2011-07-06 | EW | Futures | 986.8 | 992.4 | 980.7 | 991.7 | 23403.0 |
| 2011-07-06 | FBTP | Futures | 64.4 | 64.4 | 63.59 | 63.62 | 13047.0 |
| 2011-07-06 | FCE | Futures | 2779.5 | 2780.6 | 2739.9 | 2754.2 | 136100.0 |
| 2011-07-06 | FDAX | Futures | 8003.7 | 8008.5 | 7927.3 | 7960.9 | 129567.0 |
| 2011-07-06 | FESX | Futures | 1838.3 | 1838.9 | 1806.8 | 1816.5 | 1388279.0 |
| 2011-07-06 | FGBL | Futures | 100.85 | 101.59 | 100.79 | 101.5 | 1260752.0 |
| 2011-07-06 | FGBM | Futures | 105.03 | 105.6 | 104.98 | 105.5 | 745223.0 |
| 2011-07-06 | FGBS | Futures | 106.935 | 107.129 | 106.925 | 107.07 | 831315.0 |
| 2011-07-06 | FGBX | Futures | 95.39 | 96.83 | 95.37 | 96.69 | 7644.0 |
| 2011-07-06 | FTDX | Futures | 806.0 | 807.4 | 800.7 | 802.9 | 122.0 |
| 2011-07-06 | FTI | Futures | 282.8 | 282.8 | 279.47 | 280.58 | 31741.0 |
| 2011-07-06 | FTUK | Futures | 4224.2 | 4239.0 | 4187.9 | 4209.4 | 96740.0 |
| 2011-07-06 | FXXP | Futures | 185.7 | 186.0 | 185.1 | 185.6 | 1352.0 |
| 2011-07-06 | G | Futures | 84.48 | 84.87 | 84.45 | 84.85 | 126284.0 |
| 2011-07-06 | GF | Futures | 327.804 | 329.082 | 326.642 | 327.571 | 3351.0 |
| 2011-07-06 | GSCI | Futures | 1059.87 | 1065.08 | 1057.19 | 1063.19 | 269.0 |
| 2011-07-06 | HE | Futures | 102.976 | 103.885 | 102.921 | 103.114 | 17100.0 |
| 2011-07-06 | HG | Futures | 5.7386 | 5.7478 | 5.6857 | 5.7307 | 30717.0 |
| 2011-07-06 | HO | Futures | 2.4049 | 2.4219 | 2.385 | 2.4119 | 8911.0 |
| 2011-07-06 | HRC | Futures | 3018.5 | 3018.5 | 3018.5 | 3018.5 | 0.0 |
| 2011-07-06 | J1 | Futures | 0.0155053 | 0.0155694 | 0.0155015 | 0.0155392 | 83130.0 |
| 2011-07-06 | J7 | Futures | 0.015417 | 0.015464 | 0.0154 | 0.015435 | 634.0 |
| 2011-07-06 | JB | Futures | 122.57 | 122.67 | 122.41 | 122.53 | 1778.0 |
| 2011-07-06 | KC | Futures | 635.91 | 637.81 | 628.82 | 632.84 | 7840.0 |
| 2011-07-06 | KE | Futures | 2823.14 | 2842.35 | 2766.49 | 2790.49 | 8717.0 |
> showing 50 of 95 rows — these rows as CSV