PREVIEW / futures_daily / 2022-05-24
file: by_date/futures_daily/2022/2022-05-24.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 |
|---|---|---|---|---|---|---|---|
| 2022-05-24 | ES | Futures | 4445.22 | 4448.31 | 4355.51 | 4432.56 | 2017453.0 |
| 2022-05-24 | NQ | Futures | 13690.83 | 13694.28 | 13301.59 | 13525.37 | 717429.0 |
| 2022-05-24 | YM | Futures | 34791.3 | 34999.3 | 34280.1 | 34898.6 | 204978.0 |
| 2022-05-24 | CL | Futures | 89.27 | 90.09 | 87.81 | 88.75 | 224794.0 |
| 2022-05-24 | GC | Futures | 2153.9 | 2173.5 | 2148.5 | 2169.2 | 174762.0 |
| 2022-05-24 | ZN | Futures | 122.435493 | 123.490696 | 122.339566 | 123.170938 | 3479511.0 |
| 2022-05-24 | A6 | Futures | 0.72801 | 0.72837 | 0.72259 | 0.7253 | 85053.0 |
| 2022-05-24 | AD | Futures | 0.79308 | 0.79308 | 0.7867 | 0.78898 | 81325.0 |
| 2022-05-24 | ALI | Futures | 3336.07 | 3348.56 | 3288.67 | 3297.76 | 416.0 |
| 2022-05-24 | B | Futures | 85.71 | 87.11 | 84.88 | 86.3 | 191734.0 |
| 2022-05-24 | B6 | Futures | 1.2769 | 1.2777 | 1.2649 | 1.2689 | 105723.0 |
| 2022-05-24 | BR | Futures | 0.1752 | 0.17643 | 0.1736 | 0.17478 | 32489.0 |
| 2022-05-24 | BTC | Futures | 40290.8 | 40780.3 | 39449.7 | 40449.4 | 5115.0 |
| 2022-05-24 | BZ | Futures | 84.31 | 85.25 | 83.09 | 84.46 | 20941.0 |
| 2022-05-24 | C | Futures | 1299.0 | 1318.0 | 1299.0 | 1308.0 | 5589.0 |
| 2022-05-24 | CB | Futures | 220.826 | 222.398 | 220.786 | 222.398 | 8.0 |
| 2022-05-24 | CC | Futures | 1485.0 | 1497.0 | 1478.0 | 1486.0 | 13882.0 |
| 2022-05-24 | CNH | Futures | 6.3011 | 6.331 | 6.2983 | 6.3033 | 1286.0 |
| 2022-05-24 | CSC | Futures | 3.192 | 3.192 | 3.161 | 3.167 | 50.0 |
| 2022-05-24 | CT | Futures | 145.08 | 145.15 | 142.98 | 143.85 | 13333.0 |
| 2022-05-24 | DC | Futures | 30.76 | 30.83 | 30.48 | 30.6 | 385.0 |
| 2022-05-24 | DX | Futures | 98.494 | 98.677 | 98.021 | 98.229 | 28494.0 |
| 2022-05-24 | E1 | Futures | 1.15317 | 1.16307 | 1.15156 | 1.15885 | 23545.0 |
| 2022-05-24 | E6 | Futures | 1.13113 | 1.13695 | 1.12775 | 1.13446 | 201509.0 |
| 2022-05-24 | E7 | Futures | 1.1244 | 1.1304 | 1.1213 | 1.128 | 6744.0 |
| 2022-05-24 | EBM | Futures | 601.16 | 603.97 | 573.47 | 575.57 | 30095.0 |
| 2022-05-24 | ED | Futures | 95.5836 | 95.6055 | 95.5811 | 95.6055 | 93076.0 |
| 2022-05-24 | ER | Futures | 98.357 | 98.362 | 98.337 | 98.352 | 92145.0 |
| 2022-05-24 | ESG | Futures | 371.64 | 375.12 | 367.84 | 374.05 | 419.0 |
| 2022-05-24 | EW | Futures | 2613.8 | 2616.9 | 2545.5 | 2591.1 | 10338.0 |
| 2022-05-24 | FBON | Futures | 131.88 | 132.06 | 130.99 | 132.06 | 58.0 |
| 2022-05-24 | FBTP | Futures | 117.1 | 117.63 | 116.4 | 117.52 | 177595.0 |
| 2022-05-24 | FBTS | Futures | 107.392 | 107.52 | 107.265 | 107.48 | 104143.0 |
| 2022-05-24 | FCE | Futures | 6694.0 | 6722.8 | 6635.8 | 6647.0 | 65178.0 |
| 2022-05-24 | FDAX | Futures | 15085.8 | 15121.1 | 14872.8 | 14888.8 | 61581.0 |
| 2022-05-24 | FDXM | Futures | 15105.0 | 15139.3 | 14888.6 | 14904.7 | 44439.0 |
| 2022-05-24 | FDXS | Futures | 15003.3 | 15024.6 | 14784.2 | 14797.0 | 19264.0 |
| 2022-05-24 | FESX | Futures | 3603.9 | 3613.7 | 3560.8 | 3568.6 | 772457.0 |
| 2022-05-24 | FGBL | Futures | 151.53 | 152.4 | 151.2 | 152.36 | 940979.0 |
| 2022-05-24 | FGBM | Futures | 127.53 | 127.94 | 127.33 | 127.92 | 600375.0 |
| 2022-05-24 | FGBS | Futures | 111.214 | 111.33 | 111.154 | 111.32 | 400746.0 |
| 2022-05-24 | FGBX | Futures | 182.97 | 184.43 | 181.53 | 184.11 | 97141.0 |
| 2022-05-24 | FMWO | Futures | 9658.4 | 9680.8 | 9528.3 | 9553.1 | 3660.0 |
| 2022-05-24 | FOAT | Futures | 139.52 | 140.17 | 139.12 | 140.09 | 224399.0 |
| 2022-05-24 | FSMX | Futures | 30660.4 | 30687.7 | 30225.0 | 30301.6 | 316.0 |
| 2022-05-24 | FTDX | Futures | 3233.1 | 3260.5 | 3217.3 | 3223.7 | 23.0 |
| 2022-05-24 | FTI | Futures | 678.42 | 679.31 | 669.49 | 670.62 | 23473.0 |
| 2022-05-24 | FTUK | Futures | 7449.1 | 7513.9 | 7404.1 | 7461.5 | 90622.0 |
| 2022-05-24 | FVSA | Futures | 87.63 | 88.68 | 84.92 | 88.23 | 17078.0 |
| 2022-05-24 | FXXP | Futures | 421.9 | 423.7 | 419.6 | 420.5 | 45953.0 |
> showing 50 of 123 rows — these rows as CSV