PREVIEW / futures_daily / 2014-11-13
file: by_date/futures_daily/2014/2014-11-13.parquet size: 9 KB rows: 102
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-11-13 | ES | Futures | 2125.47 | 2134.87 | 2117.11 | 2124.69 | 1541477.0 |
| 2014-11-13 | NQ | Futures | 4860.17 | 4898.99 | 4857.85 | 4873.49 | 295015.0 |
| 2014-11-13 | YM | Futures | 17820.1 | 17917.5 | 17797.8 | 17851.6 | 135944.0 |
| 2014-11-13 | CL | Futures | 148.18 | 148.61 | 142.69 | 142.96 | 189990.0 |
| 2014-11-13 | GC | Futures | 1523.0 | 1531.2 | 1512.3 | 1523.5 | 187699.0 |
| 2014-11-13 | ZN | Futures | 118.290445 | 118.59796 | 118.231871 | 118.539385 | 1046815.0 |
| 2014-11-13 | A6 | Futures | 0.84478 | 0.84993 | 0.8409 | 0.84595 | 84984.0 |
| 2014-11-13 | AD | Futures | 0.8966 | 0.89833 | 0.89102 | 0.89325 | 49547.0 |
| 2014-11-13 | ALI | Futures | 3098.21 | 3098.21 | 3098.21 | 3098.21 | 0.0 |
| 2014-11-13 | B | Futures | 83.46 | 83.76 | 79.91 | 80.12 | 347461.0 |
| 2014-11-13 | B6 | Futures | 1.6568 | 1.6585 | 1.6492 | 1.6519 | 77977.0 |
| 2014-11-13 | BR | Futures | 0.2087 | 0.20951 | 0.20594 | 0.20686 | 1328.0 |
| 2014-11-13 | BZ | Futures | 84.06 | 84.58 | 80.74 | 80.93 | 19584.0 |
| 2014-11-13 | C | Futures | 2022.0 | 2024.0 | 1983.0 | 2011.0 | 6778.0 |
| 2014-11-13 | CB | Futures | 130.646 | 131.802 | 130.646 | 131.224 | 6.0 |
| 2014-11-13 | CC | Futures | 2105.0 | 2111.0 | 2052.0 | 2082.0 | 20942.0 |
| 2014-11-13 | CSC | Futures | 4.906 | 4.938 | 4.867 | 4.867 | 32.0 |
| 2014-11-13 | CT | Futures | 78.49 | 79.23 | 75.41 | 75.69 | 18084.0 |
| 2014-11-13 | DC | Futures | 39.3 | 39.76 | 38.85 | 38.93 | 440.0 |
| 2014-11-13 | DX | Futures | 83.441 | 83.498 | 83.251 | 83.301 | 24048.0 |
| 2014-11-13 | E1 | Futures | 1.32187 | 1.32929 | 1.32187 | 1.32865 | 30626.0 |
| 2014-11-13 | E6 | Futures | 1.4635 | 1.4708 | 1.46303 | 1.47021 | 161386.0 |
| 2014-11-13 | E7 | Futures | 1.4539 | 1.4615 | 1.4539 | 1.461 | 2600.0 |
| 2014-11-13 | ED | Futures | 95.4422 | 95.4422 | 95.4374 | 95.4374 | 44079.0 |
| 2014-11-13 | ER | Futures | 97.999 | 98.004 | 97.994 | 98.004 | 25778.0 |
| 2014-11-13 | EW | Futures | 1497.4 | 1504.3 | 1485.5 | 1488.9 | 14181.0 |
| 2014-11-13 | FBTP | Futures | 95.48 | 95.57 | 95.23 | 95.33 | 62164.0 |
| 2014-11-13 | FBTS | Futures | 98.49 | 98.508 | 98.419 | 98.455 | 15143.0 |
| 2014-11-13 | FCE | Futures | 3400.4 | 3412.6 | 3357.9 | 3385.8 | 3204.0 |
| 2014-11-13 | FDAX | Futures | 10162.5 | 10199.7 | 10041.4 | 10136.2 | 132805.0 |
| 2014-11-13 | FESX | Futures | 2218.7 | 2225.3 | 2186.9 | 2210.8 | 1060250.0 |
| 2014-11-13 | FGBL | Futures | 133.32 | 133.73 | 133.28 | 133.57 | 553239.0 |
| 2014-11-13 | FGBM | Futures | 123.2 | 123.31 | 123.16 | 123.26 | 327820.0 |
| 2014-11-13 | FGBS | Futures | 110.918 | 110.923 | 110.898 | 110.908 | 216238.0 |
| 2014-11-13 | FGBX | Futures | 145.54 | 146.72 | 145.44 | 146.14 | 20907.0 |
| 2014-11-13 | FMWO | Futures | 5718.7 | 5728.8 | 5707.5 | 5715.0 | 892.0 |
| 2014-11-13 | FOAT | Futures | 122.69 | 122.95 | 122.67 | 122.86 | 52620.0 |
| 2014-11-13 | FTDX | Futures | 1209.3 | 1215.4 | 1201.2 | 1201.7 | 80.0 |
| 2014-11-13 | FTI | Futures | 359.07 | 359.51 | 355.6 | 357.86 | 291.0 |
| 2014-11-13 | FTUK | Futures | 5106.2 | 5137.1 | 5096.1 | 5130.5 | 92790.0 |
| 2014-11-13 | FVSA | Futures | 1547.19 | 1577.96 | 1516.43 | 1542.8 | 5127.0 |
| 2014-11-13 | FXXP | Futures | 255.1 | 255.6 | 252.9 | 254.5 | 4274.0 |
| 2014-11-13 | G | Futures | 99.04 | 99.38 | 98.89 | 99.27 | 169141.0 |
| 2014-11-13 | GF | Futures | 375.169 | 377.656 | 374.848 | 375.811 | 4171.0 |
| 2014-11-13 | GSCI | Futures | 883.83 | 883.83 | 867.02 | 869.21 | 1973.0 |
| 2014-11-13 | HE | Futures | 122.242 | 124.126 | 121.838 | 122.847 | 26436.0 |
| 2014-11-13 | HG | Futures | 3.8401 | 3.8718 | 3.7824 | 3.7982 | 53744.0 |
| 2014-11-13 | HH | Futures | 49.33 | 49.33 | 47.257 | 47.4 | 4463.0 |
| 2014-11-13 | HO | Futures | 1.9406 | 1.944 | 1.8779 | 1.8805 | 86956.0 |
| 2014-11-13 | HRC | Futures | 2503.7 | 2503.7 | 2503.7 | 2503.7 | 0.0 |
> showing 50 of 102 rows — these rows as CSV