PREVIEW / futures_daily / 2021-09-28
file: by_date/futures_daily/2021/2021-09-28.parquet size: 10 KB rows: 124
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-28 | ES | Futures | 4982.99 | 4996.77 | 4876.12 | 4885.97 | 2307037.0 |
| 2021-09-28 | NQ | Futures | 17495.81 | 17518.87 | 16998.23 | 17025.9 | 836785.0 |
| 2021-09-28 | YM | Futures | 37790.6 | 37920.1 | 37124.8 | 37183.5 | 277934.0 |
| 2021-09-28 | CL | Futures | 55.54 | 56.46 | 54.67 | 55.44 | 476143.0 |
| 2021-09-28 | GC | Futures | 2041.6 | 2046.7 | 2015.7 | 2027.1 | 215840.0 |
| 2021-09-28 | ZN | Futures | 133.987996 | 134.083339 | 133.447722 | 133.701969 | 2477404.0 |
| 2021-09-28 | A6 | Futures | 0.74711 | 0.74972 | 0.74096 | 0.74255 | 109508.0 |
| 2021-09-28 | AD | Futures | 0.80389 | 0.80603 | 0.79887 | 0.80064 | 93516.0 |
| 2021-09-28 | ALI | Futures | 3291.15 | 3351.42 | 3290.3 | 3344.38 | 198.0 |
| 2021-09-28 | B | Futures | 53.25 | 54.16 | 52.4 | 53.08 | 413144.0 |
| 2021-09-28 | B6 | Futures | 1.3913 | 1.3926 | 1.3726 | 1.3738 | 161102.0 |
| 2021-09-28 | BFX | Futures | 4242.2 | 4242.2 | 4209.0 | 4209.0 | 3.0 |
| 2021-09-28 | BR | Futures | 0.14898 | 0.14902 | 0.14735 | 0.14808 | 1978.0 |
| 2021-09-28 | BTC | Futures | 57460.0 | 57912.1 | 54707.7 | 55312.7 | 4666.0 |
| 2021-09-28 | BZ | Futures | 52.04 | 52.9 | 51.16 | 51.85 | 43597.0 |
| 2021-09-28 | C | Futures | 1527.0 | 1561.0 | 1525.0 | 1552.0 | 10887.0 |
| 2021-09-28 | CB | Futures | 139.869 | 139.869 | 139.869 | 139.869 | 4.0 |
| 2021-09-28 | CC | Futures | 1634.0 | 1659.0 | 1629.0 | 1641.0 | 17975.0 |
| 2021-09-28 | CNH | Futures | 6.2226 | 6.2283 | 6.2197 | 6.2268 | 159.0 |
| 2021-09-28 | CSC | Futures | 2.438 | 2.438 | 2.432 | 2.432 | 52.0 |
| 2021-09-28 | CT | Futures | 91.47 | 94.78 | 91.09 | 93.36 | 27696.0 |
| 2021-09-28 | DC | Futures | 22.32 | 22.44 | 22.29 | 22.4 | 184.0 |
| 2021-09-28 | DX | Futures | 90.25 | 90.651 | 90.206 | 90.612 | 36699.0 |
| 2021-09-28 | E1 | Futures | 1.21194 | 1.21228 | 1.20634 | 1.20645 | 23362.0 |
| 2021-09-28 | E6 | Futures | 1.24469 | 1.24527 | 1.24155 | 1.24251 | 187630.0 |
| 2021-09-28 | E7 | Futures | 1.2379 | 1.2384 | 1.2348 | 1.2358 | 5573.0 |
| 2021-09-28 | EBM | Futures | 371.44 | 378.05 | 370.7 | 373.27 | 37543.0 |
| 2021-09-28 | ED | Futures | 96.5441 | 96.5489 | 96.5441 | 96.5489 | 93750.0 |
| 2021-09-28 | ER | Futures | 98.475 | 98.475 | 98.47 | 98.47 | 42574.0 |
| 2021-09-28 | ESG | Futures | 408.4 | 408.94 | 402.54 | 403.21 | 603.0 |
| 2021-09-28 | EW | Futures | 2919.3 | 2929.6 | 2874.6 | 2877.9 | 14956.0 |
| 2021-09-28 | FBON | Futures | 149.07 | 149.18 | 148.65 | 148.9 | 1117.0 |
| 2021-09-28 | FBTP | Futures | 138.9 | 139.05 | 138.11 | 138.43 | 168417.0 |
| 2021-09-28 | FBTS | Futures | 110.361 | 110.371 | 110.283 | 110.312 | 73914.0 |
| 2021-09-28 | FCE | Futures | 6675.3 | 6684.8 | 6500.4 | 6518.4 | 89694.0 |
| 2021-09-28 | FDAX | Futures | 16641.9 | 16682.5 | 16253.9 | 16294.5 | 103787.0 |
| 2021-09-28 | FDIV | Futures | 184.9 | 185.2 | 182.65 | 182.65 | 50.0 |
| 2021-09-28 | FDXM | Futures | 16697.9 | 16730.0 | 16301.3 | 16340.9 | 86360.0 |
| 2021-09-28 | FDXS | Futures | 16524.8 | 16575.7 | 16148.8 | 16189.2 | 30899.0 |
| 2021-09-28 | FESX | Futures | 3970.8 | 3985.2 | 3859.8 | 3874.1 | 1012046.0 |
| 2021-09-28 | FGBL | Futures | 167.73 | 167.79 | 166.98 | 167.35 | 943322.0 |
| 2021-09-28 | FGBM | Futures | 134.7 | 134.71 | 134.48 | 134.6 | 568958.0 |
| 2021-09-28 | FGBS | Futures | 112.629 | 112.634 | 112.599 | 112.629 | 338888.0 |
| 2021-09-28 | FGBX | Futures | 220.61 | 220.82 | 218.9 | 220.15 | 88214.0 |
| 2021-09-28 | FMWO | Futures | 10992.6 | 11005.5 | 10739.0 | 10765.0 | 7346.0 |
| 2021-09-28 | FOAT | Futures | 155.33 | 155.36 | 154.49 | 154.85 | 226905.0 |
| 2021-09-28 | FTDX | Futures | 3906.7 | 3906.7 | 3821.5 | 3833.8 | 167.0 |
| 2021-09-28 | FTI | Futures | 753.34 | 754.62 | 734.81 | 736.97 | 30048.0 |
| 2021-09-28 | FTUK | Futures | 6943.5 | 6963.3 | 6889.7 | 6910.9 | 105302.0 |
| 2021-09-28 | FVSA | Futures | 78.9 | 90.54 | 78.33 | 89.23 | 39489.0 |
> showing 50 of 124 rows — these rows as CSV