PREVIEW / futures_daily / 2021-08-24
file: by_date/futures_daily/2021/2021-08-24.parquet size: 10 KB rows: 121
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-08-24 | ES | Futures | 5036.97 | 5049.34 | 5032.2 | 5038.66 | 787503.0 |
| 2021-08-24 | NQ | Futures | 17682.56 | 17748.32 | 17662.37 | 17715.44 | 365577.0 |
| 2021-08-24 | YM | Futures | 38306.8 | 38388.2 | 38268.9 | 38291.7 | 94288.0 |
| 2021-08-24 | CL | Futures | 48.0 | 49.66 | 47.91 | 49.47 | 335888.0 |
| 2021-08-24 | GC | Futures | 2108.8 | 2114.2 | 2103.0 | 2109.9 | 114785.0 |
| 2021-08-24 | ZN | Futures | 135.828466 | 135.860094 | 135.54381 | 135.607067 | 1883385.0 |
| 2021-08-24 | A6 | Futures | 0.73972 | 0.74577 | 0.73854 | 0.74429 | 66010.0 |
| 2021-08-24 | AD | Futures | 0.80146 | 0.80597 | 0.8009 | 0.80496 | 70875.0 |
| 2021-08-24 | ALI | Futures | 2996.14 | 3031.77 | 2995.57 | 3008.4 | 79.0 |
| 2021-08-24 | B | Futures | 45.73 | 47.46 | 45.64 | 47.32 | 301295.0 |
| 2021-08-24 | B6 | Futures | 1.3933 | 1.396 | 1.3904 | 1.3942 | 73361.0 |
| 2021-08-24 | BFX | Futures | 4416.9 | 4418.9 | 4416.9 | 4418.9 | 2.0 |
| 2021-08-24 | BR | Futures | 0.1491 | 0.15234 | 0.14846 | 0.15226 | 14797.0 |
| 2021-08-24 | BTC | Futures | 66078.7 | 66511.5 | 63675.2 | 64294.4 | 2571.0 |
| 2021-08-24 | BZ | Futures | 44.64 | 46.35 | 44.54 | 46.19 | 38685.0 |
| 2021-08-24 | C | Futures | 1516.0 | 1526.0 | 1512.0 | 1519.0 | 1482.0 |
| 2021-08-24 | CC | Futures | 1639.0 | 1661.0 | 1635.0 | 1650.0 | 19004.0 |
| 2021-08-24 | CNH | Futures | 6.2556 | 6.2647 | 6.2465 | 6.2527 | 266.0 |
| 2021-08-24 | CSC | Futures | 2.519 | 2.534 | 2.511 | 2.515 | 69.0 |
| 2021-08-24 | CT | Futures | 87.29 | 88.67 | 86.09 | 88.56 | 10.0 |
| 2021-08-24 | DC | Futures | 22.76 | 23.14 | 22.66 | 22.67 | 381.0 |
| 2021-08-24 | DX | Futures | 89.907 | 89.98 | 89.714 | 89.797 | 13702.0 |
| 2021-08-24 | E1 | Futures | 1.23144 | 1.23313 | 1.22931 | 1.231 | 12752.0 |
| 2021-08-24 | E6 | Futures | 1.24994 | 1.2519 | 1.24791 | 1.25084 | 116765.0 |
| 2021-08-24 | E7 | Futures | 1.2437 | 1.2456 | 1.2417 | 1.2446 | 3370.0 |
| 2021-08-24 | EBM | Futures | 402.71 | 403.82 | 396.46 | 401.24 | 2002.0 |
| 2021-08-24 | ED | Futures | 96.5418 | 96.5418 | 96.5369 | 96.5393 | 54757.0 |
| 2021-08-24 | ER | Futures | 98.47 | 98.475 | 98.465 | 98.47 | 31645.0 |
| 2021-08-24 | ESG | Futures | 417.11 | 417.33 | 416.66 | 416.85 | 376.0 |
| 2021-08-24 | EW | Futures | 2903.2 | 2930.3 | 2900.5 | 2923.9 | 8045.0 |
| 2021-08-24 | FBON | Futures | 151.44 | 151.71 | 151.42 | 151.51 | 259.0 |
| 2021-08-24 | FBTP | Futures | 141.57 | 141.77 | 141.42 | 141.67 | 91169.0 |
| 2021-08-24 | FBTS | Futures | 110.516 | 110.536 | 110.497 | 110.526 | 28177.0 |
| 2021-08-24 | FCE | Futures | 6696.2 | 6711.6 | 6620.8 | 6651.2 | 40059.0 |
| 2021-08-24 | FDAX | Futures | 16993.0 | 17056.2 | 16975.8 | 17032.6 | 47115.0 |
| 2021-08-24 | FDIV | Futures | 188.38 | 188.43 | 188.38 | 188.43 | 4.0 |
| 2021-08-24 | FDXM | Futures | 16914.0 | 16970.5 | 16892.7 | 16948.1 | 34302.0 |
| 2021-08-24 | FDXS | Futures | 16814.0 | 16862.7 | 16784.3 | 16840.5 | 6717.0 |
| 2021-08-24 | FESX | Futures | 3963.1 | 3978.3 | 3943.2 | 3957.9 | 467487.0 |
| 2021-08-24 | FGBL | Futures | 171.39 | 171.54 | 171.13 | 171.29 | 518084.0 |
| 2021-08-24 | FGBM | Futures | 135.84 | 135.85 | 135.75 | 135.78 | 293382.0 |
| 2021-08-24 | FGBS | Futures | 112.754 | 112.769 | 112.744 | 112.749 | 163587.0 |
| 2021-08-24 | FGBX | Futures | 232.58 | 233.07 | 231.57 | 232.3 | 56734.0 |
| 2021-08-24 | FMWO | Futures | 11041.8 | 11044.1 | 10998.3 | 11027.7 | 2117.0 |
| 2021-08-24 | FOAT | Futures | 158.45 | 158.59 | 158.24 | 158.37 | 143170.0 |
| 2021-08-24 | FTDX | Futures | 4037.6 | 4045.8 | 4023.2 | 4025.8 | 83.0 |
| 2021-08-24 | FTI | Futures | 747.65 | 750.52 | 745.59 | 748.06 | 13732.0 |
| 2021-08-24 | FTUK | Futures | 6991.2 | 7002.5 | 6945.4 | 6983.3 | 73286.0 |
| 2021-08-24 | FVSA | Futures | 77.12 | 77.89 | 75.17 | 76.53 | 16542.0 |
| 2021-08-24 | FXXP | Futures | 450.0 | 450.7 | 446.9 | 448.6 | 28613.0 |
> showing 50 of 121 rows — these rows as CSV