PREVIEW / futures_daily / 2021-09-24
file: by_date/futures_daily/2021/2021-09-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 |
|---|---|---|---|---|---|---|---|
| 2021-09-24 | ES | Futures | 4993.39 | 5009.14 | 4961.62 | 5000.99 | 1182037.0 |
| 2021-09-24 | NQ | Futures | 17643.41 | 17682.62 | 17501.0 | 17664.75 | 470511.0 |
| 2021-09-24 | YM | Futures | 37700.3 | 37791.7 | 37492.5 | 37726.4 | 151185.0 |
| 2021-09-24 | CL | Futures | 53.93 | 54.69 | 53.61 | 54.48 | 350382.0 |
| 2021-09-24 | GC | Futures | 2034.3 | 2051.0 | 2030.2 | 2043.6 | 151552.0 |
| 2021-09-24 | ZN | Futures | 134.448818 | 134.703065 | 134.210462 | 134.258133 | 1813289.0 |
| 2021-09-24 | A6 | Futures | 0.74803 | 0.75034 | 0.74198 | 0.74414 | 79894.0 |
| 2021-09-24 | AD | Futures | 0.80202 | 0.80303 | 0.79735 | 0.80171 | 71514.0 |
| 2021-09-24 | ALI | Futures | 3335.93 | 3348.6 | 3306.36 | 3326.07 | 294.0 |
| 2021-09-24 | B | Futures | 52.02 | 52.68 | 51.74 | 52.58 | 163225.0 |
| 2021-09-24 | B6 | Futures | 1.3932 | 1.3945 | 1.3865 | 1.3867 | 81945.0 |
| 2021-09-24 | BR | Futures | 0.1508 | 0.15117 | 0.15003 | 0.15048 | 21.0 |
| 2021-09-24 | BTC | Futures | 59634.0 | 60345.3 | 54262.2 | 56535.9 | 11471.0 |
| 2021-09-24 | BZ | Futures | 50.63 | 51.33 | 50.43 | 51.23 | 20417.0 |
| 2021-09-24 | C | Futures | 1566.0 | 1574.0 | 1541.0 | 1548.0 | 7595.0 |
| 2021-09-24 | CB | Futures | 141.051 | 141.051 | 139.869 | 139.869 | 10.0 |
| 2021-09-24 | CC | Futures | 1675.0 | 1680.0 | 1644.0 | 1664.0 | 16078.0 |
| 2021-09-24 | CNH | Futures | 6.2295 | 6.2385 | 6.2274 | 6.23 | 171.0 |
| 2021-09-24 | CSC | Futures | 2.41 | 2.41 | 2.407 | 2.41 | 6.0 |
| 2021-09-24 | CT | Futures | 86.3 | 89.74 | 85.97 | 89.59 | 40664.0 |
| 2021-09-24 | DC | Futures | 22.11 | 22.23 | 22.11 | 22.15 | 25.0 |
| 2021-09-24 | DX | Futures | 89.945 | 90.26 | 89.902 | 90.182 | 17035.0 |
| 2021-09-24 | E1 | Futures | 1.21384 | 1.21676 | 1.21172 | 1.21295 | 17845.0 |
| 2021-09-24 | E6 | Futures | 1.24915 | 1.25005 | 1.24506 | 1.24665 | 132845.0 |
| 2021-09-24 | E7 | Futures | 1.2424 | 1.2433 | 1.2383 | 1.2399 | 2419.0 |
| 2021-09-24 | EBM | Futures | 370.7 | 372.91 | 367.03 | 372.17 | 19671.0 |
| 2021-09-24 | ED | Futures | 96.5392 | 96.5537 | 96.5392 | 96.5441 | 252437.0 |
| 2021-09-24 | ER | Futures | 98.475 | 98.475 | 98.47 | 98.47 | 26117.0 |
| 2021-09-24 | ESG | Futures | 410.22 | 412.99 | 409.52 | 412.65 | 238.0 |
| 2021-09-24 | EW | Futures | 2906.5 | 2912.8 | 2880.6 | 2896.0 | 11850.0 |
| 2021-09-24 | FBON | Futures | 149.52 | 149.69 | 149.27 | 149.42 | 1099.0 |
| 2021-09-24 | FBTP | Futures | 139.88 | 139.9 | 139.11 | 139.35 | 186875.0 |
| 2021-09-24 | FBTS | Futures | 110.448 | 110.448 | 110.371 | 110.4 | 95802.0 |
| 2021-09-24 | FCE | Futures | 6700.8 | 6711.4 | 6629.2 | 6643.7 | 54588.0 |
| 2021-09-24 | FDAX | Futures | 16750.9 | 16833.2 | 16538.2 | 16568.2 | 63601.0 |
| 2021-09-24 | FDIV | Futures | 183.38 | 183.73 | 183.28 | 183.58 | 55.0 |
| 2021-09-24 | FDXM | Futures | 16793.3 | 16871.5 | 16585.3 | 16615.3 | 48346.0 |
| 2021-09-24 | FDXS | Futures | 16625.6 | 16715.9 | 16431.3 | 16461.0 | 18592.0 |
| 2021-09-24 | FESX | Futures | 4008.2 | 4022.5 | 3953.6 | 3961.3 | 574223.0 |
| 2021-09-24 | FGBL | Futures | 168.07 | 168.1 | 167.63 | 167.78 | 805242.0 |
| 2021-09-24 | FGBM | Futures | 134.81 | 134.81 | 134.69 | 134.74 | 443669.0 |
| 2021-09-24 | FGBS | Futures | 112.629 | 112.644 | 112.619 | 112.639 | 291634.0 |
| 2021-09-24 | FGBX | Futures | 221.71 | 221.71 | 219.87 | 220.35 | 108819.0 |
| 2021-09-24 | FMWO | Futures | 10996.1 | 11029.1 | 10950.1 | 10979.6 | 3954.0 |
| 2021-09-24 | FOAT | Futures | 155.79 | 155.79 | 155.3 | 155.44 | 188990.0 |
| 2021-09-24 | FTDX | Futures | 4042.2 | 4051.9 | 3993.4 | 3997.0 | 80.0 |
| 2021-09-24 | FTI | Futures | 762.12 | 762.98 | 752.91 | 753.86 | 19291.0 |
| 2021-09-24 | FTUK | Futures | 6976.1 | 6982.5 | 6920.8 | 6934.1 | 77365.0 |
| 2021-09-24 | FVSA | Futures | 78.9 | 83.78 | 78.14 | 80.4 | 35927.0 |
| 2021-09-24 | FXXP | Futures | 443.3 | 444.2 | 439.2 | 439.9 | 41540.0 |
> showing 50 of 123 rows — these rows as CSV