PREVIEW / futures_daily / 2015-01-08
file: by_date/futures_daily/2015/2015-01-08.parquet size: 9 KB rows: 107
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 |
|---|---|---|---|---|---|---|---|
| 2015-01-08 | ES | Futures | 2117.74 | 2157.57 | 2117.48 | 2153.9 | 1555733.0 |
| 2015-01-08 | NQ | Futures | 4817.82 | 4922.83 | 4817.82 | 4910.64 | 272056.0 |
| 2015-01-08 | YM | Futures | 17838.6 | 18175.7 | 17837.6 | 18149.2 | 151625.0 |
| 2015-01-08 | CL | Futures | 95.54 | 97.24 | 93.48 | 95.56 | 362081.0 |
| 2015-01-08 | GC | Futures | 1585.1 | 1592.7 | 1576.2 | 1581.8 | 122494.0 |
| 2015-01-08 | ZN | Futures | 120.894703 | 120.95359 | 120.570825 | 120.703321 | 941743.0 |
| 2015-01-08 | A6 | Futures | 0.78729 | 0.79278 | 0.7871 | 0.79053 | 74891.0 |
| 2015-01-08 | AD | Futures | 0.86047 | 0.862 | 0.85863 | 0.85884 | 43916.0 |
| 2015-01-08 | ALI | Futures | 2814.94 | 2814.94 | 2814.94 | 2814.94 | 0.0 |
| 2015-01-08 | B | Futures | 53.19 | 54.05 | 51.98 | 53.13 | 220316.0 |
| 2015-01-08 | B6 | Futures | 1.5873 | 1.5888 | 1.58 | 1.5851 | 79683.0 |
| 2015-01-08 | BFX | Futures | 3926.7 | 3978.2 | 3926.7 | 3978.2 | 4.0 |
| 2015-01-08 | BR | Futures | 0.20436 | 0.20439 | 0.20367 | 0.20389 | 70.0 |
| 2015-01-08 | BZ | Futures | 53.76 | 54.3 | 52.29 | 53.42 | 26317.0 |
| 2015-01-08 | C | Futures | 2205.0 | 2249.0 | 2205.0 | 2233.0 | 12922.0 |
| 2015-01-08 | CB | Futures | 132.263 | 133.495 | 132.263 | 133.495 | 41.0 |
| 2015-01-08 | CC | Futures | 2153.0 | 2226.0 | 2148.0 | 2204.0 | 24026.0 |
| 2015-01-08 | CNH | Futures | 7.1178 | 7.1201 | 7.1109 | 7.1121 | 92.0 |
| 2015-01-08 | CSC | Futures | 4.475 | 4.478 | 4.404 | 4.415 | 126.0 |
| 2015-01-08 | CT | Futures | 77.18 | 77.45 | 76.89 | 77.35 | 8178.0 |
| 2015-01-08 | DC | Futures | 35.04 | 35.53 | 34.62 | 34.67 | 467.0 |
| 2015-01-08 | DX | Futures | 87.307 | 87.804 | 87.293 | 87.654 | 28010.0 |
| 2015-01-08 | E1 | Futures | 1.25968 | 1.26108 | 1.25125 | 1.25406 | 35684.0 |
| 2015-01-08 | E6 | Futures | 1.39292 | 1.39433 | 1.38339 | 1.3868 | 268955.0 |
| 2015-01-08 | E7 | Futures | 1.3845 | 1.386 | 1.3751 | 1.3785 | 5455.0 |
| 2015-01-08 | EBM | Futures | 324.41 | 325.63 | 318.74 | 319.14 | 23427.0 |
| 2015-01-08 | ED | Futures | 95.4498 | 95.4498 | 95.445 | 95.4498 | 99169.0 |
| 2015-01-08 | ER | Futures | 98.028 | 98.033 | 98.023 | 98.023 | 21241.0 |
| 2015-01-08 | EW | Futures | 1492.5 | 1517.8 | 1492.0 | 1516.2 | 19862.0 |
| 2015-01-08 | FBTP | Futures | 98.73 | 99.22 | 98.47 | 99.09 | 78767.0 |
| 2015-01-08 | FBTS | Futures | 98.739 | 98.792 | 98.632 | 98.757 | 24581.0 |
| 2015-01-08 | FCE | Futures | 3401.1 | 3486.0 | 3396.6 | 3478.6 | 152486.0 |
| 2015-01-08 | FDAX | Futures | 10722.2 | 10949.8 | 10672.3 | 10935.4 | 132708.0 |
| 2015-01-08 | FESX | Futures | 2214.1 | 2260.2 | 2200.4 | 2256.6 | 1340795.0 |
| 2015-01-08 | FEU3 | Futures | 98.645 | 98.645 | 98.645 | 98.645 | 1.0 |
| 2015-01-08 | FGBL | Futures | 137.12 | 137.24 | 136.82 | 136.88 | 676326.0 |
| 2015-01-08 | FGBM | Futures | 123.88 | 123.92 | 123.83 | 123.86 | 303476.0 |
| 2015-01-08 | FGBS | Futures | 110.993 | 111.003 | 110.978 | 110.988 | 169078.0 |
| 2015-01-08 | FGBX | Futures | 159.5 | 160.06 | 157.7 | 158.1 | 34760.0 |
| 2015-01-08 | FMWO | Futures | 5512.3 | 5576.6 | 5511.1 | 5575.4 | 1487.0 |
| 2015-01-08 | FOAT | Futures | 126.1 | 126.21 | 125.87 | 126.0 | 115067.0 |
| 2015-01-08 | FTDX | Futures | 1294.7 | 1326.1 | 1294.7 | 1325.2 | 174.0 |
| 2015-01-08 | FTI | Futures | 360.74 | 367.4 | 359.61 | 366.19 | 42965.0 |
| 2015-01-08 | FTUK | Futures | 5007.2 | 5082.0 | 4998.2 | 5074.2 | 105757.0 |
| 2015-01-08 | FVSA | Futures | 2048.37 | 2048.37 | 1978.54 | 1994.06 | 10472.0 |
| 2015-01-08 | FXXP | Futures | 254.0 | 258.3 | 253.3 | 258.0 | 10770.0 |
| 2015-01-08 | G | Futures | 104.33 | 104.38 | 103.93 | 104.01 | 153913.0 |
| 2015-01-08 | GF | Futures | 362.935 | 366.625 | 358.804 | 362.013 | 3452.0 |
| 2015-01-08 | GSCI | Futures | 680.21 | 680.21 | 669.64 | 675.43 | 2372.0 |
| 2015-01-08 | HE | Futures | 106.218 | 106.922 | 104.474 | 104.876 | 25931.0 |
> showing 50 of 107 rows — these rows as CSV