PREVIEW / futures_daily / 2019-12-30
file: by_date/futures_daily/2019/2019-12-30.parquet size: 10 KB rows: 118
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 |
|---|---|---|---|---|---|---|---|
| 2019-12-30 | ES | Futures | 3497.35 | 3503.83 | 3474.67 | 3481.42 | 1124598.0 |
| 2019-12-30 | NQ | Futures | 10074.84 | 10104.95 | 9969.03 | 10017.78 | 404047.0 |
| 2019-12-30 | YM | Futures | 30054.8 | 30098.9 | 29829.0 | 29867.8 | 165288.0 |
| 2019-12-30 | CL | Futures | 63.26 | 63.91 | 62.63 | 63.23 | 427149.0 |
| 2019-12-30 | GC | Futures | 1865.0 | 1868.9 | 1862.0 | 1868.3 | 178722.0 |
| 2019-12-30 | ZN | Futures | 127.467646 | 127.545078 | 127.018544 | 127.390215 | 891503.0 |
| 2019-12-30 | A6 | Futures | 0.71721 | 0.71957 | 0.7168 | 0.71896 | 81688.0 |
| 2019-12-30 | AD | Futures | 0.77144 | 0.77255 | 0.77063 | 0.77224 | 59821.0 |
| 2019-12-30 | ALI | Futures | 2226.61 | 2227.22 | 2226.61 | 2227.22 | 5.0 |
| 2019-12-30 | B | Futures | 54.7 | 55.26 | 54.02 | 54.51 | 258776.0 |
| 2019-12-30 | B6 | Futures | 1.3299 | 1.3364 | 1.3287 | 1.3328 | 73151.0 |
| 2019-12-30 | BR | Futures | 0.20013 | 0.20204 | 0.20013 | 0.20147 | 654.0 |
| 2019-12-30 | BTC | Futures | 11285.6 | 11338.7 | 10982.5 | 11043.1 | 3115.0 |
| 2019-12-30 | BZ | Futures | 53.91 | 54.47 | 53.27 | 53.74 | 34100.0 |
| 2019-12-30 | C | Futures | 1725.0 | 1748.0 | 1707.0 | 1710.0 | 9151.0 |
| 2019-12-30 | CB | Futures | 247.04 | 247.276 | 246.421 | 246.451 | 29.0 |
| 2019-12-30 | CC | Futures | 1625.0 | 1639.0 | 1608.0 | 1611.0 | 17398.0 |
| 2019-12-30 | CNH | Futures | 6.9657 | 6.967 | 6.9516 | 6.957 | 214.0 |
| 2019-12-30 | CSC | Futures | 3.363 | 3.385 | 3.361 | 3.374 | 17.0 |
| 2019-12-30 | CT | Futures | 65.57 | 66.29 | 65.57 | 66.16 | 17634.0 |
| 2019-12-30 | DC | Futures | 27.94 | 28.09 | 27.94 | 28.04 | 42.0 |
| 2019-12-30 | DX | Futures | 93.755 | 93.788 | 93.425 | 93.572 | 12042.0 |
| 2019-12-30 | E1 | Futures | 1.1789 | 1.18701 | 1.1789 | 1.18564 | 33012.0 |
| 2019-12-30 | E6 | Futures | 1.21061 | 1.21465 | 1.21024 | 1.21266 | 149563.0 |
| 2019-12-30 | E7 | Futures | 1.2042 | 1.2082 | 1.204 | 1.2064 | 2331.0 |
| 2019-12-30 | EBM | Futures | 207.97 | 208.52 | 207.15 | 207.7 | 9222.0 |
| 2019-12-30 | ED | Futures | 95.3035 | 95.318 | 95.2986 | 95.3132 | 161619.0 |
| 2019-12-30 | ER | Futures | 98.367 | 98.372 | 98.367 | 98.372 | 39985.0 |
| 2019-12-30 | ESG | Futures | 287.67 | 287.67 | 287.42 | 287.42 | 80.0 |
| 2019-12-30 | EW | Futures | 2170.8 | 2179.6 | 2164.1 | 2172.1 | 12725.0 |
| 2019-12-30 | FBON | Futures | 143.13 | 143.17 | 142.7 | 142.74 | 321.0 |
| 2019-12-30 | FBTP | Futures | 128.32 | 128.32 | 127.66 | 127.77 | 50792.0 |
| 2019-12-30 | FBTS | Futures | 108.22 | 108.22 | 108.105 | 108.134 | 29549.0 |
| 2019-12-30 | FCE | Futures | 5450.3 | 5461.2 | 5405.9 | 5409.6 | 57823.0 |
| 2019-12-30 | FDAX | Futures | 14062.9 | 14076.1 | 13854.1 | 14008.5 | 84599.0 |
| 2019-12-30 | FDXM | Futures | 13889.5 | 13900.0 | 13681.7 | 13832.6 | 33214.0 |
| 2019-12-30 | FESX | Futures | 3317.1 | 3318.9 | 3277.5 | 3284.5 | 631592.0 |
| 2019-12-30 | FGBL | Futures | 163.89 | 163.98 | 162.78 | 162.84 | 361329.0 |
| 2019-12-30 | FGBM | Futures | 133.57 | 133.6 | 133.18 | 133.22 | 230755.0 |
| 2019-12-30 | FGBS | Futures | 112.664 | 112.664 | 112.603 | 112.613 | 181259.0 |
| 2019-12-30 | FGBX | Futures | 210.81 | 210.85 | 207.17 | 207.44 | 37882.0 |
| 2019-12-30 | FMWO | Futures | 7897.3 | 7897.3 | 7831.5 | 7853.1 | 2843.0 |
| 2019-12-30 | FOAT | Futures | 151.43 | 151.5 | 150.43 | 150.47 | 88995.0 |
| 2019-12-30 | FTDX | Futures | 3039.8 | 3049.9 | 2994.1 | 3033.3 | 101.0 |
| 2019-12-30 | FTI | Futures | 583.99 | 584.95 | 579.35 | 580.08 | 19843.0 |
| 2019-12-30 | FTUK | Futures | 7111.3 | 7117.9 | 7047.5 | 7070.0 | 63537.0 |
| 2019-12-30 | FVSA | Futures | 128.32 | 136.75 | 127.39 | 134.41 | 27086.0 |
| 2019-12-30 | FXXP | Futures | 380.4 | 381.0 | 376.7 | 377.8 | 52864.0 |
| 2019-12-30 | G | Futures | 120.13 | 120.33 | 119.2 | 119.31 | 148786.0 |
| 2019-12-30 | GF | Futures | 306.493 | 307.336 | 305.493 | 306.336 | 3396.0 |
> showing 50 of 118 rows — these rows as CSV