PREVIEW / futures_daily / 2020-10-19
file: by_date/futures_daily/2020/2020-10-19.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-19 | ES | Futures | 3899.6 | 3928.25 | 3831.91 | 3845.39 | 1645853.0 |
| 2020-10-19 | NQ | Futures | 13680.36 | 13835.2 | 13419.29 | 13487.6 | 623203.0 |
| 2020-10-19 | YM | Futures | 30678.2 | 30864.5 | 30171.1 | 30251.9 | 156936.0 |
| 2020-10-19 | CL | Futures | 29.17 | 29.55 | 29.06 | 29.27 | 314646.0 |
| 2020-10-19 | GC | Futures | 2247.7 | 2271.6 | 2244.2 | 2257.7 | 159852.0 |
| 2020-10-19 | ZN | Futures | 137.892777 | 137.908274 | 137.61383 | 137.784298 | 1040956.0 |
| 2020-10-19 | A6 | Futures | 0.72681 | 0.7305 | 0.72465 | 0.72527 | 80296.0 |
| 2020-10-19 | AD | Futures | 0.7683 | 0.77068 | 0.7682 | 0.76886 | 53330.0 |
| 2020-10-19 | ALI | Futures | 2224.12 | 2224.12 | 2217.01 | 2217.01 | 29.0 |
| 2020-10-19 | B | Futures | 26.94 | 27.28 | 26.73 | 26.89 | 209058.0 |
| 2020-10-19 | B6 | Futures | 1.3086 | 1.321 | 1.3082 | 1.3129 | 115006.0 |
| 2020-10-19 | BR | Futures | 0.13916 | 0.14097 | 0.13912 | 0.1403 | 594.0 |
| 2020-10-19 | BTC | Futures | 15458.6 | 16002.7 | 15411.5 | 15794.5 | 6876.0 |
| 2020-10-19 | BZ | Futures | 26.44 | 26.74 | 26.22 | 26.37 | 26265.0 |
| 2020-10-19 | C | Futures | 1461.0 | 1489.0 | 1459.0 | 1483.0 | 5093.0 |
| 2020-10-19 | CB | Futures | 161.098 | 162.623 | 161.098 | 162.623 | 58.0 |
| 2020-10-19 | CC | Futures | 1558.0 | 1600.0 | 1558.0 | 1592.0 | 15222.0 |
| 2020-10-19 | CNH | Futures | 6.5803 | 6.5836 | 6.5561 | 6.5663 | 988.0 |
| 2020-10-19 | CSC | Futures | 3.664 | 3.787 | 3.664 | 3.787 | 66.0 |
| 2020-10-19 | CT | Futures | 69.18 | 70.38 | 69.18 | 70.32 | 22482.0 |
| 2020-10-19 | DC | Futures | 29.96 | 31.02 | 29.85 | 31.02 | 319.0 |
| 2020-10-19 | DX | Futures | 90.53 | 90.583 | 90.023 | 90.249 | 21623.0 |
| 2020-10-19 | E1 | Futures | 1.23956 | 1.2476 | 1.2373 | 1.24613 | 17907.0 |
| 2020-10-19 | E6 | Futures | 1.25706 | 1.26482 | 1.25513 | 1.26204 | 176853.0 |
| 2020-10-19 | E7 | Futures | 1.2505 | 1.2584 | 1.2486 | 1.2557 | 6290.0 |
| 2020-10-19 | EBM | Futures | 253.76 | 255.57 | 251.65 | 255.27 | 38165.0 |
| 2020-10-19 | ED | Futures | 96.4939 | 96.4987 | 96.489 | 96.4987 | 70289.0 |
| 2020-10-19 | ER | Futures | 98.445 | 98.45 | 98.445 | 98.445 | 24939.0 |
| 2020-10-19 | ESG | Futures | 324.86 | 324.88 | 316.96 | 317.61 | 69.0 |
| 2020-10-19 | EW | Futures | 2131.8 | 2148.9 | 2101.8 | 2106.0 | 9807.0 |
| 2020-10-19 | FBON | Futures | 149.6 | 149.6 | 149.04 | 149.15 | 392.0 |
| 2020-10-19 | FBTP | Futures | 137.65 | 137.71 | 136.82 | 136.89 | 125774.0 |
| 2020-10-19 | FBTS | Futures | 109.73 | 109.759 | 109.614 | 109.633 | 101816.0 |
| 2020-10-19 | FCE | Futures | 4788.0 | 4826.7 | 4757.5 | 4774.4 | 40209.0 |
| 2020-10-19 | FDAX | Futures | 13762.7 | 13879.4 | 13549.4 | 13699.8 | 71340.0 |
| 2020-10-19 | FDXM | Futures | 13687.4 | 13809.4 | 13481.6 | 13630.7 | 46329.0 |
| 2020-10-19 | FESX | Futures | 2998.2 | 3028.7 | 2955.6 | 2991.7 | 673373.0 |
| 2020-10-19 | FGBL | Futures | 171.17 | 171.33 | 170.94 | 171.27 | 486447.0 |
| 2020-10-19 | FGBM | Futures | 135.67 | 135.77 | 135.64 | 135.74 | 261335.0 |
| 2020-10-19 | FGBS | Futures | 112.905 | 112.93 | 112.89 | 112.92 | 300720.0 |
| 2020-10-19 | FGBX | Futures | 237.73 | 238.34 | 236.63 | 237.94 | 48595.0 |
| 2020-10-19 | FMWO | Futures | 8619.1 | 8641.6 | 8520.8 | 8580.0 | 3628.0 |
| 2020-10-19 | FOAT | Futures | 159.13 | 159.22 | 158.81 | 159.03 | 145659.0 |
| 2020-10-19 | FTDX | Futures | 3265.4 | 3265.4 | 3205.7 | 3237.1 | 55.0 |
| 2020-10-19 | FTI | Futures | 527.52 | 531.56 | 523.76 | 525.05 | 14855.0 |
| 2020-10-19 | FTUK | Futures | 5644.7 | 5673.9 | 5562.5 | 5604.6 | 71492.0 |
| 2020-10-19 | FVSA | Futures | 176.43 | 188.24 | 171.78 | 180.36 | 19272.0 |
| 2020-10-19 | FXXP | Futures | 340.7 | 342.6 | 335.4 | 339.0 | 45055.0 |
| 2020-10-19 | G | Futures | 127.15 | 127.44 | 127.01 | 127.37 | 164402.0 |
| 2020-10-19 | GF | Futures | 261.659 | 261.659 | 251.83 | 251.927 | 6458.0 |
> showing 50 of 118 rows — these rows as CSV