PREVIEW / futures_daily / 2020-11-04
file: by_date/futures_daily/2020/2020-11-04.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 |
|---|---|---|---|---|---|---|---|
| 2020-11-04 | ES | Futures | 3777.98 | 3909.71 | 3728.83 | 3859.16 | 2813083.0 |
| 2020-11-04 | NQ | Futures | 13040.43 | 13711.62 | 13001.36 | 13618.13 | 842617.0 |
| 2020-11-04 | YM | Futures | 29499.3 | 30353.1 | 28963.2 | 29858.9 | 309164.0 |
| 2020-11-04 | CL | Futures | 27.19 | 27.98 | 26.56 | 27.91 | 437000.0 |
| 2020-11-04 | GC | Futures | 2256.1 | 2265.1 | 2222.4 | 2239.4 | 293946.0 |
| 2020-11-04 | ZN | Futures | 136.82348 | 137.892777 | 136.513539 | 137.846286 | 2883115.0 |
| 2020-11-04 | A6 | Futures | 0.73564 | 0.74159 | 0.72383 | 0.7382 | 202059.0 |
| 2020-11-04 | AD | Futures | 0.77154 | 0.77392 | 0.76207 | 0.7722 | 110925.0 |
| 2020-11-04 | ALI | Futures | 2235.67 | 2282.16 | 2224.12 | 2282.16 | 120.0 |
| 2020-11-04 | B | Futures | 25.29 | 26.04 | 24.84 | 25.98 | 250866.0 |
| 2020-11-04 | B6 | Futures | 1.3257 | 1.3329 | 1.3098 | 1.318 | 121704.0 |
| 2020-11-04 | BR | Futures | 0.13707 | 0.1392 | 0.13412 | 0.13892 | 5711.0 |
| 2020-11-04 | BTC | Futures | 18377.2 | 19030.5 | 17994.5 | 18740.1 | 9531.0 |
| 2020-11-04 | BZ | Futures | 24.76 | 25.5 | 24.31 | 25.43 | 39329.0 |
| 2020-11-04 | C | Futures | 1416.0 | 1418.0 | 1402.0 | 1415.0 | 4556.0 |
| 2020-11-04 | CB | Futures | 155.508 | 155.508 | 155.508 | 155.508 | 3.0 |
| 2020-11-04 | CC | Futures | 1504.0 | 1516.0 | 1489.0 | 1506.0 | 14681.0 |
| 2020-11-04 | CNH | Futures | 6.5653 | 6.6453 | 6.4924 | 6.4949 | 2595.0 |
| 2020-11-04 | CSC | Futures | 3.924 | 3.924 | 3.895 | 3.908 | 68.0 |
| 2020-11-04 | CT | Futures | 69.13 | 69.89 | 68.81 | 69.41 | 17070.0 |
| 2020-11-04 | DC | Futures | 32.46 | 32.46 | 32.03 | 32.12 | 369.0 |
| 2020-11-04 | DX | Futures | 90.472 | 91.119 | 90.071 | 90.232 | 36544.0 |
| 2020-11-04 | E1 | Futures | 1.24307 | 1.24715 | 1.23254 | 1.2425 | 26949.0 |
| 2020-11-04 | E6 | Futures | 1.2577 | 1.26215 | 1.24393 | 1.25706 | 260869.0 |
| 2020-11-04 | E7 | Futures | 1.2509 | 1.2553 | 1.2377 | 1.2507 | 7734.0 |
| 2020-11-04 | EBM | Futures | 246.83 | 250.45 | 246.23 | 249.24 | 20691.0 |
| 2020-11-04 | ED | Futures | 96.4842 | 96.4939 | 96.4842 | 96.489 | 119874.0 |
| 2020-11-04 | ER | Futures | 98.455 | 98.465 | 98.455 | 98.46 | 31927.0 |
| 2020-11-04 | ESG | Futures | 314.57 | 324.34 | 312.43 | 320.58 | 1587.0 |
| 2020-11-04 | EW | Futures | 2118.5 | 2145.3 | 2041.8 | 2113.2 | 13798.0 |
| 2020-11-04 | FBON | Futures | 149.76 | 150.2 | 149.76 | 150.11 | 412.0 |
| 2020-11-04 | FBTP | Futures | 137.34 | 137.78 | 137.3 | 137.61 | 100110.0 |
| 2020-11-04 | FBTS | Futures | 109.778 | 109.884 | 109.778 | 109.836 | 51716.0 |
| 2020-11-04 | FCE | Futures | 4612.5 | 4773.5 | 4524.0 | 4756.6 | 113348.0 |
| 2020-11-04 | FDAX | Futures | 13033.4 | 13173.6 | 12551.5 | 13119.2 | 108105.0 |
| 2020-11-04 | FDIV | Futures | 142.18 | 144.46 | 142.18 | 144.46 | 127.0 |
| 2020-11-04 | FDXM | Futures | 12957.6 | 13107.2 | 12488.7 | 13053.1 | 70664.0 |
| 2020-11-04 | FESX | Futures | 2889.1 | 2930.7 | 2781.8 | 2915.9 | 1540986.0 |
| 2020-11-04 | FGBL | Futures | 170.88 | 171.97 | 170.7 | 171.55 | 787734.0 |
| 2020-11-04 | FGBM | Futures | 135.64 | 135.96 | 135.53 | 135.8 | 416015.0 |
| 2020-11-04 | FGBS | Futures | 112.915 | 112.975 | 112.91 | 112.93 | 418678.0 |
| 2020-11-04 | FGBX | Futures | 237.5 | 241.55 | 237.27 | 239.69 | 78782.0 |
| 2020-11-04 | FMWO | Futures | 8323.0 | 8594.2 | 8217.5 | 8545.6 | 6325.0 |
| 2020-11-04 | FOAT | Futures | 159.54 | 159.82 | 159.24 | 159.49 | 157077.0 |
| 2020-11-04 | FTDX | Futures | 2954.2 | 3049.8 | 2954.2 | 3036.0 | 82.0 |
| 2020-11-04 | FTI | Futures | 510.72 | 525.85 | 504.64 | 523.73 | 40857.0 |
| 2020-11-04 | FTUK | Futures | 5476.5 | 5619.4 | 5383.3 | 5596.0 | 127623.0 |
| 2020-11-04 | FVSA | Futures | 204.34 | 216.15 | 183.58 | 186.81 | 41620.0 |
| 2020-11-04 | FXXP | Futures | 328.1 | 337.0 | 321.7 | 335.7 | 105644.0 |
| 2020-11-04 | G | Futures | 126.75 | 127.05 | 126.54 | 127.0 | 242744.0 |
> showing 50 of 120 rows — these rows as CSV