PREVIEW / futures_daily / 2016-04-21
file: by_date/futures_daily/2016/2016-04-21.parquet size: 9 KB rows: 109
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 |
|---|---|---|---|---|---|---|---|
| 2016-04-21 | ES | Futures | 2252.39 | 2259.1 | 2231.99 | 2236.29 | 1638276.0 |
| 2016-04-21 | NQ | Futures | 5326.6 | 5348.34 | 5273.43 | 5284.89 | 239652.0 |
| 2016-04-21 | YM | Futures | 18753.0 | 18798.7 | 18576.2 | 18610.5 | 151053.0 |
| 2016-04-21 | CL | Futures | 52.38 | 53.0 | 51.28 | 51.44 | 671103.0 |
| 2016-04-21 | GC | Futures | 1604.1 | 1640.0 | 1603.9 | 1611.5 | 272941.0 |
| 2016-04-21 | ZN | Futures | 125.343946 | 125.434469 | 124.996942 | 125.147814 | 1397890.0 |
| 2016-04-21 | A6 | Futures | 0.7869 | 0.79126 | 0.78093 | 0.78205 | 118725.0 |
| 2016-04-21 | AD | Futures | 0.80805 | 0.80969 | 0.80192 | 0.80345 | 71047.0 |
| 2016-04-21 | ALI | Futures | 2215.24 | 2215.24 | 2215.24 | 2215.24 | 0.0 |
| 2016-04-21 | B | Futures | 37.93 | 38.46 | 37.01 | 37.09 | 312602.0 |
| 2016-04-21 | B6 | Futures | 1.5094 | 1.5209 | 1.5042 | 1.5086 | 105350.0 |
| 2016-04-21 | BFX | Futures | 4047.1 | 4047.1 | 4015.4 | 4020.1 | 7.0 |
| 2016-04-21 | BR | Futures | 0.18087 | 0.18197 | 0.18025 | 0.18025 | 44.0 |
| 2016-04-21 | BZ | Futures | 37.44 | 38.06 | 36.65 | 36.71 | 35228.0 |
| 2016-04-21 | C | Futures | 2350.0 | 2379.0 | 2346.0 | 2370.0 | 5732.0 |
| 2016-04-21 | CC | Futures | 2253.0 | 2295.0 | 2253.0 | 2273.0 | 22367.0 |
| 2016-04-21 | CNH | Futures | 7.0573 | 7.0634 | 7.0573 | 7.0634 | 296.0 |
| 2016-04-21 | CSC | Futures | 3.603 | 3.603 | 3.558 | 3.572 | 77.0 |
| 2016-04-21 | CT | Futures | 73.49 | 73.81 | 72.07 | 72.92 | 3731.0 |
| 2016-04-21 | DC | Futures | 28.51 | 28.51 | 27.93 | 28.03 | 378.0 |
| 2016-04-21 | DX | Futures | 88.113 | 88.276 | 87.493 | 88.173 | 44400.0 |
| 2016-04-21 | E1 | Futures | 1.29554 | 1.30497 | 1.2909 | 1.29228 | 30669.0 |
| 2016-04-21 | E6 | Futures | 1.31978 | 1.3315 | 1.31628 | 1.31919 | 255261.0 |
| 2016-04-21 | E7 | Futures | 1.3123 | 1.324 | 1.3092 | 1.3121 | 7001.0 |
| 2016-04-21 | EBM | Futures | 200.74 | 202.67 | 193.34 | 197.2 | 41833.0 |
| 2016-04-21 | ED | Futures | 95.7015 | 95.7015 | 95.6919 | 95.6967 | 138359.0 |
| 2016-04-21 | ER | Futures | 98.259 | 98.264 | 98.249 | 98.254 | 69994.0 |
| 2016-04-21 | EW | Futures | 1559.7 | 1563.6 | 1543.1 | 1547.0 | 16066.0 |
| 2016-04-21 | FBON | Futures | 118.19 | 118.26 | 117.65 | 117.96 | 382.0 |
| 2016-04-21 | FBTP | Futures | 106.55 | 106.59 | 105.98 | 106.14 | 111087.0 |
| 2016-04-21 | FBTS | Futures | 100.988 | 100.997 | 100.943 | 100.979 | 20792.0 |
| 2016-04-21 | FCE | Futures | 3859.1 | 3865.0 | 3808.5 | 3837.0 | 96278.0 |
| 2016-04-21 | FDAX | Futures | 11274.3 | 11302.8 | 11140.6 | 11263.0 | 108143.0 |
| 2016-04-21 | FDXM | Futures | 10859.9 | 10882.6 | 10728.5 | 10845.4 | 23269.0 |
| 2016-04-21 | FESX | Futures | 2406.3 | 2413.3 | 2382.9 | 2409.4 | 1362392.0 |
| 2016-04-21 | FEU3 | Futures | 98.912 | 98.912 | 98.907 | 98.907 | 15.0 |
| 2016-04-21 | FGBL | Futures | 145.99 | 146.09 | 145.19 | 145.33 | 984559.0 |
| 2016-04-21 | FGBM | Futures | 127.58 | 127.59 | 127.3 | 127.36 | 556963.0 |
| 2016-04-21 | FGBS | Futures | 111.658 | 111.668 | 111.613 | 111.638 | 294328.0 |
| 2016-04-21 | FGBX | Futures | 172.81 | 172.92 | 170.4 | 170.94 | 52863.0 |
| 2016-04-21 | FMWO | Futures | 5748.4 | 5754.7 | 5741.0 | 5752.2 | 114.0 |
| 2016-04-21 | FOAT | Futures | 133.63 | 133.75 | 132.96 | 133.1 | 119587.0 |
| 2016-04-21 | FTDX | Futures | 1598.5 | 1598.5 | 1561.8 | 1575.2 | 211.0 |
| 2016-04-21 | FTI | Futures | 407.19 | 408.27 | 402.04 | 404.07 | 34058.0 |
| 2016-04-21 | FTUK | Futures | 5256.1 | 5271.0 | 5198.8 | 5233.8 | 123170.0 |
| 2016-04-21 | FVSA | Futures | 2376.84 | 2445.05 | 2366.35 | 2413.57 | 15539.0 |
| 2016-04-21 | FXXP | Futures | 279.0 | 279.2 | 274.9 | 277.1 | 32622.0 |
| 2016-04-21 | G | Futures | 107.84 | 107.86 | 107.16 | 107.34 | 215278.0 |
| 2016-04-21 | GF | Futures | 290.186 | 293.731 | 287.539 | 290.535 | 2938.0 |
| 2016-04-21 | GSCI | Futures | 519.21 | 519.21 | 510.92 | 510.92 | 38.0 |
> showing 50 of 109 rows — these rows as CSV