PREVIEW / futures_daily / 2018-12-12
file: by_date/futures_daily/2018/2018-12-12.parquet size: 10 KB rows: 112
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 |
|---|---|---|---|---|---|---|---|
| 2018-12-12 | ES | Futures | 2854.98 | 2913.54 | 2854.16 | 2876.67 | 1900862.0 |
| 2018-12-12 | NQ | Futures | 7766.54 | 7982.01 | 7763.06 | 7862.37 | 663375.0 |
| 2018-12-12 | YM | Futures | 25687.9 | 26221.6 | 25687.9 | 25927.3 | 9534.0 |
| 2018-12-12 | CL | Futures | 54.96 | 55.95 | 53.9 | 54.12 | 730810.0 |
| 2018-12-12 | GC | Futures | 1572.9 | 1578.3 | 1571.3 | 1575.0 | 157070.0 |
| 2018-12-12 | ZN | Futures | 119.946477 | 119.993161 | 119.650812 | 119.74418 | 1513971.0 |
| 2018-12-12 | A6 | Futures | 0.7428 | 0.74651 | 0.7428 | 0.74466 | 72426.0 |
| 2018-12-12 | AD | Futures | 0.75767 | 0.76162 | 0.75767 | 0.75995 | 61995.0 |
| 2018-12-12 | B | Futures | 44.55 | 45.1 | 44.04 | 44.16 | 246916.0 |
| 2018-12-12 | B6 | Futures | 1.2889 | 1.3076 | 1.2876 | 1.3038 | 85542.0 |
| 2018-12-12 | BR | Futures | 0.20567 | 0.20635 | 0.20567 | 0.20635 | 57.0 |
| 2018-12-12 | BTC | Futures | 5104.0 | 5294.7 | 5042.9 | 5218.4 | 2665.0 |
| 2018-12-12 | BZ | Futures | 43.86 | 44.52 | 43.48 | 43.6 | 31651.0 |
| 2018-12-12 | C | Futures | 1395.0 | 1433.0 | 1391.0 | 1413.0 | 16120.0 |
| 2018-12-12 | CB | Futures | 266.062 | 266.67 | 266.062 | 266.67 | 3.0 |
| 2018-12-12 | CC | Futures | 1463.0 | 1516.0 | 1457.0 | 1490.0 | 19224.0 |
| 2018-12-12 | CNH | Futures | 6.9144 | 6.9157 | 6.8932 | 6.8932 | 143.0 |
| 2018-12-12 | CSC | Futures | 2.866 | 2.877 | 2.853 | 2.866 | 84.0 |
| 2018-12-12 | CT | Futures | 87.3 | 87.47 | 86.68 | 87.11 | 9776.0 |
| 2018-12-12 | DC | Futures | 24.02 | 24.16 | 24.0 | 24.1 | 241.0 |
| 2018-12-12 | DX | Futures | 92.351 | 92.456 | 91.875 | 92.035 | 19383.0 |
| 2018-12-12 | E1 | Futures | 1.19547 | 1.19735 | 1.19112 | 1.19559 | 44626.0 |
| 2018-12-12 | E6 | Futures | 1.26149 | 1.269 | 1.26099 | 1.26668 | 185219.0 |
| 2018-12-12 | E7 | Futures | 1.2557 | 1.2626 | 1.2549 | 1.2605 | 7427.0 |
| 2018-12-12 | EBM | Futures | 210.51 | 212.57 | 210.51 | 212.05 | 34111.0 |
| 2018-12-12 | ED | Futures | 94.9207 | 94.9256 | 94.9061 | 94.9109 | 263354.0 |
| 2018-12-12 | ER | Futures | 98.386 | 98.391 | 98.381 | 98.391 | 64256.0 |
| 2018-12-12 | EW | Futures | 1898.1 | 1917.2 | 1896.6 | 1897.2 | 1404.0 |
| 2018-12-12 | FBON | Futures | 129.16 | 129.78 | 129.16 | 129.43 | 514.0 |
| 2018-12-12 | FBTP | Futures | 108.29 | 109.6 | 108.29 | 109.28 | 83364.0 |
| 2018-12-12 | FBTS | Futures | 103.865 | 104.575 | 103.856 | 104.13 | 70999.0 |
| 2018-12-12 | FCE | Futures | 4295.0 | 4364.3 | 4283.5 | 4350.5 | 5669.0 |
| 2018-12-12 | FDAX | Futures | 11369.2 | 11535.3 | 11369.2 | 11512.2 | 109780.0 |
| 2018-12-12 | FDXM | Futures | 11374.0 | 11489.3 | 11330.0 | 11468.9 | 265.0 |
| 2018-12-12 | FESX | Futures | 2600.5 | 2653.4 | 2600.5 | 2646.6 | 230329.0 |
| 2018-12-12 | FEU3 | Futures | 98.981 | 98.986 | 98.981 | 98.986 | 310.0 |
| 2018-12-12 | FGBL | Futures | 155.31 | 155.48 | 154.6 | 154.96 | 708588.0 |
| 2018-12-12 | FGBM | Futures | 131.73 | 131.76 | 131.38 | 131.51 | 410072.0 |
| 2018-12-12 | FGBS | Futures | 112.668 | 112.698 | 112.603 | 112.633 | 322900.0 |
| 2018-12-12 | FGBX | Futures | 184.57 | 184.87 | 183.17 | 184.2 | 59828.0 |
| 2018-12-12 | FMWO | Futures | 6538.4 | 6641.5 | 6538.4 | 6621.8 | 8418.0 |
| 2018-12-12 | FOAT | Futures | 141.07 | 141.42 | 140.83 | 141.07 | 148022.0 |
| 2018-12-12 | FTDX | Futures | 2534.4 | 2549.8 | 2534.4 | 2549.8 | 30.0 |
| 2018-12-12 | FTI | Futures | 472.11 | 478.71 | 471.97 | 476.79 | 377.0 |
| 2018-12-12 | FTUK | Futures | 6188.8 | 6225.3 | 6160.1 | 6215.2 | 23874.0 |
| 2018-12-12 | FVSA | Futures | 403.2 | 404.21 | 395.07 | 396.09 | 21589.0 |
| 2018-12-12 | FXXP | Futures | 301.2 | 306.1 | 301.1 | 305.7 | 8179.0 |
| 2018-12-12 | G | Futures | 117.76 | 117.83 | 116.84 | 116.97 | 259714.0 |
| 2018-12-12 | GF | Futures | 317.509 | 318.962 | 316.486 | 317.67 | 5928.0 |
| 2018-12-12 | GSCI | Futures | 470.31 | 472.13 | 464.84 | 464.84 | 4412.0 |
> showing 50 of 112 rows — these rows as CSV