PREVIEW / futures_daily / 2023-04-27
file: by_date/futures_daily/2023/2023-04-27.parquet size: 10 KB rows: 130
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 |
|---|---|---|---|---|---|---|---|
| 2023-04-27 | ES | Futures | 4470.44 | 4559.07 | 4465.25 | 4545.12 | 1686692.0 |
| 2023-04-27 | NQ | Futures | 14372.37 | 14780.32 | 14340.22 | 14667.52 | 728241.0 |
| 2023-04-27 | YM | Futures | 35837.5 | 36397.9 | 35812.8 | 36357.2 | 173751.0 |
| 2023-04-27 | CL | Futures | 64.85 | 65.63 | 64.54 | 65.18 | 345880.0 |
| 2023-04-27 | GC | Futures | 2218.9 | 2233.9 | 2199.2 | 2218.0 | 203898.0 |
| 2023-04-27 | ZN | Futures | 118.097335 | 118.225233 | 117.313963 | 117.393899 | 1522224.0 |
| 2023-04-27 | A6 | Futures | 0.67254 | 0.67574 | 0.67173 | 0.67529 | 64667.0 |
| 2023-04-27 | AD | Futures | 0.74356 | 0.74609 | 0.74305 | 0.74533 | 78731.0 |
| 2023-04-27 | ALI | Futures | 2550.54 | 2550.54 | 2515.03 | 2542.07 | 2127.0 |
| 2023-04-27 | B | Futures | 68.79 | 69.38 | 68.33 | 69.09 | 437402.0 |
| 2023-04-27 | B6 | Futures | 1.2538 | 1.2569 | 1.2504 | 1.2562 | 80401.0 |
| 2023-04-27 | BFX | Futures | 4100.3 | 4100.3 | 4100.3 | 4100.3 | 0.0 |
| 2023-04-27 | BR | Futures | 0.17817 | 0.18047 | 0.1779 | 0.18016 | 7968.0 |
| 2023-04-27 | BTC | Futures | 38671.7 | 40563.2 | 38254.4 | 40307.4 | 6966.0 |
| 2023-04-27 | BZ | Futures | 68.23 | 68.97 | 67.92 | 68.68 | 29292.0 |
| 2023-04-27 | C | Futures | 1725.0 | 1733.0 | 1714.0 | 1718.0 | 1825.0 |
| 2023-04-27 | CB | Futures | 234.913 | 236.381 | 234.913 | 236.283 | 27.0 |
| 2023-04-27 | CC | Futures | 1708.0 | 1718.0 | 1691.0 | 1697.0 | 18127.0 |
| 2023-04-27 | CNH | Futures | 6.6076 | 6.6144 | 6.5926 | 6.5975 | 286.0 |
| 2023-04-27 | CSC | Futures | 2.151 | 2.175 | 2.129 | 2.169 | 174.0 |
| 2023-04-27 | CT | Futures | 99.77 | 102.75 | 98.98 | 101.86 | 19240.0 |
| 2023-04-27 | DC | Futures | 20.11 | 20.52 | 19.98 | 20.43 | 462.0 |
| 2023-04-27 | DX | Futures | 98.876 | 99.267 | 98.651 | 98.966 | 11325.0 |
| 2023-04-27 | E1 | Futures | 1.20887 | 1.20968 | 1.19982 | 1.2047 | 26220.0 |
| 2023-04-27 | E6 | Futures | 1.1389 | 1.1408 | 1.13345 | 1.137 | 201475.0 |
| 2023-04-27 | E7 | Futures | 1.1388 | 1.1403 | 1.133 | 1.1365 | 6780.0 |
| 2023-04-27 | EBM | Futures | 357.39 | 357.76 | 352.21 | 353.69 | 11846.0 |
| 2023-04-27 | ER | Futures | 97.878 | 97.894 | 97.853 | 97.868 | 143135.0 |
| 2023-04-27 | ESG | Futures | 387.14 | 394.63 | 387.14 | 393.49 | 479.0 |
| 2023-04-27 | EW | Futures | 2605.2 | 2647.8 | 2601.1 | 2645.2 | 11977.0 |
| 2023-04-27 | FBON | Futures | 121.05 | 121.19 | 120.55 | 120.67 | 43.0 |
| 2023-04-27 | FBTP | Futures | 111.24 | 111.24 | 110.49 | 110.65 | 212491.0 |
| 2023-04-27 | FBTS | Futures | 106.229 | 106.239 | 106.027 | 106.067 | 107496.0 |
| 2023-04-27 | FCE | Futures | 8080.3 | 8171.9 | 8067.2 | 8120.1 | 45021.0 |
| 2023-04-27 | FDAX | Futures | 16940.3 | 17070.5 | 16881.7 | 16981.9 | 55945.0 |
| 2023-04-27 | FDIV | Futures | 186.9 | 186.9 | 186.58 | 186.58 | 97.0 |
| 2023-04-27 | FDXM | Futures | 17063.2 | 17211.6 | 17024.5 | 17126.7 | 35050.0 |
| 2023-04-27 | FDXS | Futures | 16972.1 | 17096.1 | 16910.2 | 17011.7 | 15623.0 |
| 2023-04-27 | FESX | Futures | 4380.3 | 4441.6 | 4378.2 | 4413.0 | 738030.0 |
| 2023-04-27 | FEU3 | Futures | 97.878 | 97.878 | 97.878 | 97.878 | 0.0 |
| 2023-04-27 | FGBL | Futures | 135.44 | 135.59 | 134.61 | 134.84 | 711536.0 |
| 2023-04-27 | FGBM | Futures | 119.5 | 119.55 | 119.0 | 119.12 | 640866.0 |
| 2023-04-27 | FGBS | Futures | 108.215 | 108.215 | 108.01 | 108.051 | 442689.0 |
| 2023-04-27 | FGBX | Futures | 139.92 | 140.29 | 138.45 | 138.9 | 58262.0 |
| 2023-04-27 | FMWO | Futures | 9760.6 | 9917.7 | 9757.2 | 9839.7 | 3375.0 |
| 2023-04-27 | FOAT | Futures | 126.28 | 126.46 | 125.53 | 125.72 | 171532.0 |
| 2023-04-27 | FSMX | Futures | 29169.1 | 29413.0 | 29088.9 | 29313.7 | 62.0 |
| 2023-04-27 | FTDX | Futures | 3489.8 | 3513.3 | 3481.8 | 3494.6 | 165.0 |
| 2023-04-27 | FTI | Futures | 786.98 | 798.79 | 786.93 | 794.2 | 12222.0 |
| 2023-04-27 | FTUK | Futures | 7983.6 | 8028.5 | 7966.8 | 7982.1 | 82946.0 |
> showing 50 of 130 rows — these rows as CSV