PREVIEW / futures_daily / 2019-10-16
file: by_date/futures_daily/2019/2019-10-16.parquet size: 10 KB rows: 120
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-10-16 | ES | Futures | 3243.91 | 3245.27 | 3231.19 | 3238.5 | 1148118.0 |
| 2019-10-16 | NQ | Futures | 9173.27 | 9173.56 | 9112.77 | 9160.02 | 347550.0 |
| 2019-10-16 | YM | Futures | 28344.4 | 28362.2 | 28228.9 | 28281.4 | 137346.0 |
| 2019-10-16 | CL | Futures | 54.13 | 54.98 | 53.74 | 54.61 | 233701.0 |
| 2019-10-16 | GC | Futures | 1831.6 | 1844.8 | 1826.4 | 1842.9 | 367898.0 |
| 2019-10-16 | ZN | Futures | 128.629011 | 129.062574 | 128.598042 | 128.814824 | 1480517.0 |
| 2019-10-16 | A6 | Futures | 0.69404 | 0.69547 | 0.69106 | 0.69506 | 95128.0 |
| 2019-10-16 | AD | Futures | 0.76333 | 0.76438 | 0.76025 | 0.76388 | 82048.0 |
| 2019-10-16 | ALI | Futures | 2092.89 | 2108.68 | 2092.89 | 2105.03 | 123.0 |
| 2019-10-16 | B | Futures | 46.66 | 47.33 | 46.23 | 47.07 | 257875.0 |
| 2019-10-16 | B6 | Futures | 1.3003 | 1.312 | 1.2895 | 1.3081 | 298175.0 |
| 2019-10-16 | BR | Futures | 0.19299 | 0.194 | 0.19243 | 0.19364 | 200.0 |
| 2019-10-16 | BTC | Futures | 11721.9 | 11786.6 | 11362.3 | 11434.2 | 3685.0 |
| 2019-10-16 | BZ | Futures | 45.9 | 46.66 | 45.58 | 46.41 | 43443.0 |
| 2019-10-16 | C | Futures | 1699.0 | 1700.0 | 1676.0 | 1692.0 | 7354.0 |
| 2019-10-16 | CB | Futures | 249.4 | 249.814 | 248.869 | 249.814 | 35.0 |
| 2019-10-16 | CC | Futures | 1644.0 | 1658.0 | 1631.0 | 1650.0 | 17241.0 |
| 2019-10-16 | CNH | Futures | 7.0779 | 7.1074 | 7.0779 | 7.0946 | 705.0 |
| 2019-10-16 | CSC | Futures | 3.245 | 3.255 | 3.229 | 3.236 | 39.0 |
| 2019-10-16 | CT | Futures | 61.81 | 62.86 | 61.36 | 62.82 | 21137.0 |
| 2019-10-16 | DC | Futures | 27.17 | 27.29 | 27.06 | 27.11 | 264.0 |
| 2019-10-16 | DX | Futures | 94.739 | 94.86 | 94.343 | 94.452 | 32818.0 |
| 2019-10-16 | E1 | Futures | 1.15703 | 1.16197 | 1.1568 | 1.1614 | 28360.0 |
| 2019-10-16 | E6 | Futures | 1.20065 | 1.20651 | 1.19957 | 1.2051 | 226959.0 |
| 2019-10-16 | E7 | Futures | 1.1945 | 1.2002 | 1.1933 | 1.1989 | 4533.0 |
| 2019-10-16 | EBM | Futures | 195.64 | 197.28 | 195.36 | 197.01 | 27558.0 |
| 2019-10-16 | ED | Futures | 95.3326 | 95.3569 | 95.3277 | 95.3472 | 384007.0 |
| 2019-10-16 | ER | Futures | 98.421 | 98.426 | 98.411 | 98.416 | 71062.0 |
| 2019-10-16 | EW | Futures | 2021.7 | 2027.8 | 2011.9 | 2019.7 | 14511.0 |
| 2019-10-16 | FBON | Futures | 145.12 | 145.34 | 144.82 | 145.01 | 435.0 |
| 2019-10-16 | FBTP | Futures | 131.47 | 132.03 | 131.34 | 131.59 | 88340.0 |
| 2019-10-16 | FBTS | Futures | 108.519 | 108.558 | 108.452 | 108.481 | 41251.0 |
| 2019-10-16 | FCE | Futures | 5173.2 | 5180.0 | 5149.6 | 5167.8 | 100173.0 |
| 2019-10-16 | FDAX | Futures | 13323.5 | 13392.6 | 13282.8 | 13380.4 | 102822.0 |
| 2019-10-16 | FDIV | Futures | 152.35 | 153.65 | 152.35 | 153.65 | 141.0 |
| 2019-10-16 | FDXM | Futures | 13145.3 | 13220.3 | 13108.9 | 13205.7 | 46292.0 |
| 2019-10-16 | FESX | Futures | 3148.3 | 3157.1 | 3136.0 | 3150.9 | 1197967.0 |
| 2019-10-16 | FEU3 | Futures | 99.119 | 99.119 | 99.114 | 99.114 | 50.0 |
| 2019-10-16 | FGBL | Futures | 165.88 | 166.43 | 165.55 | 165.75 | 884388.0 |
| 2019-10-16 | FGBM | Futures | 134.31 | 134.46 | 134.22 | 134.29 | 456914.0 |
| 2019-10-16 | FGBS | Futures | 112.82 | 112.855 | 112.8 | 112.815 | 284553.0 |
| 2019-10-16 | FGBX | Futures | 217.31 | 219.01 | 215.51 | 216.19 | 58174.0 |
| 2019-10-16 | FMWO | Futures | 7322.1 | 7332.4 | 7302.8 | 7329.0 | 3286.0 |
| 2019-10-16 | FOAT | Futures | 153.43 | 153.92 | 153.11 | 153.28 | 169722.0 |
| 2019-10-16 | FTDX | Futures | 2754.0 | 2766.9 | 2754.0 | 2761.4 | 126.0 |
| 2019-10-16 | FTI | Futures | 551.74 | 552.65 | 546.88 | 548.33 | 43334.0 |
| 2019-10-16 | FTUK | Futures | 6655.9 | 6667.5 | 6601.7 | 6624.9 | 120588.0 |
| 2019-10-16 | FVSA | Futures | 167.24 | 169.9 | 164.59 | 167.78 | 57507.0 |
| 2019-10-16 | FXXP | Futures | 354.9 | 355.9 | 353.7 | 355.2 | 52639.0 |
| 2019-10-16 | G | Futures | 121.08 | 121.74 | 120.48 | 120.97 | 321414.0 |
> showing 50 of 120 rows — these rows as CSV