PREVIEW / futures_daily / 2022-01-27
file: by_date/futures_daily/2022/2022-01-27.parquet size: 10 KB rows: 128
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-01-27 | ES | Futures | 4893.96 | 4980.41 | 4801.61 | 4862.99 | 2295458.0 |
| 2022-01-27 | NQ | Futures | 16361.64 | 16609.76 | 15958.77 | 16122.74 | 866647.0 |
| 2022-01-27 | YM | Futures | 37168.1 | 37808.4 | 36580.1 | 37137.5 | 329887.0 |
| 2022-01-27 | CL | Futures | 66.64 | 67.7 | 65.91 | 66.23 | 427804.0 |
| 2022-01-27 | GC | Futures | 2127.0 | 2129.8 | 2093.5 | 2096.2 | 206383.0 |
| 2022-01-27 | ZN | Futures | 130.17438 | 130.717439 | 130.110491 | 130.493826 | 2216921.0 |
| 2022-01-27 | A6 | Futures | 0.72922 | 0.72979 | 0.71975 | 0.71995 | 112968.0 |
| 2022-01-27 | AD | Futures | 0.8009 | 0.80181 | 0.79567 | 0.79588 | 92918.0 |
| 2022-01-27 | ALI | Futures | 3477.08 | 3484.57 | 3462.1 | 3477.91 | 44.0 |
| 2022-01-27 | B | Futures | 62.02 | 62.89 | 61.52 | 61.79 | 363407.0 |
| 2022-01-27 | B6 | Futures | 1.3646 | 1.365 | 1.3539 | 1.3554 | 136611.0 |
| 2022-01-27 | BR | Futures | 0.15146 | 0.15344 | 0.1508 | 0.15125 | 17238.0 |
| 2022-01-27 | BTC | Futures | 51159.4 | 52090.6 | 49647.1 | 49787.1 | 5969.0 |
| 2022-01-27 | BZ | Futures | 60.29 | 61.1 | 59.76 | 60.03 | 35350.0 |
| 2022-01-27 | C | Futures | 1352.0 | 1362.0 | 1342.0 | 1343.0 | 7401.0 |
| 2022-01-27 | CB | Futures | 183.918 | 191.78 | 183.918 | 185.908 | 29.0 |
| 2022-01-27 | CC | Futures | 1563.0 | 1571.0 | 1534.0 | 1542.0 | 21863.0 |
| 2022-01-27 | CNH | Futures | 6.0408 | 6.0763 | 6.0408 | 6.0714 | 1210.0 |
| 2022-01-27 | CSC | Futures | 2.526 | 2.601 | 2.519 | 2.582 | 133.0 |
| 2022-01-27 | CT | Futures | 118.42 | 118.63 | 117.38 | 118.13 | 10742.0 |
| 2022-01-27 | DC | Futures | 25.5 | 26.15 | 25.25 | 25.87 | 518.0 |
| 2022-01-27 | DX | Futures | 93.286 | 94.03 | 93.286 | 93.974 | 24195.0 |
| 2022-01-27 | E1 | Futures | 1.20915 | 1.20959 | 1.19642 | 1.19933 | 29186.0 |
| 2022-01-27 | E6 | Futures | 1.19227 | 1.19238 | 1.18051 | 1.18152 | 265912.0 |
| 2022-01-27 | E7 | Futures | 1.1856 | 1.1857 | 1.1739 | 1.1749 | 6878.0 |
| 2022-01-27 | EBM | Futures | 401.58 | 405.87 | 394.42 | 396.92 | 21496.0 |
| 2022-01-27 | ED | Futures | 96.3752 | 96.3752 | 96.3316 | 96.3461 | 269464.0 |
| 2022-01-27 | ER | Futures | 98.514 | 98.519 | 98.509 | 98.509 | 40888.0 |
| 2022-01-27 | ESG | Futures | 408.84 | 415.63 | 404.89 | 406.1 | 3747.0 |
| 2022-01-27 | EW | Futures | 2769.1 | 2818.7 | 2707.3 | 2720.6 | 15190.0 |
| 2022-01-27 | FBON | Futures | 146.37 | 147.16 | 146.35 | 146.98 | 133.0 |
| 2022-01-27 | FBTP | Futures | 133.43 | 134.62 | 133.15 | 134.32 | 196171.0 |
| 2022-01-27 | FBTS | Futures | 109.904 | 110.02 | 109.836 | 109.991 | 105613.0 |
| 2022-01-27 | FCE | Futures | 6849.1 | 7065.3 | 6844.6 | 7030.3 | 71372.0 |
| 2022-01-27 | FDAX | Futures | 16533.2 | 16714.6 | 16135.2 | 16609.4 | 106594.0 |
| 2022-01-27 | FDIV | Futures | 192.76 | 195.74 | 192.76 | 195.04 | 55.0 |
| 2022-01-27 | FDXM | Futures | 16597.3 | 16789.1 | 16205.0 | 16682.4 | 68663.0 |
| 2022-01-27 | FDXS | Futures | 16431.4 | 16635.4 | 16061.9 | 16530.7 | 38133.0 |
| 2022-01-27 | FESX | Futures | 3979.3 | 4034.5 | 3872.5 | 4002.8 | 1060755.0 |
| 2022-01-27 | FGBL | Futures | 165.42 | 166.05 | 165.32 | 165.79 | 788198.0 |
| 2022-01-27 | FGBM | Futures | 133.64 | 133.79 | 133.55 | 133.71 | 521530.0 |
| 2022-01-27 | FGBS | Futures | 112.649 | 112.684 | 112.624 | 112.664 | 331275.0 |
| 2022-01-27 | FGBX | Futures | 221.05 | 223.46 | 220.85 | 222.72 | 80623.0 |
| 2022-01-27 | FMWO | Futures | 10641.9 | 10765.0 | 10460.9 | 10679.8 | 6654.0 |
| 2022-01-27 | FOAT | Futures | 152.86 | 153.57 | 152.76 | 153.31 | 210978.0 |
| 2022-01-27 | FSMX | Futures | 34250.6 | 34889.5 | 34237.0 | 34785.7 | 1657.0 |
| 2022-01-27 | FTDX | Futures | 3433.5 | 3520.7 | 3431.9 | 3517.1 | 135.0 |
| 2022-01-27 | FTI | Futures | 708.03 | 731.28 | 707.3 | 726.3 | 26856.0 |
| 2022-01-27 | FTUK | Futures | 7314.1 | 7500.6 | 7228.5 | 7452.4 | 147931.0 |
| 2022-01-27 | FVSA | Futures | 79.17 | 86.4 | 74.88 | 77.69 | 55739.0 |
> showing 50 of 128 rows — these rows as CSV