PREVIEW / futures_daily / 2018-08-10
file: by_date/futures_daily/2018/2018-08-10.parquet size: 10 KB rows: 114
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-08-10 | ES | Futures | 3098.09 | 3098.37 | 3069.31 | 3080.99 | 1416182.0 |
| 2018-08-10 | NQ | Futures | 8711.91 | 8712.49 | 8616.89 | 8659.15 | 389778.0 |
| 2018-08-10 | YM | Futures | 26846.0 | 26858.6 | 26568.9 | 26691.1 | 174863.0 |
| 2018-08-10 | CL | Futures | 69.05 | 70.22 | 68.43 | 69.97 | 524490.0 |
| 2018-08-10 | GC | Futures | 1546.3 | 1552.5 | 1537.5 | 1545.0 | 328240.0 |
| 2018-08-10 | ZN | Futures | 119.090523 | 119.743159 | 119.074985 | 119.712082 | 2336406.0 |
| 2018-08-10 | A6 | Futures | 0.75894 | 0.75894 | 0.74886 | 0.74989 | 177090.0 |
| 2018-08-10 | AD | Futures | 0.77685 | 0.77746 | 0.77042 | 0.77138 | 89130.0 |
| 2018-08-10 | B | Futures | 52.46 | 53.32 | 52.05 | 53.08 | 228741.0 |
| 2018-08-10 | B6 | Futures | 1.3252 | 1.3262 | 1.3144 | 1.3184 | 143024.0 |
| 2018-08-10 | BR | Futures | 0.19984 | 0.19999 | 0.19603 | 0.1963 | 5214.0 |
| 2018-08-10 | BTC | Futures | 9338.2 | 9409.5 | 8697.2 | 9103.2 | 6444.0 |
| 2018-08-10 | BZ | Futures | 52.41 | 53.24 | 51.98 | 53.0 | 16195.0 |
| 2018-08-10 | C | Futures | 1464.0 | 1481.0 | 1460.0 | 1472.0 | 4330.0 |
| 2018-08-10 | CB | Futures | 281.817 | 282.717 | 281.817 | 282.567 | 44.0 |
| 2018-08-10 | CC | Futures | 1481.0 | 1495.0 | 1472.0 | 1479.0 | 23864.0 |
| 2018-08-10 | CNH | Futures | 6.9184 | 6.9475 | 6.9123 | 6.9412 | 623.0 |
| 2018-08-10 | CSC | Futures | 3.284 | 3.317 | 3.284 | 3.301 | 152.0 |
| 2018-08-10 | CT | Futures | 98.36 | 98.54 | 95.96 | 96.34 | 62.0 |
| 2018-08-10 | DC | Futures | 26.74 | 26.99 | 26.68 | 26.88 | 457.0 |
| 2018-08-10 | DX | Futures | 90.429 | 91.215 | 90.339 | 91.128 | 43148.0 |
| 2018-08-10 | E1 | Futures | 1.20612 | 1.20719 | 1.20134 | 1.20457 | 42501.0 |
| 2018-08-10 | E6 | Futures | 1.29256 | 1.29351 | 1.27684 | 1.27818 | 453203.0 |
| 2018-08-10 | E7 | Futures | 1.286 | 1.2868 | 1.2703 | 1.2717 | 7073.0 |
| 2018-08-10 | EBM | Futures | 220.22 | 224.4 | 217.87 | 220.48 | 14033.0 |
| 2018-08-10 | ED | Futures | 95.0497 | 95.0692 | 95.0448 | 95.0692 | 433626.0 |
| 2018-08-10 | ER | Futures | 98.357 | 98.362 | 98.352 | 98.357 | 139200.0 |
| 2018-08-10 | EW | Futures | 2126.8 | 2127.0 | 2110.3 | 2114.6 | 9105.0 |
| 2018-08-10 | FBON | Futures | 129.73 | 129.73 | 128.76 | 129.15 | 141.0 |
| 2018-08-10 | FBTP | Futures | 106.05 | 106.22 | 105.15 | 105.39 | 67194.0 |
| 2018-08-10 | FBTS | Futures | 102.021 | 102.179 | 101.715 | 101.863 | 51525.0 |
| 2018-08-10 | FCE | Futures | 4919.5 | 4919.5 | 4834.3 | 4856.7 | 104290.0 |
| 2018-08-10 | FDAX | Futures | 13170.2 | 13194.2 | 12938.6 | 12974.2 | 112722.0 |
| 2018-08-10 | FDXM | Futures | 13004.0 | 13026.7 | 12773.8 | 12808.4 | 58150.0 |
| 2018-08-10 | FESX | Futures | 2904.0 | 2906.5 | 2848.0 | 2857.2 | 1413817.0 |
| 2018-08-10 | FEU3 | Futures | 99.006 | 99.006 | 99.006 | 99.006 | 1.0 |
| 2018-08-10 | FGBL | Futures | 153.3 | 154.01 | 153.3 | 153.91 | 754598.0 |
| 2018-08-10 | FGBM | Futures | 131.17 | 131.45 | 131.17 | 131.41 | 372931.0 |
| 2018-08-10 | FGBS | Futures | 112.673 | 112.729 | 112.673 | 112.718 | 366950.0 |
| 2018-08-10 | FGBX | Futures | 177.84 | 179.98 | 177.84 | 179.6 | 37846.0 |
| 2018-08-10 | FMWO | Futures | 7156.8 | 7156.8 | 7121.8 | 7130.0 | 1330.0 |
| 2018-08-10 | FOAT | Futures | 140.77 | 141.24 | 140.77 | 141.19 | 96979.0 |
| 2018-08-10 | FTDX | Futures | 2886.3 | 2886.3 | 2845.6 | 2860.3 | 206.0 |
| 2018-08-10 | FTI | Futures | 528.64 | 528.64 | 519.37 | 521.55 | 790.0 |
| 2018-08-10 | FTUK | Futures | 6889.6 | 6889.6 | 6800.9 | 6811.2 | 97547.0 |
| 2018-08-10 | FVSA | Futures | 257.96 | 281.84 | 257.96 | 276.11 | 58909.0 |
| 2018-08-10 | FXXP | Futures | 336.0 | 336.4 | 332.5 | 333.0 | 67736.0 |
| 2018-08-10 | G | Futures | 115.82 | 115.99 | 115.7 | 115.93 | 174196.0 |
| 2018-08-10 | GF | Futures | 309.389 | 311.417 | 307.257 | 311.053 | 6020.0 |
| 2018-08-10 | GSCI | Futures | 515.59 | 517.56 | 515.59 | 516.32 | 2450.0 |
> showing 50 of 114 rows — these rows as CSV