PREVIEW / futures_daily / 2018-12-04
file: by_date/futures_daily/2018/2018-12-04.parquet size: 10 KB rows: 115
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-04 | ES | Futures | 3025.52 | 3026.33 | 2923.84 | 2930.08 | 2709938.0 |
| 2018-12-04 | NQ | Futures | 8194.85 | 8194.85 | 7878.63 | 7902.15 | 811925.0 |
| 2018-12-04 | YM | Futures | 27210.6 | 27210.6 | 26325.0 | 26374.5 | 333857.0 |
| 2018-12-04 | CL | Futures | 56.21 | 57.72 | 55.47 | 56.34 | 738130.0 |
| 2018-12-04 | GC | Futures | 1557.7 | 1571.9 | 1557.1 | 1570.7 | 221135.0 |
| 2018-12-04 | ZN | Futures | 119.386153 | 119.853053 | 119.308337 | 119.619603 | 135343.0 |
| 2018-12-04 | A6 | Futures | 0.7572 | 0.76091 | 0.75401 | 0.75525 | 95336.0 |
| 2018-12-04 | AD | Futures | 0.76642 | 0.76834 | 0.76238 | 0.76349 | 90140.0 |
| 2018-12-04 | B | Futures | 45.45 | 46.68 | 44.97 | 45.58 | 277419.0 |
| 2018-12-04 | B6 | Futures | 1.3098 | 1.3214 | 1.3025 | 1.3085 | 158299.0 |
| 2018-12-04 | BTC | Futures | 5958.4 | 6126.3 | 5630.4 | 5859.3 | 3059.0 |
| 2018-12-04 | BZ | Futures | 44.84 | 46.07 | 44.39 | 45.0 | 35475.0 |
| 2018-12-04 | C | Futures | 1457.0 | 1466.0 | 1442.0 | 1452.0 | 2352.0 |
| 2018-12-04 | CB | Futures | 272.714 | 272.714 | 269.099 | 270.648 | 117.0 |
| 2018-12-04 | CC | Futures | 1518.0 | 1526.0 | 1494.0 | 1507.0 | 15229.0 |
| 2018-12-04 | CNH | Futures | 6.9139 | 6.9199 | 6.8632 | 6.8812 | 1149.0 |
| 2018-12-04 | CSC | Futures | 2.898 | 2.898 | 2.868 | 2.871 | 150.0 |
| 2018-12-04 | CT | Futures | 86.71 | 87.56 | 86.4 | 86.94 | 14512.0 |
| 2018-12-04 | DC | Futures | 24.29 | 24.29 | 24.12 | 24.13 | 226.0 |
| 2018-12-04 | DX | Futures | 92.044 | 92.215 | 91.483 | 92.055 | 25708.0 |
| 2018-12-04 | E1 | Futures | 1.18892 | 1.19485 | 1.1875 | 1.18952 | 19388.0 |
| 2018-12-04 | E6 | Futures | 1.26377 | 1.27088 | 1.2596 | 1.26227 | 252191.0 |
| 2018-12-04 | E7 | Futures | 1.2575 | 1.2647 | 1.2535 | 1.2561 | 4276.0 |
| 2018-12-04 | EBM | Futures | 209.5 | 210.27 | 208.2 | 208.46 | 2936.0 |
| 2018-12-04 | ED | Futures | 94.9206 | 94.9401 | 94.9133 | 94.9279 | 435433.0 |
| 2018-12-04 | ER | Futures | 98.391 | 98.391 | 98.386 | 98.391 | 62011.0 |
| 2018-12-04 | EW | Futures | 1990.2 | 1993.1 | 1917.7 | 1920.1 | 27700.0 |
| 2018-12-04 | FBON | Futures | 128.75 | 128.82 | 128.54 | 128.75 | 2429.0 |
| 2018-12-04 | FBTP | Futures | 108.09 | 108.11 | 107.48 | 107.75 | 195937.0 |
| 2018-12-04 | FBTS | Futures | 103.988 | 104.026 | 103.876 | 103.979 | 111462.0 |
| 2018-12-04 | FCE | Futures | 4503.1 | 4508.1 | 4405.6 | 4479.0 | 88345.0 |
| 2018-12-04 | FDAX | Futures | 12013.2 | 12030.6 | 11719.3 | 11911.8 | 118854.0 |
| 2018-12-04 | FDIV | Futures | 139.39 | 139.39 | 138.5 | 138.5 | 31.0 |
| 2018-12-04 | FDXM | Futures | 11800.5 | 11822.2 | 11514.3 | 11705.5 | 54882.0 |
| 2018-12-04 | FESX | Futures | 2689.9 | 2693.2 | 2631.0 | 2674.7 | 1259092.0 |
| 2018-12-04 | FEU3 | Futures | 99.011 | 99.016 | 99.011 | 99.016 | 115.0 |
| 2018-12-04 | FGBL | Futures | 154.95 | 155.45 | 154.66 | 155.12 | 1920328.0 |
| 2018-12-04 | FGBM | Futures | 131.77 | 131.95 | 131.69 | 131.82 | 1403915.0 |
| 2018-12-04 | FGBS | Futures | 112.764 | 112.794 | 112.749 | 112.764 | 1083484.0 |
| 2018-12-04 | FGBX | Futures | 181.33 | 183.47 | 180.72 | 182.24 | 207308.0 |
| 2018-12-04 | FMWO | Futures | 6830.3 | 6863.9 | 6677.4 | 6822.2 | 3605.0 |
| 2018-12-04 | FOAT | Futures | 141.67 | 141.86 | 141.39 | 141.73 | 387968.0 |
| 2018-12-04 | FTDX | Futures | 2582.8 | 2597.5 | 2533.7 | 2573.0 | 120.0 |
| 2018-12-04 | FTI | Futures | 485.71 | 487.38 | 478.66 | 485.45 | 24536.0 |
| 2018-12-04 | FTUK | Futures | 6331.8 | 6345.2 | 6190.2 | 6284.5 | 124533.0 |
| 2018-12-04 | FVSA | Futures | 321.55 | 349.77 | 316.51 | 317.52 | 30704.0 |
| 2018-12-04 | FXXP | Futures | 311.4 | 312.6 | 306.0 | 310.4 | 49256.0 |
| 2018-12-04 | G | Futures | 116.85 | 117.07 | 116.34 | 116.79 | 302836.0 |
| 2018-12-04 | GF | Futures | 311.051 | 312.827 | 308.091 | 310.836 | 7162.0 |
| 2018-12-04 | GSCI | Futures | 471.82 | 472.94 | 469.61 | 470.07 | 10.0 |
> showing 50 of 115 rows — these rows as CSV