PREVIEW / futures_daily / 2017-08-24
file: by_date/futures_daily/2017/2017-08-24.parquet size: 9 KB rows: 107
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 |
|---|---|---|---|---|---|---|---|
| 2017-08-24 | ES | Futures | 2652.12 | 2661.63 | 2645.87 | 2652.66 | 1407417.0 |
| 2017-08-24 | NQ | Futures | 6871.92 | 6905.42 | 6821.96 | 6865.75 | 372774.0 |
| 2017-08-24 | YM | Futures | 23037.6 | 23111.6 | 22986.8 | 23030.2 | 131401.0 |
| 2017-08-24 | CL | Futures | 49.63 | 49.71 | 48.3 | 48.68 | 831358.0 |
| 2017-08-24 | GC | Futures | 1649.0 | 1650.1 | 1640.5 | 1644.0 | 246715.0 |
| 2017-08-24 | ZN | Futures | 125.027251 | 125.042641 | 124.765623 | 124.781013 | 1746329.0 |
| 2017-08-24 | A6 | Futures | 0.81215 | 0.81297 | 0.80794 | 0.81184 | 63737.0 |
| 2017-08-24 | AD | Futures | 0.81062 | 0.81296 | 0.8099 | 0.81219 | 42656.0 |
| 2017-08-24 | ALI | Futures | 2744.53 | 2744.53 | 2744.53 | 2744.53 | 0.0 |
| 2017-08-24 | B | Futures | 36.76 | 36.87 | 36.1 | 36.4 | 255763.0 |
| 2017-08-24 | B6 | Futures | 1.3389 | 1.3425 | 1.3359 | 1.3388 | 77657.0 |
| 2017-08-24 | BR | Futures | 0.23566 | 0.23652 | 0.23548 | 0.236 | 1717.0 |
| 2017-08-24 | BZ | Futures | 36.44 | 36.56 | 35.79 | 36.09 | 38326.0 |
| 2017-08-24 | C | Futures | 1475.0 | 1504.0 | 1475.0 | 1500.0 | 2454.0 |
| 2017-08-24 | CB | Futures | 326.271 | 326.271 | 323.436 | 324.979 | 4.0 |
| 2017-08-24 | CC | Futures | 1377.0 | 1417.0 | 1377.0 | 1407.0 | 15163.0 |
| 2017-08-24 | CSC | Futures | 3.491 | 3.503 | 3.48 | 3.487 | 65.0 |
| 2017-08-24 | CT | Futures | 81.11 | 81.94 | 81.04 | 81.89 | 35.0 |
| 2017-08-24 | DC | Futures | 28.95 | 29.2 | 28.9 | 29.02 | 263.0 |
| 2017-08-24 | DX | Futures | 86.924 | 87.125 | 86.91 | 87.029 | 10743.0 |
| 2017-08-24 | E1 | Futures | 1.27432 | 1.27862 | 1.27211 | 1.27334 | 17425.0 |
| 2017-08-24 | E6 | Futures | 1.35454 | 1.35563 | 1.35173 | 1.35402 | 114770.0 |
| 2017-08-24 | E7 | Futures | 1.3474 | 1.3484 | 1.3446 | 1.3469 | 1808.0 |
| 2017-08-24 | EBM | Futures | 170.92 | 171.75 | 170.92 | 171.47 | 4543.0 |
| 2017-08-24 | ED | Futures | 95.5983 | 95.5983 | 95.591 | 95.5935 | 111902.0 |
| 2017-08-24 | ER | Futures | 98.342 | 98.342 | 98.337 | 98.342 | 15802.0 |
| 2017-08-24 | EW | Futures | 1806.4 | 1815.7 | 1803.7 | 1806.7 | 11317.0 |
| 2017-08-24 | FBON | Futures | 124.9 | 124.96 | 124.52 | 124.67 | 258.0 |
| 2017-08-24 | FBTP | Futures | 108.54 | 108.59 | 108.32 | 108.47 | 60688.0 |
| 2017-08-24 | FBTS | Futures | 103.009 | 103.027 | 103.0 | 103.018 | 23594.0 |
| 2017-08-24 | FCE | Futures | 4579.4 | 4595.0 | 4569.1 | 4574.0 | 51401.0 |
| 2017-08-24 | FDAX | Futures | 12818.7 | 12902.4 | 12807.6 | 12825.5 | 74615.0 |
| 2017-08-24 | FDXM | Futures | 12743.5 | 12823.0 | 12728.8 | 12746.6 | 19384.0 |
| 2017-08-24 | FESX | Futures | 2806.3 | 2824.3 | 2806.3 | 2812.0 | 608988.0 |
| 2017-08-24 | FGBL | Futures | 149.77 | 149.8 | 149.58 | 149.67 | 419458.0 |
| 2017-08-24 | FGBM | Futures | 129.76 | 129.79 | 129.68 | 129.75 | 281837.0 |
| 2017-08-24 | FGBS | Futures | 112.432 | 112.437 | 112.412 | 112.427 | 180093.0 |
| 2017-08-24 | FGBX | Futures | 169.94 | 170.08 | 169.42 | 169.66 | 30007.0 |
| 2017-08-24 | FMWO | Futures | 6490.0 | 6501.9 | 6475.7 | 6482.9 | 3327.0 |
| 2017-08-24 | FOAT | Futures | 136.61 | 136.62 | 136.34 | 136.4 | 82556.0 |
| 2017-08-24 | FTDX | Futures | 2265.7 | 2278.2 | 2263.6 | 2265.7 | 10.0 |
| 2017-08-24 | FTI | Futures | 480.24 | 482.23 | 480.1 | 480.47 | 18216.0 |
| 2017-08-24 | FTUK | Futures | 6370.1 | 6424.5 | 6369.7 | 6408.6 | 84803.0 |
| 2017-08-24 | FVSA | Futures | 516.41 | 522.71 | 502.24 | 517.99 | 20256.0 |
| 2017-08-24 | FXXP | Futures | 318.8 | 320.2 | 318.4 | 319.1 | 13666.0 |
| 2017-08-24 | G | Futures | 116.16 | 116.34 | 116.04 | 116.24 | 397024.0 |
| 2017-08-24 | GF | Futures | 309.303 | 313.359 | 305.631 | 311.715 | 5843.0 |
| 2017-08-24 | GSCI | Futures | 455.17 | 455.17 | 453.07 | 453.43 | 10.0 |
| 2017-08-24 | HE | Futures | 88.949 | 89.614 | 87.655 | 89.264 | 22442.0 |
| 2017-08-24 | HG | Futures | 3.6318 | 3.7103 | 3.627 | 3.6922 | 57752.0 |
> showing 50 of 107 rows — these rows as CSV