PREVIEW / futures_daily / 2018-09-13
file: by_date/futures_daily/2018/2018-09-13.parquet size: 10 KB rows: 111
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-09-13 | ES | Futures | 3135.56 | 3157.29 | 3133.12 | 3155.39 | 1641192.0 |
| 2018-09-13 | NQ | Futures | 8724.74 | 8841.33 | 8709.29 | 8819.47 | 459821.0 |
| 2018-09-13 | YM | Futures | 27394.9 | 27615.0 | 27381.2 | 27572.9 | 28550.0 |
| 2018-09-13 | CL | Futures | 73.3 | 73.32 | 71.35 | 71.61 | 247837.0 |
| 2018-09-13 | GC | Futures | 1536.6 | 1543.7 | 1527.2 | 1531.3 | 304352.0 |
| 2018-09-13 | ZN | Futures | 118.965944 | 119.121577 | 118.794748 | 118.950381 | 1564325.0 |
| 2018-09-13 | A6 | Futures | 0.73827 | 0.74414 | 0.73786 | 0.74054 | 81866.0 |
| 2018-09-13 | AD | Futures | 0.77952 | 0.78063 | 0.7777 | 0.77982 | 57369.0 |
| 2018-09-13 | B | Futures | 58.02 | 58.1 | 56.76 | 56.98 | 298144.0 |
| 2018-09-13 | B6 | Futures | 1.3473 | 1.3552 | 1.3451 | 1.3539 | 166899.0 |
| 2018-09-13 | BR | Futures | 0.1811 | 0.1811 | 0.18037 | 0.18052 | 19.0 |
| 2018-09-13 | BTC | Futures | 9003.0 | 9331.9 | 9003.0 | 9203.2 | 2350.0 |
| 2018-09-13 | BZ | Futures | 57.89 | 57.89 | 56.51 | 56.74 | 28501.0 |
| 2018-09-13 | C | Futures | 1527.0 | 1534.0 | 1506.0 | 1512.0 | 11600.0 |
| 2018-09-13 | CB | Futures | 262.735 | 264.358 | 262.405 | 264.358 | 22.0 |
| 2018-09-13 | CC | Futures | 1624.0 | 1632.0 | 1600.0 | 1617.0 | 17215.0 |
| 2018-09-13 | CNH | Futures | 6.9052 | 6.9185 | 6.8859 | 6.8981 | 980.0 |
| 2018-09-13 | CSC | Futures | 3.254 | 3.266 | 3.254 | 3.254 | 55.0 |
| 2018-09-13 | CT | Futures | 92.21 | 92.23 | 91.58 | 91.58 | 60.0 |
| 2018-09-13 | DC | Futures | 26.89 | 26.91 | 26.73 | 26.78 | 62.0 |
| 2018-09-13 | DX | Futures | 89.721 | 89.816 | 89.284 | 89.39 | 33068.0 |
| 2018-09-13 | E1 | Futures | 1.23136 | 1.23799 | 1.23124 | 1.23728 | 27452.0 |
| 2018-09-13 | E6 | Futures | 1.3024 | 1.31041 | 1.30001 | 1.3093 | 295472.0 |
| 2018-09-13 | E7 | Futures | 1.2961 | 1.3038 | 1.2936 | 1.3029 | 7348.0 |
| 2018-09-13 | EBM | Futures | 206.12 | 206.38 | 203.52 | 204.56 | 34344.0 |
| 2018-09-13 | ED | Futures | 95.0769 | 95.0964 | 95.072 | 95.0915 | 491381.0 |
| 2018-09-13 | ER | Futures | 98.372 | 98.377 | 98.372 | 98.377 | 42620.0 |
| 2018-09-13 | EW | Futures | 2147.2 | 2157.6 | 2145.2 | 2151.4 | 10902.0 |
| 2018-09-13 | FBON | Futures | 128.44 | 128.54 | 128.32 | 128.38 | 332.0 |
| 2018-09-13 | FBTP | Futures | 107.64 | 108.16 | 107.4 | 107.98 | 92876.0 |
| 2018-09-13 | FBTS | Futures | 102.93 | 103.108 | 102.808 | 102.977 | 55230.0 |
| 2018-09-13 | FCE | Futures | 4785.1 | 4818.0 | 4781.0 | 4792.3 | 11893.0 |
| 2018-09-13 | FDAX | Futures | 12546.6 | 12677.8 | 12543.0 | 12602.5 | 96217.0 |
| 2018-09-13 | FDXM | Futures | 12388.5 | 12517.6 | 12388.5 | 12442.2 | 976.0 |
| 2018-09-13 | FESX | Futures | 2773.9 | 2803.3 | 2770.5 | 2786.5 | 325067.0 |
| 2018-09-13 | FGBL | Futures | 152.85 | 152.91 | 152.42 | 152.61 | 677082.0 |
| 2018-09-13 | FGBM | Futures | 130.86 | 130.89 | 130.7 | 130.77 | 446413.0 |
| 2018-09-13 | FGBS | Futures | 112.573 | 112.588 | 112.542 | 112.562 | 350023.0 |
| 2018-09-13 | FGBX | Futures | 176.34 | 176.46 | 175.21 | 175.78 | 37638.0 |
| 2018-09-13 | FMWO | Futures | 7176.6 | 7223.2 | 7176.6 | 7198.7 | 6897.0 |
| 2018-09-13 | FOAT | Futures | 140.79 | 140.79 | 140.37 | 140.52 | 141310.0 |
| 2018-09-13 | FTDX | Futures | 2859.3 | 2859.3 | 2823.4 | 2823.4 | 429.0 |
| 2018-09-13 | FTI | Futures | 502.48 | 502.85 | 499.79 | 500.39 | 2245.0 |
| 2018-09-13 | FTUK | Futures | 6495.4 | 6506.1 | 6468.1 | 6471.2 | 54383.0 |
| 2018-09-13 | FVSA | Futures | 270.88 | 270.88 | 263.11 | 265.7 | 16370.0 |
| 2018-09-13 | FXXP | Futures | 325.9 | 326.3 | 324.6 | 324.7 | 10972.0 |
| 2018-09-13 | G | Futures | 114.55 | 114.66 | 114.24 | 114.43 | 255112.0 |
| 2018-09-13 | GF | Futures | 322.235 | 323.691 | 320.571 | 323.275 | 7127.0 |
| 2018-09-13 | GSCI | Futures | 524.96 | 525.58 | 520.2 | 520.87 | 2348.0 |
| 2018-09-13 | HE | Futures | 75.628 | 75.763 | 74.003 | 75.391 | 31385.0 |
> showing 50 of 111 rows — these rows as CSV