PREVIEW / futures_daily / 2018-01-30
file: by_date/futures_daily/2018/2018-01-30.parquet size: 10 KB rows: 113
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-01-30 | ES | Futures | 3101.14 | 3106.3 | 3063.37 | 3069.89 | 2133815.0 |
| 2018-01-30 | NQ | Futures | 8188.3 | 8205.87 | 8084.36 | 8129.74 | 524079.0 |
| 2018-01-30 | YM | Futures | 27859.5 | 27922.8 | 27425.1 | 27477.8 | 306912.0 |
| 2018-01-30 | CL | Futures | 65.51 | 65.54 | 63.87 | 64.48 | 688380.0 |
| 2018-01-30 | GC | Futures | 1716.7 | 1727.6 | 1708.4 | 1711.6 | 412518.0 |
| 2018-01-30 | ZN | Futures | 120.262878 | 120.401714 | 119.985206 | 120.093189 | 1691151.0 |
| 2018-01-30 | A6 | Futures | 0.83227 | 0.83443 | 0.82723 | 0.83145 | 121625.0 |
| 2018-01-30 | AD | Futures | 0.82331 | 0.82523 | 0.82056 | 0.82432 | 62415.0 |
| 2018-01-30 | B | Futures | 49.52 | 49.59 | 48.8 | 49.17 | 356664.0 |
| 2018-01-30 | B6 | Futures | 1.4663 | 1.4759 | 1.4565 | 1.4745 | 143285.0 |
| 2018-01-30 | BR | Futures | 0.23913 | 0.24027 | 0.23697 | 0.23799 | 3347.0 |
| 2018-01-30 | BTC | Futures | 14469.7 | 14632.4 | 12648.0 | 12934.3 | 1137.0 |
| 2018-01-30 | BZ | Futures | 49.05 | 49.05 | 48.13 | 48.52 | 31105.0 |
| 2018-01-30 | C | Futures | 1252.0 | 1271.0 | 1241.0 | 1267.0 | 13597.0 |
| 2018-01-30 | CB | Futures | 267.194 | 269.201 | 267.194 | 268.367 | 19.0 |
| 2018-01-30 | CC | Futures | 1450.0 | 1483.0 | 1450.0 | 1470.0 | 24277.0 |
| 2018-01-30 | CNH | Futures | 6.4844 | 6.4844 | 6.4687 | 6.4698 | 22.0 |
| 2018-01-30 | CSC | Futures | 3.137 | 3.144 | 3.12 | 3.125 | 143.0 |
| 2018-01-30 | CT | Futures | 91.52 | 92.19 | 89.89 | 89.97 | 29236.0 |
| 2018-01-30 | DC | Futures | 24.94 | 25.04 | 24.76 | 24.81 | 168.0 |
| 2018-01-30 | DX | Futures | 83.782 | 84.031 | 83.336 | 83.579 | 26244.0 |
| 2018-01-30 | E1 | Futures | 1.29926 | 1.30848 | 1.29659 | 1.3046 | 30928.0 |
| 2018-01-30 | E6 | Futures | 1.40807 | 1.41607 | 1.40252 | 1.4104 | 299582.0 |
| 2018-01-30 | E7 | Futures | 1.4011 | 1.4089 | 1.3955 | 1.4033 | 6405.0 |
| 2018-01-30 | EBM | Futures | 172.35 | 173.7 | 172.08 | 173.43 | 25895.0 |
| 2018-01-30 | ED | Futures | 95.297 | 95.3019 | 95.2922 | 95.297 | 333798.0 |
| 2018-01-30 | ER | Futures | 98.332 | 98.337 | 98.332 | 98.332 | 42684.0 |
| 2018-01-30 | EW | Futures | 2098.5 | 2102.1 | 2073.3 | 2077.5 | 18536.0 |
| 2018-01-30 | FBON | Futures | 126.8 | 127.07 | 126.79 | 126.94 | 305.0 |
| 2018-01-30 | FBTP | Futures | 110.99 | 111.43 | 110.97 | 111.02 | 124890.0 |
| 2018-01-30 | FBTS | Futures | 103.522 | 103.604 | 103.522 | 103.54 | 45893.0 |
| 2018-01-30 | FCE | Futures | 4900.4 | 4919.6 | 4870.6 | 4879.0 | 79009.0 |
| 2018-01-30 | FDAX | Futures | 13728.9 | 13806.2 | 13659.9 | 13692.6 | 90420.0 |
| 2018-01-30 | FDIV | Futures | 152.6 | 152.6 | 152.44 | 152.44 | 30.0 |
| 2018-01-30 | FDXM | Futures | 13754.3 | 13829.1 | 13682.6 | 13715.8 | 30447.0 |
| 2018-01-30 | FESX | Futures | 2957.3 | 2963.0 | 2935.2 | 2943.4 | 1070325.0 |
| 2018-01-30 | FEU3 | Futures | 99.006 | 99.011 | 99.006 | 99.011 | 600.0 |
| 2018-01-30 | FGBL | Futures | 147.12 | 147.53 | 147.11 | 147.28 | 840657.0 |
| 2018-01-30 | FGBM | Futures | 128.22 | 128.4 | 128.22 | 128.27 | 764277.0 |
| 2018-01-30 | FGBS | Futures | 112.206 | 112.246 | 112.196 | 112.216 | 478967.0 |
| 2018-01-30 | FGBX | Futures | 165.84 | 166.38 | 165.25 | 165.55 | 80410.0 |
| 2018-01-30 | FMWO | Futures | 7341.3 | 7347.2 | 7298.2 | 7309.8 | 1582.0 |
| 2018-01-30 | FOAT | Futures | 135.89 | 136.4 | 135.89 | 136.14 | 122858.0 |
| 2018-01-30 | FTDX | Futures | 2653.6 | 2665.0 | 2624.1 | 2632.6 | 196.0 |
| 2018-01-30 | FTI | Futures | 522.89 | 523.4 | 518.75 | 519.82 | 28803.0 |
| 2018-01-30 | FTUK | Futures | 6645.4 | 6645.4 | 6569.4 | 6589.5 | 114421.0 |
| 2018-01-30 | FVSA | Futures | 264.11 | 288.2 | 258.95 | 270.99 | 52868.0 |
| 2018-01-30 | FXXP | Futures | 337.6 | 338.8 | 336.0 | 336.9 | 44344.0 |
| 2018-01-30 | G | Futures | 112.82 | 113.11 | 112.81 | 112.86 | 190755.0 |
| 2018-01-30 | GF | Futures | 321.819 | 324.289 | 317.153 | 323.191 | 7146.0 |
> showing 50 of 113 rows — these rows as CSV