PREVIEW / futures_daily / 2024-03-27
file: by_date/futures_daily/2024/2024-03-27.parquet size: 10 KB rows: 130
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 |
|---|---|---|---|---|---|---|---|
| 2024-03-27 | ES | Futures | 5509.09 | 5551.4 | 5506.48 | 5545.66 | 1487671.0 |
| 2024-03-27 | NQ | Futures | 19404.41 | 19503.39 | 19300.44 | 19431.97 | 605634.0 |
| 2024-03-27 | YM | Futures | 40917.2 | 41356.7 | 40904.9 | 41318.7 | 128240.0 |
| 2024-03-27 | CL | Futures | 72.85 | 73.25 | 72.18 | 72.9 | 249964.0 |
| 2024-03-27 | GC | Futures | 2300.6 | 2319.2 | 2293.5 | 2313.4 | 191456.0 |
| 2024-03-27 | ZN | Futures | 111.441633 | 111.772087 | 111.347218 | 111.661936 | 1466914.0 |
| 2024-03-27 | A6 | Futures | 0.65677 | 0.65727 | 0.65451 | 0.65632 | 69448.0 |
| 2024-03-27 | AD | Futures | 0.74108 | 0.74218 | 0.73982 | 0.74153 | 68630.0 |
| 2024-03-27 | ALI | Futures | 2517.43 | 2517.43 | 2489.14 | 2510.01 | 1198.0 |
| 2024-03-27 | B | Futures | 80.07 | 80.47 | 79.42 | 80.2 | 369265.0 |
| 2024-03-27 | B6 | Futures | 1.2629 | 1.2642 | 1.2606 | 1.2633 | 76592.0 |
| 2024-03-27 | BFX | Futures | 3826.1 | 3826.1 | 3826.1 | 3826.1 | 0.0 |
| 2024-03-27 | BR | Futures | 0.19335 | 0.19335 | 0.19335 | 0.19335 | 0.0 |
| 2024-03-27 | BTC | Futures | 82954.7 | 84928.6 | 80857.9 | 81191.7 | 10303.0 |
| 2024-03-27 | BZ | Futures | 78.97 | 79.33 | 78.31 | 79.07 | 29801.0 |
| 2024-03-27 | C | Futures | 7135.0 | 7205.0 | 6882.0 | 7186.0 | 10331.0 |
| 2024-03-27 | CB | Futures | 292.105 | 292.105 | 289.114 | 289.114 | 2.0 |
| 2024-03-27 | CC | Futures | 5571.0 | 5811.0 | 5430.0 | 5767.0 | 23291.0 |
| 2024-03-27 | CNH | Futures | 7.0804 | 7.0961 | 7.0804 | 7.0902 | 488.0 |
| 2024-03-27 | CSC | Futures | 1.627 | 1.627 | 1.601 | 1.607 | 110.0 |
| 2024-03-27 | CT | Futures | 112.24 | 112.24 | 108.81 | 109.06 | 21775.0 |
| 2024-03-27 | DC | Futures | 15.71 | 15.74 | 15.46 | 15.5 | 451.0 |
| 2024-03-27 | DX | Futures | 103.25 | 103.409 | 103.166 | 103.309 | 11294.0 |
| 2024-03-27 | E1 | Futures | 1.1479 | 1.14826 | 1.14337 | 1.14543 | 23221.0 |
| 2024-03-27 | E6 | Futures | 1.09711 | 1.09767 | 1.09484 | 1.096 | 158436.0 |
| 2024-03-27 | E7 | Futures | 1.0969 | 1.0974 | 1.0946 | 1.0958 | 2357.0 |
| 2024-03-27 | EBM | Futures | 259.34 | 260.31 | 257.4 | 259.67 | 30947.0 |
| 2024-03-27 | ER | Futures | 97.569 | 97.574 | 97.563 | 97.569 | 94206.0 |
| 2024-03-27 | ESG | Futures | 465.9 | 468.8 | 465.34 | 468.48 | 548.0 |
| 2024-03-27 | EW | Futures | 3093.4 | 3144.9 | 3093.0 | 3140.6 | 11616.0 |
| 2024-03-27 | FBON | Futures | 124.27 | 124.6 | 124.13 | 124.5 | 422.0 |
| 2024-03-27 | FBTP | Futures | 118.39 | 118.62 | 118.19 | 118.54 | 240872.0 |
| 2024-03-27 | FBTS | Futures | 106.503 | 106.574 | 106.473 | 106.544 | 115060.0 |
| 2024-03-27 | FCE | Futures | 8454.6 | 8501.0 | 8439.2 | 8472.7 | 33665.0 |
| 2024-03-27 | FDAX | Futures | 19283.4 | 19443.6 | 19277.2 | 19373.3 | 43621.0 |
| 2024-03-27 | FDIV | Futures | 192.06 | 193.11 | 192.06 | 193.11 | 25.0 |
| 2024-03-27 | FDXM | Futures | 19153.0 | 19302.8 | 19146.8 | 19242.3 | 34980.0 |
| 2024-03-27 | FDXS | Futures | 19042.7 | 19197.9 | 19040.7 | 19136.7 | 18713.0 |
| 2024-03-27 | FESX | Futures | 5066.7 | 5105.0 | 5064.7 | 5084.9 | 677617.0 |
| 2024-03-27 | FEU3 | Futures | 97.579 | 97.584 | 97.574 | 97.584 | 2718.0 |
| 2024-03-27 | FGBL | Futures | 134.94 | 135.55 | 134.87 | 135.44 | 865564.0 |
| 2024-03-27 | FGBM | Futures | 118.21 | 118.51 | 118.19 | 118.45 | 600638.0 |
| 2024-03-27 | FGBS | Futures | 106.733 | 106.819 | 106.733 | 106.804 | 469942.0 |
| 2024-03-27 | FGBX | Futures | 137.0 | 138.47 | 136.86 | 138.21 | 94235.0 |
| 2024-03-27 | FMWO | Futures | 11624.9 | 11673.0 | 11589.6 | 11602.5 | 4726.0 |
| 2024-03-27 | FOAT | Futures | 126.99 | 127.5 | 126.95 | 127.43 | 203253.0 |
| 2024-03-27 | FSMX | Futures | 27533.7 | 27785.7 | 27533.7 | 27770.5 | 470.0 |
| 2024-03-27 | FTDX | Futures | 3576.0 | 3596.0 | 3576.0 | 3587.3 | 19.0 |
| 2024-03-27 | FTI | Futures | 900.13 | 905.55 | 899.46 | 900.91 | 6562.0 |
| 2024-03-27 | FTUK | Futures | 7967.7 | 7990.2 | 7929.6 | 7970.7 | 78951.0 |
> showing 50 of 130 rows — these rows as CSV