PREVIEW / futures_daily / 2020-10-26
file: by_date/futures_daily/2020/2020-10-26.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-10-26 | ES | Futures | 3871.23 | 3871.8 | 3770.4 | 3812.53 | 1957780.0 |
| 2020-10-26 | NQ | Futures | 13468.79 | 13539.99 | 13132.18 | 13304.68 | 674142.0 |
| 2020-10-26 | YM | Futures | 30305.7 | 30305.7 | 29346.5 | 29693.1 | 231099.0 |
| 2020-10-26 | CL | Futures | 28.29 | 28.33 | 27.29 | 27.49 | 360184.0 |
| 2020-10-26 | GC | Futures | 2251.0 | 2257.0 | 2235.1 | 2250.7 | 166313.0 |
| 2020-10-26 | ZN | Futures | 137.210907 | 137.582836 | 137.210907 | 137.505351 | 1168035.0 |
| 2020-10-26 | A6 | Futures | 0.73307 | 0.73379 | 0.72927 | 0.73163 | 85454.0 |
| 2020-10-26 | AD | Futures | 0.77215 | 0.7722 | 0.76637 | 0.76794 | 63126.0 |
| 2020-10-26 | ALI | Futures | 2185.62 | 2185.62 | 2185.32 | 2185.32 | 10.0 |
| 2020-10-26 | B | Futures | 26.36 | 26.41 | 25.57 | 25.71 | 225082.0 |
| 2020-10-26 | B6 | Futures | 1.3243 | 1.3261 | 1.3178 | 1.3204 | 80791.0 |
| 2020-10-26 | BR | Futures | 0.13967 | 0.13998 | 0.1379 | 0.13963 | 17506.0 |
| 2020-10-26 | BTC | Futures | 17427.0 | 17737.1 | 17083.9 | 17394.0 | 1519.0 |
| 2020-10-26 | BZ | Futures | 25.84 | 25.85 | 25.04 | 25.17 | 24007.0 |
| 2020-10-26 | C | Futures | 1506.0 | 1527.0 | 1501.0 | 1515.0 | 3066.0 |
| 2020-10-26 | CB | Futures | 157.541 | 157.541 | 157.541 | 157.541 | 8.0 |
| 2020-10-26 | CC | Futures | 1632.0 | 1655.0 | 1617.0 | 1640.0 | 16713.0 |
| 2020-10-26 | CNH | Futures | 6.5488 | 6.5948 | 6.5453 | 6.5815 | 751.0 |
| 2020-10-26 | CSC | Futures | 3.966 | 4.084 | 3.948 | 4.073 | 137.0 |
| 2020-10-26 | CT | Futures | 70.51 | 71.53 | 70.38 | 71.26 | 16208.0 |
| 2020-10-26 | DC | Futures | 32.33 | 33.7 | 32.33 | 33.43 | 667.0 |
| 2020-10-26 | DX | Futures | 89.593 | 89.941 | 89.574 | 89.877 | 14722.0 |
| 2020-10-26 | E1 | Futures | 1.25417 | 1.25428 | 1.24873 | 1.24964 | 15722.0 |
| 2020-10-26 | E6 | Futures | 1.27152 | 1.27179 | 1.26563 | 1.26681 | 154580.0 |
| 2020-10-26 | E7 | Futures | 1.265 | 1.265 | 1.2592 | 1.2604 | 5122.0 |
| 2020-10-26 | EBM | Futures | 251.96 | 251.96 | 248.94 | 249.85 | 30721.0 |
| 2020-10-26 | ED | Futures | 96.489 | 96.4939 | 96.4842 | 96.489 | 85413.0 |
| 2020-10-26 | ER | Futures | 98.445 | 98.45 | 98.44 | 98.445 | 66702.0 |
| 2020-10-26 | ESG | Futures | 318.22 | 319.09 | 312.36 | 315.44 | 49.0 |
| 2020-10-26 | EW | Futures | 2141.1 | 2141.1 | 2080.5 | 2104.7 | 12511.0 |
| 2020-10-26 | FBON | Futures | 148.63 | 149.46 | 148.63 | 148.82 | 693.0 |
| 2020-10-26 | FBTP | Futures | 137.14 | 137.53 | 136.66 | 136.81 | 147333.0 |
| 2020-10-26 | FBTS | Futures | 109.875 | 109.875 | 109.711 | 109.74 | 99538.0 |
| 2020-10-26 | FCE | Futures | 4698.1 | 4731.4 | 4621.2 | 4653.1 | 68797.0 |
| 2020-10-26 | FDAX | Futures | 13396.4 | 13425.8 | 12876.7 | 12975.8 | 111794.0 |
| 2020-10-26 | FDIV | Futures | 144.74 | 144.79 | 142.99 | 142.99 | 195.0 |
| 2020-10-26 | FDXM | Futures | 13340.6 | 13360.7 | 12813.3 | 12910.4 | 69457.0 |
| 2020-10-26 | FESX | Futures | 2937.1 | 2943.6 | 2841.9 | 2863.2 | 1058856.0 |
| 2020-10-26 | FGBL | Futures | 170.68 | 170.9 | 170.29 | 170.48 | 574580.0 |
| 2020-10-26 | FGBM | Futures | 135.56 | 135.6 | 135.4 | 135.47 | 265027.0 |
| 2020-10-26 | FGBS | Futures | 112.87 | 112.875 | 112.835 | 112.85 | 278337.0 |
| 2020-10-26 | FGBX | Futures | 235.6 | 236.65 | 234.66 | 235.18 | 58702.0 |
| 2020-10-26 | FMWO | Futures | 8409.4 | 8558.7 | 8344.3 | 8395.2 | 2639.0 |
| 2020-10-26 | FOAT | Futures | 158.8 | 158.96 | 158.34 | 158.48 | 128535.0 |
| 2020-10-26 | FTDX | Futures | 3073.0 | 3073.0 | 2985.0 | 3001.5 | 180.0 |
| 2020-10-26 | FTI | Futures | 508.59 | 510.68 | 502.14 | 505.06 | 24349.0 |
| 2020-10-26 | FTUK | Futures | 5558.2 | 5584.5 | 5477.4 | 5511.4 | 101899.0 |
| 2020-10-26 | FVSA | Futures | 190.03 | 208.28 | 190.03 | 200.05 | 36010.0 |
| 2020-10-26 | FXXP | Futures | 331.4 | 333.4 | 326.8 | 328.8 | 65016.0 |
| 2020-10-26 | G | Futures | 126.41 | 126.56 | 126.15 | 126.21 | 169746.0 |
> showing 50 of 120 rows — these rows as CSV