PREVIEW / futures_daily / 2020-10-13
file: by_date/futures_daily/2020/2020-10-13.parquet size: 10 KB rows: 118
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-13 | ES | Futures | 3970.38 | 3972.35 | 3922.63 | 3937.52 | 1617226.0 |
| 2020-10-13 | NQ | Futures | 14008.28 | 14180.78 | 13914.5 | 14001.33 | 754735.0 |
| 2020-10-13 | YM | Futures | 31013.0 | 31031.3 | 30666.4 | 30774.0 | 217669.0 |
| 2020-10-13 | CL | Futures | 28.38 | 29.1 | 28.25 | 28.86 | 375470.0 |
| 2020-10-13 | GC | Futures | 2276.2 | 2280.1 | 2231.3 | 2237.5 | 267538.0 |
| 2020-10-13 | ZN | Futures | 137.768801 | 138.109736 | 137.753303 | 138.063245 | 1044436.0 |
| 2020-10-13 | A6 | Futures | 0.74015 | 0.74036 | 0.7342 | 0.73451 | 81746.0 |
| 2020-10-13 | AD | Futures | 0.77296 | 0.77367 | 0.77088 | 0.77129 | 76630.0 |
| 2020-10-13 | ALI | Futures | 2227.7 | 2228.3 | 2216.41 | 2225.33 | 123.0 |
| 2020-10-13 | B | Futures | 26.38 | 26.93 | 26.29 | 26.79 | 227845.0 |
| 2020-10-13 | B6 | Futures | 1.3252 | 1.3255 | 1.3107 | 1.3123 | 115941.0 |
| 2020-10-13 | BR | Futures | 0.14108 | 0.14108 | 0.13963 | 0.14073 | 64.0 |
| 2020-10-13 | BTC | Futures | 15801.2 | 15861.7 | 15257.0 | 15371.2 | 4170.0 |
| 2020-10-13 | BZ | Futures | 25.88 | 26.4 | 25.77 | 26.26 | 22528.0 |
| 2020-10-13 | C | Futures | 1482.0 | 1495.0 | 1458.0 | 1460.0 | 8956.0 |
| 2020-10-13 | CB | Futures | 157.541 | 158.582 | 157.541 | 158.582 | 8.0 |
| 2020-10-13 | CC | Futures | 1593.0 | 1602.0 | 1557.0 | 1564.0 | 24753.0 |
| 2020-10-13 | CNH | Futures | 6.645 | 6.6527 | 6.6208 | 6.6313 | 642.0 |
| 2020-10-13 | CSC | Futures | 3.527 | 3.542 | 3.516 | 3.536 | 103.0 |
| 2020-10-13 | CT | Futures | 67.86 | 68.44 | 67.46 | 68.02 | 14282.0 |
| 2020-10-13 | DC | Futures | 28.94 | 29.15 | 28.67 | 28.97 | 231.0 |
| 2020-10-13 | DX | Futures | 89.907 | 90.419 | 89.878 | 90.352 | 28342.0 |
| 2020-10-13 | E1 | Futures | 1.24783 | 1.24794 | 1.23888 | 1.24024 | 17562.0 |
| 2020-10-13 | E6 | Futures | 1.26691 | 1.26734 | 1.25813 | 1.25974 | 174331.0 |
| 2020-10-13 | E7 | Futures | 1.2607 | 1.2609 | 1.2517 | 1.2533 | 5774.0 |
| 2020-10-13 | EBM | Futures | 243.21 | 245.32 | 242.91 | 244.42 | 32476.0 |
| 2020-10-13 | ED | Futures | 96.4939 | 96.4939 | 96.489 | 96.489 | 54289.0 |
| 2020-10-13 | ER | Futures | 98.445 | 98.45 | 98.445 | 98.445 | 40008.0 |
| 2020-10-13 | ESG | Futures | 327.33 | 327.35 | 325.47 | 326.33 | 38.0 |
| 2020-10-13 | EW | Futures | 2147.7 | 2147.7 | 2121.6 | 2127.4 | 12440.0 |
| 2020-10-13 | FBON | Futures | 149.49 | 149.49 | 149.13 | 149.36 | 348.0 |
| 2020-10-13 | FBTP | Futures | 137.33 | 137.58 | 137.15 | 137.48 | 124896.0 |
| 2020-10-13 | FBTS | Futures | 109.74 | 109.74 | 109.653 | 109.711 | 67598.0 |
| 2020-10-13 | FCE | Futures | 4824.7 | 4824.7 | 4759.9 | 4778.8 | 54075.0 |
| 2020-10-13 | FDAX | Futures | 14005.2 | 14022.8 | 13797.3 | 13844.2 | 75237.0 |
| 2020-10-13 | FDIV | Futures | 149.67 | 149.67 | 149.0 | 149.15 | 90.0 |
| 2020-10-13 | FDXM | Futures | 13938.8 | 13952.6 | 13727.7 | 13774.4 | 48449.0 |
| 2020-10-13 | FESX | Futures | 3043.5 | 3048.1 | 3010.2 | 3020.3 | 770519.0 |
| 2020-10-13 | FGBL | Futures | 170.07 | 170.32 | 169.96 | 170.25 | 493005.0 |
| 2020-10-13 | FGBM | Futures | 135.34 | 135.4 | 135.29 | 135.36 | 292222.0 |
| 2020-10-13 | FGBS | Futures | 112.795 | 112.825 | 112.795 | 112.81 | 303231.0 |
| 2020-10-13 | FGBX | Futures | 233.6 | 234.56 | 232.99 | 234.27 | 52009.0 |
| 2020-10-13 | FMWO | Futures | 8693.7 | 8726.8 | 8648.7 | 8683.0 | 1624.0 |
| 2020-10-13 | FOAT | Futures | 158.33 | 158.54 | 158.22 | 158.47 | 121429.0 |
| 2020-10-13 | FTDX | Futures | 3307.6 | 3307.6 | 3262.8 | 3280.8 | 188.0 |
| 2020-10-13 | FTI | Futures | 530.14 | 532.49 | 526.66 | 529.66 | 13205.0 |
| 2020-10-13 | FTUK | Futures | 5729.8 | 5737.0 | 5660.5 | 5673.9 | 96616.0 |
| 2020-10-13 | FVSA | Futures | 171.06 | 174.64 | 169.99 | 172.13 | 10291.0 |
| 2020-10-13 | FXXP | Futures | 346.0 | 346.0 | 341.5 | 342.4 | 36841.0 |
| 2020-10-13 | G | Futures | 126.32 | 126.74 | 126.28 | 126.66 | 264368.0 |
> showing 50 of 118 rows — these rows as CSV