PREVIEW / futures_daily / 2014-07-30
file: by_date/futures_daily/2014/2014-07-30.parquet size: 9 KB rows: 104
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 |
|---|---|---|---|---|---|---|---|
| 2014-07-30 | ES | Futures | 2040.46 | 2050.84 | 2032.41 | 2041.24 | 1768972.0 |
| 2014-07-30 | NQ | Futures | 4565.79 | 4595.5 | 4561.18 | 4578.77 | 275028.0 |
| 2014-07-30 | YM | Futures | 16999.4 | 17078.1 | 16901.5 | 16972.1 | 197892.0 |
| 2014-07-30 | CL | Futures | 185.99 | 187.17 | 183.02 | 184.59 | 263974.0 |
| 2014-07-30 | GC | Futures | 1705.8 | 1712.0 | 1696.2 | 1701.1 | 130868.0 |
| 2014-07-30 | ZN | Futures | 117.031758 | 117.104702 | 116.185605 | 116.389848 | 1830910.0 |
| 2014-07-30 | A6 | Futures | 0.90398 | 0.90436 | 0.89615 | 0.89847 | 128417.0 |
| 2014-07-30 | AD | Futures | 0.9348 | 0.9351 | 0.92911 | 0.93063 | 65291.0 |
| 2014-07-30 | ALI | Futures | 2950.34 | 2950.34 | 2950.34 | 2950.34 | 0.0 |
| 2014-07-30 | B | Futures | 113.48 | 113.66 | 111.68 | 112.37 | 131502.0 |
| 2014-07-30 | B6 | Futures | 1.7804 | 1.7817 | 1.7749 | 1.7776 | 92576.0 |
| 2014-07-30 | BFX | Futures | 3815.5 | 3819.5 | 3783.5 | 3783.5 | 10.0 |
| 2014-07-30 | BR | Futures | 0.23358 | 0.23397 | 0.23131 | 0.23213 | 592.0 |
| 2014-07-30 | BZ | Futures | 114.09 | 114.54 | 112.57 | 113.25 | 14168.0 |
| 2014-07-30 | C | Futures | 2083.0 | 2112.0 | 2080.0 | 2108.0 | 12893.0 |
| 2014-07-30 | CB | Futures | 128.0 | 128.0 | 128.0 | 128.0 | 3.0 |
| 2014-07-30 | CC | Futures | 2338.0 | 2362.0 | 2337.0 | 2355.0 | 12703.0 |
| 2014-07-30 | CNH | Futures | 7.0958 | 7.0994 | 7.0958 | 7.0994 | 1.0 |
| 2014-07-30 | CSC | Futures | 4.578 | 4.578 | 4.54 | 4.54 | 22.0 |
| 2014-07-30 | CT | Futures | 81.7 | 81.7 | 79.56 | 79.9 | 29.0 |
| 2014-07-30 | DC | Futures | 36.97 | 37.14 | 36.69 | 36.9 | 167.0 |
| 2014-07-30 | DX | Futures | 77.163 | 77.5 | 77.153 | 77.377 | 29800.0 |
| 2014-07-30 | E1 | Futures | 1.41378 | 1.41443 | 1.40763 | 1.41058 | 49053.0 |
| 2014-07-30 | E6 | Futures | 1.58241 | 1.58312 | 1.57745 | 1.58028 | 197099.0 |
| 2014-07-30 | E7 | Futures | 1.572 | 1.5728 | 1.5672 | 1.57 | 2354.0 |
| 2014-07-30 | ED | Futures | 95.4115 | 95.4162 | 95.4019 | 95.4115 | 200633.0 |
| 2014-07-30 | ER | Futures | 97.886 | 97.891 | 97.881 | 97.886 | 37847.0 |
| 2014-07-30 | EW | Futures | 1448.4 | 1457.0 | 1444.4 | 1451.5 | 15276.0 |
| 2014-07-30 | FBTP | Futures | 92.96 | 93.11 | 92.48 | 92.78 | 67555.0 |
| 2014-07-30 | FBTS | Futures | 98.561 | 98.579 | 98.383 | 98.463 | 15407.0 |
| 2014-07-30 | FCE | Futures | 3469.4 | 3484.5 | 3421.3 | 3429.2 | 119028.0 |
| 2014-07-30 | FDAX | Futures | 10622.1 | 10693.7 | 10544.5 | 10570.9 | 104259.0 |
| 2014-07-30 | FESX | Futures | 2288.6 | 2310.2 | 2273.5 | 2280.7 | 997591.0 |
| 2014-07-30 | FGBL | Futures | 129.25 | 129.31 | 128.48 | 128.78 | 742475.0 |
| 2014-07-30 | FGBM | Futures | 121.78 | 121.82 | 121.52 | 121.62 | 425302.0 |
| 2014-07-30 | FGBS | Futures | 110.768 | 110.768 | 110.738 | 110.753 | 162782.0 |
| 2014-07-30 | FGBX | Futures | 137.44 | 137.54 | 135.58 | 136.21 | 24527.0 |
| 2014-07-30 | FMWO | Futures | 5794.0 | 5800.3 | 5767.6 | 5777.7 | 304.0 |
| 2014-07-30 | FOAT | Futures | 119.32 | 119.44 | 118.77 | 118.99 | 66808.0 |
| 2014-07-30 | FTDX | Futures | 1180.9 | 1180.9 | 1163.1 | 1166.9 | 177.0 |
| 2014-07-30 | FTI | Futures | 351.26 | 354.42 | 350.39 | 352.34 | 30476.0 |
| 2014-07-30 | FTUK | Futures | 5194.6 | 5208.1 | 5161.5 | 5175.8 | 89619.0 |
| 2014-07-30 | FVSA | Futures | 1405.14 | 1434.85 | 1383.91 | 1417.87 | 4628.0 |
| 2014-07-30 | FXXP | Futures | 257.1 | 258.1 | 255.4 | 256.2 | 9884.0 |
| 2014-07-30 | G | Futures | 95.09 | 95.12 | 94.54 | 94.69 | 155937.0 |
| 2014-07-30 | GF | Futures | 339.7 | 342.535 | 339.7 | 341.807 | 3100.0 |
| 2014-07-30 | GSCI | Futures | 1054.62 | 1056.87 | 1044.66 | 1047.17 | 124.0 |
| 2014-07-30 | HE | Futures | 127.11 | 127.399 | 124.303 | 125.038 | 18330.0 |
| 2014-07-30 | HG | Futures | 4.1158 | 4.1701 | 4.0966 | 4.1433 | 38643.0 |
| 2014-07-30 | HH | Futures | 47.731 | 48.062 | 47.579 | 48.062 | 722.0 |
> showing 50 of 104 rows — these rows as CSV