PREVIEW / futures_daily / 2019-05-14
file: by_date/futures_daily/2019/2019-05-14.parquet size: 10 KB rows: 119
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 |
|---|---|---|---|---|---|---|---|
| 2019-05-14 | ES | Futures | 3030.97 | 3082.55 | 3024.22 | 3066.89 | 1797995.0 |
| 2019-05-14 | NQ | Futures | 8428.67 | 8594.87 | 8399.57 | 8550.51 | 547769.0 |
| 2019-05-14 | YM | Futures | 26682.4 | 27103.5 | 26618.0 | 26990.6 | 250534.0 |
| 2019-05-14 | CL | Futures | 62.67 | 63.92 | 62.47 | 63.59 | 192364.0 |
| 2019-05-14 | GC | Futures | 1619.0 | 1623.2 | 1610.9 | 1613.4 | 222050.0 |
| 2019-05-14 | ZN | Futures | 123.725341 | 123.849657 | 123.569946 | 123.647644 | 1302395.0 |
| 2019-05-14 | A6 | Futures | 0.71621 | 0.71797 | 0.71549 | 0.71632 | 85875.0 |
| 2019-05-14 | AD | Futures | 0.75064 | 0.7519 | 0.75014 | 0.7513 | 55980.0 |
| 2019-05-14 | B | Futures | 51.6 | 52.8 | 51.53 | 52.49 | 299769.0 |
| 2019-05-14 | B6 | Futures | 1.3298 | 1.3309 | 1.3238 | 1.3242 | 83917.0 |
| 2019-05-14 | BR | Futures | 0.19936 | 0.20144 | 0.1992 | 0.2008 | 2832.0 |
| 2019-05-14 | BTC | Futures | 12596.2 | 12967.3 | 11799.7 | 12031.7 | 26372.0 |
| 2019-05-14 | BZ | Futures | 51.43 | 52.65 | 51.39 | 52.35 | 57905.0 |
| 2019-05-14 | C | Futures | 1648.0 | 1683.0 | 1628.0 | 1631.0 | 12534.0 |
| 2019-05-14 | CB | Futures | 281.115 | 281.115 | 280.727 | 281.115 | 35.0 |
| 2019-05-14 | CC | Futures | 1541.0 | 1566.0 | 1537.0 | 1544.0 | 17138.0 |
| 2019-05-14 | CNH | Futures | 6.9335 | 6.9375 | 6.9052 | 6.9199 | 1141.0 |
| 2019-05-14 | CSC | Futures | 2.977 | 2.985 | 2.962 | 2.966 | 109.0 |
| 2019-05-14 | CT | Futures | 68.93 | 70.29 | 67.52 | 69.88 | 28629.0 |
| 2019-05-14 | DC | Futures | 24.68 | 24.87 | 24.64 | 24.8 | 163.0 |
| 2019-05-14 | DX | Futures | 93.086 | 93.321 | 93.048 | 93.285 | 9001.0 |
| 2019-05-14 | E1 | Futures | 1.16399 | 1.16469 | 1.15944 | 1.15979 | 22294.0 |
| 2019-05-14 | E6 | Futures | 1.23541 | 1.2375 | 1.23283 | 1.23349 | 161357.0 |
| 2019-05-14 | E7 | Futures | 1.2294 | 1.2314 | 1.2266 | 1.2274 | 2815.0 |
| 2019-05-14 | EBM | Futures | 195.76 | 197.78 | 195.19 | 196.34 | 22522.0 |
| 2019-05-14 | ED | Futures | 95.2136 | 95.221 | 95.2014 | 95.2063 | 256687.0 |
| 2019-05-14 | ER | Futures | 98.411 | 98.421 | 98.411 | 98.421 | 101131.0 |
| 2019-05-14 | EW | Futures | 1987.2 | 2021.7 | 1982.3 | 2013.0 | 14741.0 |
| 2019-05-14 | FBON | Futures | 136.56 | 136.75 | 136.35 | 136.64 | 736.0 |
| 2019-05-14 | FBTP | Futures | 114.67 | 114.91 | 114.23 | 114.49 | 146799.0 |
| 2019-05-14 | FBTS | Futures | 105.598 | 105.646 | 105.408 | 105.484 | 97454.0 |
| 2019-05-14 | FCE | Futures | 4734.9 | 4803.9 | 4734.9 | 4791.2 | 189974.0 |
| 2019-05-14 | FDAX | Futures | 12464.8 | 12655.9 | 12460.6 | 12608.0 | 106686.0 |
| 2019-05-14 | FDIV | Futures | 143.59 | 143.91 | 143.59 | 143.91 | 161.0 |
| 2019-05-14 | FDXM | Futures | 12371.9 | 12547.2 | 12353.1 | 12498.7 | 42375.0 |
| 2019-05-14 | FESX | Futures | 2866.6 | 2919.1 | 2865.8 | 2906.0 | 1092665.0 |
| 2019-05-14 | FGBL | Futures | 160.71 | 160.91 | 160.51 | 160.78 | 584456.0 |
| 2019-05-14 | FGBM | Futures | 133.37 | 133.48 | 133.3 | 133.44 | 332551.0 |
| 2019-05-14 | FGBS | Futures | 112.834 | 112.88 | 112.829 | 112.865 | 294945.0 |
| 2019-05-14 | FGBX | Futures | 196.25 | 196.9 | 195.67 | 196.59 | 51277.0 |
| 2019-05-14 | FMWO | Futures | 6981.2 | 7075.0 | 6981.2 | 7062.2 | 2053.0 |
| 2019-05-14 | FOAT | Futures | 147.13 | 147.39 | 147.06 | 147.29 | 104213.0 |
| 2019-05-14 | FTDX | Futures | 2723.4 | 2768.8 | 2723.4 | 2764.4 | 242.0 |
| 2019-05-14 | FTI | Futures | 513.01 | 519.04 | 512.06 | 517.66 | 37060.0 |
| 2019-05-14 | FTUK | Futures | 6511.5 | 6623.8 | 6506.9 | 6599.1 | 99862.0 |
| 2019-05-14 | FVSA | Futures | 248.06 | 249.49 | 235.95 | 239.51 | 36859.0 |
| 2019-05-14 | FXXP | Futures | 332.0 | 335.2 | 331.7 | 334.2 | 94478.0 |
| 2019-05-14 | G | Futures | 118.21 | 118.41 | 118.06 | 118.31 | 228813.0 |
| 2019-05-14 | GF | Futures | 281.8 | 284.695 | 278.513 | 279.642 | 7546.0 |
| 2019-05-14 | GSCI | Futures | 493.46 | 494.7 | 493.46 | 494.59 | 452.0 |
> showing 50 of 119 rows — these rows as CSV