PREVIEW / futures_daily / 2021-03-23
file: by_date/futures_daily/2021/2021-03-23.parquet size: 10 KB rows: 122
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-23 | ES | Futures | 4413.71 | 4419.89 | 4365.74 | 4376.12 | 1877976.0 |
| 2021-03-23 | NQ | Futures | 15074.03 | 15192.84 | 14970.23 | 15001.66 | 604250.0 |
| 2021-03-23 | YM | Futures | 35331.8 | 35380.5 | 34889.1 | 34965.9 | 180140.0 |
| 2021-03-23 | CL | Futures | 43.62 | 43.67 | 40.75 | 41.12 | 712317.0 |
| 2021-03-23 | GC | Futures | 2041.0 | 2045.1 | 2022.4 | 2025.2 | 226204.0 |
| 2021-03-23 | ZN | Futures | 132.154598 | 132.76708 | 132.107484 | 132.594328 | 1562826.0 |
| 2021-03-23 | A6 | Futures | 0.79438 | 0.79464 | 0.78131 | 0.78398 | 108175.0 |
| 2021-03-23 | AD | Futures | 0.80923 | 0.80954 | 0.80457 | 0.80614 | 76615.0 |
| 2021-03-23 | ALI | Futures | 2594.63 | 2605.31 | 2574.14 | 2599.83 | 722.0 |
| 2021-03-23 | B | Futures | 41.16 | 41.16 | 38.58 | 38.91 | 392600.0 |
| 2021-03-23 | B6 | Futures | 1.4077 | 1.4083 | 1.3956 | 1.3974 | 92843.0 |
| 2021-03-23 | BFX | Futures | 3900.1 | 3916.2 | 3900.1 | 3908.6 | 11.0 |
| 2021-03-23 | BR | Futures | 0.14186 | 0.14439 | 0.13996 | 0.14348 | 173.0 |
| 2021-03-23 | BTC | Futures | 70989.6 | 72587.0 | 68717.0 | 71405.2 | 8663.0 |
| 2021-03-23 | BZ | Futures | 40.3 | 40.32 | 37.76 | 38.09 | 43200.0 |
| 2021-03-23 | C | Futures | 1593.0 | 1598.0 | 1570.0 | 1572.0 | 4701.0 |
| 2021-03-23 | CB | Futures | 142.429 | 143.647 | 142.429 | 142.842 | 15.0 |
| 2021-03-23 | CC | Futures | 1689.0 | 1692.0 | 1646.0 | 1649.0 | 17807.0 |
| 2021-03-23 | CNH | Futures | 6.343 | 6.3543 | 6.343 | 6.3533 | 210.0 |
| 2021-03-23 | CSC | Futures | 2.808 | 2.814 | 2.796 | 2.806 | 110.0 |
| 2021-03-23 | CT | Futures | 80.04 | 80.3 | 78.86 | 79.03 | 10225.0 |
| 2021-03-23 | DC | Futures | 24.97 | 24.99 | 24.78 | 24.94 | 132.0 |
| 2021-03-23 | DX | Futures | 88.722 | 89.292 | 88.683 | 89.241 | 27705.0 |
| 2021-03-23 | E1 | Futures | 1.22182 | 1.22194 | 1.20674 | 1.20776 | 26905.0 |
| 2021-03-23 | E6 | Futures | 1.27393 | 1.27468 | 1.26413 | 1.26514 | 176362.0 |
| 2021-03-23 | E7 | Futures | 1.2677 | 1.2681 | 1.2578 | 1.2587 | 5477.0 |
| 2021-03-23 | EBM | Futures | 279.06 | 283.85 | 278.75 | 282.26 | 21558.0 |
| 2021-03-23 | ED | Futures | 96.5125 | 96.5125 | 96.5028 | 96.5077 | 190869.0 |
| 2021-03-23 | ER | Futures | 98.46 | 98.465 | 98.455 | 98.46 | 55869.0 |
| 2021-03-23 | ESG | Futures | 361.7 | 364.34 | 360.11 | 361.0 | 648.0 |
| 2021-03-23 | EW | Futures | 2781.5 | 2785.3 | 2689.7 | 2700.7 | 11647.0 |
| 2021-03-23 | FBON | Futures | 148.69 | 149.14 | 148.69 | 149.13 | 739.0 |
| 2021-03-23 | FBTP | Futures | 139.24 | 139.68 | 139.18 | 139.63 | 105645.0 |
| 2021-03-23 | FBTS | Futures | 110.137 | 110.175 | 110.098 | 110.166 | 70107.0 |
| 2021-03-23 | FCE | Futures | 5785.3 | 5813.6 | 5759.9 | 5791.1 | 45158.0 |
| 2021-03-23 | FDAX | Futures | 15656.1 | 15692.3 | 15485.5 | 15668.9 | 57973.0 |
| 2021-03-23 | FDIV | Futures | 176.42 | 178.24 | 176.42 | 178.19 | 125.0 |
| 2021-03-23 | FDXM | Futures | 15636.0 | 15673.2 | 15466.7 | 15649.8 | 53322.0 |
| 2021-03-23 | FESX | Futures | 3570.1 | 3574.9 | 3537.0 | 3566.4 | 750876.0 |
| 2021-03-23 | FGBL | Futures | 167.72 | 168.34 | 167.6 | 168.09 | 775981.0 |
| 2021-03-23 | FGBM | Futures | 134.97 | 135.12 | 134.93 | 135.05 | 422230.0 |
| 2021-03-23 | FGBS | Futures | 112.664 | 112.694 | 112.664 | 112.684 | 254986.0 |
| 2021-03-23 | FGBX | Futures | 218.59 | 220.8 | 218.13 | 219.89 | 77095.0 |
| 2021-03-23 | FMWO | Futures | 9857.6 | 9858.8 | 9744.9 | 9825.9 | 1669.0 |
| 2021-03-23 | FOAT | Futures | 156.03 | 156.55 | 155.9 | 156.39 | 183444.0 |
| 2021-03-23 | FTDX | Futures | 3494.6 | 3528.5 | 3485.4 | 3513.1 | 61.0 |
| 2021-03-23 | FTI | Futures | 639.02 | 641.13 | 634.18 | 638.75 | 19540.0 |
| 2021-03-23 | FTUK | Futures | 6490.0 | 6494.4 | 6431.1 | 6477.8 | 78443.0 |
| 2021-03-23 | FVSA | Futures | 109.17 | 115.73 | 109.17 | 110.88 | 16584.0 |
| 2021-03-23 | FXXP | Futures | 395.1 | 397.2 | 393.8 | 396.4 | 45943.0 |
> showing 50 of 122 rows — these rows as CSV