PREVIEW / futures_daily / 2021-01-05
file: by_date/futures_daily/2021/2021-01-05.parquet size: 10 KB rows: 120
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-01-05 | ES | Futures | 4141.36 | 4180.59 | 4116.99 | 4167.42 | 1414022.0 |
| 2021-01-05 | NQ | Futures | 14628.53 | 14774.15 | 14546.92 | 14756.27 | 483173.0 |
| 2021-01-05 | YM | Futures | 32514.2 | 32822.0 | 32369.5 | 32705.4 | 188607.0 |
| 2021-01-05 | CL | Futures | 33.45 | 35.44 | 33.35 | 35.25 | 643191.0 |
| 2021-01-05 | GC | Futures | 2288.9 | 2301.8 | 2279.9 | 2298.7 | 201945.0 |
| 2021-01-05 | ZN | Futures | 137.413511 | 137.413511 | 137.040527 | 137.102691 | 1316963.0 |
| 2021-01-05 | A6 | Futures | 0.787 | 0.79833 | 0.78628 | 0.79772 | 130064.0 |
| 2021-01-05 | AD | Futures | 0.79247 | 0.80047 | 0.79191 | 0.79981 | 65416.0 |
| 2021-01-05 | ALI | Futures | 2385.23 | 2391.64 | 2383.77 | 2390.76 | 156.0 |
| 2021-01-05 | B | Futures | 32.18 | 34.04 | 32.02 | 33.85 | 455351.0 |
| 2021-01-05 | B6 | Futures | 1.3787 | 1.386 | 1.3769 | 1.3844 | 68850.0 |
| 2021-01-05 | BR | Futures | 0.14723 | 0.14829 | 0.14564 | 0.14805 | 198.0 |
| 2021-01-05 | BTC | Futures | 41168.3 | 45102.4 | 39341.1 | 44887.9 | 8153.0 |
| 2021-01-05 | BZ | Futures | 31.4 | 33.34 | 31.32 | 33.17 | 62791.0 |
| 2021-01-05 | C | Futures | 1469.0 | 1469.0 | 1432.0 | 1444.0 | 7969.0 |
| 2021-01-05 | CB | Futures | 155.498 | 155.498 | 153.191 | 155.037 | 26.0 |
| 2021-01-05 | CC | Futures | 1669.0 | 1671.0 | 1640.0 | 1652.0 | 17025.0 |
| 2021-01-05 | CNH | Futures | 6.3197 | 6.3255 | 6.2816 | 6.2989 | 1005.0 |
| 2021-01-05 | CSC | Futures | 3.134 | 3.246 | 3.134 | 3.246 | 33.0 |
| 2021-01-05 | CT | Futures | 76.3 | 77.99 | 76.3 | 77.63 | 20742.0 |
| 2021-01-05 | DC | Futures | 26.53 | 27.37 | 26.53 | 27.37 | 199.0 |
| 2021-01-05 | DX | Futures | 86.866 | 86.866 | 86.426 | 86.445 | 19176.0 |
| 2021-01-05 | E1 | Futures | 1.28267 | 1.28842 | 1.28244 | 1.28808 | 17924.0 |
| 2021-01-05 | E6 | Futures | 1.30987 | 1.31585 | 1.3096 | 1.31563 | 133366.0 |
| 2021-01-05 | E7 | Futures | 1.3035 | 1.3094 | 1.3031 | 1.3091 | 9075.0 |
| 2021-01-05 | EBM | Futures | 264.39 | 269.01 | 264.39 | 268.4 | 28949.0 |
| 2021-01-05 | ED | Futures | 96.5325 | 96.5325 | 96.5276 | 96.5276 | 63535.0 |
| 2021-01-05 | ER | Futures | 98.475 | 98.48 | 98.47 | 98.475 | 34554.0 |
| 2021-01-05 | ESG | Futures | 342.03 | 344.77 | 340.7 | 344.16 | 521.0 |
| 2021-01-05 | EW | Futures | 2429.9 | 2472.1 | 2413.1 | 2460.4 | 16684.0 |
| 2021-01-05 | FBON | Futures | 151.12 | 151.12 | 150.74 | 150.89 | 153.0 |
| 2021-01-05 | FBTP | Futures | 139.19 | 139.32 | 138.91 | 139.04 | 147904.0 |
| 2021-01-05 | FBTS | Futures | 110.078 | 110.088 | 110.029 | 110.039 | 43521.0 |
| 2021-01-05 | FCE | Futures | 5433.0 | 5445.7 | 5371.8 | 5406.3 | 63131.0 |
| 2021-01-05 | FDAX | Futures | 14592.1 | 14666.8 | 14447.2 | 14519.6 | 48792.0 |
| 2021-01-05 | FDIV | Futures | 163.49 | 163.49 | 161.72 | 161.72 | 212.0 |
| 2021-01-05 | FDXM | Futures | 14527.8 | 14625.6 | 14407.7 | 14478.9 | 54536.0 |
| 2021-01-05 | FESX | Futures | 3289.5 | 3310.9 | 3262.6 | 3279.3 | 750022.0 |
| 2021-01-05 | FGBL | Futures | 170.75 | 170.8 | 170.26 | 170.45 | 613781.0 |
| 2021-01-05 | FGBM | Futures | 135.35 | 135.36 | 135.21 | 135.27 | 271350.0 |
| 2021-01-05 | FGBS | Futures | 112.739 | 112.744 | 112.714 | 112.729 | 256810.0 |
| 2021-01-05 | FGBX | Futures | 237.51 | 237.6 | 235.63 | 236.34 | 80149.0 |
| 2021-01-05 | FMWO | Futures | 9435.1 | 9501.5 | 9379.5 | 9437.5 | 2601.0 |
| 2021-01-05 | FOAT | Futures | 159.31 | 159.35 | 158.82 | 159.0 | 186999.0 |
| 2021-01-05 | FTDX | Futures | 3345.4 | 3361.4 | 3340.7 | 3344.9 | 72.0 |
| 2021-01-05 | FTI | Futures | 589.63 | 594.72 | 586.6 | 591.56 | 21603.0 |
| 2021-01-05 | FTUK | Futures | 6275.6 | 6356.9 | 6228.4 | 6308.8 | 104123.0 |
| 2021-01-05 | FVSA | Futures | 180.82 | 188.74 | 172.13 | 181.95 | 27018.0 |
| 2021-01-05 | FXXP | Futures | 372.7 | 374.1 | 370.2 | 371.6 | 55341.0 |
| 2021-01-05 | G | Futures | 127.4 | 127.48 | 126.99 | 127.1 | 201184.0 |
> showing 50 of 120 rows — these rows as CSV