PREVIEW / futures_daily / 2018-12-18
file: by_date/futures_daily/2018/2018-12-18.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-18 | ES | Futures | 2768.66 | 2790.85 | 2739.15 | 2747.82 | 2700902.0 |
| 2018-12-18 | NQ | Futures | 7521.35 | 7615.12 | 7475.61 | 7506.58 | 646315.0 |
| 2018-12-18 | YM | Futures | 25001.2 | 25260.7 | 24821.9 | 24902.1 | 301191.0 |
| 2018-12-18 | CL | Futures | 51.88 | 52.34 | 48.36 | 48.88 | 949316.0 |
| 2018-12-18 | GC | Futures | 1574.6 | 1580.7 | 1573.7 | 1579.5 | 171587.0 |
| 2018-12-18 | ZN | Futures | 120.148774 | 120.444438 | 120.117651 | 120.366632 | 1636749.0 |
| 2018-12-18 | A6 | Futures | 0.74002 | 0.74311 | 0.73909 | 0.73971 | 87053.0 |
| 2018-12-18 | AD | Futures | 0.75651 | 0.75762 | 0.7517 | 0.7519 | 86527.0 |
| 2018-12-18 | B | Futures | 43.32 | 43.5 | 41.04 | 41.31 | 398563.0 |
| 2018-12-18 | B6 | Futures | 1.3011 | 1.3105 | 1.3008 | 1.3036 | 82036.0 |
| 2018-12-18 | BFX | Futures | 3881.6 | 3881.6 | 3878.7 | 3878.7 | 26.0 |
| 2018-12-18 | BTC | Futures | 5302.3 | 5432.0 | 5226.0 | 5332.8 | 3415.0 |
| 2018-12-18 | BZ | Futures | 42.63 | 42.92 | 40.35 | 40.78 | 41690.0 |
| 2018-12-18 | C | Futures | 1447.0 | 1477.0 | 1445.0 | 1475.0 | 8826.0 |
| 2018-12-18 | CB | Futures | 268.613 | 269.464 | 268.431 | 268.674 | 38.0 |
| 2018-12-18 | CC | Futures | 1536.0 | 1593.0 | 1534.0 | 1565.0 | 14264.0 |
| 2018-12-18 | CNH | Futures | 6.9148 | 6.9176 | 6.9055 | 6.9083 | 663.0 |
| 2018-12-18 | CSC | Futures | 2.812 | 2.827 | 2.795 | 2.821 | 164.0 |
| 2018-12-18 | CT | Futures | 85.4 | 85.67 | 84.71 | 84.8 | 14419.0 |
| 2018-12-18 | DC | Futures | 23.94 | 24.05 | 23.73 | 24.0 | 328.0 |
| 2018-12-18 | DX | Futures | 92.132 | 92.17 | 91.703 | 92.099 | 13569.0 |
| 2018-12-18 | E1 | Futures | 1.19441 | 1.19841 | 1.19394 | 1.195 | 19527.0 |
| 2018-12-18 | E6 | Futures | 1.26381 | 1.26989 | 1.26249 | 1.2647 | 164785.0 |
| 2018-12-18 | E7 | Futures | 1.2576 | 1.2636 | 1.2565 | 1.2585 | 3051.0 |
| 2018-12-18 | EBM | Futures | 213.34 | 213.34 | 212.57 | 213.08 | 13728.0 |
| 2018-12-18 | ED | Futures | 94.9598 | 94.9988 | 94.9598 | 94.9891 | 380179.0 |
| 2018-12-18 | ER | Futures | 98.386 | 98.396 | 98.386 | 98.391 | 80190.0 |
| 2018-12-18 | EW | Futures | 1816.2 | 1833.7 | 1794.7 | 1807.1 | 36436.0 |
| 2018-12-18 | FBON | Futures | 129.74 | 130.08 | 129.74 | 129.98 | 145.0 |
| 2018-12-18 | FBTP | Futures | 109.5 | 109.95 | 108.97 | 109.72 | 45911.0 |
| 2018-12-18 | FBTS | Futures | 104.291 | 104.452 | 104.206 | 104.329 | 41579.0 |
| 2018-12-18 | FCE | Futures | 4233.7 | 4264.4 | 4218.2 | 4218.2 | 104257.0 |
| 2018-12-18 | FDAX | Futures | 11272.5 | 11386.5 | 11223.1 | 11295.6 | 55687.0 |
| 2018-12-18 | FDXM | Futures | 11255.5 | 11356.2 | 11195.8 | 11268.1 | 2068.0 |
| 2018-12-18 | FESX | Futures | 2602.2 | 2609.9 | 2583.4 | 2591.1 | 2122647.0 |
| 2018-12-18 | FEU3 | Futures | 98.986 | 98.996 | 98.986 | 98.996 | 400.0 |
| 2018-12-18 | FGBL | Futures | 155.26 | 155.5 | 155.19 | 155.3 | 483389.0 |
| 2018-12-18 | FGBM | Futures | 131.71 | 131.84 | 131.66 | 131.69 | 315160.0 |
| 2018-12-18 | FGBS | Futures | 112.693 | 112.718 | 112.663 | 112.678 | 130629.0 |
| 2018-12-18 | FGBX | Futures | 183.39 | 184.1 | 183.21 | 183.58 | 37295.0 |
| 2018-12-18 | FMWO | Futures | 6445.7 | 6477.1 | 6436.3 | 6438.7 | 14099.0 |
| 2018-12-18 | FOAT | Futures | 140.96 | 141.34 | 140.93 | 141.17 | 96535.0 |
| 2018-12-18 | FTDX | Futures | 2454.4 | 2480.7 | 2450.4 | 2467.8 | 477.0 |
| 2018-12-18 | FTI | Futures | 464.58 | 465.28 | 461.26 | 462.48 | 36200.0 |
| 2018-12-18 | FTUK | Futures | 6082.7 | 6101.4 | 6028.1 | 6057.7 | 343025.0 |
| 2018-12-18 | FVSA | Futures | 413.35 | 424.52 | 403.2 | 418.43 | 38171.0 |
| 2018-12-18 | FXXP | Futures | 298.1 | 299.5 | 296.7 | 297.5 | 175190.0 |
| 2018-12-18 | G | Futures | 117.15 | 117.3 | 116.64 | 116.7 | 147062.0 |
| 2018-12-18 | GF | Futures | 312.773 | 316.325 | 311.966 | 314.71 | 4482.0 |
| 2018-12-18 | GSCI | Futures | 453.95 | 453.95 | 439.99 | 441.7 | 299.0 |
> showing 50 of 115 rows — these rows as CSV