PREVIEW / futures_daily / 2011-07-05
file: by_date/futures_daily/2011/2011-07-05.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-05 | ES | Futures | 1325.34 | 1328.56 | 1319.13 | 1327.57 | 1729821.0 |
| 2011-07-05 | NQ | Futures | 2681.77 | 2701.13 | 2677.79 | 2701.13 | 249553.0 |
| 2011-07-05 | YM | Futures | 11831.7 | 11873.3 | 11794.9 | 11848.8 | 100180.0 |
| 2011-07-05 | CL | Futures | 182.25 | 187.04 | 181.02 | 185.91 | 275650.0 |
| 2011-07-05 | GC | Futures | 2012.3 | 2054.5 | 2011.5 | 2047.3 | 137184.0 |
| 2011-07-05 | ZN | Futures | 103.885225 | 104.550473 | 103.858615 | 104.444033 | 1032306.0 |
| 2011-07-05 | A6 | Futures | 0.92805 | 0.92918 | 0.91883 | 0.92118 | 105088.0 |
| 2011-07-05 | AD | Futures | 1.03878 | 1.03978 | 1.03319 | 1.03499 | 71596.0 |
| 2011-07-05 | B | Futures | 94.85 | 97.19 | 93.95 | 96.51 | 124317.0 |
| 2011-07-05 | B6 | Futures | 1.6696 | 1.6774 | 1.6618 | 1.6679 | 138744.0 |
| 2011-07-05 | BFX | Futures | 3082.4 | 3084.5 | 3048.0 | 3053.2 | 89.0 |
| 2011-07-05 | BR | Futures | 0.28241 | 0.28241 | 0.28161 | 0.28161 | 176.0 |
| 2011-07-05 | BZ | Futures | 100.23 | 100.23 | 100.23 | 100.23 | 608.0 |
| 2011-07-05 | C | Futures | 2142.0 | 2177.0 | 2138.0 | 2175.0 | 1809.0 |
| 2011-07-05 | CB | Futures | 112.874 | 113.696 | 112.874 | 113.696 | 4.0 |
| 2011-07-05 | CC | Futures | 2501.0 | 2561.0 | 2499.0 | 2558.0 | 15069.0 |
| 2011-07-05 | CSC | Futures | 4.484 | 4.484 | 4.484 | 4.484 | 21.0 |
| 2011-07-05 | CT | Futures | 158.23 | 159.36 | 153.6 | 154.37 | 55.0 |
| 2011-07-05 | DC | Futures | 30.4 | 30.72 | 30.32 | 30.52 | 189.0 |
| 2011-07-05 | DX | Futures | 73.816 | 74.326 | 73.816 | 74.261 | 17330.0 |
| 2011-07-05 | E1 | Futures | 1.54366 | 1.56079 | 1.53816 | 1.55739 | 49669.0 |
| 2011-07-05 | E6 | Futures | 1.72357 | 1.72773 | 1.70611 | 1.70801 | 318440.0 |
| 2011-07-05 | E7 | Futures | 1.711 | 1.715 | 1.6936 | 1.6955 | 5674.0 |
| 2011-07-05 | ED | Futures | 94.962 | 94.962 | 94.9382 | 94.943 | 238749.0 |
| 2011-07-05 | ER | Futures | 97.247 | 97.262 | 97.232 | 97.252 | 115584.0 |
| 2011-07-05 | EW | Futures | 983.5 | 987.6 | 979.1 | 986.8 | 17712.0 |
| 2011-07-05 | FBTP | Futures | 64.74 | 64.74 | 64.23 | 64.27 | 6404.0 |
| 2011-07-05 | FCE | Futures | 2781.3 | 2783.4 | 2762.2 | 2768.8 | 97273.0 |
| 2011-07-05 | FDAX | Futures | 7977.5 | 8012.7 | 7955.6 | 7982.8 | 113592.0 |
| 2011-07-05 | FESX | Futures | 1841.5 | 1842.1 | 1826.1 | 1831.2 | 974993.0 |
| 2011-07-05 | FGBL | Futures | 100.77 | 101.06 | 100.6 | 100.77 | 818880.0 |
| 2011-07-05 | FGBM | Futures | 104.85 | 105.17 | 104.83 | 104.96 | 444387.0 |
| 2011-07-05 | FGBS | Futures | 106.876 | 106.985 | 106.871 | 106.925 | 502469.0 |
| 2011-07-05 | FGBX | Futures | 95.14 | 95.7 | 95.1 | 95.35 | 6909.0 |
| 2011-07-05 | FTDX | Futures | 811.8 | 813.2 | 803.8 | 806.9 | 253.0 |
| 2011-07-05 | FTI | Futures | 281.93 | 283.0 | 281.24 | 281.81 | 22071.0 |
| 2011-07-05 | FTUK | Futures | 4224.6 | 4234.5 | 4213.3 | 4224.2 | 80443.0 |
| 2011-07-05 | FXXP | Futures | 186.1 | 186.9 | 185.8 | 186.3 | 815.0 |
| 2011-07-05 | G | Futures | 84.11 | 84.33 | 84.08 | 84.27 | 128125.0 |
| 2011-07-05 | GF | Futures | 326.584 | 329.779 | 324.841 | 328.327 | 3773.0 |
| 2011-07-05 | GSCI | Futures | 1048.83 | 1070.44 | 1044.89 | 1064.76 | 190.0 |
| 2011-07-05 | HE | Futures | 103.004 | 103.472 | 102.233 | 102.839 | 13716.0 |
| 2011-07-05 | HG | Futures | 5.6844 | 5.7558 | 5.6612 | 5.7472 | 34543.0 |
| 2011-07-05 | HO | Futures | 2.3859 | 2.4316 | 2.3582 | 2.4068 | 15871.0 |
| 2011-07-05 | HRC | Futures | 3018.5 | 3018.5 | 3018.5 | 3018.5 | 0.0 |
| 2011-07-05 | J1 | Futures | 0.0155581 | 0.0156134 | 0.0154864 | 0.0155128 | 105661.0 |
| 2011-07-05 | J7 | Futures | 0.015445 | 0.015508 | 0.015368 | 0.015409 | 328.0 |
| 2011-07-05 | JB | Futures | 122.59 | 122.68 | 122.49 | 122.6 | 1219.0 |
| 2011-07-05 | KC | Futures | 621.01 | 638.52 | 613.2 | 637.81 | 11546.0 |
| 2011-07-05 | KE | Futures | 2786.65 | 2862.51 | 2785.69 | 2826.98 | 9327.0 |
> showing 50 of 95 rows — these rows as CSV