PREVIEW / futures_daily / 2021-03-19
file: by_date/futures_daily/2021/2021-03-19.parquet size: 10 KB rows: 123
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-03-19 | ES | Futures | 4388.46 | 4402.77 | 4348.35 | 4376.12 | 2047619.0 |
| 2021-03-19 | NQ | Futures | 14756.27 | 14877.09 | 14627.37 | 14815.09 | 641117.0 |
| 2021-03-19 | YM | Futures | 35476.8 | 35573.1 | 35068.8 | 35179.2 | 210458.0 |
| 2021-03-19 | CL | Futures | 42.46 | 43.99 | 42.01 | 43.74 | 723883.0 |
| 2021-03-19 | GC | Futures | 2035.3 | 2049.9 | 2027.6 | 2044.7 | 213282.0 |
| 2021-03-19 | ZN | Futures | 132.013257 | 132.343054 | 131.699164 | 131.887619 | 2193356.0 |
| 2021-03-19 | A6 | Futures | 0.79577 | 0.79715 | 0.79151 | 0.79474 | 92636.0 |
| 2021-03-19 | AD | Futures | 0.81126 | 0.81308 | 0.80756 | 0.81095 | 74264.0 |
| 2021-03-19 | ALI | Futures | 2586.26 | 2659.29 | 2586.26 | 2618.59 | 710.0 |
| 2021-03-19 | B | Futures | 40.32 | 41.57 | 39.73 | 41.31 | 446114.0 |
| 2021-03-19 | B6 | Futures | 1.4148 | 1.4179 | 1.4048 | 1.4089 | 100046.0 |
| 2021-03-19 | BFX | Futures | 3916.7 | 3922.2 | 3894.0 | 3900.6 | 40.0 |
| 2021-03-19 | BR | Futures | 0.14253 | 0.14451 | 0.14253 | 0.14392 | 86.0 |
| 2021-03-19 | BTC | Futures | 75255.6 | 77365.9 | 73132.4 | 76586.7 | 6553.0 |
| 2021-03-19 | BZ | Futures | 39.37 | 40.67 | 38.9 | 40.44 | 54241.0 |
| 2021-03-19 | C | Futures | 1609.0 | 1609.0 | 1575.0 | 1592.0 | 5614.0 |
| 2021-03-19 | CB | Futures | 142.822 | 143.668 | 142.429 | 143.668 | 16.0 |
| 2021-03-19 | CC | Futures | 1713.0 | 1713.0 | 1661.0 | 1680.0 | 18857.0 |
| 2021-03-19 | CNH | Futures | 6.3516 | 6.3604 | 6.3423 | 6.3452 | 239.0 |
| 2021-03-19 | CSC | Futures | 2.841 | 2.841 | 2.828 | 2.828 | 37.0 |
| 2021-03-19 | CT | Futures | 81.12 | 81.16 | 79.15 | 80.12 | 14630.0 |
| 2021-03-19 | DC | Futures | 25.32 | 25.38 | 25.15 | 25.25 | 111.0 |
| 2021-03-19 | DX | Futures | 88.76 | 89.084 | 88.581 | 88.833 | 32375.0 |
| 2021-03-19 | E1 | Futures | 1.21609 | 1.21935 | 1.21035 | 1.21417 | 18475.0 |
| 2021-03-19 | E6 | Futures | 1.27191 | 1.27431 | 1.26754 | 1.27121 | 174375.0 |
| 2021-03-19 | E7 | Futures | 1.2655 | 1.2678 | 1.2612 | 1.2648 | 4839.0 |
| 2021-03-19 | EBM | Futures | 282.26 | 282.58 | 279.06 | 280.66 | 23277.0 |
| 2021-03-19 | ED | Futures | 96.5125 | 96.5173 | 96.5077 | 96.5125 | 193118.0 |
| 2021-03-19 | ER | Futures | 98.46 | 98.47 | 98.455 | 98.465 | 131495.0 |
| 2021-03-19 | ESG | Futures | 361.59 | 361.79 | 358.35 | 360.28 | 617.0 |
| 2021-03-19 | EW | Futures | 2798.3 | 2815.0 | 2762.3 | 2789.2 | 14961.0 |
| 2021-03-19 | FBON | Futures | 148.18 | 148.64 | 148.18 | 148.42 | 363.0 |
| 2021-03-19 | FBTP | Futures | 138.8 | 139.18 | 138.59 | 138.9 | 133986.0 |
| 2021-03-19 | FBTS | Futures | 110.059 | 110.127 | 110.049 | 110.107 | 67343.0 |
| 2021-03-19 | FCE | Futures | 5860.9 | 5892.1 | 5826.3 | 5840.9 | 87112.0 |
| 2021-03-19 | FDAX | Futures | 15681.6 | 15736.0 | 15536.7 | 15628.3 | 75346.0 |
| 2021-03-19 | FDIV | Futures | 179.85 | 179.9 | 178.04 | 178.53 | 179.0 |
| 2021-03-19 | FDXM | Futures | 15645.5 | 15716.9 | 15518.8 | 15609.3 | 53557.0 |
| 2021-03-19 | FESX | Futures | 3575.8 | 3593.8 | 3551.2 | 3574.9 | 1354500.0 |
| 2021-03-19 | FEU3 | Futures | 99.213 | 99.213 | 99.208 | 99.208 | 100.0 |
| 2021-03-19 | FGBL | Futures | 167.15 | 167.61 | 167.12 | 167.41 | 665343.0 |
| 2021-03-19 | FGBM | Futures | 134.76 | 134.91 | 134.75 | 134.87 | 374817.0 |
| 2021-03-19 | FGBS | Futures | 112.644 | 112.664 | 112.639 | 112.664 | 248659.0 |
| 2021-03-19 | FGBX | Futures | 217.36 | 218.85 | 216.83 | 217.64 | 66256.0 |
| 2021-03-19 | FMWO | Futures | 9825.9 | 9845.9 | 9735.5 | 9817.7 | 5646.0 |
| 2021-03-19 | FOAT | Futures | 155.55 | 155.99 | 155.52 | 155.79 | 147478.0 |
| 2021-03-19 | FTDX | Futures | 3496.7 | 3496.7 | 3448.4 | 3475.6 | 301.0 |
| 2021-03-19 | FTI | Futures | 634.37 | 640.38 | 632.31 | 638.66 | 25533.0 |
| 2021-03-19 | FTUK | Futures | 6517.8 | 6528.5 | 6437.9 | 6495.8 | 150271.0 |
| 2021-03-19 | FVSA | Futures | 118.58 | 123.14 | 115.73 | 116.58 | 31290.0 |
> showing 50 of 123 rows — these rows as CSV