PREVIEW / futures_daily / 2019-08-08
file: by_date/futures_daily/2019/2019-08-08.parquet size: 10 KB rows: 119
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-08-08 | ES | Futures | 3106.6 | 3173.24 | 3097.43 | 3172.43 | 1800667.0 |
| 2019-08-08 | NQ | Futures | 8696.53 | 8909.53 | 8664.87 | 8906.36 | 553666.0 |
| 2019-08-08 | YM | Futures | 27232.4 | 27692.3 | 27139.0 | 27683.9 | 228936.0 |
| 2019-08-08 | CL | Futures | 53.4 | 54.14 | 53.0 | 53.61 | 724762.0 |
| 2019-08-08 | GC | Futures | 1865.3 | 1876.6 | 1852.3 | 1862.0 | 402963.0 |
| 2019-08-08 | ZN | Futures | 129.135614 | 129.415566 | 128.777898 | 129.322249 | 2059943.0 |
| 2019-08-08 | A6 | Futures | 0.69606 | 0.70265 | 0.69483 | 0.7009 | 96144.0 |
| 2019-08-08 | AD | Futures | 0.75793 | 0.76287 | 0.75758 | 0.76196 | 73717.0 |
| 2019-08-08 | ALI | Futures | 2175.63 | 2199.45 | 2175.02 | 2197.62 | 138.0 |
| 2019-08-08 | B | Futures | 43.36 | 43.76 | 42.83 | 43.29 | 299685.0 |
| 2019-08-08 | B6 | Futures | 1.2414 | 1.2455 | 1.2366 | 1.2405 | 92064.0 |
| 2019-08-08 | BR | Futures | 0.20055 | 0.20339 | 0.20039 | 0.20311 | 5118.0 |
| 2019-08-08 | BTC | Futures | 16625.2 | 16804.2 | 15971.2 | 16095.1 | 2431.0 |
| 2019-08-08 | BZ | Futures | 42.72 | 43.2 | 42.27 | 42.73 | 36965.0 |
| 2019-08-08 | C | Futures | 1645.0 | 1645.0 | 1623.0 | 1626.0 | 9227.0 |
| 2019-08-08 | CB | Futures | 275.407 | 275.407 | 274.474 | 274.532 | 30.0 |
| 2019-08-08 | CC | Futures | 1492.0 | 1494.0 | 1473.0 | 1479.0 | 35301.0 |
| 2019-08-08 | CNH | Futures | 7.0872 | 7.108 | 7.0675 | 7.0787 | 899.0 |
| 2019-08-08 | CSC | Futures | 3.11 | 3.115 | 3.102 | 3.107 | 36.0 |
| 2019-08-08 | CT | Futures | 58.05 | 58.8 | 57.88 | 58.8 | 45.0 |
| 2019-08-08 | DC | Futures | 26.11 | 26.2 | 26.04 | 26.11 | 362.0 |
| 2019-08-08 | DX | Futures | 93.797 | 93.936 | 93.599 | 93.81 | 16647.0 |
| 2019-08-08 | E1 | Futures | 1.19322 | 1.19484 | 1.1887 | 1.19322 | 26674.0 |
| 2019-08-08 | E6 | Futures | 1.22522 | 1.22887 | 1.22271 | 1.22369 | 187411.0 |
| 2019-08-08 | E7 | Futures | 1.219 | 1.2223 | 1.2164 | 1.2173 | 5175.0 |
| 2019-08-08 | EBM | Futures | 195.76 | 196.62 | 193.75 | 195.76 | 18200.0 |
| 2019-08-08 | ED | Futures | 95.4548 | 95.4596 | 95.3915 | 95.4207 | 377448.0 |
| 2019-08-08 | ER | Futures | 98.548 | 98.553 | 98.543 | 98.553 | 63135.0 |
| 2019-08-08 | EW | Futures | 1978.8 | 2025.5 | 1973.1 | 2023.6 | 20504.0 |
| 2019-08-08 | FBON | Futures | 145.59 | 145.68 | 144.67 | 145.42 | 374.0 |
| 2019-08-08 | FBTP | Futures | 126.65 | 126.65 | 125.28 | 125.76 | 114269.0 |
| 2019-08-08 | FBTS | Futures | 107.695 | 107.724 | 107.408 | 107.552 | 72198.0 |
| 2019-08-08 | FCE | Futures | 4851.0 | 4908.4 | 4831.0 | 4907.0 | 101752.0 |
| 2019-08-08 | FDAX | Futures | 12287.8 | 12472.6 | 12261.5 | 12420.0 | 112469.0 |
| 2019-08-08 | FDIV | Futures | 140.06 | 141.36 | 140.06 | 141.36 | 80.0 |
| 2019-08-08 | FDXM | Futures | 12131.8 | 12319.0 | 12107.9 | 12267.0 | 52487.0 |
| 2019-08-08 | FESX | Futures | 2893.8 | 2946.2 | 2892.9 | 2932.2 | 1131085.0 |
| 2019-08-08 | FGBL | Futures | 168.3 | 168.7 | 167.71 | 168.24 | 852206.0 |
| 2019-08-08 | FGBM | Futures | 135.55 | 135.7 | 135.42 | 135.59 | 483761.0 |
| 2019-08-08 | FGBS | Futures | 113.272 | 113.318 | 113.247 | 113.283 | 357217.0 |
| 2019-08-08 | FGBX | Futures | 223.52 | 225.19 | 220.57 | 222.76 | 84577.0 |
| 2019-08-08 | FMWO | Futures | 7112.2 | 7232.1 | 7112.2 | 7195.2 | 3911.0 |
| 2019-08-08 | FOAT | Futures | 155.04 | 155.04 | 154.26 | 154.73 | 169266.0 |
| 2019-08-08 | FTDX | Futures | 2771.8 | 2783.7 | 2770.8 | 2780.7 | 81.0 |
| 2019-08-08 | FTI | Futures | 515.03 | 520.3 | 513.13 | 519.46 | 35432.0 |
| 2019-08-08 | FTUK | Futures | 6624.6 | 6704.0 | 6595.5 | 6675.8 | 121700.0 |
| 2019-08-08 | FVSA | Futures | 223.21 | 228.77 | 207.13 | 210.22 | 47727.0 |
| 2019-08-08 | FXXP | Futures | 332.5 | 335.6 | 331.3 | 334.3 | 86818.0 |
| 2019-08-08 | G | Futures | 123.28 | 123.38 | 122.97 | 123.08 | 214825.0 |
| 2019-08-08 | GF | Futures | 274.0 | 275.668 | 273.46 | 274.441 | 832.0 |
> showing 50 of 119 rows — these rows as CSV