PREVIEW / futures_daily / 2019-01-08
file: by_date/futures_daily/2019/2019-01-08.parquet size: 10 KB rows: 116
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-08 | ES | Futures | 2764.33 | 2794.64 | 2758.1 | 2785.17 | 1664892.0 |
| 2019-01-08 | NQ | Futures | 7532.34 | 7625.25 | 7487.48 | 7591.68 | 539049.0 |
| 2019-01-08 | YM | Futures | 24818.7 | 25154.2 | 24783.9 | 25043.4 | 246033.0 |
| 2019-01-08 | CL | Futures | 51.11 | 52.39 | 50.67 | 52.21 | 765981.0 |
| 2019-01-08 | GC | Futures | 1625.3 | 1627.2 | 1613.1 | 1620.2 | 221915.0 |
| 2019-01-08 | ZN | Futures | 121.455923 | 121.54929 | 121.113574 | 121.253626 | 1174114.0 |
| 2019-01-08 | A6 | Futures | 0.73683 | 0.73744 | 0.73404 | 0.73631 | 99850.0 |
| 2019-01-08 | AD | Futures | 0.76283 | 0.7643 | 0.76106 | 0.76339 | 70218.0 |
| 2019-01-08 | B | Futures | 41.61 | 42.5 | 41.24 | 42.39 | 288249.0 |
| 2019-01-08 | B6 | Futures | 1.3172 | 1.3185 | 1.3091 | 1.3103 | 72381.0 |
| 2019-01-08 | BR | Futures | 0.21325 | 0.21421 | 0.21321 | 0.21405 | 3693.0 |
| 2019-01-08 | BTC | Futures | 5818.6 | 5986.7 | 5738.2 | 5825.9 | 4171.0 |
| 2019-01-08 | BZ | Futures | 41.26 | 42.14 | 40.88 | 42.04 | 34135.0 |
| 2019-01-08 | C | Futures | 1524.0 | 1524.0 | 1501.0 | 1515.0 | 8530.0 |
| 2019-01-08 | CB | Futures | 272.896 | 272.896 | 269.707 | 271.286 | 48.0 |
| 2019-01-08 | CC | Futures | 1646.0 | 1653.0 | 1622.0 | 1641.0 | 19167.0 |
| 2019-01-08 | CNH | Futures | 6.8606 | 6.8838 | 6.8606 | 6.8666 | 541.0 |
| 2019-01-08 | CSC | Futures | 2.801 | 2.801 | 2.782 | 2.788 | 113.0 |
| 2019-01-08 | CT | Futures | 79.31 | 80.45 | 77.93 | 78.07 | 17142.0 |
| 2019-01-08 | DC | Futures | 24.04 | 24.04 | 23.84 | 23.86 | 265.0 |
| 2019-01-08 | DX | Futures | 90.873 | 91.188 | 90.868 | 91.058 | 17141.0 |
| 2019-01-08 | E1 | Futures | 1.20817 | 1.20899 | 1.20335 | 1.20605 | 22791.0 |
| 2019-01-08 | E6 | Futures | 1.27558 | 1.27635 | 1.26934 | 1.27155 | 177145.0 |
| 2019-01-08 | E7 | Futures | 1.2695 | 1.2701 | 1.2631 | 1.2653 | 3256.0 |
| 2019-01-08 | EBM | Futures | 211.28 | 212.57 | 211.28 | 211.8 | 13540.0 |
| 2019-01-08 | ED | Futures | 95.0037 | 95.0135 | 94.9939 | 94.9988 | 310242.0 |
| 2019-01-08 | ER | Futures | 98.401 | 98.401 | 98.391 | 98.396 | 122920.0 |
| 2019-01-08 | EW | Futures | 1816.5 | 1846.2 | 1813.7 | 1844.9 | 14190.0 |
| 2019-01-08 | FBON | Futures | 128.91 | 128.91 | 128.61 | 128.78 | 403.0 |
| 2019-01-08 | FBTP | Futures | 110.58 | 110.65 | 109.69 | 109.99 | 57505.0 |
| 2019-01-08 | FBTS | Futures | 104.66 | 104.689 | 104.49 | 104.575 | 35219.0 |
| 2019-01-08 | FCE | Futures | 4194.7 | 4269.3 | 4186.2 | 4236.0 | 87968.0 |
| 2019-01-08 | FDAX | Futures | 11296.7 | 11458.5 | 11279.9 | 11375.5 | 103321.0 |
| 2019-01-08 | FDXM | Futures | 11268.1 | 11430.6 | 11252.4 | 11347.8 | 45746.0 |
| 2019-01-08 | FESX | Futures | 2586.8 | 2621.0 | 2580.0 | 2605.6 | 1073067.0 |
| 2019-01-08 | FEU3 | Futures | 98.991 | 98.996 | 98.991 | 98.996 | 350.0 |
| 2019-01-08 | FGBL | Futures | 155.7 | 155.84 | 155.46 | 155.68 | 659039.0 |
| 2019-01-08 | FGBM | Futures | 131.97 | 132.02 | 131.87 | 131.94 | 391107.0 |
| 2019-01-08 | FGBS | Futures | 112.703 | 112.713 | 112.678 | 112.683 | 250811.0 |
| 2019-01-08 | FGBX | Futures | 183.74 | 184.12 | 183.07 | 183.76 | 38664.0 |
| 2019-01-08 | FMWO | Futures | 6485.3 | 6526.1 | 6467.8 | 6479.5 | 1988.0 |
| 2019-01-08 | FOAT | Futures | 141.26 | 141.27 | 140.96 | 141.14 | 138338.0 |
| 2019-01-08 | FTDX | Futures | 2499.6 | 2525.4 | 2475.7 | 2511.0 | 595.0 |
| 2019-01-08 | FTI | Futures | 461.58 | 465.33 | 459.67 | 461.86 | 28699.0 |
| 2019-01-08 | FTUK | Futures | 6164.7 | 6230.3 | 6138.7 | 6211.6 | 96056.0 |
| 2019-01-08 | FVSA | Futures | 409.29 | 409.29 | 388.98 | 400.15 | 31801.0 |
| 2019-01-08 | FXXP | Futures | 299.9 | 304.0 | 299.5 | 302.6 | 74276.0 |
| 2019-01-08 | G | Futures | 116.78 | 116.93 | 116.69 | 116.83 | 206613.0 |
| 2019-01-08 | GF | Futures | 314.226 | 319.177 | 312.289 | 317.778 | 2584.0 |
| 2019-01-08 | GSCI | Futures | 446.37 | 448.71 | 446.37 | 448.71 | 2900.0 |
> showing 50 of 116 rows — these rows as CSV