PREVIEW / futures_daily / 2021-10-18
file: by_date/futures_daily/2021/2021-10-18.parquet size: 10 KB rows: 124
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 |
|---|---|---|---|---|---|---|---|
| 2021-10-18 | ES | Futures | 5023.2 | 5039.23 | 4990.3 | 5036.7 | 1095216.0 |
| 2021-10-18 | NQ | Futures | 17464.39 | 17639.95 | 17341.87 | 17632.17 | 423424.0 |
| 2021-10-18 | YM | Futures | 38309.6 | 38328.1 | 37978.9 | 38225.8 | 137825.0 |
| 2021-10-18 | CL | Futures | 60.76 | 61.63 | 60.17 | 60.53 | 501073.0 |
| 2021-10-18 | GC | Futures | 2062.1 | 2067.9 | 2053.7 | 2060.0 | 152741.0 |
| 2021-10-18 | ZN | Futures | 133.129914 | 133.161695 | 132.653201 | 132.9869 | 2074254.0 |
| 2021-10-18 | A6 | Futures | 0.76069 | 0.76279 | 0.75664 | 0.76054 | 81671.0 |
| 2021-10-18 | AD | Futures | 0.821 | 0.82207 | 0.81801 | 0.82024 | 60983.0 |
| 2021-10-18 | ALI | Futures | 3557.05 | 3600.97 | 3533.42 | 3557.88 | 38.0 |
| 2021-10-18 | B | Futures | 57.55 | 58.29 | 56.87 | 57.13 | 340957.0 |
| 2021-10-18 | B6 | Futures | 1.396 | 1.3973 | 1.3913 | 1.3936 | 91492.0 |
| 2021-10-18 | BR | Futures | 0.14743 | 0.14743 | 0.14544 | 0.14634 | 33.0 |
| 2021-10-18 | BTC | Futures | 81267.1 | 84072.6 | 79910.8 | 81971.8 | 10019.0 |
| 2021-10-18 | BZ | Futures | 56.28 | 56.93 | 55.56 | 55.8 | 40153.0 |
| 2021-10-18 | C | Futures | 1557.0 | 1570.0 | 1549.0 | 1565.0 | 4722.0 |
| 2021-10-18 | CB | Futures | 141.839 | 144.203 | 141.839 | 141.839 | 23.0 |
| 2021-10-18 | CC | Futures | 1673.0 | 1693.0 | 1657.0 | 1676.0 | 13778.0 |
| 2021-10-18 | CNH | Futures | 6.1897 | 6.1945 | 6.1818 | 6.1829 | 172.0 |
| 2021-10-18 | CSC | Futures | 2.571 | 2.575 | 2.561 | 2.561 | 79.0 |
| 2021-10-18 | CT | Futures | 100.09 | 102.38 | 98.38 | 99.9 | 15931.0 |
| 2021-10-18 | DC | Futures | 24.24 | 24.29 | 24.19 | 24.24 | 357.0 |
| 2021-10-18 | DX | Futures | 90.767 | 90.994 | 90.694 | 90.772 | 20656.0 |
| 2021-10-18 | E1 | Futures | 1.21452 | 1.21597 | 1.20948 | 1.21485 | 21961.0 |
| 2021-10-18 | E6 | Futures | 1.23369 | 1.23619 | 1.23077 | 1.23491 | 154376.0 |
| 2021-10-18 | E7 | Futures | 1.2275 | 1.2294 | 1.224 | 1.2281 | 3801.0 |
| 2021-10-18 | EBM | Futures | 406.34 | 408.18 | 401.2 | 402.67 | 17384.0 |
| 2021-10-18 | ED | Futures | 96.5489 | 96.5489 | 96.5296 | 96.5344 | 311260.0 |
| 2021-10-18 | ER | Futures | 98.475 | 98.48 | 98.465 | 98.475 | 132289.0 |
| 2021-10-18 | ESG | Futures | 414.99 | 417.57 | 413.84 | 417.4 | 220.0 |
| 2021-10-18 | EW | Futures | 2956.5 | 2964.8 | 2933.1 | 2959.4 | 12988.0 |
| 2021-10-18 | FBON | Futures | 148.65 | 148.65 | 148.01 | 148.49 | 609.0 |
| 2021-10-18 | FBTP | Futures | 138.16 | 138.25 | 137.37 | 138.09 | 172759.0 |
| 2021-10-18 | FBTS | Futures | 110.303 | 110.342 | 110.157 | 110.235 | 86066.0 |
| 2021-10-18 | FCE | Futures | 6800.5 | 6801.0 | 6712.5 | 6744.9 | 52561.0 |
| 2021-10-18 | FDAX | Futures | 16630.2 | 16652.6 | 16461.3 | 16531.8 | 65341.0 |
| 2021-10-18 | FDIV | Futures | 183.14 | 183.14 | 181.27 | 181.72 | 50.0 |
| 2021-10-18 | FDXM | Futures | 16676.4 | 16694.6 | 16508.1 | 16578.9 | 46658.0 |
| 2021-10-18 | FDXS | Futures | 16526.9 | 16538.6 | 16354.9 | 16424.9 | 19190.0 |
| 2021-10-18 | FESX | Futures | 3990.0 | 3997.2 | 3944.5 | 3968.0 | 594032.0 |
| 2021-10-18 | FGBL | Futures | 166.72 | 166.8 | 166.15 | 166.61 | 913620.0 |
| 2021-10-18 | FGBM | Futures | 134.26 | 134.29 | 133.91 | 134.08 | 722086.0 |
| 2021-10-18 | FGBS | Futures | 112.594 | 112.599 | 112.468 | 112.514 | 660868.0 |
| 2021-10-18 | FGBX | Futures | 219.96 | 223.15 | 219.79 | 221.92 | 111216.0 |
| 2021-10-18 | FMWO | Futures | 11012.6 | 11069.2 | 10976.0 | 11045.6 | 4589.0 |
| 2021-10-18 | FOAT | Futures | 154.46 | 154.5 | 153.86 | 154.33 | 168688.0 |
| 2021-10-18 | FTDX | Futures | 3800.5 | 3817.9 | 3793.3 | 3817.9 | 90.0 |
| 2021-10-18 | FTI | Futures | 762.08 | 762.08 | 755.33 | 759.45 | 17193.0 |
| 2021-10-18 | FTUK | Futures | 7111.4 | 7125.8 | 7070.0 | 7093.7 | 81019.0 |
| 2021-10-18 | FVSA | Futures | 69.97 | 71.86 | 69.28 | 69.97 | 29360.0 |
| 2021-10-18 | FXXP | Futures | 443.4 | 446.0 | 442.4 | 444.2 | 73187.0 |
> showing 50 of 124 rows — these rows as CSV