PREVIEW / futures_daily / 2019-01-30
file: by_date/futures_daily/2019/2019-01-30.parquet size: 10 KB rows: 115
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-30 | ES | Futures | 2867.45 | 2912.11 | 2854.19 | 2904.26 | 1564987.0 |
| 2019-01-30 | NQ | Futures | 7745.66 | 7925.11 | 7708.03 | 7915.85 | 526133.0 |
| 2019-01-30 | YM | Futures | 25984.3 | 26441.0 | 25884.1 | 26335.5 | 242154.0 |
| 2019-01-30 | CL | Futures | 55.37 | 57.13 | 55.21 | 56.4 | 731312.0 |
| 2019-01-30 | GC | Futures | 1646.2 | 1660.7 | 1641.9 | 1644.4 | 272109.0 |
| 2019-01-30 | ZN | Futures | 121.253626 | 121.642658 | 121.004645 | 121.502606 | 1711957.0 |
| 2019-01-30 | A6 | Futures | 0.73734 | 0.74991 | 0.73703 | 0.7496 | 131275.0 |
| 2019-01-30 | AD | Futures | 0.76374 | 0.77265 | 0.76314 | 0.772 | 89074.0 |
| 2019-01-30 | B | Futures | 44.28 | 45.32 | 44.2 | 44.62 | 304571.0 |
| 2019-01-30 | B6 | Futures | 1.3463 | 1.3531 | 1.3435 | 1.35 | 96077.0 |
| 2019-01-30 | BR | Futures | 0.2144 | 0.21656 | 0.21349 | 0.21377 | 2503.0 |
| 2019-01-30 | BTC | Futures | 4954.2 | 5064.8 | 4932.1 | 5027.9 | 3311.0 |
| 2019-01-30 | BZ | Futures | 43.83 | 44.84 | 43.72 | 44.15 | 31849.0 |
| 2019-01-30 | C | Futures | 1397.0 | 1400.0 | 1376.0 | 1385.0 | 12626.0 |
| 2019-01-30 | CB | Futures | 276.723 | 278.849 | 276.176 | 278.15 | 49.0 |
| 2019-01-30 | CC | Futures | 1527.0 | 1537.0 | 1490.0 | 1499.0 | 27183.0 |
| 2019-01-30 | CNH | Futures | 6.7535 | 6.755 | 6.7186 | 6.7186 | 742.0 |
| 2019-01-30 | CSC | Futures | 2.708 | 2.723 | 2.708 | 2.719 | 113.0 |
| 2019-01-30 | CT | Futures | 80.76 | 81.21 | 80.35 | 81.0 | 16901.0 |
| 2019-01-30 | DC | Futures | 23.04 | 23.2 | 23.03 | 23.19 | 194.0 |
| 2019-01-30 | DX | Futures | 91.064 | 91.259 | 90.549 | 90.631 | 22677.0 |
| 2019-01-30 | E1 | Futures | 1.18724 | 1.189 | 1.18136 | 1.18748 | 20862.0 |
| 2019-01-30 | E6 | Futures | 1.26845 | 1.27591 | 1.26525 | 1.27481 | 220748.0 |
| 2019-01-30 | E7 | Futures | 1.2623 | 1.2696 | 1.2592 | 1.2686 | 4748.0 |
| 2019-01-30 | EBM | Futures | 211.54 | 212.31 | 211.03 | 211.54 | 10434.0 |
| 2019-01-30 | ED | Futures | 95.033 | 95.0525 | 95.0281 | 95.0476 | 293469.0 |
| 2019-01-30 | ER | Futures | 98.396 | 98.401 | 98.396 | 98.401 | 106056.0 |
| 2019-01-30 | EW | Futures | 1938.4 | 1955.3 | 1925.4 | 1946.3 | 15332.0 |
| 2019-01-30 | FBON | Futures | 131.76 | 131.76 | 131.29 | 131.56 | 481.0 |
| 2019-01-30 | FBTP | Futures | 112.88 | 113.29 | 112.72 | 113.21 | 89941.0 |
| 2019-01-30 | FBTS | Futures | 105.474 | 105.55 | 105.436 | 105.54 | 46895.0 |
| 2019-01-30 | FCE | Futures | 4416.8 | 4470.6 | 4409.2 | 4454.5 | 70140.0 |
| 2019-01-30 | FDAX | Futures | 11808.4 | 11808.4 | 11692.8 | 11729.1 | 94882.0 |
| 2019-01-30 | FDIV | Futures | 137.73 | 137.73 | 137.51 | 137.51 | 50.0 |
| 2019-01-30 | FDXM | Futures | 11759.8 | 11772.3 | 11664.4 | 11700.5 | 42916.0 |
| 2019-01-30 | FESX | Futures | 2691.9 | 2707.3 | 2681.6 | 2690.2 | 782589.0 |
| 2019-01-30 | FGBL | Futures | 157.11 | 157.39 | 156.87 | 157.05 | 573073.0 |
| 2019-01-30 | FGBM | Futures | 132.3 | 132.33 | 132.18 | 132.22 | 336957.0 |
| 2019-01-30 | FGBS | Futures | 112.688 | 112.698 | 112.658 | 112.663 | 335615.0 |
| 2019-01-30 | FGBX | Futures | 187.02 | 187.9 | 186.58 | 187.37 | 41500.0 |
| 2019-01-30 | FMWO | Futures | 6692.7 | 6798.8 | 6686.9 | 6727.7 | 1416.0 |
| 2019-01-30 | FOAT | Futures | 142.64 | 142.85 | 142.56 | 142.77 | 113202.0 |
| 2019-01-30 | FTDX | Futures | 2607.4 | 2625.8 | 2524.4 | 2575.6 | 360.0 |
| 2019-01-30 | FTI | Futures | 486.25 | 490.08 | 484.6 | 488.56 | 21776.0 |
| 2019-01-30 | FTUK | Futures | 6202.0 | 6291.3 | 6184.3 | 6259.9 | 118659.0 |
| 2019-01-30 | FVSA | Futures | 316.07 | 320.76 | 304.81 | 315.13 | 26765.0 |
| 2019-01-30 | FXXP | Futures | 311.8 | 314.5 | 311.6 | 313.2 | 42216.0 |
| 2019-01-30 | G | Futures | 116.87 | 116.92 | 116.68 | 116.8 | 158591.0 |
| 2019-01-30 | GF | Futures | 315.29 | 316.11 | 314.744 | 315.564 | 2732.0 |
| 2019-01-30 | GSCI | Futures | 467.88 | 471.14 | 467.88 | 469.94 | 11.0 |
> showing 50 of 115 rows — these rows as CSV