PREVIEW / futures_daily / 2020-12-14
file: by_date/futures_daily/2020/2020-12-14.parquet size: 10 KB rows: 119
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-12-14 | ES | Futures | 4113.34 | 4137.44 | 4076.92 | 4079.72 | 2284730.0 |
| 2020-12-14 | NQ | Futures | 14318.54 | 14474.83 | 14288.56 | 14374.49 | 421789.0 |
| 2020-12-14 | YM | Futures | 32453.8 | 32656.8 | 32141.7 | 32161.1 | 170339.0 |
| 2020-12-14 | CL | Futures | 33.12 | 33.58 | 32.39 | 33.29 | 203128.0 |
| 2020-12-14 | GC | Futures | 2170.1 | 2170.8 | 2140.7 | 2154.9 | 168491.0 |
| 2020-12-14 | ZN | Futures | 137.227019 | 137.382429 | 136.978363 | 137.335806 | 1031410.0 |
| 2020-12-14 | A6 | Futures | 0.77536 | 0.77813 | 0.77269 | 0.77454 | 86676.0 |
| 2020-12-14 | AD | Futures | 0.79434 | 0.79677 | 0.79237 | 0.79424 | 76083.0 |
| 2020-12-14 | ALI | Futures | 2422.21 | 2427.81 | 2420.74 | 2427.81 | 51.0 |
| 2020-12-14 | B | Futures | 31.63 | 32.1 | 31.05 | 31.78 | 236959.0 |
| 2020-12-14 | B6 | Futures | 1.3548 | 1.3667 | 1.3509 | 1.3541 | 141077.0 |
| 2020-12-14 | BR | Futures | 0.155 | 0.15566 | 0.15215 | 0.15223 | 32.0 |
| 2020-12-14 | BTC | Futures | 24954.1 | 25312.3 | 24856.4 | 25103.9 | 6124.0 |
| 2020-12-14 | BZ | Futures | 30.94 | 31.4 | 30.4 | 31.08 | 28782.0 |
| 2020-12-14 | C | Futures | 1515.0 | 1519.0 | 1477.0 | 1490.0 | 5113.0 |
| 2020-12-14 | CB | Futures | 153.653 | 153.653 | 150.423 | 151.346 | 108.0 |
| 2020-12-14 | CC | Futures | 1735.0 | 1744.0 | 1696.0 | 1702.0 | 12679.0 |
| 2020-12-14 | CNH | Futures | 6.416 | 6.416 | 6.3909 | 6.405 | 934.0 |
| 2020-12-14 | CSC | Futures | 3.089 | 3.124 | 3.089 | 3.099 | 92.0 |
| 2020-12-14 | CT | Futures | 71.69 | 72.66 | 71.69 | 72.14 | 14720.0 |
| 2020-12-14 | DC | Futures | 26.25 | 26.81 | 26.23 | 26.32 | 206.0 |
| 2020-12-14 | DX | Futures | 87.722 | 87.833 | 87.35 | 87.649 | 23425.0 |
| 2020-12-14 | E1 | Futures | 1.27398 | 1.27906 | 1.27262 | 1.27601 | 18856.0 |
| 2020-12-14 | E6 | Futures | 1.29855 | 1.30325 | 1.29679 | 1.30004 | 186084.0 |
| 2020-12-14 | E7 | Futures | 1.2912 | 1.2969 | 1.2904 | 1.2936 | 8141.0 |
| 2020-12-14 | EBM | Futures | 258.53 | 259.15 | 253.6 | 254.22 | 30282.0 |
| 2020-12-14 | ED | Futures | 96.5276 | 96.5276 | 96.518 | 96.5276 | 167160.0 |
| 2020-12-14 | ER | Futures | 98.484 | 98.484 | 98.475 | 98.48 | 75345.0 |
| 2020-12-14 | ESG | Futures | 341.59 | 341.7 | 336.98 | 337.0 | 1427.0 |
| 2020-12-14 | EW | Futures | 2408.7 | 2425.2 | 2387.8 | 2388.9 | 43285.0 |
| 2020-12-14 | FBON | Futures | 151.17 | 151.31 | 151.06 | 151.28 | 44.0 |
| 2020-12-14 | FBTP | Futures | 139.13 | 139.34 | 139.01 | 139.27 | 66722.0 |
| 2020-12-14 | FBTS | Futures | 110.097 | 110.136 | 110.088 | 110.107 | 39332.0 |
| 2020-12-14 | FCE | Futures | 5371.0 | 5409.7 | 5345.6 | 5361.6 | 55649.0 |
| 2020-12-14 | FDAX | Futures | 14063.3 | 14172.1 | 14013.2 | 14116.1 | 73674.0 |
| 2020-12-14 | FDXM | Futures | 13981.4 | 14118.5 | 13981.4 | 14064.9 | 1924.0 |
| 2020-12-14 | FESX | Futures | 3245.8 | 3270.0 | 3232.8 | 3247.7 | 1062606.0 |
| 2020-12-14 | FEU3 | Futures | 99.218 | 99.223 | 99.218 | 99.223 | 1.0 |
| 2020-12-14 | FGBL | Futures | 170.9 | 171.08 | 170.67 | 170.94 | 444213.0 |
| 2020-12-14 | FGBM | Futures | 135.58 | 135.62 | 135.48 | 135.56 | 238898.0 |
| 2020-12-14 | FGBS | Futures | 112.825 | 112.84 | 112.805 | 112.82 | 228928.0 |
| 2020-12-14 | FGBX | Futures | 238.27 | 238.6 | 236.97 | 238.01 | 48015.0 |
| 2020-12-14 | FMWO | Futures | 9288.3 | 9325.0 | 9230.2 | 9287.1 | 17378.0 |
| 2020-12-14 | FOAT | Futures | 159.19 | 159.42 | 159.04 | 159.3 | 100501.0 |
| 2020-12-14 | FTDX | Futures | 3171.2 | 3206.7 | 3171.2 | 3206.7 | 539.0 |
| 2020-12-14 | FTI | Futures | 576.46 | 578.47 | 570.39 | 572.2 | 4482.0 |
| 2020-12-14 | FTUK | Futures | 6290.0 | 6291.9 | 6210.6 | 6248.6 | 290412.0 |
| 2020-12-14 | FVSA | Futures | 168.74 | 175.15 | 164.21 | 168.74 | 26526.0 |
| 2020-12-14 | FXXP | Futures | 363.5 | 365.4 | 361.6 | 363.4 | 170536.0 |
| 2020-12-14 | G | Futures | 127.14 | 127.27 | 126.61 | 126.97 | 222235.0 |
> showing 50 of 119 rows — these rows as CSV