PREVIEW / futures_daily / 2021-09-09
file: by_date/futures_daily/2021/2021-09-09.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-09-09 | ES | Futures | 5070.7 | 5091.49 | 5042.03 | 5049.62 | 1696301.0 |
| 2021-09-09 | NQ | Futures | 18009.05 | 18084.91 | 17934.93 | 17949.93 | 531288.0 |
| 2021-09-09 | YM | Futures | 37960.9 | 38159.4 | 37708.3 | 37810.2 | 181905.0 |
| 2021-09-09 | CL | Futures | 50.8 | 51.19 | 49.48 | 49.91 | 556451.0 |
| 2021-09-09 | GC | Futures | 2089.4 | 2103.9 | 2082.6 | 2100.0 | 154126.0 |
| 2021-09-09 | ZN | Futures | 135.465805 | 135.878956 | 135.386353 | 135.767723 | 1408402.0 |
| 2021-09-09 | A6 | Futures | 0.75536 | 0.75828 | 0.75341 | 0.75598 | 125238.0 |
| 2021-09-09 | AD | Futures | 0.79887 | 0.80318 | 0.79659 | 0.80151 | 113914.0 |
| 2021-09-09 | ALI | Futures | 3256.39 | 3268.64 | 3236.43 | 3263.51 | 1583.0 |
| 2021-09-09 | B | Futures | 48.89 | 49.28 | 47.72 | 48.11 | 377808.0 |
| 2021-09-09 | B6 | Futures | 1.3987 | 1.4075 | 1.3965 | 1.4051 | 119284.0 |
| 2021-09-09 | BFX | Futures | 4290.2 | 4305.5 | 4290.2 | 4305.5 | 2.0 |
| 2021-09-09 | BR | Futures | 0.15084 | 0.15299 | 0.15007 | 0.15101 | 184.0 |
| 2021-09-09 | BTC | Futures | 61584.7 | 63202.5 | 60645.9 | 62110.7 | 4052.0 |
| 2021-09-09 | BZ | Futures | 47.64 | 48.02 | 46.51 | 46.87 | 35106.0 |
| 2021-09-09 | C | Futures | 1565.0 | 1578.0 | 1555.0 | 1559.0 | 804.0 |
| 2021-09-09 | CB | Futures | 142.272 | 142.43 | 142.272 | 142.43 | 8.0 |
| 2021-09-09 | CC | Futures | 1726.0 | 1731.0 | 1707.0 | 1716.0 | 18288.0 |
| 2021-09-09 | CNH | Futures | 6.2294 | 6.2331 | 6.2198 | 6.2219 | 1322.0 |
| 2021-09-09 | CT | Futures | 88.4 | 88.4 | 87.44 | 87.45 | 9.0 |
| 2021-09-09 | DC | Futures | 22.82 | 22.82 | 22.63 | 22.71 | 36.0 |
| 2021-09-09 | DX | Futures | 89.612 | 89.665 | 89.293 | 89.39 | 29162.0 |
| 2021-09-09 | E1 | Futures | 1.21819 | 1.22594 | 1.21763 | 1.22493 | 33558.0 |
| 2021-09-09 | E6 | Futures | 1.25717 | 1.25972 | 1.25573 | 1.25839 | 318034.0 |
| 2021-09-09 | E7 | Futures | 1.2509 | 1.2533 | 1.249 | 1.2521 | 4957.0 |
| 2021-09-09 | EBM | Futures | 353.44 | 353.8 | 349.03 | 351.97 | 47343.0 |
| 2021-09-09 | ED | Futures | 96.549 | 96.5538 | 96.549 | 96.549 | 163899.0 |
| 2021-09-09 | ER | Futures | 98.47 | 98.47 | 98.465 | 98.47 | 21557.0 |
| 2021-09-09 | ESG | Futures | 418.14 | 420.87 | 417.33 | 417.33 | 1217.0 |
| 2021-09-09 | EW | Futures | 2914.3 | 2938.0 | 2891.2 | 2912.4 | 17726.0 |
| 2021-09-09 | FBON | Futures | 149.93 | 150.83 | 149.8 | 150.74 | 610.0 |
| 2021-09-09 | FBTP | Futures | 139.51 | 140.75 | 139.42 | 140.63 | 180409.0 |
| 2021-09-09 | FBTS | Futures | 110.351 | 110.477 | 110.312 | 110.468 | 94906.0 |
| 2021-09-09 | FCE | Futures | 6618.3 | 6699.2 | 6593.3 | 6674.7 | 62230.0 |
| 2021-09-09 | FDAX | Futures | 16715.5 | 16810.9 | 16548.4 | 16739.1 | 84767.0 |
| 2021-09-09 | FDXM | Futures | 16647.5 | 16727.5 | 16467.4 | 16656.1 | 71312.0 |
| 2021-09-09 | FDXS | Futures | 16527.0 | 16620.2 | 16362.8 | 16550.3 | 20990.0 |
| 2021-09-09 | FESX | Futures | 3956.5 | 3976.4 | 3917.6 | 3958.9 | 1088439.0 |
| 2021-09-09 | FGBL | Futures | 169.15 | 169.93 | 169.06 | 169.73 | 763554.0 |
| 2021-09-09 | FGBM | Futures | 135.14 | 135.37 | 135.09 | 135.34 | 462180.0 |
| 2021-09-09 | FGBS | Futures | 112.649 | 112.694 | 112.639 | 112.689 | 322629.0 |
| 2021-09-09 | FGBX | Futures | 224.4 | 227.12 | 224.15 | 226.24 | 149091.0 |
| 2021-09-09 | FMWO | Futures | 11115.8 | 11158.1 | 11048.8 | 11122.9 | 22343.0 |
| 2021-09-09 | FOAT | Futures | 156.67 | 157.72 | 156.64 | 157.52 | 191556.0 |
| 2021-09-09 | FTDX | Futures | 4009.8 | 4051.4 | 4009.8 | 4037.6 | 313.0 |
| 2021-09-09 | FTI | Futures | 749.8 | 756.3 | 747.65 | 752.48 | 21102.0 |
| 2021-09-09 | FTUK | Futures | 6973.5 | 6973.5 | 6883.9 | 6915.9 | 165086.0 |
| 2021-09-09 | FVSA | Futures | 76.92 | 82.17 | 74.4 | 76.14 | 40245.0 |
| 2021-09-09 | FXXP | Futures | 444.0 | 446.9 | 441.4 | 445.1 | 59560.0 |
| 2021-09-09 | G | Futures | 123.17 | 123.32 | 122.88 | 123.24 | 251278.0 |
> showing 50 of 121 rows — these rows as CSV