PREVIEW / futures_daily / 2019-01-25
file: by_date/futures_daily/2019/2019-01-25.parquet size: 10 KB rows: 117
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-01-25 | ES | Futures | 2854.19 | 2893.43 | 2852.29 | 2883.69 | 1388741.0 |
| 2019-01-25 | NQ | Futures | 7739.0 | 7884.88 | 7730.03 | 7862.59 | 446822.0 |
| 2019-01-25 | YM | Futures | 25816.6 | 26189.9 | 25797.6 | 26048.6 | 195062.0 |
| 2019-01-25 | CL | Futures | 55.3 | 56.1 | 55.03 | 55.84 | 593385.0 |
| 2019-01-25 | GC | Futures | 1612.9 | 1642.3 | 1611.4 | 1635.6 | 303837.0 |
| 2019-01-25 | ZN | Futures | 121.206942 | 121.284748 | 120.817909 | 120.911277 | 1319213.0 |
| 2019-01-25 | A6 | Futures | 0.73095 | 0.74095 | 0.72961 | 0.74023 | 117887.0 |
| 2019-01-25 | AD | Futures | 0.75889 | 0.76704 | 0.75873 | 0.76623 | 71059.0 |
| 2019-01-25 | B | Futures | 44.29 | 44.91 | 43.99 | 44.65 | 183542.0 |
| 2019-01-25 | B6 | Futures | 1.3451 | 1.3607 | 1.3443 | 1.3585 | 139862.0 |
| 2019-01-25 | BR | Futures | 0.21133 | 0.21265 | 0.21133 | 0.21233 | 1095.0 |
| 2019-01-25 | BTC | Futures | 5197.5 | 5212.2 | 5109.0 | 5168.0 | 3678.0 |
| 2019-01-25 | BZ | Futures | 43.91 | 44.41 | 43.56 | 44.19 | 18890.0 |
| 2019-01-25 | C | Futures | 1431.0 | 1437.0 | 1401.0 | 1402.0 | 8596.0 |
| 2019-01-25 | CB | Futures | 273.352 | 274.263 | 273.352 | 273.959 | 16.0 |
| 2019-01-25 | CC | Futures | 1554.0 | 1560.0 | 1528.0 | 1533.0 | 18908.0 |
| 2019-01-25 | CNH | Futures | 6.8105 | 6.8105 | 6.7635 | 6.7642 | 909.0 |
| 2019-01-25 | CSC | Futures | 2.678 | 2.695 | 2.674 | 2.693 | 120.0 |
| 2019-01-25 | CT | Futures | 79.79 | 80.87 | 79.79 | 80.75 | 13846.0 |
| 2019-01-25 | DC | Futures | 22.64 | 22.95 | 22.62 | 22.87 | 229.0 |
| 2019-01-25 | DX | Futures | 91.746 | 91.779 | 90.983 | 91.045 | 30600.0 |
| 2019-01-25 | E1 | Futures | 1.18501 | 1.19053 | 1.1843 | 1.18959 | 19805.0 |
| 2019-01-25 | E6 | Futures | 1.25431 | 1.26691 | 1.25376 | 1.26652 | 235735.0 |
| 2019-01-25 | E7 | Futures | 1.2482 | 1.2607 | 1.2479 | 1.2604 | 4527.0 |
| 2019-01-25 | EBM | Futures | 212.57 | 212.57 | 210.77 | 211.54 | 16492.0 |
| 2019-01-25 | ED | Futures | 95.0183 | 95.0281 | 95.0135 | 95.0281 | 178988.0 |
| 2019-01-25 | ER | Futures | 98.401 | 98.401 | 98.396 | 98.401 | 20218.0 |
| 2019-01-25 | EW | Futures | 1914.5 | 1941.9 | 1913.3 | 1936.8 | 11505.0 |
| 2019-01-25 | FBON | Futures | 131.63 | 131.94 | 131.63 | 131.83 | 460.0 |
| 2019-01-25 | FBTP | Futures | 112.6 | 113.03 | 112.48 | 112.84 | 73783.0 |
| 2019-01-25 | FBTS | Futures | 105.446 | 105.512 | 105.351 | 105.455 | 51486.0 |
| 2019-01-25 | FCE | Futures | 4378.3 | 4415.9 | 4375.6 | 4409.7 | 64698.0 |
| 2019-01-25 | FDAX | Futures | 11723.8 | 11895.1 | 11719.1 | 11852.1 | 114050.0 |
| 2019-01-25 | FDIV | Futures | 137.73 | 138.23 | 137.73 | 138.14 | 34.0 |
| 2019-01-25 | FDXM | Futures | 11689.5 | 11866.7 | 11689.5 | 11823.2 | 45280.0 |
| 2019-01-25 | FESX | Futures | 2667.1 | 2700.4 | 2667.1 | 2696.2 | 1118612.0 |
| 2019-01-25 | FEU3 | Futures | 99.001 | 99.001 | 99.001 | 99.001 | 29.0 |
| 2019-01-25 | FGBL | Futures | 157.22 | 157.29 | 156.84 | 156.95 | 603429.0 |
| 2019-01-25 | FGBM | Futures | 132.33 | 132.36 | 132.19 | 132.22 | 394785.0 |
| 2019-01-25 | FGBS | Futures | 112.688 | 112.713 | 112.673 | 112.698 | 438032.0 |
| 2019-01-25 | FGBX | Futures | 187.9 | 188.0 | 187.04 | 187.35 | 44644.0 |
| 2019-01-25 | FMWO | Futures | 6691.6 | 6742.8 | 6681.1 | 6730.0 | 1647.0 |
| 2019-01-25 | FOAT | Futures | 142.85 | 142.96 | 142.69 | 142.77 | 118259.0 |
| 2019-01-25 | FTDX | Futures | 2623.8 | 2643.2 | 2623.8 | 2632.8 | 377.0 |
| 2019-01-25 | FTI | Futures | 483.08 | 485.87 | 482.94 | 485.34 | 25738.0 |
| 2019-01-25 | FTUK | Futures | 6169.7 | 6192.9 | 6131.0 | 6146.9 | 104184.0 |
| 2019-01-25 | FVSA | Futures | 309.5 | 311.38 | 304.81 | 307.63 | 23156.0 |
| 2019-01-25 | FXXP | Futures | 312.9 | 313.7 | 312.0 | 312.7 | 83307.0 |
| 2019-01-25 | G | Futures | 116.64 | 116.81 | 116.26 | 116.41 | 191551.0 |
| 2019-01-25 | GF | Futures | 316.329 | 316.821 | 313.377 | 314.087 | 5789.0 |
> showing 50 of 117 rows — these rows as CSV